Date
Details
Price
Change
Source
6/19/2026
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.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/15
$3,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/15
Property Description
August 1st Move in 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
Full Property Details for 1657 Farmington Ave
General
- Rent: $3,000
- Status: Active
- Type: Single Family
- Source: SMARTMLS
- MLS ID: 24184737
- Updated: 6/19/2026
- Added to Site: 5 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: Hot Water, 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
Schools
Schools serving 1657 Farmington Ave
School District:Farmington School District
| Name | Grades | Distance |
|---|---|---|
Union School, Farmington, CT 173 School St., Farmington, CT 06085 | K-4 | 0.9 mi |
Irving A. Robbins Middle School 20 Wolf Pit Road, Farmington, CT 06032 | 7-8 | 4.5 mi |
Farmington High School 10 Monteith Drive, Farmington, CT 06032 | 9-12 | 0.4 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price History for 1657 Farmington Ave
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 2Total Baths
- 1,398Sq. Ft.
- Single Family
- Active
- Updated 8 days ago
- 4Beds
- 2Total Baths
- 1,488Sq. Ft.
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 2Total Baths
- 1,092Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 4 days ago
- 3Beds
- 4Total Baths
- 2,056Sq. Ft.
Listed by Teresa Dudzikowski (203) 233-3217
- Apartment
- Active
- Updated 6 hours ago
- 2Beds
- 1Total Bath
- 1,048Sq. Ft.
- Condo
- Active
- Updated 15 hours ago
- 2Beds
- 2Total Baths
- 1,057Sq. Ft.
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 2Total Baths
- 1,398Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Apartment
- Active
- Updated 11 hours ago
- 2Beds
- 1Total Bath
- 900Sq. Ft.
Listed by Kathy Dell'Aquila (860) 559-0825
- Apartment
- Active
- Updated 1 day ago
- 3Beds
- 1Total Bath
- 3,596Sq. Ft.
- Apartment
- Active
- Updated 6 days ago
- 3Beds
- 1Total Bath
- 1,100Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Townhouse
- Closed
- 3Beds
- 1Total Bath
- 2,230Sq. Ft.
Listed and Sold by Olivia Cabrera and Odalys Bekanich
1657 Farmington Avenue, Farmington, CT 06085 (MLS# 24184737) is a Single Family property with 4 bedrooms, 2 full bathrooms and 1 partial bathroom. 1657 Farmington Avenue is currently listed for rent at $3,000 and was received on June 19, 2026. 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.