Property Id : 950357
Price: $ 1,348,000
Property Lot Size: 0 ft2
Bedrooms: 6
Bathrooms: 4.25
TaxAnnualAmount: 11008
BathroomsThreeQuarter: 3
BathroomsFull: 2
CoListOfficeKey: 20240702180110122585000000
InternetAutomatedValuationDisplayYN: 1
ListAgentKey: 20171003203201632614000000
StreetNumberNumeric: 251
ContractStatusChangeDate: 2025-03-25
ListAgentFullName: Yu Wing Ho
InternetAddressDisplayYN: 1
CoListAgentKey: 20160226175153204025000000
ListAgentMobilePhone: 917-916-2532
OnMarketDate: 2025-03-25
BathroomsHalf: 0
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20240702180110122585000000
CoListAgentFullName: Tsun Ming Lau
ListAgentLastName: Ho
CumulativeDaysOnMarket: 182
TaxLot: 0022
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: 2025-03-25T16:26:18Z
ListAgentFirstName: Yu Wing
CoListAgentEmail: tsunminglau@gmail.com
MajorChangeType: New Listing
LotSizeUnits: Square Feet
DocumentsCount: 1
CoListAgentPreferredPhone: 917-332-8987
CoListOfficeName: Reliance Realty One
LotSizeSquareFeet: 4000
OwnerName: Chen
CoListAgentFax: 347-825-3231
ListingId: 2501569
CoListAgentStateLicense: 10301216684
CoListAgentFirstName: Tsun Ming
YearBuilt: 2018
ListAgentPreferredPhone: 917-916-2532
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250325141655756898000000
ArchitecturalStyle: Colonial
StateOrProvince: NY
CoListAgentLastName: Lau
ListOfficeName: Reliance Realty One
CoListAgentOfficePhone: 917-332-8987
CoListOfficeURL: http://reliancerealty.com
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20250325141655756898000000
VideosCount: 0
PhotosCount: 45
CoListAgentMlsId: 15575
ListOfficeURL: http://reliancerealty.com
ListAgentStateLicense: 10401308335
PhotosChangeTimestamp: 2025-03-25T16:28:28Z
BuildingAreaTotal: 2600
Stories: 3
CoListAgentDirectPhone: 646-881-6225
OriginatingSystemName: Staten Island Multiple Listing Service
OriginalListPrice: 1348000
Sewer: City
ListingContractDate: 2025-03-16
StreetSuffix: Avenue
CoListOfficeMlsId: o11624
OriginatingSystemID: M00000487
LotSizeDimensions: 40x100
StreetNumber: 251
StreetName: Cambridge
Electric: 220 Volts
ListAgentEmail: yuwing1237@gmail.com
ModificationTimestamp: 2025-03-31T06:31:38Z
ListOfficeMlsId: o11624
MlsStatus: Active
TaxBlock: 01524
LotSizeArea: 4000
SourceSystemID: M00000487
ParcelNumber: 01524-0022
ListAgentMlsId: 16425
ParkingFeatures: Carport,Detached
Zoning: R3-X
DocumentsChangeTimestamp: 2025-03-25T16:26:19Z
Heating: Forced Air,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Stone,Vinyl Siding
MajorChangeTimestamp: 2025-03-25T16:26:18Z
Directions: Use GPS
MLSAreaMajor: Westerleigh
DaysOnMarket: 15
GarageSpaces: 1
MLSAreaMinor: Westerleigh
BathroomsTotalDecimal: 4.25
AddressLegal_co_Section: North Shore
ContractLocation_sp_Information_co_CofO: Yes
ContractLocation_sp_Information_co_REO: No
General_sp_Property_sp_Info_co_Stories2: 3
General_sp_Property_sp_Info_co_Style2: Colonial
General_sp_Property_sp_Info_co_Taxes2: 11008
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_Irregular: No
General_sp_Property_sp_Info_co_Condition: Excellent
General_sp_Property_sp_Info_co_34_sp_Baths: 3
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: No
General_sp_Property_sp_Info_co_Cooling: Yes
General_sp_Property_sp_Info_co_Fireplace: No
General_sp_Property_sp_Info_co_HOA_sp_YN: No
Sewer_co_City3: 1
Appliances_co_Dishwasher: 1
Appliances_co_Gas_sp_Grill: 1
Appliances_co_Refrigerator: 1
Dining_sp_Room_co_Combination: 1
Electric_co_220: 1
Exterior_co_Fence: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Forced_sp_Air: 1
Interior_co_Walk_hyphen_in_sp_Closet: 1
Parking_co_Carport: 1
Kitchen_co_Pantry: 1
Living_sp_Room_co_Combination2: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Primary_sp_Bedroom_co_Private_sp_Bath: 1
Primary_sp_Bedroom_co_Suite: 1
Garage_sp_Location_co_Detached: 1
Siding_co_Stone: 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: 1
Two_sp_Family_sp_2nd_sp_Unit_co_Location: L2
_two_nd_sp_Unit_sp_Appliances_co_Stove: 1