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.
For sale
$2,200,000
174 Douglas, Staten Island, NY 10304
4beds
4,000sqft
Single Family Residence, Residential
Built in 2000
0.34 Acres Lot
$-- Zestimate®
$550/sqft
$-- HOA
What's special
Two fireplacesMiele appliancesImpressive viewsNewly renovated state-of-the-art kitchen
- 29 days |
- 1,766 |
- 42 |
Zillow last checked: 8 hours ago
Listing updated: December 09, 2025 at 02:03am
Listing by:
Neuhaus Realty Inc 718-979-3400,
Domenica Neuhaus 718-979-3400
Source: OneKey® MLS,MLS#: 942265
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Microwave, Refrigerator, Washer
Features
- Central Vacuum
- Basement: Full
- Attic: Finished
- Has fireplace: Yes
Interior area
- Total structure area: 4,000
- Total interior livable area: 4,000 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Garage spaces: 2
Lot
- Size: 0.34 Acres
Details
- Parcel number: 008350110
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Stone, Stucco
Condition
- Year built: 2000
Utilities & green energy
- Sewer: Other
- Water: Public
- Utilities for property: Natural Gas Available, Sewer Available
Community & HOA
HOA
- Has HOA: No
Location
- Region: Staten Island
Financial & listing details
- Price per square foot: $550/sqft
- Tax assessed value: $1,412,000
- Annual tax amount: $18,037
- Date on market: 12/8/2025
- Cumulative days on market: 30 days
- Listing agreement: Exclusive Right To Sell
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 12/7/2025 | Listed for sale | $2,200,000-1.7%$550/sqft |
Source: | ||
| 11/1/2025 | Listing removed | $2,239,000$560/sqft |
Source: NY State MLS #11521002 Report a problem | ||
| 10/1/2025 | Price change | $2,239,000-0.4%$560/sqft |
Source: NY State MLS #11521002 Report a problem | ||
| 6/24/2025 | Listed for sale | $2,249,000$562/sqft |
Source: NY State MLS #11521002 Report a problem | ||
| 6/22/2025 | Contingent | $2,249,000$562/sqft |
Source: NY State MLS #11521002 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $18,169 | $84,720 -9.8% |
| 2023 | -- | $93,960 +10.7% |
| 2022 | -- | $84,900 -5.1% |
Find assessor info on the county website
BuyAbility℠ payment
Estimated monthly payment
Boost your down payment with 6% savings match
Earn up to a 6% match & get a competitive APY with a *. Zillow has partnered with to help get you home faster.
Learn more*Terms apply. Match provided by Foyer. Account offered by Pacific West Bank, Member FDIC.Climate risks
Neighborhood: Emerson Hill
Nearby schools
GreatSchools rating
- 7/10Ps 48 William C WilcoxGrades: PK-8Distance: 0.3 mi
- 5/10New Dorp High SchoolGrades: 9-12Distance: 2.5 mi
- 5/10Is 49 Bertha A DreyfusGrades: 6-8Distance: 1.3 mi
Schools provided by the listing agent
- Elementary: Contact Agent
- High: Contact Agent
Source: OneKey® MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
- Loading






