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

Your search results

Overview

  • Updated On:
  • September 18, 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: $ 549,999
Property Lot Size: 0 ft2
Bedrooms: 3
Bathrooms: 2.5
TaxAnnualAmount: 4731
BathroomsThreeQuarter: 0
BathroomsFull: 2
InternetConsumerCommentYN: 1
CoListOfficeKey: 20141019170639868921000000
InternetAutomatedValuationDisplayYN: 1
ListAgentKey: 20180305151702426708000000
CoListAgentMobilePhone: 646-481-6444
StreetNumberNumeric: 87
ContractStatusChangeDate: 2024-08-26
ListAgentFullName: Huan Kuei Lo
InternetAddressDisplayYN: 1
CoListAgentKey: 20170427204744097186000000
OnMarketDate: 2024-08-26
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170639868921000000
CoListAgentFullName: Kin Wa Lam
ListAgentLastName: Lo
CumulativeDaysOnMarket: 104
TaxLot: 0006
CoListOfficeEmail: info@homesrusrealestate.com
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: 2024-08-26T20:48:07Z
ListAgentFirstName: Huan Kuei
CoListAgentEmail: mr.kinwalam@gmail.com
MajorChangeType: New Listing
LotSizeUnits: Square Feet
DocumentsCount: 0
CoListAgentPreferredPhone: 646-481-6444
CoListOfficeName: Homes R Us Realty of NY, Inc.
LotSizeSquareFeet: 1819
OwnerName: 42 Coursen Group
ListAgentOfficePhone: 347-335-7946
CoListAgentFax: 718-668-2639
ListingId: 2404838
CoListAgentStateLicense: 10401301649
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
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
PhotosCount: 21
CoListAgentMlsId: 16139
ListOfficeURL: http://www.statenislandhomesearch.com
ListAgentStateLicense: 10401313713
PhotosChangeTimestamp: 2024-08-26T20:48:07Z
BuildingAreaTotal: 1400
Stories: 2
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-09-18T13:19:12Z
ListOfficeMlsId: o20070
MlsStatus: Active
TaxBlock: 00006
LotSizeArea: 1819
SourceSystemID: M00000487
ParcelNumber: 00006-0006
ListOfficeEmail: info@homesrusrealestate.com
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-08-26T20:42:51Z
Directions: GPS
CoListAgentURL: https://www.facebook.com/mr.KinWaLam
MLSAreaMajor: Mariners Harbor
DaysOnMarket: 25
GarageSpaces: 0
CoListOfficeFax: 718-668-2639
MLSAreaMinor: Mariners Harbor
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_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
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

Fri 20 Sep
Sat 21 Sep
Sun 22 Sep
Mon 23 Sep
Tue 24 Sep
Wed 25 Sep
Thu 26 Sep
Fri 27 Sep
Sat 28 Sep
Sun 29 Sep
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 September 20, 2024

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

753 Quincy Avenue, Staten Island, NY 10305

$ 699,900
Ocean lovers! 2 family semi near Verrazzano Bridge. Main house offers 3 bedrooms/3 bathroo ...
4 3.25details
Residential
Active

707 Marcy Avenue, Staten Island, NY 10312

$ 1,499,900
New Construction Center Hall Colonial in prime Huguenot! Built with quality craftsmanship ...
Residential
Active

31 Cannon Avenue, Staten Island, NY 10314

$ 828,000
Come discover this beautiful detached single family home in Travis Chelsea in excellent mo ...
3 3.5details

Schedule a tour

Fri 20 Sep
Sat 21 Sep
Sun 22 Sep
Mon 23 Sep
Tue 24 Sep
Wed 25 Sep
Thu 26 Sep
Fri 27 Sep
Sat 28 Sep
Sun 29 Sep
In Person
Video Chat
Your information
  • Advanced Search

    More Search Options
  • Our Listings

  • Mortgage Calculator

  • Reset Password

Compare Listings