SOLD JUN 25, 2026

Sold on Jun 2026

$1,999,998

•

4,000

sq ft

174 Douglas Rd, Staten Island, NY 10304

Track this home’s value and nearby sales activity

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

Single-familyProperty Type

2000Year Built

0.34 acresLot Size

$500Price/Sq.Ft.

2 car garageParking

Listing by Carl Neuhaus • Neuhaus Realty, Inc.

Bought with Broker Non-MLS • MLS

Redfin checked: a minute ago

•Source:SIBORMLS #2507011

Redfin Estimate

$2,170,786

$171K since sold in June 2026$25K since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 52.8% higher than the average sale price ($1.42M) of 6 comparable homes.

SOLD MAR 23, 2026
$999,000
A
3 beds3 baths1,604 sq ft
201 Milford Ave, Staten Island, NY 10301
Listing by Connie Profaci Realty
SOLD JUN 26, 2026
$2,000,000
B
4 beds2.5 baths5,320 sq ft
76 Douglas Rd, Staten Island, NY 10304
Listing by Re Max Team
SOLD JUN 24, 2026
$1,200,000
C
4 beds4 baths2,616 sq ft
35 Milden Ave, Staten Island, NY 10301
Listing by CRM Real Estate
SOLD JUN 16, 2026
$1,290,000
D
4 beds3.5 baths3,690 sq ft
367 Ocean Ter, Staten Island, NY 10301
Listing by Robert DeFalco Realty, Inc.
SOLD JUN 2, 2026
$1,285,000
E
4 beds3 baths4,400 sq ft
19 Woodlawn Ave, Staten Island, NY 10305
Listing by Comfort Homes Realty Group Inc
SOLD JUN 18, 2026
$1,750,000
F
4 beds3.5 baths3,690 sq ft
32 Hunt Ln, Staten Island, NY 10304
Listing by Jordan Realty Group, LLC

Claim this home to receive a free report every month with insights on the changing estimate.

Market trends in 10304, NY

Last updated August 2026

Buyer's Market

Seller's Market

Balanced market

Sale-to-List Price

95.7%

0.1% MoM

Median sale price

$737K

$38K MoM

Avg. days on market

59d

7 days MoM

Recently sold homes

2 MoM

New listings for sale

$935,000
5 beds4.5 baths2,295 sq ft
95 Pleasant Valley Ave, Staten Island, NY 10304
Listing by Homes R Us Realty of NY, Inc.
$1,850,000
3 beds3 baths1,880 sq ft
65 Cromwell Ave, Staten Island, NY 10304
Listing by Neuhaus Realty, Inc.
OPEN TODAY, 2:30PM TO 4:30PM
$849,900
4 beds3 baths1,344 sq ft
335 Oder Ave, Staten Island, NY 10304
Listing by Homes R Us Realty of NY, Inc.
$1,940,000
4 beds3 baths4,426 sq ft
111 Douglas Rd, Staten Island, NY 10304
Listing by Connie Profaci Realty
$679,888
5 beds2 baths1,512 sq ft
94 Gordon St, Staten Island, NY 10304
Listing by DiTommaso Real Estate
$299,999
1 bed1 bath658 sq ft
755 Narrows Rd N #506, Staten Island, NY 10304
Listing by Coldwell Banker Advantage
$1,199,900
3 beds3 baths2,100 sq ft
43 Wilson St, Staten Island, NY 10304
Listing by Re/Max Edge
OPEN TODAY, 12PM TO 2PM
$750,000
3 beds1 bath1,391 sq ft
28 Newberry Ave, Staten Island, NY 10304
Listing by Precious Properties Corp.
$325,000
1 bed1 bath844 sq ft
55 Austin Pl Unit 2r, Staten Island, NY 10304
Listing by Robert DeFalco Realty, Inc.
$649,888
3 beds2.5 baths1,110 sq ft
85 Fairway Ave, Staten Island, NY 10304
Listing by Robert DeFalco Realty, Inc.
See all

Provided by Redfin

Homeowner tools

View owner dashboard

Track your estimate and nearby sale activity

Edit home facts

Review property details and add renovations

Manage photos

Update home photos or make them private

Rental estimate

Est. $5,020 per month, based on comparable rentals

Sale and tax history for 174 Douglas Rd

Sale History
Tax History

Date

Event

Price

OneKey® MLS as Distributed by MLS Grid #942265

Jun 25, 2026

Sold

$1,999,998

$500/sq ft

Apr 17, 2026

Pending

—

Dec 6, 2025

Listed

$2,200,000

$550/sq ft

SIBORMLS #2507011

Jun 25, 2026

Sold

$1,999,998

$500/sq ft

Dec 6, 2025

Listed

$2,200,000

$550/sq ft

Public Records

Jul 21, 2010

Sold

$1,281,698

$320/sq ft

SIBORMLS #1057960

Jun 30, 2010

Sold

$1,800,000

$450/sq ft

Jan 8, 2010

Listed

$1,999,999

$500/sq ft

ABSOLUTELY BEAUTFUL STONE/STUCCO COLONIAL FEATURING SWEEPING WATER/BRIDGE VIEWS,ELEGANT ROOMS,HW FLOORS,RADIANT HEAT,4 BEDRMS,5 BATHS, WALK OUT LOWER LEVEL. 2 FRPLS,2 CAR GARAGE, INGROUND POOL, HEATED DRIVEWAY Level 1: 2 STORY MARBLE ENTRY, FLOATING STAIR, FLR, FDR, BUTLERS PANTRY W/WET BAR, GOURMET EIK, GREAT ROOM/FIREPLC, 1/2 BTH Level 2: LAVISH MASTER SUITE W/ PRIVATE BTH/WIC, BDRM, BDRM, JACK N JILL FULL BTH, BDRM/PRIVATE FULL BTH Level 3: WALK UP Basement: FULL FINISHED - WALK OUT - REC RM/ FIRE PLACE, WINE CELLAR, KITCHEN, GYM 3/4 BATH

SIBORMLS #1038338

Jan 11, 2010

Listing Removed

—

Jul 20, 2007

Listed

$2,250,000

$563/sq ft

SIBORMLS #1029003

Jul 20, 2007

Listing Removed

—

Sep 1, 2006

Listed

$2,375,000

$594/sq ft

Public Records

Apr 27, 1999

Sold

$200,000

$50/sq ft

Public Records

Mar 28, 1988

Sold

$25,000

$6/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$18,037 (+6.0%)

$25,320 + $100,200

$125,520

2024

$17,016 (−6.7%)

$25,320 + $77,820

$103,140

2023

$18,234 (+7.8%)

$25,320 + $59,400

$84,720

2022

$16,909 (+0.5%)

$25,320 + $68,640

$93,960

2021

$16,816 (+7.4%)

$25,320 + $59,580

$84,900

2020

$15,661 (+1.1%)

$25,320 + $64,140

$89,460

2019

$15,497 (+1.0%)

$25,320 + $63,360

$88,680

2018

$15,346 (+8.9%)

$25,320 + $53,760

$79,080

2017

$14,089 (+8.4%)

$20,112 + $50,472

$70,584

2016

$13,001 (+8.6%)

$20,112 + $50,472

$70,584

2015

$11,974 (+2.6%)

$23,554 + $43,035

$66,589

2014

$11,676 (−1.8%)

$21,120 + $41,700

$62,820

2013

$11,892

$21,120 + $41,760

$62,880

Public record

Public record
Zoning

Beds

—

Baths

—

Stories

Lot width

92 ft.

Lot depth

138 ft.

Lot size

0.29 Acres

Year renovated

—

Sq. Ft.

3,816

Year built

1999

Style

Single Family Residential

County

Richmond County

APN

008350110

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Sep 9, 2026.

R1-1

NA-1

Low-Density Non-Contextual Residence District

R1 districts are leafy, low-density neighborhoods of large, single-family detached homes on spacious lots. Resembling many suburbs, these districts are mapped in a few areas of the city, such as Todt Hill (R1-1) in Staten Island, Jamaica Estates (R1-2) in Queens, and Fieldston (R1-2) in the Bronx. R1-2A is mapped in Forest Hills in Queens.; There are three R1 districts. Although new homes in R1-1 districts must be on larger and wider lots than homes in R1-2 and R1-2A districts, generous yard requirements and high open space ratio (OSR) or lot coverage regulations preserve the open space that characterizes all R1 districts. The floor area ratio (FAR) of 0.5 and the sizeable required lot area tend to produce big, roomy houses. The maximum height of buildings in R1-1 and R1-2 districts is not fixed but is governed by a sky exposure plane;; contextual regulations in R1-2A districts produce buildings that maintain neighborhood scale and character with a maximum perimeter wall of 25 feet, a maximum building height of 35 feet and a front yard as deep as a neighboring yard. Auto ownership rates are high and, as in other lower-density districts which are often distant from mass transit, one off-street parking space is required for each dwelling unit.

Zone overlays

Permitted uses

Include but are not limited to:

Greenhouse / nursery
Community / recreation center
Religious facility
Housing-Single unit
Housing-Other
Library
Museum / gallery
Golf related
Park & open space

Property details

Parking

Parking Information
Has Garage
Attached Garage: No
Garage Spaces: 2
Parking Features: Off Street

Interior

Virtual Tour Information

Bathroom Information
# of Bathrooms (Full): 3
# of Bathrooms (3/4): 1
# of Bathrooms (Half): 1
# of Bathrooms (Total Integer): 5

Basement Information
Basement: Finished

Interior Features
Interior Features: Walk-In Closet(s), Fireplace
Appliances: Dishwasher, Dryer, Microwave, Refrigerator, Washer
Has Fireplace
Air Conditioner: Central Air

Exterior

Exterior Features
Exterior Features: Balcony

Property Information
Property Sub Type: Single Family Residence
Year Built Details: Approx
Construction Materials: Stone, Stucco
Property Condition: Excellent
Stories: 3
Building Area Total: 4,000

Lot Information
Lot Size Acres: 0.34
Lot Size Square Feet: 15,000
Lot Size Dimensions: 93x138
Lot Features: Side
Has Waterview: Yes
Zoning: R1-2

Financial

Tax Information
Tax Annual Amount: $18,037
Parcel Number: 00835-0110

Utilities

Heating & Cooling
Has Cooling
Has Heating
Heating: Natural Gas, Hot Water, Other

Utility Information
Electric: 220 Volts

Location

Location Information
Directions: off Richmond Rd and Emerson hill
Unparsed Address: 174 Douglas Road, Staten Island, NY 10304

Public facts

Beds: —
Baths: —
Sq. Ft.: 3,816
Stories: 2.0
Lot Size: 0.29 acres
Style: Single Family Residential
Year Built: 1999
Year Renovated: —
County: Richmond County
APN: 008350110

Home facts updated by county records on Sep 9, 2026

Around this home

Schools

PS 48 William C Wilcox

Public PreK-8 • Assigned • 0.3mi

7/10

New Dorp High School

Public 9-12 • Assigned • 2.5mi

4/10

Provided by GreatSchools

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

4/10 Fire Factor

1% chance of being in a wildfire in next 30 years

7/10 Heat Factor

7 days above 97° expected this year, 15 days in 30 years

6/10 Wind Factor

62% chance of strong winds in next 30 years

4/10 Air Factor

5 unhealthy days expected this year, 7 days in 30 years

Provided by First Street

Historical weather

Staten Island, NY • 10304

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

85/ 100

Very good sunlight

Sunscore

This home ranks in the top 23% for direct sun exposure in Staten Island. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.

8.2 hrs

4.6 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$2.06M – $2.50M

Reach more buyers when you sell with Redfin. Plus, you'll save $21,708 in fees.

Nearby similar homes

$1,487,000

5 beds3.5 baths2,640 sq ft

57 Schmidts Ln, Staten Island, NY 10314

Listing by Weichert Realtors Truhomes

$899,998

3 beds2 baths1,596 sq ft

2120 Clove Rd, Staten Island, NY 10305

Listing by Coldwell Banker Advantage

$525,000

2 beds2 baths1,087 sq ft

830 Howard Ave Unit 4H, Staten Island, NY 10301

Listing by 1st Premier Realty Network Inc

$3,450,000

5 beds6.5 baths7,800 sq ft

289 Ocean Ter, Staten Island, NY 10301

Listing by Robert DeFalco Realty, Inc.

OPEN TODAY, 1:30PM TO 3:30PM

$1,299,900

4 beds2 baths2,182 sq ft

17 Glendale Ave, Staten Island, NY 10304

Listing by Homes R Us Realty of NY, Inc.

OPEN TODAY, 12PM TO 2PM

$848,800

4 beds2 baths870 sq ft

78 Sparkill Ave, Staten Island, NY 10304

Listing by DiTommaso Real Estate

New listings for sale in 10304

$935,000

5 beds4.5 baths2,295 sq ft

95 Pleasant Valley Ave, Staten Island, NY 10304

Listing by Homes R Us Realty of NY, Inc.

$1,850,000

3 beds3 baths1,880 sq ft

65 Cromwell Ave, Staten Island, NY 10304

Listing by Neuhaus Realty, Inc.

OPEN TODAY, 2:30PM TO 4:30PM3D WALKTHROUGH

$849,900

4 beds3 baths1,344 sq ft

335 Oder Ave, Staten Island, NY 10304

Listing by Homes R Us Realty of NY, Inc.

$1,940,000

4 beds3 baths4,426 sq ft

111 Douglas Rd, Staten Island, NY 10304

Listing by Connie Profaci Realty

$679,888

5 beds2 baths1,512 sq ft

94 Gordon St, Staten Island, NY 10304

Listing by DiTommaso Real Estate

$299,999

1 bed1 bath658 sq ft

755 Narrows Rd N #506, Staten Island, NY 10304

Listing by Coldwell Banker Advantage

$1,199,900

3 beds3 baths2,100 sq ft

43 Wilson St, Staten Island, NY 10304

Listing by Re/Max Edge

OPEN TODAY, 12PM TO 2PM

$750,000

3 beds1 bath1,391 sq ft

28 Newberry Ave, Staten Island, NY 10304

Listing by Precious Properties Corp.

$325,000

1 bed1 bath844 sq ft

55 Austin Pl Unit 2r, Staten Island, NY 10304

Listing by Robert DeFalco Realty, Inc.

Home values near 174 Douglas Rd

Data from public records.

Address	Redfin Estimate
170 Douglas Road, Staten Island, NY - Beds \| - Baths \| 3000 Sq. Ft.	$1,534,265
191 Douglas Road, Staten Island, NY - Beds \| - Baths \| 2680 Sq. Ft.	$1,496,262

Address	Redfin Estimate
199 Douglas Road, Staten Island, NY - Beds \| - Baths \| 1820 Sq. Ft.	$1,032,667
82 Douglas Road, Staten Island, NY - Beds \| - Baths \| 10638 Sq. Ft.	$5,558,887

Address	Redfin Estimate
205 Douglas Road, Staten Island, NY - Beds \| - Baths \| 5198 Sq. Ft.	$2,298,149
166 Douglas Road, Staten Island, NY - Beds \| - Baths \| 5400 Sq. Ft.	$2,112,794

Property information provided by SIBORMLS when last listed in 2025. This data may not match . Learn more.

More real estate resources

Minor Civil Divisions
Zip Codes
Cities
Neighborhoods
Popular Searches

Bloomfield Township homes for sale
Piscataway Township homes for sale
Livingston Township homes for sale
West Orange Township homes for sale
Wayne Township homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

10305 homes for sale
10306 homes for sale
07024 homes for sale
07302 homes for sale
11209 homes for sale

Houses for rent in New York	Agents near me	White Plains, NY homes for sale	New York Housing Market
Houses for sale near me	New York, NY homes for sale	Yonkers, NY homes for sale
Land for sale near me	Manhattan, NY homes for sale	Scarsdale, NY homes for sale
Open Houses near me	Rochester, NY homes for sale	New York Property Records
Condos for sale near me	Buffalo, NY homes for sale	NY New Listings

Greenwich homes for sale
Manhattan homes for sale
Jersey City homes for sale

East Shore homes for sale
Staten Island homes for sale
Emerson Hill homes for sale

Is this your home?

About this home

Redfin Estimate

Market trends in 10304, NY

Homeowner tools

Sale and tax history for 174 Douglas Rd

Public record

Property details

Around this home

Schools

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 10304

Home values near 174 Douglas Rd

More real estate resources