array:1 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=2148&$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 {#5303
+items: array:12 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5294
+post_id: "24409"
+post_author: 1
+"ListingKey": "KEY419068966"
+"ListingId": "834373"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-05-02T17:35:36Z"
+"RFModificationTimestamp": "2025-05-02T17:43:34Z"
+"ListPrice": 757100.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1378.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "2906 Oceanside Road, Hempstead, New York 11572"
+"Coordinates": array:2 [
0 => -73.6341179
1 => 40.640939
]
+"Latitude": 40.640939
+"Longitude": -73.6341179
+"YearBuilt": 1927
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Erik C. Mahler CBR"
+"ListOfficeName": "Mahler Realty"
+"ListAgentMlsId": "85303"
+"ListOfficeMlsId": "MAHL01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Mint condition, three bedrooms, two bath, Dutch colonial located in prime Oceanside location just blocks from major shopping, award-winning Oceanside high school and elementary schools. This home features brand new siding, roof and windows, gorgeous wood floors and the Possibility of a fourth bedroom or den or home office. Oversized yard with a large patio, and two car detached garage. Don't forget about the open concept, updated kitchen with an island and stainless Steele appliances., Additional information: Appearance:Excellent,Green Features:Insulated Doors,Interior Features:Lr/Dr"
+"Appliances": array:6 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Refrigerator"
3 => "Washer"
4 => "Electric Water Heater"
5 => "ENERGY STAR Qualified Appliances"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-223-3111"
+"Basement": array:2 [
0 => "Full"
1 => "Walk-Out Access"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-223-3111"
+"CoListAgentEmail": "Tracy Mahler@hotmail.com"
+"CoListAgentFullName": "Tracy L. Mahler SFR"
+"CoListAgentKey": "326176714"
+"CoListAgentMlsId": "165056"
+"CoListOfficeKey": "326113441"
+"CoListOfficeMlsId": "MAHL01"
+"CoListOfficeName": "Mahler Realty"
+"CoListOfficePhone": "516-223-3111"
+"ConstructionMaterials": array:1 [
0 => "Vinyl Siding"
]
+"Cooling": array:3 [
0 => "Ductless"
1 => "ENERGY STAR Qualified Equipment"
2 => "Zoned"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-12T17:27:51.718747+00:00"
+"CrossStreet": "Pine St"
+"CumulativeDaysOnMarket": 151
+"DaysOnMarket": 50
+"Directions": "Atlantic Ave to Oceanside Road south, 5 houses on west side"
+"ElementarySchool": "Contact Agent"
+"ExpirationDate": "2025-05-01"
+"ExteriorFeatures": array:4 [
0 => "Garden"
1 => "Lighting"
2 => "Mailbox"
3 => "Rain Gutters"
]
+"Fencing": array:2 [
0 => "Fenced"
1 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:2 [
0 => "ENERGY STAR Qualified Equipment"
1 => "See Remarks"
]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:11 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Double Vanity"
3 => "Eat-in Kitchen"
4 => "ENERGY STAR Qualified Door(s)"
5 => "Entrance Foyer"
6 => "Formal Dining"
7 => "Natural Woodwork"
8 => "Open Floorplan"
9 => "Open Kitchen"
10 => "Smart Thermostat"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Three Or More"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "erik@mahlerrealty.com"
+"ListAgentKey": "326245957"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113441"
+"ListOfficePhone": "516-223-3111"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-03-12"
+"LivingAreaSource": "Other"
+"LotFeatures": array:4 [
0 => "Near Public Transit"
1 => "Near School"
2 => "Near Shops"
3 => "Level"
]
+"LotSizeDimensions": "50x115"
+"LotSizeSquareFeet": 5700
+"MajorChangeTimestamp": "2025-05-02T17:33:38Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-05-01"
+"OnMarketDate": "2025-03-12"
+"OriginalEntryTimestamp": "2025-03-12T17:09:27Z"
+"OriginalListPrice": 759000
+"OriginatingSystemModificationTimestamp": "2025-05-02T17:33:38Z"
+"OtherStructures": array:1 [
0 => "Garage(s)"
]
+"OwnerName": "Karl Mae"
+"ParcelNumber": "2089-38-364-00-0292-0"
+"ParkingFeatures": array:5 [
0 => "Detached"
1 => "Driveway"
2 => "On Street"
3 => "Private"
4 => "Open"
]
+"PhotosChangeTimestamp": "2025-03-12T17:10:36Z"
+"PhotosCount": 22
+"PostalCity": "Oceanside"
+"PreviousListPrice": 757200
+"PriceChangeTimestamp": "2025-05-02T17:33:38Z"
+"RoadResponsibility": array:1 [
0 => "Public Maintained Road"
]
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-223-3111"
+"ShowingRequirements": array:2 [
0 => "Appointment Only"
1 => "Call Listing Office"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-05-01T04:11:24Z"
+"StreetName": "Oceanside"
+"StreetNumber": "2906"
+"StreetNumberNumeric": "2906"
+"StreetSuffix": "Road"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "11826"
+"TaxBlock": "364"
+"TaxLot": "292"
+"TaxYear": "2024"
+"Utilities": array:1 [
0 => "Trash Collection Public"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WindowFeatures": array:4 [
0 => "Insulated Windows"
1 => "Screens"
2 => "Double Pane Windows"
3 => "ENERGY STAR Qualified Windows"
]
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.99750"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "1378.00"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalRooms": "Library/Den"
+"KEY_AdditionalFeesYN": "0"
+"KEY_CurrentPrice": "757100.00"
+"KEY_WaterAccessYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ConcessionInPrice": "2.00"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "549.41945"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_Attic": "Full"
+"KEY_ConcessionYN": "1"
+"KEY_NumberOfHeatingZones": "6"
+"KEY_TaxSection": "38"
+"KEY_RATIO_ListPrice_By_LivingArea": "549.41945"
+"KEY_SourceSystemModificationTimestamp": "2025-03-12T08:26:45.173"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419068966')"
+"provider_name": "One Key"
+"Media": array:22 [
0 => array:14 [
"Order" => 0
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/73de1caa50b65841d0f852420179ee3a.webp"
"MediaSize" => 139517
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.411Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-73de1caa50b65841d0f852420179ee3a.webp"
"ShortDescription" => "Front of Structure"
"MediaKey" => "67d1bfd7837a7e44835360d3"
"LongDescription" => "View of front of home featuring fence, driveway, a shingled roof, an outdoor structure, and a detached garage"
"ImageHeight" => 681
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x681"
]
1 => array:14 [
"Order" => 1
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/282d94a1a429f47f9ab7ba17a5b2ad26.webp"
"MediaSize" => 139103
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-282d94a1a429f47f9ab7ba17a5b2ad26.webp"
"ShortDescription" => "Front of Structure"
"MediaKey" => "67d1bfd7837a7e44835360d4"
"LongDescription" => "Bungalow-style house with a front yard and fence"
"ImageHeight" => 681
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x681"
]
2 => array:14 [
"Order" => 2
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/2d4e6573d06be05055fd7dcd9d71c4a1.webp"
"MediaSize" => 133340
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.335Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-2d4e6573d06be05055fd7dcd9d71c4a1.webp"
"ShortDescription" => "Side of Structure"
"MediaKey" => "67d1bfd7837a7e44835360d5"
"LongDescription" => "View of home's exterior featuring an outbuilding, fence, and a garage"
"ImageHeight" => 681
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x681"
]
3 => array:14 [
"Order" => 3
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/7647dba6118a250fef7e3ed823034811.webp"
"MediaSize" => 134758
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.292Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-7647dba6118a250fef7e3ed823034811.webp"
"ShortDescription" => "Back of Structure"
"MediaKey" => "67d1bfd7837a7e44835360d6"
"LongDescription" => "Back of house with french doors, a lawn, a chimney, and fence"
"ImageHeight" => 681
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x681"
]
4 => array:14 [
"Order" => 4
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/edb6f54a6f284bb0b48ed2e0eb9ac8f0.webp"
"MediaSize" => 62517
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.331Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-edb6f54a6f284bb0b48ed2e0eb9ac8f0.webp"
"ShortDescription" => "Kitchen"
"MediaKey" => "67d1bfd7837a7e44835360d7"
"LongDescription" => "Kitchen with dark wood finished floors, appliances with stainless steel finishes, light countertops, and a sink"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
5 => array:14 [
"Order" => 5
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/061aa1d43dce7d1411d6c024e2954b94.webp"
"MediaSize" => 61920
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.277Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-061aa1d43dce7d1411d6c024e2954b94.webp"
"ShortDescription" => "Living Room"
"MediaKey" => "67d1bfd7837a7e44835360d8"
"LongDescription" => "Living room featuring french doors, baseboards, dark wood finished floors, and a wall unit AC"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
6 => array:14 [
"Order" => 6
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/772c14c643a4f7228e63da6712b8b4a2.webp"
"MediaSize" => 66782
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-772c14c643a4f7228e63da6712b8b4a2.webp"
"ShortDescription" => "Living Room"
"MediaKey" => "67d1bfd7837a7e44835360d9"
"LongDescription" => "Living area with baseboards, an AC wall unit, hardwood / wood-style floors, and stairs"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
7 => array:14 [
"Order" => 7
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/f9aee3ba9dd98823a20176296504b9e6.webp"
"MediaSize" => 63156
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-f9aee3ba9dd98823a20176296504b9e6.webp"
"ShortDescription" => "Living Room"
"MediaKey" => "67d1bfd7837a7e44835360da"
"LongDescription" => "Living area featuring stairs, recessed lighting, wood finished floors, and baseboards"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
8 => array:14 [
"Order" => 8
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/863a6543b73d8c50a98513dd198e9686.webp"
"MediaSize" => 58290
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.304Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-863a6543b73d8c50a98513dd198e9686.webp"
"ShortDescription" => "Dining Area"
"MediaKey" => "67d1bfd7837a7e44835360db"
"LongDescription" => "Dining area featuring dark wood-type flooring, a notable chandelier, and baseboards"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
9 => array:14 [
"Order" => 9
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/5b2e8e004afc6cba791efbeb41938517.webp"
"MediaSize" => 52218
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.275Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-5b2e8e004afc6cba791efbeb41938517.webp"
"ShortDescription" => "Kitchen"
"MediaKey" => "67d1bfd7837a7e44835360dc"
"LongDescription" => "Kitchen featuring decorative backsplash, white cabinets, appliances with stainless steel finishes, and a sink"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
10 => array:14 [
"Order" => 10
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/2a4ff3a244b4a734a1dbb6364b0cb5ed.webp"
"MediaSize" => 47699
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.284Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-2a4ff3a244b4a734a1dbb6364b0cb5ed.webp"
"ShortDescription" => "Entry"
"MediaKey" => "67d1bfd7837a7e44835360dd"
"LongDescription" => "Doorway to outside featuring baseboards"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
11 => array:14 [
"Order" => 11
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/9a92d1d1d45d3f9347bdf081a11cd113.webp"
"MediaSize" => 80165
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.265Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-9a92d1d1d45d3f9347bdf081a11cd113.webp"
"ShortDescription" => "Office"
"MediaKey" => "67d1bfd7837a7e44835360de"
"LongDescription" => "Office area featuring baseboards, a wall unit AC, and wood finished floors"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
12 => array:14 [
"Order" => 12
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/e0da97c52dd77d8e3844a8e75d9b3279.webp"
"MediaSize" => 55819
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.269Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-e0da97c52dd77d8e3844a8e75d9b3279.webp"
"ShortDescription" => "Living Room"
"MediaKey" => "67d1bfd7837a7e44835360df"
"LongDescription" => "Living area featuring dark wood finished floors and baseboards"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
13 => array:14 [
"Order" => 13
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/4bf5d39661a33bbe597b2b8371b6ff79.webp"
"MediaSize" => 49216
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.294Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-4bf5d39661a33bbe597b2b8371b6ff79.webp"
"ShortDescription" => "Other"
"MediaKey" => "67d1bfd7837a7e44835360e0"
"LongDescription" => "View of hallway"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
14 => array:14 [
"Order" => 14
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/fae69e1ee4a5b5ec44a069c7519be39e.webp"
"MediaSize" => 54204
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.344Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-fae69e1ee4a5b5ec44a069c7519be39e.webp"
"ShortDescription" => "Bedroom"
"MediaKey" => "67d1bfd7837a7e44835360e1"
"LongDescription" => "Bedroom with a ceiling fan, an AC wall unit, baseboards, and dark wood-style flooring"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
15 => array:14 [
"Order" => 15
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/5bb7f04f6a6dbcb8b8ee7cadd0c4e46e.webp"
"MediaSize" => 65435
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.286Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-5bb7f04f6a6dbcb8b8ee7cadd0c4e46e.webp"
"ShortDescription" => "Bedroom"
"MediaKey" => "67d1bfd7837a7e44835360e2"
"LongDescription" => "Bedroom with ceiling fan, a wall mounted air conditioner, baseboards, and dark wood-style flooring"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
16 => array:14 [
"Order" => 16
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/000080b4b274df09ecfdf50e1397d135.webp"
"MediaSize" => 34681
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.260Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-000080b4b274df09ecfdf50e1397d135.webp"
"ShortDescription" => "Bathroom"
"MediaKey" => "67d1bfd7837a7e44835360e3"
"LongDescription" => "Bathroom with toilet, a stall shower, vanity, and tile walls"
"ImageHeight" => 640
"ImageWidth" => 480
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "480x640"
]
17 => array:14 [
"Order" => 17
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/75fec4a641bda9165b503fbb5c21d798.webp"
"MediaSize" => 55598
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.243Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-75fec4a641bda9165b503fbb5c21d798.webp"
"ShortDescription" => "Dining Area"
"MediaKey" => "67d1bfd7837a7e44835360e4"
"LongDescription" => "Dining room featuring dark wood-style floors, baseboards, and a chandelier"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
18 => array:14 [
"Order" => 18
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/069105cc5fd40a8baec9fc28e40af5f2.webp"
"MediaSize" => 42243
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.284Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-069105cc5fd40a8baec9fc28e40af5f2.webp"
"ShortDescription" => "Other"
"MediaKey" => "67d1bfd7837a7e44835360e5"
"LongDescription" => "Empty room with ceiling fan, baseboards, and dark wood-style floors"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
19 => array:14 [
"Order" => 19
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/443b49295f4b82de11370ab64d26aa59.webp"
"MediaSize" => 50237
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.269Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-443b49295f4b82de11370ab64d26aa59.webp"
"ShortDescription" => "Other"
"MediaKey" => "67d1bfd7837a7e44835360e6"
"LongDescription" => "Hall featuring attic access, baseboards, and dark wood-type flooring"
"ImageHeight" => 480
"ImageWidth" => 640
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "640x480"
]
20 => array:14 [
"Order" => 20
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/aac736066b3b1b86e976d5101fd95964.webp"
"MediaSize" => 139517
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.333Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-aac736066b3b1b86e976d5101fd95964.webp"
"ShortDescription" => "Front of Structure"
"MediaKey" => "67d1bfd7837a7e44835360e7"
"LongDescription" => "View of front of home featuring driveway, fence, roof with shingles, an outdoor structure, and a garage"
"ImageHeight" => 681
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x681"
]
21 => array:14 [
"Order" => 21
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/e33dc5bc0934d15a97e8bd80000d3c9d.webp"
"MediaSize" => 139517
"ResourceRecordKey" => "419068966"
"MediaModificationTimestamp" => "2025-03-12T17:09:43.409Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419068966/thumbnail-e33dc5bc0934d15a97e8bd80000d3c9d.webp"
"ShortDescription" => "Front of Structure"
"MediaKey" => "67d1bfd7837a7e44835360e8"
"LongDescription" => "View of front facade with a shingled roof, fence, a garage, an outbuilding, and driveway"
"ImageHeight" => 681
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x681"
]
]
+"ID": "24409"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5296
+post_id: "24218"
+post_author: 1
+"ListingKey": "KEY419067435"
+"ListingId": "834350"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Mixed Use"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-09-28T07:02:39Z"
+"RFModificationTimestamp": "2025-09-28T07:06:22Z"
+"ListPrice": 4900000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 31101.0
+"LivingArea": 0
+"BuildingAreaTotal": 31101.0
+"City": "Hempstead"
+"PostalCode": "11563"
+"UnparsedAddress": "29 & 21-23 Broadway, Hempstead, New York 11563"
+"Coordinates": array:2 [
0 => -73.67353482547
1 => 40.6554411
]
+"Latitude": 40.6554411
+"Longitude": -73.67353482547
+"YearBuilt": 1920
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Debra S. Harari"
+"ListOfficeName": "Contact Realty II Corp"
+"ListAgentMlsId": "152937"
+"ListOfficeMlsId": "HRC01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Attention All Investors, & Developers!!!, and End-Users! These 2 Buildings = 28,164 SQFT Office /Multiuse or Multi-Purpose Building on a Great lot in Lynbrook is now available for sale! The building offers exceptional signage, Total SQFT (31,101) Prime exposure, and strong zoning, with parking spaces, high ceilings, a skylight, and central air conditioning. Located in the heart of Lynbrook, just 2 blocks from the Lynbrook LIRR station, the property is ideally situated between Broadway & Merrick Road. Nearby neighbors include Starbucks, Audi, Acura, Volkswagen, Northwell Health, Bethpage Federal Credit Union, Dunkin', McDonald's, Enterprise Rent-A-Car, Stand-Up MRI, Karako Suits, Cold Stone Creamery, Regal Cinemas, White Castle, IHOP, KFC, and many more. With a daily traffic count of over 20,000 vehicles, this is a prime location for your next investment!\n
Beautiful Invesment Opportunity, Great Traffic, Can Build Residential Homes up to 5-6 Stories and Tripple the NOI. \n
Building #1 Gross Income $267,567 and Expenses is $40,135 Taxes $47,248 NOI = $180,184.00 its a LAW FIRM and next to it is Building #2 Collectibles Antique store Gross Income is $89,373 and Expenses is $13,406 and Taxes is $16,007 NOI = $59,960. Great Potential here as Owner is currently renting at Extremely Cheap rates now at $18.00 SQft and $8.00 SQft. with short term LEASES. Parking Lot for collectibles Included, Great Opportunity to Reconstruct for Mixed Use Developments and Residential uses Permitted above a certain floor level as its Commercial zoned for Any Multiple Use or Multi-Purpose.
"""
+"AttributionContact": "718-897-8888"
+"Basement": array:1 [
0 => "Finished"
]
+"BasementYN": true
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Commercial,Convenience Store,Parking,Professional/Office"
+"CapRate": 5
+"ConstructionMaterials": array:1 [
0 => "Frame"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-13T04:53:35.094865+00:00"
+"CumulativeDaysOnMarket": 199
+"DaysOnMarket": 199
+"ExpirationDate": "2025-09-28"
+"Fencing": array:1 [
0 => "Chain Link"
]
+"FoundationDetails": array:1 [
0 => "Brick/Mortar"
]
+"GrossIncome": 353940
+"Heating": array:1 [
0 => "Forced Air"
]
+"RFTransactionType": "For Sale"
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "718-897-8888"
+"ListAgentEmail": "temani@aol.com"
+"ListAgentKey": "326165546"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112158"
+"ListOfficePhone": "718-897-8888"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-09"
+"ListingTerms": "Other"
+"LotFeatures": array:1 [
0 => "Paved"
]
+"LotSizeSquareFeet": 31101
+"MajorChangeTimestamp": "2025-09-28T04:10:58Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"NetOperatingIncome": 240144
+"NumberOfBuildings": 2
+"NumberOfUnitsTotal": "2"
+"OffMarketDate": "2025-09-28"
+"OnMarketDate": "2025-03-13"
+"OperatingExpense": "53541"
+"OriginalEntryTimestamp": "2025-03-13T04:47:52Z"
+"OriginalListPrice": 5700000
+"OriginatingSystemModificationTimestamp": "2025-09-28T04:10:58Z"
+"OwnerName": "Jo-be"
+"ParkingFeatures": array:1 [
0 => "Driveway"
]
+"ParkingTotal": "3000"
+"PhotosChangeTimestamp": "2025-09-28T04:11:53Z"
+"PhotosCount": 9
+"PostalCity": "Lynbrook"
+"PreviousListPrice": 5700000
+"PriceChangeTimestamp": "2025-06-30T16:57:41Z"
+"PropertyCondition": array:1 [
0 => "Updated/Remodeled"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "6462508787"
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-09-28T04:10:58Z"
+"Stories": "2"
+"StoriesTotal": "2"
+"StreetName": "Broadway"
+"StreetNumber": "29 & 21-23"
+"StreetNumberNumeric": "29"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "63255"
+"TaxYear": "2025"
+"Utilities": array:1 [
0 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Other"
]
+"Zoning": "C,X, Commercial"
+"KEY_ElevatorYN": "0"
+"KEY_UsableArea": "28164.00"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "4900000.00"
+"KEY_BuildingClass": "C"
+"KEY_PreviousStatus": "Active"
+"KEY_IncomeExpenseInfo": "Actual"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_SprinklerSystemYN": "1"
+"KEY_TotalExpensesYear": "116796"
+"KEY_AnnualRentalIncome": "375726"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_InvestmentPropertyYN": "1"
+"KEY_ShowingContactPhone2": "6463428356"
+"KEY_SourceSystemModificationTimestamp": "2025-03-12T00:28:39.163"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "157.55120"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.85965"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "157.55120"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419067435')"
+"provider_name": "One Key"
+"Media": array:9 [
0 => array:14 [
"Order" => 0
"MediaKey" => "67d263aad9f7b8288c5bb223"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY419067435/64774db5f85910c1893136bd104960a2.webp"
"MediaSize" => 308278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY419067435/thumbnail-64774db5f85910c1893136bd104960a2.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 982
"LongDescription" => "Total Building SQFT 26,372 total Lot is 31,101 SQFT"
"ShortDescription" => "Office"
"ResourceRecordKey" => "419067435"
"ImageSizeDescription" => "1600x982"
…1
]
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]
]
+"ID": "24218"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5293
+post_id: "23889"
+post_author: 1
+"ListingKey": "KEY419015569"
+"ListingId": "832536"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-04-11T09:28:42Z"
+"RFModificationTimestamp": "2025-04-11T09:43:28Z"
+"ListPrice": 440000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1287.0
+"BuildingAreaTotal": 1287.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "1415 Rhode Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [
0 => -73.56532835
1 => 40.68396555
]
+"Latitude": 40.68396555
+"Longitude": -73.56532835
+"YearBuilt": 1959
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "David A. Constantino"
+"ListOfficeName": "David R Maltz And Co Inc"
+"ListAgentMlsId": "156364"
+"ListOfficeMlsId": "DAML01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Online Auction: 2 Family Merrick Home. Bidding opens 4/7 at 1:00 pm & Ends 4/9 at 1:00 pm (appx). The listing price of $440,000 represents the Opening Bid Amount Only. Please conduct due diligence as the property sells "as-is" and the information provided is not guaranteed to be accurate. Bidder must send in signed Terms and Conditions of Sale, signed Online Bidding Form, and a $44,000 deposit to be approved for bidding."
+"Appliances": array:4 [
0 => "Convection Oven"
1 => "Cooktop"
2 => "Dryer"
3 => "Electric Cooktop"
]
+"ArchitecturalStyle": array:1 [
0 => "Cape Cod"
]
+"AttributionContact": "516-349-7022"
+"Basement": array:3 [
0 => "Bilco Door(s)"
1 => "Full"
2 => "Partially Finished"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"Cooling": array:1 [
0 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-10T18:21:20.758408+00:00"
+"CrossStreet": "William St"
+"CumulativeDaysOnMarket": 32
+"DaysOnMarket": 32
+"Directions": """
Meadowbrook Road, to William to Rhode.\n
Google Maps
"""
+"ElementarySchool": "Old Mill Road School"
+"ExpirationDate": "2025-04-11"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [
0 => "Baseboard"
1 => "Steam"
]
+"HighSchool": "Contact Agent"
+"HighSchoolDistrict": "North Merrick"
+"InteriorFeatures": array:1 [
0 => "Eat-in Kitchen"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-349-7022"
+"ListAgentEmail": "dc@maltzauctions.com"
+"ListAgentKey": "326168751"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110669"
+"ListOfficePhone": "516-349-7022"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-07"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1578
+"LotSizeSquareFeet": 6875
+"MajorChangeTimestamp": "2025-04-11T04:10:48Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Contact Agent"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-04-11"
+"OnMarketDate": "2025-03-10"
+"OriginalEntryTimestamp": "2025-03-10T18:04:19Z"
+"OriginalListPrice": 440000
+"OriginatingSystemModificationTimestamp": "2025-04-11T09:05:02Z"
+"OwnerName": "Donovan"
+"ParcelNumber": "2089-55-007-00-0631-0"
+"PhotosChangeTimestamp": "2025-03-10T18:05:37Z"
+"PhotosCount": 9
+"PostalCity": "Merrick"
+"PostalCodePlus4": "2032"
+"RoomsTotal": "7"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-349-7022"
+"ShowingRequirements": array:1 [
0 => "Restricted Hours"
]
+"SpecialListingConditions": array:1 [
0 => "Auction"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-04-11T04:10:48Z"
+"StreetName": "Rhode"
+"StreetNumber": "1415"
+"StreetNumberNumeric": "1415"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "6754.03"
+"TaxYear": "2025"
+"Utilities": array:2 [
0 => "Natural Gas Connected"
1 => "See Remarks"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "1287.00"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "0"
+"KEY_CurrentPrice": "440000.00"
+"KEY_NumberOfKitchens": "2"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "341.88034"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "341.88034"
+"KEY_Attic": "None"
+"KEY_OpenHouseCount": "2"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "2788339.6705"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "341.88034"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "341.88034"
+"KEY_SourceSystemModificationTimestamp": "2025-03-07T14:42:01.190"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419015569')"
+"provider_name": "One Key"
+"Media": array:9 [
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]
]
+"ID": "23889"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5297
+post_id: "24442"
+post_author: 1
+"ListingKey": "KEY419005381"
+"ListingId": "832220"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Duplex"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-05-01T07:07:39Z"
+"RFModificationTimestamp": "2025-05-01T07:13:25Z"
+"ListPrice": 4500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2000.0
+"BuildingAreaTotal": 6500.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "41 Austin Street, Hempstead, New York 11580"
+"Coordinates": array:2 [
0 => -73.702954859618
1 => 40.67108195
]
+"Latitude": 40.67108195
+"Longitude": -73.702954859618
+"YearBuilt": 1940
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Bejolene Meus"
+"ListOfficeName": "HomeSmart CrossIsland"
+"ListAgentMlsId": "99580"
+"ListOfficeMlsId": "CRXI01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
House in Excellent condition, upscale neighborhood, wood floors through out,\n
Enjoy entire 3 level house and nice big size back yard.
"""
+"Appliances": array:6 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Gas Oven"
3 => "Refrigerator"
4 => "Stainless Steel Appliance(s)"
5 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Cape Cod"
]
+"AttributionContact": "718-341-9800"
+"AvailabilityDate": "2025-03-06"
+"Basement": array:4 [
0 => "Full"
1 => "Storage Space"
2 => "Unfinished"
3 => "Walk-Out Access"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Aluminum Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-07T01:42:48.709180+00:00"
+"CumulativeDaysOnMarket": 56
+"DaysOnMarket": 56
+"ElementarySchool": "James A Dever School"
+"ExpirationDate": "2025-05-01"
+"Heating": array:1 [
0 => "Oil"
]
+"HighSchool": "Contact Agent"
+"HighSchoolDistrict": "Valley Stream - 13"
+"InteriorFeatures": array:2 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In Basement"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "bejolene@aol.com"
+"ListAgentKey": "326270854"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110563"
+"ListOfficePhone": "718-341-9800"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-02-28"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2025-05-01T04:11:29Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Contact Agent"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-05-01"
+"OnMarketDate": "2025-03-06"
+"OriginalEntryTimestamp": "2025-03-07T01:34:01Z"
+"OriginalListPrice": 4500
+"OriginatingSystemModificationTimestamp": "2025-05-01T04:11:29Z"
+"OwnerName": "Arije"
+"ParkingTotal": "2"
+"PetsAllowed": array:1 [
0 => "No"
]
+"PhotosChangeTimestamp": "2025-03-07T02:01:37Z"
+"PhotosCount": 1
+"PostalCity": "Valley Stream"
+"PriceChangeTimestamp": "2025-03-07T01:34:01Z"
+"RoomsTotal": "7"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "9174189728"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-05-01T04:11:29Z"
+"StreetName": "Austin"
+"StreetNumber": "41"
+"StreetNumberNumeric": "41"
+"StreetSuffix": "Street"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"Utilities": array:2 [
0 => "Cable Available"
1 => "Natural Gas Available"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_LivingAreaSearchSqFt": "2000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_CurrentPrice": "4500.00"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "2.25000"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "0.69231"
+"KEY_Attic": "Crawl"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "0.69231"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_RentSpreeYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "2.25000"
+"KEY_SourceSystemModificationTimestamp": "2025-03-06T20:34:01.907"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419005381')"
+"provider_name": "One Key"
+"Media": array:1 [
0 => array:14 [ …14]
]
+"ID": "24442"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5295
+post_id: "23894"
+post_author: 1
+"ListingKey": "KEY419001569"
+"ListingId": "832095"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-04-01T07:15:44Z"
+"RFModificationTimestamp": "2025-04-01T07:20:30Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2750.0
+"BuildingAreaTotal": 3800.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "503 Nassau Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [
0 => -73.5841524
1 => 40.630831
]
+"Latitude": 40.630831
+"Longitude": -73.5841524
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mohammed O. Sheikh"
+"ListOfficeName": "Blackstone Realty"
+"ListAgentMlsId": "142696"
+"ListOfficeMlsId": "RCHB01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Experience The Epitome Of Coastal Living In This Sun Drenched New Construction FEMA-Compliant 5 Bedroom 3 Bath Home On The Water With New Bulkheading To Enjoy Spectacular Views And Year Round Sunsets. \n
\n
Welcome To Your Dream Home – A Stunning, Brand-New FEMA-Compliant Single-Family Residence Designed To Combine Sophistication, Functionality, And Modern Living. Featuring 5 Spacious Bedrooms And 3 Full Bathrooms, This Meticulously Crafted Gem Boasts An Open-Concept Floor Plan That Seamlessly Integrates The Living, Dining, And Kitchen Areas, Exuding Elegance And Charm At Every Turn. Built From The Ground Up By A Masterful And Renowned Developer, No Detail Was Spared In Delivering This Luxury Home – A True Masterpiece Loaded With All The Bells And Whistles. The Airy Living Space Is Filled With Abundant Natural Light, Accentuating The Home’s Thoughtfully Designed Elements, Including Designer Tiles, Custom Lighting Fixtures, Crown Moldings, And Picture Frame Wainscoting. Gleaming Hardwood Floors Add Warmth And Character, While Modern Energy-Efficient Features, Such As Central Air Conditioning, Generously Insulated with Spray Foam, Insulated Panels & Batt Insulation, And The Highly Acclaimed Navien Hot Water System To Ensure Both Comfort And Cost-Efficiency with Hot Water Instantaneously At Your Finger Tips At All Times. Perfectly Situated In The Sought-After South Shore Area Of Freeport, This Home Offers An Unparalleled Lifestyle In One Of The Region’s Most Desirable Locations. Residents Will Enjoy Easy Access To The Vibrant Nautical Mile, Filled With Waterfront Dining, Boutique Shops, And Cultural Attractions. Convenience Is Key, With Proximity To Major Highways, Parkways, And Thoroughfares, As Well As Public Transit Options Including The LIRR And Nice Bus, Making Commuting A Breeze. Whether You're Entertaining Guests Or Simply Relaxing In Your Bright And Inviting Living Space, This Home Has Been Built With The Ultimate Blend Of Luxury And Practicality In Mind. Don’t Miss Your Opportunity To Own This One-Of-A-Kind Masterpiece In The Heart Of Freeport!\n
\n
Add'l Features: New 58' Foot New Bulkhead, Built FEMA-Compliant (no flood insurance required), Azek Decking & Stairs(Back), Premium Vinyl Fencing, Spray Foam Insulation, Gas Cooking, Two Separate Laundry Setups/Locations, 200 AMP Electric Service/Main, LED Recessed Lighting, 5" Oak Flooring In Bedrooms, Marble Flooring In Common Areas, Designer Bathroom Fixtures, Premium Benjamin Moore Paints, And Extensive Trim & Millwork Throughout.
"""
+"Appliances": array:17 [
0 => "Convection Oven"
1 => "Cooktop"
2 => "Dishwasher"
3 => "Dryer"
4 => "ENERGY STAR Qualified Appliances"
5 => "Exhaust Fan"
6 => "Freezer"
7 => "Gas Cooktop"
8 => "Gas Oven"
9 => "Gas Range"
10 => "Microwave"
11 => "Range"
12 => "Refrigerator"
13 => "Stainless Steel Appliance(s)"
14 => "Tankless Water Heater"
15 => "Washer"
16 => "Indirect Water Heater"
]
+"ArchitecturalStyle": array:2 [
0 => "Colonial"
1 => "Contemporary"
]
+"AttributionContact": "516-802-3939"
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-615-5978"
+"CoListAgentEmail": "samkhodaparast@yahoo.com"
+"CoListAgentFullName": "Amirsaman Khodaparast"
+"CoListAgentKey": "326233203"
+"CoListAgentMlsId": "224388"
+"CoListOfficeKey": "326114911"
+"CoListOfficeMlsId": "RCHB01"
+"CoListOfficeName": "Blackstone Realty"
+"CoListOfficePhone": "516-802-3939"
+"ConstructionMaterials": array:8 [
0 => "Advanced Framing Technique"
1 => "Blown-In Insulation"
2 => "Energy Star"
3 => "Fiberglass Insulation"
4 => "Foam Insulation"
5 => "Shake Siding"
6 => "Stone"
7 => "Vinyl Siding"
]
+"Cooling": array:2 [
0 => "Central Air"
1 => "ENERGY STAR Qualified Equipment"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-06T21:03:54.563897+00:00"
+"CumulativeDaysOnMarket": 56
+"DaysOnMarket": 25
+"Directions": "GPS"
+"ElementarySchool": "Leo F Giblyn School"
+"ExpirationDate": "2025-04-01"
+"Fencing": array:2 [
0 => "Fenced"
1 => "Full"
]
+"Flooring": array:2 [
0 => "Ceramic Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:2 [
0 => "Concrete Perimeter"
1 => "Raised"
]
+"FrontageLength": "58"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:3 [
0 => "ENERGY STAR Qualified Equipment"
1 => "Forced Air"
2 => "Natural Gas"
]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:24 [
0 => "Bidet"
1 => "Breakfast Bar"
2 => "Built-in Features"
3 => "Cathedral Ceiling(s)"
4 => "Chefs Kitchen"
5 => "Crown Molding"
6 => "Double Vanity"
7 => "Dry Bar"
8 => "Eat-in Kitchen"
9 => "ENERGY STAR Qualified Door(s)"
10 => "Entrance Foyer"
11 => "Formal Dining"
12 => "High Ceilings"
13 => "His and Hers Closets"
14 => "Kitchen Island"
15 => "Marble Counters"
16 => "Open Floorplan"
17 => "Pantry"
18 => "Quartz/Quartzite Counters"
19 => "Recessed Lighting"
20 => "Smart Thermostat"
21 => "Storage"
22 => "Walk-In Closet(s)"
23 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [
0 => "In Kitchen"
1 => "Laundry Room"
2 => "Multiple Locations"
]
+"Levels": array:1 [
0 => "Three Or More"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-300-2878"
+"ListAgentEmail": "AMBSPREO@GMAIL.COM"
+"ListAgentKey": "326155961"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114911"
+"ListOfficePhone": "516-802-3939"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-03-06"
+"LivingAreaSource": "Plans"
+"LotSizeAcres": 0.1178
+"LotSizeSquareFeet": 5130
+"MajorChangeTimestamp": "2025-04-01T04:10:27Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-04-01"
+"OnMarketDate": "2025-03-07"
+"OriginalEntryTimestamp": "2025-03-06T20:46:42Z"
+"OriginalListPrice": 1148888
+"OriginatingSystemModificationTimestamp": "2025-04-01T04:10:27Z"
+"OwnerName": "DIAMOND DEVELOPMENT PROPERTIES"
+"ParcelNumber": "2009-62-183-00-0374-0"
+"ParkingFeatures": array:4 [
0 => "Driveway"
1 => "On Street"
2 => "Private"
3 => "Open"
]
+"PatioAndPorchFeatures": array:1 [
0 => "Deck"
]
+"PhotosChangeTimestamp": "2025-03-06T20:52:37Z"
+"PhotosCount": 23
+"PostalCity": "Freeport"
+"PostalCodePlus4": "6320"
+"PreviousListPrice": 1148888
+"PriceChangeTimestamp": "2025-03-19T20:00:41Z"
+"PropertyCondition": array:1 [
0 => "New Construction"
]
+"RoomsTotal": "11"
+"SecurityFeatures": array:2 [
0 => "Fire Sprinkler System"
1 => "Security System"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-300-2878"
+"ShowingRequirements": array:2 [
0 => "Appointment Only"
1 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-04-01T04:10:27Z"
+"StreetName": "Nassau"
+"StreetNumber": "503"
+"StreetNumberNumeric": "503"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "9530.44"
+"TaxAssessedValue": 460
+"TaxYear": "2024"
+"Utilities": array:5 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Sewer Connected"
3 => "Trash Collection Public"
4 => "Water Connected"
]
+"View": "Open,Panoramic"
+"WaterSource": array:1 [
0 => "Public"
]
+"WaterfrontFeatures": array:4 [
0 => "Canal Access"
1 => "Ocean Access"
2 => "Water Access"
3 => "Bulkhead"
]
+"WaterfrontYN": true
+"WindowFeatures": array:2 [
0 => "Double Pane Windows"
1 => "ENERGY STAR Qualified Windows"
]
+"KEY_OpenHousePublicCount": "0"
+"KEY_Village": "Freeport"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.95658"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "2750.00"
+"KEY_PreviousStatus": "Active"
+"KEY_CurrentPrice": "1099000.00"
+"KEY_WaterAccessYN": "1"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "399.63636"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "289.21053"
+"KEY_Attic": "None"
+"KEY_OpenHouseCount": "2"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "9329371.8166"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "289.21053"
+"KEY_ConcessionYN": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "399.63636"
+"KEY_SourceSystemModificationTimestamp": "2025-03-06T15:41:12.417"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419001569')"
+"provider_name": "One Key"
+"Media": array:23 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:14 [ …14]
5 => array:14 [ …14]
6 => array:13 [ …13]
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:13 [ …13]
22 => array:14 [ …14]
]
+"ID": "23894"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5292
+post_id: "24437"
+post_author: 1
+"ListingKey": "KEY419000158"
+"ListingId": "832044"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2025-09-03T07:02:38Z"
+"RFModificationTimestamp": "2025-09-03T07:03:13Z"
+"ListPrice": 299000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1023.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "1197 E Broadway Unit K14, Hempstead, New York 11557"
+"Coordinates": array:2 [
0 => -73.701611
1 => 40.6346957
]
+"Latitude": 40.6346957
+"Longitude": -73.701611
+"YearBuilt": 1965
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Gil R. Shemtov"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "172225"
+"ListOfficeMlsId": "DERE58"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Experience modern living in this totally renovated first-floor 2-bedroom, 1-bathroom apartment, featuring high-end finishes and an expansive oversized terrace—perfect for outdoor relaxation and entertaining. Inside, enjoy the warmth of radiant heated floors in your new kitchen and bathroom, custom closets throughout with hardwood doors adding a touch of luxury to your daily routine. The chef’s kitchen boasts solid wood cabinetry, granite countertops, and stainless steel appliances, creating both beauty and functionality. Additional highlights include in-unit laundry and central air, ensuring comfort and convenience year-round."
+"Appliances": array:3 [
0 => "Dishwasher"
1 => "Gas Cooktop"
2 => "Gas Oven"
]
+"ArchitecturalStyle": array:1 [
0 => "Garden"
]
+"AttributionContact": "516-432-3400"
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-06T20:05:24.010517+00:00"
+"CumulativeDaysOnMarket": 180
+"DaysOnMarket": 180
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"ExpirationDate": "2025-10-05"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:2 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-835-3333"
+"ListAgentEmail": "Gil.Shemtov@elliman.com"
+"ListAgentKey": "326183315"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110783"
+"ListOfficePhone": "516-432-3400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-06"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2025-09-02T15:36:18Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlsStatus": "Hold"
+"OffMarketDate": "2025-09-02"
+"OnMarketDate": "2025-03-06"
+"OriginalEntryTimestamp": "2025-03-06T19:37:52Z"
+"OriginalListPrice": 329000
+"OriginatingSystemModificationTimestamp": "2025-09-02T15:36:18Z"
+"OwnerName": "Naby"
+"ParkingFeatures": array:1 [
0 => "Waitlist"
]
+"PetsAllowed": array:1 [
0 => "No"
]
+"PhotosChangeTimestamp": "2025-03-06T19:39:41Z"
+"PhotosCount": 18
+"PostalCity": "Hewlett"
+"PreviousListPrice": 310000
+"PriceChangeTimestamp": "2025-06-20T21:43:57Z"
+"PropertyAttachedYN": true
+"RoomsTotal": "5"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [
0 => "24 Hour Notice"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-09-02T15:36:18Z"
+"StreetDirPrefix": "E"
+"StreetName": "Broadway"
+"StreetNumber": "1197"
+"StreetNumberNumeric": "1197"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"UnitNumber": "K14"
+"Utilities": array:2 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_HoldDate": "2025-09-02"
+"KEY_ParkingFee": "50"
+"KEY_CurrentPrice": "299000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_EstimatedMaintenance": "2160"
+"KEY_LivingAreaSearchSqFt": "1023.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_RATIO_ListPrice_By_LivingArea": "292.27761"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "292.27761"
+"KEY_SourceSystemModificationTimestamp": "2025-03-06T14:37:00.553"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.90881"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419000158')"
+"provider_name": "One Key"
+"Media": array:18 [
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:13 [ …13]
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]
]
+"ID": "24437"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5291
+post_id: "24236"
+post_author: 1
+"ListingKey": "KEY418996729"
+"ListingId": "831922"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-04-22T07:03:40Z"
+"RFModificationTimestamp": "2025-04-22T07:05:02Z"
+"ListPrice": 1329000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2172.0
+"BuildingAreaTotal": 2172.0
+"City": "Hempstead"
+"PostalCode": "11516"
+"UnparsedAddress": "9 Columbia, Hempstead, New York 11516"
+"Coordinates": array:2 [
0 => -74.1303435
1 => 41.3168525
]
+"Latitude": 41.3168525
+"Longitude": -74.1303435
+"YearBuilt": 1962
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Lisa F. Gordon"
+"ListOfficeName": "Realty Connect USA LLC"
+"ListAgentMlsId": "152800"
+"ListOfficeMlsId": "RLLE02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Large split with huge potential. The home is on 8200 Sf corner property . 2800 additional Sf can be added onto the already existing 2172 sf for a home with 5000 SF of living space. Tremendous opportunity to custom create the home you've always wanted. Home is being sold AS-IS"
+"Appliances": array:3 [
0 => "Dishwasher"
1 => "Oven"
2 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Split Ranch"
]
+"AttributionContact": "lisa.gordon125@gmail.com"
+"Basement": array:1 [
0 => "Unfinished"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-462-4955"
+"CoListAgentEmail": "gabrielleedery@gmail.com"
+"CoListAgentFullName": "Gabrielle N. Edery"
+"CoListAgentKey": "326226440"
+"CoListAgentMlsId": "217388"
+"CoListOfficeKey": "326115083"
+"CoListOfficeMlsId": "RLLE02"
+"CoListOfficeName": "Realty Connect USA LLC"
+"CoListOfficePhone": "516-714-3606"
+"ConstructionMaterials": array:1 [
0 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-07T13:07:03.882850+00:00"
+"CrossStreet": "Broadway"
+"CumulativeDaysOnMarket": 44
+"DaysOnMarket": 44
+"Directions": "GPS"
+"ElementarySchool": "Lawrence Early Childhood-#4 School"
+"ExpirationDate": "2025-04-22"
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:2 [
0 => "Eat-in Kitchen"
1 => "High Ceilings"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-330-2753"
+"ListAgentEmail": "lisa.gordon125@gmail.com"
+"ListAgentKey": "326165418"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115083"
+"ListOfficePhone": "516-714-3606"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-07"
+"LivingAreaSource": "Public Records"
+"MajorChangeTimestamp": "2025-04-22T04:10:39Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-04-22"
+"OnMarketDate": "2025-03-09"
+"OriginalEntryTimestamp": "2025-03-07T12:59:39Z"
+"OriginalListPrice": 1329000
+"OriginatingSystemModificationTimestamp": "2025-04-22T04:10:39Z"
+"OwnerName": "Columbia Cedar Mazal LLC"
+"PhotosChangeTimestamp": "2025-03-07T13:31:37Z"
+"PhotosCount": 1
+"PostalCity": "Cedarhurst"
+"PropertyCondition": array:1 [
0 => "Fixer"
]
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-330-2753"
+"ShowingRequirements": array:2 [
0 => "Appointment Only"
1 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-04-22T04:10:39Z"
+"StreetName": "Columbia"
+"StreetNumber": "9"
+"StreetNumberNumeric": "9"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "9744"
+"TaxYear": "2023"
+"Utilities": array:1 [
0 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_ElectricCompany": "PSEG"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_ShowingContactPhone2": "516-462-4955"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Other"
+"KEY_LivingAreaSearchSqFt": "2172.00"
+"KEY_PreviousStatus": "Active"
+"KEY_CurrentPrice": "1329000.00"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "611.87845"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "611.87845"
+"KEY_Attic": "None"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "611.87845"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "611.87845"
+"KEY_SourceSystemModificationTimestamp": "2025-03-06T11:54:03.383"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418996729')"
+"provider_name": "One Key"
+"Media": array:1 [
0 => array:14 [ …14]
]
+"ID": "24236"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5298
+post_id: "24235"
+post_author: 1
+"ListingKey": "KEY418988211"
+"ListingId": "831739"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-09-05T07:02:51Z"
+"RFModificationTimestamp": "2025-09-05T07:03:18Z"
+"ListPrice": 1899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3888.0
+"BuildingAreaTotal": 3688.0
+"City": "Hempstead"
+"PostalCode": "11598"
+"UnparsedAddress": "10 Linden Street, Hempstead, New York 11598"
+"Coordinates": array:2 [
0 => -73.6646151
1 => 41.0117947
]
+"Latitude": 41.0117947
+"Longitude": -73.6646151
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Michael Eichler"
+"ListOfficeName": "Five Towns Miller Realty Inc"
+"ListAgentMlsId": "127366"
+"ListOfficeMlsId": "DOMI01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Beautifully renovated splanch in SD 15 Woodmere "Tree Streets" with new boiler, new roof, new pavers, huge kitchen, low taxes, much more."
+"Appliances": array:2 [
0 => "Freezer"
1 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Splanch"
]
+"AttributionContact": "516-374-4100"
+"Basement": array:1 [
0 => "Finished"
]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Frame"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-09T00:32:51.138630+00:00"
+"CumulativeDaysOnMarket": 265
+"DaysOnMarket": 181
+"ElementarySchool": "Lawrence Early Childhood-#4 School"
+"ElementarySchoolDistrict": "Lawrence"
+"ExpirationDate": "2025-09-05"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [
0 => "Natural Gas"
1 => "Other"
]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:1 [
0 => "Other"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-374-4100"
+"ListAgentEmail": "meichler@ftmr.com"
+"ListAgentKey": "326142013"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110921"
+"ListOfficePhone": "516-374-4100"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-08"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1377
+"LotSizeSquareFeet": 6000
+"MajorChangeTimestamp": "2025-09-05T04:10:57Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-09-05"
+"OnMarketDate": "2025-03-08"
+"OriginalEntryTimestamp": "2025-03-09T00:32:01Z"
+"OriginalListPrice": 1899000
+"OriginatingSystemModificationTimestamp": "2025-09-05T04:10:57Z"
+"OwnerName": "Yakubov"
+"ParcelNumber": "2089-39-243-00-0225-0"
+"PhotosChangeTimestamp": "2025-03-09T00:33:37Z"
+"PhotosCount": 40
+"PostalCity": "Woodmere"
+"PostalCodePlus4": "2620"
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-09-05T04:10:57Z"
+"StreetName": "Linden"
+"StreetNumber": "10"
+"StreetNumberNumeric": "10"
+"StreetSuffix": "Street"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "16490.39"
+"TaxAssessedValue": 1027
+"TaxYear": "2024"
+"Utilities": array:3 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1899000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "3888.00"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "488.42593"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "13790849.6732"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "488.42593"
+"KEY_SourceSystemModificationTimestamp": "2025-03-05T19:04:23.710"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418988211')"
+"provider_name": "One Key"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:14 [ …14]
36 => array:14 [ …14]
37 => array:14 [ …14]
38 => array:14 [ …14]
39 => array:14 [ …14]
]
+"ID": "24235"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5299
+post_id: "30347"
+post_author: 1
+"ListingKey": "KEY418987902"
+"ListingId": "831729"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-10-02T07:03:37Z"
+"RFModificationTimestamp": "2025-10-02T07:07:08Z"
+"ListPrice": 1999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3800.0
+"BuildingAreaTotal": 3683.0
+"City": "Hempstead"
+"PostalCode": "11559"
+"UnparsedAddress": "200 Beach 2nd Street, Hempstead, New York 11559"
+"Coordinates": array:2 [
0 => -73.738043013514
1 => 40.595641547297
]
+"Latitude": 40.595641547297
+"Longitude": -73.738043013514
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Annette Alicanti"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "182389"
+"ListOfficeMlsId": "DERE57"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 200 Beach 2nd Street, your gateway to modern, waterfront living in the heart of Lawrence. This newly constructed gem offers panoramic water views, cutting-edge amenities, and unparalleled comfort.\n
Four spacious bedrooms and three and a half bathrooms, each meticulously designed for functionality and ease. The home's gourmet kitchen is a culinary enthusiast's dream, boasting a central island, subway tile backsplash, and brand-new stainless steel appliances. The bright and open great room is a haven for entertainment, filled with natural light that enhances the home's spacious feel. For those seeking a quiet retreat, two private balconies offer breathtaking water views, perfect for a morning coffee or evening read. The property also includes a six-plus car garage and a walkout basement, both equipped with radiant heated floors for your convenience. The Navien heating and cooling system ensures energy-efficient living, while the hardwood floors and high ceilings add to the home's overall elegance. Outside, a large private driveway offers ample parking, and the proximity to Atlantic, Long, and Lido beaches provides endless opportunities for leisurely strolls and weekend getaways. The neighborhood is also on the brink of exciting development, with four new luxury condos being built next door. This is not just a home, but an investment in a thriving community. 200 Beach 2nd Street is more than just a property; it's a lifestyle. Experience the perfect blend of modern luxury and coastal charm in this stunning home. Your dream living awaits.
"""
+"Appliances": array:6 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Gas Range"
3 => "Microwave"
4 => "Refrigerator"
5 => "Stainless Steel Appliance(s)"
]
+"ArchitecturalStyle": array:2 [
0 => "Post Modern"
1 => "Traditional"
]
+"AttributionContact": "516-621-3555"
+"BathroomsFull": 3
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-06T01:14:59.992840+00:00"
+"CrossStreet": "Seagirt Ave"
+"CumulativeDaysOnMarket": 211
+"DaysOnMarket": 211
+"Directions": "Waze"
+"ElementarySchool": "Lawrence Early Childhood-#4 School"
+"ElementarySchoolDistrict": "Lawrence"
+"ExpirationDate": "2025-10-02"
+"Flooring": array:2 [
0 => "Other"
1 => "Wood"
]
+"GarageSpaces": "6"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:10 [
0 => "Ceiling Fan(s)"
1 => "ENERGY STAR Qualified Door(s)"
2 => "Formal Dining"
3 => "Granite Counters"
4 => "High Ceilings"
5 => "Open Kitchen"
6 => "Smart Thermostat"
7 => "Walk Through Kitchen"
8 => "Walk-In Closet(s)"
9 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-386-6932"
+"ListAgentEmail": "annette.alicanti@elliman.com"
+"ListAgentKey": "326192729"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110782"
+"ListOfficePhone": "516-621-3555"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-05"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.0689
+"LotSizeSquareFeet": 3000
+"MajorChangeTimestamp": "2025-10-02T04:12:59Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-10-02"
+"OnMarketDate": "2025-03-05"
+"OriginalEntryTimestamp": "2025-03-06T01:12:55Z"
+"OriginalListPrice": 2400000
+"OriginatingSystemModificationTimestamp": "2025-10-02T04:12:59Z"
+"OwnerName": "Name Withheld"
+"ParcelNumber": "2023-40-131-00-0109-0"
+"ParkingTotal": "4"
+"PhotosChangeTimestamp": "2025-10-02T04:14:37Z"
+"PhotosCount": 20
+"PostalCity": "Lawrence"
+"PostalCodePlus4": "2902"
+"PreviousListPrice": 2099000
+"PriceChangeTimestamp": "2025-06-07T17:13:50Z"
+"RoomsTotal": "11"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "347-386-6932"
+"ShowingRequirements": array:1 [
0 => "24 Hour Notice"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-10-02T04:12:59Z"
+"StreetName": "Beach 2nd"
+"StreetNumber": "200"
+"StreetNumberNumeric": "200"
+"StreetSuffix": "Street"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "18575"
+"TaxYear": "2023"
+"Utilities": array:5 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Sewer Connected"
3 => "Trash Collection Public"
4 => "Water Connected"
]
+"View": "Bridge(s),Open,Water"
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "Partial"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1999000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "0"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "3800.00"
+"KEY_ShowingContactPhone2": "347-386-6932"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "526.05263"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "29013062.4093"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "526.05263"
+"KEY_SourceSystemModificationTimestamp": "2025-03-05T18:35:37.093"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "542.76405"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.83292"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "542.76405"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418987902')"
+"provider_name": "One Key"
+"Media": array:20 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
]
+"ID": "30347"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5300
+post_id: "30346"
+post_author: 1
+"ListingKey": "KEY418979420"
+"ListingId": "831476"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-03-05T07:01:38Z"
+"RFModificationTimestamp": "2026-03-05T07:04:48Z"
+"ListPrice": 4899000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 2
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 5400.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11559"
+"UnparsedAddress": "123 Barrett Road, Hempstead, New York 11559"
+"Coordinates": array:2 [
0 => -73.726646253126
1 => 40.60187485
]
+"Latitude": 40.60187485
+"Longitude": -73.726646253126
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Etty A. Levy"
+"ListOfficeName": "BERKSHIRE HATHAWAY"
+"ListAgentMlsId": "215894"
+"ListOfficeMlsId": "BHHS04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Step into this exquisite contemporary colonial estate, gracefully situated on over 1.5 acres of serene, park-like grounds. Stunning water views can be enjoyed throughout the house, creating a tranquil ambiance throughout the home. The expansive kitchen seamlessly connects to the open-concept den, serving as the heart of the home—perfect for family gatherings. For more formal entertaining, the property offers an elegant dining room and a spacious living room. The home features many floor to ceiling windows allowing for bright natural light and spectacular water views. The full finished basement includes a cozy den, a bedroom, and a half bath, providing extra living space. A convenient first-floor bedroom with an en-suite full bath is ideal for guests or multigenerational living. The private primary suite, located on its own level, features a luxurious full bath for ultimate privacy, with many closets for storage. Additionally, there are four generously sized bedrooms and two full baths, ensuring ample space for family and guests. This estate offers both beauty and functionality, all while benefiting from low taxes! All offers being reviewed!"
+"Appliances": array:6 [
0 => "Dishwasher"
1 => "Electric Cooktop"
2 => "Electric Oven"
3 => "Microwave"
4 => "Refrigerator"
5 => "Wine Refrigerator"
]
+"ArchitecturalStyle": array:2 [
0 => "Contemporary"
1 => "Estate"
]
+"AttributionContact": "516-295-3000"
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Walk-Out Access"
]
+"BasementYN": true
+"BathroomsFull": 4
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-459-0278"
+"CoListAgentEmail": "jrosenberg@bhhslaffey.com"
+"CoListAgentFullName": "Jordan Rosenberg"
+"CoListAgentKey": "326235212"
+"CoListAgentMlsId": "226457"
+"CoListOfficeKey": "326109740"
+"CoListOfficeMlsId": "BHHS04"
+"CoListOfficeName": "BERKSHIRE HATHAWAY"
+"CoListOfficePhone": "516-295-3000"
+"ConstructionMaterials": array:4 [
0 => "Foam Insulation"
1 => "Frame"
2 => "Stone"
3 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-05T18:56:44.423037+00:00"
+"CrossStreet": "Causeway"
+"CumulativeDaysOnMarket": 352
+"DaysOnMarket": 352
+"Directions": "Causeway to Barrett Road."
+"ElementarySchool": "Lawrence Early Childhood-#4 School"
+"ElementarySchoolDistrict": "Lawrence"
+"Exclusions": "Chandelier in Dining Room, Chandelier in Entrance"
+"ExpirationDate": "2026-03-05"
+"ExteriorFeatures": array:5 [
0 => "Basketball Court"
1 => "Fire Pit"
2 => "Garden"
3 => "Gas Grill"
4 => "Speakers"
]
+"Fencing": array:1 [
0 => "Back Yard"
]
+"FireplaceFeatures": array:3 [
0 => "Family Room"
1 => "Living Room"
2 => "Wood Burning Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"Flooring": array:3 [
0 => "Carpet"
1 => "Hardwood"
2 => "Tile"
]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:6 [
0 => "Baseboard"
1 => "Electric"
2 => "Hot Air"
3 => "Hot Water"
4 => "Radiant"
5 => "Radiant Floor"
]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:15 [
0 => "First Floor Bedroom"
1 => "Breakfast Bar"
2 => "Ceiling Fan(s)"
3 => "Chandelier"
4 => "Double Vanity"
5 => "Eat-in Kitchen"
6 => "Entrance Foyer"
7 => "Formal Dining"
8 => "Granite Counters"
9 => "Kitchen Island"
10 => "Marble Counters"
11 => "Primary Bathroom"
12 => "Speakers"
13 => "Walk-In Closet(s)"
14 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [
0 => "Electric Dryer Hookup"
1 => "Laundry Room"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-852-1439"
+"ListAgentEmail": "ELevy@bhhslaffey.com"
+"ListAgentKey": "326225003"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109740"
+"ListOfficePhone": "516-295-3000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-04"
+"LivingAreaSource": "Other"
+"LotFeatures": array:7 [
0 => "Back Yard"
1 => "Front Yard"
2 => "Landscaped"
3 => "Near Golf Course"
4 => "On Golf Course"
5 => "Sprinklers In Front"
6 => "Sprinklers In Rear"
]
+"LotSizeAcres": 1.58
+"MajorChangeTimestamp": "2026-03-05T05:11:46Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-03-05"
+"OnMarketDate": "2025-03-18"
+"OriginalEntryTimestamp": "2025-03-05T18:50:06Z"
+"OriginalListPrice": 4899000
+"OriginatingSystemModificationTimestamp": "2026-03-05T05:11:46Z"
+"OtherEquipment": array:1 [
0 => "Pool Equip/Cover"
]
+"OtherStructures": array:1 [
0 => "Pergola"
]
+"OwnerName": "Friedman"
+"ParcelNumber": "2023-40-112-00-0024-0"
+"ParkingFeatures": array:4 [
0 => "Attached"
1 => "Driveway"
2 => "Electric Vehicle Charging Station(s)"
3 => "Garage"
]
+"ParkingTotal": "40"
+"PatioAndPorchFeatures": array:2 [
0 => "Deck"
1 => "Patio"
]
+"PhotosChangeTimestamp": "2025-10-29T11:09:36Z"
+"PhotosCount": 32
+"PoolFeatures": array:3 [
0 => "In Ground"
1 => "Pool Cover"
2 => "Solar Heat"
]
+"PoolPrivateYN": true
+"PostalCity": "Lawrence"
+"PostalCodePlus4": "2017"
+"RoomsTotal": "12"
+"SecurityFeatures": array:4 [
0 => "Building Security"
1 => "Fire Alarm"
2 => "Smoke Detector(s)"
3 => "Video Cameras"
]
+"Sewer": array:1 [
0 => "Septic Tank"
]
+"ShowingContactPhone": "516-852-1439"
+"ShowingRequirements": array:5 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
3 => "Call Listing Office"
4 => "No Lockbox"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-05T05:11:46Z"
+"StreetName": "Barrett"
+"StreetNumber": "123"
+"StreetNumberNumeric": "123"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "24870.5"
+"TaxYear": "2025"
+"Utilities": array:1 [
0 => "Sewer Connected"
]
+"View": "Water"
+"VirtualTourURLBranded": "https://www.youtube.com/watch?v=E5bi_vULmTg"
+"VirtualTourURLUnbranded": "https://tour.vht.com/434448815/idxs"
+"WaterSource": array:1 [
0 => "Well"
]
+"WindowFeatures": array:2 [
0 => "Casement"
1 => "Floor to Ceiling Windows"
]
+"KEY_Attic": "Partially Finished"
+"KEY_Village": "Lawrence"
+"KEY_TaxSource": "Other"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "4899000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "5400.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_ShowingContactPhone2": "516-459-0278"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "907.22222"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3100632.9114"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "907.22222"
+"KEY_SourceSystemModificationTimestamp": "2025-03-05T12:24:04.510"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418979420')"
+"provider_name": "One Key"
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:14 [ …14]
5 => array:14 [ …14]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:14 [ …14]
9 => array:14 [ …14]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:14 [ …14]
15 => array:14 [ …14]
16 => array:14 [ …14]
17 => array:14 [ …14]
18 => array:14 [ …14]
19 => array:14 [ …14]
20 => array:14 [ …14]
21 => array:14 [ …14]
22 => array:14 [ …14]
23 => array:14 [ …14]
24 => array:14 [ …14]
25 => array:14 [ …14]
26 => array:14 [ …14]
27 => array:14 [ …14]
28 => array:14 [ …14]
29 => array:14 [ …14]
30 => array:14 [ …14]
31 => array:14 [ …14]
]
+"ID": "30346"
}
10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5301
+post_id: "23780"
+post_author: 1
+"ListingKey": "KEY418951154"
+"ListingId": "830652"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-20T17:24:36Z"
+"RFModificationTimestamp": "2026-01-20T17:27:44Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2150.0
+"BuildingAreaTotal": 2150.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "3250 Messick Avenue, Hempstead, New York 11572"
+"Coordinates": array:2 [
0 => -73.648923954514
1 => 40.63226875
]
+"Latitude": 40.63226875
+"Longitude": -73.648923954514
+"YearBuilt": 1960
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Joy J. Cohen"
+"ListOfficeName": "Exit All Seasons Realty"
+"ListAgentMlsId": "114780"
+"ListOfficeMlsId": "ALSE02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome To 3250 Messick Ave, A HIGH RANCH HOME IN THE SOUGHT-AFTER OCEANSIDE Community. Set On A Corner Lot, This Three Bedroom, Two Bath Property Has Been Well Maintained & Updated Throughout The Years. You Will Love The Harwood Flooring, High Ceilings & All The Natural Light That Is Flooding The Open Living Space And Three Generously Sized Bedrooms. If You Like Beautiful Beaches, Outdoor Activities & Cultural Attractions You Will Be Thrilled To Call Oceanside Your Hometown. In Addition, This Charming Town Offers A Variety Of Dining Options And Easy Access To The City."
+"Appliances": array:3 [
0 => "Dishwasher"
1 => "Gas Oven"
2 => "Refrigerator"
]
+"ArchitecturalStyle": array:2 [
0 => "Hi Ranch"
1 => "Raised Ranch"
]
+"AttributionContact": "718-416-4411"
+"Basement": array:2 [
0 => "Full"
1 => "Walk-Out Access"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "HGAR"
+"BuyerAgentDirectPhone": "000-000-0000"
+"BuyerAgentFullName": "Non Member-MLS"
+"BuyerAgentKey": "1262689"
+"BuyerAgentMlsId": "8888"
+"BuyerOfficeAOR": "HGAR"
+"BuyerOfficeKey": "1262827"
+"BuyerOfficeMlsId": "888888"
+"BuyerOfficeName": "Buyer Representation Office"
+"BuyerOfficePhone": "000-000-0000"
+"CarportSpaces": "1"
+"CarportYN": true
+"ConstructionMaterials": array:3 [
0 => "Aluminum Siding"
1 => "Brick"
2 => "Stucco"
]
+"Cooling": array:1 [
0 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-10T21:21:50.036988+00:00"
+"CumulativeDaysOnMarket": 319
+"DaysOnMarket": 319
+"ElementarySchool": "School 6-Kindergarten Ctr"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-02-28"
+"Heating": array:1 [
0 => "Oil"
]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:4 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Eat-in Kitchen"
3 => "Formal Dining"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "718-416-4411"
+"ListAgentEmail": "JCEXITALLSEASONS@GMAIL.COM"
+"ListAgentKey": "326130528"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109304"
+"ListOfficePhone": "718-416-4411"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-03"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.0872
+"LotSizeSquareFeet": 3800
+"MajorChangeTimestamp": "2026-01-20T17:22:43Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-20"
+"OnMarketDate": "2025-03-03"
+"OriginalEntryTimestamp": "2025-03-03T23:30:55Z"
+"OriginalListPrice": 650000
+"OriginatingSystemModificationTimestamp": "2026-01-20T17:22:43Z"
+"OwnerName": "Bennett"
+"ParcelNumber": "2089-43-290-00-0034-0"
+"PhotosChangeTimestamp": "2025-09-26T12:20:43Z"
+"PhotosCount": 2
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "3835"
+"PurchaseContractDate": "2026-01-20"
+"RoomsTotal": "5"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "917-609-2991"
+"ShowingRequirements": array:1 [
0 => "24 Hour Notice"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-20T17:22:43Z"
+"StreetName": "Messick"
+"StreetNumber": "3250"
+"StreetNumberNumeric": "3250"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "10852.55"
+"TaxAssessedValue": 380
+"TaxYear": "2023"
+"Utilities": array:2 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "None"
+"KEY_HoldDate": "2025-03-06"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "650000.00"
+"KEY_ContractPrice": "600000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2150.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "302.32558"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7454128.4404"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "302.32558"
+"KEY_SourceSystemModificationTimestamp": "2025-03-03T18:13:12.223"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "302.32558"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "302.32558"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418951154')"
+"provider_name": "One Key"
+"Media": array:2 [
0 => array:14 [ …14]
1 => array:14 [ …14]
]
+"ID": "23780"
}
11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5302
+post_id: "24988"
+post_author: 1
+"ListingKey": "KEY418949821"
+"ListingId": "830598"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Mixed Use"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-09-04T07:02:41Z"
+"RFModificationTimestamp": "2025-09-04T07:06:49Z"
+"ListPrice": 8500.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 6196.0
+"City": "Hempstead"
+"PostalCode": "11510"
+"UnparsedAddress": "800 Merrick Road, Hempstead, New York 11510"
+"Coordinates": array:2 [
0 => -73.395293
1 => 40.668579
]
+"Latitude": 40.668579
+"Longitude": -73.395293
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Luis A. Rodriguez"
+"ListOfficeName": "Platinum Realty Estates"
+"ListAgentMlsId": "158136"
+"ListOfficeMlsId": "EGO01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Location, Location, Location!!!!Completely Built Out space ideal for medical, spa, daycare, etc. Located in the heart of Baldwin, 23,000 cars daily traffic study\n
Property features 2 Bathrooms, 2 Heating/Ac Units, LED Lighting, Space has 7 rooms already finished with plumbing. The Building also features a sprinkler system and central station connection, plenty of parking and signage spacing for two signs, One on Merrick Rd and the other on Foxhurst Rd.
"""
+"AttributionContact": "516-706-9001"
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Barber/Beauty,Dental,Medical,Professional Service,Professional/Office"
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Cooling": array:2 [
0 => "Central Air"
1 => "Ductwork"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-20T14:27:17.653620+00:00"
+"CumulativeDaysOnMarket": 168
+"DaysOnMarket": 168
+"Directions": "Merrick Rd to Corner of Grand Ave and Foxhurst Rd."
+"Electric": "200+ Amp Service"
+"ExpirationDate": "2025-09-04"
+"Heating": array:2 [
0 => "Ducts"
1 => "ENERGY STAR Qualified Equipment"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeasableArea": 3200
+"LeaseAmountFrequency": "Monthly"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-706-9001"
+"ListAgentEmail": "luisrpre@gmail.com"
+"ListAgentKey": "326170371"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326111082"
+"ListOfficePhone": "516-706-9001"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-03-20"
+"MajorChangeTimestamp": "2025-09-04T04:10:53Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-09-04"
+"OnMarketDate": "2025-03-20"
+"OriginalEntryTimestamp": "2025-03-20T14:15:01Z"
+"OriginalListPrice": 8500
+"OriginatingSystemModificationTimestamp": "2025-09-04T04:10:53Z"
+"OwnerName": "Withheld"
+"PhotosChangeTimestamp": "2025-03-20T14:16:37Z"
+"PhotosCount": 4
+"PostalCity": "Baldwin"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-706-9001"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-09-04T04:10:53Z"
+"Stories": "1"
+"StoriesTotal": "2"
+"StreetName": "Merrick"
+"StreetNumber": "800"
+"StreetNumberNumeric": "800"
+"StreetSuffix": "Road"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "69549.12"
+"TaxYear": "2025"
+"Utilities": array:4 [
0 => "Cable Available"
1 => "Electricity Available"
2 => "Natural Gas Connected"
3 => "Sewer Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_SubleaseYN": "0"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "8500.00"
+"KEY_BuildToSuitYN": "1"
+"KEY_LeasePriceUnit": "Total"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_SprinklerSystemYN": "1"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_InvestmentPropertyYN": "0"
+"KEY_SourceSystemModificationTimestamp": "2025-03-03T16:53:28.793"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.37185"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.37185"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418949821')"
+"provider_name": "One Key"
+"Media": array:4 [
0 => array:14 [ …14]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:14 [ …14]
]
+"ID": "24988"
}
]
+success: true
+page_size: 12
+page_count: 235
+count: 2815
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]