Refine Search
Map
Sort by
$439,900
3 Beds ⋅ 2 Baths ⋅ 24186826 MLS
Welcome to your private lakeside retreat! Tucked away on a quiet, peaceful cul-de-sac, this classic brick ranch offers the ultimate vacation-at-home lifestyle with direct waterfront access to pristine Lake Garda. Boasting 1,424 square feet of single-level living on the main floor, the home features 3 comfortable bedrooms and full bath, as well as a spacious 2-car garage with an attached screened-in porch-the perfect spot for your morning coffee or mosquito-free summer evenings. The living space beautifully expands into the fully finished, walk-out lower level, adding an extra 432 square feet of finished living space. Complete with a cozy den anchored by a classic wood-burning fireplace, a dry bar, and a second full bathroom, this versatile setup is tailor-made for game days, winter nights, or winding down after a day on the water. Step out of the walk-out basement onto a spacious patio overlooking the peaceful lake, which seamlessly connects to a raised grilling deck. The low-maintenance, wooded lot means no weekend lawn-mowing chores-giving you more time to enjoy the water. From the patio, private stairs lead directly down to your own dock. Grab a book and relax, cast a line for some fishing, or launch your kayak or canoe for a tranquil sunset paddle. This home presents an incredible opportunity to customize a sturdy, brick waterfront property and build instant equity in a highly sought-after neighborhood! HIGHEST AND BEST IS THURSDAY, JULY 23 @ 10 AM

8 Washington Cir, Farmington
$299,900
2 Beds ⋅ 3 Baths ⋅ 24187366 MLS ⋅ Riverside BLDG.
Updated 2-bedroom, 2.5-bath end-unit townhouse with garage at Riverside in Unionville. This wonderful location is set on the Farmington River with direct access to the river and is convenient to shopping, dining, recreation and major routes. Only 1/2-mile to the Farmington Valley Greenway paved trail access. You will fall in love with this lovely community and setting. Inside you will find an open floor plan with large living/dining room with fireplace and private attached deck overlooking the woods. The eating space kitchen boasts beautiful cabinetry. There is also a half-bath on the main level. Upstairs are two spacious bedrooms including the primary bedroom with full bath and private balcony overlooking the woods. There is also a second bedroom with full bath and a convenient laundry area on the second floor. The large garage offers excellent storage space. This unit is move in ready. Recent updates include interior painting in 2026 and newer HVAC. Don't miss this special home and location!

277 New Britain Ave Unit 277, Farmington
$9,900,000
21 Beds ⋅ 40 Baths ⋅ 24120482 MLS
Once home to both Mike Tyson and 50 Cent, this extraordinary estate sits on more than 17 private acres in Farmington, Connecticut-a historic town just 10 miles west of Hartford and ideally positioned between Boston and New York City. Spanning an impressive 51,000 square feet, the residence embodies unmatched opulence, with over $3 million in recent renovations elevating it to a world-class standard. Inside, discover an indoor pool and spa, a lavish nightclub, recording studio, billiards room, casino room, multiple game rooms, a racquetball court, state of the art fitness center, grand foyer, elevator and seven kitchens serving 21 bedrooms and 40 bathrooms. There is a boardroom, library and offices. Outside, the grounds are equally captivating with a resort-style pool, grotto, waterfall, private bridge, 4 bedroom guesthouses, pool house, a pond with fountain, basketball and tennis courts and an 8 car garage. This is more than a home-it is a rare opportunity to own a legacy estate of iconic distinction.

50 Poplar Hill Dr, Farmington

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.