174 Douglas Road, Staten Island, NY 10304
$1,999,998
Property Type:
Residential
Bedrooms:
4
Baths:
5
Square Footage:
4,000
Lot Size (sq. ft.):
15,000
Status:
Closed
Current Price:
$1,999,998
List Date:
12/07/2025
Last Modified:
6/26/2026
Overview
Description
Listing Details MLS# 2507011
AddressLegal
- Street No.
- 174
- Street Name
- Douglas
- Street Suffix
- Road
- County
- Richmond
- State
- NY
- Zip Code
- 10304
- Area Name
- Emerson Hill
- Parcel ID
- 00835-0110
ContractLocation Information
- Marketing/Listing Date
- 2025-12-06
- Sub-Type
- Single Family - Detached
- Zoning
- R1-2
- Block
- 00835
- Lot
- 0110
General Property Info
- Year Built
- 2000
- Year Built Description
- Approx
- Taxes
- 18037
- Tax Abated
- No
- Lot Size SqFt
- 15000
- Lot Dim
- 93x138
- Building SqFt
- 4000
- Total Rooms Main Unit
- 10
- Full Baths
- 3
- 3/4 Baths
- Yes
- Half Baths
- Yes
- Total Baths
- 5
- Stories
- 3
- Garage
- Yes
- Garage Capacity
- 2
- Waterview
- Yes
- No. of Heating Units
- 2
- Air Conditioner
- Central Air
- # of A/C Units
- 6
- Fireplace
- Yes
- Public Remarks
- Located in the heart of Emerson Hill, this spectacular 4-5 bedroom center-hall colonial offers some of the most impressive views you will find in NYC. Enjoy breathtaking, year-round unobstructed panoramic views of the Verrazzano Bridge and the lower New York Bay, with constant maritime activity that can be seen from most rooms of this spacious custom-built home. Special features include: A newly renovated, state-of-the-art kitchen with Sub-Zero, Miele appliances, and a Wolf gas/electric stovetop Radiant heat with 18 separate zones Snow-melt system in the driveway Two Fireplaces Whole-house natural gas generator Large, level, beautifully landscaped yard Option to purchase the home fully furnished Must be seen to be appreciated.
Status Change Info
- Pending Date
- 2026-04-16
- Sold Date
- 2026-06-25
- Projected Close Date
- 2026-07-16
More Information
Currently Not Used
- Garage Capacity
- 2
Property Features
Appliances:
Dishwasher; Dryer; Microwave; Refrigerator; Washer
Dining Room:
Formal
Architectural Style:
Colonial
Exterior:
Balcony
Heat Source:
Natural Gas
Heat System:
Hot Water; Other
Interior:
Central Vacuum; Fireplace; Walk-In Closet(s)
Kitchen:
Eat In
Living Room:
Formal; Separate
Main Bath:
Full Bath; Separate Shower
Primary Bedroom:
Private Bath; Suite; Walk-In Closet(s)
Basement:
Finished; Full
Parking:
Off Street
Garage Location:
Built-in
Siding:
Stone; Stucco
Yard:
Back Yard; Side
Security Features:
Security System
Sewer:
Public Sewer
Electric:
220
Property Condition:
Excellent
Listing Courtesy of
Neuhaus Realty, Inc.
Listing data provided courtesy of Staten Island Multiple Listing Service.
The information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.