Looking for that special home that offers the tranquility of a fully fenced in yard with tree swing, gazebo, concrete porch, brick wall and more? You found it. This home offers so much character that you'll want to come stay. Full basement is a blank canvas to do whatever you wish along with the full open attic area. Room for more bedrooms or office. Only your own imagination is the true limits. Enter in the back door and find the large kitchen to your left. Bosch dishwasher will always make sure you never get dish panned hands. The 4 burner twin oven gas range will ensure your Thanksgiving is on time and perfect. Step right and see the formal living room. Travel through the French doors to find your family room with ceiling fans. Come watch a game or entertain with your speaker wires already installed in the walls. Step into the large formal dining room and see the entire family, three generations deep, all enjoying Sunday dinner together. The street is blocked off for Eversource and the gas company installing new lines so go down Leffingwell Ave just past Concord St and just before Grace Ave- on the left is the private driveway. Proceed until you reach the garage and vinyl fence area. Please make sure latch on fence door is latched upon entering/leaving. Security system/cameras are watching so please schedule all showings- no walk ups please. BACK ON MARKET DUE TO BUYER'S FAMILY EMERGENCY TAKING THEM OUT OF THE U.S.

Listing Tools (detailViewNewGen)

Property Details of 460 Farmington Avenue

Property Details

Interior Features

Utilities and Appliances

Community

Map Location

Listed by Mike Robinson of Century 21 AllPoints Realty

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.