Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
$2,200,000
Listing Price4beds
4baths
3,816sqft
12,546sqft lot
174 Douglas Rd, Staten Island, NY 10304
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
For Sale
Home type
Price / sqft
Year built
Home Details
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.
Interior Details
3816
4
4
Has Heating:
No
Heating Type:
N/A
Has Cooling:
No
Cooling Type:
N/A
Has Fuel:
No
Fuel Type:
N/A
Has Basement:
No
Basement Type:
N/A
Has Flooring:
No
Flooring Type:
N/A
Has Fireplace:
Yes
Fireplace Type:
N/A
Property Details
12546
No
No
Type:
N/A
Location:
N/A
Status:
N/A
Number of Spaces:
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Construction Details
N/A
N/A
N/A
N/A
N/A
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
2020
$15,660
$25,320
$63,360
--%
$88,680
2019
$15,497
$25,320
$53,760
--%
$79,080
2018
$15,345
$24,400
$50,419
--%
$74,819
2017
$14,088
$20,112
$50,472
--%
$70,584
2016
$13,001
$23,554
$43,035
--%
$66,589
2014
$11,676
$21,120
$41,700
--%
$62,820
2013
$11,892
$21,120
$41,760
--%
$62,880
2012
$11,219
$30,633
$34,692
--%
$65,325
Average Home Price in 10304
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$1,586,416
$1,586,416
-- Beds
-- Baths
3,260 Sqft
15,016 Lot (sqft)
Sold 08/22/2026
$2,019,645
$2,019,645
-- Beds
2 Baths
3,494 Sqft
12,133 Lot (sqft)
Sold 07/28/2026
$1,628,071
$1,628,071
-- Beds
2 Baths
3,277 Sqft
8,000 Lot (sqft)
Sold 06/03/2026
$2,200,000
$2,200,000
4 Beds
4 Baths
3,816 Sqft
12,546 Lot (sqft)
Sold 09/29/2026
$1,499,999
$1,499,999
-- Beds
2 Baths
3,325 Sqft
10,000 Lot (sqft)
Sold 07/10/2025
$1,568,000
$1,568,000
-- Beds
2 Baths
3,385 Sqft
7,771 Lot (sqft)
Sold 10/06/2026
$1,718,732
$1,718,732
-- Beds
2 Baths
3,324 Sqft
28,220 Lot (sqft)
Sold NaN/NaN/NaN
$2,240,000
$2,240,000
-- Beds
2 Baths
3,526 Sqft
7,786 Lot (sqft)
Sold 10/06/2026
