Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Realty
Property view
Listing view 2
Listing view 3

334 Plainville Avenue, 
Farmington, CT 06085

$699,900


4

Beds


4

Baths


3,856

Sq Ft


Single Family

Active

Listed by

Jacek Mikolajczyk, (860) 874-6646

Berkshire Hathaway Ne Prop., (860) 677-4949

(860) 677-4949

Last updated:

May 20, 2026, 03:42 AM

MLS#

24174163

Source:

CT

About This Home

334 Plainville Avenue

Rare and versatile opportunity in the heart of Unionville! This unique property offers incredible potential with a main residence featuring three existing apartments, a large barn, multiple garages, and expansive flat land ideal for a variety of uses. A separate front building lot is included and was previously approved for construction of a single-family home. There is also potential for an additional building site toward the rear of the property, creating the possibility for up to three homes on one property, subject to approvals. Whether you are seeking a multigenerational living setup, investment opportunity, hobby property, or private family compound, this property provides exceptional flexibility and space. Car enthusiasts, contractors, collectors, or hobbyists will appreciate the oversized barn, large detached garage spaces, and abundant storage options. Outdoor living is equally impressive with a beautiful patio area featuring a natural gas grill hookup, perfect for entertaining, gatherings, and enjoying the peaceful setting. The level land provides room for expansion, recreation, gardens, or future improvements. Conveniently located near shopping, dining, schools, and major routes while offering privacy and endless possibilities. Opportunities like this are rarely available-bring your vision and create your dream estate, investment property, or family compound in desirable Unionville! Included Lot 9553 (R20 0.31 Acres ) This home offers full wheelchair access.

Home Facts

Single Family

4 Baths

4 Bedrooms

Built in 1937

Price Summary

699,900

$181 per Sq. Ft.

MLS #:

24174163

Last Updated:

May 20, 2026, 03:42 AM

Added:

12 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

4

Bathrooms

Total Bathrooms:

4

Full Bathrooms:

4

Interior

Living Area:

3,856 Sq. Ft.


Structure

Structure

Architectural Style:

Cape Cod

Building Area:

3,856 Sq. Ft.

Year Built:

1937


Lot

Lot Size (Sq. Ft):

62,290


Finances & Disclosures

Finances

Price:

$699,900

Price per Sq. Ft:

$181 per Sq. Ft.

Source:CT
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.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.