23 Main St, Unit 23R

778 Sq. Ft.
$28 / Sq. Ft.
778
Sq. Ft.
$28
per Sq. Ft.

Description

Nestled in the heart of historic Farmington, Connecticut, this exquisite first-floor apartment embodies a fusion of historic charm and modern sophistication. Recently remodeled in 2023, this pristine jewel box awaits its inaugural occupant, promising a pristine, untouched sanctuary. Every detail reflects a commitment to comfort and style, from the painted hardwood floors to the brand-new appliances that grace the sleek, cozy kitchen. The living area exudes a sense of warmth and elegance, ideal for...Nestled in the heart of historic Farmington, Connecticut, this exquisite first-floor apartment embodies a fusion of historic charm and modern sophistication. Recently remodeled in 2023, this pristine jewel box awaits its inaugural occupant, promising a pristine, untouched sanctuary. Every detail reflects a commitment to comfort and style, from the painted hardwood floors to the brand-new appliances that grace the sleek, cozy kitchen. The living area exudes a sense of warmth and elegance, ideal for both relaxation and entertainment. Step outside to a park-like setting, a verdant escape that surrounds the residence, offering tranquility and a sense of natural beauty just beyond your doorstep. Moreover, the convenience of covered garage parking for one car, a rare luxury in this historic setting. This haven marries the allure of historical Farmington with the allure of a brand-new, beautifully appointed space, offering an unrivaled opportunity to relish in the town's rich legacy while reveling in modern comfort and style. No pets or smoking.
  1. Listed by Jennifer Kamens • Berkshire Hathaway NE Prop.
    P: (860)-944-4585 C: (860)-944-4585 jenniferkamens@bhhsne.com
  2. Listed by Gary M Emerito • Berkshire Hathaway NE Prop.
    P: (860)-677-4949 C: (860)-716-7601 garyemerito@bhhsne.com

Property Details for 23 Main Street, Unit 23R

Basement Description
Partial
Direct Waterfront
No
Garages Number
1
Neighborhood
Farmington Village
Style
Colonial
Garage Parking Info
Covered Garage
Swimming Pool
No
LISTING UPDATED: 10/01/2024 08:30 AM

Property Details for 23 Main Street, Unit 23R

StatusClosed
MLS #24032251
Days on Market13
Pet PolicyNot Allowed
Rental Incentives-
Costs & Fees-
Available Date08/01/2026
Lease Term-
Furnished-
Property TypeRental
MLS TypeResidential Rental / Condominium Rental
Year Built1660
Lot Size-
CountyHartford County

Location

Listing Courtesy of Berkshire Hathaway NE Prop., Jennifer Kamens; Berkshire Hathaway NE Prop., Gary M Emerito
Add your commute

Building Information for 23 Main Street, Unit 23R

Building/Complex23 Main StFloor23Stories-Residences3Pet PolicyNot AllowedPet Policy DetailsNoYear Built1660Lot Size-

Property Information for 23 Main Street, Unit 23R

Summary
Property and Location
  • Complex Name: Gleason Village Association
  • Directions: Main St
  • Elementary School: Per Board of Ed
  • End Unit: Yes
  • High School: Farmington
  • Latitude: 41.724844
  • Longitude: -72.825485
  • Pets Allowed: No
  • Unit On Floor Number: 1
  • State: Connecticut
  • Subd Complex: Gleason Village Association
HOA and Fees
  • Association Fee Includes: Grounds Maintenance
  • HOA Fee Amount: 0
  • Home Owner's Assocation: Yes
  • Special Association Assessment: No
Interior and Exterior Features
Exterior Features
  • Waterfront Description: Not Applicable
Interior Features
  • Appliances Included: Oven/Range, Microwave, Refrigerator, Dishwasher, Washer, Dryer
  • Cooling System: None
  • Heat Type: Hot Air
  • Attic YN: No
  • Fireplaces Total: 0
  • Laundry Room Info: Main Level
  • Laundry Room Location: In Unit
  • Rooms Total: 4
Room 1
  • Room Entry Order: 1
  • Room Features: Remodeled,Hardwood Floor
  • Room Length: 16.6
  • Room Level: Main
  • Room Type: Primary Bedroom
  • Room Width: 14.3
Room 2
  • Room Entry Order: 2
  • Room Features: Remodeled,Hardwood Floor
  • Room Length: 14.1
  • Room Level: Main
  • Room Type: Living Room
  • Room Width: 9.9
Room 3
  • Room Entry Order: 3
  • Room Features: Remodeled,Hardwood Floor
  • Room Length: 12.6
  • Room Level: Main
  • Room Type: Office
  • Room Width: 8.8
Room 4
  • Room Entry Order: 4
  • Room Features: Remodeled
  • Room Level: Main
  • Room Type: Eat-In Kitchen
Property
Property and Assessments
  • Fuel Tank Location: In Basement
  • Levels In Unit: 2
  • New Construction Type: No/Resale
  • Smoking Allowed: No
  • Year Built: 1660
  • Year Built Source: Public Records
  • Sq Ft Description: First floor unit
Lot Information
  • Lot Description: Rear Lot, Level Lot, Professionally Landscaped
  • Parcel Number: 1978080
  • Sq Ft Est Heated Above Grade: 778.0
  • Sq Ft Total: 778.0
  • Zoning: R20
Utilities
  • Heat Fuel Type: Oil
  • Hot Water Description: Electric, Domestic
  • Sewage System: Public Sewer Connected
  • Water Source: Public Water Connected
Multi Family
Income and Expenses
  • Occupied By: Vacant
  • Total Number of Units: 3
Rental
Rental
  • Rental Duration: Yearly Unfurnished

Schools near 23 Main Street, Unit 23R

This home is within Farmington School District.
Rating
School
Type
Grades
Distance
Public - K to 4
Public - 5 to 6
Public - 7 to 8
Public - 9 to 12
Rating
School
Distance
Noah Wallace School
PublicK to 4

West Woods Upper Elementary School
Public5 to 6

Irving A. Robbins Middle School
Public7 to 8

Farmington High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the owner. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Berkshire Hathaway NE Prop., Jennifer Kamens; Berkshire Hathaway NE Prop., Gary M Emerito

Based on information from one of the following Multiple Listing Services: Darien MLS, Smart MLS and Greenwich Multiple Listing Service. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by Darien MLS, Smart MLS and Greenwich Multiple Listing Service is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.