Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$2,200,000

  • For Sale
  • Active
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 2 Car Garage
See This Home
Save This Home
See This Home
Save This Home
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 for 174 Douglas

General

  • Price: $2,200,000
  • Taxes: $18,037
  • Status: Active
  • Type: Single Family
  • Source: Long_Island
  • MLS ID: 942265
  • Updated: 12/8/2025
  • Added to Site: 40 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

Quickly Find Out More

* Indicates a required field

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 Send Message, 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.

We Value Your Privacy

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

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 174 Douglas

School District:New York City Geographic School District 31
NameGradesDistance
Ps 48 William C Wilcox
1050 Targee Street, Staten Island, NY 10304
PK-50.3 mi
Is 49 Bertha A Dreyfus
101 Warren Street, Staten Island, NY 10304
6-81.3 mi
New Dorp High School
465 New Dorp Lane, Staten Island, NY 10306
9-122.5 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 174 Douglas Get Price Alerts and Save Property

Date
Details
Price
Change
Source
12/08/2025
Listed
$2,200,000
71.65%
MLS
6/30/2010
Sold
$1,281,698
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 174 Douglas

Year
Property Taxes
Change
Tax Assessment
Change
2025
$18,037
6%
$89,803
-1%
2024
$17,016
-6%
$90,461
1%
2023
$18,033
5%
$89,783
6%
2022
$17,202
2%
$84,900
-5%
2021
$16,816
7%
$89,460
1%
2020
$15,661
—
$88,680
12%
2019
$15,660
2%
$79,080
6%
2018
$15,346
9%
$74,819
6%
2017
$14,089
8%
$70,584
6%
2016
$13,002
9%
$66,589
6%
2015
$11,975
3%
$62,820
—
2014
$11,676
-2%
$62,820
—
2013
$11,892
—
$62,880
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 174 Douglas

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Listed by Neuhaus Realty Inc

Similar Properties near 174 Douglas

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

82 Piedmont Ave, New York, NY 10305 - Photo 1
$1,999,000
Open House

82 Piedmont Ave  New York, NY 10305

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 3,500
    Sq. Ft.
Listed by Bergen Basin Realty LLC
74 Longfellow Ave, New York, NY 10301 - Photo 1
$2,050,000

74 Longfellow Ave  New York, NY 10301

  • Single Family
  • Active
  • 6
    Beds
  • 4
    Total Baths
Listed by Safari Realty
728 Westminster Rd, Brooklyn, NY 11230 - Photo 1 Just Listed
$2,350,000
Open House

728 Westminster Rd  Brooklyn, NY 11230

  • Single Family
  • Active
  • Updated 3 days ago
  • 5
    Beds
  • 5
    Total Baths
  • 4,820
    Sq. Ft.
Listing Courtesy of Compass, Tali Berzak and Compass, Kyle Meagher
4 Reeve Pl, New York City, NY 11218 - Photo 1
$1,995,000

4 Reeve Pl  New York City, NY 11218

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,368
    Sq. Ft.
Listing Courtesy of Serhant, Courtney Ann Mendez and Serhant, Abigail Palanca

Just Listed near 174 Douglas

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

17 Douglass St, Brooklyn, NY 11231 - Photo 1 Just Listed
$9,850,000

17 Douglass St  Brooklyn, NY 11231

  • Single Family
  • Active
  • Updated 15 hours ago
  • 5
    Beds
  • 6
    Total Baths
  • 4,700
    Sq. Ft.
Listing Courtesy of Park Property Advisors, Carlos Alberto Saavedra
175 E 55th St, Brooklyn, NY 11203 - Photo 1 Just Listed
$999,000

175 E 55th St  Brooklyn, NY 11203

  • Lots/Land
  • Active
  • Updated 2 days ago
  • 0.0459
    Acres
Listed by WW Realty Group Inc
467 Stratford Rd, Brooklyn, NY 11218 - Photo 1 Just Listed
$2,550,000
Open House

467 Stratford Rd  Brooklyn, NY 11218

  • Single Family
  • Active
  • Updated 1 day ago
  • 6
    Beds
  • 6
    Total Baths
  • 4,050
    Sq. Ft.
Listing Courtesy of Compass, Laura C Rozos
508 Warwick St, Brooklyn, NY 11207 - Photo 1 Just Listed
$699,000
Open House

508 Warwick St  Brooklyn, NY 11207

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,796
    Sq. Ft.
Listed by Lanciano Pizante

174 Douglas, New York, NY 10304 (MLS# 942265) is a Single Family property with 4 bedrooms, 3 full bathrooms and 1 partial bathroom. 174 Douglas is currently listed for $2,200,000 and was received on December 08, 2025. 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.

Tour this property