This home's estimate is 36.9% lower than the average sale price ($196K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
787 N Colony Rd Unit 1-3, Meriden, CT 06450
About this home
Redfin Estimate
Earn from this home
List your home with Redfin
List your home for rent
Market trends in 06450, CT
Last updated October 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 787 N Colony Rd Unit 1-3
$149/sq ft
$119/sq ft
$123/sq ft
Tax history for 787 N Colony Rd Unit 1-3
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Zoning
C-3
Highway Commercial District
The purpose of these districts shall be to provide for a wide range of commercial uses in areas with good access, particularly along major arterials, and to accommodate uses that benefit from large numbers of motorists, that need larger parcels of land developed less intensively than would be appropriate in central or neighborhood businesses, and that may involve characteristics, such as trucking and noise, that are objectionable to residential areas and certain nonresidential areas. New residential development is excluded from these districts except by special exception. The C-3 District is intended to accommodate these same activities at a lower intensity in a more open environment.Include but are not limited to:
- Automotive sales
- Bank
- Laundromat
- General retail
- Restaurant
- Hotel / motel
- Office
- Library
- Museum / gallery
- Park & open space
Property details
Interior
- Bathroom Information
- # of Full Baths: 1
- Heating & Cooling
- Heating Type: Baseboard
- Room Information
- # of Rooms: 3
Exterior
- Exterior Information
- Physical Condition: Good
- Exterior Wall: Brick
- Roof Shape Type: Gable
- Property Information
- Living Sq. Ft: 570
- # of Units: 1
- # of Stories: 1
- Legal Description: 000411 - 000151 - 000001 - 000001 -3
- Lot Information
- # of Buildings: 1
- Municipality Name: MERIDEN
- State Use Description: CONDOMINIUM
Financial
- Assessor Information
- Assessment Year: 2023
Public facts
- Beds: 1
- Baths: 1.0
- Sq. Ft.: 570
- Stories: 1.0
- Lot Size: —
- Style: Condo/Co-op
- Year Built: 1987
- Year Renovated: —
- County: New Haven County
- APN: 2422391
About this building
Unit Information Not Available
There aren't any units for sale in this building.
Around this home
Schools
- K - 12
- Preschool & daycare
Public PreK-5 • Assigned • 1.1mi
Public 6-8 • Assigned • 0.5mi
Public 9-12 • Assigned • 1.8mi
Lifestyle
Provided by Walk Score and Local Logic
Sun exposure
In this area, properties receive around 9 hours in June and 4.4 hours in December, placing it below the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 06450
Home values near 787 N Colony Rd Unit 1-3
| Address | Redfin Estimate |
|---|---|
1 Beds | 1 Baths | 570 Sq. Ft. | $121,469 |
1 Beds | 1 Baths | 570 Sq. Ft. | $97,108 |
1 Beds | 1 Baths | 570 Sq. Ft. | $121,571 |
1 Beds | 1 Baths | 570 Sq. Ft. | $113,227 |
1 Beds | 1 Baths | 570 Sq. Ft. | $150,630 |
1 Beds | 1 Baths | 570 Sq. Ft. | $150,630 |
- Beds | 2 Baths | 2295 Sq. Ft. | $362,281 |
| Address | Redfin Estimate |
|---|---|
1 Beds | 1 Baths | 570 Sq. Ft. | $113,627 |
1 Beds | 1 Baths | 570 Sq. Ft. | $108,196 |
1 Beds | 1 Baths | 570 Sq. Ft. | $110,978 |
1 Beds | 1 Baths | 570 Sq. Ft. | $107,840 |
1 Beds | 1 Baths | 570 Sq. Ft. | $122,462 |
1 Beds | 1 Baths | 570 Sq. Ft. | $118,548 |
8 Beds | 3 Baths | 2960 Sq. Ft. | $448,292 |
| Address | Redfin Estimate |
|---|---|
1 Beds | 1 Baths | 570 Sq. Ft. | $139,275 |
1 Beds | 1 Baths | 570 Sq. Ft. | $124,816 |
1 Beds | 1 Baths | 570 Sq. Ft. | $124,651 |
1 Beds | 1 Baths | 570 Sq. Ft. | $121,401 |
1 Beds | 1 Baths | 570 Sq. Ft. | $115,780 |
1 Beds | 1 Baths | 570 Sq. Ft. | $125,501 |
4 Beds | 2 Baths | 2670 Sq. Ft. | $389,912 |
More real estate resources
- Neighborhoods
- Zip Codes
- Minor Civil Divisions
- Cities
- Popular Searches
| 06492 homes for sale | |||
| 06450 homes for sale | |||
| 06410 homes for sale | |||
| 06037 homes for sale | |||
| 06489 homes for sale |
| Guilford homes for sale | |||
| Wallingford homes for sale | |||
| Glastonbury homes for sale | |||
| Farmington homes for sale | |||
| Madison homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.






































United States
Canada