Save
Ask
Tour
Hide
$799,000
New Listing
29 Water StreetGuilford, CT 06437
For Sale|Duplex|Active
4
Beds
2
Total Baths
2
Full Baths
2,288
SqFt
$349
/SqFt
2001
Built
County:
New Haven
Listing courtesy of Jorge Zea of Blue Lighthouse Realty, Inc 8555500528 [email protected]
Call Now: (203) 281-3400
Is this the listing for you? We can help make it yours.
(203) 281-3400



Save
Ask
Tour
Hide
LOCATION! LOCATION! LOCATION! Welcome to this beautifully fully remodeled two-family home just steps from the historic Guilford Green. Both units showcase modern finishes featuring new kitchens and bathrooms. The dwelling has also recently been improved with new electrical, plumbing, flooring, fixtures, paint, and septic system. This move-in ready home can offer easy cash flow and is also ideal for owner- occupants looking to live on the Guilford Green and experience all this location has to offer. Don't miss this exceptional opportunity to own a turnkey investment or multi- generational home in pristine condition!
Save
Ask
Tour
Hide
Listing Snapshot
Price
$799,000
Days On Site
0 Days
Bedrooms
4
Inside Area (SqFt)
2,288 sqft
Total Baths
2
Full Baths
2
Partial Baths
N/A
Lot Size
0.18 Acres
Year Built
2001
MLS® Number
24143369
Status
Active
Property Tax
$11,474
HOA/Condo/Coop Fees
N/A
Sq Ft Source
N/A
Friends & Family
Recent Activity
| 16 hours ago | Listing updated with changes from the MLS® | |
| 16 hours ago | Listing first seen on site |
General Features
Acres
0.18
Foundation
BlockConcrete Perimeter
Parking
None
Property Sub Type
Duplex
Sewer
Septic Tank
SqFt Total
2288
Style
Units on different Floors
Water Source
Public
Zoning
GGB
Interior Features
Basement
FullCrawl Space
Heating
OilBaseboard
Laundry Features
Common Area
Save
Ask
Tour
Hide
Exterior Features
Construction Details
StuccoFrameClapboard
Lot Features
Level
Roof
Asphalt
Schools
School District
Unknown
Elementary School
Per Board of Ed
Middle School
Unknown
High School
Per Board of Ed
Listing courtesy of Jorge Zea of Blue Lighthouse Realty, Inc 8555500528 [email protected]
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 2025 SmartMLS, Inc.
Last checked: 2025-12-05 05:55 AM UTC.
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 2025 SmartMLS, Inc.
Last checked: 2025-12-05 05:55 AM UTC.
Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.