array:1 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=2388&$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: "25521"
+post_author: 1
+"ListingKey": "KEY419823401"
+"ListingId": "855555"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-10-14T07:02:37Z"
+"RFModificationTimestamp": "2025-10-14T07:07:10Z"
+"ListPrice": 759998.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1700.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "322 Marina Pointe, Hempstead, New York 11518"
+"Coordinates": array:2 [
0 => -73.658068
1 => 40.640384
]
+"Latitude": 40.640384
+"Longitude": -73.658068
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Richard Baumel"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "194322"
+"ListOfficeMlsId": "DERE71"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Spectacular Waterfront Townhouse with Scenic Views!\n
Enjoy beautiful waterfront views and watch geese and ducks from your deck. The community features a picnic table area, dog run, and a walking trail. Conveniently located within walking distance to restaurants, coffee shops, the LIRR and shopping. Just a 5-minute walk to the park and a 5-minute drive to the beach.\n
\n
Inside, you’ll find an eat-in chef’s kitchen with under-counter lighting, a kitchen island, pantry, and quartz/quartzite counters. The open floor plan includes a formal dining room, high ceilings, recessed lighting, natural woodwork, and an open kitchen. The primary suite offers his-and-hers closets, a walk-in closet, and a luxurious bathroom with a soaking tub.\n
\n
Appliances include:\n
Convection oven, cooktop, dishwasher, dryer, freezer, gas cooktop, gas oven, gas range, microwave, oven, range, refrigerator, washer, and stainless steel appliances.\n
\n
Additional Features:\n
Elevator, Fire alarm and water sprinkler system directly linked to emergency response\n
Two-way intercom at front entrance, Power outlets on decks and in the included shed\n
No dog restrictions (well-mannered pets welcome)\n
Annual exterior checks and cleaning by property management\n
No flood insurance required (covered by property management)\n
160;Property tax abatement until 2029\n
Dock slip available
"""
+"Appliances": array:8 [
0 => "Dishwasher"
1 => "Dryer"
2 => "ENERGY STAR Qualified Appliances"
3 => "Gas Range"
4 => "Microwave"
5 => "Refrigerator"
6 => "Stainless Steel Appliance(s)"
7 => "Washer"
]
+"AssociationAmenities": "Boat Dock"
+"AssociationFee": "697"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Grounds Care"
2 => "Snow Removal"
3 => "Trash"
]
+"AttributionContact": "516-669-3700"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CarportSpaces": "3"
+"CarportYN": true
+"ConstructionMaterials": array:3 [
0 => "Foam Insulation"
1 => "Frame"
2 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-05-01T13:40:14.137138+00:00"
+"CumulativeDaysOnMarket": 165
+"DaysOnMarket": 165
+"ElementarySchool": "Rhame Avenue Elementary School"
+"ElementarySchoolDistrict": "East Rockaway"
+"ExpirationDate": "2025-10-13"
+"Heating": array:1 [
0 => "Forced Air"
]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:7 [
0 => "Elevator"
1 => "His and Hers Closets"
2 => "Primary Bathroom"
3 => "Open Floorplan"
4 => "Open Kitchen"
5 => "Pantry"
6 => "Quartz/Quartzite Counters"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Laundry Room"
]
+"Levels": array:1 [
0 => "Two"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-395-4770"
+"ListAgentEmail": "richard.baumel@elliman.com"
+"ListAgentKey": "326204067"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110792"
+"ListOfficePhone": "516-669-3700"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-04-30"
+"LivingAreaSource": "Other"
+"LotSizeSquareFeet": 72747
+"MajorChangeTimestamp": "2025-10-13T16:16:31Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-10-13"
+"OnMarketDate": "2025-05-01"
+"OriginalEntryTimestamp": "2025-04-30T19:35:59Z"
+"OriginalListPrice": 799999
+"OriginatingSystemModificationTimestamp": "2025-10-13T16:16:31Z"
+"OwnerName": "Taylor"
+"ParcelNumber": "2089-43-055-00-0411-UCA029100322"
+"ParkingTotal": "4"
+"PetsAllowed": array:3 [
0 => "Cats OK"
1 => "Dogs OK"
2 => "Yes"
]
+"PhotosChangeTimestamp": "2025-09-27T03:24:36Z"
+"PhotosCount": 25
+"PostalCity": "East Rockaway"
+"PreviousListPrice": 759999
+"PriceChangeTimestamp": "2025-08-21T18:26:45Z"
+"PropertyAttachedYN": true
+"RoomsTotal": "5"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "5163954770"
+"ShowingRequirements": array:3 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-10-13T16:16:31Z"
+"StreetName": "Marina Pointe"
+"StreetNumber": "322"
+"StreetNumberNumeric": "322"
+"StructureType": array:1 [
0 => "Townhouse"
]
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "3309"
+"TaxAssessedValue": 645
+"TaxYear": "2025"
+"Utilities": array:4 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Sewer Connected"
3 => "Water Connected"
]
+"View": "Trees/Woods,Water"
+"WaterSource": array:1 [
0 => "Public"
]
+"WaterfrontFeatures": array:2 [
0 => "Canal Front"
1 => "Waterfront"
]
+"WaterfrontYN": true
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_ParkingFee": "0"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "759998.00"
+"KEY_WaterAccessYN": "1"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "0"
+"KEY_RentingAllowedYN": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ApprovalRequiredYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1700.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_AdditionalFeeFrequency": "Monthly"
+"KEY_RATIO_ListPrice_By_LivingArea": "447.05765"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "447.05765"
+"KEY_SourceSystemModificationTimestamp": "2025-04-30T11:43:02.973"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.95000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419823401')"
+"provider_name": "One Key"
+"Media": array:25 [
0 => array:14 [
"Order" => 0
"MediaKey" => "68d758c21ba36328352bb7c6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/dab35aef0030972c24458e8cfcd290b7.webp"
"MediaSize" => 517113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-dab35aef0030972c24458e8cfcd290b7.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "View of front of house featuring a residential view, stairs, and aphalt driveway"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.725Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "68d758c21ba36328352bb7c7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/e0e7b61e393119ea0e3bca1e4a86c562.webp"
"MediaSize" => 522501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-e0e7b61e393119ea0e3bca1e4a86c562.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"ShortDescription" => "Other"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.765Z"
]
2 => array:14 [
"Order" => 2
"MediaKey" => "68d758c21ba36328352bb7c8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/9e1db334d24f0d718b2825b2a97208b3.webp"
"MediaSize" => 404234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-9e1db334d24f0d718b2825b2a97208b3.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Dock area featuring a water view"
"ShortDescription" => "Dock"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.774Z"
]
3 => array:14 [
"Order" => 3
"MediaKey" => "68d758c21ba36328352bb7c9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/88cc3f49b38f67d9e059d8f9e1415249.webp"
"MediaSize" => 276056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-88cc3f49b38f67d9e059d8f9e1415249.webp"
"ImageWidth" => 1280
"Permission" => array:1 [ …1]
"ImageHeight" => 960
"LongDescription" => "Picnic Area, Dog Run"
"ShortDescription" => "Other"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "1280x960"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.745Z"
]
4 => array:14 [
"Order" => 4
"MediaKey" => "68d758c21ba36328352bb7ca"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/095da13398ea5e15595e63e32c34e2bb.webp"
"MediaSize" => 297944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-095da13398ea5e15595e63e32c34e2bb.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1364
"LongDescription" => "Living area featuring wood finished floors and visible vents"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1364"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.758Z"
]
5 => array:14 [
"Order" => 5
"MediaKey" => "68d758c21ba36328352bb7cb"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/7f5813e0a87f05cffd7bc2e2875e7861.webp"
"MediaSize" => 256868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-7f5813e0a87f05cffd7bc2e2875e7861.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Living area featuring baseboards, wood finished floors, and visible vents"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.734Z"
]
6 => array:14 [
"Order" => 6
"MediaKey" => "68d758c21ba36328352bb7cc"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/61b21e854a8aba4e44e6119363c05a7d.webp"
"MediaSize" => 416089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-61b21e854a8aba4e44e6119363c05a7d.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "View of wooden terrace"
"ShortDescription" => "Deck"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.740Z"
]
7 => array:14 [
"Order" => 7
"MediaKey" => "68d758c21ba36328352bb7cd"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/5bb5923665922689649843a473e9e755.webp"
"MediaSize" => 380142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-5bb5923665922689649843a473e9e755.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Dock area featuring a water view"
"ShortDescription" => "Dock"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.740Z"
]
8 => array:14 [
"Order" => 8
"MediaKey" => "68d758c21ba36328352bb7ce"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/e822ddf7e47fdf3a5447c884198d2186.webp"
"MediaSize" => 291750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-e822ddf7e47fdf3a5447c884198d2186.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Living area with visible vents, recessed lighting, and wood finished floors"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.705Z"
]
9 => array:14 [
"Order" => 9
"MediaKey" => "68d758c21ba36328352bb7cf"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/ba7a5cb0eaa5b77d080223038f027995.webp"
"MediaSize" => 281134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-ba7a5cb0eaa5b77d080223038f027995.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Living area featuring visible vents and wood finished floors"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.785Z"
]
10 => array:14 [
"Order" => 10
"MediaKey" => "68d758c21ba36328352bb7d0"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/738c91b9fb4db0963095c2109dae6586.webp"
"MediaSize" => 218622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-738c91b9fb4db0963095c2109dae6586.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Living room with light wood-type flooring, recessed lighting, visible vents, and stairway"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.754Z"
]
11 => array:14 [
"Order" => 11
"MediaKey" => "68d758c21ba36328352bb7d1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/a5d8b6709d90f5cef20e52f7d240e280.webp"
"MediaSize" => 232632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-a5d8b6709d90f5cef20e52f7d240e280.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Kitchen featuring a breakfast bar, tasteful backsplash, a sink, light wood finished floors, and premium appliances"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.717Z"
]
12 => array:14 [
"Order" => 12
"MediaKey" => "68d758c21ba36328352bb7d2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/dde1d0655e274d04cafef661c5539695.webp"
"MediaSize" => 240625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-dde1d0655e274d04cafef661c5539695.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Kitchen featuring visible vents, light wood-type flooring, light stone counters, a sink, and appliances with stainless steel finishes"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.736Z"
]
13 => array:14 [
"Order" => 13
"MediaKey" => "68d758c21ba36328352bb7d3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/6d0d0ebb03944a8bd0271f774879cb35.webp"
"MediaSize" => 265788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-6d0d0ebb03944a8bd0271f774879cb35.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Kitchen featuring decorative backsplash, a kitchen bar, visible vents, light wood-type flooring, and premium appliances"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.737Z"
]
14 => array:14 [
"Order" => 14
"MediaKey" => "68d758c21ba36328352bb7d4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/d191a5b5b66839d465b884daa957a2be.webp"
"MediaSize" => 267643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-d191a5b5b66839d465b884daa957a2be.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Kitchen featuring a sink, stainless steel dishwasher, open floor plan, and visible vents"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.705Z"
]
15 => array:14 [
"Order" => 15
"MediaKey" => "68d758c21ba36328352bb7d5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/af54597973cb11d4e229a52700b07d64.webp"
"MediaSize" => 250026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-af54597973cb11d4e229a52700b07d64.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Bedroom featuring baseboards and wood finished floors"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.717Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "68d758c21ba36328352bb7d6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/4f4f5749149ce756e3a102cc9cf6ec0c.webp"
"MediaSize" => 248953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-4f4f5749149ce756e3a102cc9cf6ec0c.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"ShortDescription" => "Other"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.713Z"
]
17 => array:14 [
"Order" => 17
"MediaKey" => "68d758c21ba36328352bb7d7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/21482e15181c155edfefdb90004beddd.webp"
"MediaSize" => 221467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-21482e15181c155edfefdb90004beddd.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Playroom with visible vents, recessed lighting, baseboards, and wood finished floors"
"ShortDescription" => "Game Room"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.725Z"
]
18 => array:14 [
"Order" => 18
"MediaKey" => "68d758c21ba36328352bb7d8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/78c59eec920cfab1c1169aabb128ce32.webp"
"MediaSize" => 304195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-78c59eec920cfab1c1169aabb128ce32.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "View of balcony"
"ShortDescription" => "Balcony"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.717Z"
]
19 => array:14 [
"Order" => 19
"MediaKey" => "68d758c21ba36328352bb7d9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/1460cffd878254c2801cae7354b13e71.webp"
"MediaSize" => 186558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-1460cffd878254c2801cae7354b13e71.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1364
"LongDescription" => "Full bath featuring visible vents, double vanity, baseboards, a shower stall, and a sink"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1364"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.765Z"
]
20 => array:14 [
"Order" => 20
"MediaKey" => "68d758c21ba36328352bb7da"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/e7de2f2b0f326556ba9d959a6252ea85.webp"
"MediaSize" => 210320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-e7de2f2b0f326556ba9d959a6252ea85.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Full bath featuring toilet, shower / bath combination with curtain, and vanity"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.776Z"
]
21 => array:14 [
"Order" => 21
"MediaKey" => "68d758c21ba36328352bb7db"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/2a44c75d902620e36baa8125a5731760.webp"
"MediaSize" => 220943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-2a44c75d902620e36baa8125a5731760.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1364
"LongDescription" => "Bedroom with baseboards, vaulted ceiling, and wood finished floors"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "2048x1364"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.821Z"
]
22 => array:14 [
"Order" => 22
"MediaKey" => "68d758c21ba36328352bb7dc"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/a26956351d3a1d092cbabb5856531f7c.webp"
"MediaSize" => 255624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-a26956351d3a1d092cbabb5856531f7c.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Elevator"
"ShortDescription" => "Other"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.735Z"
]
23 => array:14 [
"Order" => 23
"MediaKey" => "68d758c21ba36328352bb7dd"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/00ba5b9c3ec3101e073de8c99d918de2.webp"
"MediaSize" => 26312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-00ba5b9c3ec3101e073de8c99d918de2.webp"
"ImageWidth" => 792
"Permission" => array:1 [ …1]
"ImageHeight" => 612
"LongDescription" => "1st Floor layout"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "792x612"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.754Z"
]
24 => array:14 [
"Order" => 24
"MediaKey" => "68d758c21ba36328352bb7de"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/248073d74ef6ecb66437e472201bf7ee.webp"
"MediaSize" => 27442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419823401/thumbnail-248073d74ef6ecb66437e472201bf7ee.webp"
"ImageWidth" => 792
"Permission" => array:1 [ …1]
"ImageHeight" => 612
"LongDescription" => "2nd Floor layout"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "419823401"
"ImageSizeDescription" => "792x612"
"MediaModificationTimestamp" => "2025-09-27T03:23:46.736Z"
]
]
+"ID": "25521"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5120
+post_id: "25480"
+post_author: 1
+"ListingKey": "KEY419813616"
+"ListingId": "855306"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-11-29T07:01:39Z"
+"RFModificationTimestamp": "2025-11-29T07:03:50Z"
+"ListPrice": 1299000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2842.0
+"BuildingAreaTotal": 2842.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "3452 Ocean Avenue, Hempstead, New York 11572"
+"Coordinates": array:2 [
0 => -73.6304831
1 => 40.6272429
]
+"Latitude": 40.6272429
+"Longitude": -73.6304831
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Maria Lindh"
+"ListOfficeName": "Next Level Real Estate NY"
+"ListAgentMlsId": "111539"
+"ListOfficeMlsId": "MRLI01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Live the dream on this rare 80-foot-wide waterfront property! A true boater’s paradise! Located on a deep, wide canal, this expanded 4 bedroom, 2 bath expanded ranch offers breathtaking, unobstructed water views from nearly every angle of its sprawling 2,842 square feet of contemporary living space. Step inside to an open concept layout featuring a spacious eat-in kitchen and sunlit family room, beautifully anchored by a dramatic floor-to-vaulted-ceiling 3-sided stone fireplace. Sliders lead to a generous deck with a pool, perfect for entertaining against the stunning waterfront backdrop. Wake up every day to glorious main-level water views from your master suite, complete with private deck access. Enjoy the spa-like bathroom that includes an amazingly large soaking tub and separate shower. Outdoors, the 80-foot frontage truly shines with boat slips and a massive floating dock. The current owner houses 2 - 22ft boats, a 40 ft boat and a few jet skis...bring your super sized boat! Additional highlights include a heated garage, manicured landscaping, circular driveway, and more. Don't miss this rare opportunity to own 80 feet of pristine waterfront living, an exceptional lifestyle for boaters, entertainers, and anyone who appreciates panoramic views and luxury comfort."
+"Appliances": array:6 [
0 => "Cooktop"
1 => "Dishwasher"
2 => "Dryer"
3 => "Oven"
4 => "Refrigerator"
5 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Exp Ranch"
]
+"AttributionContact": "516-688-3593"
+"Basement": array:1 [
0 => "Crawl Space"
]
+"BathroomsFull": 2
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:3 [
0 => "Brick"
1 => "Frame"
2 => "Shake Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-04-29T23:20:51.446214+00:00"
+"CrossStreet": "Waukena Avenue"
+"CumulativeDaysOnMarket": 214
+"DaysOnMarket": 214
+"Disclosures": array:2 [
0 => "Lead Paint"
1 => "Seller Property Disclosure"
]
+"ElementarySchool": "School 9E-Boardman Elem School"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2025-11-29"
+"ExteriorFeatures": array:2 [
0 => "Boat Slip"
1 => "Dock"
]
+"FireplaceFeatures": array:1 [
0 => "Family Room"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Carpet"
1 => "Tile"
]
+"FrontageLength": "80"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:3 [
0 => "Baseboard"
1 => "Hot Water"
2 => "Natural Gas"
]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:7 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Cathedral Ceiling(s)"
3 => "Eat-in Kitchen"
4 => "Formal Dining"
5 => "Primary Bathroom"
6 => "Master Downstairs"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-688-3593"
+"ListAgentEmail": "maria4home@aol.com"
+"ListAgentKey": "326127512"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113859"
+"ListOfficePhone": "516-688-3593"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-04-28"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:2 [
0 => "Back Yard"
1 => "Front Yard"
]
+"LotSizeAcres": 0.1837
+"LotSizeDimensions": "80x100"
+"LotSizeSquareFeet": 8000
+"MajorChangeTimestamp": "2025-11-29T05:13:10Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-11-29"
+"OnMarketDate": "2025-04-29"
+"OriginalEntryTimestamp": "2025-04-29T23:18:38Z"
+"OriginalListPrice": 1399000
+"OriginatingSystemModificationTimestamp": "2025-11-29T05:13:10Z"
+"OwnerName": "Goldstein"
+"ParcelNumber": "2089-54-455-00-0025-0"
+"ParkingFeatures": array:2 [
0 => "Driveway"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-10-27T11:13:36Z"
+"PhotosCount": 45
+"PoolPrivateYN": true
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "4328"
+"PreviousListPrice": 1360000
+"PriceChangeTimestamp": "2025-08-14T21:33:24Z"
+"RoomsTotal": "9"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "877-847-9523"
+"ShowingRequirements": array:1 [
0 => "Showing Service"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-11-29T05:13:10Z"
+"StreetName": "Ocean"
+"StreetNumber": "3452"
+"StreetNumberNumeric": "3452"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "17755.83"
+"TaxAssessedValue": 647
+"TaxYear": "2023"
+"Utilities": array:2 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WaterfrontFeatures": array:3 [
0 => "Canal Access"
1 => "Canal Front"
2 => "Bulkhead"
]
+"WaterfrontYN": true
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1299000.00"
+"KEY_OpenHouseCount": "7"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "2842.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "457.07248"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7071311.9216"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "457.07248"
+"KEY_SourceSystemModificationTimestamp": "2025-04-29T19:18:38.417"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "457.07248"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.92852"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "457.07248"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419813616')"
+"provider_name": "One Key"
+"Media": array:45 [
0 => array:14 [
"Order" => 0
"MediaKey" => "6894edd7bb13d91993f71c97"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/b8c45bd605d812802a12f22b2a920102.webp"
"MediaSize" => 641595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/thumbnail-b8c45bd605d812802a12f22b2a920102.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "10 minutes to the Open Bay!"
"ShortDescription" => "Aerial View"
"ResourceRecordKey" => "419813616"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-08-07T18:17:59.388Z"
]
1 => array:14 [
"Order" => 1
"MediaKey" => "6894edd7bb13d91993f71c98"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/edb7e647cfedec7f085c454709599462.webp"
"MediaSize" => 717432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/thumbnail-edb7e647cfedec7f085c454709599462.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Aerial view of a pool area"
"ShortDescription" => "Aerial View"
"ResourceRecordKey" => "419813616"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-08-07T18:17:59.357Z"
]
2 => array:14 [
"Order" => 2
"MediaKey" => "6894edd7bb13d91993f71c99"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/0272c9895d002a30c0b5c448d2443d21.webp"
"MediaSize" => 761449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/thumbnail-0272c9895d002a30c0b5c448d2443d21.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "View of front of house featuring brick siding, an attached garage, driveway"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "419813616"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-08-07T18:17:59.376Z"
]
3 => array:14 [
"Order" => 3
"MediaKey" => "6894edd7bb13d91993f71c9a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/a5b9e636a4d9b1be2caa4b58c4d3e701.webp"
"MediaSize" => 696882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/thumbnail-a5b9e636a4d9b1be2caa4b58c4d3e701.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "View of front facade with an attached garage, driveway, brick siding, a front yard, and a chimney"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "419813616"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-08-07T18:17:59.383Z"
]
4 => array:14 [
"Order" => 4
"MediaKey" => "6894edd7bb13d91993f71c9b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/779ab9e97bc871fe5767aee1e7be846f.webp"
"MediaSize" => 728354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/thumbnail-779ab9e97bc871fe5767aee1e7be846f.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "View of front facade featuring a chimney, driveway, brick siding, and a front lawn"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "419813616"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-08-07T18:17:59.390Z"
]
5 => array:14 [
"Order" => 5
"MediaKey" => "6894edd7bb13d91993f71c9c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/3c29cf1a3c6c5b37783091b55b94c432.webp"
"MediaSize" => 542592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/thumbnail-3c29cf1a3c6c5b37783091b55b94c432.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "View of exterior entry with a patio area, double door entry, and a chimney"
"ShortDescription" => "Entry"
"ResourceRecordKey" => "419813616"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-08-07T18:17:59.346Z"
]
6 => array:14 [
"Order" => 6
"MediaKey" => "6894edd7bb13d91993f71c9d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/a194bb5974a02094e82b10645fe23469.webp"
"MediaSize" => 641595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/thumbnail-a194bb5974a02094e82b10645fe23469.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "Aerial perspective of suburban area with a large body of water"
"ShortDescription" => "Aerial View"
"ResourceRecordKey" => "419813616"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-08-07T18:17:59.360Z"
]
7 => array:14 [
"Order" => 7
"MediaKey" => "6894edd7bb13d91993f71c9e"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/5e9bf7f08a065835e132d24da7e9a636.webp"
"MediaSize" => 555340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419813616/thumbnail-5e9bf7f08a065835e132d24da7e9a636.webp"
"ImageWidth" => 2048
…7
]
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": "25480"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5117
+post_id: "25524"
+post_author: 1
+"ListingKey": "KEY419810026"
+"ListingId": "855190"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-01T01:36:36Z"
+"RFModificationTimestamp": "2026-05-01T01:38:42Z"
+"ListPrice": 3000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1849.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "2816 Long Beach Road, Hempstead, New York 11572"
+"Coordinates": array:2 [
0 => -73.640088
1 => 40.6430887
]
+"Latitude": 40.6430887
+"Longitude": -73.640088
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Katherine Koniecko"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "192700"
+"ListOfficeMlsId": "SPH06"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Discover a versatile lower-level commercial space available for lease in a prime Oceanside location on bustling Long Beach Road. Ideal for professionals, small businesses, or satellite offices, this unit is thoughtfully divided into multiple private offices, offering a flexible layout to suit a range of business needs.\n
\n
The space features:\n
-Several individual office rooms perfect for private work areas or client meetings\n
A renovated bathroom\n
2 Private lower-level entrance\n
Excellent visibility and accessibility from Long Beach Rd\n
Close proximity to major transportation, local shops, and restaurants\n
Whether you're a Specialist, consultant, or small business owner, this Oceanside commercial space offers affordability, functionality, and a professional setting to grow your business.\n
\n
Schedule a viewing today and secure your spot in this well-trafficked location!
"""
+"AttributionContact": "516-232-5888"
+"BuildingAreaSource": "Plans"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Storage"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "917-816-0239"
+"CoListAgentEmail": "mkaramoshos@signaturepremier.com"
+"CoListAgentFullName": "Marguerite Karamoshos"
+"CoListAgentKey": "326194806"
+"CoListAgentMlsId": "184590"
+"CoListOfficeKey": "326115726"
+"CoListOfficeMlsId": "SPH18"
+"CoListOfficeName": "Signature Premier Properties"
+"CoListOfficePhone": "516-799-7100"
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Frame"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-05-01T18:31:20.465391+00:00"
+"CrossStreet": "Davison Street"
+"CumulativeDaysOnMarket": 364
+"DaysOnMarket": 367
+"ExpirationDate": "2026-05-31"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseAmountFrequency": "Monthly"
+"LeaseTerm": "24 Months"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-232-5888"
+"ListAgentEmail": "kkoniecko@signaturepremier.com"
+"ListAgentKey": "326202518"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115714"
+"ListOfficePhone": "516-921-1400"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-05-01"
+"MajorChangeTimestamp": "2025-11-11T21:24:48Z"
+"MajorChangeType": "Price Change"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-05-01"
+"OriginalEntryTimestamp": "2025-05-01T18:24:52Z"
+"OriginalListPrice": 4000
+"OriginatingSystemModificationTimestamp": "2026-05-01T01:35:30Z"
+"OwnerName": "Osks Properties Llc"
+"ParkingFeatures": array:3 [
0 => "Off Street"
1 => "On Street"
2 => "Parking Lot"
]
+"PhotosChangeTimestamp": "2025-10-03T15:58:36Z"
+"PhotosCount": 27
+"PostalCity": "Oceanside"
+"PreviousListPrice": 3500
+"PriceChangeTimestamp": "2025-11-11T21:24:48Z"
+"PropertyAttachedYN": true
+"PropertyCondition": array:1 [
0 => "Updated/Remodeled"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-232-5888"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-05-01T18:24:52Z"
+"Stories": "1"
+"StreetName": "Long Beach"
+"StreetNumber": "2816"
+"StreetNumberNumeric": "2816"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxYear": "2025"
+"Utilities": array:5 [
0 => "Electricity Available"
1 => "Natural Gas Available"
2 => "Sewer Available"
3 => "Water Available"
4 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"YearBuiltEffective": 2024
+"KEY_ElevatorYN": "0"
+"KEY_SubleaseYN": "1"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "3000.00"
+"KEY_BuildToSuitYN": "0"
+"KEY_LeasePriceUnit": "Total"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LocationDescription": "Basement,Ground Floor"
+"KEY_InvestmentPropertyYN": "0"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_ShowingContactPhone2": "917-816-0239"
+"KEY_SourceSystemModificationTimestamp": "2025-04-29T16:06:17.937"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.62250"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.75000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.62250"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419810026')"
+"provider_name": "One Key"
+"Media": array:27 [
0 => array:14 [ …14]
1 => array:13 [ …13]
2 => array:13 [ …13]
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:13 [ …13]
12 => array:14 [ …14]
13 => array:13 [ …13]
14 => array:13 [ …13]
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]
]
+"ID": "25524"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5121
+post_id: "25529"
+post_author: 1
+"ListingKey": "KEY419806070"
+"ListingId": "855078"
+"PropertyType": "Residential Income"
+"PropertySubType": "Duplex"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-11-16T05:30:36Z"
+"RFModificationTimestamp": "2025-11-16T05:31:41Z"
+"ListPrice": 789000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1698.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "33 Cleveland Street, Hempstead, New York 11580"
+"Coordinates": array:2 [
0 => -73.689357
1 => 40.6611114
]
+"Latitude": 40.6611114
+"Longitude": -73.689357
+"YearBuilt": 1938
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Maria Goldberg CBR"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "141587"
+"ListOfficeMlsId": "DERE16"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to this Cape Code style home located mid block on a tree lined street, This home features a 10 year old roof, updated kitchen, hardwood floors, large driveway with two car detached garage, fenced in backyard, inviting front porch & timeless brick exterior. The floorplan offers a 2/3 bedroom unit on the fist floor and a 1 bedroom unit on the second floor, there is plenty of storage in the basement with outside entrance. Whether you are looking to move in or invest, this home presents various options for the living space in a convenient location to schools, shopping, dining, park and transportation"
+"ArchitecturalStyle": array:1 [
0 => "Cape Cod"
]
+"AttributionContact": "516-795-3456"
+"Basement": array:2 [
0 => "Full"
1 => "Walk-Out Access"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerOfficeAOR": "HGAR"
+"CancellationDate": "2025-11-14"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-04T19:36:51.898813+00:00"
+"CrossStreet": "Horton Avenue"
+"CumulativeDaysOnMarket": 62
+"DaysOnMarket": 62
+"Directions": "Corona Avenue South to E. Merrick Road to Horton Avenue to Cleveland Street"
+"ElementarySchool": "William L Buck School"
+"ElementarySchoolDistrict": "Valley Stream - 24"
+"ExpirationDate": "2025-11-15"
+"Fencing": array:1 [
0 => "Back Yard"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchoolDistrict": "Valley Stream - 24"
+"InteriorFeatures": array:4 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Eat-in Kitchen"
3 => "Storage"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-225-0626"
+"ListAgentEmail": "maria.goldberg@elliman.com"
+"ListAgentKey": "326154922"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110760"
+"ListOfficePhone": "516-795-3456"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-04-29"
+"LotSizeAcres": 0.1012
+"LotSizeSquareFeet": 4410
+"MajorChangeTimestamp": "2025-11-15T05:11:27Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"NumberOfSeparateElectricMeters": 2
+"NumberOfSeparateGasMeters": 2
+"NumberOfUnitsTotal": "2"
+"OffMarketDate": "2025-07-02"
+"OnMarketDate": "2025-05-01"
+"OriginalEntryTimestamp": "2025-04-30T13:54:38Z"
+"OriginalListPrice": 789000
+"OriginatingSystemModificationTimestamp": "2025-11-16T05:29:23Z"
+"OwnerName": "Michaelidies"
+"ParcelNumber": "2035-37-G-00-0754-0"
+"PatioAndPorchFeatures": array:1 [
0 => "Porch"
]
+"PhotosChangeTimestamp": "2025-11-16T05:30:36Z"
+"PhotosCount": 26
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "6044"
+"PropertyCondition": array:1 [
0 => "Actual"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-225-0626"
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-11-15T05:11:27Z"
+"StreetName": "Cleveland"
+"StreetNumber": "33"
+"StreetNumberNumeric": "33"
+"StreetSuffix": "Street"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "12929.54"
+"TaxAssessedValue": 540
+"TaxBlock": "G"
+"TaxLot": "754"
+"TaxYear": "2023"
+"Utilities": array:3 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Sewer Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_HoldDate": "2025-07-02"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "37G"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "789000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_NumOf1BedRooms": "0"
+"KEY_NumOf2BedRooms": "0"
+"KEY_NumOf3BedRooms": "1"
+"KEY_NumOf4BedRooms": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Canceled"
+"KEY_NumberOfHeatUnits": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7796442.6877"
+"KEY_SourceSystemModificationTimestamp": "2025-04-29T14:02:50.520"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "464.66431"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "464.66431"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419806070')"
+"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:13 [ …13]
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": "25529"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5119
+post_id: "25460"
+post_author: 1
+"ListingKey": "KEY419791646"
+"ListingId": "854614"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-08-01T07:06:37Z"
+"RFModificationTimestamp": "2025-08-01T07:09:17Z"
+"ListPrice": 469000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1178.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "64 Waterview Street, Hempstead, New York 11518"
+"Coordinates": array:2 [
0 => -73.6602174
1 => 40.633954
]
+"Latitude": 40.633954
+"Longitude": -73.6602174
+"YearBuilt": 1926
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Elyahou Nataneli"
+"ListOfficeName": "Prime Homes Realty"
+"ListAgentMlsId": "9018357"
+"ListOfficeMlsId": "PHRE01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "**ALL CASH OFFER ONLY** 1200 Sf Home-Park Your Boat On Driveway. Best Priced Waterfront Colonial Across From Bay County Park, Full Bsmt-Eat-In Kitchen-Two Entrances-It Was Used As Mother/Daughter. Buyer Has To Verify All The Information., Additional information: Appearance:Excellent,Separate Hotwater Heater:Y"
+"Appliances": array:1 [
0 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AssociationAmenities": "Park"
+"AttributionContact": "516-991-7300"
+"Basement": array:2 [
0 => "Full"
1 => "Unfinished"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [
0 => "Frame"
1 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-04-28T20:34:55.333600+00:00"
+"CrossStreet": "5 Th"
+"CumulativeDaysOnMarket": 95
+"DaysOnMarket": 95
+"ElementarySchool": "Contact Agent"
+"ElementarySchoolDistrict": "East Rockaway"
+"ExpirationDate": "2025-08-01"
+"FrontageLength": "50"
+"Heating": array:2 [
0 => "Natural Gas"
1 => "Baseboard"
]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:1 [
0 => "Master Downstairs"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Two"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "elinataneli@gmail.com"
+"ListAgentKey": "326253133"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114516"
+"ListOfficePhone": "516-991-7300"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-04-28"
+"LivingAreaSource": "Public Records"
+"LotSizeDimensions": "50 X 74"
+"LotSizeSquareFeet": 3600
+"MajorChangeTimestamp": "2025-08-01T04:12:21Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-08-01"
+"OnMarketDate": "2025-04-28"
+"OriginalEntryTimestamp": "2025-04-28T20:30:13Z"
+"OriginalListPrice": 469000
+"OriginatingSystemModificationTimestamp": "2025-08-01T04:12:21Z"
+"OwnerName": "NATAN"
+"ParcelNumber": "2089-42-A-00-0044-0"
+"ParkingFeatures": array:2 [
0 => "Private"
1 => "Driveway"
]
+"PhotosChangeTimestamp": "2025-04-28T20:32:36Z"
+"PhotosCount": 6
+"PostalCity": "East Rockaway"
+"PriceChangeTimestamp": "2025-04-28T20:30:13Z"
+"RoomsTotal": "6"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-991-7800"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-08-01T04:12:21Z"
+"StreetName": "Waterview"
+"StreetNumber": "64"
+"StreetNumberNumeric": "64"
+"StreetSuffix": "Street"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "10626"
+"TaxBlock": "A"
+"TaxLot": "44"
+"TaxYear": "2025"
+"Utilities": array:1 [
0 => "Trash Collection Public"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WaterfrontFeatures": array:1 [
0 => "Canal Front"
]
+"WaterfrontYN": true
+"KEY_Attic": "None"
+"KEY_Village": "East Rockaway"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "42"
+"KEY_CurrentPrice": "469000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1178.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "398.13243"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "398.13243"
+"KEY_SourceSystemModificationTimestamp": "2025-04-28T16:30:13.750"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419791646')"
+"provider_name": "One Key"
+"Media": array:6 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:14 [ …14]
5 => array:14 [ …14]
]
+"ID": "25460"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5116
+post_id: "25454"
+post_author: 1
+"ListingKey": "KEY419775208"
+"ListingId": "854051"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-05-01T07:01:40Z"
+"RFModificationTimestamp": "2026-05-01T07:04:20Z"
+"ListPrice": 2500.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 600.0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "2694-2698 Merrick Rd, Hempstead, New York 11710"
+"Coordinates": array:2 [
0 => -73.5257649
1 => 40.663364
]
+"Latitude": 40.663364
+"Longitude": -73.5257649
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Joy B. Kannett"
+"ListOfficeName": "Precise Building Tech Corp"
+"ListAgentMlsId": "119077"
+"ListOfficeMlsId": "SCAR01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "RETAIL SPACE AVAILABLE ON MAJOR TRAFFIC ARTERY, LOCATED IN A NEIGHBORHOOD STRIP CENTER WITH GREAT NEIGHBORING STORES TO HELP WITH ANY BUSINESS~BRINGS MORE PEOPLE TO THE AREA! GREAT VISIBILITY & CLEAR SIGNAGE. THIS SPACE OFFERS MANY OPTIONS FOR YOUR BUSINESS WHETHER YOUR LOOKING TO EXPAND YOUR BUSINESS HORIZONS OR START A NEW VENTURE, THIS LOCATION PROVIDES THE PERFECT LANDSCAPE FOR GROWTH."
+"AttributionContact": "516-799-1900"
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Retail"
+"ConstructionMaterials": array:1 [
0 => "Advanced Framing Technique"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-04-29T04:02:23.412970+00:00"
+"CumulativeDaysOnMarket": 368
+"DaysOnMarket": 368
+"Directions": """
Merrick Road\n
Google Maps
"""
+"ExpirationDate": "2026-05-01"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseAmountFrequency": "Monthly"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-567-0241"
+"ListAgentEmail": "Joy@pbtrealty.com"
+"ListAgentKey": "326134496"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115445"
+"ListOfficePhone": "516-799-1900"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-04-28"
+"MajorChangeTimestamp": "2026-05-01T04:21:57Z"
+"MajorChangeType": "Expired"
+"MlgCanUse": array:3 [
0 => "BO"
1 => "PT"
2 => "VOW"
]
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-05-01"
+"OnMarketDate": "2025-04-28"
+"OriginalEntryTimestamp": "2025-04-29T03:59:33Z"
+"OriginalListPrice": 2500
+"OriginatingSystemModificationTimestamp": "2026-05-01T04:21:57Z"
+"OwnerName": "Stallion Realty Bellmore LLC"
+"PhotosChangeTimestamp": "2025-10-29T04:07:46Z"
+"PhotosCount": 4
+"PostalCity": "Bellmore"
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516 567-0241"
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-01T04:21:57Z"
+"StreetName": "Merrick Rd"
+"StreetNumber": "2694-2698"
+"StreetNumberNumeric": "2694"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxYear": "2025"
+"Utilities": array:3 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_CurrentPrice": "2500.00"
+"KEY_LeasePriceUnit": "Total"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_SourceSystemModificationTimestamp": "2025-04-27T15:28:48.130"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "4.16667"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "4.16667"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419775208')"
+"provider_name": "One Key"
+"Media": array:4 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
]
+"ID": "25454"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5115
+post_id: "25447"
+post_author: 1
+"ListingKey": "KEY419773606"
+"ListingId": "853994"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Apartment"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-05-09T07:09:38Z"
+"RFModificationTimestamp": "2025-05-09T07:10:12Z"
+"ListPrice": 2199.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "1110 William Street, Hempstead, New York 11557"
+"Coordinates": array:2 [
0 => -73.7086235
1 => 40.6411927
]
+"Latitude": 40.6411927
+"Longitude": -73.7086235
+"YearBuilt": 1963
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Marc Jeret"
+"ListOfficeName": "M & J Partners Realty LLC"
+"ListAgentMlsId": "221570"
+"ListOfficeMlsId": "MJPR01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Beautiful large 1 bedroom apartment for rent starting May 1st! ALL UTILITIES except wifi included. Priced to rent out immediately. Can be used as a living or office space. Exclusive right to use backyard but landlord wants to be able to use it on special occasions."
+"Appliances": array:1 [
0 => "Other"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"AttributionContact": "516-874-0263"
+"AvailabilityDate": "2025-05-01"
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Other"
]
+"Cooling": array:1 [
0 => "Electric"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-04-27T16:09:51.884042+00:00"
+"CumulativeDaysOnMarket": 12
+"DaysOnMarket": 12
+"Directions": "google it"
+"ElementarySchool": "Contact Agent"
+"ExpirationDate": "2025-05-09"
+"FoundationDetails": array:1 [
0 => "Other"
]
+"Heating": array:1 [
0 => "Other"
]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:2 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
]
+"RFTransactionType": "For Rent"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-839-3748"
+"ListAgentEmail": "mario@mjpartnersrealty.com"
+"ListAgentKey": "326230497"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "417764778"
+"ListOfficePhone": "516-874-0263"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-04-27"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2025-05-09T04:10:40Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Contact Agent"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-05-09"
+"OnMarketDate": "2025-04-27"
+"OriginalEntryTimestamp": "2025-04-27T16:08:57Z"
+"OriginalListPrice": 2199
+"OriginatingSystemModificationTimestamp": "2025-05-09T04:10:40Z"
+"OwnerName": "Joseph A"
+"PhotosChangeTimestamp": "2025-05-03T07:28:44Z"
+"PhotosCount": 5
+"PostalCity": "Hewlett"
+"RoomsTotal": "4"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "6318393748"
+"ShowingRequirements": array:5 [
0 => "Appointment Only"
1 => "Call Listing Agent"
2 => "Combination Lock Box"
3 => "Lockbox"
4 => "See Remarks"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-05-09T04:10:40Z"
+"StreetName": "William"
+"StreetNumber": "1110"
+"StreetNumberNumeric": "1110"
+"StreetSuffix": "Street"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"Utilities": array:1 [
0 => "See Remarks"
]
+"VirtualTourURLBranded": "https://youtu.be/6v B8r06Quo E?si=l El0QXWmbdr C0Pj0"
+"WaterSource": array:1 [
0 => "Other"
]
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_Attic": "None"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_LivingAreaSearchSqFt": "700.00"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_RentSpreeYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_RATIO_ListPrice_By_LivingArea": "3.14143"
+"KEY_SourceSystemModificationTimestamp": "2025-04-27T10:38:21.010"
+"KEY_CurrentPrice": "2199.00"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "3.14143"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419773606')"
+"provider_name": "One Key"
+"Media": array:5 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:14 [ …14]
]
+"ID": "25447"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5122
+post_id: "25439"
+post_author: 1
+"ListingKey": "KEY419761177"
+"ListingId": "853698"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Multi Family"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-07-28T07:03:39Z"
+"RFModificationTimestamp": "2025-07-28T07:05:06Z"
+"ListPrice": 3500.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 950.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "40 Roeckel Avenue Unit 1st Fl, Hempstead, New York 11580"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Khalid Mehmud"
+"ListOfficeName": "Voro LLC"
+"ListAgentMlsId": "127290"
+"ListOfficeMlsId": "VORO01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Ist floor three bed room 1 bath partment. Tenants pays its own utilities. Tenants can use backyard."
+"Appliances": array:2 [
0 => "Gas Range"
1 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Exp Cape"
]
+"AttributionContact": "877-943-8676"
+"AvailabilityDate": "2025-05-01"
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Frame"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-30T21:13:18.655389+00:00"
+"CrossStreet": "Merrick"
+"CumulativeDaysOnMarket": 73
+"DaysOnMarket": 73
+"ElementarySchool": "Shaw Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 30"
+"ExpirationDate": "2025-07-28"
+"Heating": array:1 [
0 => "Baseboard"
]
+"HighSchool": "Contact Agent"
+"HighSchoolDistrict": "Valley Stream - 30"
+"InteriorFeatures": array:5 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Formal Dining"
3 => "Granite Counters"
4 => "Soaking Tub"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseTerm": "12 Months"
+"Levels": array:1 [
0 => "One"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-330-1911"
+"ListAgentEmail": "ourdreamhouse@hotmail.com"
+"ListAgentKey": "326141944"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326116380"
+"ListOfficePhone": "877-943-8676"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-04-25"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1377
+"LotSizeSquareFeet": 6000
+"MajorChangeTimestamp": "2025-07-28T04:10:18Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Call Listing Agent"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream - 30"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-07-28"
+"OnMarketDate": "2025-04-25"
+"OriginalEntryTimestamp": "2025-04-25T23:06:42Z"
+"OriginalListPrice": 3500
+"OriginatingSystemModificationTimestamp": "2025-07-28T04:10:18Z"
+"OwnerName": "Datta"
+"ParcelNumber": "2035-37-435-00-0457-0"
+"ParkingTotal": "2"
+"PetsAllowed": array:1 [
0 => "No"
]
+"PhotosChangeTimestamp": "2025-04-26T17:41:36Z"
+"PhotosCount": 3
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "3502"
+"PriceChangeTimestamp": "2025-04-25T23:06:42Z"
+"RoomsTotal": "6"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-330-1911"
+"ShowingRequirements": array:1 [
0 => "24 Hour Notice"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-07-28T04:10:18Z"
+"StreetName": "Roeckel"
+"StreetNumber": "40"
+"StreetNumberNumeric": "40"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"UnitNumber": "1st Fl"
+"Utilities": array:1 [
0 => "Water Available"
]
+"WaterSource": array:1 [
0 => "Private"
]
+"KEY_Attic": "None"
+"KEY_Village": "Valley Stream"
+"KEY_HoldDate": "2025-06-09"
+"KEY_SmokingYN": "0"
+"KEY_SeasonalYN": "0"
+"KEY_RentSpreeYN": "1"
+"KEY_CurrentPrice": "3500.00"
+"KEY_RentSpreeURL": "https://apply.link/1N-kFeU"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_SecurityDeposits": "3500"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "950.00"
+"KEY_RATIO_ListPrice_By_LivingArea": "3.68421"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "25417.5744"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "3.68421"
+"KEY_SourceSystemModificationTimestamp": "2025-04-25T19:06:42.047"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419761177')"
+"provider_name": "One Key"
+"Media": array:3 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
]
+"ID": "25439"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5123
+post_id: "25440"
+post_author: 1
+"ListingKey": "KEY419755756"
+"ListingId": "853557"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-06-20T07:07:51Z"
+"RFModificationTimestamp": "2025-06-20T07:13:27Z"
+"ListPrice": 299999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "1203 E Broadway Unit G11, Hempstead, New York 11557"
+"Coordinates": array:2 [
0 => -73.7012313
1 => 40.6348209
]
+"Latitude": 40.6348209
+"Longitude": -73.7012313
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Richard Baumel"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "194322"
+"ListOfficeMlsId": "DERE71"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Large 2 Bedroom, 2 Full Bathroom Apt w/ Huge Terrace In Gardentown Complex-SD#14! This Amazing Units Boasts Central Air, Private Washer/Dryer, Oversized Terrace, a Large Living Rm, Large Formal Dining Rm w/ Door to Oversized Terrace overlooking Hewlett Bay Park, Large Master Bedroom En-Suite w/ Full Bath & Walk-in-Closet, 2nd Bedroom w/ Build-Ins, Hardwood Floors Though out & Plenty of Closets! Maintenance $2,670, Free Parking in Lot or Pay $50/Mth for 2 Garaged Parking Spots! This Stunning Development is situated on several Acres of Land w/ Gorgeous Lush Landscaping & Courtyards...Just Sit on a Bench & Relax! Cats ok. Tenant Pays only Electric & Cable. Charcoal or Electric Grill permitted on Terrace! Very Close to LIRR, Buses & Stores."
+"Appliances": array:6 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Range"
3 => "Refrigerator"
4 => "Stainless Steel Appliance(s)"
5 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Garden"
]
+"AttributionContact": "516-669-3700"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-04-25T18:31:58.283077+00:00"
+"CumulativeDaysOnMarket": 54
+"DaysOnMarket": 54
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"ExpirationDate": "2025-06-19"
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [
0 => "Baseboard"
]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:2 [
0 => "Granite Counters"
1 => "Primary Bathroom"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-395-4770"
+"ListAgentEmail": "richard.baumel@elliman.com"
+"ListAgentKey": "326204067"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110792"
+"ListOfficePhone": "516-669-3700"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-04-25"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2025-06-19T14:43:12Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-06-19"
+"OnMarketDate": "2025-04-26"
+"OriginalEntryTimestamp": "2025-04-25T18:26:54Z"
+"OriginalListPrice": 299999
+"OriginatingSystemModificationTimestamp": "2025-06-19T14:43:12Z"
+"OwnerName": "N Witheld"
+"PetsAllowed": array:1 [
0 => "No"
]
+"PhotosChangeTimestamp": "2025-05-01T15:43:36Z"
+"PhotosCount": 15
+"PostalCity": "Hewlett"
+"RoomsTotal": "5"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "5163954770"
+"ShowingRequirements": array:2 [
0 => "24 Hour Notice"
1 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-06-19T14:43:12Z"
+"StreetName": "E Broadway"
+"StreetNumber": "1203"
+"StreetNumberNumeric": "1203"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"UnitNumber": "G11"
+"Utilities": array:3 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_DownPaymentResourceYN": "1"
+"KEY_EstimatedMaintenance": "2654"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_LivingAreaSearchSqFt": "0.00"
+"KEY_PreviousStatus": "Active"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_CurrentPrice": "299999.00"
+"KEY_WaterAccessYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_ConcessionYN": "0"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_SourceSystemModificationTimestamp": "2025-04-25T14:21:36.630"
+"KEY_ApprovalRequiredYN": "1"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419755756')"
+"provider_name": "One Key"
+"Media": array:15 [
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:13 [ …13]
13 => array:13 [ …13]
14 => array:14 [ …14]
]
+"ID": "25440"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5124
+post_id: "25464"
+post_author: 1
+"ListingKey": "KEY419755489"
+"ListingId": "853544"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Mixed Use"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-04-08T07:01:39Z"
+"RFModificationTimestamp": "2026-04-08T07:06:14Z"
+"ListPrice": 30.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 19123.0
+"LivingArea": 0
+"BuildingAreaTotal": 1700.0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "136 Main Street Unit 148, Hempstead, New York 11518"
+"Coordinates": array:2 [
0 => -73.6661331
1 => 40.6418814
]
+"Latitude": 40.6418814
+"Longitude": -73.6661331
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Vanessa I. Ambrosecchia"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "131396"
+"ListOfficeMlsId": "DERE71"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Office / Retail / Food mix-use property t commercial storefront on a This property promises high foot traffic and excellent traffic visibility 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. Commercial strip. Offering 1700 Sq Feet. Currently used as Russian Supermarket to be delivered vacant July 1st 2025. This can create endless possibilities for your business!"
+"AttributionContact": "516-669-3700"
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Grocery"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-242-0036"
+"CoListAgentEmail": "darab.lawyer@elliman.com"
+"CoListAgentFullName": "Darab K. Lawyer"
+"CoListAgentKey": "326116972"
+"CoListAgentMlsId": "100312"
+"CoListOfficeKey": "326110792"
+"CoListOfficeMlsId": "DERE71"
+"CoListOfficeName": "Douglas Elliman Real Estate"
+"CoListOfficePhone": "516-669-3700"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-04-28T17:37:54.111316+00:00"
+"CumulativeDaysOnMarket": 345
+"DaysOnMarket": 345
+"Directions": "https://maps.app.goo.gl/Cns Zm PFCWVh9JCaf8"
+"ExpirationDate": "2026-04-08"
+"Heating": array:1 [
0 => "Forced Air"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseAmountFrequency": "Annually"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-551-5276"
+"ListAgentEmail": "vanessa.ambrosecchia@elliman.com"
+"ListAgentKey": "326145584"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110792"
+"ListOfficePhone": "516-669-3700"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-04-25"
+"LotSizeAcres": 0.439
+"LotSizeSquareFeet": 19123
+"MajorChangeTimestamp": "2026-04-08T04:11:00Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-04-08"
+"OnMarketDate": "2025-04-28"
+"OriginalEntryTimestamp": "2025-04-28T17:31:52Z"
+"OriginalListPrice": 30
+"OriginatingSystemModificationTimestamp": "2026-04-08T04:11:00Z"
+"OwnerName": "136 ER LLC."
+"ParcelNumber": "2005-42-098-00-0001-0"
+"PhotosChangeTimestamp": "2026-01-12T18:02:36Z"
+"PhotosCount": 17
+"PostalCity": "East Rockaway"
+"PostalCodePlus4": "1702"
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-551-5276"
+"ShowingRequirements": array:1 [
0 => "24 Hour Notice"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-04-08T04:11:00Z"
+"StreetName": "Main"
+"StreetNumber": "136"
+"StreetNumberNumeric": "136"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "63961.81"
+"TaxAssessedValue": 11017
+"TaxYear": "2023"
+"UnitNumber": "148"
+"Utilities": array:1 [
0 => "Electricity Available"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_CurrentPrice": "30.00"
+"KEY_LeasePriceUnit": "Per SqFt"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "68.3371"
+"KEY_SourceSystemModificationTimestamp": "2025-04-25T14:05:01.167"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "0.01765"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "0.01765"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419755489')"
+"provider_name": "One Key"
+"Media": array:17 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:13 [ …13]
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:13 [ …13]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:14 [ …14]
15 => array:13 [ …13]
16 => array:14 [ …14]
]
+"ID": "25464"
}
10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5125
+post_id: "25437"
+post_author: 1
+"ListingKey": "KEY419747883"
+"ListingId": "853344"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-07-01T07:07:41Z"
+"RFModificationTimestamp": "2025-07-01T07:18:43Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1585.0
+"BuildingAreaTotal": 1585.0
+"City": "Hempstead"
+"PostalCode": "11510"
+"UnparsedAddress": "3350 Colony Drive, Hempstead, New York 11510"
+"Coordinates": array:2 [
0 => -73.5968297
1 => 40.6299996
]
+"Latitude": 40.6299996
+"Longitude": -73.5968297
+"YearBuilt": 1960
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Maria A. Mejia"
+"ListOfficeName": "Blackstone Realty"
+"ListAgentMlsId": "211617"
+"ListOfficeMlsId": "RCHB01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Stunning Property Located on the Canal in the serene Baldwin Harbor. Come and explore this beautifully renovated home featuring a modern kitchen, beautiful living room, 3 bedrooms and 3 bathrooms. Enjoy the comfort of a cozy family room and a fully finished basement. The backyard has been beautifully paved with stones, making it perfect for boating enthusiasts. Don't miss the breathtaking view of the canal. This exceptional home is a must-see! Tours 24/7"
+"Appliances": array:1 [
0 => "Stainless Steel Appliance(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Cape Cod"
]
+"AttributionContact": "516-802-3939"
+"Basement": array:2 [
0 => "Finished"
1 => "Walk-Out Access"
]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [
0 => "Frame"
1 => "Stone"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-04-26T01:55:50.693515+00:00"
+"CumulativeDaysOnMarket": 67
+"DaysOnMarket": 67
+"ElementarySchool": "Meadow Elementary School"
+"ElementarySchoolDistrict": "Baldwin"
+"ExpirationDate": "2025-07-01"
+"Flooring": array:3 [
0 => "Ceramic Tile"
1 => "Combination"
2 => "Hardwood"
]
+"Heating": array:1 [
0 => "Baseboard"
]
+"HighSchool": "Baldwin Senior High School"
+"HighSchoolDistrict": "Baldwin"
+"InteriorFeatures": array:2 [
0 => "Open Kitchen"
1 => "Quartz/Quartzite Counters"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In Basement"
]
+"Levels": array:1 [
0 => "Two"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-492-8713"
+"ListAgentEmail": "angiemejia11@icloud.com"
+"ListAgentKey": "326220858"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114911"
+"ListOfficePhone": "516-802-3939"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-04-25"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1102
+"LotSizeSquareFeet": 4800
+"MajorChangeTimestamp": "2025-07-01T04:11:49Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Baldwin Middle School"
+"MiddleOrJuniorSchoolDistrict": "Baldwin"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-07-01"
+"OnMarketDate": "2025-04-25"
+"OriginalEntryTimestamp": "2025-04-26T01:54:07Z"
+"OriginalListPrice": 775000
+"OriginatingSystemModificationTimestamp": "2025-07-01T04:11:49Z"
+"OwnerName": "Diamond Developers"
+"ParcelNumber": "2089-54-348-00-0025-0"
+"ParkingFeatures": array:1 [
0 => "Driveway"
]
+"PhotosChangeTimestamp": "2025-04-26T01:55:36Z"
+"PhotosCount": 22
+"PostalCity": "Baldwin"
+"PostalCodePlus4": "5113"
+"PropertyCondition": array:1 [
0 => "Updated/Remodeled"
]
+"RoomsTotal": "7"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "(516)492-8713"
+"ShowingRequirements": array:1 [
0 => "Combination Lock Box"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-07-01T04:11:49Z"
+"StreetName": "Colony"
+"StreetNumber": "3350"
+"StreetNumberNumeric": "3350"
+"StreetSuffix": "Drive"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "14249.96"
+"TaxAssessedValue": 468
+"TaxYear": "2023"
+"Utilities": array:1 [
0 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WaterfrontFeatures": array:2 [
0 => "Canal Access"
1 => "Canal Front"
]
+"WaterfrontYN": true
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "1585.00"
+"KEY_PreviousStatus": "Active"
+"KEY_CurrentPrice": "775000.00"
+"KEY_NumberOfKitchens": "1"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "488.95899"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_Attic": "Dormer"
+"KEY_OpenHouseCount": "2"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7032667.8766"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "488.95899"
+"KEY_SourceSystemModificationTimestamp": "2025-04-25T08:36:33.113"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419747883')"
+"provider_name": "One Key"
+"Media": array:22 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:14 [ …14]
5 => array:13 [ …13]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:14 [ …14]
9 => array:14 [ …14]
10 => array:13 [ …13]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:13 [ …13]
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]
]
+"ID": "25437"
}
11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5126
+post_id: "25415"
+post_author: 1
+"ListingKey": "KEY419672930"
+"ListingId": "851887"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2025-09-04T07:03:41Z"
+"RFModificationTimestamp": "2025-09-04T07:06:46Z"
+"ListPrice": 405000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 750.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "100 Daly Boulevard Unit 411, Hempstead, New York 11572"
+"Coordinates": array:2 [
0 => -73.6448473
1 => 40.6208023
]
+"Latitude": 40.6208023
+"Longitude": -73.6448473
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Perry Pappas"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "174216"
+"ListOfficeMlsId": "BRMN05"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Introducing Daly Blvd - Discover effortless living in this beautiful 1-bedroom, 1-bath unit in the exclusive Oceanside Cove community. The spacious layout features a upgraded kitchen with a brand-new oven, a sunlit living and dining area, and an large bedroom with a walk-in closet. Enjoy the ease of in-unit laundry and step through sliding doors to your private patio, a lush and tranquil retreat perfect for morning coffee or evening unwinding. Luxury, privacy, and comfort—all in one of Oceanside’s most desirable communities. Generous closet space, central air, and heating provide added convenience. This home includes one designated parking spot, with additional municipal parking available. On-site amenities include a gym, sauna, basketball and tennis courts, a playground, dog run, three outdoor pools, a community library, and a recreation room—ideal for hosting events. Just minutes from shopping and dining, Daly Blvd offers an exceptional lifestyle in a prime location. Maintenance - $562.82 & HOA - $495.00"
+"Appliances": array:1 [
0 => "Stainless Steel Appliance(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Garden"
]
+"AssociationFee": "495"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"AssociationYN": true
+"AttributionContact": "516-223-2525"
+"BathroomsFull": 1
+"BuilderModel": "Garden Level"
+"BuildingAreaUnits": "Square Feet"
+"BuyerOfficeAOR": "LIBOR"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-644-3929"
+"CoListAgentEmail": "dazzato@cbamhomes.com"
+"CoListAgentFullName": "Denise L. Azzato ABR SFR"
+"CoListAgentKey": "326128345"
+"CoListAgentMlsId": "112444"
+"CoListOfficeKey": "326109936"
+"CoListOfficeMlsId": "BRMN05"
+"CoListOfficeName": "Coldwell Banker American Homes"
+"CoListOfficePhone": "516-223-2525"
+"ConstructionMaterials": array:1 [
0 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-04-24T14:38:26.913784+00:00"
+"CrossStreet": "Long Beach Rd"
+"CumulativeDaysOnMarket": 48
+"DaysOnMarket": 48
+"Directions": "Long Beach Rd or Lawson Blvd to Daly Blvd"
+"ElementarySchool": "School 4"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2025-10-31"
+"ExteriorFeatures": array:6 [
0 => "Basketball Court"
1 => "Courtyard"
2 => "Dog Run"
3 => "Mailbox"
4 => "Playground"
5 => "Tennis Court(s)"
]
+"Heating": array:1 [
0 => "Forced Air"
]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:5 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Ceiling Fan(s)"
3 => "Eat-in Kitchen"
4 => "Quartz/Quartzite Counters"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-223-2525"
+"ListAgentEmail": "Perrpapp@gmail.com"
+"ListAgentKey": "326185183"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109936"
+"ListOfficePhone": "516-223-2525"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-04-24"
+"LivingAreaSource": "Plans"
+"MajorChangeTimestamp": "2025-09-03T12:47:40Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlsStatus": "Hold"
+"OffMarketDate": "2025-09-03"
+"OnMarketDate": "2025-04-24"
+"OriginalEntryTimestamp": "2025-04-24T14:28:25Z"
+"OriginalListPrice": 405000
+"OriginatingSystemModificationTimestamp": "2025-09-03T12:47:40Z"
+"OwnerName": "Knob"
+"ParkingFeatures": array:3 [
0 => "Assigned"
1 => "Common"
2 => "Parking Lot"
]
+"PetsAllowed": array:1 [
0 => "Yes"
]
+"PhotosChangeTimestamp": "2025-04-24T14:29:36Z"
+"PhotosCount": 37
+"PoolFeatures": array:1 [
0 => "Community"
]
+"PostalCity": "Oceanside"
+"PropertyAttachedYN": true
+"RoomsTotal": "3"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-223-2525"
+"ShowingRequirements": array:1 [
0 => "Showing Service"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-09-03T12:47:40Z"
+"StreetName": "Daly"
+"StreetNumber": "100"
+"StreetNumberNumeric": "100"
+"StreetSuffix": "Boulevard"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"UnitNumber": "411"
+"Utilities": array:2 [
0 => "Cable Available"
1 => "Electricity Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_HoldDate": "2025-09-03"
+"KEY_FlipTaxYN": "0"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "405000.00"
+"KEY_ContractPrice": "405000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_EstimatedMaintenance": "563"
+"KEY_LivingAreaSearchSqFt": "750.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_RATIO_ListPrice_By_LivingArea": "540.00000"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "540.00000"
+"KEY_SourceSystemModificationTimestamp": "2025-04-22T13:28:19.903"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY419672930')"
+"provider_name": "One Key"
+"Media": array:37 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:13 [ …13]
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]
]
+"ID": "25415"
}
]
+success: true
+page_size: 12
+page_count: 215
+count: 2579
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
]