Refine Search
Sort by
$299,000
2 Baths 24192818 MLS
Steeped in history and overlooking the picturesque Tariffville Green for more than a century, this charming antique Colonial offers a rare combination of character and exceptional versatility. Due to the property's unique zoning, the possibilities are endless-create a charming single-family home, convert it to a two-family residence by adding a kitchen to the main level, enjoy multi-generational living with an in-law suite, or take advantage of the property's commercial potential. The upper level is currently configured as a comfortable apartment featuring a spacious eat-in kitchen, two bedrooms, a full bath with tub and shower, and a partially finished walk-up attic offering additional space or future expansion possibilities. The main level offers three large, sun-filled rooms and a full bath with a step-in shower, providing flexible space for living, working, or a business opportunity. The basement includes laundry and ample storage, while outside you'll appreciate off-street parking for 5-6 vehicles-a valuable amenity in this desirable village setting. Just steps from the heart of Tariffville, you'll enjoy easy access to local restaurants, shops, parks, and community events. Whether you're searching for a distinctive home, an income-producing property, or a live/work opportunity, this one-of-a-kind property is ready for its next chapter.

38 Main St, Simsbury

$1,650,000
4 Beds 6 Baths 24135453 MLS
This stunning brick Colonial sits atop Hunting Ridge Drive on a sprawling two-acre level lot, offering panoramic views of the Farmington Valley and breathtaking sunsets. It is conveniently located just two miles from the International Skating Center. The back of the property features spectacular mountain views and access to a hiking trail. As you step into the two-story marble foyer, you'll be captivated by the craftsmanship and meticulous attention to detail throughout the home. The spacious chef's kitchen, spanning approximately 1,000 square feet, is a true showpiece. It boasts abundant cabinetry, ample lighting, a fireplace, a large island, and an informal dining area. The kitchen is fully equipped with two wall microwaves, two wall ovens, two dishwashers, three sinks, and two additional mini-fridges. Adjacent is a formal dining room featuring a tray ceiling and three large windows that frame the breathtaking views. The first-floor primary suite includes a Brazilian cherry wood office/library, while the second-floor primary suite includes its own private study or office space. Additional highlights of this exquisite home include seven fireplaces, 10-foot ceilings on the first floor, a circular driveway, a large Trex deck, a flat backyard, and a finished lower-level recreation room. Simsbury was recently ranked as one of the "Best Small Towns in Which to Live" by Money Magazine, with its many cultural events, top-rated school system, and preserved open spaces.

24 Hunting Ridge Dr, Simsbury

The data relating to real estate for sale on this website appears in part through the SMARTMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SMARTMLS through a licensing agreement. Listing information is from various brokers who participate in the SMARTMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed. Copyright 2026 SmartMLS, Inc.