Do Real Estate on the Go!
- Overview
- Description
- Property Details
- Location
Do Real Estate on the Go!
Download App
Street View
$2,200,000
4 Beds
4 Baths3 full baths + 1 half bath
4,000sqft
174 Douglas, New York, NY 10304
$2,200,000
Get Pre-Approved
Single Family Residence
Built in 2000
$-- HOA
15,000 sqft lot
$550/sq.ft
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 ...
Continue Reading- Houzeo last checked: 20 Minutes ago
- Listing updated: December 9, 2025 at 10:03 am
- Listing Provided by: Domenica Neuhaus (718) 979-3400 | Neuhaus Realty Inc (718) 979-3400
- Source: OneKey MLS-NY | MLS#: 942265
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
2000
HOA Fees
-
Finished Area
4,000 sqft
Lot Size
15,000 sqft lot
Basement Area
- sqft
MLS Name
OneKey MLS
MLS Number
942265
MLS Status
Active
Days on Market
57
Love this home?
Here's 4 things you can do
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
