array:3 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=1632&$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) and (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4531
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4535
+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/reso/odata/Property('KEY418996729')"
+"provider_name": "One Key"
+"Media": array:1 [
0 => array:14 [
"Order" => 0
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418996729/330fedff645e48fb090b7e482cc66496.webp"
"MediaSize" => 91508
"ResourceRecordKey" => "418996729"
"MediaModificationTimestamp" => "2025-03-07T13:30:40.606Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418996729/thumbnail-330fedff645e48fb090b7e482cc66496.webp"
"ShortDescription" => "Front of Structure"
"MediaKey" => "67caf500adef1c74619ec440"
"LongDescription" => "View of front of property featuring concrete driveway and an attached garage"
"ImageHeight" => 945
"ImageWidth" => 665
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "665x945"
]
]
+"ID": "24236"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5095
+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/reso/odata/Property('KEY418988211')"
+"provider_name": "One Key"
+"Media": array:40 [
0 => array:13 [
"Order" => 0
"MediaKey" => "67cce1aeb3240c43ddaf58ef"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/1075872876501ade110624cdad959567.webp"
"MediaSize" => 242251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-1075872876501ade110624cdad959567.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.122Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "67cce1aeb3240c43ddaf58f0"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/3f8164de7371617f993dd804cf2832c4.webp"
"MediaSize" => 217147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-3f8164de7371617f993dd804cf2832c4.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.077Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "67cce1aeb3240c43ddaf58f1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/d68aaac50e34583d05523908ae369b7e.webp"
"MediaSize" => 124909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-d68aaac50e34583d05523908ae369b7e.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Entry"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.045Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "67cce1aeb3240c43ddaf58f2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/a08ba9cf39ec1712f15c9e4af28d57f8.webp"
"MediaSize" => 109249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-a08ba9cf39ec1712f15c9e4af28d57f8.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Entry"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.043Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "67cce1aeb3240c43ddaf58f3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/8cc7aa52dccde2ab84b0cfeafe4e0214.webp"
"MediaSize" => 123603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-8cc7aa52dccde2ab84b0cfeafe4e0214.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Entry"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.050Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "67cce1aeb3240c43ddaf58f4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/74ae4fe7cac01d5af65f038aa0a22a4c.webp"
"MediaSize" => 134307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-74ae4fe7cac01d5af65f038aa0a22a4c.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.044Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "67cce1aeb3240c43ddaf58f5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/8ff09cefdc0f966a96f7972fb1e8fb2a.webp"
"MediaSize" => 133960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-8ff09cefdc0f966a96f7972fb1e8fb2a.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.047Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "67cce1aeb3240c43ddaf58f6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/796974dd04d8b12d2371b447f2701de2.webp"
"MediaSize" => 150124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-796974dd04d8b12d2371b447f2701de2.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.131Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "67cce1aeb3240c43ddaf58f7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/89d9d64b1a97edf2fa95b5769ab0cbee.webp"
"MediaSize" => 127996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-89d9d64b1a97edf2fa95b5769ab0cbee.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.040Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "67cce1aeb3240c43ddaf58f8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/820f6d315a711e2e4903712199d2a5b0.webp"
"MediaSize" => 145140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-820f6d315a711e2e4903712199d2a5b0.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.128Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "67cce1aeb3240c43ddaf58f9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/9192827eccd20db272e788b04f538f77.webp"
"MediaSize" => 149972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-9192827eccd20db272e788b04f538f77.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.110Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "67cce1aeb3240c43ddaf58fa"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/614078657f825174e43363f010eaeb58.webp"
"MediaSize" => 165719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-614078657f825174e43363f010eaeb58.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.101Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "67cce1aeb3240c43ddaf58fb"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/48a9951ac1229e3c38b995f4b42fc660.webp"
"MediaSize" => 142576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-48a9951ac1229e3c38b995f4b42fc660.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.183Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "67cce1aeb3240c43ddaf58fc"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/a5a91a7e89da3a655ac8ade755a58524.webp"
"MediaSize" => 142952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-a5a91a7e89da3a655ac8ade755a58524.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.155Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "67cce1aeb3240c43ddaf58fd"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/6a839a4fe8b83299cdf80bbffd495365.webp"
"MediaSize" => 139944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-6a839a4fe8b83299cdf80bbffd495365.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.207Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "67cce1aeb3240c43ddaf58fe"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/ac14dccb1f16901701c15adca3974633.webp"
"MediaSize" => 135652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-ac14dccb1f16901701c15adca3974633.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.069Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "67cce1aeb3240c43ddaf58ff"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/548ed0a9602b729d5facaa8c7af0a1d0.webp"
"MediaSize" => 142761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-548ed0a9602b729d5facaa8c7af0a1d0.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.125Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "67cce1aeb3240c43ddaf5900"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/a8c8c3212434bb5ea7bc03bb7833888b.webp"
"MediaSize" => 86580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-a8c8c3212434bb5ea7bc03bb7833888b.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Laundry"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.096Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "67cce1aeb3240c43ddaf5901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/b35af1676a167e834f36a4b941ea724d.webp"
"MediaSize" => 119274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-b35af1676a167e834f36a4b941ea724d.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Family Room"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.107Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "67cce1aeb3240c43ddaf5902"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/b77a8271cb8f53922e9814ce67680e11.webp"
"MediaSize" => 124326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-b77a8271cb8f53922e9814ce67680e11.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Family Room"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.117Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "67cce1aeb3240c43ddaf5903"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/df501c7a0930466c6f834e818b3d93ca.webp"
"MediaSize" => 130954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-df501c7a0930466c6f834e818b3d93ca.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Family Room"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.105Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "67cce1aeb3240c43ddaf5904"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/8fa30c828a8b851391a55308a55e75c2.webp"
"MediaSize" => 114915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-8fa30c828a8b851391a55308a55e75c2.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.151Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "67cce1aeb3240c43ddaf5905"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/43e7267c5468f1949971cb3e8bdc3328.webp"
"MediaSize" => 116413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-43e7267c5468f1949971cb3e8bdc3328.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.092Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "67cce1aeb3240c43ddaf5906"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/575fcb87051d88bb725112fc2e1dbced.webp"
"MediaSize" => 117140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-575fcb87051d88bb725112fc2e1dbced.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.032Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "67cce1aeb3240c43ddaf5907"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/a5f21619cef539846b8c0b11eda73f9f.webp"
"MediaSize" => 131382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-a5f21619cef539846b8c0b11eda73f9f.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.040Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "67cce1aeb3240c43ddaf5908"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/76b0c81a6637c4cf69d425ce6f29c5c2.webp"
"MediaSize" => 119396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-76b0c81a6637c4cf69d425ce6f29c5c2.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.078Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "67cce1aeb3240c43ddaf5909"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/24329314b95c0918f053d8f190a8ed15.webp"
"MediaSize" => 141937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-24329314b95c0918f053d8f190a8ed15.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.076Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "67cce1aeb3240c43ddaf590a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/d43e84ec0df1adb1bdd576eb10abccbf.webp"
"MediaSize" => 117122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-d43e84ec0df1adb1bdd576eb10abccbf.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.039Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "67cce1aeb3240c43ddaf590b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/9ecf4868b810c3e3ab8170815c9647c3.webp"
"MediaSize" => 124092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-9ecf4868b810c3e3ab8170815c9647c3.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.095Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "67cce1aeb3240c43ddaf590c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/f245a2ed1a86e1007f9f643ced825c6c.webp"
"MediaSize" => 184949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-f245a2ed1a86e1007f9f643ced825c6c.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Closet"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.089Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "67cce1aeb3240c43ddaf590d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/371aefaad48abb675dd8880bd9b6d517.webp"
"MediaSize" => 122091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-371aefaad48abb675dd8880bd9b6d517.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Basement"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.033Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "67cce1aeb3240c43ddaf590e"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/a4da9095ec4c73b790e222185f6c6c18.webp"
"MediaSize" => 114050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-a4da9095ec4c73b790e222185f6c6c18.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Basement"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.030Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "67cce1aeb3240c43ddaf590f"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/d45f0f40ef89a188e55f0ead24cf90df.webp"
"MediaSize" => 116794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-d45f0f40ef89a188e55f0ead24cf90df.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Basement"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.072Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "67cce1aeb3240c43ddaf5910"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/c7c7fcbac70110ad661407a44f80d9e9.webp"
"MediaSize" => 207213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-c7c7fcbac70110ad661407a44f80d9e9.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Back of Structure"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.093Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "67cce1aeb3240c43ddaf5911"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/f395ff02818e8e355e725792fea2ac6f.webp"
"MediaSize" => 221089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-f395ff02818e8e355e725792fea2ac6f.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 798
"ShortDescription" => "Patio"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x798"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.100Z"
]
35 => array:14 [
"Order" => 35
"MediaKey" => "67cce1aeb3240c43ddaf5912"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/a0e3ad385657614af5d8d50319149cc8.webp"
"MediaSize" => 65152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-a0e3ad385657614af5d8d50319149cc8.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 900
"LongDescription" => "Basement"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x900"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.125Z"
]
36 => array:14 [
"Order" => 36
"MediaKey" => "67cce1aeb3240c43ddaf5913"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/d8613511ef2ba01fda9e460fd0b4270d.webp"
"MediaSize" => 65786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-d8613511ef2ba01fda9e460fd0b4270d.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 900
"LongDescription" => "1st Floor"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x900"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.079Z"
]
37 => array:14 [
"Order" => 37
"MediaKey" => "67cce1aeb3240c43ddaf5914"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/e6cd69985e1bef6975cd414b8371392e.webp"
"MediaSize" => 57005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-e6cd69985e1bef6975cd414b8371392e.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 900
"LongDescription" => "Family Room- Mid-level"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x900"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.077Z"
]
38 => array:14 [
"Order" => 38
"MediaKey" => "67cce1aeb3240c43ddaf5915"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/c8d8d11a6a37c3a83129273fe1e94b73.webp"
"MediaSize" => 78297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-c8d8d11a6a37c3a83129273fe1e94b73.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 900
"LongDescription" => "2nd Floor"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x900"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.049Z"
]
39 => array:14 [
"Order" => 39
"MediaKey" => "67cce1aeb3240c43ddaf5916"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/131ea8ad687a7799c3591119e9c6831d.webp"
"MediaSize" => 59638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418988211/thumbnail-131ea8ad687a7799c3591119e9c6831d.webp"
"ImageWidth" => 1200
"Permission" => array:1 [ …1]
"ImageHeight" => 900
"LongDescription" => "All Floors"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "418988211"
"ImageSizeDescription" => "1200x900"
"MediaModificationTimestamp" => "2025-03-09T00:32:46.090Z"
]
]
+"ID": "24235"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4607
+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/reso/odata/Property('KEY418987902')"
+"provider_name": "One Key"
+"Media": array:20 [
0 => array:12 [
"Order" => 0
"MediaKey" => "67c8f6c8e757b12c24d8a873"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/de2e812a6857fc482c02d81194893557.webp"
"MediaSize" => 332923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-de2e812a6857fc482c02d81194893557.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.560Z"
]
1 => array:12 [
"Order" => 1
"MediaKey" => "67c8f6c8e757b12c24d8a874"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/bcb81c8d969f51935163205cc2b785b2.webp"
"MediaSize" => 225218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-bcb81c8d969f51935163205cc2b785b2.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.642Z"
]
2 => array:12 [
"Order" => 2
"MediaKey" => "67c8f6c8e757b12c24d8a875"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/0e90dcaadb3801953051c70102b49369.webp"
"MediaSize" => 247272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-0e90dcaadb3801953051c70102b49369.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.587Z"
]
3 => array:12 [
"Order" => 3
"MediaKey" => "67c8f6c8e757b12c24d8a876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/b103923f9bc0a26c01a0a225b0d34b97.webp"
"MediaSize" => 341278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-b103923f9bc0a26c01a0a225b0d34b97.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.744Z"
]
4 => array:12 [
"Order" => 4
"MediaKey" => "67c8f6c8e757b12c24d8a877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/f286056bd35d61cf10c31e14c0cea3eb.webp"
"MediaSize" => 232665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-f286056bd35d61cf10c31e14c0cea3eb.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.620Z"
]
5 => array:12 [
"Order" => 5
"MediaKey" => "67c8f6c8e757b12c24d8a878"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/3f9b82493211a972dcb920eb43c7802b.webp"
"MediaSize" => 206700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-3f9b82493211a972dcb920eb43c7802b.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.641Z"
]
6 => array:12 [
"Order" => 6
"MediaKey" => "67c8f6c8e757b12c24d8a879"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/b7aaa18ca92b99e625b1eddd5591ef93.webp"
"MediaSize" => 244096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-b7aaa18ca92b99e625b1eddd5591ef93.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.645Z"
]
7 => array:12 [
"Order" => 7
"MediaKey" => "67c8f6c8e757b12c24d8a87a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/9ec45104ca08f8a607d8085463c6cd7c.webp"
"MediaSize" => 178105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-9ec45104ca08f8a607d8085463c6cd7c.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.656Z"
]
8 => array:12 [
"Order" => 8
"MediaKey" => "67c8f6c8e757b12c24d8a87b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/43543925012bf7593a60fbeb6d93b942.webp"
"MediaSize" => 331521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-43543925012bf7593a60fbeb6d93b942.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.608Z"
]
9 => array:12 [
"Order" => 9
"MediaKey" => "67c8f6c8e757b12c24d8a87c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/2865410df03d101286d8e3b02ab72ac0.webp"
"MediaSize" => 333688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-2865410df03d101286d8e3b02ab72ac0.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.629Z"
]
10 => array:12 [
"Order" => 10
"MediaKey" => "67c8f6c8e757b12c24d8a87d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/943584253dd4f329a3cafb92fdde2b66.webp"
"MediaSize" => 156859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-943584253dd4f329a3cafb92fdde2b66.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.645Z"
]
11 => array:12 [
"Order" => 11
"MediaKey" => "67c8f6c8e757b12c24d8a87e"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/1950fefcec8458dbc5ef8fded75ad595.webp"
"MediaSize" => 281009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-1950fefcec8458dbc5ef8fded75ad595.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.655Z"
]
12 => array:12 [
"Order" => 12
"MediaKey" => "67c8f6c8e757b12c24d8a87f"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/5c64eac6964644f5d8b822c822521085.webp"
"MediaSize" => 185111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-5c64eac6964644f5d8b822c822521085.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.590Z"
]
13 => array:12 [
"Order" => 13
"MediaKey" => "67c8f6c8e757b12c24d8a880"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/d216497a7700bc3735936f0d44ae2fd3.webp"
"MediaSize" => 239312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-d216497a7700bc3735936f0d44ae2fd3.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.846Z"
]
14 => array:12 [
"Order" => 14
"MediaKey" => "67c8f6c8e757b12c24d8a881"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/b1a5f294baac9ad130a6120d28b495f0.webp"
"MediaSize" => 237387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-b1a5f294baac9ad130a6120d28b495f0.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.610Z"
]
15 => array:12 [
"Order" => 15
"MediaKey" => "67c8f6c8e757b12c24d8a882"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/adc08ca1c5bd5548336168919ea3ebae.webp"
"MediaSize" => 596872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-adc08ca1c5bd5548336168919ea3ebae.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.620Z"
]
16 => array:12 [
"Order" => 16
"MediaKey" => "67c8f6c8e757b12c24d8a883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/7c1488f774fd743f53c907d635c348a8.webp"
"MediaSize" => 224944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-7c1488f774fd743f53c907d635c348a8.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1266
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1266"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.622Z"
]
17 => array:12 [
"Order" => 17
"MediaKey" => "67c8f6c8e757b12c24d8a884"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/23f5502ae6ca856327171e957a7274e2.webp"
"MediaSize" => 460114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-23f5502ae6ca856327171e957a7274e2.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1424
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1424"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.696Z"
]
18 => array:12 [
"Order" => 18
"MediaKey" => "67c8f6c8e757b12c24d8a885"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/b12e0ed671965ebd5eefa5bd0a78b9a5.webp"
"MediaSize" => 535306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-b12e0ed671965ebd5eefa5bd0a78b9a5.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1424
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1424"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.620Z"
]
19 => array:12 [
"Order" => 19
"MediaKey" => "67c8f6c8e757b12c24d8a886"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/d1c0816ddd1afd9ab9d27370283100c9.webp"
"MediaSize" => 539808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418987902/thumbnail-d1c0816ddd1afd9ab9d27370283100c9.webp"
"ImageWidth" => 1900
"Permission" => array:1 [ …1]
"ImageHeight" => 1424
"ResourceRecordKey" => "418987902"
"ImageSizeDescription" => "1900x1424"
"MediaModificationTimestamp" => "2025-03-06T01:13:44.586Z"
]
]
+"ID": "30347"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4608
+post_id: "23808"
+post_author: 1
+"ListingKey": "KEY418985705"
+"ListingId": "831663"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-09T23:13:36Z"
+"RFModificationTimestamp": "2026-01-09T23:14:11Z"
+"ListPrice": 379990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 780.0
+"BuildingAreaTotal": 780.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "208 Sportsmans Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [
0 => -73.5812279
1 => 40.6415307
]
+"Latitude": 40.6415307
+"Longitude": -73.5812279
+"YearBuilt": 1918
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Daniel T. Moore"
+"ListOfficeName": "RE/MAX Best"
+"ListAgentMlsId": "9049888"
+"ListOfficeMlsId": "RBST01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Old world charm. 1918 Saltbox on the water. Put your boat in the back yard and enjoy the vibe. In the heart of Freeports nautical mile. Walk to shops and restaurants or take the boat. Large Living room adjoins large kitchen dining area. Enclosed back porch overlooks the canal. 2 large bedrooms and 1 bath. downstairs has been abandoned and is used for storage. House is being sold as is, Worth looking at. Don't pass this one up."
+"Appliances": array:7 [
0 => "Dryer"
1 => "Gas Cooktop"
2 => "Gas Oven"
3 => "Gas Range"
4 => "Refrigerator"
5 => "Washer"
6 => "Tankless Water Heater"
]
+"ArchitecturalStyle": array:2 [
0 => "Ranch"
1 => "Saltbox"
]
+"AttributionContact": "631-321-0100"
+"Basement": array:2 [
0 => "See Remarks"
1 => "Storage Space"
]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaSource": "Plans"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "HGAR"
+"BuyerAgentDirectPhone": "000-000-0000"
+"BuyerAgentFullName": "Unrepresented Buyer"
+"BuyerAgentKey": "421786246"
+"BuyerAgentMlsId": "347752"
+"BuyerOfficeAOR": "HGAR"
+"BuyerOfficeKey": "1262827"
+"BuyerOfficeMlsId": "888888"
+"BuyerOfficeName": "Buyer Representation Office"
+"BuyerOfficePhone": "000-000-0000"
+"ConstructionMaterials": array:2 [
0 => "Block"
1 => "Frame"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-03-05T23:05:21.283005+00:00"
+"CrossStreet": "Ray"
+"CumulativeDaysOnMarket": 307
+"DaysOnMarket": 307
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-03-04"
+"FrontageLength": "30ft"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:1 [
0 => "Storage"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "Remax DTM@aol.com"
+"ListAgentKey": "326259098"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114899"
+"ListOfficePhone": "631-321-0100"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-05"
+"LivingAreaSource": "Plans"
+"LotFeatures": array:1 [
0 => "Waterfront"
]
+"LotSizeAcres": 0.0344
+"LotSizeDimensions": "30x50"
+"LotSizeSquareFeet": 1500
+"MajorChangeTimestamp": "2026-01-09T23:12:31Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-09"
+"OnMarketDate": "2025-03-07"
+"OriginalEntryTimestamp": "2025-03-05T23:04:32Z"
+"OriginalListPrice": 399990
+"OriginatingSystemModificationTimestamp": "2026-01-09T23:12:31Z"
+"OwnerName": "Iten"
+"ParcelNumber": "2009-62-088-00-0079-0"
+"PatioAndPorchFeatures": array:1 [
0 => "Covered"
]
+"PhotosChangeTimestamp": "2025-10-23T21:01:54Z"
+"PhotosCount": 19
+"PostalCity": "Freeport"
+"PostalCodePlus4": "5626"
+"PreviousListPrice": 399990
+"PriceChangeTimestamp": "2025-09-05T14:42:18Z"
+"PropertyCondition": array:1 [
0 => "Actual"
]
+"PurchaseContractDate": "2026-01-08"
+"RoomsTotal": "5"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516 967 8429"
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-09T23:12:31Z"
+"StreetName": "Sportsmans"
+"StreetNumber": "208"
+"StreetNumberNumeric": "208"
+"StreetSuffix": "Avenue"
+"StructureType": array:1 [
0 => "Saltbox"
]
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "8707.34"
+"TaxAssessedValue": 332
+"TaxYear": "2023"
+"Utilities": array:6 [
0 => "Cable Connected"
1 => "Electricity Connected"
2 => "Natural Gas Connected"
3 => "Sewer Connected"
4 => "Trash Collection Public"
5 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WaterfrontFeatures": array:4 [
0 => "Canal Access"
1 => "Canal Front"
2 => "Waterfront"
3 => "Bulkhead"
]
+"WaterfrontYN": true
+"KEY_Attic": "None"
+"KEY_Village": "Freeport"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "379990.00"
+"KEY_ContractPrice": "380000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Active"
+"KEY_IncludedInTaxes": "Trash"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "780.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "487.16667"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "11046220.9302"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "487.16667"
+"KEY_SourceSystemModificationTimestamp": "2025-03-05T16:26:31.397"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "487.16667"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.95000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "487.16667"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418985705')"
+"provider_name": "One Key"
+"Media": array:19 [
0 => array:14 [
"Order" => 0
"MediaKey" => "67c95118c763ee4ccd28cc96"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/bbc984ee32b1c9f2d8e171e1067d3af6.webp"
"MediaSize" => 575316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-bbc984ee32b1c9f2d8e171e1067d3af6.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "View of front of home with a garage and a fenced front yard"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.058Z"
]
1 => array:14 [
"Order" => 1
"MediaKey" => "67c95118c763ee4ccd28cc97"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/04927ac42d2a825b7e0aca4d845724a8.webp"
"MediaSize" => 610788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-04927ac42d2a825b7e0aca4d845724a8.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "View of front of home"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.049Z"
]
2 => array:14 [
"Order" => 2
"MediaKey" => "67c8e1e9c763ee4ccd28a274"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/e4c5cfae38c0241b8d0cfacc8ea2d632.webp"
"MediaSize" => 441352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-e4c5cfae38c0241b8d0cfacc8ea2d632.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "View of home's exterior with fence"
"ShortDescription" => "Side of Structure"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-05T23:44:41.287Z"
]
3 => array:14 [
"Order" => 3
"MediaKey" => "67c95118c763ee4ccd28cc98"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/c0f3c2ad808e69029d7e16ab4e761cd9.webp"
"MediaSize" => 633316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-c0f3c2ad808e69029d7e16ab4e761cd9.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Rear view of house with a water view"
"ShortDescription" => "Back of Structure"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.054Z"
]
4 => array:14 [
"Order" => 4
"MediaKey" => "67c95118c763ee4ccd28cc99"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/4876fa1756892a6de3f4891823a785e6.webp"
"MediaSize" => 505556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-4876fa1756892a6de3f4891823a785e6.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Property view of water featuring a dock"
"ShortDescription" => "View"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:03.973Z"
]
5 => array:14 [
"Order" => 5
"MediaKey" => "67c95118c763ee4ccd28cc9a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/a46d07fe2d5751d5e209f0fd9c29bc0c.webp"
"MediaSize" => 529744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-a46d07fe2d5751d5e209f0fd9c29bc0c.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Dock area featuring a water view"
"ShortDescription" => "Dock"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.173Z"
]
6 => array:14 [
"Order" => 6
"MediaKey" => "67c95118c763ee4ccd28cc9b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/81c4397c131ba8a76e857d765e9e94d0.webp"
"MediaSize" => 451861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-81c4397c131ba8a76e857d765e9e94d0.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Living room with a ceiling fan, wood-type flooring, and beamed ceiling"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.035Z"
]
7 => array:14 [
"Order" => 7
"MediaKey" => "67c95118c763ee4ccd28cc9c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/5fa498bc5d16ddae091d2bf240bbb209.webp"
"MediaSize" => 484134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-5fa498bc5d16ddae091d2bf240bbb209.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Kitchen with open shelves, beam ceiling, and baseboards"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:03.988Z"
]
8 => array:14 [
"Order" => 8
"MediaKey" => "67c95118c763ee4ccd28cc9d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/9d292d65e5f79d97f05896a6768c435c.webp"
"MediaSize" => 431219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-9d292d65e5f79d97f05896a6768c435c.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Living area with ceiling fan, beam ceiling, wood-type flooring, and a wealth of natural light"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.008Z"
]
9 => array:14 [
"Order" => 9
"MediaKey" => "67c95118c763ee4ccd28cc9e"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/e6f27988bbb669ae0a197f383e8c4f7c.webp"
"MediaSize" => 577110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-e6f27988bbb669ae0a197f383e8c4f7c.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Dining area featuring beamed ceiling and ceiling fan"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.034Z"
]
10 => array:14 [
"Order" => 10
"MediaKey" => "67c95118c763ee4ccd28cc9f"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/9790bbeae118d06588a37b243cca5613.webp"
"MediaSize" => 390143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-9790bbeae118d06588a37b243cca5613.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Living area featuring a ceiling fan and beam ceiling"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.055Z"
]
11 => array:14 [
"Order" => 11
"MediaKey" => "67c95118c763ee4ccd28cca0"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/5a15dca6ec851463521ca33fbf6043da.webp"
"MediaSize" => 442437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-5a15dca6ec851463521ca33fbf6043da.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Bedroom with a baseboard heating unit and wood finished floors"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.035Z"
]
12 => array:14 [
"Order" => 12
"MediaKey" => "67c95118c763ee4ccd28cca1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/74a7ac824710de9fa7d3cce274e1e314.webp"
"MediaSize" => 463452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-74a7ac824710de9fa7d3cce274e1e314.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Bedroom with crown molding and wood finished floors"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:03.953Z"
]
13 => array:14 [
"Order" => 13
"MediaKey" => "67c95118c763ee4ccd28cca2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/da02afc8d744d87218224fb9e9c9243e.webp"
"MediaSize" => 445051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-da02afc8d744d87218224fb9e9c9243e.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Sunroom / solarium featuring a healthy amount of sunlight"
"ShortDescription" => "Sun Room"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.022Z"
]
14 => array:14 [
"Order" => 14
"MediaKey" => "67c95118c763ee4ccd28cca3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/15b5d1f7cc104abf3947d899e0291988.webp"
"MediaSize" => 400991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-15b5d1f7cc104abf3947d899e0291988.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Sunroom / solarium with plenty of natural light"
"ShortDescription" => "Sun Room"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.035Z"
]
15 => array:14 [
"Order" => 15
"MediaKey" => "67c95118c763ee4ccd28cca4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/fab433fc77f26f2f92b5fcbef5bbacc1.webp"
"MediaSize" => 179393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-fab433fc77f26f2f92b5fcbef5bbacc1.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Full bath featuring tile patterned flooring and a washtub"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.126Z"
]
16 => array:14 [
"Order" => 16
"MediaKey" => "67c95118c763ee4ccd28cca5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/ae2ee8ef2150040d2c2c3d63f3cd65c4.webp"
"MediaSize" => 434377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-ae2ee8ef2150040d2c2c3d63f3cd65c4.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Full bathroom featuring toilet, a shower with curtain, tile patterned flooring, and vanity"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.054Z"
]
17 => array:14 [
"Order" => 17
"MediaKey" => "67c95118c763ee4ccd28cca6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/f6459bd9f7fa32b4297f55634285fc19.webp"
"MediaSize" => 457353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-f6459bd9f7fa32b4297f55634285fc19.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Half bath with toilet, tile patterned flooring, and vanity"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.081Z"
]
18 => array:14 [
"Order" => 18
"MediaKey" => "67c95118c763ee4ccd28cca7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/b0e053f843072fff95be987e60f76875.webp"
"MediaSize" => 468882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418985705/thumbnail-b0e053f843072fff95be987e60f76875.webp"
"ImageWidth" => 1536
"Permission" => array:1 [ …1]
"ImageHeight" => 2048
"LongDescription" => "Utility room featuring water heater"
"ShortDescription" => "Other"
"ResourceRecordKey" => "418985705"
"ImageSizeDescription" => "1536x2048"
"MediaModificationTimestamp" => "2025-03-06T07:39:04.162Z"
]
]
+"ID": "23808"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4572
+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/reso/odata/Property('KEY418979420')"
+"provider_name": "One Key"
+"Media": array:32 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6901f5c22f10ef2f63d2886a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/a30a380a67b587c357966331f799de90.webp"
"MediaSize" => 372547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-a30a380a67b587c357966331f799de90.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"ShortDescription" => "Other"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.080Z"
]
1 => array:14 [
"Order" => 1
"MediaKey" => "6901f5c22f10ef2f63d2886b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/6f73d85820905a97ca7c44a684f773de.webp"
"MediaSize" => 421098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-6f73d85820905a97ca7c44a684f773de.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "View of road with driveway"
"ShortDescription" => "Community"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.048Z"
]
2 => array:14 [
"Order" => 2
"MediaKey" => "6901f5c22f10ef2f63d2886c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/f1da7477fb29027661145ac3a880f2f4.webp"
"MediaSize" => 180571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-f1da7477fb29027661145ac3a880f2f4.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Hall featuring recessed lighting, ornamental molding, baseboards, light wood-style flooring, and a notable chandelier"
"ShortDescription" => "Other"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.048Z"
]
3 => array:14 [
"Order" => 3
"MediaKey" => "6901f5c22f10ef2f63d2886d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/51c6629677c23887dce647b0ee33f01a.webp"
"MediaSize" => 256496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-51c6629677c23887dce647b0ee33f01a.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Living area with a decorative wall, ornamental molding, and light wood-style floors"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.076Z"
]
4 => array:14 [
"Order" => 4
"MediaKey" => "6901f5c22f10ef2f63d2886e"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/b881a3c79ce2768bc397c7d8362c4704.webp"
"MediaSize" => 226303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-b881a3c79ce2768bc397c7d8362c4704.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Living area featuring arched walkways, a fireplace with flush hearth, wood finished floors, and crown molding"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.052Z"
]
5 => array:14 [
"Order" => 5
"MediaKey" => "6901f5c22f10ef2f63d2886f"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/220b98ba2df2f9f9d5d6dc79cbc49b28.webp"
"MediaSize" => 186879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-220b98ba2df2f9f9d5d6dc79cbc49b28.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Dining area with french doors, a notable chandelier, baseboards, and light wood finished floors"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.102Z"
]
6 => array:14 [
"Order" => 6
"MediaKey" => "6901f5c22f10ef2f63d28870"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/9445841bfaf9cb3528df64e704a4b618.webp"
"MediaSize" => 187142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-9445841bfaf9cb3528df64e704a4b618.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Kitchen with backsplash, a center island, wall chimney range hood, dark countertops, and white cabinets"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.072Z"
]
7 => array:14 [
"Order" => 7
"MediaKey" => "6901f5c22f10ef2f63d28871"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/7a03dec4bc053fcef3a6f68db79ebeea.webp"
"MediaSize" => 262542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-7a03dec4bc053fcef3a6f68db79ebeea.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Kitchen featuring wood finished floors, dark countertops, open floor plan, a breakfast bar area, and wooden ceiling"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.056Z"
]
8 => array:14 [
"Order" => 8
"MediaKey" => "6901f5c22f10ef2f63d28872"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/3fa40c03a610a37df09dbe432d464fa8.webp"
"MediaSize" => 267988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-3fa40c03a610a37df09dbe432d464fa8.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Living area with wood ceiling, recessed lighting, ornamental molding, and wood finished floors"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.052Z"
]
9 => array:14 [
"Order" => 9
"MediaKey" => "6901f5c22f10ef2f63d28873"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/c7f565d7c657ad1ea9c6a9cbdd87a081.webp"
"MediaSize" => 261759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-c7f565d7c657ad1ea9c6a9cbdd87a081.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Living area with wood finished floors, wood ceiling, and recessed lighting"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.070Z"
]
10 => array:14 [
"Order" => 10
"MediaKey" => "6901f5c22f10ef2f63d28874"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/866e9b625beae0682abcdce4ed97dbd0.webp"
"MediaSize" => 212996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-866e9b625beae0682abcdce4ed97dbd0.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Bedroom with ceiling fan and recessed lighting"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.070Z"
]
11 => array:14 [
"Order" => 11
"MediaKey" => "6901f5c22f10ef2f63d28875"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/b3af2c7ee7ae5fb8b72c2fccbc8922d7.webp"
"MediaSize" => 212093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-b3af2c7ee7ae5fb8b72c2fccbc8922d7.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Full bath with decorative backsplash, vanity, tile patterned floors, and recessed lighting"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.058Z"
]
12 => array:14 [
"Order" => 12
"MediaKey" => "6901f5c22f10ef2f63d28876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/6a2d67f01a4ef8582660587817401894.webp"
"MediaSize" => 198111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-6a2d67f01a4ef8582660587817401894.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Bathroom with tile walls, toilet, recessed lighting, vanity, and tile patterned flooring"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.048Z"
]
13 => array:14 [
"Order" => 13
"MediaKey" => "6901f5c22f10ef2f63d28877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/a010238082bcfcc27b216b4a693410b8.webp"
"MediaSize" => 202772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-a010238082bcfcc27b216b4a693410b8.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Carpeted bedroom with recessed lighting and a ceiling fan"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.055Z"
]
14 => array:14 [
"Order" => 14
"MediaKey" => "6901f5c22f10ef2f63d28878"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/f137db23addaf5e4413e599e4de54701.webp"
"MediaSize" => 149700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-f137db23addaf5e4413e599e4de54701.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Bathroom with a stall shower, tile walls, visible vents, and vanity"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.052Z"
]
15 => array:14 [
"Order" => 15
"MediaKey" => "6901f5c22f10ef2f63d28879"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/c55db35a7c8723f6e97a66210333b2a7.webp"
"MediaSize" => 177646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-c55db35a7c8723f6e97a66210333b2a7.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Carpeted bedroom featuring baseboards, access to exterior, and ceiling fan"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.055Z"
]
16 => array:14 [
"Order" => 16
"MediaKey" => "6901f5c22f10ef2f63d2887a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/2ff48aedc0d38073f391b5524466112e.webp"
"MediaSize" => 202658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-2ff48aedc0d38073f391b5524466112e.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Bedroom featuring visible vents, carpet floors, and vaulted ceiling"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.055Z"
]
17 => array:14 [
"Order" => 17
"MediaKey" => "6901f5c22f10ef2f63d2887b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/3223de540e6443b7ccac5cc10b500627.webp"
"MediaSize" => 123650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-3223de540e6443b7ccac5cc10b500627.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Full bath with toilet, a sink, lofted ceiling, visible vents, and double vanity"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.048Z"
]
18 => array:14 [
"Order" => 18
"MediaKey" => "6901f5c22f10ef2f63d2887c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/93006c6dcb8b24ae68914e8a45588b0e.webp"
"MediaSize" => 131871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-93006c6dcb8b24ae68914e8a45588b0e.webp"
"ImageWidth" => 1600
"Permission" => array:1 [ …1]
"ImageHeight" => 1066
"LongDescription" => "Bathroom with a stall shower, vaulted ceiling, toilet, and tile walls"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418979420"
"ImageSizeDescription" => "1600x1066"
"MediaModificationTimestamp" => "2025-10-29T11:08:50.048Z"
]
19 => array:14 [
"Order" => 19
"MediaKey" => "6901f5c22f10ef2f63d2887d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/739d07658f0cbb879eb35834b88b7a03.webp"
"MediaSize" => 180167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418979420/thumbnail-739d07658f0cbb879eb35834b88b7a03.webp"
"ImageWidth" => 1600
…7
]
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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4573
+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/reso/odata/Property('KEY418951154')"
+"provider_name": "One Key"
+"Media": array:2 [
0 => array:14 [ …14]
1 => array:14 [ …14]
]
+"ID": "23780"
}
]
+success: true
+page_size: 6
+page_count: 287
+count: 1720
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=1632&$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) and (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5077
+items: []
+success: true
+page_size: 6
+page_count: 249
+count: 1489
+after_key: ""
}
"RF Response Time" => "0.07 seconds"
]
"RF Cache Key: 20137a337d5784c937e766e4acb097a111f2342ebeb35ccab950d943e7b9d084" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5111
+items: []
+success: true
+page_size: 6
+page_count: 249
+count: 1489
+after_key: ""
}
]
]