Property Id : 984454
Price: $ 999,888
Property Lot Size: 0 ft2
Rooms: 12
Bedrooms: 5
Bathrooms: 3.25
TaxAnnualAmount: 7906
BathroomsThreeQuarter: 1
BathroomsFull: 2
CoListOfficeKey: 20141019170630231310000000
InternetAutomatedValuationDisplayYN: 1
CoBuyerAgentKey: 20160226175153204025000000
BuyerAgentMobilePhone: 917-916-2532
ListAgentKey: 20160301163702666258000000
CoListAgentMobilePhone: 917-531-1100
StreetNumberNumeric: 459
ContractStatusChangeDate: 2025-05-09
CoBuyerAgentFullName: Tsun Ming Lau
ListAgentFullName: Maurice Molcho
InternetAddressDisplayYN: 1
CoBuyerOfficeKey: 20240702180110122585000000
CoListAgentKey: 20141019181242470282000000
BuyerAgentFullName: Yu Wing Ho
OnMarketDate: 2025-04-24
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170630231310000000
CoListAgentFullName: Ron Molcho
BuyerAgentKey: 20171003203201632614000000
BuyerOfficeKey: 20240702180110122585000000
ListAgentLastName: Molcho
CumulativeDaysOnMarket: 15
TaxLot: 0043
CoListOfficeEmail: office@americanhomesgroup.com
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: 2025-05-09T13:30:43Z
ListAgentFirstName: Maurice
CoListAgentEmail: Rmolcho@americanhomesgroup.com
BuyerOfficeURL: http://reliancerealty.com
BuyerOfficeName: Reliance Realty One
MajorChangeType: Status Change
OffMarketDate: 2025-05-09
LotSizeUnits: Square Feet
DocumentsCount: 0
BuyerAgentMlsId: 16425
CoListAgentPreferredPhone: 917-531-1100
CoListOfficeName: American Homes Group
LotSizeSquareFeet: 4000
BuyerAgentLastName: Ho
OwnerName: Endress
ListAgentOfficePhone: 718-981-3400
CoListAgentFax: 347-825-3231
ListingId: 2502016
CoListAgentStateLicense: 10311206568
CoListAgentFirstName: Ron
CoBuyerAgentEmail: tsunminglau@gmail.com
YearBuilt: 1983
ListAgentURL: americanhomesgroup.com
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250410190223919797000000
CoBuyerAgentOfficePhone: 917-332-8987
ArchitecturalStyle: Colonial
CoBuyerAgentDirectPhone: 646-881-6225
CoBuyerOfficeName: Reliance Realty One
ListOfficeFax: 347-825-3231
CoBuyerAgentPreferredPhone: 917-332-8987
StateOrProvince: NY
BuyerAgentStateLicense: 10401308335
CoListAgentLastName: Molcho
ListOfficeName: American Homes Group
CoListOfficeURL: http://www.americanhomesgroup.com
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20250410190223919797000000
VideosCount: 0
PhotosCount: 19
CoBuyerAgentMlsId: 15575
CoListAgentMlsId: 6296
ContingentDate: 2025-04-29
ListOfficeURL: http://www.americanhomesgroup.com
ListAgentStateLicense: 10301219002
PhotosChangeTimestamp: 2025-04-12T16:02:58Z
BuildingAreaTotal: 2744
BuyerAgentPreferredPhone: 917-916-2532
Stories: 2
PurchaseContractDate: 2025-05-09
YearBuiltEffective: 2022
OriginatingSystemName: Staten Island Multiple Listing Service
CoBuyerAgentFax: 347-825-3231
OriginalListPrice: 999888
Sewer: City
ListingContractDate: 2025-04-12
StreetSuffix: Street
CoListOfficeMlsId: o10192
OriginatingSystemID: M00000487
LotSizeDimensions: 40x100
StreetNumber: 459
StreetName: Riga
Electric: 220 Volts
ListAgentEmail: moe@americanhomesgroup.com
ModificationTimestamp: 2025-05-09T13:31:05Z
CoBuyerAgentStateLicense: 10301216684
ListOfficeMlsId: o10192
BuyerAgentEmail: yuwing1237@gmail.com
MlsStatus: Pending
CoBuyerAgentLastName: Lau
TaxBlock: 04028
LotSizeArea: 4000
SourceSystemID: M00000487
CoBuyerAgentFirstName: Tsun Ming
ParcelNumber: 04028-0043
ListOfficeEmail: office@americanhomesgroup.com
BuyerAgentFirstName: Yu Wing
ListAgentMlsId: 12950
CoBuyerOfficeMlsId: o11624
ParkingFeatures: Off Street
Zoning: R2
DocumentsChangeTimestamp: 2025-04-12T16:02:58Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Brick,Vinyl Siding
CoBuyerOfficeURL: http://reliancerealty.com
MajorChangeTimestamp: 2025-05-09T13:30:46Z
Directions: Between Guyon and Isabella
CoListAgentURL: http://americanhomesgroup.com
MLSAreaMajor: Oakwood
DaysOnMarket: 15
PendingTimestamp: 2025-05-09T13:30:43Z
GarageSpaces: 1
CoListOfficeFax: 347-825-3231
MLSAreaMinor: Oakwood
BuyerOfficeMlsId: o11624
BathroomsTotalDecimal: 3.25
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: Colonial
General_sp_Property_sp_Info_co_Taxes2: 7906
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 40x100
General_sp_Property_sp_Info_co_Condition: Excellent
General_sp_Property_sp_Info_co_34_sp_Baths: 1
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
General_sp_Property_sp_Info_co_Fireplace: No
Sewer_co_City3: 1
Appliances_co_Dishwasher: 1
Appliances_co_Refrigerator: 1
Dining_sp_Room_co_Combination: 1
Electric_co_220: 1
Exterior_co_Deck: 1
Exterior_co_Fence: 1
Exterior_co_Garage_sp_Door_sp_Opener: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Hot_sp_Water2: 1
Interior_co_Security_sp_System: 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_Private_sp_Bath: 1
Garage_sp_Location_co_Built_hyphen_in: 1
Siding_co_Brick: 1
Siding_co_Vinyl_sp_Siding: 1
Yard_co_Back: 1
Yard_co_Front: 1
Yard_co_Side: 1
Two_sp_Family_sp_2nd_sp_Unit_co_34_sp_Baths3: 0
Two_sp_Family_sp_2nd_sp_Unit_co_Location: L1
_two_nd_sp_Unit_sp_Appliances_co_Stove: 1