Robin Ward
BEDS4
BATHS3 full 1 partial
SQUARE FEET4,000
MLS#942265
STATUSActive
PROPERTY TYPEResidential - Single Family
SCHOOLContact Agent
Property 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 the home fully furnished Must be seen to be appreciated.
Property Features
Property Type: Residential - Single Family
Basement: Full
Basement: Yes
Cooling: Central Air
Garage: 2
Heating: Natural Gas
Home Style: Colonial
Lot Size: 0.34 Acres
Taxes: $18,037
Year Built: 2000
Amenities
Central Vacuum
Walk-In Closet(s)
Feature Descriptions
Appliances: Dishwasher, Dryer, Microwave, Refrigerator, Washer
Attic: Finished
Days on Site: 126
Exterior: Stone, Stucco
Fireplace Y/N: Yes
GarageY/N: Yes
On Market Date: 2025-12-08
Parking Features: Attached
Rental Term: Monthly
Rooms Total: 10
Sewer: Other
Utilities: Electricity Available, Natural Gas Available, Sewer Available
Water: Public
Local Schools
High School: Contact Agent
Elementary School: Contact Agent
School District: Contact Agent
Listed By / Shown By
Listing By
Agency Name: Neuhaus Realty Inc
Agency Contact: 718-979-3400
Shown By
Agent Name: Robin Ward
Agent Phone: Cell: (631) 521-0843
Agency Title: Howard Hanna | Coach Realtors
Estimate Your Payment
Estimated Payment
$ 11,592.81 per month $9,448.06 Principal & Interest $1,503.08 Property Tax $641.67 Homeowner's InsuranceChange Payment Information
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
Agency License Information: https://www.coachrealtors.com New York State Real Estate Broker Principal Office License Number: 10991237973
174 Douglas | MLS# 942265
This single family home located at 174 Douglas, Staten Island, NY 10304 is currently listed for sale with an asking price of $2,200,000. This property was built in 2000 and has 4 bedrooms and 3 full and 1 partial baths with 4000 sq. ft. Douglas is located within the Contact Agent school district. Search Staten Island real estate on rward.coachrealtors.com today.