Great investment opprtunity or owner occupant that wants immediate sweat equity. Classic Colonial offering a great floor plan with 4 bedrooms, 1.5 baths, hardwood floors, enclosed front porch, covered back deck. Security System. Electrical box has been updated to circuit breakers. Located close to Fulton Park with walking and biking trails, ponds, picnic areas, playground, basketball, ect.... Conveniently located between NYC and Boston with easy access to I-84. Subject to probate court approval. Property is being sold AS-IS WHERE-IS condition. Cash buyers only. Property will not qualify for financing. Original boiler does not work. Home is winterized and will not be unwinterized for inspections.

Listing Tools (detailViewNewGen)

Property Details of 390 Farmington Avenue, Overlook

Property Details

Interior Features

Utilities and Appliances

Community

Map Location

Listed by Anne Krings E-Pro of Pavlik Real Estate LLC

Listing Sold by YellowBrick Real Estate LLC

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.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Residential Properties Ltd. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.