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

Your search results
Active

87 Louis Street, Staten Island, NY 10301

$ 775,000
87 Louis Street, Staten Island, NY 10301, ,

Overview

  • Updated On:
  • June 14, 2025
  • 3 Bedrooms
  • 1.5 Bathrooms
  • 0 Garage Spaces
  • 960 Size Sft
  • 1960 Year Built

HandyMan Special with Spectacular views of downtown Manhattan and the VZ bridge! A spectacularly designed home that unfortunately fell into disrepair. This 3 bedroom semi-detached home (with a master bedroom that has the view of downtown) boasts an open layout living area with the focus on the spectacular view of the downtown Manhattan area.

LEVEL 0: Walkout Basement. Utility room, Office/Den, Family room with SGD to patio & backyard.
LEVEL 1: Entry Foyer, small eat in kitchen, coat closet, open Living room/dining room area with sprawling SGD to large deck that overlooks the impressive skyline.
LEVEL 2: Master bedroom with large windows to capture the skyline, Bedroom #2, Bedroom #3, Full Bathroom.
LEVEL 3: Attic for storage.

*Please note that the the photos have been digitally enhanced. Some show the house in its current state, others show what the finished area would look like if construction and furniture are added.

Address: 87 Louis Street, Staten Island, NY 10301
State/County:
Zip: 10301
Country: United States
Open In Google Maps
Property Id : 1005026
Price: $ 775,000
Property Lot Size: 0 ft2
Rooms: 10
Bedrooms: 3
Bathrooms: 1.5
TaxAnnualAmount: 4587
BathroomsThreeQuarter: 0
BathroomsFull: 1
InternetConsumerCommentYN: 1
ListAgentKey: 20141019181342278047000000
StreetNumberNumeric: 87
ContractStatusChangeDate: 2025-06-14
ListAgentFullName: Angelo Pappalardo
InternetAddressDisplayYN: 1
ListAgentMobilePhone: 646-210-8265
OnMarketDate: 2025-06-14
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170639574038000000
ListAgentLastName: Pappalardo
CumulativeDaysOnMarket: 0
TaxLot: 0089
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: June 14, 2025 at 03:00pm
ListAgentFirstName: Angelo
MajorChangeType: New Listing
LotSizeUnits: Square Feet
DocumentsCount: 0
LotSizeSquareFeet: 4140
OwnerName: Steven P. Plyer RE Irr Trust
ListingId: 2503465
YearBuilt: 1960
ListAgentURL: http://c21papp.com
ListAgentPreferredPhone: 646-210-8265
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250603154432360971000000
ArchitecturalStyle: Colonial
ListOfficeFax: 718-273-4348
StateOrProvince: NY
ListOfficeName: Century 21 Papp Realty
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20250603154432360971000000
VideosCount: 1
PhotosCount: 50
ListAgentDirectPhone: 718-727-6900
ListOfficeURL: http://www.c21papp.com
ListAgentStateLicense: 10311207495
PhotosChangeTimestamp: June 14, 2025 at 03:00pm
BuildingAreaTotal: 960
Stories: 2
OriginatingSystemName: Staten Island Multiple Listing Service
OriginalListPrice: 775000
Sewer: City
ListingContractDate: 2025-06-14
StreetSuffix: Street
OriginatingSystemID: M00000487
LotSizeDimensions: 45 x 97
StreetNumber: 87
StreetName: Louis
Electric: 110
ListAgentEmail: angelo.pappalardo@hotmail.com
ModificationTimestamp: June 14, 2025 at 05:03pm
ListOfficeMlsId: o19501
MlsStatus: Active
VideosChangeTimestamp: 2025-06-14T15:00:56Z
TaxBlock: 00580
LotSizeArea: 4140
SourceSystemID: M00000487
ParcelNumber: 00580-0089
ListOfficeEmail: c21papp@c21papp.com
ListAgentMlsId: 2557
ParkingFeatures: Off Street
Zoning: R3-2
DocumentsChangeTimestamp: 2025-06-14T15:00:56Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Wood Siding
ListAgentFax: 718-273-4348
MajorChangeTimestamp: June 14, 2025 at 03:00pm
Directions: Howard ave then a right onto Louis St. House is located on the left in between Howard Ave and Sunrise Terrace.
MLSAreaMajor: Grymes Hill
DaysOnMarket: 0
GarageSpaces: 0
MLSAreaMinor: Grymes Hill
BathroomsTotalDecimal: 1.5
AddressLegal_co_Section: North Shore
ContractLocation_sp_Information_co_CofO: Yes
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: 4587
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 45 x 97
General_sp_Property_sp_Info_co_Irregular: Y
General_sp_Property_sp_Info_co_Condition: Poor
General_sp_Property_sp_Info_co_34_sp_Baths: 0
General_sp_Property_sp_Info_co_Half_sp_Baths: 1
General_sp_Property_sp_Info_co_Waterview: Yes
General_sp_Property_sp_Info_co_Cooling: No
General_sp_Property_sp_Info_co_HOA_sp_YN: No
Sewer_co_City3: 1
Dining_sp_Room_co_Combination: 1
Electric_co_110: 1
Exterior_co_Deck: 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_Combination2: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Primary_sp_Bedroom_co_Shared_sp_Bath: 1
Garage_sp_Location_co_None4: 1
Siding_co_Wood_sp_Siding: 1
Yard_co_Back: 1
Yard_co_Front: 1
Yard_co_Side: 1
Other Features
Deck
Has Heating System
Patio

Schedule a tour

Sun 15 Jun
Mon 16 Jun
Tue 17 Jun
Wed 18 Jun
Thu 19 Jun
Fri 20 Jun
Sat 21 Jun
Sun 22 Jun
Mon 23 Jun
Tue 24 Jun
In Person
Video Chat
Your information

Amenities and Features

Other Features
Deck
Has Heating System
Patio

Listing Office Century 21 Papp Realty

Staten Island Board of Realtors

© 2024 Staten Island Multiple Listing Service. All rights reserved. Information deemed reliable but not guaranteed. Data last updated June 15, 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

32 Scribner Avenue, Staten Island, NY 10301

$ 888,000
Welcome to this exquisite four years old side hall colonial, perfectly nestled in the vibr ...
Residential
Active

30 Regis Drive, 76, Staten Island, NY 10314

$ 549,000
MOVE RIGHT INTO THIS 3 BEDROOM/2 BATH TOWN HOME ON AN OVERSIZED LOT. WHAT MAKES THIS UNIT ...
3 1.75details
Residential
Pending

16 Astor Avenue, Staten Island, NY 10314

$ 699,888
Welcome to this beautifully maintained 3-bedroom, 2-bathroom semi-detached home, ideally s ...
3 1.75details

Schedule a tour

Sun 15 Jun
Mon 16 Jun
Tue 17 Jun
Wed 18 Jun
Thu 19 Jun
Fri 20 Jun
Sat 21 Jun
Sun 22 Jun
Mon 23 Jun
Tue 24 Jun
In Person
Video Chat
Your information
  • Advanced Search

    More Search Options
  • Our Listings

  • Mortgage Calculator

  • Reset Password

Compare Listings