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

Your search results

Overview

  • Updated On:
  • December 23, 2024
  • 3 Bedrooms
  • 2.5 Bathrooms
  • 0 Garage Spaces
  • 1400 Size Sft
  • 2003 Year Built

Welcome to this stunning semi-detached single-family home in the desirable Mariners Harbor area. Boasting three bedrooms and three bathrooms, this residence offers a perfect blend of elegance and functionality. The allure of this property extends to its full finished basement, providing an additional versatile space for entertainment, a home office, or even a guest suite. The location is not just a place to live; it’s a lifestyle offering comfort and accessibility. With its thoughtful design, ample living space, and strategic location, this beautiful home invites you to experience the best of Mariners Harbor living. Don’t miss the opportunity to call this gem your own!

Address: 87 Andros Avenue, Staten Island, NY 10303
State/County:
Zip: 10303
Country: United States
Open In Google Maps
Property Id : 549924
Price: $ 529,000
Property Lot Size: 0 ft2
Bedrooms: 3
Bathrooms: 2.5
TaxAnnualAmount: 4731
BathroomsThreeQuarter: 0
BathroomsFull: 2
InternetConsumerCommentYN: 1
CoListOfficeKey: 20141019170639868921000000
InternetAutomatedValuationDisplayYN: 1
BuyerAgentMobilePhone: 917-763-2196
ListAgentKey: 20180305151702426708000000
CoListAgentMobilePhone: 646-481-6444
StreetNumberNumeric: 87
ContractStatusChangeDate: 2024-12-23
ListAgentFullName: Huan Kuei Lo
InternetAddressDisplayYN: 1
CoListAgentKey: 20170427204744097186000000
BuyerAgentFullName: William Bush
OnMarketDate: 2024-11-20
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170639868921000000
CoListAgentFullName: Kin Wa Lam
BuyerAgentKey: 20240906190520304852000000
BuyerOfficeKey: 20200814023207717338000000
ListAgentLastName: Lo
CumulativeDaysOnMarket: 200
TaxLot: 0006
CoListOfficeEmail: info@homesrusrealestate.com
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: 2024-12-23T16:12:03Z
ListAgentFirstName: Huan Kuei
CoListAgentEmail: mr.kinwalam@gmail.com
PriceChangeTimestamp: 2024-10-30T13:21:59Z
BuyerOfficeURL: http://www.defalcorealty.com
BuyerOfficeName: Matias Real Estate
MajorChangeType: Status Change
OffMarketDate: 2024-12-23
BuyerOfficeEmail: sargejvm@yahoo.com
LotSizeUnits: Square Feet
DocumentsCount: 0
BuyerAgentMlsId: 19848
CoListAgentPreferredPhone: 646-481-6444
CoListOfficeName: Homes R Us Realty of NY, Inc.
LotSizeSquareFeet: 1819
BuyerAgentLastName: Bush
OwnerName: 42 Coursen Group
ListAgentOfficePhone: 347-335-7946
CoListAgentFax: 718-668-2639
ListingId: 2404838
CoListAgentStateLicense: 10401301649
BuyerAgentOfficePhone: 718-987-7900
CoListAgentFirstName: Kin Wa
YearBuilt: 2003
ListAgentPreferredPhone: 347-335-7946
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20240826204200757196000000
ArchitecturalStyle: Colonial
DocumentsAvailable: Property Owner Information
ListOfficeFax: 718-668-2639
StateOrProvince: NY
BuyerAgentStateLicense: 10401389168
CoListAgentLastName: Lam
ListOfficeName: Homes R Us Realty of NY, Inc.
CoListAgentOfficePhone: 646-481-6444
CoListOfficeURL: http://www.statenislandhomesearch.com
LotFeatures: Back
OriginatingSystemKey: 20240826204200757196000000
VideosCount: 0
BuyerOfficeFax: 718-980-9842
BuyerAgentFax: 718-980-9842
PhotosCount: 21
CoListAgentMlsId: 16139
ContingentDate: 2024-12-18
ListOfficeURL: http://www.statenislandhomesearch.com
ListAgentStateLicense: 10401313713
PhotosChangeTimestamp: 2024-08-26T20:48:07Z
BuildingAreaTotal: 1400
BuyerAgentPreferredPhone: 917-763-2196
Stories: 2
PurchaseContractDate: 2024-12-23
OriginatingSystemName: Staten Island Multiple Listing Service
OriginalListPrice: 549999
Sewer: City
ListingContractDate: 2024-08-24
StreetSuffix: Avenue
CoListOfficeMlsId: o20070
OriginatingSystemID: M00000487
LotSizeDimensions: 20x91
StreetNumber: 87
StreetName: Andros
Electric: 220 Volts
ListAgentEmail: lo_0905@hotmail.com
ModificationTimestamp: 2024-12-23T16:12:25Z
ListOfficeMlsId: o20070
BuyerAgentEmail: willbrealagent@gmail.com
MlsStatus: Pending
TaxBlock: 00006
LotSizeArea: 1819
SourceSystemID: M00000487
ParcelNumber: 00006-0006
ListOfficeEmail: info@homesrusrealestate.com
BuyerAgentFirstName: William
ListAgentMlsId: 16621
ParkingFeatures: Off Street
Zoning: R3X
DocumentsChangeTimestamp: 2024-08-26T20:48:07Z
Heating: Forced Air,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Stone,Vinyl Siding
ListAgentFax: 718-668-2639
MajorChangeTimestamp: 2024-12-23T16:12:05Z
Directions: GPS
CoListAgentURL: https://www.facebook.com/mr.KinWaLam
MLSAreaMajor: Mariners Harbor
DaysOnMarket: 121
PendingTimestamp: 2024-12-23T16:12:03Z
BuyerAgentMiddleName: A
GarageSpaces: 0
CoListOfficeFax: 718-668-2639
MLSAreaMinor: Mariners Harbor
BuyerOfficeMlsId: o11412
BathroomsTotalDecimal: 2.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: 4731
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 20x91
General_sp_Property_sp_Info_co_Condition: Excellent
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_Cable: Yes
General_sp_Property_sp_Info_co_Waterview: No
General_sp_Property_sp_Info_co_Cooling: Yes
Sewer_co_City3: 1
Appliances_co_Microwave: 1
Dining_sp_Room_co_Combination: 1
Electric_co_220: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Forced_sp_Air: 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_Stone: 1
Siding_co_Vinyl_sp_Siding: 1
Yard_co_Back: 1
Other Features
Has Heating System
Microwave

Schedule a tour

Mon 17 Feb
Tue 18 Feb
Wed 19 Feb
Thu 20 Feb
Fri 21 Feb
Sat 22 Feb
Sun 23 Feb
Mon 24 Feb
Tue 25 Feb
Wed 26 Feb
In Person
Video Chat
Your information

Amenities and Features

Other Features
Has Heating System
Microwave

Listing Office Homes R Us Realty of NY, Inc.

Staten Island Board of Realtors

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

459 Klondike Avenue, Staten Island, NY 10314

$ 998,000
Welcome to this semi detached large fully renovated two family house in the heart of NEW S ...
Residential
Pending

134 Alex Circle, Staten Island, NY 10305

$ 699,000
This captivating townhouse epitomizes timeless charm and modern convenience, offering an i ...
3 2.25details
Residential
Pending

47 Hunter Place, Staten Island, NY 10301

$ 979,000
Welcome to 47 Hunter Place, a stunning 4-bedroom, 4-bathroom home nestled in the heart of ...
4 3.25details

Schedule a tour

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

    More Search Options
  • Our Listings

  • Mortgage Calculator

  • Reset Password

Compare Listings