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
- 91 days |
- 1,230 |
- 29 |
Zillow last checked: 7 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: 92 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:  SIBOR #2507011 Report a problem | ||
| 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 | ||
| 6/20/2025 | Listed for sale | $2,249,000+75.5%$562/sqft |
Source: NY State MLS #11521002 Report a problem | ||
| 7/21/2010 | Sold | $1,281,698-35.9%$320/sqft |
Source: Public Record Report a problem | ||
| 3/11/2010 | Listing removed | $1,999,999$500/sqft |
Source: Vitale Sunshine #1057960 Report a problem | ||
| 1/13/2010 | Listed for sale | $1,999,999+900%$500/sqft |
Source: Vitale Sunshine #1057960 Report a problem | ||
| 7/15/1999 | Sold | $200,000-34.4%$50/sqft |
Source: Public Record Report a problem | ||
| 4/27/1999 | Sold | $305,000+60.5%$76/sqft |
Source: Public Record Report a problem | ||
| 3/9/1998 | Sold | $190,000$48/sqft |
Source: Public Record 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% |
| 2021 | -- | $89,460 +0.9% |
| 2020 | $15,661 +0% | $88,680 +12.1% |
| 2019 | $15,660 | $79,080 +5.7% |
| 2018 | -- | $74,819 +6% |
| 2017 | $14,389 +10.7% | $70,584 +6% |
| 2016 | $13,002 | $66,589 +6% |
| 2015 | $13,002 +10.6% | $62,820 |
| 2014 | $11,751 | $62,820 -0.1% |
| 2013 | -- | $62,880 -3.7% |
| 2012 | -- | $65,325 +6% |
| 2011 | -- | $61,628 +6% |
| 2010 | -- | $58,140 -0.6% |
| 2009 | -- | $58,500 -5.5% |
| 2008 | -- | $61,920 -16.1% |
| 2007 | -- | $73,800 |
| 2006 | -- | $73,800 -4.7% |
| 2005 | -- | $77,400 -0.5% |
| 2004 | -- | $77,756 +2.9% |
| 2003 | -- | $75,594 +6% |
| 2002 | -- | $71,316 +6% |
| 2001 | -- | $67,280 +39.8% |
| 2000 | -- | $48,130 |
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
- 6/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.
Local experts in 10304
