x
Showing 1 of 0
X
Save

788 Farmington Avenue 102
Farmington CT 06032 US

$675,000

Active Listing ID 24182278
bed icon
2 bed
bath icon
2.00 Bath (2 Full)
home icon
Condominium

$675,000

Active Listing ID 24182278
Save

788 Farmington Avenue 102 Welcome to The Pennington Farmington's premier luxury community, where this exclusive 'model unit' offers a lifestyle of sophisticated design and absolute convenience. Perfectly positioned in the heart of Historic Farmington, this turn-key residence blends superior architectural detail with the charm of the walkable historic village. Imagine mornings beginning with a short walk to Hartford Baking Company for fresh pastries and coffee. Afternoons are for leisure, whether you are playing 18 holes at the legendary Farmington Country Club right next door, exploring the Hill-Stead Museum's scenic trails, or walking along pictureque Main Street. As evening approaches, leave your car in the garage and stroll to premier dining at Fork and Fire or Naples Pizza. Minutes away is West Hartford Center, the Polo Grounds and major highways, making your night on the town or commute effortless. This former model unit boasts elevated details; 9' ceilings, crown molding, and hand-scraped hardwood floors. The living room gas fireplace is flanked by custom built-ins which is mirrored in the private den. The gourmet kitchen is a dream with premium GE Cafe appliances, custom Sanford and Hawley cabinetry, and heat-resistant Quartzite countertops. The unprecedented outdoor access truly sets this unit apart. It is one of the only residences with an additional glass sliding door opening directly to the community patio, with comfortable seating, fire pit, grill, and stairs leading to a grassy area below.

Collapse all

Property Features

  • Facts
  • Property Type: Residential
  • Property Sub-type: Condominium
  • Features
  • Full Bathrooms: 2
  • Cooling System: Central Air
  • Exterior Finish: Grill, Underground Utilities, Sidewalk, Lighting, Covered Deck, Underground Sprinkler, Patio
  • Additional Features
  • Fireplace
  • Patio

School Information

  • School
  • Noah Wallace(Elementary)
  • Farmington(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Condominium
  • listprice: 675000
  • unparsedaddress: 788 Farmington Avenue
  • unitnumber: 102
  • postalcity: Farmington
  • stateorprovince: CT
  • country: US
  • postalcode: 06032
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeunits: Acres
  • livingarea: 1572
  • livingareaunits: Square Feet
  • latitude: 41.72675
  • longitude: -72.823144
  • listagentfullname: Diane Barry
  • listagentemail: dbarry@wpsir.com
  • listagentkey: 3yd-CTMLS-BARRYD
  • listagentmlsid: BARRYD
  • listagentpreferredphone: 8606141569
  • listagentofficephone: 8607771800
  • listofficekey: 3yd-CTMLS-PSOTH00
  • listofficemlsid: PSOTH00
  • disclaimer: Copyright © 2026 SmartMLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: CTMLS
  • yearbuilt: 2017
  • listingcontractdate: 2026-06-22
  • listagenturl: http://www.williampitt.com
  • countyorparish: Hartford
  • elementaryschool: Noah Wallace
  • highschool: Farmington
  • appliances: Gas Range, Microwave, Range Hood, Refrigerator, Dishwasher, Disposal, Washer, Dryer
  • cooling: Central Air
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 1
  • parkingtotal: 2
  • waterfrontyn: False
  • franchiseaffiliation: Sotheby's International Realty
  • interiorfeatures: Auto Garage Door Opener, Cable - Pre-wired, Elevator, Intercom, Open Floor Plan, Security System
  • exteriorfeatures: Grill, Underground Utilities, Sidewalk, Lighting, Covered Deck, Underground Sprinkler, Patio
  • architecturalstyle: Ranch, Other
  • rooms: Bedroom 1, Bathroom 2, Bedroom 2, Bathroom 1
  • securityfeatures: Security System
  • patioandporchfeatures: Patio
  • accessibilityfeatures: Accessible Elevator Installed
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -72.82314, 41.72675
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"William Pitt Sotheby's International Realty", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"dbarry@wpsir.com", "ListBrokerageCity":"Stamford", "ListBrokerageCountry":"US", "ListBrokerageEmail":"pbreunich@wpsir.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"William Pitt Sotheby's International Realty", "ListBrokeragePhone":null, "ListBrokeragePostalCode":"06902", "ListBrokerageStateOrProvince":"CT", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"170 Washington Blvd", "ListBrokerageWebsiteUrl":"http://www.williampitt.com", "ListOfficeAddress1":"45 E Main Street ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"PSOTH00", "ListOfficeCity":"Avon", "ListOfficeCountry":"US", "ListOfficeEmail":"aohlandt@williampitt.com", "ListOfficePostalCode":"06001", "ListOfficeStateOrProvince":"CT", "ListPriceCurrencyType":"USD", "ListingTitle":"CONDOS - Farmington, CT", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/788-Farmington-Ave-Apt-102_Farmington_CT_06032_M30977-33682?f=listhub&s=CTMLS&m=24182278&c=rexren", "MLSModificationTimestamp":"2026-06-25 04:05:03", "Neighborhoods":[{"Description":null, "Name":"Farmington Village"}], "PostalCode":null, "RoomCount":5, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":9481, "TaxDescription":null, "TaxYear":"2026"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 6/25/2026 5:10:37 AM GMT
Source Updated Date: 6/26/2026 6:41:16 PM GMT

Courtesy of: Diane Barry, William Pitt Sotheby's Int'l, dbarry@wpsir.com

Copyright © 2026 SmartMLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.