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.
Sold for $1,999,998
$1,999,998
174 Douglas, Staten Island, NY 10304
4beds
4,000sqft
Single Family Residence, Residential
Built in 2000
0.34 Acres Lot
$2,007,900 Zestimate®
$500/sqft
$5,796 Estimated rent
Home value
$2,007,900
$1.83M - $2.19M
$5,796/mo
Zestimate® history
Owner options
List your home for rent
$5,796/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,796/mo
Rent Zestimate®
Refinance and save
$12,363/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$12,363/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Two fireplacesMiele appliancesImpressive viewsNewly renovated state-of-the-art kitchen
Zillow last checked:
Listing updated:
Listed by:
Domenica Neuhaus 718-979-3400,
Neuhaus Realty Inc 718-979-3400
Bought with:
Non Member-MLS
Buyer Representation Office
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 942265
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Heating
- Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Microwave, Refrigerator, Washer
Features
- Central Vacuum, Walk-In Closet(s)
- 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: Electricity Available, Natural Gas Available, Sewer Available
Community & HOA
HOA
- Has HOA: No
Location
- Region: Staten Island
Financial & listing details
- Price per square foot: $500/sqft
- Tax assessed value: $1,719,000
- Annual tax amount: $18,037
- Date on market: 12/8/2025
- Cumulative days on market: 130 days
- Listing agreement: Exclusive Right To Sell
- Electric utility on property: Yes
Price history
| Date | Event | Price |
|---|---|---|
| 6/25/2026 | Sold | $1,999,998-9.1%$500/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #942265 Report a problem | ||
| 4/17/2026 | Pending sale | $2,200,000$550/sqft |
Source:  SIBOR #2507011 Report a problem | ||
| 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
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $18,037 -0.7% | $103,140 +21.7% |
| 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
Neighborhood: Emerson Hill
Nearby homes
- $1,597,700-- bd-- ba3k sqft170 Douglas Rd, Staten Island, NY 10304Off Market
- $1,880,0004 bd4 ba5.1k sqft178 Douglas Rd, Staten Island, NY 10304Sold
- $2,578,000-- bd-- ba7.5k sqft80 Lyman Pl, Staten Island, NY 10304Off Market
- $1,864,9004 bd4 ba4k sqft90 Lyman Pl, Staten Island, NY 10304Off Market
- $1,457,100-- bd-- ba2.6k sqft191 Douglas Rd, Staten Island, NY 10304Off Market
- $1,287,2004 bd4 ba2.7k sqft199 Douglas Rd, Staten Island, NY 10304Off Market
- $2,889,2004 bd6 ba8.8k sqft70 Lyman Pl, Staten Island, NY 10304Off Market
- $1,886,700-- bd-- ba5.4k sqft166 Douglas Rd, Staten Island, NY 10304Off Market
Nearby schools
GreatSchools rating
- 7/10Ps 48 William C WilcoxGrades: PK-8Distance: 0.3 mi
- 4/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.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,007,900
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,007,900
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other New York Topics
