Property Id : 946988
Price: $ 1,150,000
Property Lot Size: 0 ft2
Rooms: 15
Bedrooms: 3
Bathrooms: 2.25
TaxAnnualAmount: 9702
BathroomsThreeQuarter: 1
BathroomsFull: 1
CoListOfficeKey: 20141019170639528220000000
InternetAutomatedValuationDisplayYN: 1
ListAgentKey: 20141019181334808907000000
CoListAgentMobilePhone: 917-613-1260
StreetNumberNumeric: 128
ContractStatusChangeDate: 2025-03-20
ListAgentFullName: Anthony Ragucci
InternetAddressDisplayYN: 1
CoListAgentKey: 20141019181339759459000000
BuyerAgentFullName: Tsun Ming Lau
ListAgentMobilePhone: 917-842-1746
OnMarketDate: 2025-03-07
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170639528220000000
CoListAgentFullName: Elizabeth M Walsh
BuyerAgentKey: 20160226175153204025000000
BuyerOfficeKey: 20240702180110122585000000
ListAgentLastName: Ragucci
CumulativeDaysOnMarket: 135
TaxLot: 0042
CoListOfficeEmail: vianeuhaus@aol.com
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: 2025-03-20T13:14:53.000Z
ListAgentFirstName: Anthony
CoListAgentEmail: ewalshrealtor@aol.com
BuyerOfficeURL: http://reliancerealty.com
BuyerOfficeName: Reliance Realty One
MajorChangeType: Status Change
OffMarketDate: 2025-03-20
LotSizeUnits: Square Feet
DocumentsCount: 0
BuyerAgentMlsId: 15575
CoListAgentPreferredPhone: 917-613-1260
CoListOfficeName: Neuhaus Realty, Inc.
LotSizeSquareFeet: 4535
BuyerAgentLastName: Lau
OwnerName: SCHMIDT
ListAgentOfficePhone: 718-979-3400
CoListAgentFax: 718-987-3225
ListingId: 2501225
CoListAgentStateLicense: 10301209677
BuyerAgentOfficePhone: 917-332-8987
CoListAgentFirstName: Elizabeth
YearBuilt: 1997
ListAgentURL: https://www.neuhausrealty.com
ListAgentPreferredPhone: 917-842-1746
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250302191836298715000000
ArchitecturalStyle: Colonial
CoListAgentMiddleName: M
ListOfficeFax: 718-987-3225
StateOrProvince: NY
BuyerAgentStateLicense: 10301216684
CoListAgentLastName: Walsh
ListOfficeName: Neuhaus Realty, Inc.
CoListAgentOfficePhone: 718-979-3400
CoListOfficeURL: https://www.neuhausrealty.com
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20250302191836298715000000
VideosCount: 0
BuyerAgentFax: 347-825-3231
PhotosCount: 46
CoListAgentMlsId: 13374
ContingentDate: 2025-03-18
ListOfficeURL: https://www.neuhausrealty.com
ListAgentStateLicense: 30RA0600423
PhotosChangeTimestamp: 2025-03-08T15:00:38.000Z
BuildingAreaTotal: 2600
BuyerAgentPreferredPhone: 917-332-8987
Stories: 2
CoListAgentDirectPhone: 718-979-3400
PurchaseContractDate: 2025-03-20
OriginatingSystemName: Staten Island Multiple Listing Service
BuyerAgentDirectPhone: 646-881-6225
OriginalListPrice: 1150000
Sewer: City
ListingContractDate: 2025-03-07
StreetSuffix: Avenue
CoListOfficeMlsId: o19001
OriginatingSystemID: M00000487
LotSizeDimensions: 42'X108'
StreetNumber: 128
StreetName: Justin
Electric: 220 Volts
ListAgentEmail: tragucci@aol.com
ModificationTimestamp: 2025-03-20T13:15:18.000Z
ListOfficeMlsId: o19001
BuyerAgentEmail: tsunminglau@gmail.com
MlsStatus: Pending
TaxBlock: 05024
LotSizeArea: 4535
SourceSystemID: M00000487
ParcelNumber: 05024-0042
ListOfficeEmail: vianeuhaus@aol.com
BuyerAgentFirstName: Tsun Ming
ListAgentMlsId: 8020
ParkingFeatures: Off Street
Zoning: R3X
DocumentsChangeTimestamp: 2025-03-07T21:23:50.000Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Brick,Vinyl Siding
MajorChangeTimestamp: 2025-03-20T13:14:56.000Z
Directions: BTWN DURANT AVE & O'GORMAN AVE
MLSAreaMajor: Bay Terrace
DaysOnMarket: 13
PendingTimestamp: 2025-03-20T13:14:53.000Z
GarageSpaces: 1
CoListOfficeFax: 718-987-3225
MLSAreaMinor: Bay Terrace
BuyerOfficeMlsId: o11624
BathroomsTotalDecimal: 2.25
AddressLegal_co_Section: South 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: 9702
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 42'X108'
General_sp_Property_sp_Info_co_Irregular: N
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: Yes
General_sp_Property_sp_Info_co_HOA_sp_YN: No
Sewer_co_City3: 1
Appliances_co_Dishwasher: 1
Appliances_co_Dryer: 1
Appliances_co_Gas_sp_Grill: 1
Appliances_co_Microwave: 1
Appliances_co_Refrigerator: 1
Appliances_co_Washer: 1
Dining_sp_Room_co_Formal: 1
Dining_sp_Room_co_Separate: 1
Electric_co_220: 1
Exterior_co_Deck: 1
Exterior_co_Fence: 1
Exterior_co_Garage_sp_Door_sp_Opener: 1
Exterior_co_Grill: 1
Exterior_co_Patio: 1
Exterior_co_Shed: 1
Exterior_co_Sprinkler_sp_System: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Hot_sp_Water2: 1
Interior_co_Ceiling_sp_Fan: 1
Interior_co_Fireplace5: 1
Interior_co_Intercom: 1
Interior_co_Security_sp_System: 1
Interior_co_Walk_hyphen_in_sp_Closet: 1
Parking_co_Off_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Kitchen_co_YardDeck_sp_Access: 1
Living_sp_Room_co_Formal2: 1
Living_sp_Room_co_Separate2: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Main_sp_Bath_co_Jacuzzi2: 1
Main_sp_Bath_co_Separate_sp_Shower: 1
Primary_sp_Bedroom_co_Shared_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: L2
_two_nd_sp_Unit_sp_Appliances_co_Stove: 1
Documents_co_Property_sp_Owner_sp_Information: 1