• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • INTERNATIONAL PARTNERSHIP
  • THE ISLES GROUP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • The wealth report
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • property management
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • master trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON JUN 03 2025 AT 4:49 PM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

797 Woodrow Road

staten island, NY 10312

$2,250,000

  • 4 BR
    2 BA
    APPROX. 3,180 SF
  • sold

INTERESTED? LET'S CONNECT

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.

available on

8/1/2023

Details

3,180 Sq Ft

Single Family Home

$1,310 Annual Tax

Built in 2007

MLS/Listing ID 475909

2 Stories

BNY

Source of Data: BROOKLYN MLS

Interested in 797 Woodrow Road?