Save
Ask
Tour
Hide
$2,200,000
2 Days On Site
174 DouglasStaten Island, NY 10304
For Sale|Single Family Residence|Active
4
Beds
4
Total Baths
3
Full Baths
1
Partial Bath
4,000
SqFt
$550
/SqFt
2000
Built
County:
Richmond (Staten Island)
Listing courtesy of Neuhaus Realty Inc neuhausrealtyinc@gmail.com
Call Now: 845 893 2920
Is this the listing for you? We can help make it yours.
845 893 2920
Save
Ask
Tour
Hide
Mortgage Calculator
Monthly Payment (Est.)
$10,037Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.
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.
Save
Ask
Tour
Hide
Listing Snapshot
Price
$2,200,000
Days On Site
2 Days
Bedrooms
4
Inside Area (SqFt)
4,000 sqft
Total Baths
4
Full Baths
3
Partial Baths
1
Lot Size
N/A
Year Built
2000
MLS® Number
942265
Status
Active
Property Tax
$18,037
HOA/Condo/Coop Fees
N/A
Sq Ft Source
N/A
Friends & Family
Recent Activity
| 2 days ago | Listing first seen on site | |
| 2 days ago | Listing updated with changes from the MLS® |
General Features
Attached Garage
Yes
Garage
Yes
Garage Spaces
2
Parking
Attached
Property Sub Type
Single Family Residence
Sewer
Other
Style
Colonial
Utilities
Natural Gas AvailableElectricity AvailableSewer Available
Water Source
Public
Interior Features
Appliances
DishwasherDryerMicrowaveRefrigeratorWasher
Basement
Full
Cooling
Central Air
Fireplace
Yes
Heating
Natural Gas
Interior
Central VacuumWalk-In Closet(s)
Save
Ask
Tour
Hide
Exterior Features
Construction Details
StoneStucco
Community Features
School District
Contact Agent
Schools
School District
Contact Agent
Elementary School
Contact Agent
Middle School
Call Listing Agent
High School
Contact Agent
Listing courtesy of Neuhaus Realty Inc neuhausrealtyinc@gmail.com
Based on information submitted to the MLS GRID as of 2025-12-10 06:40 PM EST. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
Based on information submitted to the MLS GRID as of 2025-12-10 06:40 PM EST. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
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.