array:1 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=2292&$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 {#5127
+items: array:12 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5118
+post_id: "25980"
+post_author: 1
+"ListingKey": "KEY420416885"
+"ListingId": "873445"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-23T17:18:36Z"
+"RFModificationTimestamp": "2026-04-23T17:24:26Z"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2471.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11581"
+"UnparsedAddress": "797 Caldwell Avenue, Hempstead, New York 11581"
+"Coordinates": array:2 [
0 => -73.724665
1 => 40.6463279
]
+"Latitude": 40.6463279
+"Longitude": -73.724665
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mark Lipner GRI"
+"ListOfficeName": "BERKSHIRE HATHAWAY"
+"ListAgentMlsId": "83128"
+"ListOfficeMlsId": "BHHS04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "New to the market! Welcome to a beautifully maintained 4-bedroom, 3-bathroom home on a spacious 74x100 lot, located on a serene tree-lined street in the highly desirable Hewlett-Woodmere School District. This charming home features a formal living room with vaulted ceilings, a separate dining room, and a large eat-in kitchen with granite countertops and abundant cabinet space. The primary bedroom boasts its own private en-suite bathroom for added comfort and privacy. The expansive lower level includes a generous den, wet bar, and convenient washer and dryer. A 2-car garage provides additional storage and parking. Throughout the home, you'll find gleaming hardwood floors, recessed lighting, and central air conditioning for year-round comfort. Step outside to enjoy the lush, fully fenced backyard – a perfect space for relaxation or entertaining. With its ideal location, ample living space, and modern amenities, this home is a must-see!"
+"Appliances": array:10 [
0 => "Convection Oven"
1 => "Cooktop"
2 => "Dishwasher"
3 => "Dryer"
4 => "Gas Cooktop"
5 => "Gas Oven"
6 => "Microwave"
7 => "Refrigerator"
8 => "Stainless Steel Appliance(s)"
9 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Split Ranch"
]
+"AttributionContact": "516-295-3000"
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [
0 => "Shingle Siding"
1 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-04T20:43:59.472510+00:00"
+"CrossStreet": "Park Ln"
+"CumulativeDaysOnMarket": 323
+"DaysOnMarket": 334
+"Directions": "Park Ln To Caldwell Ave."
+"Disclosures": array:2 [
0 => "Lead Paint"
1 => "Seller Property Disclosure"
]
+"ElementarySchool": "Ogden Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"Exclusions": "Dining Room Chandelier"
+"ExpirationDate": "2026-08-01"
+"ExteriorFeatures": array:1 [
0 => "Garden"
]
+"Fencing": array:1 [
0 => "Fenced"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:3 [
0 => "Baseboard"
1 => "Hot Water"
2 => "Natural Gas"
]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:11 [
0 => "Cathedral Ceiling(s)"
1 => "Ceiling Fan(s)"
2 => "Eat-in Kitchen"
3 => "Entrance Foyer"
4 => "Formal Dining"
5 => "Granite Counters"
6 => "Primary Bathroom"
7 => "Pantry"
8 => "Recessed Lighting"
9 => "Walk-In Closet(s)"
10 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Three Or More"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-298-8457"
+"ListAgentEmail": "mlipner@bhhslaffey.com"
+"ListAgentKey": "326244341"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109740"
+"ListOfficePhone": "516-295-3000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-04"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:8 [
0 => "Back Yard"
1 => "Landscaped"
2 => "Near Public Transit"
3 => "Near School"
4 => "Near Shops"
5 => "Paved"
6 => "Sprinklers In Front"
7 => "Sprinklers In Rear"
]
+"LotSizeAcres": 0.1607
+"LotSizeDimensions": "74x100"
+"LotSizeSquareFeet": 7400
+"MajorChangeTimestamp": "2026-03-30T19:09:05Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-06-04"
+"OriginalEntryTimestamp": "2025-06-04T20:36:10Z"
+"OriginalListPrice": 1350000
+"OriginatingSystemModificationTimestamp": "2026-04-23T17:17:13Z"
+"OtherEquipment": array:1 [
0 => "Compressor"
]
+"OwnerName": "Berkowitz"
+"ParcelNumber": "2089-39-567-00-0009-0"
+"ParkingFeatures": array:2 [
0 => "Driveway"
1 => "Garage"
]
+"PatioAndPorchFeatures": array:1 [
0 => "Patio"
]
+"PhotosChangeTimestamp": "2025-12-30T17:58:36Z"
+"PhotosCount": 45
+"PostalCity": "North Woodmere"
+"PostalCodePlus4": "3618"
+"PreviousListPrice": 1229000
+"PriceChangeTimestamp": "2026-03-30T19:09:05Z"
+"RoomsTotal": "8"
+"SecurityFeatures": array:1 [
0 => "Security System"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-298-8457"
+"ShowingRequirements": array:3 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-06-04T20:36:10Z"
+"StreetName": "Caldwell"
+"StreetNumber": "797"
+"StreetNumberNumeric": "797"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "20172.96"
+"TaxBlock": "567"
+"TaxLot": "9"
+"TaxYear": "2025"
+"Utilities": array:1 [
0 => "Cable Available"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "Partial"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "39"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1199000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "2471.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-295-3000"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "485.22865"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7461107.6540"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "485.22865"
+"KEY_SourceSystemModificationTimestamp": "2025-06-04T14:01:49.577"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.88815"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420416885')"
+"provider_name": "One Key"
+"Media": array:45 [
0 => array:14 [
"Order" => 0
"MediaKey" => "6954129c43ad045b81f91f94"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/038d78bbd11869d573663ce21ccf63df.webp"
"MediaSize" => 99202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-038d78bbd11869d573663ce21ccf63df.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Split level home featuring brick siding, a garage, a chimney, concrete driveway, and a front yard"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.129Z"
]
1 => array:14 [
"Order" => 1
"MediaKey" => "6954129c43ad045b81f91f95"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/d94260eee2a52f2bb14b117f30ffc54a.webp"
"MediaSize" => 128987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-d94260eee2a52f2bb14b117f30ffc54a.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Tri-level home featuring brick siding, a garage, concrete driveway, a chimney, and a front lawn"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.135Z"
]
2 => array:14 [
"Order" => 2
"MediaKey" => "6954129c43ad045b81f91f96"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/7775b339d8184542f2c51e5937d50b02.webp"
"MediaSize" => 133128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-7775b339d8184542f2c51e5937d50b02.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Split level home with brick siding, an attached garage, concrete driveway, and a front lawn"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.169Z"
]
3 => array:14 [
"Order" => 3
"MediaKey" => "6954129c43ad045b81f91f97"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/7e87c85de0daa3c5d47a320561a83405.webp"
"MediaSize" => 137230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-7e87c85de0daa3c5d47a320561a83405.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Split level home featuring brick siding, an attached garage, driveway, a front yard, and a chimney"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.134Z"
]
4 => array:14 [
"Order" => 4
"MediaKey" => "6954129c43ad045b81f91f98"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/cbfedfe3a202cd4f6e408fe9846635e0.webp"
"MediaSize" => 135279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-cbfedfe3a202cd4f6e408fe9846635e0.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Split level home with brick siding, driveway, and an attached garage"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.166Z"
]
5 => array:14 [
"Order" => 5
"MediaKey" => "6954129c43ad045b81f91f99"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/8e5e898abeac54bbcf2eef75dd5c6404.webp"
"MediaSize" => 166595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-8e5e898abeac54bbcf2eef75dd5c6404.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "View of patio"
"ShortDescription" => "Patio"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.129Z"
]
6 => array:14 [
"Order" => 6
"MediaKey" => "6954129c43ad045b81f91f9a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/a726eea29420b75427abbe49c6964dac.webp"
"MediaSize" => 130514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-a726eea29420b75427abbe49c6964dac.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Back of house featuring brick siding, a patio, and a gate"
"ShortDescription" => "Back of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.129Z"
]
7 => array:14 [
"Order" => 7
"MediaKey" => "6954129c43ad045b81f91f9b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/944532c3504cd54c8bbc2bdfc72f561e.webp"
"MediaSize" => 134842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-944532c3504cd54c8bbc2bdfc72f561e.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Back of house featuring a patio and brick siding"
"ShortDescription" => "Back of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.163Z"
]
8 => array:14 [
"Order" => 8
"MediaKey" => "6954129c43ad045b81f91f9c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/e76bb9c469aaa4d26f128f0a87a47d2e.webp"
"MediaSize" => 141554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-e76bb9c469aaa4d26f128f0a87a47d2e.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Rear view of house with a patio area, cooling unit, brick siding, and a chimney"
"ShortDescription" => "Back of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.129Z"
]
9 => array:14 [
"Order" => 9
"MediaKey" => "6954129c43ad045b81f91f9d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/d905e26c6746000f9e99c5a6326b0277.webp"
"MediaSize" => 83992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-d905e26c6746000f9e99c5a6326b0277.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Stairway with vaulted ceiling"
"ShortDescription" => "Other"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.167Z"
]
10 => array:14 [
"Order" => 10
"MediaKey" => "6954129c43ad045b81f91f9e"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/8a584f69224e3292172b371c8a0cc6d3.webp"
"MediaSize" => 110764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-8a584f69224e3292172b371c8a0cc6d3.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living room with lofted ceiling, wood finished floors, a chandelier, baseboard heating, and baseboards"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.127Z"
]
11 => array:14 [
"Order" => 11
"MediaKey" => "6954129c43ad045b81f91f9f"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/bc982d5a416ed117d3765a7244001091.webp"
"MediaSize" => 102091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-bc982d5a416ed117d3765a7244001091.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living room featuring lofted ceiling, wood finished floors, and recessed lighting"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.140Z"
]
12 => array:14 [
"Order" => 12
"MediaKey" => "6954129c43ad045b81f91fa0"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/eff984a6630f4e34f1c1b7945806bad7.webp"
"MediaSize" => 113520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-eff984a6630f4e34f1c1b7945806bad7.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living room featuring wood finished floors, vaulted ceiling, stairs, and recessed lighting"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.127Z"
]
13 => array:14 [
"Order" => 13
"MediaKey" => "6954129c43ad045b81f91fa1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/a53a338bdd0dfb4f2d7a481849bb28b7.webp"
"MediaSize" => 120305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-a53a338bdd0dfb4f2d7a481849bb28b7.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living area featuring a chandelier, wood finished floors, stairway, and recessed lighting"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.147Z"
]
14 => array:14 [
"Order" => 14
"MediaKey" => "6954129c43ad045b81f91fa2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/b446c8613b8b793179d7bf76137e15ef.webp"
"MediaSize" => 130363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-b446c8613b8b793179d7bf76137e15ef.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Dining area featuring wooden walls, a chandelier, a baseboard heating unit, and wood finished floors"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.165Z"
]
15 => array:14 [
"Order" => 15
"MediaKey" => "6954129c43ad045b81f91fa3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/b40227c2e5fa8a3621caf97bed3152fa.webp"
"MediaSize" => 133655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-b40227c2e5fa8a3621caf97bed3152fa.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Dining area featuring a chandelier, wood walls, crown molding, and light wood-type flooring"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.119Z"
]
16 => array:14 [
"Order" => 16
"MediaKey" => "6954129c43ad045b81f91fa4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/cc407706a027c8502fd8a25d2e01079c.webp"
"MediaSize" => 109707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-cc407706a027c8502fd8a25d2e01079c.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Dining room with a baseboard heating unit, recessed lighting, and baseboards"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.113Z"
]
17 => array:14 [
"Order" => 17
"MediaKey" => "6954129c43ad045b81f91fa5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/d3b07c171733c9a2cf75c5546ae7d641.webp"
"MediaSize" => 95247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-d3b07c171733c9a2cf75c5546ae7d641.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Dining area with recessed lighting and stairway"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.119Z"
]
18 => array:14 [
"Order" => 18
"MediaKey" => "6954129c43ad045b81f91fa6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/44d47c5e2b114a8e82b74e9004e65d91.webp"
"MediaSize" => 114829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-44d47c5e2b114a8e82b74e9004e65d91.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Kitchen featuring appliances with stainless steel finishes, a sink, recessed lighting, backsplash, and glass insert cabinets"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.115Z"
]
19 => array:14 [
"Order" => 19
"MediaKey" => "6954129c43ad045b81f91fa7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/ed7841db566460aade7f439925f4b3ff.webp"
"MediaSize" => 122117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-ed7841db566460aade7f439925f4b3ff.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Kitchen featuring stainless steel appliances, backsplash, baseboards, recessed lighting, and glass insert cabinets"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.156Z"
]
20 => array:14 [
"Order" => 20
"MediaKey" => "6954129c43ad045b81f91fa8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/796ee0d0ae795c4db7ece30966cd3bb1.webp"
"MediaSize" => 82921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-796ee0d0ae795c4db7ece30966cd3bb1.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Entryway featuring radiator heating unit and baseboards"
"ShortDescription" => "Entry"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.118Z"
]
21 => array:14 [
"Order" => 21
"MediaKey" => "6954129c43ad045b81f91fa9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/94aa9eee2c2f70b724e217ae3a01dc16.webp"
"MediaSize" => 86485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-94aa9eee2c2f70b724e217ae3a01dc16.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living area with carpet, baseboards, and baseboard heating"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.113Z"
]
22 => array:14 [
"Order" => 22
"MediaKey" => "6954129c43ad045b81f91faa"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/b1eea1cf177988e2be7d487837af7d8b.webp"
"MediaSize" => 77766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-b1eea1cf177988e2be7d487837af7d8b.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Carpeted living area featuring baseboards"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.182Z"
]
23 => array:14 [
"Order" => 23
"MediaKey" => "6954129c43ad045b81f91fab"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/3e835795b36066c7dc45029804ca133f.webp"
"MediaSize" => 219911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-3e835795b36066c7dc45029804ca133f.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Bathroom featuring wallpapered walls, a sink, toilet, and tile patterned floors"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.113Z"
]
24 => array:14 [
"Order" => 24
"MediaKey" => "6954129c43ad045b81f91fac"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/9dffdbdbc1060315e4babb0ee00a4c5a.webp"
"MediaSize" => 119796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-9dffdbdbc1060315e4babb0ee00a4c5a.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Indoor dry bar with stairway, wooden walls, carpet floors, recessed lighting, and a textured ceiling"
"ShortDescription" => "Bar"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.150Z"
]
25 => array:14 [
"Order" => 25
"MediaKey" => "6954129c43ad045b81f91fad"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/58a5ab32d1816e071769837002664079.webp"
"MediaSize" => 128341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-58a5ab32d1816e071769837002664079.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Carpeted dining area featuring a bar, wooden walls, a textured ceiling, and a baseboard radiator"
"ShortDescription" => "Dining Area"
…3
]
26 => array:14 [ …14]
27 => array:14 [ …14]
28 => array:14 [ …14]
29 => array:14 [ …14]
30 => array:14 [ …14]
31 => array:14 [ …14]
32 => array:14 [ …14]
33 => array:14 [ …14]
34 => array:14 [ …14]
35 => array:14 [ …14]
36 => array:14 [ …14]
37 => array:14 [ …14]
38 => array:14 [ …14]
39 => array:14 [ …14]
40 => array:14 [ …14]
41 => array:14 [ …14]
42 => array:14 [ …14]
43 => array:14 [ …14]
44 => array:14 [ …14]
]
+"ID": "25980"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5120
+post_id: "30357"
+post_author: 1
+"ListingKey": "KEY420412902"
+"ListingId": "873340"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-15T20:39:53Z"
+"RFModificationTimestamp": "2025-06-15T20:42:09Z"
+"ListPrice": 3750000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 6300.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11559"
+"UnparsedAddress": "8 Stuyvesant Place, Hempstead, New York 11559"
+"Coordinates": array:2 [
0 => -73.723551
1 => 40.617061
]
+"Latitude": 40.617061
+"Longitude": -73.723551
+"YearBuilt": 1936
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jillian Felder"
+"ListOfficeName": "Desimone Real Estate"
+"ListAgentMlsId": "225439"
+"ListOfficeMlsId": "DSMN01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Exquisite Fully Renovated Colonial Home in the Five Towns - Welcome to this magnificent 7-bedroom, 4.5-bathroom Colonial residence, set on a beautiful tree-lined cul-de-sac in the heart of Lawrence. This grand home offers over 6,000 square feet of meticulously designed living space, perfect for both sophisticated entertaining and comfortable family living.\n
Upon entering, you are greeted by a gracious foyer with a stunning dining room to your right and a nice sized living room to your left. At the heart of the home is a gourmet chef’s kitchen, thoughtfully designed with high-end stainless steel appliances, white caesar stone countertops, a generous center island, and a large amount of cabinetry. A large breakfast room overlooks the lush backyard. The home is covered with windows creating an even more opened feel space and beautiful natural light. The main level also features an extra closed room and half bath.\n
The upper level boasts five spacious bedrooms, including a luxurious primary suite complete with a spa-inspired ensuite bathroom and huge walk-in closet. Each additional bedroom offers ample closet space and beautiful natural light, while all bathrooms feature premium fixtures and finishes.\n
Additional highlights include a fully finished basement with recreational space, tons of storage, two bedrooms, 1 full bathroom, and a spacious dedicated laundry room. The beautifully landscaped grounds provide room for outdoor entertaining or future pool installation.\n
Located near many synagogues, shopping, and transportation, this exceptional Colonial is a great find in one of Long Island’s most sought-after communities. Move-in ready and built to impress, this home is the perfect blend of traditional charm and contemporary convenience.
"""
+"Appliances": array:10 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Freezer"
3 => "Gas Cooktop"
4 => "Gas Oven"
5 => "Oven"
6 => "Refrigerator"
7 => "Stainless Steel Appliance(s)"
8 => "Washer"
9 => "Gas Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-534-2200"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 4
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:4 [
0 => "Brick"
1 => "Foam Insulation"
2 => "Frame"
3 => "Stucco"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-05T14:59:53.682866+00:00"
+"CrossStreet": "Sealy Court"
+"CumulativeDaysOnMarket": 3
+"DaysOnMarket": 325
+"DirectionFaces": "East"
+"ElementarySchool": "Lawrence Elementary School-Broadway"
+"ElementarySchoolDistrict": "Lawrence"
+"ExpirationDate": "2026-06-01"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:11 [
0 => "Chefs Kitchen"
1 => "Eat-in Kitchen"
2 => "Entrance Foyer"
3 => "Formal Dining"
4 => "High Ceilings"
5 => "Kitchen Island"
6 => "Primary Bathroom"
7 => "Open Kitchen"
8 => "Stone Counters"
9 => "Walk-In Closet(s)"
10 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:4 [
0 => "Gas Dryer Hookup"
1 => "In Basement"
2 => "Laundry Room"
3 => "Washer Hookup"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "212-464-7932"
+"ListAgentEmail": "jillian@dsregroup.com"
+"ListAgentKey": "326234220"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110973"
+"ListOfficePhone": "516-534-2200"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-01"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1939
+"LotSizeSquareFeet": 8448
+"MajorChangeTimestamp": "2025-06-12T04:30:49Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-06-12"
+"OriginalEntryTimestamp": "2025-06-05T14:53:36Z"
+"OriginalListPrice": 3750000
+"OriginatingSystemModificationTimestamp": "2025-06-15T20:38:23Z"
+"OwnerName": "Aaron Felder"
+"ParcelNumber": "2023-41-086-00-0009-0"
+"ParkingFeatures": array:4 [
0 => "Attached"
1 => "Driveway"
2 => "Garage"
3 => "Garage Door Opener"
]
+"PatioAndPorchFeatures": array:1 [
0 => "Patio"
]
+"PhotosChangeTimestamp": "2025-06-05T14:54:36Z"
+"PhotosCount": 37
+"PostalCity": "Lawrence"
+"PostalCodePlus4": "2417"
+"RoomsTotal": "13"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "212-464-7932"
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-06-12T04:30:49Z"
+"StreetName": "Stuyvesant"
+"StreetNumber": "8"
+"StreetNumberNumeric": "8"
+"StreetSuffix": "Place"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "14668.32"
+"TaxAssessedValue": 952
+"TaxYear": "2023"
+"Utilities": array:1 [
0 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "6300.00"
+"KEY_PreviousStatus": "Coming Soon"
+"KEY_CurrentPrice": "3750000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_ConcessionInPrice": "2.00"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "595.23810"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_Attic": "None"
+"KEY_OpenHouseCount": "1"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "19339865.9103"
+"KEY_ConcessionYN": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_RATIO_ListPrice_By_LivingArea": "595.23810"
+"KEY_SourceSystemModificationTimestamp": "2025-06-04T12:19:50.617"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420412902')"
+"provider_name": "One Key"
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:14 [ …14]
4 => array:14 [ …14]
5 => array:14 [ …14]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:14 [ …14]
9 => array:14 [ …14]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:13 [ …13]
13 => array:14 [ …14]
14 => array:13 [ …13]
15 => array:14 [ …14]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:14 [ …14]
31 => array:14 [ …14]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:14 [ …14]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"ID": "30357"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5117
+post_id: "26140"
+post_author: 1
+"ListingKey": "KEY420411615"
+"ListingId": "873302"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-03T19:26:36Z"
+"RFModificationTimestamp": "2026-04-03T19:29:44Z"
+"ListPrice": 2625000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 17372.0
+"LivingArea": 0
+"BuildingAreaTotal": 5482.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "On Merrick Ave Merrick Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Ameet Sikka"
+"ListOfficeName": "National Real Estate Agency"
+"ListAgentMlsId": "208146"
+"ListOfficeMlsId": "NTLR01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Newly Renovated Freestanding Commercial Building in Prime North Merrick Location\n
\n
Exceptional opportunity to own a fully updated brick commercial property situated on a 17,303 sq ft corner lot along a high-traffic main road in North Merrick, NY. This impressive building offers approximately 5,482 sq ft of interior space and is ideally suited for both investors and owner-users.\n
\n
The property features 6 spacious units, each with private entrances, modern flooring, and energy-efficient LED lighting. Additional highlights include 5 bathrooms, storage closets, an unfinished basement ideal for storage and building systems, and a private parking lot with 28 spaces, recently repaved with new blacktop and a newly constructed walkway.\n
\n
The building is currently occupied by a strong mix of professional tenants, including a dentist, psychiatrist, internal medicine physician, cardiologist (featuring a mini operating room), and a foot spa. One unit is currently vacant, presenting an excellent opportunity for an owner-user or additional rental income.\n
\n
Conveniently located near the heart of North Merrick, with close proximity to Starbucks, restaurants, schools, major highways, and shopping centers, this property offers outstanding visibility and accessibility.\n
\n
Don’t miss this rare chance to acquire a turnkey commercial asset in a thriving and highly desirable area.
"""
+"AttributionContact": "516-519-4363"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Walk-Out Access"
]
+"BasementYN": true
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BuildingFeatures": array:3 [
0 => "Bathrooms"
1 => "Lobby"
2 => "Mailbox"
]
+"BusinessType": "Barber/Beauty,Commercial,Dental,Medical,Mixed,Professional/Office"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-778-7771"
+"CoListAgentEmail": "contactsikka@gmail.com"
+"CoListAgentFullName": "Sandeep S. Sikka"
+"CoListAgentKey": "326189806"
+"CoListAgentMlsId": "179239"
+"CoListOfficeKey": "326114175"
+"CoListOfficeMlsId": "NTLR01"
+"CoListOfficeName": "National Real Estate Agency"
+"CoListOfficePhone": "516-888-0884"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-15T01:57:49.660984+00:00"
+"CrossStreet": "Camp Avenue"
+"CumulativeDaysOnMarket": 145
+"DaysOnMarket": 176
+"Directions": "On Merrick Avenue - Cross street is Camp Avenue"
+"Electric": "200+ Amp Service"
+"EntryLevel": 1
+"ExpirationDate": "2027-12-31"
+"Flooring": array:1 [
0 => "Combination"
]
+"FoundationDetails": array:1 [
0 => "Slab"
]
+"Heating": array:1 [
0 => "Oil"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-519-4363"
+"ListAgentEmail": "contactameetsikka@gmail.com"
+"ListAgentKey": "326217497"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114175"
+"ListOfficePhone": "516-888-0884"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-14"
+"LotFeatures": array:1 [
0 => "Corner Lot"
]
+"LotSizeAcres": 0.3988
+"LotSizeSquareFeet": 17372
+"MajorChangeTimestamp": "2026-04-01T20:04:03Z"
+"MajorChangeType": "Back On Market"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"NumberOfBuildings": 1
+"NumberOfUnitsTotal": "6"
+"OnMarketDate": "2025-06-14"
+"OriginalEntryTimestamp": "2025-06-15T01:53:41Z"
+"OriginalListPrice": 2700000
+"OriginatingSystemModificationTimestamp": "2026-04-03T19:24:47Z"
+"OwnerName": "Merrick Corp"
+"ParcelNumber": "2089-56-101-00-0015-0"
+"ParkingFeatures": array:3 [
0 => "Driveway"
1 => "On Street"
2 => "Parking Lot"
]
+"ParkingTotal": "28"
+"PhotosChangeTimestamp": "2025-11-05T00:43:53Z"
+"PhotosCount": 48
+"PostalCity": "Merrick"
+"PreviousListPrice": 2700000
+"PriceChangeTimestamp": "2026-04-01T20:03:07Z"
+"PropertyCondition": array:1 [
0 => "Updated/Remodeled"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-519-4363"
+"ShowingRequirements": array:2 [
0 => "24 Hour Notice"
1 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-04-01T20:04:03Z"
+"Stories": "1"
+"StoriesTotal": "2"
+"StreetName": "Merrick"
+"StreetNumber": "On Merrick Road"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:3 [
0 => "Realtor.com"
1 => "Crexi"
2 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "66887.3"
+"TaxAssessedValue": 12029
+"TaxYear": "2023"
+"Utilities": array:3 [
0 => "Electricity Connected"
1 => "Sewer Connected"
2 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"Zoning": "C"
+"KEY_HoldDate": "2026-01-23"
+"KEY_ElevatorYN": "0"
+"KEY_UsableArea": "5482.00"
+"KEY_CurrentPrice": "2625000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Hold"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Back On Market"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6582246.7402"
+"KEY_SourceSystemModificationTimestamp": "2025-06-04T11:38:31.587"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "478.83984"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97222"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "478.83984"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420411615')"
+"provider_name": "One Key"
+"Media": array:48 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:13 [ …13]
3 => array:14 [ …14]
4 => array:13 [ …13]
5 => array:14 [ …14]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:13 [ …13]
9 => array:14 [ …14]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:14 [ …14]
15 => array:14 [ …14]
16 => array:14 [ …14]
17 => array:14 [ …14]
18 => array:14 [ …14]
19 => array:14 [ …14]
20 => array:14 [ …14]
21 => array:14 [ …14]
22 => array:14 [ …14]
23 => array:13 [ …13]
24 => array:14 [ …14]
25 => array:14 [ …14]
26 => array:14 [ …14]
27 => array:14 [ …14]
28 => array:14 [ …14]
29 => array:14 [ …14]
30 => array:14 [ …14]
31 => array:14 [ …14]
32 => array:14 [ …14]
33 => array:14 [ …14]
34 => array:14 [ …14]
35 => array:14 [ …14]
36 => array:14 [ …14]
37 => array:14 [ …14]
38 => array:14 [ …14]
39 => array:14 [ …14]
40 => array:13 [ …13]
41 => array:14 [ …14]
42 => array:14 [ …14]
43 => array:14 [ …14]
44 => array:14 [ …14]
45 => array:14 [ …14]
46 => array:14 [ …14]
47 => array:14 [ …14]
]
+"ID": "26140"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5121
+post_id: "25968"
+post_author: 1
+"ListingKey": "KEY420409455"
+"ListingId": "873231"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Other"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-01-01T07:07:37Z"
+"RFModificationTimestamp": "2026-01-01T07:12:40Z"
+"ListPrice": 1100.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 80.0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "1231 Broadway, Hempstead, New York 11557"
+"Coordinates": array:2 [
0 => -73.7016963
1 => 40.637674
]
+"Latitude": 40.637674
+"Longitude": -73.7016963
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Gregory Zaurov"
+"ListOfficeName": "Real Broker NY LLC"
+"ListAgentMlsId": "9197679"
+"ListOfficeMlsId": "HOWO01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Suites for Rent – Turnkey Beauty & Wellness Spaces | Hewlett, NY | All Utilities Included\n
Now available in the heart of Hewlett, NY — beautifully maintained private suites ideal for beauty and wellness professionals. Whether you're a hairstylist, esthetician, or cosmetic specialist, this space is ready to support and elevate your business.\n
Property Features:\n
3 Private Suites (Each rented separately) \n
Suite 1: Fully equipped for a hair salon, featuring a professional styling chair and shampoo/head wash station.\n
Suites 2 & 4: Perfect for facials, Botox, lashes, office , or any other personal care services. Clean, spacious, and adaptable to your needs.\n
\n
Located in a high-visibility area with easy access and ample parking, this space offers a professional environment that clients will love.\n
\n
Included Amenities:\n
- Electricity.\n
- Water.\n
- High-speed Internet.\n
- Shared half-bathroom.\n
- On-site washer & dryer.\n
\n
Ready to move in – just bring your tools and talent!\n
Contact us today to schedule a tour or request more information.
"""
+"Appliances": array:3 [
0 => "Dryer"
1 => "Electric Water Heater"
2 => "Washer"
]
+"AttributionContact": "516-401-8821"
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Community Center"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-04T14:44:39.525661+00:00"
+"CumulativeDaysOnMarket": 210
+"DaysOnMarket": 210
+"ExpirationDate": "2026-01-01"
+"Heating": array:2 [
0 => "Electric"
1 => "Forced Air"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseAmountFrequency": "Monthly"
+"LeaseTerm": "Negotiable"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-401-8821"
+"ListAgentEmail": "Greg@gregzhomes.com"
+"ListAgentKey": "326264051"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112133"
+"ListOfficePhone": "855-450-0442"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-06-04"
+"MajorChangeTimestamp": "2026-01-01T05:27:20Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-01-01"
+"OnMarketDate": "2025-06-04"
+"OriginalEntryTimestamp": "2025-06-04T14:40:04Z"
+"OriginalListPrice": 1500
+"OriginatingSystemModificationTimestamp": "2026-01-01T05:27:20Z"
+"OwnerName": "AZ Suites"
+"PhotosChangeTimestamp": "2025-09-28T17:38:49Z"
+"PhotosCount": 9
+"PostalCity": "Hewlett"
+"PreviousListPrice": 1300
+"PriceChangeTimestamp": "2025-09-28T17:36:57Z"
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "Sublease"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-01T05:27:20Z"
+"StreetName": "Broadway"
+"StreetNumber": "1231"
+"StreetNumberNumeric": "1231"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxYear": "2025"
+"Utilities": array:2 [
0 => "Electricity Connected"
1 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_CurrentPrice": "1100.00"
+"KEY_LeasePriceUnit": "Total"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_SourceSystemModificationTimestamp": "2025-06-04T10:40:04.427"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "13.75000"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.73333"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "13.75000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420409455')"
+"provider_name": "One Key"
+"Media": array:9 [
0 => array:13 [ …13]
1 => array:13 [ …13]
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:13 [ …13]
]
+"ID": "25968"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5119
+post_id: "25986"
+post_author: 1
+"ListingKey": "KEY420408569"
+"ListingId": "873207"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2025-09-18T07:06:38Z"
+"RFModificationTimestamp": "2025-09-18T07:08:48Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1753.0
+"BuildingAreaTotal": 1753.0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "2501 Hughes Street, Hempstead, New York 11710"
+"Coordinates": array:2 [
0 => -73.5334401
1 => 40.6633486
]
+"Latitude": 40.6633486
+"Longitude": -73.5334401
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mathias Coni"
+"ListOfficeName": "Oversouth LLC"
+"ListAgentMlsId": "198106"
+"ListOfficeMlsId": "OVRS02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to Hughes Street, a beautifully updated split-level home situated on an oversized 10,000 square foot lot in the heart of Bellmore.This meticulously maintained 4-bedroom, 2-bathroom residence offers a spacious and functional layout ideal for comfortable living. The main level features an open-concept design with a fully renovated kitchen that includes granite countertops, stainless steel appliances, custom cabinetry, and a large center island. Beautiful hardwood floors flow throughout the main living areas, complemented by abundant natural light in the generously sized living room.The upper level features three bedrooms, including a large primary bedroom with a double closet, and a fully renovated hall bathroom with modern finishes. The lower level offers a spacious living den with a separate entrance and an additional fourth bedroom, providing excellent flexibility for guests, extended family, or a private home office. A second fully renovated full bathroom is also located on the lower level.Additional highlights include a full basement with laundry and storage, a 1-car attached garage, and a private driveway. The expansive backyard offers endless possibilities for outdoor enjoyment."
+"Appliances": array:1 [
0 => "ENERGY STAR Qualified Appliances"
]
+"ArchitecturalStyle": array:1 [
0 => "Split Level"
]
+"AttributionContact": "631-770-0030"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerOfficeAOR": "LIBOR"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-776-2826"
+"CoListAgentEmail": "jennajconi@gmail.com"
+"CoListAgentFullName": "Jenna Coni"
+"CoListAgentKey": "326217646"
+"CoListAgentMlsId": "208302"
+"CoListOfficeKey": "406610771"
+"CoListOfficeMlsId": "OVRS02"
+"CoListOfficeName": "Oversouth LLC"
+"CoListOfficePhone": "631-770-0030"
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Frame"
]
+"Cooling": array:2 [
0 => "Ductless"
1 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-18T13:13:20.209082+00:00"
+"CrossStreet": "Argyle Pl"
+"CumulativeDaysOnMarket": 7
+"DaysOnMarket": 7
+"Directions": "Merrick Rd to Argyle to Hughes St"
+"ElementarySchool": "Shore Road School"
+"ElementarySchoolDistrict": "Bellmore"
+"ExpirationDate": "2025-12-05"
+"FireplaceFeatures": array:1 [
0 => "Gas"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:6 [
0 => "First Floor Bedroom"
1 => "Eat-in Kitchen"
2 => "Granite Counters"
3 => "Kitchen Island"
4 => "Open Floorplan"
5 => "Open Kitchen"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-587-3283"
+"ListAgentEmail": "mathiasconi737@gmail.com"
+"ListAgentKey": "326207699"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "406610771"
+"ListOfficePhone": "631-770-0030"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-05"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.2296
+"LotSizeSquareFeet": 10000
+"MajorChangeTimestamp": "2025-09-17T14:29:13Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "Grand Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlsStatus": "Hold"
+"OffMarketDate": "2025-09-17"
+"OnMarketDate": "2025-06-05"
+"OriginalEntryTimestamp": "2025-06-05T11:38:45Z"
+"OriginalListPrice": 799000
+"OriginatingSystemModificationTimestamp": "2025-09-17T14:29:13Z"
+"OwnerName": "Dobrowolski"
+"ParcelNumber": "2089-56-319-00-0712-0"
+"PhotosChangeTimestamp": "2025-06-05T11:40:36Z"
+"PhotosCount": 45
+"PostalCity": "Bellmore"
+"PostalCodePlus4": "4005"
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-587-3283"
+"ShowingRequirements": array:2 [
0 => "24 Hour Notice"
1 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-09-17T14:29:13Z"
+"StreetName": "Hughes"
+"StreetNumber": "2501"
+"StreetNumberNumeric": "2501"
+"StreetSuffix": "Street"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "16157.72"
+"TaxAssessedValue": 537
+"TaxYear": "2023"
+"Utilities": array:1 [
0 => "See Remarks"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "See Remarks"
+"KEY_HoldDate": "2025-09-17"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "799000.00"
+"KEY_ContractPrice": "799000.00"
+"KEY_OpenHouseCount": "4"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "1753.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "455.79007"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3479965.1568"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "455.79007"
+"KEY_SourceSystemModificationTimestamp": "2025-06-04T10:04:37.890"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "455.79007"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "455.79007"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420408569')"
+"provider_name": "One Key"
+"Media": array:45 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:14 [ …14]
5 => array:14 [ …14]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:14 [ …14]
9 => array:14 [ …14]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:14 [ …14]
15 => array:14 [ …14]
16 => array:14 [ …14]
17 => array:14 [ …14]
18 => array:14 [ …14]
19 => array:14 [ …14]
20 => array:14 [ …14]
21 => array:14 [ …14]
22 => array:14 [ …14]
23 => array:14 [ …14]
24 => array:14 [ …14]
25 => array:14 [ …14]
26 => array:14 [ …14]
27 => array:14 [ …14]
28 => array:14 [ …14]
29 => array:14 [ …14]
30 => array:14 [ …14]
31 => array:14 [ …14]
32 => array:14 [ …14]
33 => array:14 [ …14]
34 => array:14 [ …14]
35 => array:14 [ …14]
36 => array:14 [ …14]
37 => array:14 [ …14]
38 => array:14 [ …14]
39 => array:14 [ …14]
40 => array:14 [ …14]
41 => array:14 [ …14]
42 => array:14 [ …14]
43 => array:14 [ …14]
44 => array:14 [ …14]
]
+"ID": "25986"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5116
+post_id: "25956"
+post_author: 1
+"ListingKey": "KEY420395825"
+"ListingId": "872873"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Business"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-12-03T07:02:45Z"
+"RFModificationTimestamp": "2025-12-03T07:09:36Z"
+"ListPrice": 4100.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1950.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "3259 Long Beach Road, Hempstead, New York 11572"
+"Coordinates": array:2 [
0 => -73.6405608
1 => 40.6317475
]
+"Latitude": 40.6317475
+"Longitude": -73.6405608
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Sondra Lisi"
+"ListOfficeName": "Compass Greater NY LLC"
+"ListAgentMlsId": "9005830"
+"ListOfficeMlsId": "CMPA07"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Prime Opportunity on Long Beach Road in Oceanside\n
\n
Discover the perfect location for your business with this spacious double-sized store situated in a bustling area on Long Beach Road. This property promises high foot traffic and excellent visibility, making it an ideal choice for retailers looking to establish or expand their presence. \n
\n
This property is a rare find in a high-demand location, offering the perfect combination of size, amenities, and accessibility. Whether you're launching a new venture or relocating an existing business, this store provides the foundation for success.
"""
+"Appliances": array:1 [
0 => "None"
]
+"AttributionContact": "516-426-0703"
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Professional Service"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-03T19:01:25.709834+00:00"
+"CrossStreet": "Cortland"
+"CumulativeDaysOnMarket": 315
+"DaysOnMarket": 183
+"DirectionFaces": "West"
+"Exclusions": "Tenant pays electric, gas, water"
+"ExpirationDate": "2025-12-03"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseAmountFrequency": "Monthly"
+"LeaseTerm": "12 Months"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-426-0703"
+"ListAgentEmail": "Sandylisi@compass.com"
+"ListAgentKey": "326251099"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110404"
+"ListOfficePhone": "516-764-6060"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-06-02"
+"MajorChangeTimestamp": "2025-12-03T05:11:08Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"NumberOfUnitsTotal": "1"
+"OffMarketDate": "2025-12-03"
+"OnMarketDate": "2025-06-03"
+"OriginalEntryTimestamp": "2025-06-03T18:56:31Z"
+"OriginalListPrice": 4100
+"OriginatingSystemModificationTimestamp": "2025-12-03T05:11:08Z"
+"OwnerName": "SGL Properties"
+"ParkingFeatures": array:1 [
0 => "Parking Lot"
]
+"ParkingTotal": "15"
+"PhotosChangeTimestamp": "2025-12-03T05:12:38Z"
+"PhotosCount": 2
+"PostalCity": "Oceanside"
+"PriceChangeTimestamp": "2025-06-03T18:56:31Z"
+"PropertyAttachedYN": true
+"PropertyCondition": array:1 [
0 => "Actual"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:2 [
0 => "Appointment Only"
1 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-03T05:11:08Z"
+"Stories": "1"
+"StoriesTotal": "1"
+"StreetName": "Long Beach"
+"StreetNumber": "3259"
+"StreetNumberNumeric": "3259"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "82"
+"TaxYear": "2024"
+"Utilities": array:3 [
0 => "Cable Available"
1 => "Electricity Connected"
2 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_ElevatorYN": "0"
+"KEY_CurrentPrice": "4100.00"
+"KEY_CeilingHeight": "10"
+"KEY_WaterAccessYN": "0"
+"KEY_LeasePriceUnit": "Total"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_SprinklerSystemYN": "1"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_SourceSystemModificationTimestamp": "2025-06-03T14:56:31.393"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "2.10256"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "2.10256"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420395825')"
+"provider_name": "One Key"
+"Media": array:2 [
0 => array:14 [ …14]
1 => array:14 [ …14]
]
+"ID": "25956"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5115
+post_id: "25976"
+post_author: 1
+"ListingKey": "KEY420376197"
+"ListingId": "872264"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-09-25T07:19:37Z"
+"RFModificationTimestamp": "2025-09-25T07:33:54Z"
+"ListPrice": 3000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 800.0
+"BuildingAreaTotal": 68832.0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "320 Atlantic Avenue Unit D11, Hempstead, New York 11518"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1957
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jamie Deutsch"
+"ListOfficeName": "Desimone Real Estate"
+"ListAgentMlsId": "222863"
+"ListOfficeMlsId": "DSMN01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Spacious 2 bedroom, 1 bath unit in a well maintained building near the LIRR, shops, and restaurants. Large living room with hard wood floors and court yard views. Galley kitchen with eat-in area. Both bedrooms are generously sized with hardwood floors and good closet space. Bathroom with tub/shower combo. Walk-up building (no elevator). Heat, gas, water, and common area maintenance included. Laundry in adjacent building. Assigned parking available for $40/month.\n
\n
Move in/out fees apply. 80% floor coverage rule. Refundable floor coverage deposit of $750. All information other to be verified by tenant.
"""
+"Appliances": array:3 [
0 => "Dishwasher"
1 => "Gas Range"
2 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Garden"
]
+"AssociationAmenities": "Landscaping,Maintenance Grounds,Snow Removal,Trash"
+"AssociationYN": true
+"AttributionContact": "516-534-2200"
+"AvailabilityDate": "2025-06-03"
+"Basement": array:1 [
0 => "See Remarks"
]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"CommonWalls": array:1 [
0 => "1 Common Wall"
]
+"ConstructionMaterials": array:1 [
0 => "Other"
]
+"Cooling": array:1 [
0 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-04T16:16:07.065818+00:00"
+"CumulativeDaysOnMarket": 240
+"DaysOnMarket": 111
+"ElementarySchool": "Centre Avenue Elementary School"
+"ElementarySchoolDistrict": "East Rockaway"
+"EntryLevel": 3
+"ExpirationDate": "2025-09-23"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Other"
]
+"Heating": array:1 [
0 => "Hot Water"
]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:2 [
0 => "Eat-in Kitchen"
1 => "Galley Type Kitchen"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:4 [
0 => "Common Area"
1 => "In Basement"
2 => "Laundry Room"
3 => "Outside"
]
+"LeaseTerm": "12 Months"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-728-1731"
+"ListAgentEmail": "jamie@dsregroup.com"
+"ListAgentKey": "326231746"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110973"
+"ListOfficePhone": "516-534-2200"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-05-30"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 1.3722
+"LotSizeSquareFeet": 59773
+"MajorChangeTimestamp": "2025-09-23T23:40:01Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-09-23"
+"OnMarketDate": "2025-06-04"
+"OriginalEntryTimestamp": "2025-06-04T16:08:42Z"
+"OriginalListPrice": 2750
+"OriginatingSystemModificationTimestamp": "2025-09-23T23:40:01Z"
+"OwnerName": "East Rock Tenants Corp"
+"ParcelNumber": "2005-38-520-00-0115-0"
+"PetsAllowed": array:1 [
0 => "No"
]
+"PhotosChangeTimestamp": "2025-09-25T07:19:37Z"
+"PhotosCount": 10
+"PostalCity": "East Rockaway"
+"PreviousListPrice": 2750
+"PriceChangeTimestamp": "2025-06-23T15:46:16Z"
+"PropertyAttachedYN": true
+"RentIncludes": "Association Fees,Gas,Grounds Care,Heat,Hot Water,Snow Removal,Water"
+"RoomsTotal": "5"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-728-1731"
+"ShowingRequirements": array:3 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "See Remarks"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-09-23T23:40:01Z"
+"StoriesTotal": "3"
+"StreetName": "Atlantic"
+"StreetNumber": "320"
+"StreetNumberNumeric": "320"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"UnitNumber": "D11"
+"Utilities": array:2 [
0 => "Electricity Available"
1 => "Sewer Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "None"
+"KEY_ParkingFee": "40"
+"KEY_RentSpreeYN": "1"
+"KEY_CurrentPrice": "3000.00"
+"KEY_RentSpreeURL": "https://apply.link/J_l5wyQ"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "800.00"
+"KEY_RATIO_ListPrice_By_LivingArea": "3.75000"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "2186.2702"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "3.75000"
+"KEY_SourceSystemModificationTimestamp": "2025-06-02T14:40:30.803"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "0.04358"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.09091"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "0.04358"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420376197')"
+"provider_name": "One Key"
+"Media": array:10 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:13 [ …13]
5 => array:14 [ …14]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:14 [ …14]
9 => array:14 [ …14]
]
+"ID": "25976"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5122
+post_id: "25928"
+post_author: 1
+"ListingKey": "KEY420340222"
+"ListingId": "869768"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-02-21T07:01:39Z"
+"RFModificationTimestamp": "2026-02-21T07:04:27Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 981.0
+"BuildingAreaTotal": 981.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "259 N Columbus Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [
0 => -73.5789159
1 => 40.66584
]
+"Latitude": 40.66584
+"Longitude": -73.5789159
+"YearBuilt": 1940
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Kevin Iglesias"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "180504"
+"ListOfficeMlsId": "SPH22"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "House Has 4 Bedrooms, 2 Bathrooms, Full Basement. Investor Special. Drive By Only. Amazing Opportunity To Own This Beautiful Home In Freeport. Close To Nautical Mile, All Transportation And Major Shops. Low Taxes. 1 Hour Train Ride To Manhattan!"
+"Appliances": array:1 [
0 => "Other"
]
+"ArchitecturalStyle": array:1 [
0 => "Exp Cape"
]
+"AttributionContact": "631-642-2300"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Frame"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-09-05T19:13:59.404722+00:00"
+"CumulativeDaysOnMarket": 261
+"DaysOnMarket": 261
+"ElementarySchool": "Archer Street School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-02-28"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:1 [
0 => "First Floor Bedroom"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-618-7413"
+"ListAgentEmail": "kevinsoldmyhome@gmail.com"
+"ListAgentKey": "326190979"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115730"
+"ListOfficePhone": "631-642-2300"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-05-31"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.0459
+"LotSizeSquareFeet": 2000
+"MajorChangeTimestamp": "2026-02-20T22:12:02Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlsStatus": "Hold"
+"OffMarketDate": "2026-02-20"
+"OnMarketDate": "2025-05-31"
+"OriginalEntryTimestamp": "2025-06-01T01:24:49Z"
+"OriginalListPrice": 460000
+"OriginatingSystemModificationTimestamp": "2026-02-20T22:12:02Z"
+"OwnerName": "Espalza"
+"ParcelNumber": "2009-55-361-00-1108-0"
+"PhotosChangeTimestamp": "2025-12-01T05:15:37Z"
+"PhotosCount": 1
+"PostalCity": "Freeport"
+"PostalCodePlus4": "1632"
+"PreviousListPrice": 460000
+"PriceChangeTimestamp": "2025-07-02T19:27:40Z"
+"RoomsTotal": "6"
+"Sewer": array:1 [
0 => "Other"
]
+"ShowingContactPhone": "631-618-7413"
+"ShowingRequirements": array:1 [
0 => "Occupied"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-20T22:12:02Z"
+"StreetDirPrefix": "N"
+"StreetName": "Columbus"
+"StreetNumber": "259"
+"StreetNumberNumeric": "259"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "7298.95"
+"TaxAssessedValue": 316
+"TaxYear": "2023"
+"Utilities": array:1 [
0 => "None"
]
+"WaterSource": array:1 [
0 => "Other"
]
+"KEY_Attic": "Full"
+"KEY_HoldDate": "2026-02-20"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "450000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "981.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "458.71560"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "9803921.5686"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "458.71560"
+"KEY_SourceSystemModificationTimestamp": "2025-05-31T21:24:49.577"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "458.71560"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97826"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "458.71560"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420340222')"
+"provider_name": "One Key"
+"Media": array:1 [
0 => array:14 [ …14]
]
+"ID": "25928"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5123
+post_id: "25929"
+post_author: 1
+"ListingKey": "KEY420337218"
+"ListingId": "869679"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-03-31T07:01:39Z"
+"RFModificationTimestamp": "2026-03-31T07:02:28Z"
+"ListPrice": 175000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 700.0
+"City": "Hempstead"
+"PostalCode": "11563"
+"UnparsedAddress": "504 Merrick Road Unit Gf, Hempstead, New York 11563"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Crystin L. Quick SRS"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "208301"
+"ListOfficeMlsId": "DERE58"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "For sale is a stunning ground-floor office space located in the Lynbrook Terrace building, offering an exceptional blend of elegance and functionality. This fully renovated property is ideally situated just blocks from the Long Island Rail Road in the heart of Lynbrook. The space features a sophisticated design with high-end finishes throughout, creating a welcoming and professional atmosphere. Inside, you will find a waiting room, two spacious treatment rooms equipped with sinks, providing versatility for various uses. The office also includes a modern full bathroom with a shower and ample closet space, adding to the convenience and comfort of the environment. Additionally, a laundry room is conveniently located on the same floor, and a serene garden patio at the back of the building offers a perfect outdoor retreat for breaks or meetings. This property boasts dual access points through the main lobby or a side entrance, allowing for flexible and immediate entry. This turn-key office space is ready to be configured to meet your needs, whether you envision it as a high-end corporate office or converted to your own dream workspace. Do not miss this rare opportunity to secure a prime location with all the modern amenities in place."
+"AttributionContact": "516-432-3400"
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Professional/Office"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Ductless"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-01T10:29:18.059256+00:00"
+"CrossStreet": "Crab Or John"
+"CumulativeDaysOnMarket": 547
+"DaysOnMarket": 303
+"Directions": "Crab Ave to Merrick Rd"
+"ExpirationDate": "2026-03-31"
+"Heating": array:2 [
0 => "Natural Gas"
1 => "Baseboard"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-404-7688"
+"ListAgentEmail": "crystin.quick@elliman.com"
+"ListAgentKey": "326217645"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110783"
+"ListOfficePhone": "516-432-3400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-01"
+"MajorChangeTimestamp": "2026-03-31T04:12:22Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-03-31"
+"OnMarketDate": "2025-06-01"
+"OriginalEntryTimestamp": "2025-06-01T10:26:09Z"
+"OriginalListPrice": 175000
+"OriginatingSystemModificationTimestamp": "2026-03-31T04:12:22Z"
+"OwnerName": "Facella"
+"PhotosChangeTimestamp": "2025-12-31T18:55:36Z"
+"PhotosCount": 26
+"PostalCity": "Lynbrook"
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-404-7688"
+"ShowingRequirements": array:3 [
0 => "Appointment Only"
1 => "Call Listing Agent"
2 => "See Remarks"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-31T04:12:22Z"
+"StreetName": "Merrick"
+"StreetNumber": "504"
+"StreetNumberNumeric": "504"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxYear": "2025"
+"UnitNumber": "GF"
+"Utilities": array:2 [
0 => "Sewer Connected"
1 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"Zoning": "office"
+"KEY_Village": "Lynbrook"
+"KEY_CurrentPrice": "175000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_NumberOfTailBoards": "0"
+"KEY_OverheadDoorHeight": "0"
+"KEY_SourceSystemModificationTimestamp": "2025-05-31T14:55:50.573"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "250.00000"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "250.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420337218')"
+"provider_name": "One Key"
+"Media": array:26 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:14 [ …14]
5 => array:14 [ …14]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:14 [ …14]
9 => array:14 [ …14]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:14 [ …14]
15 => array:14 [ …14]
16 => array:14 [ …14]
17 => array:14 [ …14]
18 => array:14 [ …14]
19 => array:14 [ …14]
20 => array:14 [ …14]
21 => array:14 [ …14]
22 => array:14 [ …14]
23 => array:14 [ …14]
24 => array:14 [ …14]
25 => array:14 [ …14]
]
+"ID": "25929"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5124
+post_id: "25926"
+post_author: 1
+"ListingKey": "KEY420335792"
+"ListingId": "869625"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Business"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-12-01T07:03:37Z"
+"RFModificationTimestamp": "2025-12-01T07:07:58Z"
+"ListPrice": 3750.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 8000.0
+"LivingArea": 0
+"BuildingAreaTotal": 2752.0
+"City": "Hempstead"
+"PostalCode": "11581"
+"UnparsedAddress": "20 Brooklyn Avenue Unit 20, Hempstead, New York 11581"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1952
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Hilary Becker"
+"ListOfficeName": "Becker Realty Services Inc"
+"ListAgentMlsId": "9022302"
+"ListOfficeMlsId": "BCKR01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Please call Listing Agent to schedule an appointment. 516 887-0677"
+"AttributionContact": "516-887-0677"
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Commercial"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-05-31T16:44:46.991208+00:00"
+"CumulativeDaysOnMarket": 184
+"DaysOnMarket": 184
+"ExpirationDate": "2025-12-01"
+"Heating": array:1 [
0 => "Electric"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseAmountFrequency": "Monthly"
+"LeaseTerm": "12 Months"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-887-0677"
+"ListAgentEmail": "hilarybecker7@gmail.com"
+"ListAgentKey": "326253941"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109659"
+"ListOfficePhone": "516-887-0677"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-05-30"
+"LotSizeAcres": 0.1837
+"LotSizeSquareFeet": 8000
+"MajorChangeTimestamp": "2025-12-01T05:14:09Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-12-01"
+"OnMarketDate": "2025-05-31"
+"OriginalEntryTimestamp": "2025-05-31T16:40:08Z"
+"OriginalListPrice": 3750
+"OriginatingSystemModificationTimestamp": "2025-12-01T05:14:09Z"
+"OwnerName": "Arnie Seltzer"
+"ParcelNumber": "2035-39-013-00-0110-0"
+"PhotosChangeTimestamp": "2025-12-01T05:15:37Z"
+"PhotosCount": 7
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "1222"
+"PriceChangeTimestamp": "2025-05-31T16:40:08Z"
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516 887-0677"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-01T05:14:09Z"
+"StreetName": "Brooklyn"
+"StreetNumber": "22"
+"StreetNumberNumeric": "22"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "24494.62"
+"TaxAssessedValue": 2807
+"TaxYear": "2023"
+"UnitNumber": "20"
+"Utilities": array:2 [
0 => "Electricity Available"
1 => "Water Available"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_UsableArea": "800.00"
+"KEY_CurrentPrice": "3750.00"
+"KEY_LeasePriceUnit": "Total"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "20413.7180"
+"KEY_SourceSystemModificationTimestamp": "2025-05-31T12:40:08.263"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.36265"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.36265"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420335792')"
+"provider_name": "One Key"
+"Media": array:7 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:14 [ …14]
5 => array:13 [ …13]
6 => array:13 [ …13]
]
+"ID": "25926"
}
10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5125
+post_id: "25967"
+post_author: 1
+"ListingKey": "KEY420330040"
+"ListingId": "869494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-11-21T07:02:39Z"
+"RFModificationTimestamp": "2025-11-23T10:04:18Z"
+"ListPrice": 1300000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2479.0
+"BuildingAreaTotal": 2479.0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "3142 Shore Road, Hempstead, New York 11710"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Zachary Scher CBR"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "187602"
+"ListOfficeMlsId": "SPH17"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Short Sale, Subject to Bank Approval, By Appointment Only."
+"Appliances": array:2 [
0 => "Gas Range"
1 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "631-751-2111"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "631-974-2609"
+"BuyerAgentEmail": "zachscher@gmail.com"
+"BuyerAgentFullName": "Zachary Scher CBR"
+"BuyerAgentKey": "326197677"
+"BuyerAgentMlsId": "187602"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115725"
+"BuyerOfficeMlsId": "SPH17"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "631-751-2111"
+"ConstructionMaterials": array:1 [
0 => "Other"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-07-08T13:29:34.058402+00:00"
+"CrossStreet": "May Ct"
+"CumulativeDaysOnMarket": 45
+"DaysOnMarket": 45
+"Directions": "Sunrise Hwy To Hewlett Ln To Shore Rd"
+"ElementarySchool": "Shore Road School"
+"ElementarySchoolDistrict": "Bellmore"
+"ExpirationDate": "2026-05-29"
+"FoundationDetails": array:1 [
0 => "Other"
]
+"Heating": array:2 [
0 => "Baseboard"
1 => "Natural Gas"
]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Bellmore"
+"InteriorFeatures": array:1 [
0 => "Storage"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Two"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-974-2609"
+"ListAgentEmail": "zachscher@gmail.com"
+"ListAgentKey": "326197677"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115725"
+"ListOfficePhone": "631-751-2111"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-04"
+"LivingAreaSource": "Other"
+"LotSizeDimensions": "54x131"
+"LotSizeSquareFeet": 9375
+"MajorChangeTimestamp": "2025-11-20T15:42:53Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Grand Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2025-11-20"
+"OnMarketDate": "2025-06-04"
+"OriginalEntryTimestamp": "2025-06-04T14:58:54Z"
+"OriginalListPrice": 869250
+"OriginatingSystemModificationTimestamp": "2025-11-20T15:42:53Z"
+"OwnerName": "Ross"
+"ParcelNumber": "2089-63-284-00-0058-0"
+"ParkingFeatures": array:2 [
0 => "Other"
1 => "Private"
]
+"PhotosChangeTimestamp": "2025-11-23T10:03:50Z"
+"PhotosCount": 24
+"PostalCity": "Bellmore"
+"PreviousListPrice": 869250
+"PriceChangeTimestamp": "2025-10-07T23:49:01Z"
+"PurchaseContractDate": "2025-11-20"
+"RoomsTotal": "5"
+"Sewer": array:1 [
0 => "Other"
]
+"ShowingContactPhone": "631-751-2111"
+"ShowingRequirements": array:1 [
0 => "See Remarks"
]
+"SpecialListingConditions": array:1 [
0 => "Short Sale"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-11-20T15:42:53Z"
+"StreetName": "Shore"
+"StreetNumber": "3142"
+"StreetNumberNumeric": "3142"
+"StreetSuffix": "Road"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "33149"
+"TaxBlock": "284"
+"TaxLot": "58"
+"TaxYear": "2023"
+"Utilities": array:3 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "See Remarks"
+"KEY_HoldDate": "2025-06-06"
+"KEY_TaxSource": "Other"
+"KEY_TaxSection": "63"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1300000.00"
+"KEY_ContractPrice": "1500000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2479.00"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "524.40500"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "524.40500"
+"KEY_SourceSystemModificationTimestamp": "2025-05-30T19:36:45.203"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "524.40500"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.49554"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "524.40500"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420330040')"
+"provider_name": "One Key"
+"Media": array:24 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:14 [ …14]
5 => array:14 [ …14]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:14 [ …14]
9 => array:14 [ …14]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:14 [ …14]
15 => array:14 [ …14]
16 => array:14 [ …14]
17 => array:14 [ …14]
18 => array:14 [ …14]
19 => array:14 [ …14]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:14 [ …14]
23 => array:14 [ …14]
]
+"ID": "25967"
}
11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5126
+post_id: "26487"
+post_author: 1
+"ListingKey": "KEY420319821"
+"ListingId": "869193"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-05-02T07:02:38Z"
+"RFModificationTimestamp": "2026-05-02T07:03:33Z"
+"ListPrice": 635000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 6660.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "335 Arthur Street Street, Hempstead, New York 11520"
+"Coordinates": array:2 [
0 => -73.5795503
1 => 40.6400717
]
+"Latitude": 40.6400717
+"Longitude": -73.5795503
+"YearBuilt": 1928
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Amanda R. Muldowney"
+"ListOfficeName": "Becker Realty Services Inc"
+"ListAgentMlsId": "216486"
+"ListOfficeMlsId": "BCKR01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
This unique waterfront Cape-style home in a prime Freeport cul-de-sac offers 2 bedrooms, 2 baths, and direct canal access to the Jones Inlet, with 185 ft of updated private bulkhead—perfect for boats and water sports. Recent updates include a new roof. Inside, the home features inviting brick floors throughout the entry and living room, two fireplaces, one in the main bedroom and a stunning stone wood-burning fireplace in the living room. A charming and bright eat in kitchen boasts an atrium style sunroof, Large windows, and a walk-in pantry. The living room area has built in shelves and wall to wall windows that will provide tons of light and back yard water views, built-in shelves and a magnificent stone wood-burning fireplace. Additional first floor highlights include a sun room, garden room, attached garage, and an expansive deck/patio ideal for outdoor entertaining —ready for a modern transformation. With thoughtful restoration, this home has the potential to become a luxurious waterfront retreat, offering both style and functionality in one of the most desirable locations. Enjoy enhanced privacy with, just moments from Freeport’s Nautical Mile. A rare opportunity to create a true luxury gem!\n
\n
\n
\n
\n
Ask ChatGPT
"""
+"Appliances": array:1 [
0 => "Electric Range"
]
+"ArchitecturalStyle": array:1 [
0 => "Cape Cod"
]
+"AttributionContact": "516-887-0677"
+"Basement": array:2 [
0 => "Full"
1 => "Unfinished"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "HGAR"
+"BuyerAgentDirectPhone": "000-000-0000"
+"BuyerAgentFullName": "Unrepresented Buyer"
+"BuyerAgentKey": "421786246"
+"BuyerAgentMlsId": "347752"
+"BuyerOfficeAOR": "HGAR"
+"BuyerOfficeKey": "1262827"
+"BuyerOfficeMlsId": "888888"
+"BuyerOfficeName": "Buyer Representation Office"
+"BuyerOfficePhone": "000-000-0000"
+"CoBuyerAgentAOR": "HGAR"
+"CoBuyerAgentDirectPhone": "000-000-0000"
+"CoBuyerAgentFullName": "Unrepresented Buyer"
+"CoBuyerAgentKey": "421786246"
+"CoBuyerAgentMlsId": "347752"
+"CoBuyerOfficeKey": "1262827"
+"CoBuyerOfficeMlsId": "888888"
+"CoBuyerOfficeName": "Buyer Representation Office"
+"CoBuyerOfficePhone": "000-000-0000"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-697-9529"
+"CoListAgentEmail": "mtkennedy39@gmail.com"
+"CoListAgentFullName": "Mary Kennedy"
+"CoListAgentKey": "326194399"
+"CoListAgentMlsId": "184169"
+"CoListOfficeKey": "326109659"
+"CoListOfficeMlsId": "BCKR01"
+"CoListOfficeName": "Becker Realty Services Inc"
+"CoListOfficePhone": "516-887-0677"
+"ConstructionMaterials": array:1 [
0 => "Aluminum Siding"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-07-15T15:42:59.605521+00:00"
+"CrossStreet": "Sportsman"
+"CumulativeDaysOnMarket": 162
+"DaysOnMarket": 162
+"Directions": "Atlantic Ave to Sportsman St. Turn left on Arthur Street to the end."
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2027-03-19"
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Oil"
]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:4 [
0 => "Formal Dining"
1 => "Open Floorplan"
2 => "Pantry"
3 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Two"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-721-2119"
+"ListAgentEmail": "muldowney817@gmail.com"
+"ListAgentKey": "326225568"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109659"
+"ListOfficePhone": "516-887-0677"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-07-15"
+"LivingAreaSource": "Public Records"
+"MajorChangeTimestamp": "2026-05-01T15:35:49Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-05-01"
+"OnMarketDate": "2025-07-21"
+"OriginalEntryTimestamp": "2025-07-15T15:40:18Z"
+"OriginalListPrice": 750000
+"OriginatingSystemModificationTimestamp": "2026-05-01T15:35:49Z"
+"OwnerName": "Estate of Spencer Michlow"
+"PatioAndPorchFeatures": array:1 [
0 => "Porch"
]
+"PhotosChangeTimestamp": "2026-03-20T15:52:36Z"
+"PhotosCount": 17
+"PostalCity": "Freeport"
+"PreviousListPrice": 650000
+"PriceChangeTimestamp": "2026-04-08T18:42:55Z"
+"PurchaseContractDate": "2026-05-01"
+"RoomsTotal": "7"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "5166979529"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-01T15:35:49Z"
+"StreetName": "Arthur Street"
+"StreetNumber": "335"
+"StreetNumberNumeric": "335"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "12825.68"
+"TaxYear": "2025"
+"Utilities": array:2 [
0 => "Sewer Connected"
1 => "Trash Collection Public"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WaterfrontFeatures": array:1 [
0 => "Canal Access"
]
+"WaterfrontYN": true
+"KEY_Attic": "None"
+"KEY_Village": "Freeport"
+"KEY_HoldDate": "2026-01-24"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "635000.00"
+"KEY_ContractPrice": "500000.00"
+"KEY_OpenHouseCount": "3"
+"KEY_PreviousStatus": "Active"
+"KEY_StreetViewParam": "1$40.64029000133709$-73.57974744606811$132.07$13.33$1.00$3ggvYzzoOkfrsEb200svOQ"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1500.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "5167212119"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "423.33333"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "423.33333"
+"KEY_SourceSystemModificationTimestamp": "2025-05-30T11:48:24.437"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "95.34535"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.84667"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "95.34535"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420319821')"
+"provider_name": "One Key"
+"Media": array:17 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:13 [ …13]
5 => array:14 [ …14]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:14 [ …14]
9 => array:14 [ …14]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:14 [ …14]
15 => array:14 [ …14]
16 => array:14 [ …14]
]
+"ID": "26487"
}
]
+success: true
+page_size: 12
+page_count: 215
+count: 2574
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]