Property Id : 900635
Price: $ 1,275,000
Property Lot Size: 0 ft2
Rooms: 9
Bedrooms: 3
Bathrooms: 3
TaxAnnualAmount: 1
BathroomsThreeQuarter: 2
BathroomsFull: 1
CoListOfficeKey: 20141019170630231310000000
InternetAutomatedValuationDisplayYN: 1
ListAgentKey: 20141019181242470282000000
StreetNumberNumeric: 149
ContractStatusChangeDate: 2024-12-02
ListAgentFullName: Ron Molcho
InternetAddressDisplayYN: 1
CoListAgentKey: 20160301163702666258000000
ListAgentMobilePhone: 917-531-1100
OnMarketDate: 2024-12-02
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170630231310000000
CoListAgentFullName: Maurice Molcho
ListAgentLastName: Molcho
CumulativeDaysOnMarket: 7
TaxLot: 0001
CoListOfficeEmail: office@americanhomesgroup.com
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: 2024-12-02T18:33:13Z
ListAgentFirstName: Ron
CoListAgentEmail: moe@americanhomesgroup.com
MajorChangeType: New Listing
LotSizeUnits: Square Feet
DocumentsCount: 0
CoListOfficeName: American Homes Group
LotSizeSquareFeet: 5040
OwnerName: R&L Enterprises
ListingId: 2406597
CoListAgentStateLicense: 10301216355
CoListAgentFirstName: Maurice
YearBuilt: 2025
ListAgentURL: http://americanhomesgroup.com
ListAgentPreferredPhone: 917-531-1100
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20241202161204873420000000
ArchitecturalStyle: Colonial
ListOfficeFax: 347-825-3231
StateOrProvince: NY
CoListAgentLastName: Molcho
ListOfficeName: American Homes Group
CoListAgentOfficePhone: 718-981-3400
CoListOfficeURL: http://www.americanhomesgroup.com
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20241202161204873420000000
VideosCount: 0
PhotosCount: 1
CoListAgentMlsId: 12950
ListOfficeURL: http://www.americanhomesgroup.com
ListAgentStateLicense: 10311206568
PhotosChangeTimestamp: 2024-12-02T18:33:13Z
BuildingAreaTotal: 2400
Stories: 2
OriginatingSystemName: Staten Island Multiple Listing Service
OriginalListPrice: 1275000
Sewer: City
ListingContractDate: 2024-12-02
StreetSuffix: Avenue
CoListOfficeMlsId: o10192
OriginatingSystemID: M00000487
LotSizeDimensions: 42 x 120
StreetNumber: 149
StreetName: Waldron
Electric: 220 Volts
ListAgentEmail: Rmolcho@americanhomesgroup.com
ModificationTimestamp: 2024-12-09T17:02:39Z
ListOfficeMlsId: o10192
MlsStatus: Active
TaxBlock: 00246
LotSizeArea: 5040
SourceSystemID: M00000487
ParcelNumber: 00246-0001
ListOfficeEmail: office@americanhomesgroup.com
ListAgentMlsId: 6296
ParkingFeatures: Off Street
Zoning: R 2
DocumentsChangeTimestamp: 2024-12-02T16:14:46Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: New
ConstructionMaterials: Brick
ListAgentFax: 347-825-3231
MajorChangeTimestamp: 2024-12-02T18:33:13Z
Directions: Victory to Clove Road
CoListAgentURL: americanhomesgroup.com
MLSAreaMajor: Clove Lake
DaysOnMarket: 7
GarageSpaces: 0
CoListOfficeFax: 347-825-3231
MLSAreaMinor: Clove Lake
BathroomsTotalDecimal: 3
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: 1
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 42 x 120
General_sp_Property_sp_Info_co_Condition: Excellent
General_sp_Property_sp_Info_co_34_sp_Baths: 2
General_sp_Property_sp_Info_co_Half_sp_Baths: 1
General_sp_Property_sp_Info_co_Waterview: No
General_sp_Property_sp_Info_co_Cooling: Yes
Sewer_co_City3: 1
Appliances_co_Dishwasher: 1
Appliances_co_Microwave: 1
Dining_sp_Room_co_Combination: 1
Electric_co_220: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Hot_sp_Water2: 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_None4: 1
Siding_co_Brick: 1
Yard_co_Back: 1
Yard_co_Front: 1
Yard_co_Side: 1