Skip main navigation
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
    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.
    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#: 942265MLS Logo

    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
    DateEventPrice
    12/7/2025Listed for sale$2,200,000-1.7%$550/sqft
    Source: SIBOR #2507011 Report a problem
    11/1/2025Listing removed$2,239,000$560/sqft
    Source: NY State MLS #11521002 Report a problem
    10/1/2025Price change$2,239,000-0.4%$560/sqft
    Source: NY State MLS #11521002 Report a problem
    6/24/2025Listed for sale$2,249,000$562/sqft
    Source: NY State MLS #11521002 Report a problem
    6/22/2025Contingent$2,249,000$562/sqft
    Source: NY State MLS #11521002 Report a problem

    Public tax history

    Public tax history
    YearProperty taxesTax 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
    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.

    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
    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.

    Similar homes

    Skip to the end of the carouselSkip to the beginning of the carousel
    • Loading
    • Loading