array:3 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=1860&$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 {#4696
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4697
+post_id: "24793"
+post_author: 1
+"ListingKey": "KEY418145392"
+"ListingId": "805810"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-08-31T07:01:39Z"
+"RFModificationTimestamp": "2025-08-31T07:02:34Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1726.0
+"BuildingAreaTotal": 1726.0
+"City": "Hempstead"
+"PostalCode": "11598"
+"UnparsedAddress": "838 Peninsula Boulevard, Hempstead, New York 11598"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.693056887404
+"Longitude": -73.632096042223
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Milka Forst"
+"ListOfficeName": "Milky Forst Properties Inc"
+"ListAgentMlsId": "9070197"
+"ListOfficeMlsId": "MLKY01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "charming col. open concept, flr and fdnr , eik main flr bdrm sunrm ,4 large bdrms 3 new bths . gas heat,cac, priced to sell"
+"Appliances": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-239-0306"
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2024-12-16T17:43:41.105058+00:00"
+"CrossStreet": "longacre ave"
+"CumulativeDaysOnMarket": 258
+"DaysOnMarket": 258
+"Directions": "peninsula blvd to 838"
+"ElementarySchool": "Lawrence Elementary School-Broadway"
+"ElementarySchoolDistrict": "Lawrence"
+"ExpirationDate": "2025-08-31"
+"Flooring": array:3 [ …3]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "milky@milkyforstproperties.com"
+"ListAgentKey": "326260589"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113756"
+"ListOfficePhone": "516-239-0306"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2024-12-16"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1148
+"LotSizeDimensions": "50x100"
+"LotSizeSquareFeet": 5000
+"MajorChangeTimestamp": "2025-08-31T04:11:47Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-08-31"
+"OnMarketDate": "2024-12-16"
+"OriginalEntryTimestamp": "2024-12-16T17:42:33Z"
+"OriginalListPrice": 899000
+"OriginatingSystemModificationTimestamp": "2025-08-31T04:11:47Z"
+"OwnerName": "naomi gordon"
+"ParcelNumber": "2089-39-177-00-0092-0"
+"ParkingTotal": "2"
+"PhotosChangeTimestamp": "2025-01-14T07:09:37Z"
+"PhotosCount": 33
+"PostalCity": "Woodmere"
+"PostalCodePlus4": "2426"
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-236-8416"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-08-31T04:11:47Z"
+"StreetName": "Peninsula"
+"StreetNumber": "838"
+"StreetNumberNumeric": "838"
+"StreetSuffix": "Boulevard"
+"SyndicateTo": array:1 [ …1]
+"TaxAnnualAmount": "9916.66"
+"TaxAssessedValue": 603
+"TaxYear": "2023"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Crawl"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "899000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1726.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_ShowingContactPhone2": "516-239-0306"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "520.85747"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7831010.4530"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "520.85747"
+"KEY_SourceSystemModificationTimestamp": "2024-12-15T20:35:00.883"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "520.85747"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "520.85747"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418145392')"
+"provider_name": "One Key"
+"Media": array:33 [ …33]
+"ID": "24793"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5256
+post_id: "24782"
+post_author: 1
+"ListingKey": "KEY418145108"
+"ListingId": "805797"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-04-11T09:04:44Z"
+"RFModificationTimestamp": "2025-04-11T09:23:26Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1658.0
+"BuildingAreaTotal": 1658.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "119 S Bay Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.679045
+"Longitude": -74.164627363636
+"YearBuilt": 1913
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Diana Ruinsky"
+"ListOfficeName": "Island Advantage Realty LLC"
+"ListAgentMlsId": "172263"
+"ListOfficeMlsId": "YOVI01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Entertainers delight, fully updated 3 bedrooms, 1 bath home. Large property with long driveway and 2 car detached garage. Beautiful curb appeal, large, fenced backyard with outdoor spa, large deck and dog run. New roof, siding and exterior completed 2022. Interior, updated 2019. Boiler/ gas conversion 2021. Too many updates to list. 2 additional rooms great for extra living space or office. property sold as is. verify taxes. Possibilities are endless."
+"Appliances": array:13 [ …13]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "631-351-6000"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-425-4434"
+"BuyerAgentEmail": "Listingbycast@gmail.com"
+"BuyerAgentFullName": "Tracey Castaneda"
+"BuyerAgentKey": "326233640"
+"BuyerAgentMlsId": "224843"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326112059"
+"BuyerOfficeMlsId": "HMSM01"
+"BuyerOfficeName": "HomeSmart Premier Living Rlty"
+"BuyerOfficePhone": "516-535-9692"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2024-12-16T00:20:42.513427+00:00"
+"CrossStreet": "Ray St."
+"CumulativeDaysOnMarket": 26
+"DaysOnMarket": 26
+"Disclosures": array:1 [ …1]
+"ElementarySchool": "Leo F Giblyn School"
+"ExpirationDate": "2025-01-30"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-513-2929"
+"ListAgentEmail": "my1realtordr@gmail.com"
+"ListAgentKey": "326183352"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326116614"
+"ListOfficePhone": "631-351-6000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2024-12-15"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.2534
+"LotSizeSquareFeet": 11038
+"MajorChangeTimestamp": "2025-01-16T02:51:23Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2025-01-15"
+"OnMarketDate": "2024-12-20"
+"OriginalEntryTimestamp": "2024-12-16T00:13:31Z"
+"OriginalListPrice": 659000
+"OriginatingSystemModificationTimestamp": "2025-04-11T09:02:29Z"
+"OwnerName": "Diana Ruinsky"
+"ParcelNumber": "2009-62-147-00-0515-0"
+"ParkingTotal": "7"
+"PhotosChangeTimestamp": "2025-01-02T22:36:37Z"
+"PhotosCount": 16
+"PostalCity": "Freeport"
+"PostalCodePlus4": "5417"
+"PriceChangeTimestamp": "2024-12-16T00:13:31Z"
+"PurchaseContractDate": "2025-01-15"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "917-513-2929"
+"ShowingRequirements": array:2 [ …2]
+"SpaYN": true
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-01-16T02:51:23Z"
+"StreetDirPrefix": "S"
+"StreetName": "Bay"
+"StreetNumber": "119"
+"StreetNumberNumeric": "119"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [ …1]
+"TaxAnnualAmount": "7394.37"
+"TaxAssessedValue": 351
+"TaxYear": "2023"
+"Utilities": array:3 [ …3]
+"WaterSource": array:1 [ …1]
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Other"
+"KEY_LivingAreaSearchSqFt": "1658.00"
+"KEY_PreviousStatus": "Active"
+"KEY_CurrentPrice": "659000.00"
+"KEY_ConcessionInPrice": "7000.00"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "397.46683"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "397.46683"
+"KEY_Attic": "Crawl"
+"KEY_OpenHouseCount": "2"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "2600631.4128"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "397.46683"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ContractPrice": "685000.00"
+"KEY_RATIO_ListPrice_By_LivingArea": "397.46683"
+"KEY_SourceSystemModificationTimestamp": "2024-12-15T19:13:31.913"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418145108')"
+"provider_name": "One Key"
+"Media": array:16 [ …16]
+"ID": "24782"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4768
+post_id: "24475"
+post_author: 1
+"ListingKey": "KEY418113496"
+"ListingId": "804847"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Mixed Use"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-06-09T07:02:38Z"
+"RFModificationTimestamp": "2025-06-09T07:07:04Z"
+"ListPrice": 2500000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 4155.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "80 Guy Lombardo Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.654161
+"Longitude": -73.5847536
+"YearBuilt": 1900
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Ivy Garito"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "226580"
+"ListOfficeMlsId": "DERE23"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Unlock a world of possibilities with this unique mixed use property featuring three established medical offices and a charming 3-bedroom residential duplex. Strategically located in a thriving community, this property is perfect for investors or business owners. Features a dedicated parking lot accommodating up to 11 vehicles, providing convenience for clients, patients and residents. The property comes with valuable zoning air rights, allowing for vertical expansion opportunities. Explore the potential to increase revenue through additional medical or residential units. Ideal for professionals in the medical field or investors looking to capitilize on mixed-use space. Perfect for personal use or as a rental property. Don't miss this rare opportunity to own a multifaceted commerical property with incredible potential."
+"AttributionContact": "516-354-6500"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Mixed"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-610-8913"
+"CoListAgentEmail": "Corey.Guglielmo@elliman.com"
+"CoListAgentFullName": "Corey Guglielmo"
+"CoListAgentKey": "326220125"
+"CoListAgentMlsId": "210865"
+"CoListOfficeKey": "326110763"
+"CoListOfficeMlsId": "DERE23"
+"CoListOfficeName": "Douglas Elliman Real Estate"
+"CoListOfficePhone": "516-354-6500"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-01-26T19:35:56.974343+00:00"
+"CumulativeDaysOnMarket": 134
+"DaysOnMarket": 134
+"ExpirationDate": "2025-06-09"
+"Heating": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-635-3344"
+"ListAgentEmail": "ivy.garito@elliman.com"
+"ListAgentKey": "326235334"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110763"
+"ListOfficePhone": "516-354-6500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2024-12-09"
+"LotSizeAcres": 0.178
+"MajorChangeTimestamp": "2025-06-09T04:11:11Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"NumberOfBuildings": 1
+"NumberOfUnitsTotal": "4"
+"OffMarketDate": "2025-06-09"
+"OnMarketDate": "2025-01-26"
+"OriginalEntryTimestamp": "2024-12-12T16:04:28Z"
+"OriginalListPrice": 2800000
+"OriginatingSystemModificationTimestamp": "2025-06-09T04:11:11Z"
+"OwnerName": "Guy Lombardoi Properties LLC"
+"ParcelNumber": "2009-55-331-00-0112-0"
+"ParkingTotal": "11"
+"PhotosChangeTimestamp": "2025-01-26T19:31:36Z"
+"PhotosCount": 14
+"PostalCity": "Freeport"
+"PreviousListPrice": 2800000
+"PriceChangeTimestamp": "2025-03-04T16:59:05Z"
+"PropertyAttachedYN": true
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-06-09T04:11:11Z"
+"StreetName": "Guy Lombardo"
+"StreetNumber": "80"
+"StreetNumberNumeric": "80"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [ …1]
+"TaxAnnualAmount": "18684"
+"TaxBlock": "331"
+"TaxLot": "112"
+"TaxYear": "2023"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"YearBuiltEffective": 2020
+"KEY_ElectricCompany": "PSEG"
+"KEY_Village": "Freeport"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.89286"
+"KEY_PreviousStatus": "Active"
+"KEY_CurrentPrice": "2500000.00"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "601.68472"
+"KEY_MlsDistrictCode": "Freeport"
+"KEY_NumberOfResidentialUnits": "1"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "14044943.8202"
+"KEY_OverheadDoorHeight": "7"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "601.68472"
+"KEY_PermittedUses": "Mixed"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_TaxSection": "55-331"
+"KEY_SourceSystemModificationTimestamp": "2024-12-11T13:53:23.913"
+"KEY_UsableArea": "4155.00"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418113496')"
+"provider_name": "One Key"
+"Media": array:14 [ …14]
+"ID": "24475"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4769
+post_id: "24854"
+post_author: 1
+"ListingKey": "KEY418105063"
+"ListingId": "804550"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-05-11T07:03:38Z"
+"RFModificationTimestamp": "2025-05-11T07:07:40Z"
+"ListPrice": 3498000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2253.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11598"
+"UnparsedAddress": "506-508-510 Longacre Avenue, Hempstead, New York 11598"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.63666435
+"Longitude": -73.720728747108
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Judah Spector"
+"ListOfficeName": "All Going Realty LLC"
+"ListAgentMlsId": "172763"
+"ListOfficeMlsId": "SAYA01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
This opportunity seems quite promising! Here’s a breakdown of the key details regarding the properties for sale at 506, 508, and 510 Longacre in Woodmere: Property Overview:\n
- **Location**: 506, 508, and 510 Longacre, Woodmere\n
- **Current Status**: \n
- 506 Longacre: Rented\n
- 508 Longacre: Approved plans for new development\n
- 510 Longacre: Rented\n
Financials:\n
Total Monthly Rental Income $10,000 (from 506 and 510 Longacre)\n
\n
Development Potential:\n
- **Ability to build**: There is an opportunity to construct 3 separate homes.\n
- **Approved Plans**: Plans for the development of the 508 Longacre property are already approved, \n
Summary:\n
This collection of properties not only generates a decent rental income but also possesses significant potential for development!
"""
+"Appliances": array:2 [ …2]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-206-2005"
+"Basement": array:1 [ …1]
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2024-12-18T00:40:57.029381+00:00"
+"CrossStreet": "Ibsen"
+"CumulativeDaysOnMarket": 145
+"DaysOnMarket": 145
+"ElementarySchool": "Lawrence Elementary School-Broadway"
+"ExpirationDate": "2025-05-11"
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-524-8088"
+"ListAgentEmail": "judah.spector@gmail.com"
+"ListAgentKey": "326183818"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115432"
+"ListOfficePhone": "516-206-2005"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2024-12-11"
+"LotSizeDimensions": "200x100"
+"LotSizeSquareFeet": 20000
+"MajorChangeTimestamp": "2025-05-11T04:10:18Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-05-11"
+"OnMarketDate": "2024-12-17"
+"OriginalEntryTimestamp": "2024-12-18T00:35:28Z"
+"OriginalListPrice": 3498000
+"OriginatingSystemModificationTimestamp": "2025-05-11T04:10:18Z"
+"OwnerName": "80 Church St LLC"
+"ParcelNumber": "2089-39-462-00-0013-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2024-12-18T00:36:36Z"
+"PhotosCount": 5
+"PostalCity": "Woodmere"
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-524-8088"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-05-11T04:10:18Z"
+"StreetName": "Longacre"
+"StreetNumber": "506-508-510"
+"StreetNumberNumeric": "506"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [ …1]
+"TaxAnnualAmount": "17442.84"
+"TaxBlock": "462"
+"TaxLot": "13"
+"TaxYear": "2024"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_IncludedInTaxes": "Sewer,Trash,Water"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "2253.00"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "0"
+"KEY_CurrentPrice": "3498000.00"
+"KEY_NumberOfKitchens": "1"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "1552.59654"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_Attic": "None"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_TaxSection": "39"
+"KEY_RATIO_ListPrice_By_LivingArea": "1552.59654"
+"KEY_SourceSystemModificationTimestamp": "2024-12-10T15:50:43.933"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418105063')"
+"provider_name": "One Key"
+"Media": array:5 [ …5]
+"ID": "24854"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4731
+post_id: "24802"
+post_author: 1
+"ListingKey": "KEY418104826"
+"ListingId": "804542"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-05-01T04:14:37Z"
+"RFModificationTimestamp": "2025-05-01T04:16:23Z"
+"ListPrice": 685000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1100.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "45 Ella Street, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.659963714286
+"Longitude": -73.668345591837
+"YearBuilt": 1920
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Carolyn Campbell Gould CBR"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "104994"
+"ListOfficeMlsId": "DERE03"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This home sits in the charming Village of Valley Stream. This property boasts an array of desirable features situated in a cul-de-sac and offers 3 bedrooms, 2.5 bathrooms provide amble space for comfortable living. The dining room opens to a sliding door that leads to a back patio overlooking a fenced backyard 60X114, perfect for outdoor relaxation and entertaining. One of the unique highlights of this home is an additional room with a separate entrance, offering versatility and potential for various uses. The finished basement also includes a separate entrance, adding to this already fantastic home. Equipped with gas heating. Its prime location provides easy access to transportation, highways, airports, beaches and shopping, making it a convenient and desirable to call home. This is an exciting opportunity to expand with necessary permits, allowing you to customize and enhance to suit your specific needs and preferences!!"
+"Appliances": array:2 [ …2]
+"ArchitecturalStyle": array:2 [ …2]
+"AttributionContact": "516-921-2262"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2024-12-16T15:22:46.870676+00:00"
+"CrossStreet": "Shaw"
+"CumulativeDaysOnMarket": 136
+"DaysOnMarket": 136
+"Directions": "Central to Shaw to Ella"
+"ElementarySchool": "Shaw Avenue School"
+"ExpirationDate": "2025-05-01"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageSpaces": "1"
+"GarageYN": true
+"HighSchool": "Contact Agent"
+"HighSchoolDistrict": "Valley Stream - 30"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "carolyn.campbell@elliman.com"
+"ListAgentKey": "326121370"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110753"
+"ListOfficePhone": "516-921-2262"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2024-12-10"
+"LotFeatures": array:2 [ …2]
+"LotSizeAcres": 0.1988
+"LotSizeDimensions": "60x114"
+"LotSizeSquareFeet": 8625
+"MajorChangeTimestamp": "2025-05-01T04:13:30Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Contact Agent"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-05-01"
+"OnMarketDate": "2024-12-16"
+"OriginalEntryTimestamp": "2024-12-16T15:13:44Z"
+"OriginalListPrice": 685000
+"OriginatingSystemModificationTimestamp": "2025-05-01T04:13:30Z"
+"OwnerName": "Cunningham"
+"PatioAndPorchFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2024-12-16T15:15:37Z"
+"PhotosCount": 24
+"PostalCity": "Valley Stream"
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-921-2262"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-05-01T04:13:30Z"
+"StreetName": "Ella"
+"StreetNumber": "45"
+"StreetNumberNumeric": "45"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "12702"
+"TaxBlock": "300"
+"TaxLot": "103"
+"TaxYear": "2025"
+"Utilities": array:1 [ …1]
+"VirtualTourURLUnbranded": "https://tour.vht.com/434433659/idx"
+"WaterSource": array:1 [ …1]
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "1100.00"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "0"
+"KEY_CurrentPrice": "685000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "622.72727"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_MlsDistrictCode": "30"
+"KEY_Attic": "Finished,Full,Walkup"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3445674.0443"
+"KEY_ConcessionYN": "0"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_TaxSection": "37"
+"KEY_RATIO_ListPrice_By_LivingArea": "622.72727"
+"KEY_SourceSystemModificationTimestamp": "2024-12-10T15:33:55.063"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418104826')"
+"provider_name": "One Key"
+"Media": array:24 [ …24]
+"ID": "24802"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4732
+post_id: "24650"
+post_author: 1
+"ListingKey": "KEY418097229"
+"ListingId": "804294"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-04-11T09:04:38Z"
+"RFModificationTimestamp": "2025-04-11T09:25:36Z"
+"ListPrice": 319000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 775.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11563"
+"UnparsedAddress": "60 Hempstead Avenue Unit 1k, Hempstead, New York 11563"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.70518855
+"Longitude": -73.640377479116
+"YearBuilt": 1960
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Robert J. Hendrick"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "169582"
+"ListOfficeMlsId": "DERE23"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Beautifully updated 1 bedroom, Junior 4 Co-op with private balcony in the heart of Lynbrook Village. Located on 2nd level/1st residential floor of Penbrook House. Corner unit with windows in each room. New kitchen with stainless steel appliances, quartz countertops, and tile floor. New bathroom with mosaic tile floor and subway wall tile. Heated, inground pool and large deck furnished with lounge chairs, tables, and umbrellas. A short walk to LIRR, downtown Lynbrook, stores, and shops. Heat, water, and 1 parking space in adjacent lot included."
+"Appliances": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-354-6500"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-728-1731"
+"BuyerAgentEmail": "jamie@dsregroup.com"
+"BuyerAgentFullName": "Jamie Deutsch"
+"BuyerAgentKey": "326231746"
+"BuyerAgentMlsId": "222863"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110973"
+"BuyerOfficeMlsId": "DSMN01"
+"BuyerOfficeName": "Desimone Real Estate"
+"BuyerOfficePhone": "516-534-2200"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2024-12-11T01:29:18.777672+00:00"
+"CrossStreet": "Peninsula"
+"CumulativeDaysOnMarket": 51
+"DaysOnMarket": 51
+"ElementarySchool": "West End School"
+"ExpirationDate": "2025-12-06"
+"Flooring": array:2 [ …2]
+"Heating": array:3 [ …3]
+"HighSchool": "Lynbrook Senior High School"
+"HighSchoolDistrict": "Lynbrook"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-298-8725"
+"ListAgentEmail": "Robert.Hendrick@elliman.com"
+"ListAgentKey": "326180864"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110763"
+"ListOfficePhone": "516-354-6500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2024-12-06"
+"LivingAreaSource": "Public Records"
+"MajorChangeTimestamp": "2025-02-12T15:55:29Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Lynbrook North Middle School"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2025-02-12"
+"OnMarketDate": "2024-12-23"
+"OriginalEntryTimestamp": "2024-12-11T01:23:50Z"
+"OriginalListPrice": 340000
+"OriginatingSystemModificationTimestamp": "2025-04-11T09:02:26Z"
+"OwnerName": "Salem"
+"ParkingTotal": "1"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2024-12-18T20:58:36Z"
+"PhotosCount": 23
+"PostalCity": "Lynbrook"
+"PreviousListPrice": 340000
+"PriceChangeTimestamp": "2025-01-20T16:43:45Z"
+"PropertyAttachedYN": true
+"PurchaseContractDate": "2025-02-12"
+"RoomsTotal": "4"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "(516) 298-8725"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-02-12T15:55:29Z"
+"StreetName": "Hempstead"
+"StreetNumber": "60"
+"StreetNumberNumeric": "60"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [ …1]
+"UnitNumber": "1K"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Village": "Lynbrook"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_AdditionalFeeFrequency": "Monthly"
+"KEY_EstimatedMaintenance": "1072"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.93824"
+"KEY_LivingAreaSearchSqFt": "775.00"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "1"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_CurrentPrice": "319000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "411.61290"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_RentingAllowedYN": "0"
+"KEY_EstimatedMMDeduction": "1"
+"KEY_AdditionalFeeDescription": "HOA"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ContractPrice": "300000.00"
+"KEY_RATIO_ListPrice_By_LivingArea": "411.61290"
+"KEY_SourceSystemModificationTimestamp": "2024-12-09T19:37:41.523"
+"KEY_AdditionalFeesAmount": "0.00"
+"KEY_ApprovalRequiredYN": "1"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418097229')"
+"provider_name": "One Key"
+"Media": array:23 [ …23]
+"ID": "24650"
}
]
+success: true
+page_size: 6
+page_count: 369
+count: 2209
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=1860&$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 {#5255
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5238
+post_id: "31416"
+post_author: 1
+"ListingKey": "KEY425101950"
+"ListingId": "1004534"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-06-16T07:14:38Z"
+"RFModificationTimestamp": "2026-06-16T07:16:43Z"
+"ListPrice": 860000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1700.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "49 Mc Cord Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6598118
+"Longitude": -73.556458
+"YearBuilt": 1925
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Andrea H. Greenberg"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "78562"
+"ListOfficeMlsId": "SPH09"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Beautiful, charming and truly one-of-a-kind! Prepare to be wowed by this stunning Colonial that checks every box. Featuring 3 spacious bedrooms, 2 bathrooms, living room, dining room and a large open kitchen. The den is a showstopper with cathedral ceiling, radiant heated floor and a gas fireplace. A separate large bonus room offers endless flexibility to suit your needs – perfect as a guest room, home office or playroom. A full basement provides even more possibilities. The backyard is spectacular!!! Located in the Lindenmere section of Merrick. This is the home you’ve been waiting for.!! Hurry…Generator, gas heating and cooking, pull down attic, sprinklers, fully fenced yard. Wood floors throughout."
+"Appliances": array:7 [ …7]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-546-6300"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-382-4690"
+"BuyerAgentEmail": "mtavernise@signaturepremier.com"
+"BuyerAgentFullName": "Michael V. Tavernise"
+"BuyerAgentKey": "326185281"
+"BuyerAgentMlsId": "174319"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115731"
+"BuyerOfficeMlsId": "SPH23"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "516-785-0100"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-546-6300"
+"CoListAgentEmail": "rlevine@signaturepremier.com"
+"CoListAgentFullName": "Rhonda Levine"
+"CoListAgentKey": "326144513"
+"CoListAgentMlsId": "130186"
+"CoListOfficeKey": "326115717"
+"CoListOfficeMlsId": "SPH09"
+"CoListOfficeName": "Signature Premier Properties"
+"CoListOfficePhone": "516-546-6300"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-27T17:13:02.545875+00:00"
+"CrossStreet": "Kirkwood Ave"
+"CumulativeDaysOnMarket": 16
+"DaysOnMarket": 16
+"ElementarySchool": "Birch School"
+"ElementarySchoolDistrict": "Merrick"
+"ExpirationDate": "2026-11-27"
+"ExteriorFeatures": array:1 [ …1]
+"Fencing": array:1 [ …1]
+"Flooring": array:2 [ …2]
+"Heating": array:2 [ …2]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "agreenberg@signaturepremier.com"
+"ListAgentKey": "326241335"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115717"
+"ListOfficePhone": "516-546-6300"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-27"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:7 [ …7]
+"LotSizeAcres": 0.1148
+"LotSizeDimensions": "75x100"
+"LotSizeSquareFeet": 7500
+"MajorChangeTimestamp": "2026-06-15T16:47:26Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-06-15"
+"OnMarketDate": "2026-05-27"
+"OriginalEntryTimestamp": "2026-05-27T17:07:58Z"
+"OriginalListPrice": 860000
+"OriginatingSystemModificationTimestamp": "2026-06-15T16:47:26Z"
+"OtherEquipment": array:1 [ …1]
+"OwnerName": "Sklover"
+"ParcelNumber": "2089-55-152-00-0387-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-05-27T17:09:37Z"
+"PhotosCount": 23
+"PostalCity": "Merrick"
+"PostalCodePlus4": "4227"
+"PurchaseContractDate": "2026-06-12"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-15T16:47:26Z"
+"StreetName": "Mc Cord"
+"StreetNumber": "49"
+"StreetNumberNumeric": "49"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "13842"
+"TaxAssessedValue": 458
+"TaxBlock": "152"
+"TaxLot": "387"
+"TaxYear": "2026"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"KEY_Attic": "Partially Finished,Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "860000.00"
+"KEY_ContractPrice": "935000.00"
+"KEY_OpenHouseCount": "3"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_BuyerRepresentation": "Buyer's Agent"
+"KEY_LivingAreaSearchSqFt": "1700.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "505.88235"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7491289.1986"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "505.88235"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T13:35:56.870"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425101950')"
+"provider_name": "One Key"
+"Media": array:23 [ …23]
+"ID": "31416"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4766
+post_id: "31419"
+post_author: 1
+"ListingKey": "KEY425101547"
+"ListingId": "1004520"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-30T19:10:38Z"
+"RFModificationTimestamp": "2026-05-30T19:12:37Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1602.0
+"BuildingAreaTotal": 1686.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "311 Locust Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6457832
+"Longitude": -73.5946852
+"YearBuilt": 1912
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jared M. Garcia"
+"ListOfficeName": "Weichert Realtors Performance"
+"ListAgentMlsId": "122014"
+"ListOfficeMlsId": "PRRC01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 311 Locust Ave — a beautifully maintained early 1900’s Colonial blending timeless character with thoughtful updates, all set on a meticulously manicured property in the heart of Freeport’s historic coastal community.\n
From the moment you arrive, the home’s 4 bedroom, 2 full bath has classic architecture, cedar shake exterior, mature landscaping, and inviting curb appeal immediately stand out. Inside, you’ll find oversized sun-filled rooms, beautiful original moldings, rich woodwork, handsome oak pocket doors, and the kind of warmth and craftsmanship rarely found today.\n
The spacious main level offers a welcoming layout perfect for both everyday living and entertaining, featuring a large formal living room, elegant dining area, oversized eat-in kitchen, and an enclosed back porch/sunroom that creates the perfect space to relax and enjoy views of the beautifully maintained yard.\n
The second floor offers 4 bedrooms , including two generously sized primary bedrooms along with two additional bedrooms. Updated split-system air conditioning provides modern comfort while the home continues to preserve its original charm and character throughout.\n
Outside, the property continues to impress with an expansive private backyard, detached garage, and incredible outdoor space ideal for entertaining, gardening, or simply enjoying peaceful coastal living. An unfinished basement provides additional storage and future potential.\n
Located in the vibrant Village of Freeport — known for its waterfront lifestyle, boating culture, restaurants, and rich history — this special home offers the perfect combination of classic charm, space, character, and pride of ownership. Taxes listed includes the village.
"""
+"Appliances": array:7 [ …7]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-845-4700"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-449-2028"
+"CoListAgentEmail": "jagarcia@weichertph.com"
+"CoListAgentFullName": "Joseph A. Garcia"
+"CoListAgentKey": "326137237"
+"CoListAgentMlsId": "122016"
+"CoListOfficeKey": "326114719"
+"CoListOfficeMlsId": "PRRC01"
+"CoListOfficeName": "Weichert Realtors Performance"
+"CoListOfficePhone": "516-845-4700"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-27T17:42:30.329300+00:00"
+"CrossStreet": "Southside Avenue"
+"CumulativeDaysOnMarket": 3
+"DaysOnMarket": 22
+"Directions": "West Merrick Rd to S. Bayview Avenue to Southside Avenue right, to Locust Avenue #311"
+"ElementarySchool": "Bayview Avenue School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2027-02-26"
+"GarageSpaces": "1.5"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-993-7041"
+"ListAgentEmail": "jmgarcia@weichertph.com"
+"ListAgentKey": "326137235"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114719"
+"ListOfficePhone": "516-845-4700"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-26"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1928
+"LotSizeSquareFeet": 8400
+"MajorChangeTimestamp": "2026-05-27T17:38:52Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-27"
+"OriginalEntryTimestamp": "2026-05-27T17:38:52Z"
+"OriginalListPrice": 719000
+"OriginatingSystemModificationTimestamp": "2026-05-30T19:08:30Z"
+"OwnerName": "Gambino Trust"
+"ParcelNumber": "2009-54-307-00-0036-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-05-27T17:40:36Z"
+"PhotosCount": 29
+"PostalCity": "Freeport"
+"PostalCodePlus4": "4833"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "800-746-9464"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-27T17:38:52Z"
+"StreetName": "Locust"
+"StreetNumber": "311"
+"StreetNumberNumeric": "311"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12620"
+"TaxAssessedValue": 400
+"TaxBlock": "307"
+"TaxLot": "36"
+"TaxYear": "2025"
+"Utilities": array:3 [ …3]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_Village": "Freeport"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "719000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1602.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "448.81398"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3729253.1120"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "448.81398"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T13:23:57.757"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "426.45314"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "426.45314"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425101547')"
+"provider_name": "One Key"
+"Media": array:29 [ …29]
+"ID": "31419"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#317
+post_id: "31392"
+post_author: 1
+"ListingKey": "KEY425098383"
+"ListingId": "1004436"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T18:09:48Z"
+"RFModificationTimestamp": "2026-06-14T18:13:33Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1298.0
+"BuildingAreaTotal": 1298.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "168 Hendrickson Avenue, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6754883
+"Longitude": -73.6993096
+"YearBuilt": 1941
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Dennis Arango"
+"ListOfficeName": "John Savoretti Realty"
+"ListAgentMlsId": "108161"
+"ListOfficeMlsId": "JOSV01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Updated Cape Close Distance To All, Featuring New Roof, Central Air, and Bathroom, Has An Updated Kitchen With Granite Counters, Inviting Living Room With Wood Burning Fireplace, Harwood Floors Freshly Done, Gas Heat, Full Finished Basement With OSE , This One Is Priced To Fly!"
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-459-3655"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-26T16:10:12.199751+00:00"
+"CumulativeDaysOnMarket": 48
+"DaysOnMarket": 23
+"ElementarySchool": "Wheeler Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-10-08"
+"Fencing": array:1 [ …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:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-459-3655"
+"ListAgentEmail": "dennis@dennisarango.com"
+"ListAgentKey": "326124339"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112691"
+"ListOfficePhone": "516-327-6400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-26"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:1 [ …1]
+"LotSizeAcres": 0.1056
+"LotSizeDimensions": "46x100"
+"LotSizeSquareFeet": 4600
+"MajorChangeTimestamp": "2026-05-26T16:04:26Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-26"
+"OriginalEntryTimestamp": "2026-05-26T16:04:26Z"
+"OriginalListPrice": 699000
+"OriginatingSystemModificationTimestamp": "2026-06-14T18:08:17Z"
+"OwnerName": "D & D Custom Homes Llc"
+"ParcelNumber": "2035-37-509-04-0154-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-05-26T16:05:36Z"
+"PhotosCount": 22
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "3315"
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-459-3655"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-26T16:04:26Z"
+"StreetName": "Hendrickson"
+"StreetNumber": "168"
+"StreetNumberNumeric": "168"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12398"
+"TaxAssessedValue": 462
+"TaxYear": "2024"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Crawl"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "699000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_AdditionalRooms": "Dining Area"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_AdditionalFeesYN": "0"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1298.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "538.52080"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6619318.1818"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "538.52080"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T12:00:08.890"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "538.52080"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "538.52080"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425098383')"
+"provider_name": "One Key"
+"Media": array:22 [ …22]
+"ID": "31392"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5272
+post_id: "31415"
+post_author: 1
+"ListingKey": "KEY425098206"
+"ListingId": "1004430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T07:46:36Z"
+"RFModificationTimestamp": "2026-06-13T08:02:41Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1854.0
+"BuildingAreaTotal": 1854.0
+"City": "Hempstead"
+"PostalCode": "11565"
+"UnparsedAddress": "19 Saint Thomas Place, Hempstead, New York 11565"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6758508
+"Longitude": -73.6699
+"YearBuilt": 1937
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jonathan P. Sanchez"
+"ListOfficeName": "Newman Realty Inc"
+"ListAgentMlsId": "164824"
+"ListOfficeMlsId": "NWMN01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Charming and spacious 3-bedroom, 1.5-bath Colonial set on an oversized property! This inviting home features a living room with a cozy fireplace, formal dining room perfect for entertaining, and a comfortable family room for everyday living. Beautiful hardwood floors flow throughout, adding warmth and character to the home. Step outside to a stunning Trex deck overlooking the expansive backyard — ideal for outdoor gatherings, relaxing, or enjoying summer nights. A wonderful blend of classic charm and modern comfort with plenty of indoor and outdoor space to enjoy!"
+"Appliances": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-599-2800"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-599-2800"
+"CoListAgentEmail": "leonsanchez_jr@yahoo.com"
+"CoListAgentFullName": "Leon J. Sanchez"
+"CoListAgentKey": "326179578"
+"CoListAgentMlsId": "168171"
+"CoListOfficeKey": "326114200"
+"CoListOfficeMlsId": "NWMN01"
+"CoListOfficeName": "Newman Realty Inc"
+"CoListOfficePhone": "516-599-2800"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-27T17:07:58.101373+00:00"
+"CumulativeDaysOnMarket": 17
+"DaysOnMarket": 22
+"Directions": "Hempstead Ave to Saint Thomas Place"
+"ElementarySchool": "Maurice W Downing Primary School"
+"ElementarySchoolDistrict": "Malverne"
+"ExpirationDate": "2026-09-12"
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Malverne Senior High School"
+"HighSchoolDistrict": "Malverne"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-406-4046"
+"ListAgentEmail": "jonsanchez367@yahoo.com"
+"ListAgentKey": "326176499"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114200"
+"ListOfficePhone": "516-599-2800"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-13"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1601
+"LotSizeDimensions": "45x156"
+"LotSizeSquareFeet": 6975
+"MajorChangeTimestamp": "2026-05-27T17:01:10Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Howard T Herber Middle School"
+"MiddleOrJuniorSchoolDistrict": "Malverne"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-27"
+"OriginalEntryTimestamp": "2026-05-27T17:01:10Z"
+"OriginalListPrice": 899000
+"OriginatingSystemModificationTimestamp": "2026-06-12T21:30:22Z"
+"OwnerName": "James & Jacqueline Casey"
+"ParcelNumber": "2027-37-345-00-0219-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-06-13T07:46:36Z"
+"PhotosCount": 21
+"PostalCity": "Malverne"
+"PostalCodePlus4": "1437"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-599-2800"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-27T17:01:10Z"
+"StreetName": "Saint Thomas"
+"StreetNumber": "19"
+"StreetNumberNumeric": "19"
+"StreetSuffix": "Place"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "18066"
+"TaxAssessedValue": 579
+"TaxYear": "2026"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Pull Stairs"
+"KEY_Village": "Malverne"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "899000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1854.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "484.89752"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5615240.4747"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "484.89752"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T11:56:50.143"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "484.89752"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "484.89752"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425098206')"
+"provider_name": "One Key"
+"Media": array:21 [ …21]
+"ID": "31415"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4624
+post_id: "31618"
+post_author: 1
+"ListingKey": "KEY425097792"
+"ListingId": "1004422"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T17:39:41Z"
+"RFModificationTimestamp": "2026-06-13T17:42:16Z"
+"ListPrice": 849000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1490.0
+"BuildingAreaTotal": 1490.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "56 Columbine Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.692295533414
+"Longitude": -73.560000763378
+"YearBuilt": 1948
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Kristin Scanlon"
+"ListOfficeName": "Keller Williams Rty Gold Coast"
+"ListAgentMlsId": "187596"
+"ListOfficeMlsId": "NYGC01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to this beautifully maintained 3-bedroom, 2-bath Expanded Cape situated on a desirable corner lot in the heart of Merrick. Rich in timeless charm and custom craftsmanship, this exceptional home features elegant wainscoting, detailed millwork, and a thoughtfully designed floor plan.\n
\n
The main level offers a spacious living room, formal dining room, eat-in kitchen, inviting den with a gas fireplace and surround sound, a bedroom, and a full bath. Upstairs, you’ll find two additional bedrooms and a beautifully updated bathroom featuring a luxurious steam shower.\n
\n
The finished basement provides additional living and entertaining space, while the private backyard is designed for year-round enjoyment with a built-in BBQ, pizza oven, jacuzzi, and detached one-car garage.\n
\n
Combining comfort, character, and impressive indoor and outdoor living spaces, this is a rare opportunity to own a truly special home in Merrick.
"""
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-482-0200"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-06-09T12:48:31.688813+00:00"
+"CrossStreet": "Little Whaleneck Road"
+"CumulativeDaysOnMarket": 4
+"DaysOnMarket": 9
+"ElementarySchool": "Harold D Fayette School"
+"ElementarySchoolDistrict": "North Merrick"
+"ExpirationDate": "2026-12-31"
+"ExteriorFeatures": array:1 [ …1]
+"Fencing": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "646-599-5649"
+"ListAgentEmail": "kristinscanlon@kw.com"
+"ListAgentKey": "326197671"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114235"
+"ListOfficePhone": "516-482-0200"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-06-09"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1814
+"LotSizeSquareFeet": 7900
+"MajorChangeTimestamp": "2026-06-09T12:42:05Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-06-09"
+"OriginalEntryTimestamp": "2026-06-09T12:42:05Z"
+"OriginalListPrice": 849000
+"OriginatingSystemModificationTimestamp": "2026-06-13T17:38:18Z"
+"OwnerName": "Gajda"
+"ParcelNumber": "2089-50-378-00-0009-0"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1"
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-06-09T12:43:36Z"
+"PhotosCount": 27
+"PostalCity": "Merrick"
+"PostalCodePlus4": "1133"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "646-599-5649"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-09T12:42:05Z"
+"StreetName": "Columbine"
+"StreetNumber": "56"
+"StreetNumberNumeric": "56"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "15175"
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "849000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1490.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "569.79866"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "4680264.6086"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "569.79866"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T11:45:35.457"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "569.79866"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "569.79866"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425097792')"
+"provider_name": "One Key"
+"Media": array:27 [ …27]
+"ID": "31618"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4733
+post_id: "31390"
+post_author: 1
+"ListingKey": "KEY425094855"
+"ListingId": "1004339"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:12:36Z"
+"RFModificationTimestamp": "2026-06-17T13:15:26Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2610.0
+"BuildingAreaTotal": 2610.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "357 Wynsum Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6556777
+"Longitude": -73.5413631
+"YearBuilt": 1928
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Tammy Gatto"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "195256"
+"ListOfficeMlsId": "SPH04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to this beautifully updated Colonial located in the highly sought-after Historic Gables section of Merrick. Blending timeless charm with extensive modern upgrades, this meticulously maintained home offers exceptional craftsmanship, style, and comfort throughout. From the moment you arrive, you’ll appreciate the stunning curb appeal featuring all new front stucco, fresh exterior paint, a beautiful bluestone front entry and walkway, and professionally designed landscaping. The private backyard is perfect for entertaining with pet turf and updated outdoor space designed for low-maintenance enjoyment. Inside, this move-in ready home showcases updated flooring in both upstairs bedrooms and formal dining room, all new high hats, and beautifully updated bathrooms. The elegant formal dining room is highlighted by a fireplace and new sliding doors installed approximately two years ago, creating the perfect setting for gatherings and entertaining. The fully renovated kitchen was thoughtfully redesigned and completed alongside the updated first-floor bathroom, including a reconfigured layout for improved flow and functionality. Kitchen appliances were all replaced within the last six months. Additional custom touches include a stunning Turkish custom tile bathroom upstairs and a custom California Closets installation on the first floor. Major updates throughout the home include roof, front windows, additional windows replaced within the last two years, master bathroom renovation, basement bathroom renovation, upgraded stairs (6 years), new air conditioning system, generator, upgraded electric, and replaced sump pumps within the last three years — providing true peace of mind for years to come. A rare opportunity to own a beautifully updated Colonial in one of Merrick’s most desirable and historic neighborhoods close to parks, shopping, dining, and transportation. Truly a must-see!"
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "631-673-3900"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-26T15:21:00.792573+00:00"
+"CrossStreet": "Elliot St"
+"CumulativeDaysOnMarket": 22
+"DaysOnMarket": 23
+"ElementarySchool": "Norman J Levy Lakeside School"
+"ElementarySchoolDistrict": "Merrick"
+"ExpirationDate": "2026-10-26"
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Merrick"
+"InteriorFeatures": array:8 [ …8]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-300-5633"
+"ListAgentEmail": "tgatto@signaturepremier.com"
+"ListAgentKey": "326204974"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115712"
+"ListOfficePhone": "631-673-3900"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-26"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1377
+"LotSizeSquareFeet": 6000
+"MajorChangeTimestamp": "2026-06-17T13:11:27Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-26"
+"OriginalEntryTimestamp": "2026-05-26T15:15:03Z"
+"OriginalListPrice": 1175000
+"OriginatingSystemModificationTimestamp": "2026-06-17T13:11:27Z"
+"OwnerName": "Delprete Vincent Living Trust"
+"ParcelNumber": "2089-63-126-00-0029-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-05-26T15:16:37Z"
+"PhotosCount": 40
+"PostalCity": "Merrick"
+"PostalCodePlus4": "4727"
+"PreviousListPrice": 1100000
+"PriceChangeTimestamp": "2026-06-17T13:11:27Z"
+"RoomsTotal": "12"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "631-300-5633"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-26T15:15:03Z"
+"StreetName": "Wynsum"
+"StreetNumber": "357"
+"StreetNumberNumeric": "357"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "16573.95"
+"TaxAssessedValue": 546
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"VirtualTourURLUnbranded": "https://show.tours/v/TdQxRdQ"
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Full,Unfinished"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "999999.00"
+"KEY_OpenHouseCount": "1"
+"KEY_OpenHouseUpcoming": "Public: Sat Jun 20, 12:30PM-3:00PM"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "2610.00"
+"KEY_OpenHousePublicCount": "1"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_OpenHousePublicUpcoming": "Public: Sat Jun 20, 12:30PM-3:00PM"
+"KEY_RATIO_ListPrice_By_LivingArea": "383.14138"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7262156.8627"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "383.14138"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T10:28:50.930"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "383.14138"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.85106"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "383.14138"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425094855')"
+"provider_name": "One Key"
+"Media": array:40 [ …40]
+"ID": "31390"
}
]
+success: true
+page_size: 6
+page_count: 322
+count: 1931
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Cache Key: ef261b6438b60fdea76f2992fc7aa8668a8319dedec4e39084d4cdd3ae96e3d9" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6025
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5983
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY425101950"
+"ListingId": "1004534"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-06-16T07:14:38Z"
+"RFModificationTimestamp": "2026-06-16T07:16:43Z"
+"ListPrice": 860000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1700.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "49 Mc Cord Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6598118
+"Longitude": -73.556458
+"YearBuilt": 1925
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Andrea H. Greenberg"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "78562"
+"ListOfficeMlsId": "SPH09"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Beautiful, charming and truly one-of-a-kind! Prepare to be wowed by this stunning Colonial that checks every box. Featuring 3 spacious bedrooms, 2 bathrooms, living room, dining room and a large open kitchen. The den is a showstopper with cathedral ceiling, radiant heated floor and a gas fireplace. A separate large bonus room offers endless flexibility to suit your needs – perfect as a guest room, home office or playroom. A full basement provides even more possibilities. The backyard is spectacular!!! Located in the Lindenmere section of Merrick. This is the home you’ve been waiting for.!! Hurry…Generator, gas heating and cooking, pull down attic, sprinklers, fully fenced yard. Wood floors throughout."
+"Appliances": array:7 [ …7]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-546-6300"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-382-4690"
+"BuyerAgentEmail": "mtavernise@signaturepremier.com"
+"BuyerAgentFullName": "Michael V. Tavernise"
+"BuyerAgentKey": "326185281"
+"BuyerAgentMlsId": "174319"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115731"
+"BuyerOfficeMlsId": "SPH23"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "516-785-0100"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-546-6300"
+"CoListAgentEmail": "rlevine@signaturepremier.com"
+"CoListAgentFullName": "Rhonda Levine"
+"CoListAgentKey": "326144513"
+"CoListAgentMlsId": "130186"
+"CoListOfficeKey": "326115717"
+"CoListOfficeMlsId": "SPH09"
+"CoListOfficeName": "Signature Premier Properties"
+"CoListOfficePhone": "516-546-6300"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-27T17:13:02.545875+00:00"
+"CrossStreet": "Kirkwood Ave"
+"CumulativeDaysOnMarket": 16
+"DaysOnMarket": 16
+"ElementarySchool": "Birch School"
+"ElementarySchoolDistrict": "Merrick"
+"ExpirationDate": "2026-11-27"
+"ExteriorFeatures": array:1 [ …1]
+"Fencing": array:1 [ …1]
+"Flooring": array:2 [ …2]
+"Heating": array:2 [ …2]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "agreenberg@signaturepremier.com"
+"ListAgentKey": "326241335"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115717"
+"ListOfficePhone": "516-546-6300"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-27"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:7 [ …7]
+"LotSizeAcres": 0.1148
+"LotSizeDimensions": "75x100"
+"LotSizeSquareFeet": 7500
+"MajorChangeTimestamp": "2026-06-15T16:47:26Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-06-15"
+"OnMarketDate": "2026-05-27"
+"OriginalEntryTimestamp": "2026-05-27T17:07:58Z"
+"OriginalListPrice": 860000
+"OriginatingSystemModificationTimestamp": "2026-06-15T16:47:26Z"
+"OtherEquipment": array:1 [ …1]
+"OwnerName": "Sklover"
+"ParcelNumber": "2089-55-152-00-0387-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-05-27T17:09:37Z"
+"PhotosCount": 23
+"PostalCity": "Merrick"
+"PostalCodePlus4": "4227"
+"PurchaseContractDate": "2026-06-12"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-15T16:47:26Z"
+"StreetName": "Mc Cord"
+"StreetNumber": "49"
+"StreetNumberNumeric": "49"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "13842"
+"TaxAssessedValue": 458
+"TaxBlock": "152"
+"TaxLot": "387"
+"TaxYear": "2026"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"KEY_Attic": "Partially Finished,Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "860000.00"
+"KEY_ContractPrice": "935000.00"
+"KEY_OpenHouseCount": "3"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_BuyerRepresentation": "Buyer's Agent"
+"KEY_LivingAreaSearchSqFt": "1700.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "505.88235"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7491289.1986"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "505.88235"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T13:35:56.870"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425101950')"
+"provider_name": "One Key"
+"Media": array:23 [ …23]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5969
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY425101547"
+"ListingId": "1004520"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-30T19:10:38Z"
+"RFModificationTimestamp": "2026-05-30T19:12:37Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1602.0
+"BuildingAreaTotal": 1686.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "311 Locust Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6457832
+"Longitude": -73.5946852
+"YearBuilt": 1912
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jared M. Garcia"
+"ListOfficeName": "Weichert Realtors Performance"
+"ListAgentMlsId": "122014"
+"ListOfficeMlsId": "PRRC01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 311 Locust Ave — a beautifully maintained early 1900’s Colonial blending timeless character with thoughtful updates, all set on a meticulously manicured property in the heart of Freeport’s historic coastal community.\n
From the moment you arrive, the home’s 4 bedroom, 2 full bath has classic architecture, cedar shake exterior, mature landscaping, and inviting curb appeal immediately stand out. Inside, you’ll find oversized sun-filled rooms, beautiful original moldings, rich woodwork, handsome oak pocket doors, and the kind of warmth and craftsmanship rarely found today.\n
The spacious main level offers a welcoming layout perfect for both everyday living and entertaining, featuring a large formal living room, elegant dining area, oversized eat-in kitchen, and an enclosed back porch/sunroom that creates the perfect space to relax and enjoy views of the beautifully maintained yard.\n
The second floor offers 4 bedrooms , including two generously sized primary bedrooms along with two additional bedrooms. Updated split-system air conditioning provides modern comfort while the home continues to preserve its original charm and character throughout.\n
Outside, the property continues to impress with an expansive private backyard, detached garage, and incredible outdoor space ideal for entertaining, gardening, or simply enjoying peaceful coastal living. An unfinished basement provides additional storage and future potential.\n
Located in the vibrant Village of Freeport — known for its waterfront lifestyle, boating culture, restaurants, and rich history — this special home offers the perfect combination of classic charm, space, character, and pride of ownership. Taxes listed includes the village.
"""
+"Appliances": array:7 [ …7]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-845-4700"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-449-2028"
+"CoListAgentEmail": "jagarcia@weichertph.com"
+"CoListAgentFullName": "Joseph A. Garcia"
+"CoListAgentKey": "326137237"
+"CoListAgentMlsId": "122016"
+"CoListOfficeKey": "326114719"
+"CoListOfficeMlsId": "PRRC01"
+"CoListOfficeName": "Weichert Realtors Performance"
+"CoListOfficePhone": "516-845-4700"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-27T17:42:30.329300+00:00"
+"CrossStreet": "Southside Avenue"
+"CumulativeDaysOnMarket": 3
+"DaysOnMarket": 22
+"Directions": "West Merrick Rd to S. Bayview Avenue to Southside Avenue right, to Locust Avenue #311"
+"ElementarySchool": "Bayview Avenue School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2027-02-26"
+"GarageSpaces": "1.5"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-993-7041"
+"ListAgentEmail": "jmgarcia@weichertph.com"
+"ListAgentKey": "326137235"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114719"
+"ListOfficePhone": "516-845-4700"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-26"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1928
+"LotSizeSquareFeet": 8400
+"MajorChangeTimestamp": "2026-05-27T17:38:52Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-27"
+"OriginalEntryTimestamp": "2026-05-27T17:38:52Z"
+"OriginalListPrice": 719000
+"OriginatingSystemModificationTimestamp": "2026-05-30T19:08:30Z"
+"OwnerName": "Gambino Trust"
+"ParcelNumber": "2009-54-307-00-0036-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-05-27T17:40:36Z"
+"PhotosCount": 29
+"PostalCity": "Freeport"
+"PostalCodePlus4": "4833"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "800-746-9464"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-27T17:38:52Z"
+"StreetName": "Locust"
+"StreetNumber": "311"
+"StreetNumberNumeric": "311"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12620"
+"TaxAssessedValue": 400
+"TaxBlock": "307"
+"TaxLot": "36"
+"TaxYear": "2025"
+"Utilities": array:3 [ …3]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_Village": "Freeport"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "719000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1602.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "448.81398"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3729253.1120"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "448.81398"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T13:23:57.757"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "426.45314"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "426.45314"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425101547')"
+"provider_name": "One Key"
+"Media": array:29 [ …29]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5543
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY425098383"
+"ListingId": "1004436"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T18:09:48Z"
+"RFModificationTimestamp": "2026-06-14T18:13:33Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1298.0
+"BuildingAreaTotal": 1298.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "168 Hendrickson Avenue, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6754883
+"Longitude": -73.6993096
+"YearBuilt": 1941
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Dennis Arango"
+"ListOfficeName": "John Savoretti Realty"
+"ListAgentMlsId": "108161"
+"ListOfficeMlsId": "JOSV01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Updated Cape Close Distance To All, Featuring New Roof, Central Air, and Bathroom, Has An Updated Kitchen With Granite Counters, Inviting Living Room With Wood Burning Fireplace, Harwood Floors Freshly Done, Gas Heat, Full Finished Basement With OSE , This One Is Priced To Fly!"
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-459-3655"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-26T16:10:12.199751+00:00"
+"CumulativeDaysOnMarket": 48
+"DaysOnMarket": 23
+"ElementarySchool": "Wheeler Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-10-08"
+"Fencing": array:1 [ …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:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-459-3655"
+"ListAgentEmail": "dennis@dennisarango.com"
+"ListAgentKey": "326124339"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112691"
+"ListOfficePhone": "516-327-6400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-26"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:1 [ …1]
+"LotSizeAcres": 0.1056
+"LotSizeDimensions": "46x100"
+"LotSizeSquareFeet": 4600
+"MajorChangeTimestamp": "2026-05-26T16:04:26Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-26"
+"OriginalEntryTimestamp": "2026-05-26T16:04:26Z"
+"OriginalListPrice": 699000
+"OriginatingSystemModificationTimestamp": "2026-06-14T18:08:17Z"
+"OwnerName": "D & D Custom Homes Llc"
+"ParcelNumber": "2035-37-509-04-0154-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-05-26T16:05:36Z"
+"PhotosCount": 22
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "3315"
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-459-3655"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-26T16:04:26Z"
+"StreetName": "Hendrickson"
+"StreetNumber": "168"
+"StreetNumberNumeric": "168"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12398"
+"TaxAssessedValue": 462
+"TaxYear": "2024"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Crawl"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "699000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_AdditionalRooms": "Dining Area"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_AdditionalFeesYN": "0"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1298.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "538.52080"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6619318.1818"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "538.52080"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T12:00:08.890"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "538.52080"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "538.52080"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425098383')"
+"provider_name": "One Key"
+"Media": array:22 [ …22]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5999
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY425098206"
+"ListingId": "1004430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T07:46:36Z"
+"RFModificationTimestamp": "2026-06-13T08:02:41Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1854.0
+"BuildingAreaTotal": 1854.0
+"City": "Hempstead"
+"PostalCode": "11565"
+"UnparsedAddress": "19 Saint Thomas Place, Hempstead, New York 11565"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6758508
+"Longitude": -73.6699
+"YearBuilt": 1937
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jonathan P. Sanchez"
+"ListOfficeName": "Newman Realty Inc"
+"ListAgentMlsId": "164824"
+"ListOfficeMlsId": "NWMN01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Charming and spacious 3-bedroom, 1.5-bath Colonial set on an oversized property! This inviting home features a living room with a cozy fireplace, formal dining room perfect for entertaining, and a comfortable family room for everyday living. Beautiful hardwood floors flow throughout, adding warmth and character to the home. Step outside to a stunning Trex deck overlooking the expansive backyard — ideal for outdoor gatherings, relaxing, or enjoying summer nights. A wonderful blend of classic charm and modern comfort with plenty of indoor and outdoor space to enjoy!"
+"Appliances": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-599-2800"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-599-2800"
+"CoListAgentEmail": "leonsanchez_jr@yahoo.com"
+"CoListAgentFullName": "Leon J. Sanchez"
+"CoListAgentKey": "326179578"
+"CoListAgentMlsId": "168171"
+"CoListOfficeKey": "326114200"
+"CoListOfficeMlsId": "NWMN01"
+"CoListOfficeName": "Newman Realty Inc"
+"CoListOfficePhone": "516-599-2800"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-27T17:07:58.101373+00:00"
+"CumulativeDaysOnMarket": 17
+"DaysOnMarket": 22
+"Directions": "Hempstead Ave to Saint Thomas Place"
+"ElementarySchool": "Maurice W Downing Primary School"
+"ElementarySchoolDistrict": "Malverne"
+"ExpirationDate": "2026-09-12"
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Malverne Senior High School"
+"HighSchoolDistrict": "Malverne"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-406-4046"
+"ListAgentEmail": "jonsanchez367@yahoo.com"
+"ListAgentKey": "326176499"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114200"
+"ListOfficePhone": "516-599-2800"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-13"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1601
+"LotSizeDimensions": "45x156"
+"LotSizeSquareFeet": 6975
+"MajorChangeTimestamp": "2026-05-27T17:01:10Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Howard T Herber Middle School"
+"MiddleOrJuniorSchoolDistrict": "Malverne"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-27"
+"OriginalEntryTimestamp": "2026-05-27T17:01:10Z"
+"OriginalListPrice": 899000
+"OriginatingSystemModificationTimestamp": "2026-06-12T21:30:22Z"
+"OwnerName": "James & Jacqueline Casey"
+"ParcelNumber": "2027-37-345-00-0219-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-06-13T07:46:36Z"
+"PhotosCount": 21
+"PostalCity": "Malverne"
+"PostalCodePlus4": "1437"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-599-2800"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-27T17:01:10Z"
+"StreetName": "Saint Thomas"
+"StreetNumber": "19"
+"StreetNumberNumeric": "19"
+"StreetSuffix": "Place"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "18066"
+"TaxAssessedValue": 579
+"TaxYear": "2026"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Pull Stairs"
+"KEY_Village": "Malverne"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "899000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1854.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "484.89752"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5615240.4747"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "484.89752"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T11:56:50.143"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "484.89752"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "484.89752"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425098206')"
+"provider_name": "One Key"
+"Media": array:21 [ …21]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6001
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY425097792"
+"ListingId": "1004422"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T17:39:41Z"
+"RFModificationTimestamp": "2026-06-13T17:42:16Z"
+"ListPrice": 849000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1490.0
+"BuildingAreaTotal": 1490.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "56 Columbine Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.692295533414
+"Longitude": -73.560000763378
+"YearBuilt": 1948
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Kristin Scanlon"
+"ListOfficeName": "Keller Williams Rty Gold Coast"
+"ListAgentMlsId": "187596"
+"ListOfficeMlsId": "NYGC01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to this beautifully maintained 3-bedroom, 2-bath Expanded Cape situated on a desirable corner lot in the heart of Merrick. Rich in timeless charm and custom craftsmanship, this exceptional home features elegant wainscoting, detailed millwork, and a thoughtfully designed floor plan.\n
\n
The main level offers a spacious living room, formal dining room, eat-in kitchen, inviting den with a gas fireplace and surround sound, a bedroom, and a full bath. Upstairs, you’ll find two additional bedrooms and a beautifully updated bathroom featuring a luxurious steam shower.\n
\n
The finished basement provides additional living and entertaining space, while the private backyard is designed for year-round enjoyment with a built-in BBQ, pizza oven, jacuzzi, and detached one-car garage.\n
\n
Combining comfort, character, and impressive indoor and outdoor living spaces, this is a rare opportunity to own a truly special home in Merrick.
"""
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-482-0200"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-06-09T12:48:31.688813+00:00"
+"CrossStreet": "Little Whaleneck Road"
+"CumulativeDaysOnMarket": 4
+"DaysOnMarket": 9
+"ElementarySchool": "Harold D Fayette School"
+"ElementarySchoolDistrict": "North Merrick"
+"ExpirationDate": "2026-12-31"
+"ExteriorFeatures": array:1 [ …1]
+"Fencing": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "646-599-5649"
+"ListAgentEmail": "kristinscanlon@kw.com"
+"ListAgentKey": "326197671"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114235"
+"ListOfficePhone": "516-482-0200"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-06-09"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1814
+"LotSizeSquareFeet": 7900
+"MajorChangeTimestamp": "2026-06-09T12:42:05Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-06-09"
+"OriginalEntryTimestamp": "2026-06-09T12:42:05Z"
+"OriginalListPrice": 849000
+"OriginatingSystemModificationTimestamp": "2026-06-13T17:38:18Z"
+"OwnerName": "Gajda"
+"ParcelNumber": "2089-50-378-00-0009-0"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1"
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-06-09T12:43:36Z"
+"PhotosCount": 27
+"PostalCity": "Merrick"
+"PostalCodePlus4": "1133"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "646-599-5649"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-09T12:42:05Z"
+"StreetName": "Columbine"
+"StreetNumber": "56"
+"StreetNumberNumeric": "56"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "15175"
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "849000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1490.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "569.79866"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "4680264.6086"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "569.79866"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T11:45:35.457"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "569.79866"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "569.79866"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425097792')"
+"provider_name": "One Key"
+"Media": array:27 [ …27]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6003
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY425094855"
+"ListingId": "1004339"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:12:36Z"
+"RFModificationTimestamp": "2026-06-17T13:15:26Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2610.0
+"BuildingAreaTotal": 2610.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "357 Wynsum Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6556777
+"Longitude": -73.5413631
+"YearBuilt": 1928
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Tammy Gatto"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "195256"
+"ListOfficeMlsId": "SPH04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to this beautifully updated Colonial located in the highly sought-after Historic Gables section of Merrick. Blending timeless charm with extensive modern upgrades, this meticulously maintained home offers exceptional craftsmanship, style, and comfort throughout. From the moment you arrive, you’ll appreciate the stunning curb appeal featuring all new front stucco, fresh exterior paint, a beautiful bluestone front entry and walkway, and professionally designed landscaping. The private backyard is perfect for entertaining with pet turf and updated outdoor space designed for low-maintenance enjoyment. Inside, this move-in ready home showcases updated flooring in both upstairs bedrooms and formal dining room, all new high hats, and beautifully updated bathrooms. The elegant formal dining room is highlighted by a fireplace and new sliding doors installed approximately two years ago, creating the perfect setting for gatherings and entertaining. The fully renovated kitchen was thoughtfully redesigned and completed alongside the updated first-floor bathroom, including a reconfigured layout for improved flow and functionality. Kitchen appliances were all replaced within the last six months. Additional custom touches include a stunning Turkish custom tile bathroom upstairs and a custom California Closets installation on the first floor. Major updates throughout the home include roof, front windows, additional windows replaced within the last two years, master bathroom renovation, basement bathroom renovation, upgraded stairs (6 years), new air conditioning system, generator, upgraded electric, and replaced sump pumps within the last three years — providing true peace of mind for years to come. A rare opportunity to own a beautifully updated Colonial in one of Merrick’s most desirable and historic neighborhoods close to parks, shopping, dining, and transportation. Truly a must-see!"
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "631-673-3900"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-26T15:21:00.792573+00:00"
+"CrossStreet": "Elliot St"
+"CumulativeDaysOnMarket": 22
+"DaysOnMarket": 23
+"ElementarySchool": "Norman J Levy Lakeside School"
+"ElementarySchoolDistrict": "Merrick"
+"ExpirationDate": "2026-10-26"
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Merrick"
+"InteriorFeatures": array:8 [ …8]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-300-5633"
+"ListAgentEmail": "tgatto@signaturepremier.com"
+"ListAgentKey": "326204974"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115712"
+"ListOfficePhone": "631-673-3900"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-26"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1377
+"LotSizeSquareFeet": 6000
+"MajorChangeTimestamp": "2026-06-17T13:11:27Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-26"
+"OriginalEntryTimestamp": "2026-05-26T15:15:03Z"
+"OriginalListPrice": 1175000
+"OriginatingSystemModificationTimestamp": "2026-06-17T13:11:27Z"
+"OwnerName": "Delprete Vincent Living Trust"
+"ParcelNumber": "2089-63-126-00-0029-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-05-26T15:16:37Z"
+"PhotosCount": 40
+"PostalCity": "Merrick"
+"PostalCodePlus4": "4727"
+"PreviousListPrice": 1100000
+"PriceChangeTimestamp": "2026-06-17T13:11:27Z"
+"RoomsTotal": "12"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "631-300-5633"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-26T15:15:03Z"
+"StreetName": "Wynsum"
+"StreetNumber": "357"
+"StreetNumberNumeric": "357"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "16573.95"
+"TaxAssessedValue": 546
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"VirtualTourURLUnbranded": "https://show.tours/v/TdQxRdQ"
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Full,Unfinished"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "999999.00"
…18
}
]
+success: true
+page_size: 6
+page_count: 322
+count: 1931
+after_key: ""
}
]
]