Recently Viewed Properties
See This Home
Save This Listing
Close

$3,000

  • Sold
  • Closed
  • Single Family
  • 4 Beds
  • 2 Full Baths
  • 1 Partial Bath
  • 1,608 Sq. Ft.
  • 1 Car Garage
See This Home
Save This Home
See This Home
Save This Home
Charming Cape Cod Rental by the River Enjoy the perfect blend of comfort and convenience in this fully furnished Cape Cod-style rental located near the tranquil river. This spacious home features an attached garage, ground-level laundry, and two full bathrooms-one with a soaking tub perfect for relaxing self-care routines. The property is thoughtfully equipped beyond the basics, with all furnishings and utilities included, making it truly move-in ready. Situated close to a variety of local amenities, you'll have everything you need just minutes away-from parks and shops to vibrant dining options. With so many nearby restaurants and eateries, you'll never run out of places to enjoy a great meal. Live by the calming water and experience all the best this location has to offer.

Full Property Details for 1657 Farmington Ave

General

  • Rent: $3,000
  • Status: Closed
  • Type: Single Family
  • Source: SMARTMLS
  • MLS ID: 24106414
  • Added to Site: 209 day(s) ago

Rental Information

  • Rental Type: Yearly Furnished
  • Lease Terms: Per Month

Interior

  • Number of Rooms: 7
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Appliances: Electric Cooktop, Electric Range, Microwave, Refrigerator, Dishwasher, Washer, Dryer

Rooms

Bathrooms

  • Total Bathrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1

Bedrooms

  • Total Bedrooms: 4
  • Primary Bedroom: Primary Bedroom, Upper
  • Bedroom 1: Bedroom, Upper
  • Bedroom 2: Bedroom, Upper
  • Bedroom 3: Bedroom, Upper

Other Rooms

  • Living Room: Living Room, Main
  • Dining Room: Dining Room, Main

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 1
  • Parking: Attached Garage

Location

  • County: Hartford
  • Neighborhood: Unionville
  • Driving Directions: Follow Farmington Ave through Farmington or Unionville and the property is 4 houses away from wood n tap

School Information

  • Elementary School: Union
  • Middle School: Robbins
  • Intermediate School: West Woods
  • High School: Farmington

Community

  • Community Name: Unionville

Heating & Cooling

  • Cooling Type: None
  • Heating Type: Radiant, Natural Gas
  • Heating Fuel: Natural Gas
  • Water Heater: Other, Domestic

Utilities

  • Sewer: Public Sewer Connected
  • Water: Public Water Connected

Structural Information

  • Architectural Style: Cape Cod
  • Construction Status: No/Resale
  • Basement Desc.: Full
  • Attic: Yes
  • Square Feet: 1,608
  • Above Ground: 1,608 Sq. Ft.
  • Year Built: 1951

Lot Features

  • Lot Size (Acres): 0.66
  • Zoning: R12
  • Lot Description: Cleared, Water View

Water Features

  • Water Front: Yes
  • Water View: Yes
  • Water Front Desc.: River

Financial Considerations

  • Tenant Pays: All Utilities, Credit Check, Electricity, Heat, Hot Water, Water

Disclosures and Reports

  • Property ID: 2201394

Listed by William Raveis Real Estate, Burgio Sousa Team at William Raveis Real Estate, Omar Montalvo
Sold by Berkshire Hathaway NE Prop., Lepore Eagan Team at Berkshire Hathaway Homeservices New England Properties, John Lepore and Berkshire Hathaway NE Prop., Lepore Eagan Team at Berkshire Hathaway Homeservices New England Properties, Mark Given

Listing agent

— 1657 Farmington Ave —

  • Omar Montalvo

    William Raveis Real Estate

Schools serving 1657 Farmington Ave

School District:Farmington School District
NameGradesDistance
Union School, Farmington, CT
173 School St., Farmington, CT 06085
K-40.9 mi
West Woods Upper Elementary School
50 Judson Lane, Farmington, CT 06032
5-62.8 mi
Irving A. Robbins Middle School
20 Wolf Pit Road, Farmington, CT 06032
7-84.5 mi
Farmington High School
10 Monteith Drive, Farmington, CT 06032
9-120.4 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price History for 1657 Farmington Ave

Date
Details
Price
Change
Source
8/01/2025
Sold
$3,000
—
MLS
6/23/2025
Listed
$3,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Listed by William Raveis Real Estate, Burgio Sousa Team at William Raveis Real Estate, Omar Montalvo
Sold by Berkshire Hathaway NE Prop., Lepore Eagan Team at Berkshire Hathaway Homeservices New England Properties, John Lepore and Berkshire Hathaway NE Prop., Lepore Eagan Team at Berkshire Hathaway Homeservices New England Properties, Mark Given

Just Listed near 1657 Farmington Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

122 Richard St, West Hartford, CT 06119 - Photo 1 Just Listed
$374,900
Open House

122 Richard St  West Hartford, CT 06119

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,672
    Sq. Ft.
Listed by Kate Gervais (860) 690-5467
30 Ravenwood Rd, West Hartford, CT 06107 - Photo 1 Just Listed
$539,900

30 Ravenwood Rd  West Hartford, CT 06107

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,746
    Sq. Ft.
Listed by Billy Stiles (860) 231-2600
2 Farm Hill Rd, West Hartford, CT 06107 - Photo 1 Just Listed
$589,000

2 Farm Hill Rd  West Hartford, CT 06107

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,249
    Sq. Ft.
Listed by Century 21 AllPoints Realty
115 Mountain Terrace Rd, West Hartford, CT 06107 - Photo 1 Just Listed
$785,000

115 Mountain Terrace Rd  West Hartford, CT 06107

  • Single Family
  • Active
  • Updated 2 days ago
  • 5
    Beds
  • 4
    Total Baths
  • 2,655
    Sq. Ft.
Listed by KW Legacy Partners

Price Reduced near 1657 Farmington Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

10 Ironwood Ln, West Hartford, CT 06117 - Photo 1 Price Reduced
-$30,090 (-5.47%)
$519,900
Open House

10 Ironwood Ln  West Hartford, CT 06117

  • Townhouse
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 3,868
    Sq. Ft.
Listed by Agnelli Real Estate
148 King Philip Dr, West Hartford, CT 06117 - Photo 1 Price Reduced
-$15,000 (-2.68%)
$544,900

148 King Philip Dr  West Hartford, CT 06117

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 3,123
    Sq. Ft.
Listed by William Raveis Real Estate
100 Austin St, New Britain, CT 06051 - Photo 1 Price Reduced
-$1,099 (-0.42%)
$262,500

100 Austin St  New Britain, CT 06051

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,314
    Sq. Ft.
Listed by William Raveis Real Estate
75 Clark St, New Britain, CT 06051 - Photo 1 Price Reduced
-$50,000 (-4.17%)
$1,150,000

75 Clark St  New Britain, CT 06051

  • Multi-Family
  • Active
  • Updated 2 days ago
  • 13
    Total Beds
Listed by Alpha Capital Realty, LLC

Recent Sales near 1657 Farmington Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1716 Farmington Ave, Farmington, CT 06085 - Photo 1 Sold
$2,800

1716 Farmington Ave  #2nd Floor  Farmington, CT 06085

  • Townhouse
  • Closed
  • Updated 8 days ago
  • 3
    Beds
  • 1
    Total Bath
  • 2,230
    Sq. Ft.
Listed and Sold by Olivia Cabrera and Odalys Bekanich
10 Tanglewood Rd, Farmington, CT 06032 - Photo 1 Sold
$3,200

10 Tanglewood Rd  Farmington, CT 06032

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,372
    Sq. Ft.
Listed and Sold by Tier 1 Real Estate
41 Crocus Ln, Avon, CT 06001 - Photo 1 Sold
$2,800

41 Crocus Ln  #41  Avon, CT 06001

  • Condo
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 1,350
    Sq. Ft.
Listed and Sold by Berkshire Hathaway NE Prop.
8 Sycamore Ln, Avon, CT 06001 - Photo 1 Sold
$2,700

8 Sycamore Ln  #8  Avon, CT 06001

  • Townhouse
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 1,433
    Sq. Ft.
Listed and Sold by Farmington Woods

1657 Farmington Avenue, Farmington, CT 06085 (MLS# 24106414) is a Single Family property that was sold at $3,000 on August 01, 2025. Want to learn more about 1657 Farmington Avenue? Do you have questions about finding other real estate for sale or rent in Unionville? You can browse all Unionville rentals or contact a Coldwell Banker agent to request more information.