174 Douglas Road
Description
A newly renovated, state-of-the-art kitchen with Sub-Zero, Miele appliances, and a Wolf gas/electric stovetop
Radiant...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.
- Listed by Carl Neuhaus • Brokerage DRE #109940369 • Neuhaus Realty, Inc.P: (917)-902-2915 cneu@aol.com
Property Details for 174 Douglas Road
Property Details for 174 Douglas Road
| Status | Active |
|---|---|
| MLS ID | 2507011 |
| Days on Market | 123 |
| Taxes | $18,037 / year |
| Maintenance | - |
| Min. Down Pymt | - |
| Total Rooms | 10.0 |
| Property Type | Single Family |
| MLS Type | Residential |
| Year Built | 1999 |
| Lot Size | 15,000 SF / 93' x 138' |
| County | Richmond County |
Building
174 Douglas Rd
Location
Building Information for 174 Douglas Road
Payment Calculator
$12,581 per month
30 year fixed, 6.46% Interest
$11,078
$1,503
$0
Know your buying power with a preapproval and custom rate in minutes
1Property Information for 174 Douglas Road
- Absolute Longitude: -74
- Directions: off Richmond Rd and Emerson hill
- Handicap Access: No
- Section: Mid-Island
- Garage: True
- Garage Location: Built-in
- Garage Capacity: 2.0
- Tax Abated: No
- UnBranded Virtual Tour: https://app.doaudiotours.com/unbranded?id=14424&lang=en-US
- Block: 00835
- Lot: 0110
- Lot Dim: 93x138
- Parcel ID: 00835-0110
- Lot Features: Back, Side
- CofO: Yes
- Condition: Excellent
- Year Built Description: Approx
- Cable: Yes
- Cooling: Yes
- Electric: 220
- Sewer: City
- # of A/C Units: 6
- 3/4 Baths: 1
- Air Conditioner: Central
- Appliances: Dishwasher, Dryer, Microwave, Refrigerator, Washer
- Basement Desc: Finished
- Basement Type: Full
- Dining Room: Formal
- Fireplace: Yes
- Full Baths: 3
- Heat Source: Gas
- Heat System: Hot Water, Other
- Interior: Central Vac, Fireplace, Security System, Walk-in Closet, Walk-In Closet(s)
- Kitchen: Eat In
- Living Room: Formal, Separate
- Main Bath: Full Bath, Separate Shower
- Total Baths: 5.00
- Total Rooms Main Unit: 10
- Exterior: Balcony
- Siding: Stone, Stucco
- Main Unit Lease: No
Property History for 174 Douglas Road
| Date | Event & Source | Price |
|---|---|---|
| 12/07/2025 | Listed (Active) SIBOR #2507011 | $2,200,000 |
| 06/30/2010 | Sold SIBOR #1057960 | $1,800,000 |
| 06/30/2010 | $1,281,698 | |
| 04/12/2010 | Contract Signed SIBOR #1057960 | — |
| 01/11/2010 | Permanently Off Market SIBOR #1038338 | $2,250,000 |
| 01/08/2010 | Listed (Active) SIBOR #1057960 | $1,999,999 |
| 07/20/2007 | Permanently Off Market SIBOR #1029003 | $2,375,000 |
| 07/20/2007 | Listed (Active) SIBOR #1038338 | $2,250,000 |
| 09/01/2006 | Listed (Active) SIBOR #1029003 | $2,699,000 |
For completeness, Compass often displays two records for one sale: the MLS record and the public record.
Public Records for 174 Douglas Road
Schools near 174 Douglas Road
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | PK to 8 | |||
| Public - | 6 to 8 | |||
| Public - | 9 to 12 | |||
| Public - | 6 to 8 |
Rating | School | Distance |
|---|---|---|
P.S. 48 William C Wilcox PublicPK to 8 | ||
Is 49 Bertha A Dreyfus Public6 to 8 | ||
New Dorp High School Public9 to 12 | ||
YOUNG WOMEN'S LEADERSHIP OF SI Public6 to 8 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Neighborhood Map and Transit
Similar Homes
Similar Sold Homes
Explore Nearby Homes
- Clifton Homes for Sale
- Concord Homes for Sale
- Dongan Hills Homes for Sale
- Dongan Hills Colony Homes for Sale
- East Shore Homes for Sale
- Egbertville Homes for Sale
- Emerson Hill Homes for Sale
- Grasmere Homes for Sale
- Grymes Hill Homes for Sale
- New Dorp Homes for Sale
- North Shore Homes for Sale
- Rosebank Homes for Sale
- Stapleton Homes for Sale
- Sunnyside Homes for Sale
- Todt Hill Homes for Sale
- New York Homes for Sale
- Staten Island Homes for Sale
- Bayonne Homes for Sale
- Brooklyn Homes for Sale
- Jersey City Homes for Sale
- Elizabeth Homes for Sale
- Newark Homes for Sale
- Manhattan Homes for Sale
- Linden Homes for Sale
- Carteret Homes for Sale
- Elizabeth Port Homes for Sale
- Kearny Homes for Sale
- Keansburg Homes for Sale
- Woodbridge Homes for Sale
- Port Reading Homes for Sale
- 10301 Homes for Sale
- 10305 Homes for Sale
- 10306 Homes for Sale
- 10314 Homes for Sale
- 10310 Homes for Sale
- 07002 Homes for Sale
- 11209 Homes for Sale
- 10308 Homes for Sale
- 10302 Homes for Sale
- 11220 Homes for Sale
- 07305 Homes for Sale
- 11252 Homes for Sale
- 11228 Homes for Sale
- 10303 Homes for Sale
- 10312 Homes for Sale
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of Neuhaus Realty, Inc.
This information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. ©2026 The Real Estate Board of New York, Inc., All rights reserved. The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers’ personal, non-commercial use. The data relating to real estate for sale on this website comes in part from the IDX Program of OneKey® MLS. Information Copyright 2026, OneKey® MLS. All data is deemed reliable but is not guaranteed accurate by Compass. See Terms of Service for additional restrictions. Compass · Tel: 212-913-9058 · New York, NY Listing information for certain New York City properties provided courtesy of the Real Estate Board of New York’s Residential Listing Service (the "RLS"). The information contained in this listing has not been verified by the RLS and should be verified by the consumer. The listing information provided here is for the consumer’s personal, non-commercial use. Retransmission, redistribution or copying of this listing information is strictly prohibited except in connection with a consumer's consideration of the purchase and/or sale of an individual property. This listing information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. ©2026 The Real Estate Board of New York, Inc., all rights reserved. This information is not guaranteed, should be independently verified and may not reflect all real estate activity in the market. Offers of compensation set forth here are for other RLSParticipants only and may not reflect other agreements between a consumer and their broker.©2026 The Real Estate Board of New York, Inc., All rights reserved.