174 Douglas Road, Staten Island, NY 10304
$2,200,000
Property Type:
Residential
Bedrooms:
4
Baths:
5
Square Footage:
4,000
Lot Size (sq. ft.):
15,000
Status:
Pending
Current Price:
$2,200,000
List Date:
12/07/2025
Last Modified:
4/17/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 Location
- Built-in
- 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
- Projected Close Date
- 2026-07-16
Address/Legal
- Section
- Mid-Island
- Country
- United States
Contract/Location Information
- List Price/SqFt
- 550
- Accessory Dwelling Unit YN
- No
- Ownership Type
- Fee Simple
- CofO
- Yes
- List Type
- Exclusive Right To Sell
- REO
- No
- Owner Finance
- No
More Information
Sewer
- Public Sewer
- Yes
Appliances
- Dishwasher
- Yes
- Dryer
- Yes
- Microwave
- Yes
- Refrigerator
- Yes
- Washer
- Yes
Architectural Style
- Colonial
- Yes
Dining Room
- Formal
- Yes
Electric
- 220
- Yes
Exterior
- Balcony
- Yes
Heat Source
- Natural Gas
- Yes
Heat System
- Hot Water
- Yes
- Other
- Yes
Interior
- Central Vacuum
- Yes
- Fireplace
- Yes
- Walk-In Closet(s)
- Yes
Kitchen
- Eat In
- Yes
Living Room
- Formal
- Yes
- Separate
- Yes
Main Bath
- Full Bath
- Yes
- Separate Shower
- Yes
Primary Bedroom
- Private Bath
- Yes
- Suite
- Yes
- Walk-In Closet(s)
- Yes
Basement
- Finished
- Yes
- Full
- Yes
Parking
- Off Street
- Yes
Garage Location
- Built-in
- Yes
Siding
- Stone
- Yes
- Stucco
- Yes
Yard
- Back Yard
- Yes
- Side
- Yes
Security Features
- Security System
- Yes
Property Condition
- Excellent
- Yes
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.