array:1 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=2496&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000)&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5127
+items: array:12 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5118
+post_id: "24161"
+post_author: 1
+"ListingKey": "KEY418663729"
+"ListingId": "821858"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-01-19T07:01:39Z"
+"RFModificationTimestamp": "2026-01-19T07:07:05Z"
+"ListPrice": 2599000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 1
+"BedroomsTotal": 8.0
+"LotSizeArea": 0
+"LivingArea": 5637.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11598"
+"UnparsedAddress": "339 Midwood Road, Hempstead, New York 11598"
+"Coordinates": array:2 [
0 => -73.338355
1 => 40.708145333333
]
+"Latitude": 40.708145333333
+"Longitude": -73.338355
+"YearBuilt": 1930
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mark Lipner GRI"
+"ListOfficeName": "BERKSHIRE HATHAWAY"
+"ListAgentMlsId": "83128"
+"ListOfficeMlsId": "BHHS04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This exquisite 8+ bedroom, 7-bathroom colonial masterpiece, nestled in the prestigious Woodmere Academy area, offers an unparalleled blend of sophistication, luxury, and functionality. Expansively designed, the home features a private wing with two generously sized bedrooms, a full bath, a kitchenette, and a secluded porch, providing a perfect sanctuary for guests or extended family. Upon entering, you are greeted by an elegant foyer that flows seamlessly into a grand formal living room with a stunning fireplace, a stately dining room, and a private office with built-in bookcases. The main level also boasts an enormous den, a butler's pantry with a washing station. At the heart of the home lies the chef’s dream kitchen, outfitted with premium stainless steel appliances, including double ovens, two dishwashers, two microwaves, dual sinks, and a spacious island with a pull-out pantry, ensuring both style and convenience for the most discerning culinary enthusiast. Sliding glass doors open to a sprawling, fenced-in backyard, ideal for entertaining. The second floor is home to a luxurious master suite with an opulent en-suite bath featuring a jacuzzi tub, a walk-in shower, and a private terrace, alongside five additional spacious bedrooms, three elegant bathrooms, and a well-appointed laundry room. Two expansive attics provide endless storage options. The fully finished basement, with its private exterior entrance, offers an expansive playroom, a state-of-the-art gym, a second laundry area, a full bathroom, additional living space, and generous storage. The home’s exterior boasts a sophisticated blend of stone and vinyl, while inside, six zones of heating and central air ensure the utmost comfort. Ideally located near top-tier schools, fine dining, shopping, transportation, and houses of worship, this exceptional estate defines the pinnacle of luxury living."
+"Appliances": array:13 [
0 => "Cooktop"
1 => "Dishwasher"
2 => "Dryer"
3 => "Electric Oven"
4 => "Gas Cooktop"
5 => "Gas Range"
6 => "Microwave"
7 => "Oven"
8 => "Range"
9 => "Refrigerator"
10 => "Stainless Steel Appliance(s)"
11 => "Washer"
12 => "Gas Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-295-3000"
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Storage Space"
]
+"BasementYN": true
+"BathroomsFull": 6
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [
0 => "Stone"
1 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-02-07T17:24:55.961474+00:00"
+"CrossStreet": "Greenfield Rd"
+"CumulativeDaysOnMarket": 345
+"DaysOnMarket": 345
+"Directions": "Greenfield Rd To Midwood Rd."
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"ExpirationDate": "2026-01-19"
+"ExteriorFeatures": array:3 [
0 => "Balcony"
1 => "Gas Grill"
2 => "Lighting"
]
+"Fencing": array:4 [
0 => "Fenced"
1 => "Full"
2 => "Perimeter"
3 => "Vinyl"
]
+"FireplaceFeatures": array:2 [
0 => "Living Room"
1 => "Wood Burning"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:4 [
0 => "Carpet"
1 => "Hardwood"
2 => "Tile"
3 => "Wood"
]
+"Heating": array:3 [
0 => "Forced Air"
1 => "Natural Gas"
2 => "Steam"
]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:17 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Chefs Kitchen"
3 => "Crown Molding"
4 => "Eat-in Kitchen"
5 => "Entrance Foyer"
6 => "Formal Dining"
7 => "High Ceilings"
8 => "His and Hers Closets"
9 => "Kitchen Island"
10 => "Pantry"
11 => "Quartz/Quartzite Counters"
12 => "Recessed Lighting"
13 => "Soaking Tub"
14 => "Storage"
15 => "Walk-In Closet(s)"
16 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:7 [
0 => "Electric Dryer Hookup"
1 => "Gas Dryer Hookup"
2 => "In Basement"
3 => "In Hall"
4 => "Laundry Room"
5 => "Multiple Locations"
6 => "Washer Hookup"
]
+"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-02-07"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:6 [
0 => "Back Yard"
1 => "Front Yard"
2 => "Landscaped"
3 => "Near Public Transit"
4 => "Near Shops"
5 => "Sprinklers In Front"
]
+"LotSizeAcres": 0.1433
+"LotSizeDimensions": "60x104irr"
+"LotSizeSquareFeet": 6240
+"MajorChangeTimestamp": "2026-01-19T05:11:21Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-01-19"
+"OnMarketDate": "2025-02-07"
+"OriginalEntryTimestamp": "2025-02-07T17:18:31Z"
+"OriginalListPrice": 2599000
+"OriginatingSystemModificationTimestamp": "2026-01-19T05:11:21Z"
+"OtherEquipment": array:1 [
0 => "Compressor"
]
+"OwnerName": "Skurnik"
+"ParcelNumber": "2089-39-128-00-0020-0"
+"ParkingFeatures": array:2 [
0 => "Driveway"
1 => "On Street"
]
+"PatioAndPorchFeatures": array:3 [
0 => "Patio"
1 => "Porch"
2 => "Terrace"
]
+"PhotosChangeTimestamp": "2025-12-31T17:24:36Z"
+"PhotosCount": 49
+"PostalCity": "Woodmere"
+"PostalCodePlus4": "1607"
+"PropertyCondition": array:1 [
0 => "Actual"
]
+"RoomsTotal": "15"
+"SecurityFeatures": array:2 [
0 => "Security Lights"
1 => "Security System"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-298-8457"
+"ShowingRequirements": array:4 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
3 => "Call Listing Office"
]
+"SpaFeatures": array:1 [
0 => "Bath"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-19T05:11:21Z"
+"StreetName": "Midwood"
+"StreetNumber": "339"
+"StreetNumberNumeric": "339"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "34150.23"
+"TaxBlock": "128"
+"TaxLot": "20"
+"TaxYear": "2025"
+"Utilities": array:1 [
0 => "Sewer Connected"
]
+"VirtualTourURLBranded": "https://tour.vht.com/434441340/339-midwood-rd-woodmere-ny-11598"
+"VirtualTourURLUnbranded": "https://tour.vht.com/434441340/idxs"
+"WaterSource": array:1 [
0 => "Public"
]
+"WindowFeatures": array:3 [
0 => "Bay Window(s)"
1 => "Insulated Windows"
2 => "New Windows"
]
+"KEY_Attic": "Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "39"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "2599000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalRooms": "Dining Area,Home Office"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_MlsDistrictCode": "14"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "5637.00"
+"KEY_NumberOfHeatingZones": "6"
+"KEY_ShowingContactPhone2": "516-295-3000"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "461.06085"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "18136775.9944"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "461.06085"
+"KEY_SourceSystemModificationTimestamp": "2025-02-06T15:03:29.690"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418663729')"
+"provider_name": "One Key"
+"Media": array:49 [
0 => array:14 [
"Order" => 0
"MediaKey" => "67b39b8f7d564304acf5298b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/f26d5d395ea1620602f599e08cf77e54.webp"
"MediaSize" => 507433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-f26d5d395ea1620602f599e08cf77e54.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "View of front facade with a front lawn"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-02-17T20:26:55.099Z"
]
1 => array:14 [
"Order" => 1
"MediaKey" => "67b39b8f7d564304acf5298c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/50f074079714dccab19d65d7f16d5888.webp"
"MediaSize" => 562945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-50f074079714dccab19d65d7f16d5888.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "View of front of property with a front yard"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-02-17T20:26:55.100Z"
]
2 => array:14 [
"Order" => 2
"MediaKey" => "67b39b8f7d564304acf5298d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/2c5c70a046d3eac31bea764867053e4f.webp"
"MediaSize" => 595122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-2c5c70a046d3eac31bea764867053e4f.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1365
"LongDescription" => "View of front of home with a front yard"
"ShortDescription" => "Front of Structure"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1365"
"MediaModificationTimestamp" => "2025-02-17T20:26:55.137Z"
]
3 => array:14 [
"Order" => 3
"MediaKey" => "686ed2acf50c5176d6951fe5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/d4c36b46970ec7e0d6e5d495d609bd9c.webp"
"MediaSize" => 192903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-d4c36b46970ec7e0d6e5d495d609bd9c.webp"
"ImageWidth" => 1152
"Permission" => array:1 [ …1]
"ImageHeight" => 1536
"LongDescription" => "Tiled foyer entrance with a chandelier, stairway, ornamental molding, and wallpapered walls"
"ShortDescription" => "Entry"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "1152x1536"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.232Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "686ed2acf50c5176d6951fe6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/42545fd51aab3f81c0c0f2c6dd957c18.webp"
"MediaSize" => 209752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-42545fd51aab3f81c0c0f2c6dd957c18.webp"
"ImageWidth" => 1152
"Permission" => array:1 [ …1]
"ImageHeight" => 1536
"ShortDescription" => "Other"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "1152x1536"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.275Z"
]
5 => array:14 [
"Order" => 5
"MediaKey" => "686ed2acf50c5176d6951fe7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/bf40c3a327dd782b3b5e6772ed7800f3.webp"
"MediaSize" => 273156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-bf40c3a327dd782b3b5e6772ed7800f3.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Living room featuring crown molding, hardwood / wood-style flooring, a fireplace, and french doors"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.257Z"
]
6 => array:14 [
"Order" => 6
"MediaKey" => "686ed2acf50c5176d6951fe8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/feabbb3a86846ac1597b339985ce55a0.webp"
"MediaSize" => 263483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-feabbb3a86846ac1597b339985ce55a0.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Living room with a fireplace, dark wood-type flooring, ornamental molding, and french doors"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.311Z"
]
7 => array:14 [
"Order" => 7
"MediaKey" => "686ed2acf50c5176d6951fe9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/cd24255a907d7b55b006a8a5ec99c37e.webp"
"MediaSize" => 284318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-cd24255a907d7b55b006a8a5ec99c37e.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Living room featuring crown molding, dark wood-type flooring, and a notable chandelier"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.212Z"
]
8 => array:14 [
"Order" => 8
"MediaKey" => "686ed2acf50c5176d6951fea"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/2055f993bbac1f5d636a25a2a3230fc2.webp"
"MediaSize" => 236265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-2055f993bbac1f5d636a25a2a3230fc2.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Dining space featuring ornamental molding, an inviting chandelier, and light wood-type flooring"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.213Z"
]
9 => array:14 [
"Order" => 9
"MediaKey" => "686ed2acf50c5176d6951feb"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/583e9e857d7aaa507bfd9949e1934a1b.webp"
"MediaSize" => 266497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-583e9e857d7aaa507bfd9949e1934a1b.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Dining area with hardwood / wood-style flooring, ornamental molding, and a chandelier"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.264Z"
]
10 => array:14 [
"Order" => 10
"MediaKey" => "686ed2acf50c5176d6951fec"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/8087b2292cd91b2b6f49cd7e7b977ad3.webp"
"MediaSize" => 283829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-8087b2292cd91b2b6f49cd7e7b977ad3.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Office area with ornamental molding"
"ShortDescription" => "Office"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.264Z"
]
11 => array:14 [
"Order" => 11
"MediaKey" => "686ed2acf50c5176d6951fed"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/57535596a6a76cfea5329abd2de373ec.webp"
"MediaSize" => 238135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-57535596a6a76cfea5329abd2de373ec.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Kitchen with decorative backsplash, dark brown cabinets, and light wood-type flooring"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.217Z"
]
12 => array:14 [
"Order" => 12
"MediaKey" => "686ed2acf50c5176d6951fee"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/8a169abfddcab79b0994f117d2f2bd12.webp"
"MediaSize" => 220345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-8a169abfddcab79b0994f117d2f2bd12.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Kitchen with pendant lighting, backsplash, built in appliances, dark brown cabinetry, and wall chimney exhaust hood"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.211Z"
]
13 => array:14 [
"Order" => 13
"MediaKey" => "686ed2acf50c5176d6951fef"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/8331d86175b7d67e57630fda330d5bc7.webp"
"MediaSize" => 223460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-8331d86175b7d67e57630fda330d5bc7.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Kitchen featuring sink, decorative light fixtures, decorative backsplash, and appliances with stainless steel finishes"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.246Z"
]
14 => array:14 [
"Order" => 14
"MediaKey" => "686ed2acf50c5176d6951ff0"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/3bf8490f2e73bc57a61d5c56579e8411.webp"
"MediaSize" => 205920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-3bf8490f2e73bc57a61d5c56579e8411.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Kitchen with sink, a center island, hanging light fixtures, stainless steel appliances, and decorative backsplash"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.277Z"
]
15 => array:14 [
"Order" => 15
"MediaKey" => "686ed2acf50c5176d6951ff1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/7652cce5151eb9c889bf9c6b167c1d33.webp"
"MediaSize" => 178917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-7652cce5151eb9c889bf9c6b167c1d33.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Dining space featuring a notable chandelier"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.259Z"
]
16 => array:14 [
"Order" => 16
"MediaKey" => "686ed2acf50c5176d6951ff2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/241a8a3aed7bf04bbadc15fe20d7f762.webp"
"MediaSize" => 136884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-241a8a3aed7bf04bbadc15fe20d7f762.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Tiled dining area with an inviting chandelier"
"ShortDescription" => "Dining Area"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.253Z"
]
17 => array:14 [
"Order" => 17
"MediaKey" => "686ed2acf50c5176d6951ff3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/a4024dbb34863b99030d573d998f9a87.webp"
"MediaSize" => 228867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-a4024dbb34863b99030d573d998f9a87.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Living room with light tile patterned flooring"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.266Z"
]
18 => array:14 [
"Order" => 18
"MediaKey" => "686ed2acf50c5176d6951ff4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/2db5d55a4a8d6af15583c3fc2917efc3.webp"
"MediaSize" => 187919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-2db5d55a4a8d6af15583c3fc2917efc3.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Living room with a wall mounted air conditioner"
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.279Z"
]
19 => array:14 [
"Order" => 19
"MediaKey" => "686ed2acf50c5176d6951ff5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/c7074e098bfd20d6e492b89c5444807c.webp"
"MediaSize" => 214126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-c7074e098bfd20d6e492b89c5444807c.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1256
"LongDescription" => "Bathroom with vanity, toilet, and tile walls"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1256"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.244Z"
]
20 => array:14 [
"Order" => 20
"MediaKey" => "686ed2acf50c5176d6951ff6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/747cc493c4538ec5f718e91763a697aa.webp"
"MediaSize" => 185603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-747cc493c4538ec5f718e91763a697aa.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Kitchen featuring tasteful backsplash, sink, white cabinets, light tile patterned floors, and stainless steel appliances"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.217Z"
]
21 => array:14 [
"Order" => 21
"MediaKey" => "686ed2acf50c5176d6951ff7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/10a60a75ee628eedfb00575001b607fc.webp"
"MediaSize" => 176755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-10a60a75ee628eedfb00575001b607fc.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1205
"LongDescription" => "Kitchen featuring light tile patterned floors, white cabinets, and stainless steel refrigerator"
"ShortDescription" => "Kitchen"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1205"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.232Z"
]
22 => array:14 [
"Order" => 22
"MediaKey" => "686ed2acf50c5176d6951ff8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/1fee7126f6321843aa19e6997ad92510.webp"
"MediaSize" => 353847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-1fee7126f6321843aa19e6997ad92510.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Bathroom with toilet, an enclosed shower, tile walls, vanity, and backsplash"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.276Z"
]
23 => array:14 [
"Order" => 23
"MediaKey" => "686ed2acf50c5176d6951ff9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/8859411cdc9173c909919e74369bafab.webp"
"MediaSize" => 188547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-8859411cdc9173c909919e74369bafab.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Bedroom featuring multiple windows and light hardwood / wood-style floors"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.232Z"
]
24 => array:14 [
"Order" => 24
"MediaKey" => "686ed2acf50c5176d6951ffa"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/18ca32bbdf1e88c58c2cf9427a3c31c6.webp"
"MediaSize" => 169671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-18ca32bbdf1e88c58c2cf9427a3c31c6.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Bedroom featuring dark hardwood / wood-style floors and a closet"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.196Z"
]
25 => array:14 [
"Order" => 25
"MediaKey" => "686ed2acf50c5176d6951ffb"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/580a032e60ffc3abe8f2275ec299de12.webp"
"MediaSize" => 212723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-580a032e60ffc3abe8f2275ec299de12.webp"
"ImageWidth" => 1152
"Permission" => array:1 [ …1]
"ImageHeight" => 1536
"LongDescription" => "Stairway featuring tile patterned floors"
"ShortDescription" => "Other"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "1152x1536"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.233Z"
]
26 => array:14 [
"Order" => 26
"MediaKey" => "686ed2acf50c5176d6951ffc"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/c83974d7614e28935e9c382c0fca7b73.webp"
"MediaSize" => 189577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-c83974d7614e28935e9c382c0fca7b73.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "Bedroom with radiator and carpet floors"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.216Z"
]
27 => array:14 [
"Order" => 27
"MediaKey" => "686ed2acf50c5176d6951ffd"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/49ba4f82cf7dd72524aa8307fd1b9f79.webp"
"MediaSize" => 310076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-49ba4f82cf7dd72524aa8307fd1b9f79.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1536
"LongDescription" => "Bathroom featuring separate shower and tub, tile walls, and tile patterned floors"
"ShortDescription" => "Bathroom"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1536"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.232Z"
]
28 => array:14 [
"Order" => 28
"MediaKey" => "686ed2acf50c5176d6951ffe"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/5a3d52eed7982f65592db154e07cff36.webp"
"MediaSize" => 230908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-5a3d52eed7982f65592db154e07cff36.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1151
"LongDescription" => "View of bedroom"
"ShortDescription" => "Bedroom"
"ResourceRecordKey" => "418663729"
"ImageSizeDescription" => "2048x1151"
"MediaModificationTimestamp" => "2025-07-09T20:35:56.248Z"
]
29 => array:14 [
"Order" => 29
"MediaKey" => "686ed2acf50c5176d6951fff"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/c42c1c0b5208314f5bc700e5b6c26ca3.webp"
"MediaSize" => 208364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY418663729/thumbnail-c42c1c0b5208314f5bc700e5b6c26ca3.webp"
…8
]
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]
45 => array:14 [ …14]
46 => array:14 [ …14]
47 => array:14 [ …14]
48 => array:14 [ …14]
]
+"ID": "24161"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5120
+post_id: "24699"
+post_author: 1
+"ListingKey": "KEY418660920"
+"ListingId": "821762"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-05-16T07:03:42Z"
+"RFModificationTimestamp": "2025-05-16T08:02:19Z"
+"ListPrice": 759000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1032.0
+"BuildingAreaTotal": 1032.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "30 Franklin Square, Hempstead, New York 11520"
+"Coordinates": array:2 [
0 => -73.687071
1 => 40.7160534
]
+"Latitude": 40.7160534
+"Longitude": -73.687071
+"YearBuilt": 1910
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Angel C. Lemus"
+"ListOfficeName": "Real Broker NY LLC"
+"ListAgentMlsId": "214444"
+"ListOfficeMlsId": "HOWO01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome home! This beautiful cape greets you with 4 bedrooms and 2 bathrooms, central A/C, and central heat, and the property has also been recently updated, come check it out yourself!"
+"Appliances": array:1 [
0 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Exp Cape"
]
+"AttributionContact": "855-450-0442"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-02-06T18:21:55.269937+00:00"
+"CumulativeDaysOnMarket": 99
+"DaysOnMarket": 99
+"Directions": "Mapquest.com"
+"ElementarySchool": "Caroline G Atkinson School"
+"ExpirationDate": "2025-05-16"
+"Heating": array:1 [
0 => "Forced Air"
]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:1 [
0 => "First Floor Bedroom"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-800-9509"
+"ListAgentEmail": "lemustherealtor@gmail.com"
+"ListAgentKey": "326223599"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112133"
+"ListOfficePhone": "855-450-0442"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-02-05"
+"LotSizeAcres": 0.1581
+"LotSizeSquareFeet": 6888
+"MajorChangeTimestamp": "2025-05-16T04:10:52Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-05-16"
+"OnMarketDate": "2025-02-06"
+"OriginalEntryTimestamp": "2025-02-06T18:11:49Z"
+"OriginalListPrice": 759000
+"OriginatingSystemModificationTimestamp": "2025-05-16T04:10:52Z"
+"OwnerName": "USA DREAM LLC"
+"ParcelNumber": "2009-62-047-00-0217-0"
+"PhotosChangeTimestamp": "2025-02-06T18:13:36Z"
+"PhotosCount": 1
+"PostalCity": "Freeport"
+"PostalCodePlus4": "4541"
+"PriceChangeTimestamp": "2025-02-06T18:11:49Z"
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-800-9509"
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-05-16T04:10:52Z"
+"StreetName": "Franklin"
+"StreetNumber": "30"
+"StreetNumberNumeric": "30"
+"StreetSuffix": "Square"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "7370.52"
+"TaxAssessedValue": 332
+"TaxYear": "2023"
+"Utilities": array:2 [
0 => "Natural Gas Available"
1 => "Sewer Available"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "1032.00"
+"KEY_PreviousStatus": "Active"
+"KEY_CurrentPrice": "759000.00"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "735.46512"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "735.46512"
+"KEY_Attic": "Crawl"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "4800759.0133"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "735.46512"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "735.46512"
+"KEY_SourceSystemModificationTimestamp": "2025-02-06T13:11:49.167"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418660920')"
+"provider_name": "One Key"
+"Media": array:1 [
0 => array:14 [ …14]
]
+"ID": "24699"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5117
+post_id: "24692"
+post_author: 1
+"ListingKey": "KEY418660778"
+"ListingId": "821758"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Business"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-10-01T04:21:57Z"
+"RFModificationTimestamp": "2025-10-01T04:49:31Z"
+"ListPrice": 4000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 3116.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "100 E Merrick Road, Hempstead, New York 11580"
+"Coordinates": array:2 [
0 => -73.6508311
1 => 40.656456
]
+"Latitude": 40.656456
+"Longitude": -73.6508311
+"YearBuilt": 1905
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Nelson G. Cardona"
+"ListOfficeName": "Telemundo Realty Corp"
+"ListAgentMlsId": "211384"
+"ListOfficeMlsId": "TEL01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Seize the opportunity to own this versatile commercial property located on bustling E Merrick Road in the heart of Valley Stream. Previously utilized as a successful beauty spa, this property offers a flexible layout suitable for various business ventures. The space boasts high visibility, ample parking, and a well-maintained interior ready for immediate use.\n
\n
Key Features:\n
\n
Prime location with high foot traffic\n
\n
Versatile layout for multiple business types\n
\n
Ample parking space\n
\n
Well-maintained interior, ready for occupancy\n
\n
Close proximity to public transportation and local amenities\n
\n
Don't miss your chance to make this prime location the new home for your business. Contact us today for more details and to schedule a viewing.
"""
+"AttributionContact": "718-205-3737"
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Barber/Beauty"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-02-06T18:12:37.414258+00:00"
+"CumulativeDaysOnMarket": 237
+"DaysOnMarket": 237
+"ExpirationDate": "2025-10-01"
+"Heating": array:2 [
0 => "Forced Air"
1 => "Natural Gas"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseAmountFrequency": "Annually"
+"LeaseTerm": "12 Months"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-285-3074"
+"ListAgentEmail": "nelsonghomes@gmail.com"
+"ListAgentKey": "326220635"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115982"
+"ListOfficePhone": "718-205-3737"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-02-06"
+"MajorChangeTimestamp": "2025-10-01T04:21:23Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-10-01"
+"OnMarketDate": "2025-02-06"
+"OriginalEntryTimestamp": "2025-02-06T18:04:13Z"
+"OriginalListPrice": 4000
+"OriginatingSystemModificationTimestamp": "2025-10-01T04:21:23Z"
+"OwnerName": "104 E MERRICK LLC"
+"PhotosChangeTimestamp": "2025-10-01T04:21:57Z"
+"PhotosCount": 14
+"PostalCity": "Valley Stream"
+"PriceChangeTimestamp": "2025-02-06T18:04:13Z"
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "347-285-3074"
+"ShowingRequirements": array:3 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-10-01T04:21:23Z"
+"StreetDirPrefix": "E"
+"StreetName": "MERRICK"
+"StreetNumber": "100"
+"StreetNumberNumeric": "100"
+"StreetSuffix": "Road"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "24051"
+"TaxAssessedValue": 2708
+"TaxYear": "2024"
+"Utilities": array:1 [
0 => "See Remarks"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_SubleaseYN": "0"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "4000.00"
+"KEY_BuildToSuitYN": "0"
+"KEY_LeasePriceUnit": "Total"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_InvestmentPropertyYN": "0"
+"KEY_SourceSystemModificationTimestamp": "2025-02-06T13:04:13.607"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.28370"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.28370"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418660778')"
+"provider_name": "One Key"
+"Media": array:14 [
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:13 [ …13]
9 => array:13 [ …13]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
]
+"ID": "24692"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5121
+post_id: "26009"
+post_author: 1
+"ListingKey": "KEY418660537"
+"ListingId": "821745"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-02-23T07:01:37Z"
+"RFModificationTimestamp": "2026-02-23T07:04:33Z"
+"ListPrice": 500000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 4521.0
+"BuildingAreaTotal": 5662.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "296 Pine Street, Hempstead, New York 11520"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1897
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "SMS Kabir"
+"ListOfficeName": "SMS World Realty Inc"
+"ListAgentMlsId": "116156"
+"ListOfficeMlsId": "KSMS01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
SHORT SALE SUB. TO 3RD PARTY OR BANK APPROVAL NEEDED.\n
\n
UNDER CONTRACT NO MORE SHOWING., STILL TAKING BACK OF OFFER UNTILL JUNE 15,2025 . BANK ASKING MORE THE LISTING PRICE.
"""
+"Appliances": array:4 [
0 => "Electric Oven"
1 => "Freezer"
2 => "Gas Range"
3 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "A-Frame"
]
+"AttributionContact": "718-207-0025"
+"Basement": array:1 [
0 => "Crawl Space"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Aluminum Siding"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-06-05T18:26:40.543884+00:00"
+"CumulativeDaysOnMarket": 170
+"DaysOnMarket": 170
+"ElementarySchool": "Bayview Avenue School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2027-02-01"
+"Heating": array:2 [
0 => "Natural Gas"
1 => "Steam"
]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:4 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Eat-in Kitchen"
3 => "Open Kitchen"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "718-207-0025"
+"ListAgentEmail": "Sobyrealty2004@yahoo.com"
+"ListAgentKey": "326131819"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112985"
+"ListOfficePhone": "718-207-0025"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-02-01"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.2296
+"LotSizeSquareFeet": 10000
+"MajorChangeTimestamp": "2026-02-22T23:55:47Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlsStatus": "Hold"
+"OffMarketDate": "2026-02-22"
+"OnMarketDate": "2025-02-06"
+"OriginalEntryTimestamp": "2025-02-06T17:48:13Z"
+"OriginalListPrice": 399999
+"OriginatingSystemModificationTimestamp": "2026-02-22T23:55:47Z"
+"OwnerName": "ANDERA FAGAN"
+"ParcelNumber": "2009-54-084-00-0007-0"
+"PhotosChangeTimestamp": "2025-10-03T20:17:42Z"
+"PhotosCount": 4
+"PostalCity": "Freeport"
+"PostalCodePlus4": "3246"
+"PreviousListPrice": 399999
+"PriceChangeTimestamp": "2025-06-12T16:17:26Z"
+"RoomsTotal": "10"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "7182070025"
+"ShowingRequirements": array:2 [
0 => "Call Listing Agent"
1 => "Occupied"
]
+"SpecialListingConditions": array:2 [
0 => "In Foreclosure"
1 => "Short Sale"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-22T23:55:47Z"
+"StreetName": "Pine"
+"StreetNumber": "296"
+"StreetNumberNumeric": "296"
+"StreetSuffix": "Street"
+"StructureType": array:1 [
0 => "Townhouse"
]
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "14955.71"
+"TaxAssessedValue": 650
+"TaxYear": "2023"
+"Utilities": array:1 [
0 => "Electricity Available"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "Finished"
+"KEY_HoldDate": "2026-02-22"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "500000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "4521.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "110.59500"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "2177700.3484"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "110.59500"
+"KEY_SourceSystemModificationTimestamp": "2025-02-06T12:48:13.543"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "88.30802"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.25000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "88.30802"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418660537')"
+"provider_name": "One Key"
+"Media": array:4 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:14 [ …14]
]
+"ID": "26009"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5119
+post_id: "24519"
+post_author: 1
+"ListingKey": "KEY418653153"
+"ListingId": "821568"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-02-08T07:01:37Z"
+"RFModificationTimestamp": "2026-02-08T07:03:27Z"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1260.0
+"BuildingAreaTotal": 1260.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "235 Dogwood Road, Hempstead, New York 11580"
+"Coordinates": array:2 [
0 => -73.703468004435
1 => 40.67248065
]
+"Latitude": 40.67248065
+"Longitude": -73.703468004435
+"YearBuilt": 1949
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Donald Augustin"
+"ListOfficeName": "Charles Rutenberg Realty Inc"
+"ListAgentMlsId": "210555"
+"ListOfficeMlsId": "CHRU01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Cash Only! Drive By Only! Inspections of this property and contact with occupants are strictly prohibited. Property is sold "as Is". Submit all offers to listing agent. Buyer to complete Own Due Diligence."
+"Appliances": array:1 [
0 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Cape Cod"
]
+"AttributionContact": "rpfeffer@crrli.net"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-02-06T01:31:38.747523+00:00"
+"CrossStreet": "Fletcher Ave"
+"CumulativeDaysOnMarket": 368
+"DaysOnMarket": 368
+"ElementarySchool": "Wheeler Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-02-08"
+"Fencing": array:1 [
0 => "None"
]
+"Flooring": array:1 [
0 => "Carpet"
]
+"Heating": array:1 [
0 => "Oil"
]
+"HighSchool": "Contact Agent"
+"HighSchoolDistrict": "Valley Stream - 13"
+"InteriorFeatures": array:3 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Master Downstairs"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-668-6953"
+"ListAgentEmail": "donald.augustin@crrnys.com"
+"ListAgentKey": "326219817"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110310"
+"ListOfficePhone": "516-575-7500"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-02-05"
+"ListingTerms": "Cash"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1512
+"LotSizeSquareFeet": 6586
+"MajorChangeTimestamp": "2026-02-08T05:11:45Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Call Listing Agent"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream - 13"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-02-08"
+"OnMarketDate": "2025-02-05"
+"OriginalEntryTimestamp": "2025-02-06T01:26:45Z"
+"OriginalListPrice": 850000
+"OriginatingSystemModificationTimestamp": "2026-02-08T05:11:45Z"
+"OwnerName": "Marie"
+"ParcelNumber": "2035-37-541-00-0043-0"
+"ParkingFeatures": array:1 [
0 => "Driveway"
]
+"PatioAndPorchFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2025-11-20T22:25:37Z"
+"PhotosCount": 1
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "4032"
+"PriceChangeTimestamp": "2025-02-06T01:26:45Z"
+"PropertyCondition": array:1 [
0 => "Fixer"
]
+"RoomsTotal": "6"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [
0 => "See Remarks"
]
+"SpecialListingConditions": array:1 [
0 => "Third Party Approval"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-08T05:11:45Z"
+"StreetName": "Dogwood"
+"StreetNumber": "235"
+"StreetNumberNumeric": "235"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "16835"
+"TaxAssessedValue": 453
+"TaxYear": "2023"
+"Utilities": array:1 [
0 => "None"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "None"
+"KEY_Village": "Valley Stream"
+"KEY_TaxSource": "Other"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "850000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_MlsDistrictCode": "13"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "1260.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "674.60317"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5621693.1217"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "674.60317"
+"KEY_SourceSystemModificationTimestamp": "2025-02-05T20:26:45.097"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "674.60317"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "674.60317"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418653153')"
+"provider_name": "One Key"
+"Media": array:1 [
0 => array:14 [ …14]
]
+"ID": "24519"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5116
+post_id: "23927"
+post_author: 1
+"ListingKey": "KEY418650544"
+"ListingId": "821486"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-08-02T07:03:37Z"
+"RFModificationTimestamp": "2025-08-02T07:07:06Z"
+"ListPrice": 249999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1000.0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "1177-1183 Broadway, Hempstead, New York 11557"
+"Coordinates": array:2 [
0 => -73.7004475
1 => 40.6393452
]
+"Latitude": 40.6393452
+"Longitude": -73.7004475
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Anadesis Miranda CBR"
+"ListOfficeName": "Exit Family Realty"
+"ListAgentMlsId": "195405"
+"ListOfficeMlsId": "BRMU01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Don't miss this opportunity to purchase a high end Beauty & Day Spa in the heart of Hewlett. Totally renovated with a full basement . All included, a must see! Near shopping and transportation. Security System included."
+"AttributionContact": "631-450-4777"
+"Basement": array:1 [
0 => "Finished"
]
+"BasementYN": true
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Commercial,Other"
+"ConstructionMaterials": array:1 [
0 => "Other"
]
+"Cooling": array:2 [
0 => "Electric"
1 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-02-05T21:54:14.468905+00:00"
+"CrossStreet": "Franklin Ave"
+"CumulativeDaysOnMarket": 178
+"DaysOnMarket": 178
+"Directions": "Broadway in Hewlett, off of Franklin Ave"
+"ExpirationDate": "2025-08-02"
+"FoundationDetails": array:1 [
0 => "Other"
]
+"Heating": array:1 [
0 => "Electric"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-312-6069"
+"ListAgentEmail": "homesbyanamiranda@gmail.com"
+"ListAgentKey": "326205119"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109959"
+"ListOfficePhone": "631-450-4777"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-02-05"
+"MajorChangeTimestamp": "2025-08-02T04:14:35Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-08-02"
+"OnMarketDate": "2025-02-05"
+"OriginalEntryTimestamp": "2025-02-05T21:45:14Z"
+"OriginalListPrice": 299999
+"OriginatingSystemModificationTimestamp": "2025-08-02T04:14:35Z"
+"OwnerName": "Rubinov"
+"PhotosChangeTimestamp": "2025-02-05T21:46:36Z"
+"PhotosCount": 14
+"PostalCity": "Hewlett"
+"PreviousListPrice": 289999
+"PriceChangeTimestamp": "2025-04-29T15:27:17Z"
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "917--312-6069"
+"ShowingRequirements": array:2 [
0 => "Call Listing Agent"
1 => "Showing Service"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-08-02T04:14:35Z"
+"StreetName": "Broadway"
+"StreetNumber": "1177-1183"
+"StreetNumberNumeric": "1177"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxYear": "2025"
+"Utilities": array:1 [
0 => "None"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_CurrentPrice": "249999.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_OpenHousePublicCount": "0"
+"KEY_SourceSystemModificationTimestamp": "2025-02-05T16:35:13.403"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "249.99900"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.83333"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "249.99900"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418650544')"
+"provider_name": "One Key"
+"Media": array:14 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
]
+"ID": "23927"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5115
+post_id: "24697"
+post_author: 1
+"ListingKey": "KEY418648700"
+"ListingId": "821420"
+"PropertyType": "Residential Income"
+"PropertySubType": "Duplex"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-07-31T07:02:37Z"
+"RFModificationTimestamp": "2025-07-31T07:10:13Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1384.0
+"City": "Hempstead"
+"PostalCode": "11563"
+"UnparsedAddress": "29 Everett Street, Hempstead, New York 11563"
+"Coordinates": array:2 [
0 => -73.6857706
1 => 40.9590725
]
+"Latitude": 40.9590725
+"Longitude": -73.6857706
+"YearBuilt": 1925
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Aminta X. Borja"
+"ListOfficeName": "Winzone Realty Inc"
+"ListAgentMlsId": "173429"
+"ListOfficeMlsId": "WIN02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
This exceptional multifamily detached residential home with private driveway and garage, offers excellent potential for investors or homeowners seeking rental income\n
Whole house newly renovated\n
1st Fl has 2 bedrooms living room kitchen and bathroom access to back yard\n
2nd Fl duplex 2bed 1bath living area and kitchen (attic)\n
Fully finished basement, AC heating and cooling from a split system, Two independent brand-new boilers, Brand new electrical system, Brand-new plumbing.
"""
+"AttributionContact": "917-502-7225"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Other"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-02-05T20:28:32.228070+00:00"
+"CumulativeDaysOnMarket": 176
+"DaysOnMarket": 176
+"ElementarySchoolDistrict": "Lynbrook"
+"ExpirationDate": "2025-07-31"
+"FoundationDetails": array:1 [
0 => "Other"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Other"
]
+"HighSchool": "Lynbrook Senior High School"
+"HighSchoolDistrict": "Lynbrook"
+"InteriorFeatures": array:1 [
0 => "Other"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-502-7225"
+"ListAgentEmail": "amintaborja@gmail.com"
+"ListAgentKey": "326184440"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326116457"
+"ListOfficePhone": "718-899-7000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-02-05"
+"LotSizeAcres": 0.0918
+"LotSizeSquareFeet": 4000
+"MajorChangeTimestamp": "2025-07-31T04:11:06Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchoolDistrict": "Lynbrook"
+"MlsStatus": "Expired"
+"NumberOfUnitsTotal": "2"
+"OffMarketDate": "2025-07-31"
+"OnMarketDate": "2025-02-05"
+"OriginalEntryTimestamp": "2025-02-05T20:19:27Z"
+"OriginalListPrice": 950000
+"OriginatingSystemModificationTimestamp": "2025-07-31T04:11:06Z"
+"OwnerName": "Sanchez"
+"ParcelNumber": "2025-42-168-01-0113-0"
+"PhotosChangeTimestamp": "2025-06-18T14:22:36Z"
+"PhotosCount": 11
+"PostalCity": "Lynbrook"
+"PostalCodePlus4": "3230"
+"Sewer": array:1 [
0 => "Other"
]
+"ShowingContactPhone": "917-502-7225"
+"ShowingRequirements": array:3 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-07-31T04:11:06Z"
+"StreetName": "Everett"
+"StreetNumber": "29"
+"StreetNumberNumeric": "29"
+"StreetSuffix": "Street"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "12897"
+"TaxYear": "2024"
+"Utilities": array:1 [
0 => "See Remarks"
]
+"WaterSource": array:1 [
0 => "Other"
]
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "950000.00"
+"KEY_NumOf1BedRooms": "0"
+"KEY_NumOf2BedRooms": "2"
+"KEY_NumOf3BedRooms": "0"
+"KEY_NumOf4BedRooms": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "10348583.8780"
+"KEY_SourceSystemModificationTimestamp": "2025-02-05T15:13:44.400"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "686.41618"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "686.41618"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418648700')"
+"provider_name": "One Key"
+"Media": array:11 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:13 [ …13]
3 => array:14 [ …14]
4 => array:14 [ …14]
5 => array:14 [ …14]
6 => array:14 [ …14]
7 => array:14 [ …14]
8 => array:14 [ …14]
9 => array:14 [ …14]
10 => array:14 [ …14]
]
+"ID": "24697"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5122
+post_id: "24667"
+post_author: 1
+"ListingKey": "KEY418648095"
+"ListingId": "821399"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-03T17:39:36Z"
+"RFModificationTimestamp": "2026-05-03T17:42:40Z"
+"ListPrice": 1849000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 3375.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11581"
+"UnparsedAddress": "748 Sherwood Street, Hempstead, New York 11581"
+"Coordinates": array:2 [
0 => -73.72758865871
1 => 40.6455589
]
+"Latitude": 40.6455589
+"Longitude": -73.72758865871
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Carol Braunstein"
+"ListOfficeName": "BERKSHIRE HATHAWAY"
+"ListAgentMlsId": "171852"
+"ListOfficeMlsId": "BHHS04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome Home to this Beautiful and Expansive Colonial located in a very highly desirable Prime area of North Woodmere. This impressive home has approximately 3,375 square feet of living space and features six generously sized bedrooms, all conveniently located on the second floor, each offering abundant closet space. Two of the bedrooms have ensuite full bathrooms. The large, updated kitchen is designed for both functionality and style, complete with granite countertops and stainless steel appliances. Just off the kitchen, an inviting den with a fireplace creates the perfect setting for comfortable gatherings and everyday living. Step outside to a fenced-in backyard featuring a huge Trex deck—ideal for outdoor entertaining and relaxation. Additional features include an enormous basement with exceptionally high ceilings, a two car attached garage with very high ceilings & laundry on 1st floor. Conveniently situated just minutes from the LIRR, shopping, beaches, houses of worship and beautiful North Woodmere Park."
+"Appliances": array:7 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Electric Range"
3 => "Microwave"
4 => "Refrigerator"
5 => "Stainless Steel Appliance(s)"
6 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-295-3000"
+"Basement": array:2 [
0 => "Full"
1 => "Unfinished"
]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"CommunityFeatures": array:2 [
0 => "Park"
1 => "Playground"
]
+"ConstructionMaterials": array:2 [
0 => "Aluminum Siding"
1 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-02-10T16:12:47.019253+00:00"
+"CrossStreet": "Park Lane"
+"CumulativeDaysOnMarket": 447
+"DaysOnMarket": 447
+"Directions": "Hungry Harbor Road to Park Lane to Sherwood Street."
+"ElementarySchool": "Lawrence Early Childhood-#4 School"
+"ElementarySchoolDistrict": "Lawrence"
+"ExpirationDate": "2026-08-31"
+"Fencing": array:1 [
0 => "Back Yard"
]
+"FireplaceFeatures": array:1 [
0 => "Family Room"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete Perimeter"
]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:2 [
0 => "Baseboard"
1 => "Oil"
]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:4 [
0 => "Eat-in Kitchen"
1 => "Entrance Foyer"
2 => "Granite Counters"
3 => "Kitchen Island"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Three Or More"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-592-2206"
+"ListAgentEmail": "cbraunstein@bhhslaffey.com"
+"ListAgentKey": "326182971"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109740"
+"ListOfficePhone": "516-295-3000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-02-10"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1492
+"LotSizeDimensions": "65x100"
+"LotSizeSquareFeet": 6500
+"MajorChangeTimestamp": "2026-04-20T13:35:43Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-02-10"
+"OriginalEntryTimestamp": "2025-02-10T16:09:24Z"
+"OriginalListPrice": 2398000
+"OriginatingSystemModificationTimestamp": "2026-05-03T17:38:18Z"
+"OwnerName": "Grun"
+"ParcelNumber": "2089-39-605-00-0011-0"
+"ParkingFeatures": array:3 [
0 => "Attached"
1 => "Driveway"
2 => "Garage"
]
+"PatioAndPorchFeatures": array:1 [
0 => "Deck"
]
+"PhotosChangeTimestamp": "2026-04-22T15:01:36Z"
+"PhotosCount": 31
+"PostalCity": "North Woodmere"
+"PreviousListPrice": 1875000
+"PriceChangeTimestamp": "2026-04-20T13:35:43Z"
+"RoomsTotal": "10"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-592-2206"
+"ShowingRequirements": array:5 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
3 => "Call Listing Office"
4 => "No Lockbox"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-02-10T16:09:24Z"
+"StreetName": "Sherwood"
+"StreetNumber": "748"
+"StreetNumberNumeric": "748"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "16017.01"
+"TaxBlock": "605"
+"TaxLot": "11"
+"TaxYear": "2025"
+"Utilities": array:1 [
0 => "Sewer Available"
]
+"VirtualTourURLBranded": "https://app.realtorsessentials.com/748-Sherwood-St"
+"VirtualTourURLUnbranded": "https://app.realtorsessentials.com/748-Sherwood-St/idx"
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "Partial"
+"KEY_TaxSource": "Other"
+"KEY_TaxSection": "39"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1849000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_AdditionalRooms": "Dining Area,Library/Den"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "3375.00"
+"KEY_NumberOfHeatingZones": "4"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-295-3000"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "547.85185"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "12392761.3941"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "547.85185"
+"KEY_SourceSystemModificationTimestamp": "2025-02-05T14:44:24.907"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.77106"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418648095')"
+"provider_name": "One Key"
+"Media": array:31 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:13 [ …13]
6 => array:12 [ …12]
7 => array:13 [ …13]
8 => array:12 [ …12]
9 => array:14 [ …14]
10 => array:14 [ …14]
11 => array:14 [ …14]
12 => array:14 [ …14]
13 => array:14 [ …14]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:13 [ …13]
17 => array:12 [ …12]
18 => array:14 [ …14]
19 => array:14 [ …14]
20 => array:14 [ …14]
21 => array:14 [ …14]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
29 => array:14 [ …14]
30 => array:14 [ …14]
]
+"ID": "24667"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5123
+post_id: "24008"
+post_author: 1
+"ListingKey": "KEY418643606"
+"ListingId": "821260"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-06T07:01:39Z"
+"RFModificationTimestamp": "2026-01-06T07:04:41Z"
+"ListPrice": 2150000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 5406.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "30 Thixton Drive, Hempstead, New York 11557"
+"Coordinates": array:2 [
0 => -73.678203102204
1 => 40.63061165
]
+"Latitude": 40.63061165
+"Longitude": -73.678203102204
+"YearBuilt": 1957
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Gil R. Shemtov"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "172225"
+"ListOfficeMlsId": "DERE58"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to this extraordinary residence in the stunning surroundings of Hewlett Harbor. This home beautifully marries luxury and masterful design, creating a truly unique living experience that will captivate your senses. Step inside this elegant showcase home spanning over 5400 square feet of living space plus1600 square feet of finished basement, and you'll be greeted by an impeccably crafted interior layout. Every detail has been meticulously considered, offering one-of-a-kind views and an unparalleled use of space. The center hall colonial entry foyer sets the stage for a fairy tale-like journey through this exceptional property. Among its many features, this home boasts six generously sized bedrooms and five full bathrooms, ensuring ample space for your family and guests. The private master bedroom suite is a sanctuary of sophistication, featuring walk-in closets, a comfortable sitting room, and a luxurious full marble bath that flows seamlessly. As you explore the house, you'll be enchanted by the spectacular vistas of your oversized pool and the surrounding golf course, creating an atmosphere of tranquility and natural beauty. Don't miss the chance to experience the perfect combination of opulence and thoughtful design in this magnificent Hewlett Harbor residence. Schedule your visit today and be prepared to fall in love with the embodiment of refined living."
+"Appliances": array:1 [
0 => "Gas Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-432-3400"
+"Basement": array:1 [
0 => "Finished"
]
+"BathroomsFull": 5
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [
0 => "Frame"
1 => "Shingle Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-02-10T19:36:42.305212+00:00"
+"CrossStreet": "Harbor Road"
+"CumulativeDaysOnMarket": 426
+"DaysOnMarket": 442
+"ElementarySchool": "Waverly Park School"
+"ElementarySchoolDistrict": "Lynbrook"
+"ExpirationDate": "2026-07-31"
+"FireplacesTotal": "1"
+"GarageSpaces": "3"
+"GarageYN": true
+"Heating": array:2 [
0 => "Oil"
1 => "Hot Water"
]
+"HighSchool": "Lynbrook Senior High School"
+"HighSchoolDistrict": "Lynbrook"
+"InteriorFeatures": array:7 [
0 => "Primary Bathroom"
1 => "Cathedral Ceiling(s)"
2 => "Eat-in Kitchen"
3 => "Entrance Foyer"
4 => "Walk-In Closet(s)"
5 => "Formal Dining"
6 => "First Floor Bedroom"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Three Or More"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-835-3333"
+"ListAgentEmail": "Gil.Shemtov@elliman.com"
+"ListAgentKey": "326183315"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110783"
+"ListOfficePhone": "516-432-3400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-02-05"
+"LivingAreaSource": "Public Records"
+"LotSizeDimensions": ".5266"
+"LotSizeSquareFeet": 22939
+"MajorChangeTimestamp": "2026-01-05T15:37:27Z"
+"MajorChangeType": "Back On Market"
+"MiddleOrJuniorSchool": "Lynbrook South Middle School"
+"MiddleOrJuniorSchoolDistrict": "Lynbrook"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-02-10"
+"OriginalEntryTimestamp": "2025-02-10T19:29:18Z"
+"OriginalListPrice": 2150000
+"OriginatingSystemModificationTimestamp": "2026-01-05T15:37:27Z"
+"OwnerName": "Yohai"
+"ParcelNumber": "2017-42-H-00-0012-0"
+"ParkingFeatures": array:3 [
0 => "Private"
1 => "Attached"
2 => "Driveway"
]
+"PhotosChangeTimestamp": "2025-12-31T05:14:38Z"
+"PhotosCount": 34
+"PoolFeatures": array:1 [
0 => "In Ground"
]
+"PostalCity": "Hewlett Harbor"
+"RoomsTotal": "11"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:2 [
0 => "Appointment Only"
1 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-05T15:37:27Z"
+"StreetName": "Thixton"
+"StreetNumber": "30"
+"StreetNumberNumeric": "30"
+"StreetSuffix": "Drive"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "35478"
+"TaxBlock": "H"
+"TaxLot": "12"
+"TaxYear": "2025"
+"Utilities": array:1 [
0 => "Trash Collection Public"
]
+"View": "Panoramic"
+"WaterSource": array:1 [
0 => "Public"
]
+"WindowFeatures": array:1 [
0 => "Skylight(s)"
]
+"KEY_Attic": "See Remarks"
+"KEY_Village": "Hewlett Harbor"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "42"
+"KEY_CurrentPrice": "2150000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Expired"
+"KEY_AdditionalRooms": "Library/Den"
+"KEY_IncludedInTaxes": "Sewer"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Back On Market"
+"KEY_LivingAreaSearchSqFt": "5406.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "397.70625"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "397.70625"
+"KEY_SourceSystemModificationTimestamp": "2025-02-05T11:57:31.293"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418643606')"
+"provider_name": "One Key"
+"Media": array:34 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
29 => array:12 [ …12]
30 => array:12 [ …12]
31 => array:12 [ …12]
32 => array:12 [ …12]
33 => array:12 [ …12]
]
+"ID": "24008"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5124
+post_id: "23862"
+post_author: 1
+"ListingKey": "KEY418642634"
+"ListingId": "821236"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-04-11T09:16:50Z"
+"RFModificationTimestamp": "2025-04-11T10:28:12Z"
+"ListPrice": 645000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1600.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "311 Marina Pointe Drive Unit H, Hempstead, New York 11518"
+"Coordinates": array:2 [
0 => 0
1 => 0
]
+"Latitude": 0.01
+"Longitude": 0.01
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Steven Baroumis"
+"ListOfficeName": "SBNY RE"
+"ListAgentMlsId": "18761"
+"ListOfficeMlsId": "STBA01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to this duplex condo which seamlessly blends style, comfort, and modern amenities. With inviting interiors and luxurious features, this condo suite is a place you'll love to call home. \n
\n
Nestled near the LIRR, this location offers a quick 30-minute ride to Manhattan. You'll find an abundance of supermarkets, shops, and new restaurants, all while being conveniently close to JFK Airport.\n
\n
Don’t miss out on this exceptional living experience!
"""
+"Appliances": array:3 [
0 => "Dryer"
1 => "Refrigerator"
2 => "Washer"
]
+"AssociationFee": "720"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Exterior Maintenance"
1 => "Hot Water"
2 => "Snow Removal"
3 => "Trash"
4 => "Water"
]
+"AssociationYN": true
+"AttributionContact": "718-520-3050"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "631-331-4000"
+"BuyerAgentEmail": "raskenas@exitislandelite.com"
+"BuyerAgentFullName": "Rosanna Askenas"
+"BuyerAgentKey": "326232770"
+"BuyerAgentMlsId": "223934"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326111276"
+"BuyerOfficeMlsId": "EXIS01"
+"BuyerOfficeName": "Exit Realty Island Elite"
+"BuyerOfficePhone": "631-331-4000"
+"CoBuyerAgentAOR": "LIBOR"
+"CoBuyerAgentDirectPhone": "631-839-4150"
+"CoBuyerAgentEmail": "JFurnari@EXITIsland Elite.com"
+"CoBuyerAgentFullName": "Jason R. Furnari"
+"CoBuyerAgentKey": "326194600"
+"CoBuyerAgentMlsId": "184375"
+"CoBuyerOfficeKey": "326111276"
+"CoBuyerOfficeMlsId": "EXIS01"
+"CoBuyerOfficeName": "Exit Realty Island Elite"
+"CoBuyerOfficePhone": "631-331-4000"
+"ConstructionMaterials": array:1 [
0 => "Aluminum Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-02-07T23:17:02.851210+00:00"
+"CumulativeDaysOnMarket": 31
+"DaysOnMarket": 31
+"ElementarySchool": "Contact Agent"
+"ExpirationDate": "2025-04-26"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Contact Agent"
+"HighSchoolDistrict": "Contact Agent"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [
0 => "In Unit"
1 => "Laundry Room"
]
+"Levels": array:1 [
0 => "Two"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-686-6088"
+"ListAgentEmail": "steven@sbnyre.com"
+"ListAgentKey": "326197684"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115782"
+"ListOfficePhone": "718-520-3050"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-02-07"
+"LivingAreaSource": "Plans"
+"MajorChangeTimestamp": "2025-03-14T14:41:01Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Contact Agent"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2025-03-14"
+"OnMarketDate": "2025-02-07"
+"OriginalEntryTimestamp": "2025-02-07T23:12:57Z"
+"OriginalListPrice": 645000
+"OriginatingSystemModificationTimestamp": "2025-04-11T09:03:45Z"
+"OwnerName": "Baldwin"
+"ParkingTotal": "2"
+"PatioAndPorchFeatures": array:1 [
0 => "Terrace"
]
+"PetsAllowed": array:3 [
0 => "Call"
1 => "Cats OK"
2 => "Dogs OK"
]
+"PhotosChangeTimestamp": "2025-02-07T23:14:36Z"
+"PhotosCount": 33
+"PostalCity": "East Rockaway"
+"PropertyAttachedYN": true
+"PurchaseContractDate": "2025-03-10"
+"RoomsTotal": "5"
+"Sewer": array:1 [
0 => "Other"
]
+"ShowingContactPhone": "917-686-6088"
+"ShowingRequirements": array:2 [
0 => "24 Hour Notice"
1 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-03-14T14:41:01Z"
+"StreetName": "Marina Pointe"
+"StreetNumber": "311"
+"StreetNumberNumeric": "311"
+"StreetSuffix": "Drive"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "9384"
+"TaxYear": "2024"
+"UnitNumber": "H"
+"Utilities": array:2 [
0 => "Cable Available"
1 => "Natural Gas Available"
]
+"View": "Water"
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "1600.00"
+"KEY_PreviousStatus": "Active"
+"KEY_CurrentPrice": "645000.00"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "403.12500"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_Attic": "None"
+"KEY_OpenHouseCount": "2"
+"KEY_ConcessionYN": "0"
+"KEY_ContractPrice": "655000.00"
+"KEY_RATIO_ListPrice_By_LivingArea": "403.12500"
+"KEY_SourceSystemModificationTimestamp": "2025-02-05T11:27:21.683"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418642634')"
+"location_extra_data": array:1 [
"source" => "MLS"
]
+"full_address": "311 Marina Pointe Drive Unit H, Hempstead, New York 11518"
+"provider_name": "One Key"
+"short_address": "Hempstead, New York 11518, USA"
+"Media": array:33 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
29 => array:12 [ …12]
30 => array:12 [ …12]
31 => array:12 [ …12]
32 => array:12 [ …12]
]
+"ID": "23862"
}
10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5125
+post_id: "24718"
+post_author: 1
+"ListingKey": "KEY418622561"
+"ListingId": "820569"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Business"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-05-06T19:23:36Z"
+"RFModificationTimestamp": "2025-05-06T19:27:47Z"
+"ListPrice": 4000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1500.0
+"City": "Hempstead"
+"PostalCode": "11510"
+"UnparsedAddress": "751 Merrick Boulevard, Hempstead, New York 11510"
+"Coordinates": array:2 [
0 => -73.727903269025
1 => 40.674128176797
]
+"Latitude": 40.674128176797
+"Longitude": -73.727903269025
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Anthoane C. Mazzara CBR"
+"ListOfficeName": "A Class Realty"
+"ListAgentMlsId": "183669"
+"ListOfficeMlsId": "ACL02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Prime Commercial Space for Lease – Busy Intersection, High Foot Traffic! Size: 1,500 sq ft (Main Storefront) + 1,500 sq ft Additional Space\n
?? High Visibility – Situated at a bustling intersection with great foot and vehicle traffic\n
??? Accessibility – 3 separate exits for easy customer flow\n
\n
?? Key Features:\n
Perfect for Retail, Office, or Showroom\n
Open floor plan – ready for your design & customization\n
Great exposure – corner location with large windows\n
Ideal for businesses seeking high visibility & walk-in traffic\n
Situated in a vibrant, growing area with established foot traffic\n
Close proximity to public transportation and ample parking
"""
+"AttributionContact": "516-226-1420"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BuildingAreaSource": "Plans"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Retail"
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-02-03T23:33:42.542985+00:00"
+"CumulativeDaysOnMarket": 90
+"DaysOnMarket": 90
+"ExpirationDate": "2025-11-04"
+"Heating": array:1 [
0 => "Forced Air"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseAmountFrequency": "Annually"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-226-1420"
+"ListAgentEmail": "ann.mazzara@aclassrealty.com"
+"ListAgentKey": "326193924"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109125"
+"ListOfficePhone": "516-226-1420"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2025-02-03"
+"MajorChangeTimestamp": "2025-05-04T04:10:58Z"
+"MajorChangeType": "Expired"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-05-04"
+"OnMarketDate": "2025-02-03"
+"OriginalEntryTimestamp": "2025-02-03T23:26:25Z"
+"OriginalListPrice": 4000
+"OriginatingSystemModificationTimestamp": "2025-05-06T19:22:15Z"
+"OwnerName": "751 Holdings"
+"PhotosChangeTimestamp": "2025-02-03T23:27:36Z"
+"PhotosCount": 4
+"PostalCity": "Baldwin"
+"PriceChangeTimestamp": "2025-02-03T23:26:25Z"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-368-6841"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "Security Deposit"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-05-04T04:10:58Z"
+"StreetName": "Merrick"
+"StreetNumber": "751"
+"StreetNumberNumeric": "751"
+"StreetSuffix": "Boulevard"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxYear": "2025"
+"Utilities": array:1 [
0 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "2.66667"
+"KEY_LeasePriceUnit": "Total"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "2.66667"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_SourceSystemModificationTimestamp": "2025-02-03T18:26:26.017"
+"KEY_CurrentPrice": "4000.00"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418622561')"
+"provider_name": "One Key"
+"Media": array:4 [
0 => array:14 [ …14]
1 => array:14 [ …14]
2 => array:14 [ …14]
3 => array:13 [ …13]
]
+"ID": "24718"
}
11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5126
+post_id: "24501"
+post_author: 1
+"ListingKey": "KEY418622041"
+"ListingId": "820552"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2025-06-01T19:09:45Z"
+"RFModificationTimestamp": "2025-06-01T19:13:49Z"
+"ListPrice": 749999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1647.0
+"BuildingAreaTotal": 1647.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "55 Ethel Street, Hempstead, New York 11580"
+"Coordinates": array:2 [
0 => -73.7113951
1 => 40.6735879
]
+"Latitude": 40.6735879
+"Longitude": -73.7113951
+"YearBuilt": 1932
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Katrina Qiao Y. Wang"
+"ListOfficeName": "Chase Global Realty Corp"
+"ListAgentMlsId": "146884"
+"ListOfficeMlsId": "CHSG01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Charming Home in a Desirable Neighborhood!\n
Welcome to 55 Ethel Street, a beautifully maintained residence in Valley Stream, Long Island.\n
Features: 4 spacious bedrooms with ample closet space, 3 bathrooms with modern fixtures. Gourmet kitchen with granite countertops, stainless steel appliances, custom cabinetry. Full basement with separate entrance. Hardwood flooring throughout. Private backyard perfect for outdoor entertaining. Close proximity to parks, schools, and shopping
"""
+"Appliances": array:4 [
0 => "Microwave"
1 => "Oven"
2 => "Range"
3 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Cape Cod"
]
+"AttributionContact": "718-355-8788"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "718-362-0006"
+"CoListAgentEmail": "dmatias10@gmail.com"
+"CoListAgentFullName": "David Matias"
+"CoListAgentKey": "326216589"
+"CoListAgentMlsId": "207214"
+"CoListOfficeKey": "326110322"
+"CoListOfficeMlsId": "CHSG01"
+"CoListOfficeName": "Chase Global Realty Corp"
+"CoListOfficePhone": "718-355-8788"
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Frame"
]
+"Cooling": array:1 [
0 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-05-27T15:05:14.078473+00:00"
+"CumulativeDaysOnMarket": 99
+"DaysOnMarket": 99
+"Directions": "see map"
+"ElementarySchool": "Shaw Avenue School"
+"ExpirationDate": "2025-05-28"
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Contact Agent"
+"HighSchoolDistrict": "Valley Stream - 30"
+"InteriorFeatures": array:2 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "718-757-6068"
+"ListAgentEmail": "bnlwang@gmail.com"
+"ListAgentKey": "326159793"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110322"
+"ListOfficePhone": "718-355-8788"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-02-06"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.0918
+"LotSizeSquareFeet": 4000
+"MajorChangeTimestamp": "2025-05-28T04:10:30Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Contact Agent"
+"MlsStatus": "Expired"
+"OffMarketDate": "2025-05-28"
+"OnMarketDate": "2025-02-06"
+"OriginalEntryTimestamp": "2025-02-06T21:37:09Z"
+"OriginalListPrice": 749999
+"OriginatingSystemModificationTimestamp": "2025-06-01T19:08:24Z"
+"OwnerName": "Hernandez"
+"ParcelNumber": "2035-37-U-02-0292-0"
+"ParkingFeatures": array:1 [
0 => "Driveway"
]
+"PhotosChangeTimestamp": "2025-02-06T21:38:39Z"
+"PhotosCount": 38
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "3107"
+"RoomsTotal": "15"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "718-757-6068"
+"ShowingRequirements": array:3 [
0 => "24 Hour Notice"
1 => "Appointment Only"
2 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-05-28T04:10:30Z"
+"StreetName": "Ethel"
+"StreetNumber": "55"
+"StreetNumberNumeric": "55"
+"StreetSuffix": "Street"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"TaxAnnualAmount": "10818.15"
+"TaxAssessedValue": 505
+"TaxYear": "2023"
+"Utilities": array:2 [
0 => "Electricity Connected"
1 => "Sewer Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_TaxSource": "Municipality"
+"KEY_LivingAreaSearchSqFt": "1647.00"
+"KEY_PreviousStatus": "Active"
+"KEY_CurrentPrice": "749999.00"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "455.37280"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "455.37280"
+"KEY_Attic": "None"
+"KEY_OpenHouseCount": "2"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8169923.7473"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "455.37280"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_RATIO_ListPrice_By_LivingArea": "455.37280"
+"KEY_SourceSystemModificationTimestamp": "2025-02-03T17:42:41.657"
+"KEY_HoldDate": "2025-05-21"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY418622041')"
+"provider_name": "One Key"
+"Media": array:38 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:12 [ …12]
20 => array:12 [ …12]
21 => array:12 [ …12]
22 => array:12 [ …12]
23 => array:12 [ …12]
24 => array:12 [ …12]
25 => array:12 [ …12]
26 => array:12 [ …12]
27 => array:12 [ …12]
28 => array:12 [ …12]
29 => array:12 [ …12]
30 => array:12 [ …12]
31 => array:12 [ …12]
32 => array:12 [ …12]
33 => array:12 [ …12]
34 => array:12 [ …12]
35 => array:12 [ …12]
36 => array:12 [ …12]
37 => array:12 [ …12]
]
+"ID": "24501"
}
]
+success: true
+page_size: 12
+page_count: 215
+count: 2575
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]