array:2 [
"RF Query: /Property?$select=ALL&$top=20&$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')) and ListPrice le 5000000) and ListingKey eq 'KEY422514515'/Property?$select=ALL&$top=20&$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')) and ListPrice le 5000000) and ListingKey eq 'KEY422514515'&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$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')) and ListPrice le 5000000) and ListingKey eq 'KEY422514515'/Property?$select=ALL&$top=20&$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')) and ListPrice le 5000000) and ListingKey eq 'KEY422514515'&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3786
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3784
+post_id: "22161"
+post_author: 1
+"ListingKey": "KEY422514515"
+"ListingId": "930938"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Mixed Use"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-20T22:35:36Z"
+"RFModificationTimestamp": "2025-11-20T22:38:13Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 4400.0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "2846 Sunrise Highway, Hempstead, New York 11710"
+"Coordinates": array:2 [
0 => -73.5221369
1 => 40.6695379
]
+"Latitude": 40.6695379
+"Longitude": -73.5221369
+"YearBuilt": 1949
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Luisa C. Escalona Martinez"
+"ListOfficeName": "Orion Realty Group Florida LLC"
+"ListAgentMlsId": "222824"
+"ListOfficeMlsId": "SUNA01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Prime commercial opportunity on Sunrise Highway in the heart of Bellmore. This 1,500 sq. ft. mixed-use building offers excellent visibility and high traffic counts, ideal for retail, office, or professional use. Featuring a well-maintained structure with flexible layout options, the property provides strong potential for both owner-users and investors. Conveniently located near major thoroughfares, public transportation, and local amenities, this site is perfectly positioned to support business growth and long-term value."
+"AttributionContact": "631-789-3400"
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Commercial"
+"ConstructionMaterials": array:1 [
0 => "Block"
]
+"Cooling": array:1 [
0 => "Electric"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-10-31T21:46:28.715392+00:00"
+"CumulativeDaysOnMarket": 20
+"DaysOnMarket": 44
+"ExpirationDate": "2026-04-29"
+"Heating": array:1 [
0 => "Electric"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-262-2948"
+"ListAgentEmail": "carolinaescalona@orionrealtygroupllc.com"
+"ListAgentKey": "326231708"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115870"
+"ListOfficePhone": "631-789-3400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-10-29"
+"MajorChangeTimestamp": "2025-10-31T21:40:55Z"
+"MajorChangeType": "New Listing"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-10-31"
+"OriginalEntryTimestamp": "2025-10-31T21:40:55Z"
+"OriginalListPrice": 1499000
+"OriginatingSystemModificationTimestamp": "2025-11-20T22:34:15Z"
+"OwnerName": "427 Sunrise Realty LLC"
+"PhotosChangeTimestamp": "2025-10-31T21:41:57Z"
+"PhotosCount": 13
+"PostalCity": "Bellmore"
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "(516) 262-2948"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-10-31T21:40:55Z"
+"StreetName": "Sunrise"
+"StreetNumber": "2846"
+"StreetNumberNumeric": "2846"
+"StreetSuffix": "Highway"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "Crexi"
]
+"TaxAnnualAmount": "16972.32"
+"TaxYear": "2024"
+"Utilities": array:1 [
0 => "See Remarks"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1499000.00"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_ShowingContactPhone2": "(631) 742-2776"
+"KEY_SourceSystemModificationTimestamp": "2025-10-31T16:12:20.960"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "340.68182"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "340.68182"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422514515')"
+"provider_name": "One Key"
+"Media": array:13 [
0 => array:13 [
"Order" => 0
"MediaKey" => "69052d2024afe62cb5d71fad"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/7c19ffdca1fe50522ea51ffabade6b1f.webp"
"MediaSize" => 527017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-7c19ffdca1fe50522ea51ffabade6b1f.webp"
"ImageWidth" => 2048
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1536
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "2048x1536"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.127Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "69052d2024afe62cb5d71fae"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/ad8873472da04af5fc493871e07b9e89.webp"
"MediaSize" => 764178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-ad8873472da04af5fc493871e07b9e89.webp"
"ImageWidth" => 1536
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2048
"ShortDescription" => "Other"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.109Z"
]
2 => array:14 [
"Order" => 2
"MediaKey" => "69052d2024afe62cb5d71faf"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/120a30eb162354410dda3fea154b374e.webp"
"MediaSize" => 380478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-120a30eb162354410dda3fea154b374e.webp"
"ImageWidth" => 1536
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2048
"LongDescription" => "View of road featuring street lighting"
"ShortDescription" => "Community"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.127Z"
]
3 => array:14 [
"Order" => 3
"MediaKey" => "69052d2024afe62cb5d71fb0"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/db1201cf3bf05409bf2b2a9f53dae9af.webp"
"MediaSize" => 268726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-db1201cf3bf05409bf2b2a9f53dae9af.webp"
"ImageWidth" => 1536
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2048
"LongDescription" => "Unfurnished living room with dark wood-style flooring and a drop ceiling"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.126Z"
]
4 => array:14 [
"Order" => 4
"MediaKey" => "69052d2024afe62cb5d71fb1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/0378d85cbb62d153f3962947871431b2.webp"
"MediaSize" => 200881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-0378d85cbb62d153f3962947871431b2.webp"
"ImageWidth" => 1536
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2048
"LongDescription" => "Sitting room with a drop ceiling and dark wood-style floors"
"ShortDescription" => "Sitting Room"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.150Z"
]
5 => array:14 [
"Order" => 5
"MediaKey" => "69052d2024afe62cb5d71fb2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/6eb180dbe0291872a1d89201da74c4b1.webp"
"MediaSize" => 165140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-6eb180dbe0291872a1d89201da74c4b1.webp"
"ImageWidth" => 1536
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2048
"LongDescription" => "Bar area with white cabinets, dark wood-style floors, and light stone countertops"
"ShortDescription" => "Bar"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.132Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "69052d2024afe62cb5d71fb3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/4ff0ff322ea01da7b93306d8956aa04f.webp"
"MediaSize" => 202790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-4ff0ff322ea01da7b93306d8956aa04f.webp"
"ImageWidth" => 1536
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2048
"ShortDescription" => "Other"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.143Z"
]
7 => array:14 [
"Order" => 7
"MediaKey" => "69052d2024afe62cb5d71fb4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/66b6da80dd43c7f1f2f9b6e4da2c7d2d.webp"
"MediaSize" => 187176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-66b6da80dd43c7f1f2f9b6e4da2c7d2d.webp"
"ImageWidth" => 2048
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1536
"LongDescription" => "Unfurnished room featuring dark wood-type flooring and a drop ceiling"
"ShortDescription" => "Other"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "2048x1536"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.114Z"
]
8 => array:14 [
"Order" => 8
"MediaKey" => "69052d2024afe62cb5d71fb5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/8cb281a3e269accd8c559d084b407ebb.webp"
"MediaSize" => 352821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-8cb281a3e269accd8c559d084b407ebb.webp"
"ImageWidth" => 1536
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2048
"LongDescription" => "Unfurnished living room featuring dark wood-style flooring and a drop ceiling"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.093Z"
]
9 => array:14 [
"Order" => 9
"MediaKey" => "69052d2024afe62cb5d71fb6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/d3fed09cf76ac698a46073475887f330.webp"
"MediaSize" => 369515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-d3fed09cf76ac698a46073475887f330.webp"
"ImageWidth" => 1536
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2048
"LongDescription" => "Unfurnished room with a drop ceiling and dark wood-style floors"
"ShortDescription" => "Other"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.124Z"
]
10 => array:14 [
"Order" => 10
"MediaKey" => "69052d2024afe62cb5d71fb7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/dcde7d5ef9ab452e7a5c3835710c4646.webp"
"MediaSize" => 389670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-dcde7d5ef9ab452e7a5c3835710c4646.webp"
"ImageWidth" => 1536
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2048
"LongDescription" => "Spare room with a paneled ceiling and dark wood-type flooring"
"ShortDescription" => "Other"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.134Z"
]
11 => array:14 [
"Order" => 11
"MediaKey" => "69052d2024afe62cb5d71fb8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/002bdd28601132fb54030d05495e95cf.webp"
"MediaSize" => 257219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-002bdd28601132fb54030d05495e95cf.webp"
"ImageWidth" => 2048
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1536
"LongDescription" => "Miscellaneous room featuring a wall mounted air conditioner and a drop ceiling"
"ShortDescription" => "Other"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "2048x1536"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.112Z"
]
12 => array:14 [
"Order" => 12
"MediaKey" => "69052d2024afe62cb5d71fb9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/ad18ea75ec3463d6e36afc170255434e.webp"
"MediaSize" => 165140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY422514515/thumbnail-ad18ea75ec3463d6e36afc170255434e.webp"
"ImageWidth" => 1536
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2048
"LongDescription" => "Bar area with white cabinets, dark wood-style floors, and light stone countertops"
"ShortDescription" => "Bar"
"ResourceRecordKey" => "422514515"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-10-31T21:41:52.118Z"
]
]
+"Member": array:1 [
0 => array:33 [
"MemberFullName" => "Luisa C. Escalona Martinez"
"MemberFirstName" => "Luisa"
"MemberLastName" => "Escalona Martinez"
"MemberEmail" => "carolinaescalona@orionrealtygroupllc.com"
"MemberDirectPhone" => "516-262-2948"
"MemberMlsId" => "222824"
"OriginatingSystemName" => 29
"OfficeMlsId" => "SUNA01"
"MemberKey" => "326231708"
"ModificationTimestamp" => "2025-10-10T20:55:35Z"
"MemberMiddleName" => "C"
"MemberStateLicense" => "10401371637"
"MemberStatus" => "Active"
"OfficeKey" => "326115870"
"MemberAOR" => "LIBOR"
"MemberFax" => "631-532-1584"
"MlgCanUse" => array:1 [
0 => "IDX"
]
"MemberCity" => "West Babylon"
"MemberType" => "REALTOR Salesperson"
"MlgCanView" => true
"MemberCountry" => "US"
"MemberAddress1" => "359 Great East Neck Rd"
"MemberPostalCode" => "11704"
"MemberMobilePhone" => "516-262-2948"
"MemberStateOrProvince" => "NY"
"MemberMlsSecurityClass" => "AWI - Agent With Input"
"MemberNationalAssociationId" => "641668777"
"OriginatingSystemModificationTimestamp" => "2025-10-10T19:09:23.000Z"
"KEY_MainOfficeMlsId" => "SUNA01"
"KEY_LegacyMemberMlsId" => "222824"
"KEY_MemberPhotosCount" => "0"
"KEY_MemberLockboxAccessYN" => "0"
"KEY_MemberAdvertisingLicenseType" => "Real Estate Salesperson"
]
]
+"Office": array:1 [
0 => array:31 [
"OfficeName" => "Orion Realty Group Florida LLC"
"OfficeEmail" => "fernandezluis19@gmail.com"
"OfficePhone" => "631-789-3400"
"OfficeMlsId" => "SUNA01"
"OriginatingSystemName" => 29
"rf_group_id" => 0
"OfficeKey" => "326115870"
"ModificationTimestamp" => "2025-11-05T17:09:26Z"
"IDXOfficeParticipationYN" => true
"MainOfficeKey" => "326115870"
"MainOfficeMlsId" => "SUNA01"
"OfficeAddress1" => "128 Carleton Ave Ste 203"
"OfficeBrokerKey" => "326129475"
"OfficeCity" => "East Islip"
"OfficePostalCode" => "11730"
"OfficeStateOrProvince" => "NY"
"OfficeStatus" => "Active"
"OfficeAOR" => "LIBOR"
"MlgCanUse" => array:1 [
0 => "IDX"
]
"OfficeFax" => "631-532-1584"
"MlgCanView" => true
"SyndicateTo" => array:6 [
0 => "Realtor.com On-Market"
1 => "Realtor.com Off-Market"
2 => "Crexi"
3 => "OneKeyMLS.com"
4 => "Photo Visualizer"
5 => "Data Partnerships"
]
"OfficeManagerKey" => "326129475"
"OfficeBrokerMlsId" => "113661"
"OfficeManagerMlsId" => "113661"
"OfficeCountyOrParish" => "Suffolk County"
"OriginalEntryTimestamp" => "2006-01-27T10:00:00.000Z"
"OfficeNationalAssociationId" => "641600645"
"OriginatingSystemModificationTimestamp" => "2025-11-05T14:45:59.000Z"
"KEY_OfficeLongName" => "East Islip - Orion Realty Group Florida LLC"
"KEY_AttributionType" => "Office Phone"
]
]
+"ID": "22161"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.08 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 'KEY422514515'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5065
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.05 seconds"
]
]