Property Id : 1035524
Price: $ 849,000
Property Lot Size: 1 ft2
Bedrooms: 3
Bathrooms: 1.75
TaxAnnualAmount: 11400
BathroomsThreeQuarter: 1
BathroomsFull: 1
CoListOfficeKey: 20181003230201979178000000
InternetAutomatedValuationDisplayYN: 1
ListAgentKey: 20141019181314795557000000
StreetNumberNumeric: 278
ContractStatusChangeDate: 2025-08-12
ListAgentFullName: Michael A Martin
InternetAddressDisplayYN: 1
CoListAgentKey: 20150118003002328598000000
ListAgentMobilePhone: 917-974-7540
OnMarketDate: 2025-08-12
BathroomsHalf: 0
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20181003230201979178000000
CoListAgentFullName: Thomas P Smith
ListAgentLastName: Martin
Cooling: Central
CumulativeDaysOnMarket: 0
TaxLot: 21
CoListOfficeEmail: contact@remaxedgeny.com
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: August 12, 2025 at 10:54pm
ListAgentFirstName: Michael
CoListAgentEmail: tommyt79123@gmail.com
MajorChangeType: New Listing
LotSizeUnits: Square Feet
DocumentsCount: 0
CoListAgentPreferredPhone: 718-510-2606
CoListOfficeName: Re/Max Edge
LotSizeSquareFeet: 22160
OwnerName: O Hara Real Estate
ListingId: 2504742
CoListAgentStateLicense: 10301218062
CoListAgentFirstName: Thomas
YearBuilt: 1960
ListAgentPreferredPhone: 917-974-7540
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250812192309200645000000
ArchitecturalStyle: Ranch
CoListAgentMiddleName: P
StateOrProvince: NY
CoListAgentLastName: Smith
ListOfficeName: Re/Max Edge
CoListAgentOfficePhone: 718-288-3835
CoListOfficeURL: http://www.remaxedgeny.com
LotFeatures: Back,Front
OriginatingSystemKey: 20250812192309200645000000
VideosCount: 0
PhotosCount: 35
CoListAgentMlsId: 13749
ListAgentDirectPhone: 718-288-3835
ListOfficeURL: http://www.remaxedgeny.com
ListAgentStateLicense: 10301212589
PhotosChangeTimestamp: August 12, 2025 at 10:54pm
BuildingAreaTotal: 1800
Stories: 2
CoListAgentDirectPhone: 718-510-2606
OriginatingSystemName: Staten Island Multiple Listing Service
OriginalListPrice: 849000
Sewer: Septic Tank
ListingContractDate: 2025-08-12
StreetSuffix: Avenue
CoListOfficeMlsId: o21226
OriginatingSystemID: M00000487
LotSizeDimensions: 80x232
StreetNumber: 278
StreetName: Lighthouse
Electric: 220 Volts
ListAgentEmail: mikemartinsiny@gmail.com
ModificationTimestamp: August 13, 2025 at 01:03am
ListOfficeMlsId: o21226
MlsStatus: Active
TaxBlock: 02272
LotSizeArea: 22160
SourceSystemID: M00000487
ParcelNumber: 02272-21
ListOfficeEmail: contact@remaxedgeny.com
ListAgentMlsId: 14045
ParkingFeatures: On Street
Zoning: R-1-2
DocumentsChangeTimestamp: 2025-08-12T22:54:50Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Wood Siding
MajorChangeTimestamp: August 12, 2025 at 10:54pm
ListAgentMiddleName: A
Directions: Use GPS
MLSAreaMajor: Lighthouse Hill
DaysOnMarket: 0
GarageSpaces: 0
MLSAreaMinor: Lighthouse Hill
BathroomsTotalDecimal: 1.75
AddressLegal_co_Section: Mid-Island
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: Ranch
General_sp_Property_sp_Info_co_Taxes2: 11400
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 80x232
General_sp_Property_sp_Info_co_Condition: Fair
General_sp_Property_sp_Info_co_34_sp_Baths: 1
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: Yes
General_sp_Property_sp_Info_co_Cooling: Yes
General_sp_Property_sp_Info_co_Fireplace: No
Sewer_co_Septic: 1
Appliances_co_Dishwasher: 1
Appliances_co_Refrigerator: 1
Dining_sp_Room_co_Separate: 1
Electric_co_220: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Hot_sp_Water2: 1
Interior_co_Ceiling_sp_Fan: 1
Parking_co_On_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Living_sp_Room_co_Separate2: 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