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
- 123 days |
- 1,151 |
- 25 |
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 as distributed by MLS GRID,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: 123 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
Monthly payment
Estimated monthly payment
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
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 as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Local experts in 10304
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other New York Topics
