$1,200,000
UNDER CONTRACT

Estimated payment $7,554/month

Total Views 9,628
4 Beds
4.5 Baths
4,075 Sq Ft
$294 Price per Sq Ft

Highlights

  • Deck
  • 5-minute walk to Glenbrook Station
  • Balcony
  • Property is near public transit and shops
  • 2 Fireplaces
  • 4-minute walk to Hope Street Island Park

About This Home

This is the multifamily property investors, owner-occupants, and business owners have been waiting for. Measuring over 4,000 square feet and being delivered without residents, this fully remodeled, move-in ready property offers an extraordinary combination of flexibility, income potential, lifestyle, and functionality rarely found in Glenbrook. Whether you're searching for a true cash-flowing investment property, a house-hacking opportunity, a multigenerational setup, or the ideal live/work environment, the possibilities here are endless. The property features three separate living spaces, an attached oversized heated two-car garage with oversized bay doors and high ceilings, a private office with half bathroom, a carport, and parking for approximately eight vehicles on a level lot. The centerpiece of the property is the stunning duplex owner's unit - a beautifully renovated 3-bedroom, 2-full-bath residence designed for both everyday living and entertaining. Flooded with natural light, the open-concept layout centers around a tremendous great room featuring a wood-burning stove and double sets of French doors leading to your own private deck. A second private balcony further extends the living space outdoors. The chef's kitchen offers stainless steel appliances, a gas cooktop, abundant counter space, and a large center island with seating, all opening seamlessly into the dining area.

Listing Agent

Michael A Tarallo

Giner Real Estate Brokerage Phone: (917) 374-0026 License #RES.0814389 Listed on: 05/09/2026

Property Details

Home Type

  • Multi-Family

Est. Annual Taxes

  • $12,867

Year Built

  • Built in 1925

Lot Details

  • 7,841 Sq Ft Lot
  • Level Lot

Home Design

  • Concrete Foundation
  • Stone Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Vinyl Siding

Interior Spaces

  • 2 Fireplaces

Bedrooms and Bathrooms

  • 4 Bedrooms

Finished Basement

  • Heated Basement
  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Home Security

  • Smart Locks
  • Smart Thermostat

Parking

  • 3 Car Garage
  • Parking Deck
  • Driveway

Outdoor Features

  • Balcony
  • Deck
  • Porch

Location

  • Property is near public transit and shops

Schools

  • Julia A. Stark Elementary School
  • Dolan Middle School
  • Stamford High School

Utilities

  • Zoned Heating and Cooling
  • Heating System Uses Natural Gas
  • Programmable Thermostat
  • Electric Water Heater

Community Details

  • 3 Units
  • Public Transportation

Listing and Financial Details

  • Assessor Parcel Number 328024

Property Details

Home Type

Multi-Family

Est. Annual Taxes

$12,867

Year Built

Built in 1925

Lot Details

7,841 Sq Ft Lot

Listing Details

  • Neighborhood: Glenbrook
  • Property Type: Multi-Family For Sale
  • Style: Units on different Floors
  • Sq Ft Est Heated Above Grade: 3510
  • Sq Ft Est Heated Below Grade: 565
  • Total Sq Ft: 4075
  • Year Built: 1925
  • New Construction: No/Resale
  • Nearby Amenities: Library, Medical Facilities, Park, Public Transportation, Shopping/Mall
  • Remarks Public Addendum: Three nicely proportioned bedrooms, two full bathrooms, in-unit laundry, and an additional open flex space ideal for a home office, reading nook, or sitting area complete the unit. The main floor 1-bedroom, 1-bath unit has been completely renovated top to bottom and has never been lived in since completion. Featuring a brand-new kitchen with quartz countertops, brand-new stainless appliances, new fixtures, updated bathroom, fireplace, and in-unit laundry, the space offers immediate rental or occupancy potential without lifting a finger. The lower-level studio-style living space adds yet another layer of flexibility and opportunity. Completely renovated, the space features a large open main room, excellent closet storage, full bathroom, wet bar with brand-new cabinetry, refrigerator, microwave, quartz countertops, and an additional laundry setup. For business owners, contractors, hobbyists, or entrepreneurs, the attached heated oversized two-car garage with its own office and half bath creates an exceptional work-from-home or operational setup rarely available in residential properties. From maximizing rental income across multiple living spaces, to living comfortably while offsetting expenses, to creating the ultimate live/work property, this is the type of opportunity that rarely becomes available. Welcome home!
  • Property Sub Type: 2 Family
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: No
  • Radon Mitigation Water Ynu: No
  • Directions: Center Street between Church Street and Scofield Avenue
  • Street Type: Street
  • Office Attribution Contact: (914) 263-0345
  • Reserve Prospect: No
  • Special Features: UnderContract

Interior Features

  • Total Bedrooms: 4
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Fireplaces: 2
  • Basement Description: Full, Heated, Fully Finished, Full With Walk-Out
  • Laundry Room Location: Each unit has its own laundry.
  • Laundry Room Info: All Units Have Hook-Ups, Washer/Dryer All Units
  • Attic: No
  • Home Automation: Lock(s), Thermostat(s)

Exterior Features

  • Exterior Features: Balcony, Porch, Deck
  • Exterior Siding: Vinyl Siding
  • Foundation Type: Concrete, Stone
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Not Applicable
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 3
  • Driveway Type: Paved
  • Total Parking Spaces: 9
  • Garage And Parking: Carport, Attached Garage, Parking Lot, Off Street Parking, Driveway

Utilities

  • Cooling System: Central Air, Zoned
  • Heat Type: Hot Air
  • Heat Fuel Type: Natural Gas
  • Hot Water Description: Natural Gas, Electric, Upright Tank
  • Water Source: Public Water Connected
  • Sewer: Public Sewer Connected

Schools

  • Intermediate School: Per Board of Ed

Green Features

  • Energy Features: Programmable Thermostat

Lot Info

  • Acres: 0.18
  • Lot Description: Level Lot
  • Flood Zone: No
  • Zoning: R6
  • Parcel #: 328024

Multi Family

  • Total Number Of Units: 3

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 12867

MLS Schools

  • Elementary School: Julia A. Stark
  • Middle Jr High School: Dolan
  • High School: Stamford

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $12,867 $543,820 $206,340 $337,480
2024 $12,584 $543,820 $206,340 $337,480
2023 $13,519 $543,820 $206,340 $337,480
2022 $11,271 $421,490 $158,390 $263,100
2021 $11,148 $421,490 $158,390 $263,100
2020 $10,862 $421,490 $158,390 $263,100
2019 $10,862 $421,490 $158,390 $263,100
2018 $10,461 $421,490 $158,390 $263,100
2017 $8,827 $328,270 $133,060 $195,210
2016 $8,295 $328,270 $133,060 $195,210
2015 $8,079 $328,270 $133,060 $195,210
2014 $7,810 $328,270 $133,060 $195,210
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/16/2026 05/16/26 For Sale $1,200,000 +41.2% $294 / Sq Ft
07/15/2022 07/15/22 Sold $850,000 -2.9% $261 / Sq Ft View Prior Sale
06/06/2022 06/06/22 Pending -- -- --
05/01/2022 05/01/22 For Sale $875,000 -- $268 / Sq Ft
Source: SmartMLS

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Warranty Deed $850,000 None Available
Deed $213,000 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Closed $450,000 Purchase Money Mortgage
Closed $345,800 Stand Alone Refi Refinance Of Original Loan
Closed $331,000 Credit Line Revolving
Closed $400,000 No Value Available
Closed $342,000 No Value Available
Closed $265,000 No Value Available
Source: Public Records

Source: SmartMLS

MLS Number: 24174396

SmartMLS

APN: STAM-000001-000000-007388

Your Personal Tour Guide

Ask me questions while you tour the home.