![[Address not provided], Stamford, CT 06902 - Photo 2](https://m1.cbhomes.com/p/229/24207200/36073b96c8Ca47C/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 3](https://m.cbhomes.com/p/229/24207200/3bc8680479494aa/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 4](https://m1.cbhomes.com/p/229/24207200/Ac9336C8F65F4B4/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 5](https://m.cbhomes.com/p/229/24207200/Bda47DB82D4347E/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 6](https://m1.cbhomes.com/p/229/24207200/9C7FfdB1fEcD4ed/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 7](https://m.cbhomes.com/p/229/24207200/8c813F1D3759427/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 8](https://m1.cbhomes.com/p/229/24207200/B2C77dac593f42B/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 9](https://m.cbhomes.com/p/229/24207200/F9506807494D423/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 10](https://m1.cbhomes.com/p/229/24207200/62DA50Ecb3Fc431/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 11](https://m.cbhomes.com/p/229/24207200/7649850FcDc1415/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 12](https://m1.cbhomes.com/p/229/24207200/7ea00A33F1Eb402/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 13](https://m.cbhomes.com/p/229/24207200/0ac54FeC993B490/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 14](https://m1.cbhomes.com/p/229/24207200/dD76Ed4fB5864B7/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 15](https://m.cbhomes.com/p/229/24207200/58D4feD717204e2/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 16](https://m1.cbhomes.com/p/229/24207200/fb9cab5457514aa/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 17](https://m.cbhomes.com/p/229/24207200/66afED953604442/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 18](https://m1.cbhomes.com/p/229/24207200/e275949d63eF490/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 19](https://m.cbhomes.com/p/229/24207200/03286Cc23eA84C4/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 20](https://m1.cbhomes.com/p/229/24207200/375e5E86D62243F/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 21](https://m.cbhomes.com/p/229/24207200/C693B103DE05425/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 22](https://m1.cbhomes.com/p/229/24207200/7119656765084db/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 23](https://m.cbhomes.com/p/229/24207200/d71d62a5627e45E/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 24](https://m1.cbhomes.com/p/229/24207200/79Be0b806f274Af/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 25](https://m.cbhomes.com/p/229/24207200/8E969Bf5F4E84db/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 26](https://m1.cbhomes.com/p/229/24207200/dC4E821287c54E9/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 27](https://m.cbhomes.com/p/229/24207200/a20a3bbbc03344B/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 28](https://m1.cbhomes.com/p/229/24207200/740F733f2FaF423/pds23tp.webp)
![[Address not provided], Stamford, CT 06902 - Photo 29](https://m.cbhomes.com/p/229/24207200/D36CF45EeB7945f/pds23tp.webp)
Date
Details
Price
Change
Source
10/05/2026
Listed
$1,045,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
![[Address not provided], Stamford, CT 06902 - Photo 1](https://m1.cbhomes.com/p/229/24207200/073d6a6d47554a4/pds23tp.webp)
1/29
$1,045,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
![[Address not provided], Stamford, CT 06902 - Photo 1](https://m.cbhomes.com/p/229/24207200/073d6a6d47554a4/pds23tp.webp)
1/29
Property Description
Rare riverfront 4-family compound on an oversized 0.20-acre lot along the scenic Mill River corridor, directly across from Scalzi Park! This grandfathered R-5 zoned gem is an exceptional find for Savvy Investors and House-Hackers seeking an income-producing property or Lifestyle Visionaries escaping the concrete blocks of NYC. Every unit features a highly rentable 1 loft-style BR (converted from 2 beds), FR, Kitchen & 1-bath. Two units on one wing are occupied by the owner - will deliver vacant at closing. An ultimate setup could be to live in one wing while letting the remaining 2 units pay your mortgage. The building stands 120 ft back from the watercourse, completely clearing Stamford's strict 100-ft regulated wetland buffer for hassle-free updates. Massive CapEx protections are already done: New gas meters (2024), 3 tankless water heaters (2015), updated electric panels (2012), 30 double-pane windows (2011). The level lot professionally curated & landscaped for over 25 years that is framed by mature plantings creates a profound sense of privacy and offers a tranquil backyard retreat sanctuary with guaranteed, permanent views. Located a short 0.5 to 1.5-mile stroll from downtown dining, the library, and the Stamford Train Station (~50 mins to NYC), this address perfectly serves the region's growing commuter and vibrant artist community seeking a peaceful, biophilic live-work atelier. Bring your vision to this premier riverside asset! Details on: MillRiverBrickBuilding.com
Full Property Details
Full Property Details for MLS# 24207200
General
- Price: $1,045,000
- Taxes: (July 2025-June 2026)
- Status: Active
- Type: Multi-Family
- Source: SMARTMLS
- MLS ID: 24207200
- Updated: Today (10/5/2026)
- Added to Site: Today
Interior
- Number of Rooms: 12
Rooms
Bathrooms
- Total Bathrooms: 4
- Full Bathrooms: 4
Bedrooms
- Total Bedrooms: 4
Other Rooms
- Laundry: Common Laundry Area
Exterior
- Exterior Features: Awnings, Porch, Gutters, Garden Area, Lighting
Location
- County: Fairfield
- Neighborhood: Mid City
- Driving Directions: Use GPS
School Information
- Elementary School: Hart Magnet
- Middle School: Cloonan
- High School: Westhill
Community
- Community Name: Mid City
Heating & Cooling
- Cooling Type: Window Unit
- Heating Type: Gas on Gas
- Water Heater: Natural Gas, Tankless Hotwater
Utilities
- Sewer: Public Sewer Connected
- Water: Public Water Connected
Structural Information
- Architectural Style: Units on different Floors, Units are Side-by-Side
- Construction Status: No/Resale
- Exterior Const.: Brick
- Basement Desc.: Full, Unfinished, Shared Basement, Hatchway Access, Concrete Floor, Full With Hatchway
- Roof: Flat
- Attic: Yes
- Disability Access: Multiple Entries/Exits
- Square Feet: 3,430
- Above Ground: 3,430 Sq. Ft.
- Year Built: 1892
Unit Information
Unit 1
- Square Feet: 857
- Total Bathrooms: 1
- Bedrooms: 1
Unit 2
- Square Feet: 857
- Total Bathrooms: 1
- Bedrooms: 1
Unit 3
- Square Feet: 857
- Total Bathrooms: 1
- Bedrooms: 1
Unit 4
- Square Feet: 857
- Total Bathrooms: 1
- Bedrooms: 3
Lot Features
- Lot Size (Acres): 0.23
- Zoning: R5
- Lot Description: Some Wetlands, Level Lot, On Cul-De-Sac, Water View
Water Features
- Water Front: Yes
- Water View: Yes
- Water Front Desc.: River, Walk to Water, View, Access
Financial Considerations
- Assessment Amount: $577,940
- Tax Year: July 2025-June 2026
Disclosures and Reports
- Exclusions: see included/excluded for each apartment
- Property ID: 317022
Listed by William Raveis Real Estate, Ileana Barns-Slavin
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— MLS# 24207200 —
Ileana Barns-Slavin
William Raveis Real Estate
Agent Contact: (203) 246-7215 Office Contact: (203) 966-3555
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving MLS# 24207200
School District:Stamford School District
| Name | Grades | Distance |
|---|---|---|
Hart School 61 Adams Avenue, Stamford, CT 06902 | K-5 | 0.3 mi |
Cloonan School 11 West North Street, Stamford, CT 06902 | 6-8 | 0.2 mi |
Westhill High School, Stamford, CT 125 Roxbury Road, Stamford, CT 06902 | 9-12 | 2.3 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for MLS# 24207200
Estimate the Cost
Estimate the Cost for MLS# 24207200
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 3 days ago
- 6Beds
- 7Total Baths
- 4,007Sq. Ft.
Listed by Houlihan Lawrence
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 2Total Baths
- 2,091Sq. Ft.
Listed by Mark Pires (203) 247-2655
- Single Family
- Active
- Updated 2 hours ago
- 4Beds
- 3Total Baths
- 2,456Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 23 hours ago
- 5Beds
- 7Total Baths
- 6,069Sq. Ft.
Listed by Corcoran Centric Realty LLC
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 3Total Baths
- 3,207Sq. Ft.
- Single Family
- Active
- Updated 2 days ago
- 5Beds
- 7Total Baths
- 9,493Sq. Ft.
- Single Family
- Active
- Updated 3 days ago
- 3Beds
- 4Total Baths
- 3,200Sq. Ft.
Listed by The Rosato Team (203) 622-4000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Closed
- 2Beds
- 3Total Baths
- 1,677Sq. Ft.
Listed and Sold by Sharon Giglio Real Estate LLC
MLS# 24207200, Stamford, CT 06902 (MLS# 24207200) is a Multi-Family property with 4 units containing 4 bedrooms and 4 full bathrooms. MLS# 24207200 is currently listed for $1,045,000 and was received on October 05, 2026. Want to learn more about MLS# 24207200? Do you have questions about finding other Multi-Family real estate for sale in Stamford? You can browse all Stamford real estate or contact a Coldwell Banker agent to request more information.