array:3 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=1494&$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 {#4529
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4533
+post_id: "25980"
+post_author: 1
+"ListingKey": "KEY420416885"
+"ListingId": "873445"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T21:42:36Z"
+"RFModificationTimestamp": "2026-03-16T21:51:49Z"
+"ListPrice": 1229000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2471.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11581"
+"UnparsedAddress": "797 Caldwell Avenue, Hempstead, New York 11581"
+"Coordinates": array:2 [
0 => -73.724665
1 => 40.6463279
]
+"Latitude": 40.6463279
+"Longitude": -73.724665
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mark Lipner GRI"
+"ListOfficeName": "BERKSHIRE HATHAWAY"
+"ListAgentMlsId": "83128"
+"ListOfficeMlsId": "BHHS04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "New to the market! Welcome to a beautifully maintained 4-bedroom, 3-bathroom home on a spacious 74x100 lot, located on a serene tree-lined street in the highly desirable Hewlett-Woodmere School District. This charming home features a formal living room with vaulted ceilings, a separate dining room, and a large eat-in kitchen with granite countertops and abundant cabinet space. The primary bedroom boasts its own private en-suite bathroom for added comfort and privacy. The expansive lower level includes a generous den, wet bar, and convenient washer and dryer. A 2-car garage provides additional storage and parking. Throughout the home, you'll find gleaming hardwood floors, recessed lighting, and central air conditioning for year-round comfort. Step outside to enjoy the lush, fully fenced backyard – a perfect space for relaxation or entertaining. With its ideal location, ample living space, and modern amenities, this home is a must-see!"
+"Appliances": array:10 [
0 => "Convection Oven"
1 => "Cooktop"
2 => "Dishwasher"
3 => "Dryer"
4 => "Gas Cooktop"
5 => "Gas Oven"
6 => "Microwave"
7 => "Refrigerator"
8 => "Stainless Steel Appliance(s)"
9 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Split Ranch"
]
+"AttributionContact": "516-295-3000"
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [
0 => "Shingle Siding"
1 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-04T20:43:59.472510+00:00"
+"CrossStreet": "Park Ln"
+"CumulativeDaysOnMarket": 285
+"DaysOnMarket": 285
+"Directions": "Park Ln To Caldwell Ave."
+"Disclosures": array:2 [
0 => "Lead Paint"
1 => "Seller Property Disclosure"
]
+"ElementarySchool": "Ogden Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"Exclusions": "Dining Room Chandelier"
+"ExpirationDate": "2026-04-01"
+"ExteriorFeatures": array:1 [
0 => "Garden"
]
+"Fencing": array:1 [
0 => "Fenced"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:3 [
0 => "Baseboard"
1 => "Hot Water"
2 => "Natural Gas"
]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:11 [
0 => "Cathedral Ceiling(s)"
1 => "Ceiling Fan(s)"
2 => "Eat-in Kitchen"
3 => "Entrance Foyer"
4 => "Formal Dining"
5 => "Granite Counters"
6 => "Primary Bathroom"
7 => "Pantry"
8 => "Recessed Lighting"
9 => "Walk-In Closet(s)"
10 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Three Or More"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-298-8457"
+"ListAgentEmail": "mlipner@bhhslaffey.com"
+"ListAgentKey": "326244341"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109740"
+"ListOfficePhone": "516-295-3000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-04"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:8 [
0 => "Back Yard"
1 => "Landscaped"
2 => "Near Public Transit"
3 => "Near School"
4 => "Near Shops"
5 => "Paved"
6 => "Sprinklers In Front"
7 => "Sprinklers In Rear"
]
+"LotSizeAcres": 0.1607
+"LotSizeDimensions": "74x100"
+"LotSizeSquareFeet": 7400
+"MajorChangeTimestamp": "2025-12-22T18:53:33Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-06-04"
+"OriginalEntryTimestamp": "2025-06-04T20:36:10Z"
+"OriginalListPrice": 1350000
+"OriginatingSystemModificationTimestamp": "2026-03-16T21:41:03Z"
+"OtherEquipment": array:1 [
0 => "Compressor"
]
+"OwnerName": "Berkowitz"
+"ParcelNumber": "2089-39-567-00-0009-0"
+"ParkingFeatures": array:2 [
0 => "Driveway"
1 => "Garage"
]
+"PatioAndPorchFeatures": array:1 [
0 => "Patio"
]
+"PhotosChangeTimestamp": "2025-12-30T17:58:36Z"
+"PhotosCount": 45
+"PostalCity": "North Woodmere"
+"PostalCodePlus4": "3618"
+"PreviousListPrice": 1249000
+"PriceChangeTimestamp": "2025-12-22T18:53:33Z"
+"RoomsTotal": "8"
+"SecurityFeatures": array:1 [
0 => "Security System"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-298-8457"
+"ShowingRequirements": array:3 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-06-04T20:36:10Z"
+"StreetName": "Caldwell"
+"StreetNumber": "797"
+"StreetNumberNumeric": "797"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "20172.96"
+"TaxBlock": "567"
+"TaxLot": "9"
+"TaxYear": "2025"
+"Utilities": array:1 [
0 => "Cable Available"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "Partial"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "39"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1229000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_NumberOfKitchens": "1"
+"KEY_OpenHouseUpcoming": "Broker: Sun Mar 22, 2:15PM-3:45PM"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "2471.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "1"
+"KEY_ShowingContactPhone2": "516-295-3000"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_OpenHousePublicUpcoming": "Public: Sun Mar 22, 2:15PM-3:45PM"
+"KEY_RATIO_ListPrice_By_LivingArea": "497.36949"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7647790.9147"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "497.36949"
+"KEY_SourceSystemModificationTimestamp": "2025-06-04T14:01:49.577"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.91037"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420416885')"
+"provider_name": "One Key"
+"Media": array:45 [
0 => array:14 [
"Order" => 0
"MediaKey" => "6954129c43ad045b81f91f94"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/038d78bbd11869d573663ce21ccf63df.webp"
"MediaSize" => 99202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-038d78bbd11869d573663ce21ccf63df.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Split level home featuring brick siding, a garage, a chimney, concrete driveway, and a front yard"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.129Z"
]
1 => array:14 [
"Order" => 1
"MediaKey" => "6954129c43ad045b81f91f95"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/d94260eee2a52f2bb14b117f30ffc54a.webp"
"MediaSize" => 128987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-d94260eee2a52f2bb14b117f30ffc54a.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Tri-level home featuring brick siding, a garage, concrete driveway, a chimney, and a front lawn"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.135Z"
]
2 => array:14 [
"Order" => 2
"MediaKey" => "6954129c43ad045b81f91f96"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/7775b339d8184542f2c51e5937d50b02.webp"
"MediaSize" => 133128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-7775b339d8184542f2c51e5937d50b02.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Split level home with brick siding, an attached garage, concrete driveway, and a front lawn"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.169Z"
]
3 => array:14 [
"Order" => 3
"MediaKey" => "6954129c43ad045b81f91f97"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/7e87c85de0daa3c5d47a320561a83405.webp"
"MediaSize" => 137230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-7e87c85de0daa3c5d47a320561a83405.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Split level home featuring brick siding, an attached garage, driveway, a front yard, and a chimney"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.134Z"
]
4 => array:14 [
"Order" => 4
"MediaKey" => "6954129c43ad045b81f91f98"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/cbfedfe3a202cd4f6e408fe9846635e0.webp"
"MediaSize" => 135279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-cbfedfe3a202cd4f6e408fe9846635e0.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Split level home with brick siding, driveway, and an attached garage"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.166Z"
]
5 => array:14 [
"Order" => 5
"MediaKey" => "6954129c43ad045b81f91f99"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/8e5e898abeac54bbcf2eef75dd5c6404.webp"
"MediaSize" => 166595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-8e5e898abeac54bbcf2eef75dd5c6404.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "View of patio"
"ShortDescription" => "Patio"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.129Z"
]
6 => array:14 [
"Order" => 6
"MediaKey" => "6954129c43ad045b81f91f9a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/a726eea29420b75427abbe49c6964dac.webp"
"MediaSize" => 130514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-a726eea29420b75427abbe49c6964dac.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Back of house featuring brick siding, a patio, and a gate"
"ShortDescription" => "Back of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.129Z"
]
7 => array:14 [
"Order" => 7
"MediaKey" => "6954129c43ad045b81f91f9b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/944532c3504cd54c8bbc2bdfc72f561e.webp"
"MediaSize" => 134842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-944532c3504cd54c8bbc2bdfc72f561e.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Back of house featuring a patio and brick siding"
"ShortDescription" => "Back of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.163Z"
]
8 => array:14 [
"Order" => 8
"MediaKey" => "6954129c43ad045b81f91f9c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/e76bb9c469aaa4d26f128f0a87a47d2e.webp"
"MediaSize" => 141554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-e76bb9c469aaa4d26f128f0a87a47d2e.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Rear view of house with a patio area, cooling unit, brick siding, and a chimney"
"ShortDescription" => "Back of Structure"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.129Z"
]
9 => array:14 [
"Order" => 9
"MediaKey" => "6954129c43ad045b81f91f9d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/d905e26c6746000f9e99c5a6326b0277.webp"
"MediaSize" => 83992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-d905e26c6746000f9e99c5a6326b0277.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Stairway with vaulted ceiling"
"ShortDescription" => "Other"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.167Z"
]
10 => array:14 [
"Order" => 10
"MediaKey" => "6954129c43ad045b81f91f9e"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/8a584f69224e3292172b371c8a0cc6d3.webp"
"MediaSize" => 110764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-8a584f69224e3292172b371c8a0cc6d3.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living room with lofted ceiling, wood finished floors, a chandelier, baseboard heating, and baseboards"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.127Z"
]
11 => array:14 [
"Order" => 11
"MediaKey" => "6954129c43ad045b81f91f9f"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/bc982d5a416ed117d3765a7244001091.webp"
"MediaSize" => 102091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-bc982d5a416ed117d3765a7244001091.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living room featuring lofted ceiling, wood finished floors, and recessed lighting"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.140Z"
]
12 => array:14 [
"Order" => 12
"MediaKey" => "6954129c43ad045b81f91fa0"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/eff984a6630f4e34f1c1b7945806bad7.webp"
"MediaSize" => 113520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-eff984a6630f4e34f1c1b7945806bad7.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living room featuring wood finished floors, vaulted ceiling, stairs, and recessed lighting"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.127Z"
]
13 => array:14 [
"Order" => 13
"MediaKey" => "6954129c43ad045b81f91fa1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/a53a338bdd0dfb4f2d7a481849bb28b7.webp"
"MediaSize" => 120305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-a53a338bdd0dfb4f2d7a481849bb28b7.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living area featuring a chandelier, wood finished floors, stairway, and recessed lighting"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.147Z"
]
14 => array:14 [
"Order" => 14
"MediaKey" => "6954129c43ad045b81f91fa2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/b446c8613b8b793179d7bf76137e15ef.webp"
"MediaSize" => 130363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-b446c8613b8b793179d7bf76137e15ef.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Dining area featuring wooden walls, a chandelier, a baseboard heating unit, and wood finished floors"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.165Z"
]
15 => array:14 [
"Order" => 15
"MediaKey" => "6954129c43ad045b81f91fa3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/b40227c2e5fa8a3621caf97bed3152fa.webp"
"MediaSize" => 133655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-b40227c2e5fa8a3621caf97bed3152fa.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Dining area featuring a chandelier, wood walls, crown molding, and light wood-type flooring"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.119Z"
]
16 => array:14 [
"Order" => 16
"MediaKey" => "6954129c43ad045b81f91fa4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/cc407706a027c8502fd8a25d2e01079c.webp"
"MediaSize" => 109707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-cc407706a027c8502fd8a25d2e01079c.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Dining room with a baseboard heating unit, recessed lighting, and baseboards"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.113Z"
]
17 => array:14 [
"Order" => 17
"MediaKey" => "6954129c43ad045b81f91fa5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/d3b07c171733c9a2cf75c5546ae7d641.webp"
"MediaSize" => 95247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-d3b07c171733c9a2cf75c5546ae7d641.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Dining area with recessed lighting and stairway"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.119Z"
]
18 => array:14 [
"Order" => 18
"MediaKey" => "6954129c43ad045b81f91fa6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/44d47c5e2b114a8e82b74e9004e65d91.webp"
"MediaSize" => 114829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-44d47c5e2b114a8e82b74e9004e65d91.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Kitchen featuring appliances with stainless steel finishes, a sink, recessed lighting, backsplash, and glass insert cabinets"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.115Z"
]
19 => array:14 [
"Order" => 19
"MediaKey" => "6954129c43ad045b81f91fa7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/ed7841db566460aade7f439925f4b3ff.webp"
"MediaSize" => 122117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-ed7841db566460aade7f439925f4b3ff.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Kitchen featuring stainless steel appliances, backsplash, baseboards, recessed lighting, and glass insert cabinets"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.156Z"
]
20 => array:14 [
"Order" => 20
"MediaKey" => "6954129c43ad045b81f91fa8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/796ee0d0ae795c4db7ece30966cd3bb1.webp"
"MediaSize" => 82921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-796ee0d0ae795c4db7ece30966cd3bb1.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Entryway featuring radiator heating unit and baseboards"
"ShortDescription" => "Entry"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.118Z"
]
21 => array:14 [
"Order" => 21
"MediaKey" => "6954129c43ad045b81f91fa9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/94aa9eee2c2f70b724e217ae3a01dc16.webp"
"MediaSize" => 86485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-94aa9eee2c2f70b724e217ae3a01dc16.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living area with carpet, baseboards, and baseboard heating"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.113Z"
]
22 => array:14 [
"Order" => 22
"MediaKey" => "6954129c43ad045b81f91faa"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/b1eea1cf177988e2be7d487837af7d8b.webp"
"MediaSize" => 77766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-b1eea1cf177988e2be7d487837af7d8b.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Carpeted living area featuring baseboards"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.182Z"
]
23 => array:14 [
"Order" => 23
"MediaKey" => "6954129c43ad045b81f91fab"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/3e835795b36066c7dc45029804ca133f.webp"
"MediaSize" => 219911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-3e835795b36066c7dc45029804ca133f.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Bathroom featuring wallpapered walls, a sink, toilet, and tile patterned floors"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.113Z"
]
24 => array:14 [
"Order" => 24
"MediaKey" => "6954129c43ad045b81f91fac"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/9dffdbdbc1060315e4babb0ee00a4c5a.webp"
"MediaSize" => 119796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-9dffdbdbc1060315e4babb0ee00a4c5a.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Indoor dry bar with stairway, wooden walls, carpet floors, recessed lighting, and a textured ceiling"
"ShortDescription" => "Bar"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.150Z"
]
25 => array:14 [
"Order" => 25
"MediaKey" => "6954129c43ad045b81f91fad"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/58a5ab32d1816e071769837002664079.webp"
"MediaSize" => 128341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-58a5ab32d1816e071769837002664079.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Carpeted dining area featuring a bar, wooden walls, a textured ceiling, and a baseboard radiator"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.113Z"
]
26 => array:14 [
"Order" => 26
"MediaKey" => "6954129c43ad045b81f91fae"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/912f3ffbc882cf314d389f2d5df43474.webp"
"MediaSize" => 111301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-912f3ffbc882cf314d389f2d5df43474.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living room with wooden walls and recessed lighting"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.166Z"
]
27 => array:14 [
"Order" => 27
"MediaKey" => "6954129c43ad045b81f91faf"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/de0834194e1ed74377474b2fbb5c3393.webp"
"MediaSize" => 122810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-de0834194e1ed74377474b2fbb5c3393.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living area with carpet floors, a textured ceiling, wooden walls, and bar area"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.118Z"
]
28 => array:14 [
"Order" => 28
"MediaKey" => "6954129c43ad045b81f91fb0"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/1bae3c7a2d67aa0433922a5bb1a6e004.webp"
"MediaSize" => 60114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-1bae3c7a2d67aa0433922a5bb1a6e004.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Laundry room with crown molding, baseboards, and light tile patterned flooring"
"ShortDescription" => "Laundry"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.113Z"
]
29 => array:14 [
"Order" => 29
"MediaKey" => "6954129c43ad045b81f91fb1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/5e66f7cf3905787cdd047a9a17066c37.webp"
"MediaSize" => 147004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-5e66f7cf3905787cdd047a9a17066c37.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Utilities featuring water heater"
"ShortDescription" => "Other"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.151Z"
]
30 => array:14 [
"Order" => 30
"MediaKey" => "6954129c43ad045b81f91fb2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/92c01c9799f799c0d2e942b6abab3b7c.webp"
"MediaSize" => 130767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-92c01c9799f799c0d2e942b6abab3b7c.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 676
"LongDescription" => "Carpeted bedroom with wallpapered walls and ceiling fan"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x676"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.153Z"
]
31 => array:14 [
"Order" => 31
"MediaKey" => "6954129c43ad045b81f91fb3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/bee969904a9b8d34a7575ed8f9e0d76f.webp"
"MediaSize" => 124479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-bee969904a9b8d34a7575ed8f9e0d76f.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 679
"LongDescription" => "Bedroom featuring wallpapered walls, light colored carpet, baseboards, a ceiling fan, and a baseboard heating unit"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x679"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.113Z"
]
32 => array:14 [
"Order" => 32
"MediaKey" => "6954129c43ad045b81f91fb4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/f8e21fd5a4eee857d2bdfa45158058f2.webp"
"MediaSize" => 91502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-f8e21fd5a4eee857d2bdfa45158058f2.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Bathroom featuring toilet, a shower stall, vanity, and tile walls"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.151Z"
]
33 => array:14 [
"Order" => 33
"MediaKey" => "6954129c43ad045b81f91fb5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/08dee20fa4f61a218f434f72ba26b4f1.webp"
"MediaSize" => 125438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-08dee20fa4f61a218f434f72ba26b4f1.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Bathroom featuring a baseboard heating unit, wallpapered walls, toilet, shower / bath combination with glass door, and tile patterned flooring"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.109Z"
]
34 => array:14 [
"Order" => 34
"MediaKey" => "6954129c43ad045b81f91fb6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/b06e808553b1f64d2c7772a15ec8847e.webp"
"MediaSize" => 123358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-b06e808553b1f64d2c7772a15ec8847e.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Full bath featuring baseboard heating, wallpapered walls, vanity, toilet, and tile patterned floors"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.186Z"
]
35 => array:14 [
"Order" => 35
"MediaKey" => "6954129c43ad045b81f91fb7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/14b9ab318c5f657ab73ee7a59acf5b2c.webp"
"MediaSize" => 123396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-14b9ab318c5f657ab73ee7a59acf5b2c.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Bedroom featuring a chandelier, multiple windows, wood walls, dark carpet, and baseboards"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.114Z"
]
36 => array:14 [
"Order" => 36
"MediaKey" => "6954129c43ad045b81f91fb8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/d2e34c4e6a716b1e34194b16e21e174e.webp"
"MediaSize" => 103773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-d2e34c4e6a716b1e34194b16e21e174e.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Bedroom featuring a chandelier, carpet floors, and wooden walls"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.139Z"
]
37 => array:14 [
"Order" => 37
"MediaKey" => "6954129c43ad045b81f91fb9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/57c978cf0fae8007f43298fb89a5c752.webp"
"MediaSize" => 141958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-57c978cf0fae8007f43298fb89a5c752.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Carpeted office with a chandelier and wooden walls"
"ShortDescription" => "Office"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.163Z"
]
38 => array:14 [
"Order" => 38
"MediaKey" => "6954129c43ad045b81f91fba"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/961852de7c0d0566f173a257899aed7c.webp"
"MediaSize" => 115627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-961852de7c0d0566f173a257899aed7c.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Living room with lofted ceiling, recessed lighting, wood finished floors, and baseboard heating"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.109Z"
]
39 => array:14 [
"Order" => 39
"MediaKey" => "6954129c43ad045b81f91fbb"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/e1f2fcdce311b6c354f619a8ae2c0afe.webp"
"MediaSize" => 99447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-e1f2fcdce311b6c354f619a8ae2c0afe.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 683
"LongDescription" => "Garage featuring a garage door opener"
"ShortDescription" => "Garage"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x683"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.104Z"
]
40 => array:14 [
"Order" => 40
"MediaKey" => "6954129c43ad045b81f91fbc"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/45b52dc9d4fbc737db9bfbf6c452e816.webp"
"MediaSize" => 46836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-45b52dc9d4fbc737db9bfbf6c452e816.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 768
"LongDescription" => "Home floor plan"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x768"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.100Z"
]
41 => array:14 [
"Order" => 41
"MediaKey" => "6954129c43ad045b81f91fbd"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/63d0df5352f4da5e70a712cdc1ed9d2e.webp"
"MediaSize" => 48805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-63d0df5352f4da5e70a712cdc1ed9d2e.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 768
"LongDescription" => "Floor plan / room layout"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x768"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.118Z"
]
42 => array:14 [
"Order" => 42
"MediaKey" => "6954129c43ad045b81f91fbe"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/7505879045c1068ce28fbc74afcfa08c.webp"
"MediaSize" => 43350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-7505879045c1068ce28fbc74afcfa08c.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 768
"LongDescription" => "Property floor plan"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x768"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.163Z"
]
43 => array:14 [
"Order" => 43
"MediaKey" => "6954129c43ad045b81f91fbf"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/122920e128580c51d1f9dab17554576a.webp"
"MediaSize" => 53817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-122920e128580c51d1f9dab17554576a.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 768
"LongDescription" => "Property floor plan"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x768"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.134Z"
]
44 => array:14 [
"Order" => 44
"MediaKey" => "6954129c43ad045b81f91fc0"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/350c7001c6fcdcdbf36fbb1f9e136408.webp"
"MediaSize" => 50203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420416885/thumbnail-350c7001c6fcdcdbf36fbb1f9e136408.webp"
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"ImageHeight" => 768
"LongDescription" => "Floor plan / room layout"
"ShortDescription" => "Floor Plan"
"ResourceRecordKey" => "420416885"
"ImageSizeDescription" => "1024x768"
"MediaModificationTimestamp" => "2025-12-30T17:57:48.150Z"
]
]
+"ID": "25980"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5093
+post_id: "30357"
+post_author: 1
+"ListingKey": "KEY420412902"
+"ListingId": "873340"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-15T20:39:53Z"
+"RFModificationTimestamp": "2025-06-15T20:42:09Z"
+"ListPrice": 3750000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 6300.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11559"
+"UnparsedAddress": "8 Stuyvesant Place, Hempstead, New York 11559"
+"Coordinates": array:2 [
0 => -73.723551
1 => 40.617061
]
+"Latitude": 40.617061
+"Longitude": -73.723551
+"YearBuilt": 1936
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jillian Felder"
+"ListOfficeName": "Desimone Real Estate"
+"ListAgentMlsId": "225439"
+"ListOfficeMlsId": "DSMN01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Exquisite Fully Renovated Colonial Home in the Five Towns - Welcome to this magnificent 7-bedroom, 4.5-bathroom Colonial residence, set on a beautiful tree-lined cul-de-sac in the heart of Lawrence. This grand home offers over 6,000 square feet of meticulously designed living space, perfect for both sophisticated entertaining and comfortable family living.\n
Upon entering, you are greeted by a gracious foyer with a stunning dining room to your right and a nice sized living room to your left. At the heart of the home is a gourmet chef’s kitchen, thoughtfully designed with high-end stainless steel appliances, white caesar stone countertops, a generous center island, and a large amount of cabinetry. A large breakfast room overlooks the lush backyard. The home is covered with windows creating an even more opened feel space and beautiful natural light. The main level also features an extra closed room and half bath.\n
The upper level boasts five spacious bedrooms, including a luxurious primary suite complete with a spa-inspired ensuite bathroom and huge walk-in closet. Each additional bedroom offers ample closet space and beautiful natural light, while all bathrooms feature premium fixtures and finishes.\n
Additional highlights include a fully finished basement with recreational space, tons of storage, two bedrooms, 1 full bathroom, and a spacious dedicated laundry room. The beautifully landscaped grounds provide room for outdoor entertaining or future pool installation.\n
Located near many synagogues, shopping, and transportation, this exceptional Colonial is a great find in one of Long Island’s most sought-after communities. Move-in ready and built to impress, this home is the perfect blend of traditional charm and contemporary convenience.
"""
+"Appliances": array:10 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Freezer"
3 => "Gas Cooktop"
4 => "Gas Oven"
5 => "Oven"
6 => "Refrigerator"
7 => "Stainless Steel Appliance(s)"
8 => "Washer"
9 => "Gas Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-534-2200"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 4
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:4 [
0 => "Brick"
1 => "Foam Insulation"
2 => "Frame"
3 => "Stucco"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-05T14:59:53.682866+00:00"
+"CrossStreet": "Sealy Court"
+"CumulativeDaysOnMarket": 3
+"DaysOnMarket": 277
+"DirectionFaces": "East"
+"ElementarySchool": "Lawrence Elementary School-Broadway"
+"ElementarySchoolDistrict": "Lawrence"
+"ExpirationDate": "2026-06-01"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:11 [
0 => "Chefs Kitchen"
1 => "Eat-in Kitchen"
2 => "Entrance Foyer"
3 => "Formal Dining"
4 => "High Ceilings"
5 => "Kitchen Island"
6 => "Primary Bathroom"
7 => "Open Kitchen"
8 => "Stone Counters"
9 => "Walk-In Closet(s)"
10 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:4 [
0 => "Gas Dryer Hookup"
1 => "In Basement"
2 => "Laundry Room"
3 => "Washer Hookup"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "212-464-7932"
+"ListAgentEmail": "jillian@dsregroup.com"
+"ListAgentKey": "326234220"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110973"
+"ListOfficePhone": "516-534-2200"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-01"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1939
+"LotSizeSquareFeet": 8448
+"MajorChangeTimestamp": "2025-06-12T04:30:49Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-06-12"
+"OriginalEntryTimestamp": "2025-06-05T14:53:36Z"
+"OriginalListPrice": 3750000
+"OriginatingSystemModificationTimestamp": "2025-06-15T20:38:23Z"
+"OwnerName": "Aaron Felder"
+"ParcelNumber": "2023-41-086-00-0009-0"
+"ParkingFeatures": array:4 [
0 => "Attached"
1 => "Driveway"
2 => "Garage"
3 => "Garage Door Opener"
]
+"PatioAndPorchFeatures": array:1 [
0 => "Patio"
]
+"PhotosChangeTimestamp": "2025-06-05T14:54:36Z"
+"PhotosCount": 37
+"PostalCity": "Lawrence"
+"PostalCodePlus4": "2417"
+"RoomsTotal": "13"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "212-464-7932"
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-06-12T04:30:49Z"
+"StreetName": "Stuyvesant"
+"StreetNumber": "8"
+"StreetNumberNumeric": "8"
+"StreetSuffix": "Place"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "14668.32"
+"TaxAssessedValue": 952
+"TaxYear": "2023"
+"Utilities": array:1 [
0 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "6300.00"
+"KEY_PreviousStatus": "Coming Soon"
+"KEY_CurrentPrice": "3750000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_ConcessionInPrice": "2.00"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "595.23810"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_Attic": "None"
+"KEY_OpenHouseCount": "1"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "19339865.9103"
+"KEY_ConcessionYN": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_RATIO_ListPrice_By_LivingArea": "595.23810"
+"KEY_SourceSystemModificationTimestamp": "2025-06-04T12:19:50.617"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420412902')"
+"provider_name": "One Key"
+"Media": array:37 [
0 => array:13 [
"Order" => 0
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/3a660ecca96441f9ae1e279a48d43405.webp"
"MediaSize" => 239305
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.322Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-3a660ecca96441f9ae1e279a48d43405.webp"
"ShortDescription" => "Front of Structure"
"MediaKey" => "6841af8d7a0a844d35241165"
"ImageHeight" => 768
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x768"
]
1 => array:13 [
"Order" => 1
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/de246f7ed7fa5091ee83d64459d2889d.webp"
"MediaSize" => 291555
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-de246f7ed7fa5091ee83d64459d2889d.webp"
"ShortDescription" => "Aerial View"
"MediaKey" => "6841af8d7a0a844d35241166"
"ImageHeight" => 768
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x768"
]
2 => array:13 [
"Order" => 2
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/d13654ca1153c261549e098b10cd0c8a.webp"
"MediaSize" => 127363
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.318Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-d13654ca1153c261549e098b10cd0c8a.webp"
"ShortDescription" => "Entry"
"MediaKey" => "6841af8d7a0a844d35241167"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
3 => array:14 [
"Order" => 3
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/7152ebb95276142539af85825c3d650e.webp"
"MediaSize" => 88784
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-7152ebb95276142539af85825c3d650e.webp"
"ShortDescription" => "Entry"
"MediaKey" => "6841af8d7a0a844d35241168"
"LongDescription" => "Staircase with marble finish flooring"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
4 => array:14 [
"Order" => 4
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/9763f4374189d6f798d2fad972af56f1.webp"
"MediaSize" => 93696
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-9763f4374189d6f798d2fad972af56f1.webp"
"ShortDescription" => "Kitchen"
"MediaKey" => "6841af8d7a0a844d35241169"
"LongDescription" => "Kitchen with a built in center island, light marble finish flooring, and backsplash"
"ImageHeight" => 676
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x676"
]
5 => array:14 [
"Order" => 5
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/3b46552b5c8f98426b294b5edb5de812.webp"
"MediaSize" => 96958
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.265Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-3b46552b5c8f98426b294b5edb5de812.webp"
"ShortDescription" => "Kitchen"
"MediaKey" => "6841af8d7a0a844d3524116a"
"LongDescription" => "Kitchen featuring stainless steel appliances, wall chimney exhaust hood, multiple sinks, light countertops, and a large kitchen island"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
6 => array:13 [
"Order" => 6
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/ce739a38a4992884db93c119cec53126.webp"
"MediaSize" => 106347
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.347Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-ce739a38a4992884db93c119cec53126.webp"
"ShortDescription" => "Kitchen"
"MediaKey" => "6841af8d7a0a844d3524116b"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
7 => array:13 [
"Order" => 7
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/cc5a15cced2f0a055e8ff2ff3b414ea7.webp"
"MediaSize" => 89749
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.267Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-cc5a15cced2f0a055e8ff2ff3b414ea7.webp"
"ShortDescription" => "Breakfast Area"
"MediaKey" => "6841af8d7a0a844d3524116c"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
8 => array:14 [
"Order" => 8
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/8ea3deb27506a5c4cd7656a2bb5fa5a8.webp"
"MediaSize" => 102224
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-8ea3deb27506a5c4cd7656a2bb5fa5a8.webp"
"ShortDescription" => "Breakfast Area"
"MediaKey" => "6841af8d7a0a844d3524116d"
"LongDescription" => "Dining space featuring plenty of natural light, light marble finish flooring, and recessed lighting"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
9 => array:14 [
"Order" => 9
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/afa8921606a89e8605881bf6e60c6db7.webp"
"MediaSize" => 87496
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.265Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-afa8921606a89e8605881bf6e60c6db7.webp"
"ShortDescription" => "Kitchen"
"MediaKey" => "6841af8d7a0a844d3524116e"
"LongDescription" => "Washing area + walk-in pantry"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
10 => array:14 [
"Order" => 10
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/7b20aa6950fa993a5108feab27527795.webp"
"MediaSize" => 89509
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.317Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-7b20aa6950fa993a5108feab27527795.webp"
"ShortDescription" => "Dining Area"
"MediaKey" => "6841af8d7a0a844d3524116f"
"LongDescription" => "Dining area featuring dark wood-style floors and recessed lighting"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
11 => array:14 [
"Order" => 11
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/4e88fc26d1261bc0f5649017d3baa41b.webp"
"MediaSize" => 119832
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-4e88fc26d1261bc0f5649017d3baa41b.webp"
"ShortDescription" => "Living Room"
"MediaKey" => "6841af8d7a0a844d35241170"
"LongDescription" => "Living room featuring recessed lighting, and lots of windows"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
12 => array:13 [
"Order" => 12
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/f3f19a0ed56806ad3ce4ff14b5bc6a80.webp"
"MediaSize" => 113369
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.280Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-f3f19a0ed56806ad3ce4ff14b5bc6a80.webp"
"ShortDescription" => "Bonus Room"
"MediaKey" => "6841af8d7a0a844d35241171"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
13 => array:14 [
"Order" => 13
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/7ab98054974a957f7c36832724436b94.webp"
"MediaSize" => 84433
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-7ab98054974a957f7c36832724436b94.webp"
"ShortDescription" => "Other"
"MediaKey" => "6841af8d7a0a844d35241172"
"LongDescription" => "Second floor hall featuring beautifully designed carpet and recessed lighting"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
14 => array:13 [
"Order" => 14
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/0a99b380697431b5f7bb024b4ac02326.webp"
"MediaSize" => 81855
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-0a99b380697431b5f7bb024b4ac02326.webp"
"ShortDescription" => "Primary Bedroom"
"MediaKey" => "6841af8d7a0a844d35241173"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
15 => array:14 [
"Order" => 15
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/9bbad7ea59cdf0430a37213f58fee3c6.webp"
"MediaSize" => 78226
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.256Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-9bbad7ea59cdf0430a37213f58fee3c6.webp"
"ShortDescription" => "Primary Bathroom"
"MediaKey" => "6841af8d7a0a844d35241174"
"LongDescription" => "Full bath with toilet, a shower stall, two vanities, a freestanding bath, and marble finish floors"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
16 => array:13 [
"Order" => 16
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/594da7b0e185b823bf72edb65a784897.webp"
"MediaSize" => 89765
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.237Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-594da7b0e185b823bf72edb65a784897.webp"
"ShortDescription" => "Primary Bathroom"
"MediaKey" => "6841af8d7a0a844d35241175"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
17 => array:13 [
"Order" => 17
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/b53874adb64fa0e071f0c51b157fdab4.webp"
"MediaSize" => 95958
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-b53874adb64fa0e071f0c51b157fdab4.webp"
"ShortDescription" => "Bedroom"
"MediaKey" => "6841af8d7a0a844d35241176"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
18 => array:13 [
"Order" => 18
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/ff459e80b327c4c47dd9cf572b92b698.webp"
"MediaSize" => 112734
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.394Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-ff459e80b327c4c47dd9cf572b92b698.webp"
"ShortDescription" => "Bedroom"
"MediaKey" => "6841af8d7a0a844d35241177"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
19 => array:13 [
"Order" => 19
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/a942b0ef6ef7b34a6e4c6b7be403e0f5.webp"
"MediaSize" => 100317
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.272Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-a942b0ef6ef7b34a6e4c6b7be403e0f5.webp"
"ShortDescription" => "Bedroom"
"MediaKey" => "6841af8d7a0a844d35241178"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
20 => array:13 [
"Order" => 20
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/31ef9667b4c58615a1a189b127fe468d.webp"
"MediaSize" => 63281
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.275Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-31ef9667b4c58615a1a189b127fe468d.webp"
"ShortDescription" => "Bedroom"
"MediaKey" => "6841af8d7a0a844d35241179"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
21 => array:13 [
"Order" => 21
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/1a03aa546095d6ca995c308390a743b1.webp"
"MediaSize" => 98214
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.317Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-1a03aa546095d6ca995c308390a743b1.webp"
"ShortDescription" => "Bathroom"
"MediaKey" => "6841af8d7a0a844d3524117a"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
22 => array:13 [
"Order" => 22
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/9b36aa52088ae304b09f83cae1b8987e.webp"
"MediaSize" => 94152
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-9b36aa52088ae304b09f83cae1b8987e.webp"
"ShortDescription" => "Bathroom"
"MediaKey" => "6841af8d7a0a844d3524117b"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
23 => array:13 [
"Order" => 23
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/d470beb4fb636b95d21af5d9150653ca.webp"
"MediaSize" => 102553
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.256Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-d470beb4fb636b95d21af5d9150653ca.webp"
"ShortDescription" => "Bathroom"
"MediaKey" => "6841af8d7a0a844d3524117c"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
24 => array:13 [
"Order" => 24
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/ea1d234c68ba1b917fab1ad1bef1da72.webp"
"MediaSize" => 59641
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.265Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-ea1d234c68ba1b917fab1ad1bef1da72.webp"
"ShortDescription" => "Basement"
"MediaKey" => "6841af8d7a0a844d3524117d"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
25 => array:13 [
"Order" => 25
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/c052a232a68a879f3744d1b9e2099d6f.webp"
"MediaSize" => 67306
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.265Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-c052a232a68a879f3744d1b9e2099d6f.webp"
"ShortDescription" => "Basement"
"MediaKey" => "6841af8d7a0a844d3524117e"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
26 => array:13 [
"Order" => 26
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/24fe2c67b5a9c054fad06620e9ef2e75.webp"
"MediaSize" => 77093
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-24fe2c67b5a9c054fad06620e9ef2e75.webp"
"ShortDescription" => "Bathroom"
"MediaKey" => "6841af8d7a0a844d3524117f"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
27 => array:13 [
"Order" => 27
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/8adea6fbfee55145dc82dd64ebcf8317.webp"
"MediaSize" => 63791
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.265Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-8adea6fbfee55145dc82dd64ebcf8317.webp"
"ShortDescription" => "Laundry"
"MediaKey" => "6841af8d7a0a844d35241180"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
28 => array:13 [
"Order" => 28
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/6a271eb0d6e2a06cfb01967b2a74bef5.webp"
"MediaSize" => 78614
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.277Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-6a271eb0d6e2a06cfb01967b2a74bef5.webp"
"ShortDescription" => "Bedroom"
"MediaKey" => "6841af8d7a0a844d35241181"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
29 => array:13 [
"Order" => 29
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/2e833923059b803e05e08067c87ef44e.webp"
"MediaSize" => 111039
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.262Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-2e833923059b803e05e08067c87ef44e.webp"
"ShortDescription" => "Bedroom"
"MediaKey" => "6841af8d7a0a844d35241182"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
30 => array:14 [
"Order" => 30
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/113dd1a38422f18aa78837e91423bf48.webp"
"MediaSize" => 267381
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.323Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-113dd1a38422f18aa78837e91423bf48.webp"
"ShortDescription" => "Back of Structure"
"MediaKey" => "6841af8d7a0a844d35241183"
"LongDescription" => "Back of property with an outdoor hangout area, a playground, and stucco siding"
"ImageHeight" => 768
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x768"
]
31 => array:14 [
"Order" => 31
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/b433d41586cedca642705c65a04d7759.webp"
"MediaSize" => 311990
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.273Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-b433d41586cedca642705c65a04d7759.webp"
"ShortDescription" => "Yard"
"MediaKey" => "6841af8d7a0a844d35241184"
"LongDescription" => "View of yard featuring outdoor lounge area, a playground, and option for a pool"
"ImageHeight" => 768
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x768"
]
32 => array:13 [
"Order" => 32
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/a2bf584909a20cc1fa41339e200a13b8.webp"
"MediaSize" => 284973
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.317Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-a2bf584909a20cc1fa41339e200a13b8.webp"
"ShortDescription" => "Aerial View"
"MediaKey" => "6841af8d7a0a844d35241185"
"ImageHeight" => 774
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x774"
]
33 => array:13 [
"Order" => 33
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/7803f4b295d7835ca72d9a797f0c8034.webp"
"MediaSize" => 282183
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.317Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-7803f4b295d7835ca72d9a797f0c8034.webp"
"ShortDescription" => "Aerial View"
"MediaKey" => "6841af8d7a0a844d35241186"
"ImageHeight" => 768
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x768"
]
34 => array:14 [
"Order" => 34
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/890318332f6992da5a9cf85bca44a0a8.webp"
"MediaSize" => 241548
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.322Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-890318332f6992da5a9cf85bca44a0a8.webp"
"ShortDescription" => "Front of Structure"
"MediaKey" => "6841af8d7a0a844d35241187"
"LongDescription" => "Colonial-style house featuring asphalt driveway, an attached garage, brick and stucco siding, a front lawn, and a chimney"
"ImageHeight" => 768
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x768"
]
35 => array:13 [
"Order" => 35
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/995298c847d064da86fbee82e179d27e.webp"
"MediaSize" => 247054
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.281Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-995298c847d064da86fbee82e179d27e.webp"
"ShortDescription" => "Front of Structure"
"MediaKey" => "6841af8d7a0a844d35241188"
"ImageHeight" => 683
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x683"
]
36 => array:13 [
"Order" => 36
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/12505eb3c857f0971ae6b59df9978a46.webp"
"MediaSize" => 238349
"ResourceRecordKey" => "420412902"
"MediaModificationTimestamp" => "2025-06-05T14:54:05.317Z"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420412902/thumbnail-12505eb3c857f0971ae6b59df9978a46.webp"
"ShortDescription" => "Aerial View"
"MediaKey" => "6841af8d7a0a844d35241189"
"ImageHeight" => 768
"ImageWidth" => 1024
"Permission" => array:1 [ …1]
"MediaType" => "webp"
"ImageSizeDescription" => "1024x768"
]
]
+"ID": "30357"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4605
+post_id: "26140"
+post_author: 1
+"ListingKey": "KEY420411615"
+"ListingId": "873302"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-01-23T21:13:36Z"
+"RFModificationTimestamp": "2026-01-23T21:19:16Z"
+"ListPrice": 2700000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 17372.0
+"LivingArea": 0
+"BuildingAreaTotal": 5482.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "On Merrick Ave Merrick Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Ameet Sikka"
+"ListOfficeName": "National Real Estate Agency"
+"ListAgentMlsId": "208146"
+"ListOfficeMlsId": "NTLR01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Newly Renovated Freestanding Commercial Building on a 17,303 sqft corner lot in a Prime North Merrick Location! Exceptional opportunity to own a fully updated brick commercial building offering 5,482 sqft of interior space on a high-traffic main road in North Merrick, NY. This property features: 6 spacious units, each with private entrances, LED lighting, and modern flooring, 5 bathrooms, unfinished basement ideal for storage and utility systems, and private parking lot with 28 spaces, recently repaved with new blacktop and new walkway. Strong tenant mix, including: Dentist, Psychiatrist, Foot Spa, Internal Medicine Doctor, Cardiologist with mini OR and One vacant unit, ready for your business or rental income opportunity. Located close to North Merrick town, Starbucks, restaurants, schools, highways, and major shopping centers, this commercial gem offers both convenience and visibility. High-visibility location on a busy thoroughfare. Ideal for investors or owner users. Don't miss this rare opportunity to own a turn-key commercial property in a thriving community!"
+"AttributionContact": "516-519-4363"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Walk-Out Access"
]
+"BasementYN": true
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BuildingFeatures": array:3 [
0 => "Bathrooms"
1 => "Lobby"
2 => "Mailbox"
]
+"BusinessType": "Dental,Medical,Mixed,Professional/Office"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-778-7771"
+"CoListAgentEmail": "contactsikka@gmail.com"
+"CoListAgentFullName": "Sandeep S. Sikka"
+"CoListAgentKey": "326189806"
+"CoListAgentMlsId": "179239"
+"CoListOfficeKey": "326114175"
+"CoListOfficeMlsId": "NTLR01"
+"CoListOfficeName": "National Real Estate Agency"
+"CoListOfficePhone": "516-888-0884"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-15T01:57:49.660984+00:00"
+"CrossStreet": "Camp Avenue"
+"CumulativeDaysOnMarket": 143
+"DaysOnMarket": 143
+"Directions": "On Merrick Avenue - Cross street is Camp Avenue"
+"Electric": "200+ Amp Service"
+"EntryLevel": 1
+"ExpirationDate": "2027-12-31"
+"Flooring": array:1 [
0 => "Combination"
]
+"FoundationDetails": array:1 [
0 => "Slab"
]
+"Heating": array:1 [
0 => "Oil"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-519-4363"
+"ListAgentEmail": "contactameetsikka@gmail.com"
+"ListAgentKey": "326217497"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114175"
+"ListOfficePhone": "516-888-0884"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-14"
+"LotFeatures": array:1 [
0 => "Corner Lot"
]
+"LotSizeAcres": 0.3988
+"LotSizeSquareFeet": 17372
+"MajorChangeTimestamp": "2026-01-23T21:12:10Z"
+"MajorChangeType": "Hold"
+"MlsStatus": "Hold"
+"NumberOfBuildings": 1
+"NumberOfUnitsTotal": "6"
+"OffMarketDate": "2026-01-23"
+"OnMarketDate": "2025-06-14"
+"OriginalEntryTimestamp": "2025-06-15T01:53:41Z"
+"OriginalListPrice": 2700000
+"OriginatingSystemModificationTimestamp": "2026-01-23T21:12:10Z"
+"OwnerName": "Merrick Corp"
+"ParcelNumber": "2089-56-101-00-0015-0"
+"ParkingFeatures": array:3 [
0 => "Driveway"
1 => "On Street"
2 => "Parking Lot"
]
+"ParkingTotal": "28"
+"PhotosChangeTimestamp": "2025-11-05T00:43:53Z"
+"PhotosCount": 48
+"PostalCity": "Merrick"
+"PropertyCondition": array:1 [
0 => "Updated/Remodeled"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-519-4363"
+"ShowingRequirements": array:2 [
0 => "24 Hour Notice"
1 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-23T21:12:10Z"
+"Stories": "1"
+"StoriesTotal": "2"
+"StreetName": "Merrick"
+"StreetNumber": "On Merrick Ave"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:3 [
0 => "Realtor.com"
1 => "Crexi"
2 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "66887.3"
+"TaxAssessedValue": 12029
+"TaxYear": "2023"
+"Utilities": array:3 [
0 => "Electricity Connected"
1 => "Sewer Connected"
2 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"Zoning": "C"
+"KEY_HoldDate": "2026-01-23"
+"KEY_ElevatorYN": "0"
+"KEY_UsableArea": "5482.00"
+"KEY_CurrentPrice": "2700000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6770310.9328"
+"KEY_SourceSystemModificationTimestamp": "2025-06-04T11:38:31.587"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "492.52098"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "492.52098"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420411615')"
+"provider_name": "One Key"
+"Media": array:48 [
0 => array:14 [
"Order" => 0
"MediaKey" => "68b11a459e739b19d4314b99"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/3ba6ca83b60efe83015c644706a98253.webp"
"MediaSize" => 492886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-3ba6ca83b60efe83015c644706a98253.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"LongDescription" => "View of building exterior with uncovered parking"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.643Z"
]
1 => array:14 [
"Order" => 1
"MediaKey" => "68b11a459e739b19d4314b9a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/87071ef3a490c880a0a2fb61f0fd64c5.webp"
"MediaSize" => 476612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-87071ef3a490c880a0a2fb61f0fd64c5.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"LongDescription" => "View of uncovered parking lot"
"ShortDescription" => "Parking"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.569Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "68b11a459e739b19d4314b9b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/5d295b55e3fdb5b28b5b9e4dd8101f30.webp"
"MediaSize" => 509806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-5d295b55e3fdb5b28b5b9e4dd8101f30.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"ShortDescription" => "Other"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.581Z"
]
3 => array:14 [
"Order" => 3
"MediaKey" => "68b11a459e739b19d4314b9c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/2a3045b6763db729a7c84f42e705d6a6.webp"
"MediaSize" => 501192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-2a3045b6763db729a7c84f42e705d6a6.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"LongDescription" => "View of building exterior"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.579Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "68b11a459e739b19d4314b9d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/d583be9b87f4368d39f361ca0896fb9a.webp"
"MediaSize" => 571311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-d583be9b87f4368d39f361ca0896fb9a.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"ShortDescription" => "Other"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.610Z"
]
5 => array:14 [
"Order" => 5
"MediaKey" => "68b11a459e739b19d4314b9e"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/1bded28536a7d66887aff7ee988bd6c9.webp"
"MediaSize" => 417090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-1bded28536a7d66887aff7ee988bd6c9.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"LongDescription" => "View of uncovered parking lot"
"ShortDescription" => "Parking"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.574Z"
]
6 => array:14 [
"Order" => 6
"MediaKey" => "68b11a459e739b19d4314b9f"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/830b913c92ba4c48ab614742bdc0578d.webp"
"MediaSize" => 281382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-830b913c92ba4c48ab614742bdc0578d.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"LongDescription" => "Living room with light wood finished floors"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.558Z"
]
7 => array:14 [
"Order" => 7
"MediaKey" => "68b11a459e739b19d4314ba0"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/617e4eaa1f2f471cd6a7d62f1135a90c.webp"
"MediaSize" => 306446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-617e4eaa1f2f471cd6a7d62f1135a90c.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"LongDescription" => "Living area featuring wood finished floors and baseboards"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.569Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "68b11a459e739b19d4314ba1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/de7694f23df13b2760fffee154c40190.webp"
"MediaSize" => 256384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-de7694f23df13b2760fffee154c40190.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"ShortDescription" => "Other"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.548Z"
]
9 => array:14 [
"Order" => 9
"MediaKey" => "68b11a459e739b19d4314ba2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/a7154b88fe48e9ea84bd4b6263b3bbdc.webp"
"MediaSize" => 270371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-a7154b88fe48e9ea84bd4b6263b3bbdc.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"LongDescription" => "Foyer entrance featuring light wood-style flooring and baseboards"
"ShortDescription" => "Entry"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.546Z"
]
10 => array:14 [
"Order" => 10
"MediaKey" => "68b11a459e739b19d4314ba3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/8cba769ddbc761501e1c11fcd0bcb96a.webp"
"MediaSize" => 228913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-8cba769ddbc761501e1c11fcd0bcb96a.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"LongDescription" => "Office with wood finished floors and ornamental molding"
"ShortDescription" => "Office"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.532Z"
]
11 => array:14 [
"Order" => 11
"MediaKey" => "68b11a459e739b19d4314ba4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/0746ee1173a8bc7e2ce1164466bd2c0d.webp"
"MediaSize" => 271178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-0746ee1173a8bc7e2ce1164466bd2c0d.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"LongDescription" => "Dining room featuring a desk, light wood-type flooring, and baseboards"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.580Z"
]
12 => array:14 [
"Order" => 12
"MediaKey" => "68b11a459e739b19d4314ba5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/e48ca2221601567684cfedecb6f8cc75.webp"
"MediaSize" => 239877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/thumbnail-e48ca2221601567684cfedecb6f8cc75.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1362
"LongDescription" => "Office with wood finished floors, baseboards, and ornamental molding"
"ShortDescription" => "Office"
"ResourceRecordKey" => "420411615"
"ImageSizeDescription" => "2048x1362"
"MediaModificationTimestamp" => "2025-08-29T03:11:01.558Z"
]
13 => array:14 [
"Order" => 13
"MediaKey" => "68b11a459e739b19d4314ba6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY420411615/473cf2e28f7add42aaf6bd0d2d82484d.webp"
"MediaSize" => 297575
…10
]
14 => array:14 [ …14]
15 => array:14 [ …14]
16 => array:14 [ …14]
17 => array:14 [ …14]
18 => array:14 [ …14]
19 => array:14 [ …14]
20 => array:14 [ …14]
21 => array:14 [ …14]
22 => array:14 [ …14]
23 => array:13 [ …13]
24 => array:14 [ …14]
25 => array:14 [ …14]
26 => array:14 [ …14]
27 => array:14 [ …14]
28 => array:14 [ …14]
29 => array:14 [ …14]
30 => array:14 [ …14]
31 => array:14 [ …14]
32 => array:14 [ …14]
33 => array:14 [ …14]
34 => array:14 [ …14]
35 => array:14 [ …14]
36 => array:14 [ …14]
37 => array:14 [ …14]
38 => array:14 [ …14]
39 => array:14 [ …14]
40 => array:13 [ …13]
41 => array:14 [ …14]
42 => array:14 [ …14]
43 => array:14 [ …14]
44 => array:14 [ …14]
45 => array:14 [ …14]
46 => array:14 [ …14]
47 => array:14 [ …14]
]
+"ID": "26140"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4606
+post_id: "25986"
+post_author: 1
+"ListingKey": "KEY420408569"
+"ListingId": "873207"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2025-09-18T07:06:38Z"
+"RFModificationTimestamp": "2025-09-18T07:08:48Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1753.0
+"BuildingAreaTotal": 1753.0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "2501 Hughes Street, Hempstead, New York 11710"
+"Coordinates": array:2 [
0 => -73.5334401
1 => 40.6633486
]
+"Latitude": 40.6633486
+"Longitude": -73.5334401
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mathias Coni"
+"ListOfficeName": "Oversouth LLC"
+"ListAgentMlsId": "198106"
+"ListOfficeMlsId": "OVRS02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to Hughes Street, a beautifully updated split-level home situated on an oversized 10,000 square foot lot in the heart of Bellmore.This meticulously maintained 4-bedroom, 2-bathroom residence offers a spacious and functional layout ideal for comfortable living. The main level features an open-concept design with a fully renovated kitchen that includes granite countertops, stainless steel appliances, custom cabinetry, and a large center island. Beautiful hardwood floors flow throughout the main living areas, complemented by abundant natural light in the generously sized living room.The upper level features three bedrooms, including a large primary bedroom with a double closet, and a fully renovated hall bathroom with modern finishes. The lower level offers a spacious living den with a separate entrance and an additional fourth bedroom, providing excellent flexibility for guests, extended family, or a private home office. A second fully renovated full bathroom is also located on the lower level.Additional highlights include a full basement with laundry and storage, a 1-car attached garage, and a private driveway. The expansive backyard offers endless possibilities for outdoor enjoyment."
+"Appliances": array:1 [
0 => "ENERGY STAR Qualified Appliances"
]
+"ArchitecturalStyle": array:1 [
0 => "Split Level"
]
+"AttributionContact": "631-770-0030"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerOfficeAOR": "LIBOR"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-776-2826"
+"CoListAgentEmail": "jennajconi@gmail.com"
+"CoListAgentFullName": "Jenna Coni"
+"CoListAgentKey": "326217646"
+"CoListAgentMlsId": "208302"
+"CoListOfficeKey": "406610771"
+"CoListOfficeMlsId": "OVRS02"
+"CoListOfficeName": "Oversouth LLC"
+"CoListOfficePhone": "631-770-0030"
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Frame"
]
+"Cooling": array:2 [
0 => "Ductless"
1 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-18T13:13:20.209082+00:00"
+"CrossStreet": "Argyle Pl"
+"CumulativeDaysOnMarket": 7
+"DaysOnMarket": 7
+"Directions": "Merrick Rd to Argyle to Hughes St"
+"ElementarySchool": "Shore Road School"
+"ElementarySchoolDistrict": "Bellmore"
+"ExpirationDate": "2025-12-05"
+"FireplaceFeatures": array:1 [
0 => "Gas"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:6 [
0 => "First Floor Bedroom"
1 => "Eat-in Kitchen"
2 => "Granite Counters"
3 => "Kitchen Island"
4 => "Open Floorplan"
5 => "Open Kitchen"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-587-3283"
+"ListAgentEmail": "mathiasconi737@gmail.com"
+"ListAgentKey": "326207699"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "406610771"
+"ListOfficePhone": "631-770-0030"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-05"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.2296
+"LotSizeSquareFeet": 10000
+"MajorChangeTimestamp": "2025-09-17T14:29:13Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "Grand Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlsStatus": "Hold"
+"OffMarketDate": "2025-09-17"
+"OnMarketDate": "2025-06-05"
+"OriginalEntryTimestamp": "2025-06-05T11:38:45Z"
+"OriginalListPrice": 799000
+"OriginatingSystemModificationTimestamp": "2025-09-17T14:29:13Z"
+"OwnerName": "Dobrowolski"
+"ParcelNumber": "2089-56-319-00-0712-0"
+"PhotosChangeTimestamp": "2025-06-05T11:40:36Z"
+"PhotosCount": 45
+"PostalCity": "Bellmore"
+"PostalCodePlus4": "4005"
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-587-3283"
+"ShowingRequirements": array:2 [
0 => "24 Hour Notice"
1 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-09-17T14:29:13Z"
+"StreetName": "Hughes"
+"StreetNumber": "2501"
+"StreetNumberNumeric": "2501"
+"StreetSuffix": "Street"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "16157.72"
+"TaxAssessedValue": 537
+"TaxYear": "2023"
+"Utilities": array:1 [
0 => "See Remarks"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "See Remarks"
+"KEY_HoldDate": "2025-09-17"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "799000.00"
+"KEY_ContractPrice": "799000.00"
+"KEY_OpenHouseCount": "4"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "1753.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "455.79007"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3479965.1568"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "455.79007"
+"KEY_SourceSystemModificationTimestamp": "2025-06-04T10:04:37.890"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "455.79007"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "455.79007"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420408569')"
+"provider_name": "One Key"
+"Media": array:45 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:14 [ …14]
5 => array:14 [ …14]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:14 [ …14]
9 => array:14 [ …14]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:14 [ …14]
15 => array:14 [ …14]
16 => array:14 [ …14]
17 => array:14 [ …14]
18 => array:14 [ …14]
19 => array:14 [ …14]
20 => array:14 [ …14]
21 => array:14 [ …14]
22 => array:14 [ …14]
23 => array:14 [ …14]
24 => array:14 [ …14]
25 => array:14 [ …14]
26 => array:14 [ …14]
27 => array:14 [ …14]
28 => array:14 [ …14]
29 => array:14 [ …14]
30 => array:14 [ …14]
31 => array:14 [ …14]
32 => array:14 [ …14]
33 => array:14 [ …14]
34 => array:14 [ …14]
35 => array:14 [ …14]
36 => array:14 [ …14]
37 => array:14 [ …14]
38 => array:14 [ …14]
39 => array:14 [ …14]
40 => array:14 [ …14]
41 => array:14 [ …14]
42 => array:14 [ …14]
43 => array:14 [ …14]
44 => array:14 [ …14]
]
+"ID": "25986"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4570
+post_id: "25928"
+post_author: 1
+"ListingKey": "KEY420340222"
+"ListingId": "869768"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-02-21T07:01:39Z"
+"RFModificationTimestamp": "2026-02-21T07:04:27Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 981.0
+"BuildingAreaTotal": 981.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "259 N Columbus Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [
0 => -73.5789159
1 => 40.66584
]
+"Latitude": 40.66584
+"Longitude": -73.5789159
+"YearBuilt": 1940
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Kevin Iglesias"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "180504"
+"ListOfficeMlsId": "SPH22"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "House Has 4 Bedrooms, 2 Bathrooms, Full Basement. Investor Special. Drive By Only. Amazing Opportunity To Own This Beautiful Home In Freeport. Close To Nautical Mile, All Transportation And Major Shops. Low Taxes. 1 Hour Train Ride To Manhattan!"
+"Appliances": array:1 [
0 => "Other"
]
+"ArchitecturalStyle": array:1 [
0 => "Exp Cape"
]
+"AttributionContact": "631-642-2300"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Frame"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-09-05T19:13:59.404722+00:00"
+"CumulativeDaysOnMarket": 261
+"DaysOnMarket": 261
+"ElementarySchool": "Archer Street School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-02-28"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:1 [
0 => "First Floor Bedroom"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-618-7413"
+"ListAgentEmail": "kevinsoldmyhome@gmail.com"
+"ListAgentKey": "326190979"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115730"
+"ListOfficePhone": "631-642-2300"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-05-31"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.0459
+"LotSizeSquareFeet": 2000
+"MajorChangeTimestamp": "2026-02-20T22:12:02Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlsStatus": "Hold"
+"OffMarketDate": "2026-02-20"
+"OnMarketDate": "2025-05-31"
+"OriginalEntryTimestamp": "2025-06-01T01:24:49Z"
+"OriginalListPrice": 460000
+"OriginatingSystemModificationTimestamp": "2026-02-20T22:12:02Z"
+"OwnerName": "Espalza"
+"ParcelNumber": "2009-55-361-00-1108-0"
+"PhotosChangeTimestamp": "2025-12-01T05:15:37Z"
+"PhotosCount": 1
+"PostalCity": "Freeport"
+"PostalCodePlus4": "1632"
+"PreviousListPrice": 460000
+"PriceChangeTimestamp": "2025-07-02T19:27:40Z"
+"RoomsTotal": "6"
+"Sewer": array:1 [
0 => "Other"
]
+"ShowingContactPhone": "631-618-7413"
+"ShowingRequirements": array:1 [
0 => "Occupied"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-20T22:12:02Z"
+"StreetDirPrefix": "N"
+"StreetName": "Columbus"
+"StreetNumber": "259"
+"StreetNumberNumeric": "259"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "7298.95"
+"TaxAssessedValue": 316
+"TaxYear": "2023"
+"Utilities": array:1 [
0 => "None"
]
+"WaterSource": array:1 [
0 => "Other"
]
+"KEY_Attic": "Full"
+"KEY_HoldDate": "2026-02-20"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "450000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "981.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "458.71560"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "9803921.5686"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "458.71560"
+"KEY_SourceSystemModificationTimestamp": "2025-05-31T21:24:49.577"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "458.71560"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97826"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "458.71560"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420340222')"
+"provider_name": "One Key"
+"Media": array:1 [
0 => array:14 [ …14]
]
+"ID": "25928"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4571
+post_id: "25929"
+post_author: 1
+"ListingKey": "KEY420337218"
+"ListingId": "869679"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-02-25T19:03:36Z"
+"RFModificationTimestamp": "2026-02-25T19:05:27Z"
+"ListPrice": 175000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 700.0
+"City": "Hempstead"
+"PostalCode": "11563"
+"UnparsedAddress": "504 Merrick Road Unit Gf, Hempstead, New York 11563"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Crystin L. Quick SRS"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "208301"
+"ListOfficeMlsId": "DERE58"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "For sale is a stunning ground-floor office space located in the Lynbrook Terrace building, offering an exceptional blend of elegance and functionality. This fully renovated property is ideally situated just blocks from the Long Island Rail Road in the heart of Lynbrook. The space features a sophisticated design with high-end finishes throughout, creating a welcoming and professional atmosphere. Inside, you will find a waiting room, two spacious treatment rooms equipped with sinks, providing versatility for various uses. The office also includes a modern full bathroom with a shower and ample closet space, adding to the convenience and comfort of the environment. Additionally, a laundry room is conveniently located on the same floor, and a serene garden patio at the back of the building offers a perfect outdoor retreat for breaks or meetings. This property boasts dual access points through the main lobby or a side entrance, allowing for flexible and immediate entry. This turn-key office space is ready to be configured to meet your needs, whether you envision it as a high-end corporate office or converted to your own dream workspace. Do not miss this rare opportunity to secure a prime location with all the modern amenities in place."
+"AttributionContact": "516-432-3400"
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Professional/Office"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Ductless"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-01T10:29:18.059256+00:00"
+"CrossStreet": "Crab Or John"
+"CumulativeDaysOnMarket": 513
+"DaysOnMarket": 288
+"Directions": "Crab Ave to Merrick Rd"
+"ExpirationDate": "2026-03-30"
+"Heating": array:2 [
0 => "Natural Gas"
1 => "Baseboard"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-404-7688"
+"ListAgentEmail": "crystin.quick@elliman.com"
+"ListAgentKey": "326217645"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110783"
+"ListOfficePhone": "516-432-3400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-06-01"
+"MajorChangeTimestamp": "2025-06-01T10:26:09Z"
+"MajorChangeType": "New Listing"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-06-01"
+"OriginalEntryTimestamp": "2025-06-01T10:26:09Z"
+"OriginalListPrice": 175000
+"OriginatingSystemModificationTimestamp": "2026-02-25T19:02:26Z"
+"OwnerName": "Facella"
+"PhotosChangeTimestamp": "2025-12-31T18:55:36Z"
+"PhotosCount": 26
+"PostalCity": "Lynbrook"
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-404-7688"
+"ShowingRequirements": array:3 [
0 => "Appointment Only"
1 => "Call Listing Agent"
2 => "See Remarks"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-06-01T10:26:09Z"
+"StreetName": "Merrick"
+"StreetNumber": "504"
+"StreetNumberNumeric": "504"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxYear": "2025"
+"UnitNumber": "GF"
+"Utilities": array:2 [
0 => "Sewer Connected"
1 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"Zoning": "office"
+"KEY_Village": "Lynbrook"
+"KEY_CurrentPrice": "175000.00"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_NumberOfTailBoards": "0"
+"KEY_OverheadDoorHeight": "0"
+"KEY_SourceSystemModificationTimestamp": "2025-05-31T14:55:50.573"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "250.00000"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "250.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420337218')"
+"provider_name": "One Key"
+"Media": array:26 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
4 => array:14 [ …14]
5 => array:14 [ …14]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:14 [ …14]
9 => array:14 [ …14]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:14 [ …14]
15 => array:14 [ …14]
16 => array:14 [ …14]
17 => array:14 [ …14]
18 => array:14 [ …14]
19 => array:14 [ …14]
20 => array:14 [ …14]
21 => array:14 [ …14]
22 => array:14 [ …14]
23 => array:14 [ …14]
24 => array:14 [ …14]
25 => array:14 [ …14]
]
+"ID": "25929"
}
]
+success: true
+page_size: 6
+page_count: 286
+count: 1716
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=1494&$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 {#5075
+items: []
+success: true
+page_size: 6
+page_count: 248
+count: 1486
+after_key: ""
}
"RF Response Time" => "0.07 seconds"
]
"RF Cache Key: 27892e042e659a8ce4b6a20dde45617a3ecc60ff69238a486a907ff4f3dbe910" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5109
+items: []
+success: true
+page_size: 6
+page_count: 248
+count: 1486
+after_key: ""
}
]
]