174 Douglas, New York, NY 10304 - Photo 1

1/1

$1,999,998

Sold
Closed
Single Family
4 Beds
3 Full Baths
1 Partial Bath
2 Car Garage

1/1

Property Description

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.

Full Property Details

Full Property Details for 174 Douglas

General

Sold For: $1,999,998
Taxes: $18,037
Status: Closed
Type: Single Family
Source: Long_Island
MLS ID: 942265
Added to Site: 224 day(s) ago

Interior

Number of Rooms: 10
Interior Features: Central Vacuum, Walk-In Closet(s)
Fireplace: Yes
Appliances: Dishwasher, Dryer, Microwave, Refrigerator, Washer

Rooms

Bathrooms

Total Bathrooms: 4
Full Bathrooms: 3
Half Bathrooms: 1

Bedrooms

Total Bedrooms: 4

Parking

Garage: Yes
Garage Spaces: 2
Parking Features: Attached

Location

County: Richmond (Staten Island)

School Information

High School District: Contact Agent
Elementary School: Contact Agent
Middle School: Call Listing Agent
High School: Contact Agent

Heating & Cooling

Central air: Yes
Cooling Type: Central Air
Heating Type: Natural Gas

Utilities

Sewer: Other
Water: Public
Utility Description: Electricity Available, Natural Gas Available, Sewer Available

Structural Information

Architectural Style: Colonial
Detached/Attached: Detached
Construction: Stone, Stucco
Basement: Yes
Basement Desc.: Full Basement
Sq. Ft. Source: Other
Year Built: 2000

Lot Features

Lot Size (Sq. Ft.): 15,000

Financial Considerations

Tax Amount: $18,037

Disclosures and Reports

Special Conditions: None

Listed by Neuhaus Realty Inc
Sold by Buyer Representation Office

What's Your Home Worth?

* Indicates a required field

For a complimentary comparative market analysis, please contact us so we can discuss your home's value.

Your Property Information

Address optional

City *State *

Zip Code optional

Your Contact Information

First Name *Last Name *

Email Address *

Phone Number *

Comment *

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Submit, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

Listing agent

— 174 Douglas —

Neuhaus Realty Inc

718-979-3400

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender

NMLS#: 1598647

Get Pre-Approved

Schools

Schools serving 174 Douglas

School District:New York City Geographic School District 31

Name	Grades	Distance
Ps 48 William C Wilcox 1050 Targee Street, Staten Island, NY 10304	PK-5	0.3 mi
Is 49 Bertha A Dreyfus 101 Warren Street, Staten Island, NY 10304	6-8	1.3 mi
New Dorp High School 465 New Dorp Lane, Staten Island, NY 10306	9-12	2.5 mi

Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 174 Douglas

Date

Details

Price

Change

Source

6/25/2026

Sold

$1,999,998

-9.09%

MLS

12/08/2025

Listed

$2,200,000

—

MLS

Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

179 N 10th St, Brooklyn, NY 11211 - Photo 1

Just Listed

$3,500,000

179 N 10th St #4C Brooklyn, NY 11211

Apartment
Active
Updated 6 days ago

3
Beds
3
Total Baths
1,714
Sq. Ft.

Listing Courtesy of Compass, Sarah E Burke

301 Stockholm St, Brooklyn, NY 11237 - Photo 1

Just Listed

$795,000

301 Stockholm St #1-F Brooklyn, NY 11237

Apartment
Active
Updated 2 hours ago

1
Bed
2
Total Baths

Listing Courtesy of Nest Seekers LLC, Michael DeSena

775 48th St, Brooklyn, NY 11220 - Photo 1

Just Listed

$2,680,000

775 48th St Brooklyn, NY 11220

Multi-Family
Active
Updated 1 day ago

Listed by RE/MAX Edge

85 Adams St, Brooklyn, NY 11201 - Photo 1

Just Listed

$1,549,999

85 Adams St #6A Brooklyn, NY 11201

Apartment
Active
Updated 2 hours ago

2
Beds
2
Total Baths
1,169
Sq. Ft.

Listing Courtesy of Corcoran Group, Gabriel Gambardella and Corcoran Group, Anthony J Dellecave

174 Douglas, New York, NY 10304 (MLS# 942265) is a Single Family property that was sold at $1,999,998 on June 25, 2026. Want to learn more about 174 Douglas? Do you have questions about finding other Single Family real estate for sale in New York? You can browse all New York real estate or contact a Coldwell Banker agent to request more information.

174 Douglas New York, NY 10304