• Neuhaus Realty Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act.

Your search results
Pending

249 Lindenwood Road, Staten Island, NY 10308

$ 599,000
249 Lindenwood Road, Staten Island, NY 10308, ,

Overview

  • Updated On:
  • August 28, 2025
  • 3 Bedrooms
  • 1 Bathroom
  • 1 Garage Space
  • 897 Size Sft
  • 1935 Year Built

Attention Builders & Investors! Don’t miss your chance to unlock the potential of this property. Located in a desirable neighborhood close to schools and transportation, this home offers a blank canvas for visionaries ready to transform and create a lucrative masterpiece. Whether you’re looking to renovate for resale, develop a new project, or add value to your portfolio, this property provides endless possibilities. Contact your architect today to explore zoning and the full potential of this property.
Key Features:
Spacious lot with development potential
Solid foundational structure ready for customization.
Close to amenities, schools, and transportation.
Opportunity to maximize ROI through strategic upgrades.
Why Invest?
This is an ideal project for builders and seasoned investors seeking a high-potential property with room for growth.
Bring your design ideas and craftsmanship to turn this property into a stunning home or profitable development.
Act Now!
Contact your architect today to explore renovation plans, zoning options, and the full potential of this property.
Don’t wait—this opportunity won’t last!

Address: 249 Lindenwood Road, Staten Island, NY 10308
State/County:
Zip: 10308
Country: United States
Open In Google Maps
Property Id : 1042765
Price: $ 599,000
Property Lot Size: 0 ft2
Bedrooms: 3
Bathrooms: 1
TaxAnnualAmount: 5652
BathroomsThreeQuarter: 0
BathroomsFull: 1
InternetConsumerCommentYN: 1
CoBuyerAgentMobilePhone: 917-856-2012
InternetAutomatedValuationDisplayYN: 1
CoBuyerAgentKey: 20141019181345358080000000
BuyerAgentMobilePhone: 917-683-5990
ListAgentKey: 20220324134707119230000000
StreetNumberNumeric: 249
ContractStatusChangeDate: 2025-08-28
CoBuyerAgentFullName: Gennady Gary Papirov
ListAgentFullName: Gina DeRosa
InternetAddressDisplayYN: 1
CoBuyerOfficeKey: 20141019170639868921000000
BuyerAgentFullName: Leor Mizrahi
OnMarketDate: 2025-05-07
BathroomsHalf: 0
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20190122211707371755000000
BuyerAgentKey: 20220630144707874160000000
BuyerOfficeKey: 20141019170639868921000000
ListAgentLastName: DeRosa
Cooling: Units
CumulativeDaysOnMarket: 115
TaxLot: 57
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: August 28, 2025 at 02:21pm
ListAgentFirstName: Gina
PriceChangeTimestamp: July 7, 2025 at 03:49pm
BuyerOfficeURL: http://www.statenislandhomesearch.com
BuyerOfficeName: Homes R Us Realty of NY, Inc.
MajorChangeType: Status Change
OffMarketDate: 2025-08-28
BuyerOfficeEmail: HRURealty@gmail.com
LotSizeUnits: Square Feet
DocumentsCount: 1
BuyerAgentMlsId: 18814
CoBuyerOfficeEmail: HRURealty@gmail.com
LotSizeSquareFeet: 3180
BuyerAgentLastName: Mizrahi
OwnerName: Amber Larson
BuyerAgentURL: http://blinq.me/fHpeuu5y4siAtwpUVAoL
ListAgentOfficePhone: 347-838-0008
ListingId: 2502600
BuyerAgentOfficePhone: 917-683-5990
CoBuyerAgentEmail: gary.papirov@gmail.com
YearBuilt: 1935
ListAgentPreferredPhone: 347-838-0008
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250506152227427330000000
CoBuyerAgentOfficePhone: 718-668-2550
ArchitecturalStyle: Ranch
CoBuyerOfficeName: Homes R Us Realty of NY, Inc.
CoBuyerAgentPreferredPhone: 917-856-2012
StateOrProvince: NY
BuyerAgentStateLicense: 10401366939
ListOfficeName: Coldwell Banker Advantage
LotFeatures: Back
OriginatingSystemKey: 20250506152227427330000000
VideosCount: 0
BuyerOfficeFax: 718-668-2639
BuyerAgentFax: 718-668-2639
PhotosCount: 18
CoBuyerAgentMlsId: 2070
CoBuyerOfficeFax: 718-668-2639
ContingentDate: 2025-07-28
ListOfficeURL: cbadvantagenyc.com
ListAgentStateLicense: 10401362849
PhotosChangeTimestamp: May 7, 2025 at 06:32pm
BuildingAreaTotal: 897
CoBuyerAgentURL: http://garypapirov.com
BuyerAgentPreferredPhone: 917-683-5990
Stories: 1
PurchaseContractDate: 2025-08-28
OriginatingSystemName: Staten Island Multiple Listing Service
CoBuyerAgentFax: 718-668-2639
OriginalListPrice: 699000
Sewer: City
ListingContractDate: 2025-05-05
StreetSuffix: Road
OriginatingSystemID: M00000487
LotSizeDimensions: 68x74
StreetNumber: 249
StreetName: Lindenwood
Electric: 110
ListAgentEmail: realtorginaderosa@gmail.com
ModificationTimestamp: August 28, 2025 at 02:21pm
CoBuyerAgentStateLicense: 30PA0885250
ListOfficeMlsId: o11321
BuyerAgentEmail: leormizrahirealty@gmail.com
MlsStatus: Pending
CoBuyerAgentLastName: Papirov
TaxBlock: 05247
LotSizeArea: 3180
SourceSystemID: M00000487
CoBuyerAgentFirstName: Gennady Gary
ParcelNumber: 05247-57
ListOfficeEmail: info@cbadvantagenyc.com
BuyerAgentFirstName: Leor
ListAgentMlsId: 17745
CoBuyerOfficeMlsId: o20070
ParkingFeatures: Off Street,Detached
Zoning: R3A
DocumentsChangeTimestamp: 2025-05-07T18:32:32Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Vinyl Siding
ListAgentFax: 718-447-8225
CoBuyerOfficeURL: http://www.statenislandhomesearch.com
MajorChangeTimestamp: August 28, 2025 at 02:21pm
Directions: Use GPS
MLSAreaMajor: Great Kills
DaysOnMarket: 115
PendingTimestamp: 2025-08-28T14:21:34Z
GarageSpaces: 1
MLSAreaMinor: Great Kills
BuyerOfficeMlsId: o20070
BathroomsTotalDecimal: 1
AddressLegal_co_Section: South Shore
ContractLocation_sp_Information_co_CofO: No
ContractLocation_sp_Information_co_REO: No
General_sp_Property_sp_Info_co_Stories2: 1
General_sp_Property_sp_Info_co_Style2: Ranch
General_sp_Property_sp_Info_co_Taxes2: 5652
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 68x74
General_sp_Property_sp_Info_co_Irregular: Yes
General_sp_Property_sp_Info_co_Condition: Good
General_sp_Property_sp_Info_co_34_sp_Baths: 0
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
Sewer_co_City3: 1
Appliances_co_Compactor: 1
Dining_sp_Room_co_None: 1
Electric_co_110: 1
Exterior_co_Patio: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Hot_sp_Water2: 1
Parking_co_Off_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Living_sp_Room_co_Formal2: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Primary_sp_Bedroom_co_Shared_sp_Bath: 1
Garage_sp_Location_co_Detached: 1
Siding_co_Vinyl_sp_Siding: 1
Yard_co_Back: 1
Broker_sp_Load_co_Broker_sp_Load_sp_Edit: Office
Other Features
Compactor
Has Cooling System
Has Garage
Has Heating System
Patio

Schedule a tour

Mon 01 Sep
Tue 02 Sep
Wed 03 Sep
Thu 04 Sep
Fri 05 Sep
Sat 06 Sep
Sun 07 Sep
Mon 08 Sep
Tue 09 Sep
Wed 10 Sep
In Person
Video Chat
Your information

Amenities and Features

Other Features
Compactor
Has Cooling System
Has Garage
Has Heating System
Patio

Listing Office Coldwell Banker Advantage

Staten Island Board of Realtors

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

Map

Transport
Supermarkets
Schools
Restaurants
Pharmacies
Hospitals

Virtual Tour

Property Reviews

You need to login in order to post a review

Similar Listings

Residential
Active

1784 Arthur Kill Road, Staten Island, NY 10312

$ 650,000
Introducing this charming townhouse-style single-family home in Staten Island with no HOA ...
3 1.25details
Residential
Active

20 Notus Avenue, Staten Island, NY 10312

$ 740,000
Beautifully maintained and fully attached, this custom 3-bedroom, 3-bath townhouse offers ...
3 2.25details
Residential
Active

523 Woolley Avenue, Staten Island, NY 10314

$ 738,000
Welcome to this newly renovated fully detached single-family home, where modern design mee ...

Schedule a tour

Mon 01 Sep
Tue 02 Sep
Wed 03 Sep
Thu 04 Sep
Fri 05 Sep
Sat 06 Sep
Sun 07 Sep
Mon 08 Sep
Tue 09 Sep
Wed 10 Sep
In Person
Video Chat
Your information
  • Advanced Search

    More Search Options
  • Our Listings

  • Mortgage Calculator

  • Reset Password

Compare Listings