array:1 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=2724&$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)&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5287
+items: array:12 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5278
+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 [
0 => -73.556458
1 => 40.6598118
]
+"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 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Gas Range"
3 => "Microwave"
4 => "Refrigerator"
5 => "Washer"
6 => "Gas Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-546-6300"
+"Basement": array:1 [
0 => "Finished"
]
+"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 [
0 => "Clapboard"
]
+"Cooling": array:1 [
0 => "Ductless"
]
+"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 [
0 => "Gas Grill"
]
+"Fencing": array:1 [
0 => "Back Yard"
]
+"Flooring": array:2 [
0 => "Carpet"
1 => "Wood"
]
+"Heating": array:2 [
0 => "Baseboard"
1 => "Natural Gas"
]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [
0 => "Eat-in Kitchen"
1 => "Formal Dining"
2 => "Natural Woodwork"
]
+"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 [
0 => "Back Yard"
1 => "Front Yard"
2 => "Landscaped"
3 => "Near Public Transit"
4 => "Near Shops"
5 => "Sprinklers In Front"
6 => "Sprinklers In Rear"
]
+"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 [
0 => "IDX"
]
+"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 [
0 => "Generator"
]
+"OwnerName": "Sklover"
+"ParcelNumber": "2089-55-152-00-0387-0"
+"ParkingFeatures": array:2 [
0 => "Driveway"
1 => "On Street"
]
+"PhotosChangeTimestamp": "2026-05-27T17:09:37Z"
+"PhotosCount": 23
+"PostalCity": "Merrick"
+"PostalCodePlus4": "4227"
+"PurchaseContractDate": "2026-06-12"
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:2 [
0 => "Appointment Only"
1 => "Call Listing Office"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-15T16:47:26Z"
+"StreetName": "Mc Cord"
+"StreetNumber": "49"
+"StreetNumberNumeric": "49"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "13842"
+"TaxAssessedValue": 458
+"TaxBlock": "152"
+"TaxLot": "387"
+"TaxYear": "2026"
+"Utilities": array:1 [
0 => "Electricity Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WindowFeatures": array:1 [
0 => "Skylight(s)"
]
+"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 [
0 => array:12 [
"Order" => 0
"MediaKey" => "6a172534ee899e991f836947"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY425101950/e41c6b860687b57c122ea9317a071997.webp"
"MediaSize" => 852282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY425101950/thumbnail-e41c6b860687b57c122ea9317a071997.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"ResourceRecordKey" => "425101950"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2026-05-27T17:09:08.008Z"
]
1 => array:12 [
"Order" => 1
"MediaKey" => "6a172534ee899e991f836948"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY425101950/a0cc8f6ed58013641aa725d241a48f72.webp"
"MediaSize" => 772081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY425101950/thumbnail-a0cc8f6ed58013641aa725d241a48f72.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"ResourceRecordKey" => "425101950"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2026-05-27T17:09:08.025Z"
]
2 => array:12 [
"Order" => 2
"MediaKey" => "6a172534ee899e991f836949"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY425101950/9fb916b968f08a4ae275e608952d0a27.webp"
"MediaSize" => 311221
…8
]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
]
+"ID": "31416"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5280
+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 [
0 => -73.5946852
1 => 40.6457832
]
+"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 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Electric Cooktop"
3 => "Electric Oven"
4 => "Refrigerator"
5 => "Washer"
6 => "Oil Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-845-4700"
+"Basement": array:1 [
0 => "Full"
]
+"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 [
0 => "Cedar"
]
+"Cooling": array:1 [
0 => "Ductless"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-27T17:42:30.329300+00:00"
+"CrossStreet": "Southside Avenue"
+"CumulativeDaysOnMarket": 3
+"DaysOnMarket": 21
+"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 [
0 => "Oil"
]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:7 [
0 => "Ceiling Fan(s)"
1 => "Crown Molding"
2 => "Eat-in Kitchen"
3 => "Entrance Foyer"
4 => "Formal Dining"
5 => "High Ceilings"
6 => "Washer/Dryer Hookup"
]
+"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 [
0 => "IDX"
]
+"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 [
0 => "Driveway"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-27T17:40:36Z"
+"PhotosCount": 29
+"PostalCity": "Freeport"
+"PostalCodePlus4": "4833"
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "800-746-9464"
+"ShowingRequirements": array:2 [
0 => "24 Hour Notice"
1 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-27T17:38:52Z"
+"StreetName": "Locust"
+"StreetNumber": "311"
+"StreetNumberNumeric": "311"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "12620"
+"TaxAssessedValue": 400
+"TaxBlock": "307"
+"TaxLot": "36"
+"TaxYear": "2025"
+"Utilities": array:3 [
0 => "Cable Connected"
1 => "Electricity Connected"
2 => "Sewer Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"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 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
]
+"ID": "31419"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5277
+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 [
0 => -73.6993096
1 => 40.6754883
]
+"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 [
0 => "Dishwasher"
1 => "Gas Range"
2 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Cape Cod"
]
+"AttributionContact": "516-459-3655"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-26T16:10:12.199751+00:00"
+"CumulativeDaysOnMarket": 48
+"DaysOnMarket": 22
+"ElementarySchool": "Wheeler Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-10-08"
+"Fencing": array:1 [
0 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:3 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Granite Counters"
]
+"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 [
0 => "Back Yard"
]
+"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 [
0 => "IDX"
]
+"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 [
0 => "Driveway"
]
+"PhotosChangeTimestamp": "2026-05-26T16:05:36Z"
+"PhotosCount": 22
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "3315"
+"PropertyCondition": array:1 [
0 => "Updated/Remodeled"
]
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-459-3655"
+"ShowingRequirements": array:1 [
0 => "Showing Service"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-26T16:04:26Z"
+"StreetName": "Hendrickson"
+"StreetNumber": "168"
+"StreetNumberNumeric": "168"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "12398"
+"TaxAssessedValue": 462
+"TaxYear": "2024"
+"Utilities": array:4 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Sewer Connected"
3 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"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 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
]
+"ID": "31392"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5281
+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 [
0 => -73.6699
1 => 40.6758508
]
+"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 [
0 => "Dishwasher"
1 => "Gas Range"
2 => "Microwave"
3 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-599-2800"
+"Basement": array:1 [
0 => "Full"
]
+"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 [
0 => "Frame"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-27T17:07:58.101373+00:00"
+"CumulativeDaysOnMarket": 17
+"DaysOnMarket": 21
+"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 [
0 => "Hardwood"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Oil"
]
+"HighSchool": "Malverne Senior High School"
+"HighSchoolDistrict": "Malverne"
+"InteriorFeatures": array:3 [
0 => "Breakfast Bar"
1 => "Eat-in Kitchen"
2 => "Formal Dining"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In Basement"
]
+"Levels": array:1 [
0 => "Two"
]
+"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 [
0 => "IDX"
]
+"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 [
0 => "Driveway"
]
+"PhotosChangeTimestamp": "2026-06-13T07:46:36Z"
+"PhotosCount": 21
+"PostalCity": "Malverne"
+"PostalCodePlus4": "1437"
+"RoomsTotal": "7"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-599-2800"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-27T17:01:10Z"
+"StreetName": "Saint Thomas"
+"StreetNumber": "19"
+"StreetNumberNumeric": "19"
+"StreetSuffix": "Place"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "18066"
+"TaxAssessedValue": 579
+"TaxYear": "2026"
+"Utilities": array:4 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Sewer Connected"
3 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"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 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
]
+"ID": "31415"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5279
+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 [
0 => -73.560000763378
1 => 40.692295533414
]
+"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 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Gas Oven"
3 => "Microwave"
4 => "Refrigerator"
5 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Exp Cape"
]
+"AttributionContact": "516-482-0200"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Frame"
]
+"Cooling": array:1 [
0 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-06-09T12:48:31.688813+00:00"
+"CrossStreet": "Little Whaleneck Road"
+"CumulativeDaysOnMarket": 4
+"DaysOnMarket": 8
+"ElementarySchool": "Harold D Fayette School"
+"ElementarySchoolDistrict": "North Merrick"
+"ExpirationDate": "2026-12-31"
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Fencing": array:1 [
0 => "Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Gas"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [
0 => "Forced Air"
1 => "Oil"
]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [
0 => "First Floor Bedroom"
1 => "Eat-in Kitchen"
2 => "Granite Counters"
]
+"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 [
0 => "IDX"
]
+"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 [
0 => "Detached"
]
+"ParkingTotal": "1"
+"PatioAndPorchFeatures": array:1 [
0 => "Patio"
]
+"PhotosChangeTimestamp": "2026-06-09T12:43:36Z"
+"PhotosCount": 27
+"PostalCity": "Merrick"
+"PostalCodePlus4": "1133"
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Other"
]
+"ShowingContactPhone": "646-599-5649"
+"ShowingRequirements": array:2 [
0 => "Call Listing Agent"
1 => "See Remarks"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-09T12:42:05Z"
+"StreetName": "Columbine"
+"StreetNumber": "56"
+"StreetNumberNumeric": "56"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "15175"
+"TaxYear": "2024"
+"Utilities": array:1 [
0 => "See Remarks"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"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 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
]
+"ID": "31618"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5276
+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 [
0 => -73.5413631
1 => 40.6556777
]
+"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 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Gas Range"
3 => "Microwave"
4 => "Refrigerator"
5 => "Stainless Steel Appliance(s)"
6 => "Washer"
7 => "Gas Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "631-673-3900"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [
0 => "Frame"
1 => "Stucco"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-26T15:21:00.792573+00:00"
+"CrossStreet": "Elliot St"
+"CumulativeDaysOnMarket": 22
+"DaysOnMarket": 22
+"ElementarySchool": "Norman J Levy Lakeside School"
+"ElementarySchoolDistrict": "Merrick"
+"ExpirationDate": "2026-10-26"
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Wood"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Merrick"
+"InteriorFeatures": array:8 [
0 => "Crown Molding"
1 => "Eat-in Kitchen"
2 => "Entrance Foyer"
3 => "Formal Dining"
4 => "Granite Counters"
5 => "High Ceilings"
6 => "Kitchen Island"
7 => "Open Floorplan"
]
+"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 [
0 => "IDX"
]
+"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 [
0 => "Driveway"
]
+"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 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "631-300-5633"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-26T15:15:03Z"
+"StreetName": "Wynsum"
+"StreetNumber": "357"
+"StreetNumberNumeric": "357"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "16573.95"
+"TaxAssessedValue": 546
+"TaxYear": "2024"
+"Utilities": array:1 [
0 => "Natural Gas Connected"
]
+"VirtualTourURLUnbranded": "https://show.tours/v/TdQxRdQ"
+"WaterSource": array:1 [
0 => "Public"
]
+"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 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
29 => array:12 [ …12]
30 => array:12 [ …12]
31 => array:12 [ …12]
32 => array:12 [ …12]
33 => array:12 [ …12]
34 => array:12 [ …12]
35 => array:12 [ …12]
36 => array:12 [ …12]
37 => array:12 [ …12]
38 => array:12 [ …12]
39 => array:12 [ …12]
]
+"ID": "31390"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5275
+post_id: "31528"
+post_author: 1
+"ListingKey": "KEY425092002"
+"ListingId": "1004263"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-06-17T07:11:41Z"
+"RFModificationTimestamp": "2026-06-17T07:17:06Z"
+"ListPrice": 1088000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2139.0
+"BuildingAreaTotal": 2139.0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "2499 Haff Avenue, Hempstead, New York 11710"
+"Coordinates": array:2 [
0 => -73.5384989
1 => 40.6874487
]
+"Latitude": 40.6874487
+"Longitude": -73.5384989
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Michelle S. Cervoni CBR"
+"ListOfficeName": "Stephen Joseph Properties"
+"ListAgentMlsId": "201936"
+"ListOfficeMlsId": "SJP02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to 2499 Haff Avenue!! This meticulously maintained home situated on over 8,400 sq. ft. of professionally landscaped property is located in the sought-after town of Bellmore (Bellmore/Merrick SD). This elegant, timeless in-line hi-ranch provides over 2,100 sq. ft. of living space and is 5 feet longer than the traditional in-line hi-ranch architectural styled home. The upper level features a formal living rm with electric fireplace, formal dining rm, updated thoughtfully-designed EIK with granite counter tops, full bath, primary bedrm plus 2 additional bedrms. The lower level offers a cozy den with sliders leading out to the patio, bedrm, full bath, seating area, laundry & one-car garage. The private, spacious, resort-style backyard boasts a custom, heated built-in, salt-water pool, covered patio & bar gazebo (7 stools included!!) providing the perfect setting for entertaining or just relaxing on a sunny day! Additional amenities include: CAC, IGS, landscape lighting, fenced in yard, shed for additional storage, attic with pull-down stairs, security system, "Diamond Plated" custom garage cabinetry, 200 amp, plus so much more!! Custom Weber gas BBQ grill gifted to Buyer!! Pool heater: 2 years old. Filter: 4 years old. Ideally located near restaurants, shopping, highways, schools, 2 miles to LIRR. Possible mother/daughter with proper permits. Seller is the original owner. Sold as-is."
+"Appliances": array:5 [
0 => "Dishwasher"
1 => "Electric Range"
2 => "Refrigerator"
3 => "Stainless Steel Appliance(s)"
4 => "Wine Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Hi Ranch"
]
+"AttributionContact": "516-809-9288"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "347-663-0199"
+"BuyerAgentEmail": "tarek.agag@compass.com"
+"BuyerAgentFullName": "Tarek Agag SFR"
+"BuyerAgentKey": "326232359"
+"BuyerAgentMlsId": "223497"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110407"
+"BuyerOfficeMlsId": "CMPA10"
+"BuyerOfficeName": "Compass Greater NY LLC"
+"BuyerOfficePhone": "516-517-4866"
+"CoBuyerAgentAOR": "LIBOR"
+"CoBuyerAgentDirectPhone": "646-331-2592"
+"CoBuyerAgentEmail": "dina.mohamed@compass.com"
+"CoBuyerAgentFullName": "Dina N. Mohamed"
+"CoBuyerAgentKey": "326222757"
+"CoBuyerAgentMlsId": "213588"
+"CoBuyerOfficeKey": "326110407"
+"CoBuyerOfficeMlsId": "CMPA10"
+"CoBuyerOfficeName": "Compass Greater NY LLC"
+"CoBuyerOfficePhone": "516-517-4866"
+"ConstructionMaterials": array:1 [
0 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-06-02T23:25:15.356301+00:00"
+"CumulativeDaysOnMarket": 14
+"DaysOnMarket": 14
+"Directions": "Waze or GPS"
+"ElementarySchool": "Newbridge Road School"
+"ElementarySchoolDistrict": "North Bellmore"
+"ExpirationDate": "2027-03-01"
+"FireplaceFeatures": array:1 [
0 => "Electric"
]
+"FireplaceYN": true
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Wellington C Mepham High Sch"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:4 [
0 => "Eat-in Kitchen"
1 => "Formal Dining"
2 => "Granite Counters"
3 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-528-2630"
+"ListAgentEmail": "michcerv@aol.com"
+"ListAgentKey": "326211419"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115604"
+"ListOfficePhone": "516-809-9288"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-06-01"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1931
+"LotSizeSquareFeet": 8412
+"MajorChangeTimestamp": "2026-06-16T20:38:21Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Grand Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-06-16"
+"OnMarketDate": "2026-06-02"
+"OriginalEntryTimestamp": "2026-06-02T23:19:42Z"
+"OriginalListPrice": 1088000
+"OriginatingSystemModificationTimestamp": "2026-06-16T20:38:21Z"
+"OwnerName": "Withheld"
+"ParcelNumber": "2089-56-C-00-0109-0"
+"ParkingFeatures": array:2 [
0 => "Driveway"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T23:21:36Z"
+"PhotosCount": 34
+"PoolFeatures": array:4 [
0 => "In Ground"
1 => "Pool Cover"
2 => "Salt Water"
3 => "Vinyl"
]
+"PoolPrivateYN": true
+"PostalCity": "Bellmore"
+"PostalCodePlus4": "2735"
+"PurchaseContractDate": "2026-06-16"
+"RoomsTotal": "9"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-528-2630"
+"ShowingRequirements": array:4 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
3 => "No Lockbox"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-16T20:38:21Z"
+"StreetName": "Haff"
+"StreetNumber": "2499"
+"StreetNumberNumeric": "2499"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "15234"
+"TaxAssessedValue": 523
+"TaxBlock": "C"
+"TaxLot": "109"
+"TaxYear": "2026"
+"Utilities": array:5 [
0 => "Cable Connected"
1 => "Electricity Connected"
2 => "Natural Gas Connected"
3 => "Sewer Connected"
4 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "Pull Stairs,Storage"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "56"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1088000.00"
+"KEY_ContractPrice": "1120000.00"
+"KEY_OpenHouseCount": "4"
+"KEY_PreviousStatus": "Active"
+"KEY_DistanceToTrain": "2.00"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_BuyerRepresentation": "Buyer's Agent"
+"KEY_LivingAreaSearchSqFt": "2139.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "508.64890"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5634386.3283"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "508.64890"
+"KEY_SourceSystemModificationTimestamp": "2026-05-26T07:26:36.617"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "508.64890"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "508.64890"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425092002')"
+"provider_name": "One Key"
+"Media": array:34 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:13 [ …13]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
29 => array:12 [ …12]
30 => array:13 [ …13]
31 => array:12 [ …12]
32 => array:12 [ …12]
33 => array:12 [ …12]
]
+"ID": "31528"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5282
+post_id: "31395"
+post_author: 1
+"ListingKey": "KEY425090629"
+"ListingId": "1004235"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-06-05T07:18:39Z"
+"RFModificationTimestamp": "2026-06-05T07:21:37Z"
+"ListPrice": 985000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2672.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "3452 Turf Road, Hempstead, New York 11572"
+"Coordinates": array:2 [
0 => -73.6276365
1 => 40.6277237
]
+"Latitude": 40.6277237
+"Longitude": -73.6276365
+"YearBuilt": 1957
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jason W. Krawitz"
+"ListOfficeName": "Jason W Krawitz"
+"ListAgentMlsId": "218480"
+"ListOfficeMlsId": "KRWZ01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 3452 Turf Road, a beautifully maintained and spacious 5-level split located in the desirable Wedgewood section of Oceanside. Offering 5 bedrooms and 3.5 bathrooms, this expansive home provides the perfect blend of comfort, functionality, and flexible living space.\n
\n
The main level features a bright and inviting living room, formal dining room, and a spacious eat-in kitchen complete with a gas stovetop, double oven, two sinks, and two dishwashers. Sliding glass doors lead directly to a large deck that is perfect for outdoor dining and entertaining.\n
\n
Just above the main level are three generously sized bedrooms, including a primary suite with its own private bath and a full hallway bath. The top level features two additional bedrooms and another full bath, perfect for guests, extended family, or home office space.\n
\n
The lower level boasts a spacious and comfortable den with a half bath and sliding glass doors to the backyard patio. A large finished basement with a separate laundry room adds even more versatility, ideal for a playroom, gym, media room, or other flexible uses.\n
\n
Additional highlights include central air conditioning, gas heating and cooking, a two-car garage, excellent storage and closet space, and in-ground sprinklers.\n
\n
A rare opportunity to own a spacious and versatile home in one of Oceanside’s most sought-after areas — don’t miss it!
"""
+"Appliances": array:9 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Freezer"
3 => "Gas Range"
4 => "Microwave"
5 => "Oven"
6 => "Refrigerator"
7 => "Stainless Steel Appliance(s)"
8 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Split Level"
]
+"AttributionContact": "516-318-5576"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-688-3593"
+"BuyerAgentEmail": "maria4home@aol.com"
+"BuyerAgentFullName": "Maria Lindh"
+"BuyerAgentKey": "326127512"
+"BuyerAgentMlsId": "111539"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326113859"
+"BuyerOfficeMlsId": "MRLI01"
+"BuyerOfficeName": "Next Level Real Estate NY"
+"BuyerOfficePhone": "516-688-3593"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-318-5576"
+"CoListAgentEmail": "jenniferlsturm@gmail.com"
+"CoListAgentFullName": "Jennifer Krawitz"
+"CoListAgentKey": "326228812"
+"CoListAgentMlsId": "219829"
+"CoListOfficeKey": "326112980"
+"CoListOfficeMlsId": "KRWZ01"
+"CoListOfficeName": "Jason W Krawitz"
+"CoListOfficePhone": "516-318-5576"
+"ConstructionMaterials": array:1 [
0 => "Frame"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-26T18:07:08.323882+00:00"
+"CumulativeDaysOnMarket": 9
+"DaysOnMarket": 9
+"ElementarySchool": "School 9E-Boardman Elem School"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-11-26"
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:8 [
0 => "Chefs Kitchen"
1 => "Eat-in Kitchen"
2 => "Entrance Foyer"
3 => "Formal Dining"
4 => "Granite Counters"
5 => "Primary Bathroom"
6 => "Storage"
7 => "Walk-In Closet(s)"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-318-5576"
+"ListAgentEmail": "jkrawitz21@gmail.com"
+"ListAgentKey": "326227503"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112980"
+"ListOfficePhone": "516-318-5576"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-26"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1607
+"LotSizeSquareFeet": 7000
+"MajorChangeTimestamp": "2026-06-04T21:31:59Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-06-04"
+"OnMarketDate": "2026-05-26"
+"OriginalEntryTimestamp": "2026-05-26T18:01:10Z"
+"OriginalListPrice": 985000
+"OriginatingSystemModificationTimestamp": "2026-06-04T21:31:59Z"
+"OwnerName": "Spund"
+"ParcelNumber": "2089-54-539-00-0016-0"
+"ParkingFeatures": array:3 [
0 => "Driveway"
1 => "Garage"
2 => "On Street"
]
+"PhotosChangeTimestamp": "2026-05-26T18:02:36Z"
+"PhotosCount": 46
+"PostalCity": "Oceanside"
+"PurchaseContractDate": "2026-06-04"
+"RoomsTotal": "14"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-318-5576"
+"ShowingRequirements": array:2 [
0 => "No Lockbox"
1 => "See Remarks"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-04T21:31:59Z"
+"StreetName": "Turf"
+"StreetNumber": "3452"
+"StreetNumberNumeric": "3452"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "16850"
+"TaxYear": "2026"
+"Utilities": array:5 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Sewer Connected"
3 => "Trash Collection Public"
4 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "See Remarks"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "985000.00"
+"KEY_ContractPrice": "990000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2672.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "368.63772"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6129433.7274"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "368.63772"
+"KEY_SourceSystemModificationTimestamp": "2026-05-25T22:14:37.067"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425090629')"
+"provider_name": "One Key"
+"Media": array:46 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
29 => array:12 [ …12]
30 => array:12 [ …12]
31 => array:12 [ …12]
32 => array:12 [ …12]
33 => array:12 [ …12]
34 => array:12 [ …12]
35 => array:12 [ …12]
36 => array:12 [ …12]
37 => array:12 [ …12]
38 => array:12 [ …12]
39 => array:12 [ …12]
40 => array:12 [ …12]
41 => array:12 [ …12]
42 => array:12 [ …12]
43 => array:12 [ …12]
44 => array:12 [ …12]
45 => array:12 [ …12]
]
+"ID": "31395"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5283
+post_id: "31437"
+post_author: 1
+"ListingKey": "KEY425087805"
+"ListingId": "1004140"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-06-03T07:15:40Z"
+"RFModificationTimestamp": "2026-06-03T07:17:28Z"
+"ListPrice": 1088800.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 3192.0
+"BuildingAreaTotal": 3192.0
+"City": "Hempstead"
+"PostalCode": "11581"
+"UnparsedAddress": "736 Bunker Road, Hempstead, New York 11581"
+"Coordinates": array:2 [
0 => -73.7257127
1 => 40.6432276
]
+"Latitude": 40.6432276
+"Longitude": -73.7257127
+"YearBuilt": 1962
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Janice Chavkin"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "184431"
+"ListOfficeMlsId": "SPH04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Spacious Tropicana - 6-bedroom, 3 full bath home offering incredible potential and endless possibilities. Featuring a flexible layout with a lower level ideal for extended family or guest space, this home is perfect for buyers looking to customize and create their dream home. The kitchen has already been beautifully redone, providing a modern and updated centerpiece to the home. Generous room sizes throughout, great bones, and a backyard with an in-ground pool. This is a fantastic opportunity for renovators, investors, or end users with vision. Conveniently located near parks, shopping, schools, and transportation. Home is being sold as-is."
+"Appliances": array:1 [
0 => "Dishwasher"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised Ranch"
]
+"AttributionContact": "631-673-3900"
+"Basement": array:3 [
0 => "Finished"
1 => "Storage Space"
2 => "Walk-Out Access"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-28T12:35:10.006288+00:00"
+"CumulativeDaysOnMarket": 5
+"DaysOnMarket": 5
+"ElementarySchool": "Lawrence Early Childhood-#4 School"
+"ElementarySchoolDistrict": "Lawrence"
+"ExpirationDate": "2026-11-25"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [
0 => "Hot Water"
]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:8 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Eat-in Kitchen"
3 => "Entrance Foyer"
4 => "Formal Dining"
5 => "Original Details"
6 => "Primary Bathroom"
7 => "Quartz/Quartzite Counters"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-568-4428"
+"ListAgentEmail": "jchavkin@signaturepremier.com"
+"ListAgentKey": "326194656"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115712"
+"ListOfficePhone": "631-673-3900"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-28"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1592
+"LotSizeSquareFeet": 6936
+"MajorChangeTimestamp": "2026-06-02T14:09:30Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlgCanUse": array:3 [
0 => "BO"
1 => "PT"
2 => "VOW"
]
+"MlsStatus": "Hold"
+"OffMarketDate": "2026-06-02"
+"OnMarketDate": "2026-05-28"
+"OriginalEntryTimestamp": "2026-05-28T12:31:53Z"
+"OriginalListPrice": 1088800
+"OriginatingSystemModificationTimestamp": "2026-06-02T14:09:30Z"
+"OwnerName": "Alec Diamond & Janna Palmquist"
+"ParcelNumber": "2089-39-617-00-0016-0"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T12:33:36Z"
+"PhotosCount": 33
+"PoolPrivateYN": true
+"PostalCity": "North Woodmere"
+"PostalCodePlus4": "3536"
+"RoomsTotal": "9"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "9175684428"
+"ShowingRequirements": array:4 [
0 => "Call Listing Agent"
1 => "No Sign"
2 => "Occupied"
3 => "See Remarks"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-02T14:09:30Z"
+"StreetName": "Bunker"
+"StreetNumber": "736"
+"StreetNumberNumeric": "736"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "12853"
+"TaxAssessedValue": 935
+"TaxYear": "2024"
+"Utilities": array:6 [
0 => "Cable Connected"
1 => "Electricity Connected"
2 => "Phone Connected"
3 => "Sewer Connected"
4 => "Trash Collection Public"
5 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Private"
]
+"KEY_Attic": "None"
+"KEY_HoldDate": "2026-06-02"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1088800.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "3192.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "341.10276"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6839195.9799"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "341.10276"
+"KEY_SourceSystemModificationTimestamp": "2026-05-25T15:02:50.800"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "341.10276"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "341.10276"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425087805')"
+"provider_name": "One Key"
+"Media": array:33 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
29 => array:12 [ …12]
30 => array:12 [ …12]
31 => array:12 [ …12]
32 => array:12 [ …12]
]
+"ID": "31437"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5284
+post_id: "31424"
+post_author: 1
+"ListingKey": "KEY425086579"
+"ListingId": "1004107"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-28T09:03:42Z"
+"RFModificationTimestamp": "2026-05-28T09:04:55Z"
+"ListPrice": 4245000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 1
+"BedroomsTotal": 8.0
+"LotSizeArea": 0
+"LivingArea": 4784.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11559"
+"UnparsedAddress": "8 Sealy Drive, Hempstead, New York 11559"
+"Coordinates": array:2 [
0 => -73.7218732
1 => 40.6153714
]
+"Latitude": 40.6153714
+"Longitude": -73.7218732
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Sarah Isaacs"
+"ListOfficeName": "Realty Connect USA LLC"
+"ListAgentMlsId": "220776"
+"ListOfficeMlsId": "RLLE02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to luxury living in this stunning custom-built 2024 gut-renovated residence tucked away on a private street, offering the ultimate privacy and exclusivity. This exceptional home features 8 spacious bedrooms and 6.5 beautifully designed bathrooms, including a first-floor bedroom with a full bath, ideal for guests.\n
\n
Designed with impeccable attention to detail, the home boasts soaring ceilings, radiant heated floors, exquisite hardwood flooring throughout, and elegant herringbone accents. The grand staircase creates a dramatic first impression, while the expansive formal dining room features a built-in washing station and additional refrigerator, perfect for effortless entertaining.\n
\n
The gourmet eat-in kitchen is both functional and sophisticated, complemented by abundant cabinetry and premium finishes. Three of the second-floor bedrooms are en suite, while the luxurious primary suite features an impressive oversized closet and spa-like bathroom. The home also offers exceptional closet space and generously sized rooms throughout.\n
\n
Additional highlights include an attached garage, side entrance mudroom, full attic with potential to easily expand additional living space, and a finished basement with two legal bedrooms and a full bathroom. The private backyard provides a serene retreat, completing this extraordinary luxury offering.\n
\n
A rare opportunity to own a meticulously crafted home that seamlessly blends elegance, comfort, and modern living.
"""
+"Appliances": array:7 [
0 => "Cooktop"
1 => "Dishwasher"
2 => "Freezer"
3 => "Gas Cooktop"
4 => "Refrigerator"
5 => "Stainless Steel Appliance(s)"
6 => "Wine Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "sarahcisaacs@gmail.com"
+"Basement": array:1 [
0 => "Finished"
]
+"BasementYN": true
+"BathroomsFull": 6
+"BuildingAreaUnits": "Square Feet"
+"CarportSpaces": "2"
+"CarportYN": true
+"ConstructionMaterials": array:1 [
0 => "HardiPlank Type"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-27T20:25:45.836614+00:00"
+"CrossStreet": "Broadway and Barrett Rd"
+"CumulativeDaysOnMarket": 1
+"DaysOnMarket": 21
+"ElementarySchool": "Lawrence Early Childhood-#4 School"
+"ElementarySchoolDistrict": "Lawrence"
+"ExpirationDate": "2026-08-31"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:3 [
0 => "Forced Air"
1 => "Radiant"
2 => "Radiant Floor"
]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:13 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Built-in Features"
3 => "Double Vanity"
4 => "Eat-in Kitchen"
5 => "Entrance Foyer"
6 => "Formal Dining"
7 => "High Ceilings"
8 => "Kitchen Island"
9 => "Primary Bathroom"
10 => "Recessed Lighting"
11 => "Walk-In Closet(s)"
12 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [
0 => "In Basement"
1 => "Laundry Room"
2 => "Multiple Locations"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-587-5704"
+"ListAgentEmail": "sarahcisaacs@gmail.com"
+"ListAgentKey": "326229736"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115083"
+"ListOfficePhone": "516-714-3606"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-25"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1916
+"LotSizeSquareFeet": 8347
+"MajorChangeTimestamp": "2026-05-27T20:19:28Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-27"
+"OriginalEntryTimestamp": "2026-05-27T20:19:28Z"
+"OriginalListPrice": 4245000
+"OriginatingSystemModificationTimestamp": "2026-05-28T09:02:14Z"
+"OwnerName": "876 Woodmere Place Llc"
+"ParcelNumber": "2023-41-085-00-0439-0"
+"ParkingFeatures": array:1 [
0 => "Attached"
]
+"PhotosChangeTimestamp": "2026-05-27T20:20:36Z"
+"PhotosCount": 40
+"PostalCity": "Lawrence"
+"PostalCodePlus4": "2420"
+"PriceChangeTimestamp": "2026-05-27T20:19:28Z"
+"PropertyAttachedYN": true
+"RoomsTotal": "12"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "917-587-5704"
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-27T20:19:28Z"
+"StreetName": "Sealy"
+"StreetNumber": "8"
+"StreetNumberNumeric": "8"
+"StreetSuffix": "Drive"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "17210.85"
+"TaxAssessedValue": 602
+"TaxBlock": "85"
+"TaxLot": "439"
+"TaxYear": "2024"
+"Utilities": array:5 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Sewer Connected"
3 => "Trash Collection Public"
4 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "Full"
+"KEY_TaxSource": "Other"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "4245000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "4784.00"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "887.33278"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "22155532.3591"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "887.33278"
+"KEY_SourceSystemModificationTimestamp": "2026-05-25T13:00:31.920"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425086579')"
+"provider_name": "One Key"
+"Media": array:40 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
29 => array:12 [ …12]
30 => array:12 [ …12]
31 => array:12 [ …12]
32 => array:12 [ …12]
33 => array:12 [ …12]
34 => array:12 [ …12]
35 => array:12 [ …12]
36 => array:12 [ …12]
37 => array:12 [ …12]
38 => array:12 [ …12]
39 => array:12 [ …12]
]
+"ID": "31424"
}
10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5285
+post_id: "31387"
+post_author: 1
+"ListingKey": "KEY425085862"
+"ListingId": "1004080"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:33:36Z"
+"RFModificationTimestamp": "2026-06-17T18:35:47Z"
+"ListPrice": 1050000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2143.0
+"BuildingAreaTotal": 2143.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": null
+"Coordinates": array:2 [
0 => 0.0
1 => 0.0
]
+"Latitude": null
+"Longitude": null
+"YearBuilt": 1986
+"InternetAddressDisplayYN": false
+"FeedTypes": "IDX"
+"ListAgentFullName": "Khalid Mehmud"
+"ListOfficeName": "Voro LLC"
+"ListAgentMlsId": "127290"
+"ListOfficeMlsId": "VORO01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Up for slae is a rarely found three level High Ranch including basment in the desired east section of Valley Stream, in SD#13. “Stunning newly renovated 5-bedroom single-family home offering 2 full and 2 half baths, spacious living, dining, and family rooms, and versatile mother-daughter potential — perfect for comfortable family living, entertaining, or multi-generational use.” sold as is."
+"AdditionalParcelsYN": true
+"Appliances": array:3 [
0 => "Dishwasher"
1 => "Gas Range"
2 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Hi Ranch"
]
+"AttributionContact": "516-330-1911"
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Walk-Out Access"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CarportSpaces": "3"
+"CarportYN": true
+"ConstructionMaterials": array:1 [
0 => "Frame"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-25T15:48:10.355690+00:00"
+"CumulativeDaysOnMarket": 23
+"DaysOnMarket": 23
+"ElementarySchool": "Wheeler Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-12-31"
+"GarageSpaces": "1"
+"Heating": array:1 [
0 => "None"
]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:9 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Formal Dining"
3 => "In-Law Floorplan"
4 => "Kitchen Island"
5 => "Marble Counters"
6 => "Primary Bathroom"
7 => "Walk Through Kitchen"
8 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-330-1911"
+"ListAgentEmail": "ourdreamhouse@hotmail.com"
+"ListAgentKey": "326141944"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326116380"
+"ListOfficePhone": "877-943-8676"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-25"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.0918
+"LotSizeSquareFeet": 4000
+"MajorChangeTimestamp": "2026-05-25T15:44:36Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-25"
+"OriginalEntryTimestamp": "2026-05-25T15:44:36Z"
+"OriginalListPrice": 1050000
+"OriginatingSystemModificationTimestamp": "2026-06-17T18:32:20Z"
+"OwnerName": "209 Grove St Llc"
+"ParcelNumber": "2035-37-147-00-0028-0"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"ParkingTotal": "4"
+"PhotosChangeTimestamp": "2026-06-04T20:23:36Z"
+"PhotosCount": 29
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "4114"
+"PriceChangeTimestamp": "2026-05-25T15:44:36Z"
+"RoomsTotal": "4"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Combination Lock Box"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-25T15:44:36Z"
+"StreetDirPrefix": "N"
+"StreetName": "Grove"
+"StreetNumber": "209"
+"StreetNumberNumeric": "209"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "9603.23"
+"TaxAssessedValue": 578
+"TaxYear": "2024"
+"Utilities": array:3 [
0 => "Electricity Available"
1 => "Natural Gas Available"
2 => "Sewer Available"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "None"
+"KEY_Village": "Valley Stream"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1050000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_OpenHouseUpcoming": "Public: Sat Jun 20, 1:00PM-3:00PM"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "2143.00"
+"KEY_OpenHousePublicCount": "1"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_OpenHousePublicUpcoming": "Public: Sat Jun 20, 1:00PM-3:00PM"
+"KEY_RATIO_ListPrice_By_LivingArea": "489.96734"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "11437908.4967"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "489.96734"
+"KEY_SourceSystemModificationTimestamp": "2026-05-25T11:44:36.457"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "489.96734"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "489.96734"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425085862')"
+"provider_name": "One Key"
+"Media": array:29 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
]
+"ID": "31387"
}
11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5286
+post_id: "31385"
+post_author: 1
+"ListingKey": "KEY425085030"
+"ListingId": "1004050"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T10:47:36Z"
+"RFModificationTimestamp": "2026-06-04T10:52:21Z"
+"ListPrice": 779999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1944.0
+"BuildingAreaTotal": 1944.0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "36 2nd Avenue, Hempstead, New York 11518"
+"Coordinates": array:2 [
0 => -73.6636107
1 => 40.6373385
]
+"Latitude": 40.6373385
+"Longitude": -73.6636107
+"YearBuilt": 1968
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Matthew Hart"
+"ListOfficeName": "World Prop Intl Sea to Sky"
+"ListAgentMlsId": "112688"
+"ListOfficeMlsId": "WOPR01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "4 bedroom, 2 bath East Rockaway Recently Renovated High Ranch. Features an OPEN FLOOR PLAN. 2nd Floor: Living room w/bay window. Kitchen with cathedral ceiling, skylight, peninsula seats 5, SS appliances, dining room. 3 bedrooms, bathroom w/double vanity, hardwood floors. 1st Floor: Family Room, 1 bedroom, bathroom, storage room, flex room, laundry/utility room and garage. Yard w/Gas line BBQ, patio, shed, lawn. Driveway for 5 cars. Walk to Bay Park/Beach/Pool, LIRR, Schools/Shopping/Restaurants."
+"Appliances": array:5 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Range"
3 => "Refrigerator"
4 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Hi Ranch"
]
+"AttributionContact": "631-961-4626"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Frame"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-25T14:45:26.074038+00:00"
+"CumulativeDaysOnMarket": 10
+"DaysOnMarket": 23
+"ElementarySchool": "Contact Agent"
+"ElementarySchoolDistrict": "Contact Agent"
+"ExpirationDate": "2026-11-25"
+"Flooring": array:1 [
0 => "Wood"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:1 [
0 => "Formal Dining"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Inside"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-961-4626"
+"ListAgentEmail": "matthew@wpinewyork.com"
+"ListAgentKey": "326128575"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326116516"
+"ListOfficePhone": "631-961-4626"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2026-05-25"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.0918
+"LotSizeSquareFeet": 4000
+"MajorChangeTimestamp": "2026-05-25T14:38:44Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-25"
+"OriginalEntryTimestamp": "2026-05-25T14:38:44Z"
+"OriginalListPrice": 779999
+"OriginatingSystemModificationTimestamp": "2026-06-04T10:45:52Z"
+"OwnerName": "Christine Lorraine Trust"
+"ParcelNumber": "2005-42-073-00-0125-0"
+"ParkingFeatures": array:2 [
0 => "Driveway"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T02:07:36Z"
+"PhotosCount": 23
+"PostalCity": "East Rockaway"
+"PostalCodePlus4": "1912"
+"PriceChangeTimestamp": "2026-05-25T14:38:44Z"
+"RoomsTotal": "7"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "347-804-6386"
+"ShowingRequirements": array:2 [
0 => "Appointment Only"
1 => "Call Owner"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-25T14:38:44Z"
+"StreetName": "2nd"
+"StreetNumber": "36"
+"StreetNumberNumeric": "36"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "13555"
+"TaxAssessedValue": 485
+"TaxYear": "2024"
+"Utilities": array:1 [
0 => "Electricity Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WaterfrontFeatures": array:1 [
0 => "Beach Access"
]
+"KEY_Attic": "Unfinished"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "779999.00"
+"KEY_OpenHouseCount": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1944.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "347-804-6386"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "401.23405"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8496721.1329"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "401.23405"
+"KEY_SourceSystemModificationTimestamp": "2026-05-25T10:24:14.793"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "401.23405"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "401.23405"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425085030')"
+"provider_name": "One Key"
+"Media": array:23 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
]
+"ID": "31385"
}
]
+success: true
+page_size: 12
+page_count: 235
+count: 2810
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]