No results found.
Try adjusting or resetting your filters.
{{ agent?.kind }}
{{ agent?.firstname }} {{ agent?.lastname }}
{{ agent?.type }}
{{ agent?.office?.officename }}
{{ agent?.office?.officeaddress }}
Office {{ formatPhoneString(agent?.office?.phone) }}
Cell. {{ formatPhoneString(agent?.cellphone) }}
Languages: {{ agent?.languagesNames }}
{{ agent?.text }}
{{ agent?.biography }}
{{agent?.rating}}
{{agent?.reviews?.length ?? 0}} Reviews
{{ review.created_at }}
{{ review.name }}
{{ agent?.firstname }} {{ agent?.lastname }} currently has no active listings.

797 Woodrow Rd, Staten Island, NY 10312

Listed Price: $2,358,000
Sold Price: $2,250,000
4 Bed / 2 Bath , 6,300 Sq Ft · Single Family

EXQUISITE, IN A CLASS OF ITS OWN CUSTOM BUILT PALATIAL RESIDENCE SET BACK FOR ULTIMATE PRIVACY. SITUATED ON A 105' BY 134' LOT. THIS 4+ BEDROOM, 5 BATH, CENTER HALL WORK OF ART BOASTS 6,300+ SQUARE FEET OF WELL-APPOINTED LIVING SPACE FAR BEYOND ANYONE'S EXPECTATIONS. THE MAIN ENTRANCE IS A REAL SHOW STOPPER WITH STUNNING DOUBLE FLOATING ENTRY STAIRCASES & DRAMATIC BALCONIES OVERLOOKING THE 1ST FLOOR. A 33 'CHEFS GOURMENT KITCHEN GIVES WAY TO A KINGS & QUEENS FORMAL BANQUET DINING ROOM. CENTER STAGE IS A SUNKEN GREAT ROOM W/ FIREPLACE, GRANDEOUS FORMAL LIVING ROOM W/ FIREPLACE AND A CUSTOM CHERRY WOOD PROFESSIONAL HOME OFFICE. THE MASTER BEDROOM IS OUTSTANDING BOASTING 60' OF OPEN SPACE FIT FOR ROYALTY WITH A FIREPLACE AND LAVISH BATHROOM, THE WALK IN CLOSET IS UNIMAGINABLE. EACH BEDROOM HOSTS ITS OWN BATHROOM AND CUSTOM CLOSETS. BUT WAIT THERES MORE! WHY GO OUT WHEN YOU CAN ENTERTAIN IN YOUR OWN PRIVATE OAK BAR LOUNGE OR STROLL OUT TO YOUR RESORT STYLE OASIS WITH A 28' INGROUD HEATED SALTWATER POOL. IF MORE ROOM IS WHAT YOU NEED THIS HOME HAS AN AMAZING 3000+ SQ FT FINISHED WALK OUT BASEMENT WITH UNLIMITED POSSIBILITIES AND A 3 CAR GARAGE. THE ENTIRE ESTATE IS HEATED BY 7 ZONES OF RADIANT FLOORING AND HAS 5 ZONE CENTRAL AIR FOR ADDED EFFICIENCY. TOUR THIS MAGNIFICENT HOME.

Building type: Detached

Residential Features:

  • Central Air
  • Deck
  • Dryer
  • Fireplace
  • Garage Door Opener(s)
  • Laundry Area
  • Patio Garden
  • Pool
  • Washer
  • Other
{{ property.neighbourhood?.name }}
{{ property.borough?.name }}
{{ property.projectname }}

{{ property.address }}

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

{{ property.listprice | toCurrency }}

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 }}

{{ property.publicremarks }}

{{ property.propertyType }}
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 }}
All listings are subject to errors, omissions, price change, withdrawal and sale without notice.
Data source copyright: © 2026 BROOKLYNMLS USA. All rights reserved.
{{ property.propertysubtype }}
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?.kind }}
{{ agent?.firstname }} {{ agent?.lastname }}
{{ agent?.type }}
{{ agent?.officename }}
{{ agent?.officeaddress }}
Office {{ formatPhoneString(agent?.officephone) }}
Cell. {{ formatPhoneString(agent?.cellphone) }}
Languages: {{ agent?.languages }}
{{ agent?.text }}
Mortgage Calculator

{{ calc.monthly }}

{{ property.matrix_unique_id }}