Your search results

797 Woodrow Road, Staten Island, NY 10312

$ 2,358,000
797 Woodrow Road, Staten Island, NY 10312, ,

Overview

  • Updated On:
  • April 1, 2024
  • 4 Bedrooms
  • 4.25 Bathrooms
  • 3 Garage Spaces
  • 6300 Size Sft
  • 2007 Year Built

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. SCHEDULE A TOUR OF THIS MAGNIFICENT HOME. ‘PRICED TO SELL, SELLER IS MOTIVATED’.

Address: 797 Woodrow Road, Staten Island, NY 10312
State/County:
Zip: 10312
Country: United States
Open In Google Maps
Property Id : 45500
Price: $ 2,358,000
Property Lot Size: 0 ft2
Rooms: 7
Bedrooms: 4
Bathrooms: 4.25
TaxAnnualAmount: 15719
BathroomsThreeQuarter: 3
BathroomsFull: 2
InternetConsumerCommentYN: 1
CoBuyerAgentMobilePhone: 917-856-2012
InternetAutomatedValuationDisplayYN: 1
CoBuyerAgentKey: 20141019181345358080000000
BuyerAgentMobilePhone: 718-702-9948
ListAgentKey: 20141019181339914767000000
StreetNumberNumeric: 797
ContractStatusChangeDate: 2024-02-22
CoBuyerAgentFullName: Gennady Gary Papirov
ListAgentFullName: Sean Cusick
InternetAddressDisplayYN: 1
CoBuyerOfficeKey: 20141019170639868921000000
BuyerAgentFullName: Christian Jackson
OnMarketDate: 2023-11-29
BathroomsHalf: 0
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170639528220000000
BuyerAgentKey: 20190301210207465291000000
BuyerOfficeKey: 20141019170639868921000000
ListAgentLastName: Cusick
CumulativeDaysOnMarket: 224
TaxLot: 0007
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: 2024-02-22T14:21:10Z
ListAgentFirstName: Sean
PriceChangeTimestamp: 2023-10-28T16:03:13Z
BuyerOfficeURL: http://www.statenislandhomesearch.com
BuyerOfficeName: Homes R Us Realty of NY, Inc.
MajorChangeType: Status Change
OffMarketDate: 2024-02-21
BuyerOfficeEmail: hrurealty@gmail.com
LotSizeUnits: Square Feet
DocumentsCount: 0
CoBuyerOfficePhone: 718-668-2550
BuyerAgentMlsId: 17211
CoBuyerOfficeEmail: hrurealty@gmail.com
LotSizeSquareFeet: 14070
BuyerAgentLastName: Jackson
WindowFeatures: Skylight(s)
OwnerName: B. R.
ListingId: 1163102
BuyerAgentOfficePhone: 718-668-2550
SubAgencyCompensationType: %
CoBuyerAgentEmail: gary.papirov@gmail.com
YearBuilt: 2007
ListAgentPreferredPhone: 917-709-4877
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20230521192925452005000000
CoBuyerAgentOfficePhone: 718-668-2550
ArchitecturalStyle: Colonial
DocumentsAvailable: Property Owner Information
CoBuyerOfficeName: Homes R Us Realty of NY, Inc.
ListOfficeFax: 718-987-3225
CoBuyerAgentPreferredPhone: 718-668-2639
StateOrProvince: NY
BuyerAgentStateLicense: 10401326911
ListOfficeName: Neuhaus Realty, Inc.
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20230521192925452005000000
VideosCount: 0
BuyerOfficeFax: 718-668-2639
PhotosCount: 83
CoBuyerAgentMlsId: 2070
CoBuyerOfficeFax: 718-668-2639
ContingentDate: 2024-02-20
ListOfficeURL: https://www.neuhausrealty.com
ListAgentStateLicense: 10301210624
BuyerOfficePhone: 718-668-2550
PhotosChangeTimestamp: 2023-07-12T21:53:00Z
BuildingAreaTotal: 6300
CoBuyerAgentURL: http://garypapirov.com
BuyerAgentPreferredPhone: 718-668-2550
SubAgencyCompensation: 0.00
Stories: 2
PurchaseContractDate: 2024-02-21
OriginatingSystemName: Staten Island Multiple Listing Service
CoBuyerAgentFax: 718-668-2639
PoolFeatures: In Ground
OriginalListPrice: 2689800
Sewer: City
ListingContractDate: 2023-07-12
StreetSuffix: Road
OriginatingSystemID: M00000487
LotSizeDimensions: 53' X 60'
StreetNumber: 797
StreetName: Woodrow
Electric: 220 Volts
ListAgentEmail: kce48@aol.com
ModificationTimestamp: 2024-02-22T14:21:54Z
CoBuyerAgentStateLicense: 30PA0885250
ListOfficeMlsId: o19001
BuyerAgentEmail: christianhomesrus@gmail.com
MlsStatus: Pending
CoBuyerAgentLastName: Papirov
TaxBlock: 06016
LotSizeArea: 14070
SourceSystemID: M00000487
CoBuyerAgentFirstName: Gennady Gary
ParcelNumber: 06016-0007
ListOfficeEmail: vianeuhaus@aol.com
BuyerAgentFirstName: Christian
ListAgentMlsId: 13647
CoBuyerOfficeMlsId: o20070
ParkingFeatures: Off Street
Zoning: R3-X
DocumentsChangeTimestamp: 2023-07-12T21:45:29Z
Heating: Forced Air,Natural Gas,Other
YearBuiltDetails: Approx
ConstructionMaterials: Stucco
CoBuyerOfficeURL: http://www.statenislandhomesearch.com
MajorChangeTimestamp: 2024-02-22T14:21:12Z
Directions: Woodrow Road, C/S Everton Avenue.
FireplaceFeatures: Living Room,Master Bedroom
MLSAreaMajor: Huguenot
DaysOnMarket: 224
PendingTimestamp: 2024-02-22T14:21:10Z
GarageSpaces: 3
MLSAreaMinor: Huguenot
BuyerOfficeMlsId: o20070
ListOfficePhone: 718-979-3400
CompensationDisclaimer: The listing broker's offer of compensation is made only to participants of the MLS where the listing is filed.
BathroomsTotalDecimal: 4.25
AddressLegal_co_Section: South Shore
ContractLocation_sp_Information_co_CofO: No
ContractLocation_sp_Information_co_REO: No
General_sp_Property_sp_Info_co_Stories2: 2
General_sp_Property_sp_Info_co_Style2: Colonial
General_sp_Property_sp_Info_co_Taxes2: 15719
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 105' X 134'
General_sp_Property_sp_Info_co_Condition: Excellent
General_sp_Property_sp_Info_co_Half_sp_Baths: 0
General_sp_Property_sp_Info_co_Cable: Yes
General_sp_Property_sp_Info_co_Waterview: No
General_sp_Property_sp_Info_co_Cooling: Yes
General_sp_Property_sp_Info_co_Fireplace: Yes
Sewer_co_City3: 1
Appliances_co_Dishwasher: 1
Appliances_co_Dryer: 1
Appliances_co_Gas_sp_Grill: 1
Appliances_co_Microwave: 1
Appliances_co_Refrigerator: 1
Appliances_co_Washer: 1
Dining_sp_Room_co_Formal: 1
Dining_sp_Room_co_Separate: 1
Exterior_co_Balcony: 1
Exterior_co_Deck: 1
Exterior_co_Fence: 1
Exterior_co_Garage_sp_Door_sp_Opener: 1
Exterior_co_Grill: 1
Exterior_co_Patio: 1
Exterior_co_Sprinkler_sp_System: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Forced_sp_Air: 1
Heat_sp_System_co_Other2: 1
Interior_co_Ceiling_sp_Fan: 1
Interior_co_Central_sp_Vac: 1
Interior_co_Fireplace5: 1
Interior_co_Hot_sp_Tub: 1
Interior_co_Intercom: 1
Interior_co_Security_sp_System: 1
Interior_co_Walk_hyphen_in_sp_Closet: 1
Interior_co_Water_sp_Filter: 1
Interior_co_Wet_sp_Bar: 1
Parking_co_Off_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Kitchen_co_Pantry: 1
Kitchen_co_YardDeck_sp_Access: 1
Living_sp_Room_co_Fireplace3: 1
Living_sp_Room_co_Formal2: 1
Living_sp_Room_co_Separate2: 1
Main_sp_Bath_co_Bidet: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Main_sp_Bath_co_Jacuzzi2: 1
Main_sp_Bath_co_Separate_sp_Shower: 1
Main_sp_Bath_co_Skylight: 1
Primary_sp_Bedroom_co_Dressing_sp_Room: 1
Primary_sp_Bedroom_co_Fireplace4: 1
Primary_sp_Bedroom_co_Jacuzzi: 1
Primary_sp_Bedroom_co_Private_sp_Bath: 1
Primary_sp_Bedroom_co_Suite: 1
Garage_sp_Location_co_Built_hyphen_in: 1
Siding_co_Stucco: 1
Yard_co_Back: 1
Yard_co_Front: 1
Yard_co_Side: 1
Pool_co_In_sp_Ground: 1
Broker_sp_Load_co_Broker_sp_Load_sp_Edit: Office
Outdoor Details
balcony
Garage Attached
Other Features
Bidet
Ceiling Fan
Central Vac
Deck
Dishwasher
Dryer
Fence
Fireplace
Garage Door Opener
Gas Grill
Grill
Has Fireplace
Has Garage
Has Heating System
Hot Tub
Intercom
Microwave
Pantry
Patio
Refrigerator
Security System
Sprinkler System
Walk-in Closet
Walk-In Closet(s)
Washer
Water Filter
Wet Bar

Schedule a tour

Wed 24 Apr
Thu 25 Apr
Fri 26 Apr
Sat 27 Apr
Sun 28 Apr
Mon 29 Apr
Tue 30 Apr
Wed 01 May
Thu 02 May
Fri 03 May
In Person
Video Chat
Your information

Amenities and Features

Outdoor Details
balcony
Garage Attached
Other Features
Bidet
Ceiling Fan
Central Vac
Deck
Dishwasher
Dryer
Fence
Fireplace
Garage Door Opener
Gas Grill
Grill
Has Fireplace
Has Garage
Has Heating System
Hot Tub
Intercom
Microwave
Pantry
Patio
Refrigerator
Security System
Sprinkler System
Walk-in Closet
Walk-In Closet(s)
Washer
Water Filter
Wet Bar

Listing Office Neuhaus Realty, Inc.

Staten Island Board of Realtors

© 2024 Staten Island Multiple Listing Service. All rights reserved. Information deemed reliable but not guaranteed. Data last updated April 24, 2024

Map

Transport
Supermarkets
Schools
Restaurants
Pharmacies
Hospitals

Property Reviews

You need to login in order to post a review

Similar Listings

Residential
Active

65 Rae Avenue, Staten Island, NY 10312

$ 1,150,000
Large, spacious, and beautiful broad side High Ranch style home in SE Annadale. The main l ...
4 2.5details
Residential
Active

537 Van Duzer Street, Staten Island, NY ...

$ 599,000
Nestled amidst the historic streets of Stapleton, this captivating three-story residence o ...
3 2.25details
Residential
Active

162 Continental Place, A, Staten Island,...

$ 458,000
ATTENTION: INVESTORS, 1ST TIME HOME BUYERS,1ST TIME ON MARKET!! THIS 3 BED 2 BATH TOWNHOUS ...
3 1.5details

Schedule a tour

Wed 24 Apr
Thu 25 Apr
Fri 26 Apr
Sat 27 Apr
Sun 28 Apr
Mon 29 Apr
Tue 30 Apr
Wed 01 May
Thu 02 May
Fri 03 May
In Person
Video Chat
Your information

Compare Listings