Total: {{ totalFound }}

Selected: {{ Object.values(filter.idsInSelected).filter(Boolean).length }}

No results found.
Try adjusting or resetting your filters.

Featured OPEN HOUSE:
{{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}
For sale For rent {{ property.price | toCurrency }} NEW RENTED UNDER CONTRACT Expired SOLD

{{ property?.neighbourhood?.name }}

{{ property?.borough?.name }}

{{ property.address }}

{{ property.propertysubtype }}

Building {{ property.buildingwidth }} Ft x {{ property.buildinglength }} Ft

Lot {{ property.lotsizewidth }} Ft x {{ property.lotsizelength }} Ft

{{ property.bedstotal }} Beds | {{ property.bathstotal }} Baths

Sq. Ft {{ property.sqfttotal.toLocaleString() }}

CC/Maint.{{ property.maintenancecommonfee | toCurrency }}

RE Tax {{ property.taxamount | toCurrency }}

Featured OPEN HOUSE:
{{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}
For sale For rent {{ property.price | toCurrency }} NEW RENTED UNDER CONTRACT Expired SOLD

{{ property?.neighbourhood?.name }}

{{ property?.borough?.name }}

{{ property.address }}

{{ property.propertysubtype }}

Building {{ property.buildingwidth }} Ft x {{ property.buildinglength }} Ft

Lot {{ property.lotsizewidth }} Ft x {{ property.lotsizelength }} Ft

{{ property.bedstotal }} Beds | {{ property.bathstotal }} Baths

Sq. Ft {{ property.sqfttotal.toLocaleString() }}

CC/Maint.{{ property.maintenancecommonfee | toCurrency }}

RE Tax {{ property.taxamount | toCurrency }}

Unit History Building History Save Search Map ViewDetailed View

{{ agent?.office?.officeaddress }}

Office {{ formatPhoneString(agent?.office?.phone) }}

Cell. {{ formatPhoneString(agent?.cellphone) }}

Contact

Languages: {{ agent?.languagesNames }}

View my other listings

{{agent?.reviews?.length ?? 0}} Reviews

{{ agent?.firstname }} {{ agent?.lastname }} currently has no active listings.

Huguenot

797 Woodrow Rd, Staten Island, NY 10312

Introducing an exquisite custom-built palatial residence in Huguenot, Staten Island, this architectural masterpiece is designed for ultimate privacy, set back on a generous 105' by 134' lot. Spanning over 6,300 square feet, the home showcases a harmonious blend of elegance and functionality, exceeding all expectations. The striking main entrance features breathtaking double floating staircases, complemented by dramatic balconies that overlook the grand first floor. The expansive layout includes a chef's gourmet kitchen that seamlessly connects to a formal banquet dining room, ideal for hosting lavish gatherings. At the heart of the home lies a sunken great room with a fireplace, alongside a gracious formal living room, also equipped with a fireplace, and a sophisticated cherry wood professional home office. The opulent master suite offers an impressive 60 feet of open space, complete with a cozy fireplace and a luxurious bathroom, while each additional bedroom is thoughtfully designed with its own bathroom and custom closets. For entertainment, residents can indulge in a private oak bar lounge or retreat to the resort-style oasis, featuring a 28-foot inground heated saltwater pool, making this residence a true sanctuary.

Total Units: 1

For Sale: 0

For Rent: 0

Building type: Detached

Style: Colonial

Residential Features:

Central Air
Deck
Dryer
Fireplace
Garage Door Opener(s)
Laundry Area
Patio Garden
Pool
Washer
Other

Parking Attributes:

Built-In Garage

◀

►

MLS #{{ property.mlsnumber }}

OPEN HOUSE: {{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}

Selling agent commission: {{ property.co_broke_commission| toCurrency }}

Selling agent commission: {{ property.co_broke_commission }}{{ property.co_broke_commission_type }}

Days on Market: {{ property.dom }}

Expiration Date: {{ property.expireddate }}

Listed Price: {{ property.listprice | toCurrency }}

Sold Price: {{ property.closeprice | toCurrency }}

Days on Market: {{ property.dom }}

Close Date: {{ property.closedate }}

Listed Price: {{ property.listprice | toCurrency }}

Closed Price: {{ property.closeprice | toCurrency }}

Days on Market: {{ property.dom }}

Close Date: {{ property.closedate }}

Under Contract: {{ property.lastchangedate }}

Floor: {{ property.floornumber }}

Year built: {{ property.yearbuilt }}

Period built: {{ property.periodbuilt }}

Building type: {{ property.buildingtype }}

Pets Allowed: {{ property.petsallowed }}

Style: {{ property.style }}

Assessment included

Board approval included

Building amenities:

{{ amenity }}

Residential Features:

{{ feature }}

Commercial Features Interior:

{{ feature }}

Utilities:

{{ utility }}

Parking Attributes:

{{ parkingattribute }}

Parking Features:

{{ property.parkingfeaturesingle }}
{{ parkingfeature }}

Basement amenities:

{{ basementamenity }}

Exterior:

{{ exteriorItem }}

Virtual Tour

Bedrooms:	{{ property.bedstotal }}
Baths Full:	{{ property.bathsfull }}
Baths Half:	{{ property.bathshalf }}
Rooms:	{{ property.roomcount }}
Stories:	{{ property.stories }}
Building Size:	{{ property.buildingwidth }}' x {{ property.buildinglength }}'
Lot:	{{ property.lotsizewidth }}' x {{ property.lotsizelength }}'
Finished Sq. Ft.:	{{ property.sqfttotal \| toLocaleFormat }}
CC/Maintenance:	{{ property.maintenancecommonfee \| toCurrency }}
RE Tax:	{{ property.taxamount \| toCurrency }}
Families #:	{{ property.numberoffamilies }}

Contacts

{{ agent?.officeaddress }}

Office {{ formatPhoneString(agent?.officephone) }}

Cell. {{ formatPhoneString(agent?.cellphone) }}

Languages: {{ agent?.languages }}

View my other listings

Contact

Mortgage Calculator

Number of Years:

Interest Rate:

Amount of loan after down payment:

Monthly Payment:

Huguenot

797 Woodrow Rd, Staten Island, NY 10312

Residential Features:

Parking Attributes:

{{ property.neighbourhood?.name }}

{{ property.borough?.name }}

{{ property.projectname }}

{{ property.address }}

{{ property.listprice | toCurrency }}

Selling agent commission: {{ property.co_broke_commission| toCurrency }}

Selling agent commission: {{ property.co_broke_commission }}{{ property.co_broke_commission_type }}

Sold Price: {{ property.closeprice | toCurrency }}

Closed Price: {{ property.closeprice | toCurrency }}

Building amenities:

Residential Features:

Commercial Features Interior:

Utilities:

Parking Attributes:

Parking Features:

Basement amenities:

Exterior:

Virtual Tour

{{ property.propertysubtype }}

Contacts

Mortgage Calculator

{{ calc.monthly }}