Property Id : 1015815
Price: $ 1,529,000
Property Lot Size: 0 ft2
Rooms: 14
Bedrooms: 4
Bathrooms: 2.5
TaxAnnualAmount: 9698.15
BathroomsThreeQuarter: 0
BathroomsFull: 2
InternetAutomatedValuationDisplayYN: 1
ListAgentKey: 20141019181235794889000000
StreetNumberNumeric: 249
ContractStatusChangeDate: 2025-07-07
ListAgentFullName: Richard J Freeo
InternetAddressDisplayYN: 1
ListAgentMobilePhone: 917-658-1931
OnMarketDate: 2025-07-08
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170629896256000000
ListAgentLastName: Freeo
CumulativeDaysOnMarket: 4
TaxLot: 214
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: July 8, 2025 at 02:17am
ListAgentFirstName: Richard
PriceChangeTimestamp: July 8, 2025 at 02:52am
MajorChangeType: Price Change
LotSizeUnits: Square Feet
DocumentsCount: 0
LotSizeSquareFeet: 9165
WindowFeatures: ENERGY STAR Qualified Windows
OwnerName: LeLi
ListAgentOfficePhone: 718-980-2111
ListingId: 2503936
YearBuilt: 1965
ListAgentPreferredPhone: 917-658-1931
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250701233335981393000000
ArchitecturalStyle: Colonial
ListOfficeFax: 718-351-2199
StateOrProvince: NY
ListOfficeName: Richard J. Freeo Realty Inc.
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20250701233335981393000000
VideosCount: 0
PhotosCount: 39
ListAgentStateLicense: 31FR0926410
PhotosChangeTimestamp: July 8, 2025 at 02:17am
BuildingAreaTotal: 3174
Stories: 2
YearBuiltEffective: 2020
OriginatingSystemName: Staten Island Multiple Listing Service
GreenEnergyEfficient: Low Flow Faucets,Low Flow Toilet,Programmable Thermostat
OriginalListPrice: 1519000
Sewer: City
ListingContractDate: 2025-07-04
StreetSuffix: Avenue
OriginatingSystemID: M00000487
LotSizeDimensions: 65x141
StreetNumber: 249
StreetName: Ridgecrest
Electric: 220 Volts
ListAgentEmail: freeorealty@yahoo.com
ModificationTimestamp: July 8, 2025 at 05:03am
ListOfficeMlsId: o10113x
MlsStatus: Active
TaxBlock: 05268
LotSizeArea: 9165
SourceSystemID: M00000487
ParcelNumber: 05268-214
ListOfficeEmail: richie@richardfreeorealty.com
ListAgentMlsId: 5352
ParkingFeatures: Off Street
Zoning: A-1
DocumentsChangeTimestamp: 2025-07-08T02:17:37Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Brick
ListAgentFax: 718-351-2199
MajorChangeTimestamp: July 8, 2025 at 02:52am
ListAgentMiddleName: J
Directions: Hylan Blvd to Ridgecrest Avenue
FireplaceFeatures: Living Room
MLSAreaMajor: Eltingville
DaysOnMarket: 4
GarageSpaces: 1
MLSAreaMinor: Eltingville
BathroomsTotalDecimal: 2.5
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: 9698.15
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 65x141
General_sp_Property_sp_Info_co_Condition: Excellent
General_sp_Property_sp_Info_co_34_sp_Baths: 0
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_Combination: 1
Dining_sp_Room_co_Formal: 1
Electric_co_220: 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
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_Hot_sp_Tub: 1
Interior_co_Security_sp_System: 1
Interior_co_Walk_hyphen_in_sp_Closet: 1
Interior_co_Water_sp_Filter: 1
Parking_co_Off_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Kitchen_co_Pantry: 1
Kitchen_co_YardDeck_sp_Access: 1
Living_sp_Room_co_Fireplace3: 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_Dressing_sp_Room: 1
Primary_sp_Bedroom_co_Private_sp_Bath: 1
Garage_sp_Location_co_Built_hyphen_in: 1
Siding_co_Brick: 1
Yard_co_Back: 1
Yard_co_Front: 1
Yard_co_Side: 1
Broker_sp_Load_co_Broker_sp_Load_sp_Edit: Office
Documents_co_Property_sp_Owner_sp_Information: 1