array:3 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=1206&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4531
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4535
+post_id: "28519"
+post_author: 1
+"ListingKey": "KEY422198217"
+"ListingId": "922305"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-01-26T18:33:36Z"
+"RFModificationTimestamp": "2026-01-26T18:38:42Z"
+"ListPrice": 795000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1600.0
+"BuildingAreaTotal": 875.0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "29 Avon Road, Hempstead, New York 11557"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.646603
+"Longitude": -73.6926571
+"YearBuilt": 1938
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Lori B. Sunshine Harrow GRI"
+"ListOfficeName": "GYGA Realty"
+"ListAgentMlsId": "9026775"
+"ListOfficeMlsId": "SRL02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Completely Renovated Ranch Under 2025 Building permit.New Windows,Siding,Roof. 3bedroom 2 bathrooms. Open layout kitchen. White Shaker cabinets with SS Appliances. New 200 amp electrical. Solid oak Floors.Finished Basement with Separate entrance and full bathroom. Lots of storage space. Located on a quiet treelined street . Walking distance to parks. Large Fenced in PVC backyard."
+"Appliances": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "888-492-4657"
+"Basement": array:3 [ …3]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerOfficeAOR": "LIBOR"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-10-08T16:30:27.947235+00:00"
+"CumulativeDaysOnMarket": 23
+"DaysOnMarket": 23
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"ExpirationDate": "2026-01-25"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "0.5"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:6 [ …6]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-513-9811"
+"ListAgentEmail": "sunshinerealtors@yahoo.com"
+"ListAgentKey": "326255411"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115759"
+"ListOfficePhone": "888-492-4657"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-10-08"
+"LotSizeAcres": 0.1377
+"LotSizeSquareFeet": 6000
+"MajorChangeTimestamp": "2026-01-25T05:11:04Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-01-25"
+"OnMarketDate": "2025-10-10"
+"OriginalEntryTimestamp": "2025-10-08T16:23:55Z"
+"OriginalListPrice": 795000
+"OriginatingSystemModificationTimestamp": "2026-01-26T18:31:55Z"
+"OwnerName": "Kolosov Dev Corp"
+"ParcelNumber": "2089-39-439-00-0018-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2025-10-16T13:31:36Z"
+"PhotosCount": 20
+"PostalCity": "Hewlett"
+"PostalCodePlus4": "1529"
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-647-5906"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-25T05:11:04Z"
+"StreetName": "Avon"
+"StreetNumber": "29"
+"StreetNumberNumeric": "29"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12000"
+"TaxYear": "2025"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Partial"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "795000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalRooms": "Dining Area"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1600.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-647-5906"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "496.87500"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5773420.4793"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "496.87500"
+"KEY_SourceSystemModificationTimestamp": "2025-10-08T12:09:36.437"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422198217')"
+"provider_name": "One Key"
+"Media": array:20 [ …20]
+"ID": "28519"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5095
+post_id: "28531"
+post_author: 1
+"ListingKey": "KEY422188837"
+"ListingId": "922071"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-02-07T07:03:38Z"
+"RFModificationTimestamp": "2026-02-07T07:07:03Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2800.0
+"BuildingAreaTotal": 2800.0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "262 Channon Road, Hempstead, New York 11557"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6398124
+"Longitude": -73.6796871
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Oksana Malayeva SFR"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "178388"
+"ListOfficeMlsId": "SPH15"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to this beautifully updated and spacious 5-bedroom, 3 full bath expanded Ranch in Hewlett Harbor! The Most Desirable Section of Five Towns!!! LOW TAXES! NO SANDY DAMAGE! NO FLOOD INSURANCE IS REQUIRED! Step inside and be greeted by an airy, bright atmosphere enhanced by brand-new wall-to-wall windows that fill every room with natural light and custom-built blinds. The home features a central air conditioner and a gas range. The primary bedroom offers a private ensuite bath with a triple door closet. The eat-in kitchen is newly renovated with gorgeous countertops, modern new appliances, a wine cooler, and a butler’s pantry with additional counter space for effortless entertaining. A mudroom with ample storage provides the perfect spot to keep seasonal and holiday items neatly organized and out of the way. The two additional updated bathrooms blend style and convenience, while gleaming hardwood floors flow throughout the home. The second floor is a private oasis, complete with two bedrooms and a full bath, and a stand-up attic for extra storage. Outside, enjoy a low-maintenance, beautifully landscaped, and oversized fenced backyard where you can let your imagination run wild, plenty of room for a pool, hot tub, outdoor fireplace, swing set, and even a basketball hoop — the ultimate space for entertainment and relaxation. Enjoy new siding, a newer roof under 10 years old, freshly installed pavers, and a beautiful patio that’s perfect for gatherings or outdoor relaxation under the stars. Well Water For Sprinklers. Don't miss the opportunity to make it your Home sweet Home! Schedule your private tour to view this beauty!"
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-766-7900"
+"Basement": array:1 [ …1]
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "646-388-2208"
+"CoListAgentEmail": "ABangiyeva@cbamhomes.com"
+"CoListAgentFullName": "Asya Bangiyeva"
+"CoListAgentKey": "326200290"
+"CoListAgentMlsId": "190349"
+"CoListOfficeKey": "326109936"
+"CoListOfficeMlsId": "BRMN05"
+"CoListOfficeName": "Coldwell Banker American Homes"
+"CoListOfficePhone": "516-223-2525"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-10-09T02:16:57.723926+00:00"
+"CrossStreet": "E Rockaway"
+"CumulativeDaysOnMarket": 115
+"DaysOnMarket": 115
+"ElementarySchool": "Waverly Park School"
+"ElementarySchoolDistrict": "Lynbrook"
+"ExpirationDate": "2026-06-07"
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:4 [ …4]
+"Heating": array:2 [ …2]
+"HighSchool": "Lynbrook Senior High School"
+"HighSchoolDistrict": "Lynbrook"
+"InteriorFeatures": array:13 [ …13]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-575-3800"
+"ListAgentEmail": "omalayeva@signaturepremier.com"
+"ListAgentKey": "326189005"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115723"
+"ListOfficePhone": "516-766-7900"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-10-07"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.2639
+"LotSizeSquareFeet": 11495
+"MajorChangeTimestamp": "2026-02-06T15:12:30Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "Lynbrook South Middle School"
+"MiddleOrJuniorSchoolDistrict": "Lynbrook"
+"MlsStatus": "Hold"
+"OffMarketDate": "2026-02-06"
+"OnMarketDate": "2025-10-14"
+"OriginalEntryTimestamp": "2025-10-09T02:13:33Z"
+"OriginalListPrice": 1299000
+"OriginatingSystemModificationTimestamp": "2026-02-06T15:12:30Z"
+"OwnerName": "Rosa & Rufino Gonzalez"
+"ParcelNumber": "2017-42-239-00-0001-0"
+"ParkingFeatures": array:5 [ …5]
+"PhotosChangeTimestamp": "2026-02-03T18:49:36Z"
+"PhotosCount": 37
+"PostalCity": "Hewlett Harbor"
+"PostalCodePlus4": "2702"
+"PreviousListPrice": 1249000
+"PriceChangeTimestamp": "2026-01-06T21:09:25Z"
+"RoomsTotal": "9"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "347-575-3800"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-06T15:12:30Z"
+"StreetName": "Channon"
+"StreetNumber": "262"
+"StreetNumberNumeric": "262"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "20942.56"
+"TaxYear": "2025"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:7 [ …7]
+"KEY_Attic": "Partially Finished,Storage,Walkup"
+"KEY_Village": "Hewlett Harbor"
+"KEY_HoldDate": "2026-02-06"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1149000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "2800.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "646-388-2208"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "410.35714"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "4353921.9401"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "410.35714"
+"KEY_SourceSystemModificationTimestamp": "2025-10-07T18:25:36.327"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "410.35714"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.88453"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "410.35714"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422188837')"
+"provider_name": "One Key"
+"Media": array:37 [ …37]
+"ID": "28531"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4607
+post_id: "28509"
+post_author: 1
+"ListingKey": "KEY422183609"
+"ListingId": "921898"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-12-13T15:01:36Z"
+"RFModificationTimestamp": "2025-12-13T15:03:54Z"
+"ListPrice": 925000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1422.0
+"BuildingAreaTotal": 1422.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "19 Margaret Boulevard, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6714491
+"Longitude": -73.5542102
+"YearBuilt": 1929
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Evan Mogelefsky"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "120109"
+"ListOfficeMlsId": "DERE28"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to this beautifully renovated Tudor-style home nestled in the heart of Merrick Woods. This 3-bedroom, 2-bath residence is truly turn-key and ready for its next chapter.\n
\n
Step inside to discover open-concept living space with gleaming hardwood floors and an inviting living room which features a cozy wood-burning fireplace, seamlessly flowing into the dining area and an updated eat-in kitchen complete with marble countertops, stainless-steel appliances, and a gas range — perfect for both everyday living and entertaining.\n
\n
The first floor includes a spacious bedroom and a fully updated bathroom. Upstairs, you'll find two additional bedrooms, all with new flooring, plus a second full bath.\n
\n
The large, unfinished basement offers high ceilings a walk-out entrance, laundry area, utilities, and ample storage space, giving you endless potential to customize.\n
\n
Recent updates (2022-2023) include a new roof , new siding, two-zone heating and central AC, 200-amp electric service, and a newly built 1.5-car detached garage.\n
\n
Perfectly located close to shopping, schools, LIRR and major highways, this home combines old-world charm with modern updates and convenience.
"""
+"Appliances": array:2 [ …2]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-623-4500"
+"Basement": array:3 [ …3]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-322-1380"
+"BuyerAgentEmail": "carolinedelucarealtor@gmail.com"
+"BuyerAgentFullName": "Caroline M. DeLuca"
+"BuyerAgentKey": "326144836"
+"BuyerAgentMlsId": "130557"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326112634"
+"BuyerOfficeMlsId": "JOCA01"
+"BuyerOfficeName": "Century 21 Catapano Homes"
+"BuyerOfficePhone": "516-938-0021"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-10-07T19:29:24.747599+00:00"
+"CrossStreet": "Hewlett Ave"
+"CumulativeDaysOnMarket": 38
+"DaysOnMarket": 38
+"ElementarySchool": "Camp Avenue School"
+"ElementarySchoolDistrict": "North Merrick"
+"ExpirationDate": "2026-04-30"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageSpaces": "1.5"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-322-7518"
+"ListAgentEmail": "evan.mogelefsky@elliman.com"
+"ListAgentKey": "326135460"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110766"
+"ListOfficePhone": "516-623-4500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-10-07"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1377
+"LotSizeDimensions": "60x100"
+"LotSizeSquareFeet": 6000
+"MajorChangeTimestamp": "2025-12-13T15:00:11Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2025-11-14"
+"OnMarketDate": "2025-10-07"
+"OriginalEntryTimestamp": "2025-10-07T19:26:25Z"
+"OriginalListPrice": 949000
+"OriginatingSystemModificationTimestamp": "2025-12-13T15:00:11Z"
+"OwnerName": "Mark & Rebecca Scarfone"
+"ParcelNumber": "2089-56-081-00-0046-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-10T14:35:36Z"
+"PhotosCount": 25
+"PostalCity": "Merrick"
+"PostalCodePlus4": "3105"
+"PreviousListPrice": 939000
+"PriceChangeTimestamp": "2025-11-06T17:41:30Z"
+"PropertyCondition": array:1 [ …1]
+"PurchaseContractDate": "2025-12-12"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-623-4500"
+"ShowingRequirements": array:6 [ …6]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-13T15:00:11Z"
+"StreetName": "Margaret"
+"StreetNumber": "19"
+"StreetNumberNumeric": "19"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "Merrick Woods"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "14956.68"
+"TaxYear": "2025"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_HoldDate": "2025-11-14"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "925000.00"
+"KEY_ContractPrice": "905000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Hold"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1422.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-322-7518"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "650.49226"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6717501.8155"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "650.49226"
+"KEY_SourceSystemModificationTimestamp": "2025-10-07T14:23:27.313"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "650.49226"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97471"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "650.49226"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422183609')"
+"provider_name": "One Key"
+"Media": array:25 [ …25]
+"ID": "28509"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4608
+post_id: "28506"
+post_author: 1
+"ListingKey": "KEY422178545"
+"ListingId": "921732"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2025-10-30T07:09:39Z"
+"RFModificationTimestamp": "2025-10-30T07:16:35Z"
+"ListPrice": 475000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1426.0
+"BuildingAreaTotal": 1426.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "256 Westside Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6362868
+"Longitude": -73.5894975
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Leticia Rodriguez"
+"ListOfficeName": "Keller Williams Rlty Landmark"
+"ListAgentMlsId": "192511"
+"ListOfficeMlsId": "KEWL01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This 4-bedroom, 2-bath, split-level single-family home, is in the heart of Freeport and is ideal for investors or buyers looking for a renovation project. Featuring an eat-in kitchen, vaulted ceilings in the living room, spacious family room with access to a private backyard, a one-car garage, and a private driveway. This home requires work and is being sold as-is. Property will be delivered vacant. It is conveniently located near the marinas, parks, shopping, and dining with easy access to major roadways."
+"Appliances": array:2 [ …2]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "718-475-2700"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "917-915-2619"
+"CoListAgentEmail": "evanxu@kw.com"
+"CoListAgentFullName": "Zhi Xu CBR"
+"CoListAgentKey": "326189563"
+"CoListAgentMlsId": "178981"
+"CoListOfficeKey": "326112865"
+"CoListOfficeMlsId": "KEWL01"
+"CoListOfficeName": "Keller Williams Rlty Landmark"
+"CoListOfficePhone": "718-475-2700"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-10-07T15:29:47.625067+00:00"
+"CumulativeDaysOnMarket": 119
+"DaysOnMarket": 21
+"Directions": "GPS"
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-04-07"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "718-475-2700"
+"ListAgentEmail": "leticiahomes@kw.com"
+"ListAgentKey": "326202338"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112865"
+"ListOfficePhone": "718-475-2700"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-10-07"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1148
+"LotSizeDimensions": "50x100"
+"LotSizeSquareFeet": 5000
+"MajorChangeTimestamp": "2025-10-28T22:30:27Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlsStatus": "Hold"
+"OffMarketDate": "2025-10-28"
+"OnMarketDate": "2025-10-07"
+"OriginalEntryTimestamp": "2025-10-07T15:22:44Z"
+"OriginalListPrice": 475000
+"OriginatingSystemModificationTimestamp": "2025-10-28T22:30:27Z"
+"OwnerName": "Espinoza"
+"ParcelNumber": "2009-62-032-00-0125-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-07T15:27:36Z"
+"PhotosCount": 12
+"PostalCity": "Freeport"
+"PostalCodePlus4": "6027"
+"PriceChangeTimestamp": "2025-10-07T15:22:44Z"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "(917) 744-5930"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:2 [ …2]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-10-28T22:30:27Z"
+"StreetName": "Westside"
+"StreetNumber": "256"
+"StreetNumberNumeric": "256"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [ …1]
+"TaxAnnualAmount": "11050.99"
+"TaxBlock": "32"
+"TaxLot": "125"
+"TaxYear": "2025"
+"Utilities": array:3 [ …3]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_Village": "Freeport"
+"KEY_HoldDate": "2025-10-28"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "475000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "1426.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "333.09958"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "4137630.6620"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "333.09958"
+"KEY_SourceSystemModificationTimestamp": "2025-10-07T11:22:44.677"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "333.09958"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "333.09958"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422178545')"
+"provider_name": "One Key"
+"Media": array:12 [ …12]
+"ID": "28506"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4572
+post_id: "28503"
+post_author: 1
+"ListingKey": "KEY422176321"
+"ListingId": "921681"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-09T13:11:47Z"
+"RFModificationTimestamp": "2025-10-09T13:18:02Z"
+"ListPrice": 1799000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 4490.0
+"BuildingAreaTotal": 4490.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "487 Links E Drive, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.764189
+"Longitude": -73.6830546
+"YearBuilt": 1962
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "John C. Gandolfo"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "105241"
+"ListOfficeMlsId": "BRMN05"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "A masterpiece of modern luxury, this brand-new contemporay home that redefines luxury living. Magnificent open concept floor plan with 4 Bedrooms, 4.5 Bathrooms Floor to ceiling windows, glass railings, roof top deck and spectacular 360 degree views of Middle Bay Golf Course and Bay Views of Parsonage Cove. This Malibu Inspired home with every concevable amenity will be completed Spring of 2026 so there is still time to add your personal finishes. Features include a massive Eat In Kitchen, Living Room, Dining Room, a Primary Bedroom with a Walk In Closet and En Suite Bathroom, 2 Car Garage and so much more. House has not been demoed yet, plans are available to view."
+"Appliances": array:7 [ …7]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-223-2525"
+"BathroomsFull": 4
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-644-8097"
+"CoListAgentEmail": "realtorgandolfo@aol.com"
+"CoListAgentFullName": "Barbara L. Gandolfo"
+"CoListAgentKey": "326249090"
+"CoListAgentMlsId": "89085"
+"CoListOfficeKey": "326109936"
+"CoListOfficeMlsId": "BRMN05"
+"CoListOfficeName": "Coldwell Banker American Homes"
+"CoListOfficePhone": "516-223-2525"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-10-07T14:54:27.134308+00:00"
+"CumulativeDaysOnMarket": 2
+"DaysOnMarket": 163
+"ElementarySchool": "School 9E-Boardman Elem School"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-10-02"
+"Flooring": array:2 [ …2]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:11 [ …11]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-779-8423"
+"ListAgentEmail": "johngandolfosells@gmail.com"
+"ListAgentKey": "326121593"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109936"
+"ListOfficePhone": "516-223-2525"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-10-06"
+"LivingAreaSource": "Plans"
+"LotSizeAcres": 0.1779
+"LotSizeSquareFeet": 7750
+"MajorChangeTimestamp": "2025-10-07T14:45:54Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-10-07"
+"OriginalEntryTimestamp": "2025-10-07T14:45:54Z"
+"OriginalListPrice": 1799000
+"OriginatingSystemModificationTimestamp": "2025-10-09T13:10:19Z"
+"OwnerName": "Luxe Homes Royale"
+"ParcelNumber": "2089-54-568-00-0006-0"
+"ParkingFeatures": array:3 [ …3]
+"ParkingTotal": "4"
+"PhotosChangeTimestamp": "2025-10-09T13:11:47Z"
+"PhotosCount": 16
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "5641"
+"RoomsTotal": "9"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-223-2525"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-10-07T14:45:54Z"
+"StreetDirSuffix": "E"
+"StreetName": "Links"
+"StreetNumber": "487"
+"StreetNumberNumeric": "487"
+"StreetSuffix": "Drive"
+"SyndicateTo": array:1 [ …1]
+"TaxAnnualAmount": "12284"
+"TaxYear": "2025"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "1799000.00"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "4490.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "400.66815"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "10112422.7094"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "400.66815"
+"KEY_SourceSystemModificationTimestamp": "2025-10-07T09:57:01.977"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "400.66815"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "400.66815"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422176321')"
+"provider_name": "One Key"
+"Media": array:16 [ …16]
+"ID": "28503"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4573
+post_id: "28557"
+post_author: 1
+"ListingKey": "KEY422169210"
+"ListingId": "921467"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-12-23T21:04:36Z"
+"RFModificationTimestamp": "2025-12-23T21:09:09Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1612.0
+"BuildingAreaTotal": 1612.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "208 Dogwood Road, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6719743
+"Longitude": -73.7023569
+"YearBuilt": 1948
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Russell E. Birdsall III CBR"
+"ListOfficeName": "Keller Williams Legendary"
+"ListAgentMlsId": "119091"
+"ListOfficeMlsId": "KWLG01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Vintage 4 bedroom 2 full bath home with a few surprises in a GREAT Location. \n
\n
Center Hall Cape featuring 2 Fireplaces, one in the Living Room and the other in the Sunroom/Den. This room has access to the private Driveway and 1 and half car garage with Garage door opener. The back yard is fenced in. Lets not forget the First floor Living Room, Full Bath, Formal Dinning Room, Partially finished basement, Bright 2nd floor bedrooms (1 Bedroom has a large Cedar Closet) bedrooms with full bath.\n
(1 Block from Memorial Jr and Central High Schools, 4 -5 minute drive to Wheeler Elementary School. Located near multiple bus stops on Central Ave an Merrick Rd. Town Park and Pool are Directly behind the Central HS. Southern State Parkway is 4 Blocks North of the home and the LIRR Babylon line is 5 miles away (According to Google maps) \n
Welcome home.
"""
+"Appliances": array:2 [ …2]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-355-1126"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-825-6511"
+"BuyerAgentEmail": "Leberle@cbamhomes.com"
+"BuyerAgentFullName": "Larry Eberle"
+"BuyerAgentKey": "326189840"
+"BuyerAgentMlsId": "179276"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326109943"
+"BuyerOfficeMlsId": "BRMN12"
+"BuyerOfficeName": "Coldwell Banker American Homes"
+"BuyerOfficePhone": "516-825-6511"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-770-0803"
+"CoListAgentEmail": "lourdesguekjian@kw.com"
+"CoListAgentFullName": "Lourdes M. Guekjian E-PRO MRP PSA"
+"CoListAgentKey": "326209909"
+"CoListAgentMlsId": "200376"
+"CoListOfficeKey": "326113002"
+"CoListOfficeMlsId": "KWLG01"
+"CoListOfficeName": "Keller Williams Legendary"
+"CoListOfficePhone": "516-328-8600"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-10-13T15:25:02.612829+00:00"
+"CrossStreet": "Meadowbrook La & Edgewood Rd"
+"CumulativeDaysOnMarket": 50
+"DaysOnMarket": 50
+"DirectionFaces": "North"
+"Directions": "Fletcher Ave -Turn onto Dogwood Rd - 1 block down on your left."
+"Disclosures": array:1 [ …1]
+"ElementarySchool": "Wheeler Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-02-27"
+"Fencing": array:2 [ …2]
+"FireplaceYN": true
+"Flooring": array:3 [ …3]
+"GarageSpaces": "1.5"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-355-1126"
+"ListAgentEmail": "Russ.Birdsall@KW.com"
+"ListAgentKey": "326134510"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113002"
+"ListOfficePhone": "516-328-8600"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-10-13"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:6 [ …6]
+"LotSizeAcres": 0.1205
+"LotSizeDimensions": "50x103"
+"LotSizeSquareFeet": 5250
+"MajorChangeTimestamp": "2025-12-23T21:02:58Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2025-12-12"
+"OnMarketDate": "2025-10-23"
+"OriginalEntryTimestamp": "2025-10-13T15:22:02Z"
+"OriginalListPrice": 699000
+"OriginatingSystemModificationTimestamp": "2025-12-23T21:02:58Z"
+"OwnerName": "Kraus"
+"ParcelNumber": "2035-37-564-00-0005-0"
+"ParkingFeatures": array:3 [ …3]
+"ParkingTotal": "5"
+"PhotosChangeTimestamp": "2025-10-21T18:13:54Z"
+"PhotosCount": 38
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "4002"
+"PurchaseContractDate": "2025-12-23"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516 770-0803"
+"ShowingRequirements": array:4 [ …4]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-23T21:02:58Z"
+"StreetName": "Dogwood"
+"StreetNumber": "208"
+"StreetNumberNumeric": "208"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12078.92"
+"TaxBlock": "37"
+"TaxLot": "5"
+"TaxYear": "2025"
+"Utilities": array:9 [ …9]
+"WaterSource": array:1 [ …1]
+"YearBuiltEffective": 1948
+"KEY_Attic": "None"
+"KEY_Village": "Valley Stream"
+"KEY_HoldDate": "2025-12-12"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "37"
+"KEY_CurrentPrice": "699000.00"
+"KEY_ContractPrice": "710000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Hold"
+"KEY_DistanceToTrain": "5.00"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1612.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516 355-1126"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "433.62283"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5800829.8755"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "433.62283"
+"KEY_SourceSystemModificationTimestamp": "2025-10-06T16:19:54.557"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "433.62283"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "433.62283"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422169210')"
+"provider_name": "One Key"
+"Media": array:38 [ …38]
+"ID": "28557"
}
]
+success: true
+page_size: 6
+page_count: 293
+count: 1755
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=1206&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5094
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5077
+post_id: "27783"
+post_author: 1
+"ListingKey": "KEY421365589"
+"ListingId": "899002"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-11T02:45:36Z"
+"RFModificationTimestamp": "2026-01-11T02:50:23Z"
+"ListPrice": 2999999.0
+"BathroomsTotalInteger": 8.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 6200.0
+"BuildingAreaTotal": 9300.0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "1331 Harbor Road, Hempstead, New York 11557"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6362531
+"Longitude": -73.6850699
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mahir Sadman SFR"
+"ListOfficeName": "EXP Realty"
+"ListAgentMlsId": "211779"
+"ListOfficeMlsId": "EXP02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Experience refined living at 1331 Harbor Road, an exceptional residence in the prestigious Hewlett Harbor community.\n
\n
This distinctive Norman-style masterpiece — once showcased in Architectural Digest and designed by the renowned Dorothy Draper & Co. — combines timeless elegance with thoughtful modern updates. Set on a lush ¾-acre lot, the property is surrounded by mature landscaping that creates a serene, private retreat. A stunning glass conservatory invites you to take in the tranquil garden views, offering the perfect setting for quiet moments or intimate gatherings.\n
\n
Inside, you’ll find five generously sized bedrooms, each complete with its own en-suite bath, plus three additional bathrooms for guests. The open-concept layout, extensively redesigned in 2005, allows for effortless entertaining and a natural flow between living spaces. The gourmet eat-in kitchen is a showstopper, featuring vaulted ceilings, top-tier Wolf & Sub-Zero appliances, three sinks, two dishwashers, a wine refrigerator, a warming drawer, and more — a true chef’s delight.\n
\n
Comfort is built into every detail, with nine zones of central air, radiant heat, and two wood-burning fireplaces ensuring year-round enjoyment. Wellness enthusiasts will appreciate the unique indoor Endless pool, while the finished basement with a full bath provides additional versatile space. The home also includes a two-car attached garage, a whole-house sound system, and a dramatic curved staircase connecting all three levels.\n
\n
1331 Harbor Road is more than just a home — it’s a rare opportunity to embrace luxury, privacy, and sophistication in one of Long Island’s most sought-after neighborhoods.
"""
+"Appliances": array:10 [ …10]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "888-276-0630"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 7
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "347-771-7288"
+"BuyerAgentEmail": "mahir@sadman.homes"
+"BuyerAgentFullName": "Mahir Sadman SFR"
+"BuyerAgentKey": "326221014"
+"BuyerAgentMlsId": "211779"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110398"
+"BuyerOfficeMlsId": "CMPA01"
+"BuyerOfficeName": "Compass Greater NY LLC"
+"BuyerOfficePhone": "212-913-9058"
+"CoBuyerAgentAOR": "HGAR"
+"CoBuyerAgentDirectPhone": "000-000-0000"
+"CoBuyerAgentFullName": "Unrepresented Buyer"
+"CoBuyerAgentKey": "421786246"
+"CoBuyerAgentMlsId": "347752"
+"CoBuyerOfficeKey": "1262827"
+"CoBuyerOfficeMlsId": "888888"
+"CoBuyerOfficeName": "Buyer Representation Office"
+"CoBuyerOfficePhone": "000-000-0000"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-08T01:29:22.775001+00:00"
+"CumulativeDaysOnMarket": 154
+"DaysOnMarket": 154
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"ExpirationDate": "2026-03-31"
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:3 [ …3]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:22 [ …22]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-771-7288"
+"ListAgentEmail": "mahir@sadman.homes"
+"ListAgentKey": "326221014"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326111282"
+"ListOfficePhone": "888-276-0630"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-08-06"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.75
+"LotSizeSquareFeet": 32670
+"MajorChangeTimestamp": "2026-01-11T02:43:48Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-10"
+"OnMarketDate": "2025-08-07"
+"OriginalEntryTimestamp": "2025-08-08T01:25:06Z"
+"OriginalListPrice": 3349999
+"OriginatingSystemModificationTimestamp": "2026-01-11T02:43:48Z"
+"OwnerName": "Goorsammy"
+"ParcelNumber": "2017-42-219-00-0103-0"
+"PhotosChangeTimestamp": "2025-09-30T04:18:51Z"
+"PhotosCount": 50
+"PoolPrivateYN": true
+"PostalCity": "Hewlett Harbor"
+"PostalCodePlus4": "2640"
+"PreviousListPrice": 3349999
+"PriceChangeTimestamp": "2025-09-30T04:17:26Z"
+"PurchaseContractDate": "2026-01-09"
+"RoomsTotal": "21"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "347-771-7288"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-11T02:43:48Z"
+"StreetName": "Harbor"
+"StreetNumber": "1331"
+"StreetNumberNumeric": "1331"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "33880.87"
+"TaxYear": "2025"
+"Utilities": array:7 [ …7]
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=vWxxQoWPCqh"
+"WaterSource": array:1 [ …1]
+"YearBuiltEffective": 2005
+"KEY_Attic": "Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "2999999.00"
+"KEY_ContractPrice": "2800000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "6200.00"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "483.87081"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3999998.6667"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "483.87081"
+"KEY_SourceSystemModificationTimestamp": "2025-08-07T21:25:05.837"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "322.58054"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.89552"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "322.58054"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421365589')"
+"provider_name": "One Key"
+"Media": array:50 [ …50]
+"ID": "27783"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4605
+post_id: "27779"
+post_author: 1
+"ListingKey": "KEY421362093"
+"ListingId": "898913"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-10-09T07:07:51Z"
+"RFModificationTimestamp": "2025-10-09T07:10:47Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1241.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "535 Marina Pointe Drive Unit 535, Hempstead, New York 11518"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mark R. Doneson"
+"ListOfficeName": "Premier Prop At Meadowbrook Pt"
+"ListAgentMlsId": "9045384"
+"ListOfficeMlsId": "MRD01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 535 Marina Pointe Drive, a thoughtfully designed 2-bedroom, 2-bath condo suite offering 1,241 square feet of stylish, open-concept living. This bright and airy home features a spacious primary bedroom with an oversized closet and a private en-suite bath, complete with a dual-sink vanity and shower.\n
The chef-inspired kitchen—equipped with a center island, modern appliances, and ample storage—flows seamlessly into the living room and dining area, perfect for both entertaining and relaxing. Large windows invite natural light into every corner, enhancing the home’s warmth and openness.\n
The second bedroom, located on the opposite end for added privacy, includes its own oversized closet and is adjacent to the full secondary bathroom. A private balcony extends your living space outdoors, offering water views—perfect for enjoying your morning coffee or unwinding in the evening.\n
Located within a beautifully maintained community, this condo blends low-maintenance living with elegant design. Sale may be subject to term & conditions of an offering plan. This property is subject to an existing tax exemption as outlined in the offering plan. Purchaser should independently verify tax information.
"""
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "760.13"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [ …4]
+"AssociationYN": true
+"AttributionContact": "516-713-6626"
+"BathroomsFull": 2
+"BuilderModel": "F"
+"BuildingAreaUnits": "Square Feet"
+"CommonWalls": array:1 [ …1]
+"CommunityFeatures": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-07T20:47:24.738042+00:00"
+"CumulativeDaysOnMarket": 63
+"DaysOnMarket": 63
+"ElementarySchool": "Rhame Avenue Elementary School"
+"ElementarySchoolDistrict": "East Rockaway"
+"ExpirationDate": "2025-10-09"
+"ExteriorFeatures": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "markrd48@aol.com"
+"ListAgentKey": "326258530"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113842"
+"ListOfficePhone": "516-713-6626"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-08-07"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2025-10-09T04:10:56Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-10-09"
+"OnMarketDate": "2025-08-07"
+"OriginalEntryTimestamp": "2025-08-07T20:41:20Z"
+"OriginalListPrice": 649000
+"OriginatingSystemModificationTimestamp": "2025-10-09T04:10:56Z"
+"OwnerName": "Beechwood Homes"
+"ParkingFeatures": array:2 [ …2]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-09-25T07:06:47Z"
+"PhotosCount": 9
+"PostalCity": "East Rockaway"
+"PropertyAttachedYN": true
+"RoomsTotal": "4"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-206-6228"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-10-09T04:10:56Z"
+"StreetName": "Marina Pointe"
+"StreetNumber": "535"
+"StreetNumberNumeric": "535"
+"StreetSuffix": "Drive"
+"SubdivisionName": "Marina Pointe"
+"SyndicateTo": array:1 [ …1]
+"TaxYear": "2025"
+"UnitNumber": "535"
+"Utilities": array:4 [ …4]
+"View": "Water"
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:2 [ …2]
+"WaterfrontYN": true
+"KEY_Attic": "None"
+"KEY_TaxSource": "Other"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "649000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1241.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "522.96535"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "522.96535"
+"KEY_SourceSystemModificationTimestamp": "2025-08-07T16:34:58.200"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421362093')"
+"provider_name": "One Key"
+"Media": array:9 [ …9]
+"ID": "27779"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#317
+post_id: "27766"
+post_author: 1
+"ListingKey": "KEY421361554"
+"ListingId": "898892"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-11-08T05:11:37Z"
+"RFModificationTimestamp": "2025-11-08T05:21:56Z"
+"ListPrice": 759000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1600.0
+"BuildingAreaTotal": 1598.0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "2457 Williams Court, Hempstead, New York 11710"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.656476
+"Longitude": -73.5331631
+"YearBuilt": 1931
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Michael Lobasso"
+"ListOfficeName": "Charles Rutenberg Realty Inc"
+"ListAgentMlsId": "205441"
+"ListOfficeMlsId": "CHRU01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Nestled just one block away from the serene Bellmore Shores, this gorgeous and well-maintained Colonial house is the perfect place to call home. This completely updated residence offers a blend of modern amenities and classic charm, with an open-concept layout that is perfect for both relaxing and entertaining. \n
\n
Step inside to the main level, where you'll find a spacious Living Room that flows seamlessly into the Dining Room and a beautiful Eat-in Kitchen. The kitchen is a chef's delight, featuring sleek stainless steel appliances. For your comfort, the first floor is equipped with radiant heat, making it a cozy haven during cooler months. \n
\n
Upstairs, the second floor features a spacious Master Bedroom complete with a walk-in closet. Two additional generous bedrooms and a full bathroom provide plenty of space for family or guests. Hardwood floors throughout the home add a touch of elegance and warmth. \n
\n
This home also boasts a prime location with street and driveway parking, and easy access to the railroad. A true standout feature is the included deeded boat rights to docking at a nearby marina, a massive bonus for any boating enthusiast!
"""
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "michaellobasso.sold@gmail.com"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-655-4396"
+"CoListAgentEmail": "Reneeblitz67@yahoo.com"
+"CoListAgentFullName": "Renee Blitz"
+"CoListAgentKey": "419367178"
+"CoListAgentMlsId": "503536"
+"CoListOfficeKey": "326110310"
+"CoListOfficeMlsId": "CHRU01"
+"CoListOfficeName": "Charles Rutenberg Realty Inc"
+"CoListOfficePhone": "516-575-7500"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-07T20:12:46.086560+00:00"
+"CumulativeDaysOnMarket": 90
+"DaysOnMarket": 90
+"ElementarySchool": "Shore Road School"
+"ElementarySchoolDistrict": "Bellmore"
+"ExpirationDate": "2025-11-08"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-575-7500"
+"ListAgentEmail": "michaellobasso.sold@gmail.com"
+"ListAgentKey": "326214857"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110310"
+"ListOfficePhone": "516-575-7500"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-08-07"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.0918
+"LotSizeSquareFeet": 4000
+"MajorChangeTimestamp": "2025-11-08T05:10:21Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Grand Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-11-05"
+"OnMarketDate": "2025-08-07"
+"OriginalEntryTimestamp": "2025-08-07T20:09:17Z"
+"OriginalListPrice": 759000
+"OriginatingSystemModificationTimestamp": "2025-11-08T05:10:21Z"
+"OwnerName": "Lent"
+"ParcelNumber": "2089-63-159-00-0070-0"
+"PhotosChangeTimestamp": "2025-10-21T15:15:36Z"
+"PhotosCount": 12
+"PoolFeatures": array:1 [ …1]
+"PoolPrivateYN": true
+"PostalCity": "Bellmore"
+"PostalCodePlus4": "4804"
+"PriceChangeTimestamp": "2025-08-07T20:09:17Z"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-322-0887"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-11-08T05:10:21Z"
+"StreetName": "Williams"
+"StreetNumber": "2457"
+"StreetNumberNumeric": "2457"
+"StreetSuffix": "Court"
+"SyndicateTo": array:1 [ …1]
+"TaxAnnualAmount": "12602.07"
+"TaxAssessedValue": 450
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "759000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Withdrawn"
+"KEY_AdditionalFeesYN": "0"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1600.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-655-4396"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "474.37500"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8267973.8562"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "474.37500"
+"KEY_SourceSystemModificationTimestamp": "2025-08-07T16:09:18.020"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "474.96871"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "474.96871"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421361554')"
+"provider_name": "One Key"
+"Media": array:12 [ …12]
+"ID": "27766"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5111
+post_id: "27772"
+post_author: 1
+"ListingKey": "KEY421350844"
+"ListingId": "898597"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2025-08-11T22:55:55Z"
+"RFModificationTimestamp": "2025-08-11T22:57:49Z"
+"ListPrice": 1500000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2898.0
+"BuildingAreaTotal": 3265.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "2546 Harvey Avenue, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6478043
+"Longitude": -73.6275777
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Patricia A. Murphy CBR"
+"ListOfficeName": "Village Plaza Realty"
+"ListAgentMlsId": "93410"
+"ListOfficeMlsId": "VILL01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This one-of-a-kind impressive custom built in 2015 center hall colonial features the best construction and finishes available. The details in this home are the top of the line and amazing. The exterior is all stucco and features the best available custom windows. As you walk up to this home you will walk up the paver walkway to the portico and in front of the custom double door entrance. As you enter the home, you will be in the wide entry hallway with a coat closet, half bath and wide solid wood staircase. To the left is the large living room and then into the even larger family room with a fireplace. Off of the entry foyer to the right is the large banquet formal dining room and then also accessed from the center hall is the very large custom eat-in-kitchen with high end appliances, custom wood cabinets, island and granite counters. There is also a large dining area in the kitchen. Off of the kitchen is the entrance to the oversized one-car electric eye opener garage with a double wide paver driveway. As you ascend the wide staircase, you will be on the second floor and to the left is a huge primary bedroom retreat with two large walk-in closets and office or nursery, an amazing large top of the line full bath with a separate soaking tub, large steam shower, toilet and double sinks. There is a large private terrace off of the primary bedroom. There are three additional very large bedrooms all with large closets and a beautiful hall bath. There is a huge unfinished attic space. The full basement is also finished with high ceilings. The private, fully PVC fenced back yard is like an outstanding island oasis. The private yard features tall mature plantings, a large salt water in-ground heated pool, a hot tub for five or six people, an outdoor kitchen and a covered sitting area. There is 2,898 square feet of living space excluding the finished basement and the property is 8,000 square feet or 80X100. There are in-ground sprinklers, central air, hardwood floors throughout, all gas cooking and heating, the best available central station alarm burglar and fire security system with cameras around the house and so much more! This is a totally custom home with the best available materials in and out. There is nothing like this home on the market. This house is a must see!!!"
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-680-6346"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaSource": "Plans"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-07T13:28:52.426687+00:00"
+"CrossStreet": "Allen Street/Nassau Parkway"
+"CumulativeDaysOnMarket": 4
+"DaysOnMarket": 4
+"DirectionFaces": "East"
+"Directions": "Foxhurst Road to Harvey Avenue to #2546"
+"Disclosures": array:2 [ …2]
+"ElementarySchool": "School 3"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-05-31"
+"ExteriorFeatures": array:5 [ …5]
+"Fencing": array:3 [ …3]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [ …3]
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:3 [ …3]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:15 [ …15]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-680-6346"
+"ListAgentEmail": "info@villageplaza.com"
+"ListAgentKey": "326265261"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326116330"
+"ListOfficePhone": "516-593-5455"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-08-07"
+"ListingTerms": "1031 Exchange,Cash,Conventional"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:8 [ …8]
+"LotSizeAcres": 0.1837
+"LotSizeDimensions": "80X100"
+"LotSizeSquareFeet": 8000
+"MajorChangeTimestamp": "2025-08-11T22:54:59Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlsStatus": "Hold"
+"OffMarketDate": "2025-08-11"
+"OnMarketDate": "2025-08-07"
+"OriginalEntryTimestamp": "2025-08-07T13:22:34Z"
+"OriginalListPrice": 1500000
+"OriginatingSystemModificationTimestamp": "2025-08-11T22:54:59Z"
+"OwnerName": "Brennan"
+"ParcelNumber": "2089-54-159-00-0011-0"
+"ParkingFeatures": array:8 [ …8]
+"ParkingTotal": "5"
+"PhotosChangeTimestamp": "2025-08-07T13:33:36Z"
+"PhotosCount": 49
+"PoolFeatures": array:6 [ …6]
+"PoolPrivateYN": true
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "2418"
+"PriceChangeTimestamp": "2025-08-07T13:22:34Z"
+"PropertyCondition": array:1 [ …1]
+"RoadFrontageType": array:1 [ …1]
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-680-6346"
+"ShowingRequirements": array:5 [ …5]
+"SpaFeatures": array:1 [ …1]
+"SpaYN": true
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-08-11T22:54:59Z"
+"StreetName": "Harvey"
+"StreetNumber": "2546"
+"StreetNumberNumeric": "2546"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [ …1]
+"TaxAnnualAmount": "16761.73"
+"TaxAssessedValue": 744
+"TaxBlock": "159"
+"TaxLot": "11"
+"TaxYear": "2024"
+"Utilities": array:7 [ …7]
+"View": "Neighborhood"
+"VirtualTourURLBranded": "https://tours.longislandvirtual.com/288667"
+"VirtualTourURLUnbranded": "https://tours.longislandvirtual.com/idx/288667"
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:4 [ …4]
+"YearBuiltEffective": 2015
+"KEY_Attic": "Full,Storage,Unfinished"
+"KEY_HoldDate": "2025-08-11"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "54"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1500000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "2898.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "517.59834"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8165487.2074"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "517.59834"
+"KEY_SourceSystemModificationTimestamp": "2025-08-07T09:22:34.027"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "459.41807"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "459.41807"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421350844')"
+"provider_name": "One Key"
+"Media": array:49 [ …49]
+"ID": "27772"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4567
+post_id: "27854"
+post_author: 1
+"ListingKey": "KEY421347414"
+"ListingId": "898531"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-02-06T07:02:39Z"
+"RFModificationTimestamp": "2026-02-06T07:04:26Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1148.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "1013 Stafford Road, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6811395
+"Longitude": -73.7068249
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Connie Chan"
+"ListOfficeName": "Sung & Associates Real Estate"
+"ListAgentMlsId": "94291"
+"ListOfficeMlsId": "SA01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
This contemporary Ranch home, situated in the heart of Valley Stream, boasts three\n
spacious bedrooms and two bathrooms, blending modern updates with classic\n
elegance. The custom-built kitchen is an ideal chef’s haven, equipped with new stainless\n
steel appliances, Heated floor. The primary bedroom offers a private sanctuary with an en-suite\n
bathroom, Step outside from the new kitchen to enjoy the rear patio\n
and private garden ideal for relaxation. The fully finished basement provides exceptional\n
space for additional entertainment and recreational area. New heating system and AG oil\n
tank. A full size single garage with newly done double driveway. It’s prime location off as a\n
short walk to schools, transportation and a park making this move in and ready gem and\n
ideal blend of space style and convenience.
"""
+"Appliances": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-825-3400"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-13T16:00:36.666699+00:00"
+"CumulativeDaysOnMarket": 177
+"DaysOnMarket": 177
+"ElementarySchool": "Howell Road School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-02-06"
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "connie.sungassoc@gmail.com"
+"ListAgentKey": "326266000"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115348"
+"ListOfficePhone": "516-825-3400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-08-13"
+"LivingAreaSource": "Public Records"
+"LotSizeDimensions": "69x100"
+"LotSizeSquareFeet": 6900
+"MajorChangeTimestamp": "2026-02-06T05:11:07Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-02-06"
+"OnMarketDate": "2025-08-13"
+"OriginalEntryTimestamp": "2025-08-13T15:57:24Z"
+"OriginalListPrice": 885000
+"OriginatingSystemModificationTimestamp": "2026-02-06T05:11:07Z"
+"OwnerName": "Badrinath"
+"ParcelNumber": "37582 00270"
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-09-25T14:50:36Z"
+"PhotosCount": 30
+"PostalCity": "Valley Stream"
+"PreviousListPrice": 829000
+"PriceChangeTimestamp": "2025-11-21T04:47:26Z"
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-825-3400"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-06T05:11:07Z"
+"StreetName": "Stafford"
+"StreetNumber": "1013"
+"StreetNumberNumeric": "1013"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "10897.19"
+"TaxBlock": "582"
+"TaxLot": "27"
+"TaxYear": "2025"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Other"
+"KEY_TaxSection": "37"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "799000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1148.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-236-1937"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "695.99303"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "695.99303"
+"KEY_SourceSystemModificationTimestamp": "2025-08-06T21:58:20.497"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.90282"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421347414')"
+"provider_name": "One Key"
+"Media": array:30 [ …30]
+"ID": "27854"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4464
+post_id: "27753"
+post_author: 1
+"ListingKey": "KEY421343219"
+"ListingId": "898407"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-02-26T07:01:41Z"
+"RFModificationTimestamp": "2026-02-26T07:02:41Z"
+"ListPrice": 690000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1108.0
+"BuildingAreaTotal": 1108.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "110 Woodside Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6704697
+"Longitude": -73.5831881
+"YearBuilt": 1930
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Robert Hakimian"
+"ListOfficeName": "Fox 21"
+"ListAgentMlsId": "123359"
+"ListOfficeMlsId": "ROOZ01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "BACK IN MARKET. RENOVATED. 2 STORY SINGLE FAMILY HOUSE. 3 BEDROOMS 1 & 1/2 BATH. FULL FINISHED BASEMENT. GARAGE. VERY LARGE BACKYARD. BEDROOM ON FIRST FLOOR. ROOSEVELT SD-8"
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-637-8344"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerOfficeAOR": "LIBOR"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-06T20:19:45.145465+00:00"
+"CrossStreet": "Union St"
+"CumulativeDaysOnMarket": 122
+"DaysOnMarket": 122
+"DirectionFaces": "North"
+"ElementarySchool": "Centennial Avenue Elementary School"
+"ElementarySchoolDistrict": "Roosevelt"
+"ExpirationDate": "2026-06-30"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Roosevelt High School"
+"HighSchoolDistrict": "Roosevelt"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-859-1611"
+"ListAgentEmail": "Hakimianr52@gmail.com"
+"ListAgentKey": "326138440"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115207"
+"ListOfficePhone": "516-637-8344"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-08-06"
+"ListingTerms": "Contract"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:1 [ …1]
+"LotSizeAcres": 0.1119
+"LotSizeDimensions": "39x125 aprox"
+"LotSizeSquareFeet": 4875
+"MajorChangeTimestamp": "2026-02-25T14:11:01Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "Roosevelt Middle School"
+"MiddleOrJuniorSchoolDistrict": "Roosevelt"
+"MlsStatus": "Hold"
+"OffMarketDate": "2026-02-25"
+"OnMarketDate": "2025-08-06"
+"OriginalEntryTimestamp": "2025-08-06T20:14:45Z"
+"OriginalListPrice": 768000
+"OriginatingSystemModificationTimestamp": "2026-02-25T14:11:01Z"
+"OwnerName": "Island Homes Inc"
+"ParcelNumber": "2009-55-362-00-0153-0"
+"PhotosChangeTimestamp": "2025-10-28T20:31:59Z"
+"PhotosCount": 14
+"PostalCity": "Freeport"
+"PostalCodePlus4": "1239"
+"PreviousListPrice": 665000
+"PriceChangeTimestamp": "2026-02-25T00:41:57Z"
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-859-1611"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-25T14:11:01Z"
+"StreetName": "Woodside"
+"StreetNumber": "110"
+"StreetNumberNumeric": "110"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "9070"
+"TaxAssessedValue": 342
+"TaxBlock": "362"
+"TaxLot": "153"
+"TaxYear": "2024"
+"Utilities": array:2 [ …2]
+"WaterSource": array:1 [ …1]
+"YearBuiltEffective": 1930
+"KEY_Attic": "None"
+"KEY_Village": "Freeport"
+"KEY_HoldDate": "2026-02-25"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "55"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "690000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "1108.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "622.74368"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6166219.8391"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "622.74368"
+"KEY_SourceSystemModificationTimestamp": "2025-08-06T16:14:45.803"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "622.74368"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.89844"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "622.74368"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421343219')"
+"provider_name": "One Key"
+"Media": array:14 [ …14]
+"ID": "27753"
}
]
+success: true
+page_size: 6
+page_count: 254
+count: 1520
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Cache Key: 1d61192b749889fa7abbd049779832887332f13acb3f6ace4f5a5f9d7de85e71" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5942
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5900
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY421365589"
+"ListingId": "899002"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-11T02:45:36Z"
+"RFModificationTimestamp": "2026-01-11T02:50:23Z"
+"ListPrice": 2999999.0
+"BathroomsTotalInteger": 8.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 6200.0
+"BuildingAreaTotal": 9300.0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "1331 Harbor Road, Hempstead, New York 11557"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6362531
+"Longitude": -73.6850699
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mahir Sadman SFR"
+"ListOfficeName": "EXP Realty"
+"ListAgentMlsId": "211779"
+"ListOfficeMlsId": "EXP02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Experience refined living at 1331 Harbor Road, an exceptional residence in the prestigious Hewlett Harbor community.\n
\n
This distinctive Norman-style masterpiece — once showcased in Architectural Digest and designed by the renowned Dorothy Draper & Co. — combines timeless elegance with thoughtful modern updates. Set on a lush ¾-acre lot, the property is surrounded by mature landscaping that creates a serene, private retreat. A stunning glass conservatory invites you to take in the tranquil garden views, offering the perfect setting for quiet moments or intimate gatherings.\n
\n
Inside, you’ll find five generously sized bedrooms, each complete with its own en-suite bath, plus three additional bathrooms for guests. The open-concept layout, extensively redesigned in 2005, allows for effortless entertaining and a natural flow between living spaces. The gourmet eat-in kitchen is a showstopper, featuring vaulted ceilings, top-tier Wolf & Sub-Zero appliances, three sinks, two dishwashers, a wine refrigerator, a warming drawer, and more — a true chef’s delight.\n
\n
Comfort is built into every detail, with nine zones of central air, radiant heat, and two wood-burning fireplaces ensuring year-round enjoyment. Wellness enthusiasts will appreciate the unique indoor Endless pool, while the finished basement with a full bath provides additional versatile space. The home also includes a two-car attached garage, a whole-house sound system, and a dramatic curved staircase connecting all three levels.\n
\n
1331 Harbor Road is more than just a home — it’s a rare opportunity to embrace luxury, privacy, and sophistication in one of Long Island’s most sought-after neighborhoods.
"""
+"Appliances": array:10 [ …10]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "888-276-0630"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 7
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "347-771-7288"
+"BuyerAgentEmail": "mahir@sadman.homes"
+"BuyerAgentFullName": "Mahir Sadman SFR"
+"BuyerAgentKey": "326221014"
+"BuyerAgentMlsId": "211779"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110398"
+"BuyerOfficeMlsId": "CMPA01"
+"BuyerOfficeName": "Compass Greater NY LLC"
+"BuyerOfficePhone": "212-913-9058"
+"CoBuyerAgentAOR": "HGAR"
+"CoBuyerAgentDirectPhone": "000-000-0000"
+"CoBuyerAgentFullName": "Unrepresented Buyer"
+"CoBuyerAgentKey": "421786246"
+"CoBuyerAgentMlsId": "347752"
+"CoBuyerOfficeKey": "1262827"
+"CoBuyerOfficeMlsId": "888888"
+"CoBuyerOfficeName": "Buyer Representation Office"
+"CoBuyerOfficePhone": "000-000-0000"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-08T01:29:22.775001+00:00"
+"CumulativeDaysOnMarket": 154
+"DaysOnMarket": 154
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"ExpirationDate": "2026-03-31"
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:3 [ …3]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:22 [ …22]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-771-7288"
+"ListAgentEmail": "mahir@sadman.homes"
+"ListAgentKey": "326221014"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326111282"
+"ListOfficePhone": "888-276-0630"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-08-06"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.75
+"LotSizeSquareFeet": 32670
+"MajorChangeTimestamp": "2026-01-11T02:43:48Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-10"
+"OnMarketDate": "2025-08-07"
+"OriginalEntryTimestamp": "2025-08-08T01:25:06Z"
+"OriginalListPrice": 3349999
+"OriginatingSystemModificationTimestamp": "2026-01-11T02:43:48Z"
+"OwnerName": "Goorsammy"
+"ParcelNumber": "2017-42-219-00-0103-0"
+"PhotosChangeTimestamp": "2025-09-30T04:18:51Z"
+"PhotosCount": 50
+"PoolPrivateYN": true
+"PostalCity": "Hewlett Harbor"
+"PostalCodePlus4": "2640"
+"PreviousListPrice": 3349999
+"PriceChangeTimestamp": "2025-09-30T04:17:26Z"
+"PurchaseContractDate": "2026-01-09"
+"RoomsTotal": "21"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "347-771-7288"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-11T02:43:48Z"
+"StreetName": "Harbor"
+"StreetNumber": "1331"
+"StreetNumberNumeric": "1331"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "33880.87"
+"TaxYear": "2025"
+"Utilities": array:7 [ …7]
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=vWxxQoWPCqh"
+"WaterSource": array:1 [ …1]
+"YearBuiltEffective": 2005
+"KEY_Attic": "Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "2999999.00"
+"KEY_ContractPrice": "2800000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "6200.00"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "483.87081"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3999998.6667"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "483.87081"
+"KEY_SourceSystemModificationTimestamp": "2025-08-07T21:25:05.837"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "322.58054"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.89552"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "322.58054"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421365589')"
+"provider_name": "One Key"
+"Media": array:50 [ …50]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5884
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY421362093"
+"ListingId": "898913"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-10-09T07:07:51Z"
+"RFModificationTimestamp": "2025-10-09T07:10:47Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1241.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "535 Marina Pointe Drive Unit 535, Hempstead, New York 11518"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mark R. Doneson"
+"ListOfficeName": "Premier Prop At Meadowbrook Pt"
+"ListAgentMlsId": "9045384"
+"ListOfficeMlsId": "MRD01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 535 Marina Pointe Drive, a thoughtfully designed 2-bedroom, 2-bath condo suite offering 1,241 square feet of stylish, open-concept living. This bright and airy home features a spacious primary bedroom with an oversized closet and a private en-suite bath, complete with a dual-sink vanity and shower.\n
The chef-inspired kitchen—equipped with a center island, modern appliances, and ample storage—flows seamlessly into the living room and dining area, perfect for both entertaining and relaxing. Large windows invite natural light into every corner, enhancing the home’s warmth and openness.\n
The second bedroom, located on the opposite end for added privacy, includes its own oversized closet and is adjacent to the full secondary bathroom. A private balcony extends your living space outdoors, offering water views—perfect for enjoying your morning coffee or unwinding in the evening.\n
Located within a beautifully maintained community, this condo blends low-maintenance living with elegant design. Sale may be subject to term & conditions of an offering plan. This property is subject to an existing tax exemption as outlined in the offering plan. Purchaser should independently verify tax information.
"""
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "760.13"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [ …4]
+"AssociationYN": true
+"AttributionContact": "516-713-6626"
+"BathroomsFull": 2
+"BuilderModel": "F"
+"BuildingAreaUnits": "Square Feet"
+"CommonWalls": array:1 [ …1]
+"CommunityFeatures": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-07T20:47:24.738042+00:00"
+"CumulativeDaysOnMarket": 63
+"DaysOnMarket": 63
+"ElementarySchool": "Rhame Avenue Elementary School"
+"ElementarySchoolDistrict": "East Rockaway"
+"ExpirationDate": "2025-10-09"
+"ExteriorFeatures": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "markrd48@aol.com"
+"ListAgentKey": "326258530"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113842"
+"ListOfficePhone": "516-713-6626"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-08-07"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2025-10-09T04:10:56Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-10-09"
+"OnMarketDate": "2025-08-07"
+"OriginalEntryTimestamp": "2025-08-07T20:41:20Z"
+"OriginalListPrice": 649000
+"OriginatingSystemModificationTimestamp": "2025-10-09T04:10:56Z"
+"OwnerName": "Beechwood Homes"
+"ParkingFeatures": array:2 [ …2]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-09-25T07:06:47Z"
+"PhotosCount": 9
+"PostalCity": "East Rockaway"
+"PropertyAttachedYN": true
+"RoomsTotal": "4"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-206-6228"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-10-09T04:10:56Z"
+"StreetName": "Marina Pointe"
+"StreetNumber": "535"
+"StreetNumberNumeric": "535"
+"StreetSuffix": "Drive"
+"SubdivisionName": "Marina Pointe"
+"SyndicateTo": array:1 [ …1]
+"TaxYear": "2025"
+"UnitNumber": "535"
+"Utilities": array:4 [ …4]
+"View": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:2 [ …2]
+"WaterfrontYN": true
+"KEY_Attic": "None"
+"KEY_TaxSource": "Other"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "649000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1241.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "522.96535"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "522.96535"
+"KEY_SourceSystemModificationTimestamp": "2025-08-07T16:34:58.200"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421362093')"
+"provider_name": "One Key"
+"Media": array:9 [ …9]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5482
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY421361554"
+"ListingId": "898892"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-11-08T05:11:37Z"
+"RFModificationTimestamp": "2025-11-08T05:21:56Z"
+"ListPrice": 759000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1600.0
+"BuildingAreaTotal": 1598.0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "2457 Williams Court, Hempstead, New York 11710"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.656476
+"Longitude": -73.5331631
+"YearBuilt": 1931
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Michael Lobasso"
+"ListOfficeName": "Charles Rutenberg Realty Inc"
+"ListAgentMlsId": "205441"
+"ListOfficeMlsId": "CHRU01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Nestled just one block away from the serene Bellmore Shores, this gorgeous and well-maintained Colonial house is the perfect place to call home. This completely updated residence offers a blend of modern amenities and classic charm, with an open-concept layout that is perfect for both relaxing and entertaining. \n
\n
Step inside to the main level, where you'll find a spacious Living Room that flows seamlessly into the Dining Room and a beautiful Eat-in Kitchen. The kitchen is a chef's delight, featuring sleek stainless steel appliances. For your comfort, the first floor is equipped with radiant heat, making it a cozy haven during cooler months. \n
\n
Upstairs, the second floor features a spacious Master Bedroom complete with a walk-in closet. Two additional generous bedrooms and a full bathroom provide plenty of space for family or guests. Hardwood floors throughout the home add a touch of elegance and warmth. \n
\n
This home also boasts a prime location with street and driveway parking, and easy access to the railroad. A true standout feature is the included deeded boat rights to docking at a nearby marina, a massive bonus for any boating enthusiast!
"""
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "michaellobasso.sold@gmail.com"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-655-4396"
+"CoListAgentEmail": "Reneeblitz67@yahoo.com"
+"CoListAgentFullName": "Renee Blitz"
+"CoListAgentKey": "419367178"
+"CoListAgentMlsId": "503536"
+"CoListOfficeKey": "326110310"
+"CoListOfficeMlsId": "CHRU01"
+"CoListOfficeName": "Charles Rutenberg Realty Inc"
+"CoListOfficePhone": "516-575-7500"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-07T20:12:46.086560+00:00"
+"CumulativeDaysOnMarket": 90
+"DaysOnMarket": 90
+"ElementarySchool": "Shore Road School"
+"ElementarySchoolDistrict": "Bellmore"
+"ExpirationDate": "2025-11-08"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-575-7500"
+"ListAgentEmail": "michaellobasso.sold@gmail.com"
+"ListAgentKey": "326214857"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110310"
+"ListOfficePhone": "516-575-7500"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-08-07"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.0918
+"LotSizeSquareFeet": 4000
+"MajorChangeTimestamp": "2025-11-08T05:10:21Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Grand Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-11-05"
+"OnMarketDate": "2025-08-07"
+"OriginalEntryTimestamp": "2025-08-07T20:09:17Z"
+"OriginalListPrice": 759000
+"OriginatingSystemModificationTimestamp": "2025-11-08T05:10:21Z"
+"OwnerName": "Lent"
+"ParcelNumber": "2089-63-159-00-0070-0"
+"PhotosChangeTimestamp": "2025-10-21T15:15:36Z"
+"PhotosCount": 12
+"PoolFeatures": array:1 [ …1]
+"PoolPrivateYN": true
+"PostalCity": "Bellmore"
+"PostalCodePlus4": "4804"
+"PriceChangeTimestamp": "2025-08-07T20:09:17Z"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-322-0887"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-11-08T05:10:21Z"
+"StreetName": "Williams"
+"StreetNumber": "2457"
+"StreetNumberNumeric": "2457"
+"StreetSuffix": "Court"
+"SyndicateTo": array:1 [ …1]
+"TaxAnnualAmount": "12602.07"
+"TaxAssessedValue": 450
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "759000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Withdrawn"
+"KEY_AdditionalFeesYN": "0"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1600.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-655-4396"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "474.37500"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8267973.8562"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "474.37500"
+"KEY_SourceSystemModificationTimestamp": "2025-08-07T16:09:18.020"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "474.96871"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "474.96871"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421361554')"
+"provider_name": "One Key"
+"Media": array:12 [ …12]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5916
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY421350844"
+"ListingId": "898597"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2025-08-11T22:55:55Z"
+"RFModificationTimestamp": "2025-08-11T22:57:49Z"
+"ListPrice": 1500000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2898.0
+"BuildingAreaTotal": 3265.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "2546 Harvey Avenue, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6478043
+"Longitude": -73.6275777
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Patricia A. Murphy CBR"
+"ListOfficeName": "Village Plaza Realty"
+"ListAgentMlsId": "93410"
+"ListOfficeMlsId": "VILL01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This one-of-a-kind impressive custom built in 2015 center hall colonial features the best construction and finishes available. The details in this home are the top of the line and amazing. The exterior is all stucco and features the best available custom windows. As you walk up to this home you will walk up the paver walkway to the portico and in front of the custom double door entrance. As you enter the home, you will be in the wide entry hallway with a coat closet, half bath and wide solid wood staircase. To the left is the large living room and then into the even larger family room with a fireplace. Off of the entry foyer to the right is the large banquet formal dining room and then also accessed from the center hall is the very large custom eat-in-kitchen with high end appliances, custom wood cabinets, island and granite counters. There is also a large dining area in the kitchen. Off of the kitchen is the entrance to the oversized one-car electric eye opener garage with a double wide paver driveway. As you ascend the wide staircase, you will be on the second floor and to the left is a huge primary bedroom retreat with two large walk-in closets and office or nursery, an amazing large top of the line full bath with a separate soaking tub, large steam shower, toilet and double sinks. There is a large private terrace off of the primary bedroom. There are three additional very large bedrooms all with large closets and a beautiful hall bath. There is a huge unfinished attic space. The full basement is also finished with high ceilings. The private, fully PVC fenced back yard is like an outstanding island oasis. The private yard features tall mature plantings, a large salt water in-ground heated pool, a hot tub for five or six people, an outdoor kitchen and a covered sitting area. There is 2,898 square feet of living space excluding the finished basement and the property is 8,000 square feet or 80X100. There are in-ground sprinklers, central air, hardwood floors throughout, all gas cooking and heating, the best available central station alarm burglar and fire security system with cameras around the house and so much more! This is a totally custom home with the best available materials in and out. There is nothing like this home on the market. This house is a must see!!!"
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-680-6346"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaSource": "Plans"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-07T13:28:52.426687+00:00"
+"CrossStreet": "Allen Street/Nassau Parkway"
+"CumulativeDaysOnMarket": 4
+"DaysOnMarket": 4
+"DirectionFaces": "East"
+"Directions": "Foxhurst Road to Harvey Avenue to #2546"
+"Disclosures": array:2 [ …2]
+"ElementarySchool": "School 3"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-05-31"
+"ExteriorFeatures": array:5 [ …5]
+"Fencing": array:3 [ …3]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [ …3]
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:3 [ …3]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:15 [ …15]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-680-6346"
+"ListAgentEmail": "info@villageplaza.com"
+"ListAgentKey": "326265261"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326116330"
+"ListOfficePhone": "516-593-5455"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-08-07"
+"ListingTerms": array:3 [ …3]
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:8 [ …8]
+"LotSizeAcres": 0.1837
+"LotSizeDimensions": "80X100"
+"LotSizeSquareFeet": 8000
+"MajorChangeTimestamp": "2025-08-11T22:54:59Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlsStatus": "Hold"
+"OffMarketDate": "2025-08-11"
+"OnMarketDate": "2025-08-07"
+"OriginalEntryTimestamp": "2025-08-07T13:22:34Z"
+"OriginalListPrice": 1500000
+"OriginatingSystemModificationTimestamp": "2025-08-11T22:54:59Z"
+"OwnerName": "Brennan"
+"ParcelNumber": "2089-54-159-00-0011-0"
+"ParkingFeatures": array:8 [ …8]
+"ParkingTotal": "5"
+"PhotosChangeTimestamp": "2025-08-07T13:33:36Z"
+"PhotosCount": 49
+"PoolFeatures": array:6 [ …6]
+"PoolPrivateYN": true
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "2418"
+"PriceChangeTimestamp": "2025-08-07T13:22:34Z"
+"PropertyCondition": array:1 [ …1]
+"RoadFrontageType": array:1 [ …1]
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-680-6346"
+"ShowingRequirements": array:5 [ …5]
+"SpaFeatures": array:1 [ …1]
+"SpaYN": true
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-08-11T22:54:59Z"
+"StreetName": "Harvey"
+"StreetNumber": "2546"
+"StreetNumberNumeric": "2546"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [ …1]
+"TaxAnnualAmount": "16761.73"
+"TaxAssessedValue": 744
+"TaxBlock": "159"
+"TaxLot": "11"
+"TaxYear": "2024"
+"Utilities": array:7 [ …7]
+"View": array:1 [ …1]
+"VirtualTourURLBranded": "https://tours.longislandvirtual.com/288667"
+"VirtualTourURLUnbranded": "https://tours.longislandvirtual.com/idx/288667"
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:4 [ …4]
+"YearBuiltEffective": 2015
+"KEY_Attic": "Full,Storage,Unfinished"
+"KEY_HoldDate": "2025-08-11"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "54"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1500000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "2898.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "517.59834"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8165487.2074"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "517.59834"
+"KEY_SourceSystemModificationTimestamp": "2025-08-07T09:22:34.027"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "459.41807"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "459.41807"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421350844')"
+"provider_name": "One Key"
+"Media": array:49 [ …49]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5918
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY421347414"
+"ListingId": "898531"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-02-06T07:02:39Z"
+"RFModificationTimestamp": "2026-02-06T07:04:26Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1148.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "1013 Stafford Road, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6811395
+"Longitude": -73.7068249
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Connie Chan"
+"ListOfficeName": "Sung & Associates Real Estate"
+"ListAgentMlsId": "94291"
+"ListOfficeMlsId": "SA01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
This contemporary Ranch home, situated in the heart of Valley Stream, boasts three\n
spacious bedrooms and two bathrooms, blending modern updates with classic\n
elegance. The custom-built kitchen is an ideal chef’s haven, equipped with new stainless\n
steel appliances, Heated floor. The primary bedroom offers a private sanctuary with an en-suite\n
bathroom, Step outside from the new kitchen to enjoy the rear patio\n
and private garden ideal for relaxation. The fully finished basement provides exceptional\n
space for additional entertainment and recreational area. New heating system and AG oil\n
tank. A full size single garage with newly done double driveway. It’s prime location off as a\n
short walk to schools, transportation and a park making this move in and ready gem and\n
ideal blend of space style and convenience.
"""
+"Appliances": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-825-3400"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-13T16:00:36.666699+00:00"
+"CumulativeDaysOnMarket": 177
+"DaysOnMarket": 177
+"ElementarySchool": "Howell Road School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-02-06"
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "connie.sungassoc@gmail.com"
+"ListAgentKey": "326266000"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115348"
+"ListOfficePhone": "516-825-3400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-08-13"
+"LivingAreaSource": "Public Records"
+"LotSizeDimensions": "69x100"
+"LotSizeSquareFeet": 6900
+"MajorChangeTimestamp": "2026-02-06T05:11:07Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-02-06"
+"OnMarketDate": "2025-08-13"
+"OriginalEntryTimestamp": "2025-08-13T15:57:24Z"
+"OriginalListPrice": 885000
+"OriginatingSystemModificationTimestamp": "2026-02-06T05:11:07Z"
+"OwnerName": "Badrinath"
+"ParcelNumber": "37582 00270"
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-09-25T14:50:36Z"
+"PhotosCount": 30
+"PostalCity": "Valley Stream"
+"PreviousListPrice": 829000
+"PriceChangeTimestamp": "2025-11-21T04:47:26Z"
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-825-3400"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-06T05:11:07Z"
+"StreetName": "Stafford"
+"StreetNumber": "1013"
+"StreetNumberNumeric": "1013"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "10897.19"
+"TaxBlock": "582"
+"TaxLot": "27"
+"TaxYear": "2025"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Other"
+"KEY_TaxSection": "37"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "799000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1148.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-236-1937"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "695.99303"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "695.99303"
+"KEY_SourceSystemModificationTimestamp": "2025-08-06T21:58:20.497"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.90282"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421347414')"
+"provider_name": "One Key"
+"Media": array:30 [ …30]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5920
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY421343219"
+"ListingId": "898407"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-02-26T07:01:41Z"
+"RFModificationTimestamp": "2026-02-26T07:02:41Z"
+"ListPrice": 690000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1108.0
+"BuildingAreaTotal": 1108.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "110 Woodside Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6704697
+"Longitude": -73.5831881
+"YearBuilt": 1930
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Robert Hakimian"
+"ListOfficeName": "Fox 21"
+"ListAgentMlsId": "123359"
+"ListOfficeMlsId": "ROOZ01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "BACK IN MARKET. RENOVATED. 2 STORY SINGLE FAMILY HOUSE. 3 BEDROOMS 1 & 1/2 BATH. FULL FINISHED BASEMENT. GARAGE. VERY LARGE BACKYARD. BEDROOM ON FIRST FLOOR. ROOSEVELT SD-8"
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-637-8344"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerOfficeAOR": "LIBOR"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-08-06T20:19:45.145465+00:00"
+"CrossStreet": "Union St"
+"CumulativeDaysOnMarket": 122
+"DaysOnMarket": 122
+"DirectionFaces": "North"
+"ElementarySchool": "Centennial Avenue Elementary School"
+"ElementarySchoolDistrict": "Roosevelt"
…94
}
]
+success: true
+page_size: 6
+page_count: 254
+count: 1520
+after_key: ""
}
]
]