array:1 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=756&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000)&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5303
+items: array:12 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5294
+post_id: "31207"
+post_author: 1
+"ListingKey": "KEY424832149"
+"ListingId": "997322"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-21T20:42:36Z"
+"RFModificationTimestamp": "2026-05-21T20:50:06Z"
+"ListPrice": 3500.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2340.0
+"BuildingAreaTotal": 2340.0
+"City": "Hempstead"
+"PostalCode": "11581"
+"UnparsedAddress": "375 Cochran Place Unit 2, Hempstead, New York 11581"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1959
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Violeta Y. Castillo"
+"ListOfficeName": "EXIT Realty Premier"
+"ListAgentMlsId": "507204"
+"ListOfficeMlsId": "EREA02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Beautiful 3 bedrooms apartment. appointments 24 hours in advance, easy to show. Heat and hot water included. Follow the rent spree link for applications. 1parking spot available only from 9pm to 9 am everyday."
+"Appliances": array:2 [
0 => "Range"
1 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"AttributionContact": "516-795-1000"
+"AvailabilityDate": "2026-05-09"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"CarportSpaces": "1"
+"CarportYN": true
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Multi Units"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-09T15:49:05.749914+00:00"
+"CumulativeDaysOnMarket": 12
+"DaysOnMarket": 46
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"EntryLevel": 2
+"ExpirationDate": "2026-08-08"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:3 [
0 => "Eat-in Kitchen"
1 => "Formal Dining"
2 => "Natural Woodwork"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseTerm": "12 Months"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-795-1000"
+"ListAgentEmail": "Violetaexitrealty@gmail.com"
+"ListAgentKey": "425038023"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326111209"
+"ListOfficePhone": "516-795-1000"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2026-05-08"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.093
+"LotSizeSquareFeet": 4050
+"MajorChangeTimestamp": "2026-05-09T15:43:08Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-09"
+"OriginalEntryTimestamp": "2026-05-09T15:43:08Z"
+"OriginalListPrice": 3500
+"OriginatingSystemModificationTimestamp": "2026-05-21T20:41:31Z"
+"OwnerName": "Ashley Ramos & Wilfredo Salas"
+"ParcelNumber": "2035-39-452-00-0066-0"
+"ParkingFeatures": array:2 [
0 => "Private"
1 => "Shared Driveway"
]
+"PetsAllowed": array:1 [
0 => "No"
]
+"PhotosChangeTimestamp": "2026-05-09T16:02:36Z"
+"PhotosCount": 14
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "3265"
+"PriceChangeTimestamp": "2026-05-09T15:43:08Z"
+"RentIncludes": "Heat,Hot Water,Sewer,Water"
+"RoomsTotal": "5"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "347-553-4760"
+"ShowingRequirements": array:1 [
0 => "24 Hour Notice"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-09T15:43:08Z"
+"StreetName": "Cochran"
+"StreetNumber": "375"
+"StreetNumberNumeric": "375"
+"StreetSuffix": "Place"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"UnitNumber": "2"
+"Utilities": array:4 [
0 => "Electricity Available"
1 => "Natural Gas Available"
2 => "Sewer Connected"
3 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "None"
+"KEY_RentSpreeYN": "1"
+"KEY_CurrentPrice": "3500.00"
+"KEY_RentSpreeURL": "https://apply.link/lfMyrhU"
+"KEY_AdditionalFeesYN": "0"
+"KEY_SecurityDeposits": "3500"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "2340.00"
+"KEY_RATIO_ListPrice_By_LivingArea": "1.49573"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "37634.4086"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "1.49573"
+"KEY_SourceSystemModificationTimestamp": "2026-05-09T11:43:08.347"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.49573"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.49573"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424832149')"
+"provider_name": "One Key"
+"Media": array:14 [
0 => array:12 [
"Order" => 0
"MediaKey" => "69ff5a7bf8f3c86aa02fbc65"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/2e699dc0068923e1c4fa3efadd2c2e95.webp"
"MediaSize" => 341551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/thumbnail-2e699dc0068923e1c4fa3efadd2c2e95.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1536
"ResourceRecordKey" => "424832149"
"ImageSizeDescription" => "2048x1536"
"MediaModificationTimestamp" => "2026-05-09T16:02:03.475Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "69ff5a7bf8f3c86aa02fbc66"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/61dc77ccc1bebcc959cfb1a8bb8823ed.webp"
"MediaSize" => 324584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/thumbnail-61dc77ccc1bebcc959cfb1a8bb8823ed.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1536
"ShortDescription" => "Living Room"
"ResourceRecordKey" => "424832149"
"ImageSizeDescription" => "2048x1536"
"MediaModificationTimestamp" => "2026-05-09T16:02:03.464Z"
]
2 => array:12 [
"Order" => 2
"MediaKey" => "69ff5a7bf8f3c86aa02fbc67"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/f7abc91e94922b52b5c739d40f157b37.webp"
"MediaSize" => 380173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/thumbnail-f7abc91e94922b52b5c739d40f157b37.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1536
"ResourceRecordKey" => "424832149"
"ImageSizeDescription" => "2048x1536"
"MediaModificationTimestamp" => "2026-05-09T16:02:03.472Z"
]
3 => array:12 [
"Order" => 3
"MediaKey" => "69ff5a7bf8f3c86aa02fbc68"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/90c57e3889e114ec4511dad9abecf4c6.webp"
"MediaSize" => 380173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/thumbnail-90c57e3889e114ec4511dad9abecf4c6.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1536
"ResourceRecordKey" => "424832149"
"ImageSizeDescription" => "2048x1536"
"MediaModificationTimestamp" => "2026-05-09T16:02:03.470Z"
]
4 => array:12 [
"Order" => 4
"MediaKey" => "69ff5a7bf8f3c86aa02fbc69"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/77eb1def54c96e37a4fae4a4dd94a843.webp"
"MediaSize" => 274029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/thumbnail-77eb1def54c96e37a4fae4a4dd94a843.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1536
"ResourceRecordKey" => "424832149"
"ImageSizeDescription" => "2048x1536"
"MediaModificationTimestamp" => "2026-05-09T16:02:03.465Z"
]
5 => array:12 [
"Order" => 5
"MediaKey" => "69ff5a7bf8f3c86aa02fbc6a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/e76dbd395e5cbf8791a36e66c9a62862.webp"
"MediaSize" => 298200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/29/KEY424832149/thumbnail-e76dbd395e5cbf8791a36e66c9a62862.webp"
"ImageWidth" => 2048
"Permission" => array:1 [ …1]
"ImageHeight" => 1536
"ResourceRecordKey" => "424832149"
"ImageSizeDescription" => "2048x1536"
"MediaModificationTimestamp" => "2026-05-09T16:02:03.464Z"
]
6 => array:13 [
"Order" => 6
…12
]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:13 [ …13]
10 => array:12 [ …12]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:12 [ …12]
]
+"ID": "31207"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5296
+post_id: "31206"
+post_author: 1
+"ListingKey": "KEY424831071"
+"ListingId": "997289"
+"PropertyType": "Business Opportunity"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-10T07:20:37Z"
+"RFModificationTimestamp": "2026-05-10T07:21:56Z"
+"ListPrice": 160000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "42 Merrick Ave, Hempstead, New York 11566"
+"Coordinates": array:2 [
0 => -73.5596225
1 => 40.6753125
]
+"Latitude": 40.6753125
+"Longitude": -73.5596225
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Xuehui S. Lin"
+"ListOfficeName": "Homix Realty Inc"
+"ListAgentMlsId": "224257"
+"ListOfficeMlsId": "HRMI01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Turnkey opportunity to own a well-established Japanese hibachi & ramen restaurant in a highly desirable Long Island location. Currently generating approximately $55,000/month in revenue, this business offers strong cash flow with significant upside potential.\n
Strategically located near Exit 38, just about 25 minutes from Flushing, the restaurant benefits from excellent accessibility and visibility. Surrounded by residential neighborhoods with dedicated parking, it enjoys a steady flow of local customers.\n
The space features over 1,000 sq ft on the main level plus a full basement, providing ample room for storage or expansion. The current setup is ideal for Japanese cuisine, including teppanyaki and ramen, but can easily be converted to suit a variety of other restaurant concepts.\n
Monthly rent is $3,645, which includes property taxes, making it a very attractive lease for the area.\n
Perfect for owner-operators or investors looking for a profitable business with flexibility and growth potential.\n
For more information or to schedule a viewing, please contact directly.
"""
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Restaurant"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-09T12:45:09.086989+00:00"
+"CumulativeDaysOnMarket": 1
+"DaysOnMarket": 46
+"ExpirationDate": "2026-10-11"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "929-666-9886"
+"ListAgentEmail": "shellylin8209@gmail.com"
+"ListAgentKey": "326233075"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "421354028"
+"ListOfficePhone": "929-666-9886"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-04-12"
+"MajorChangeTimestamp": "2026-05-09T12:40:12Z"
+"MajorChangeType": "New Listing"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-09"
+"OriginalEntryTimestamp": "2026-05-09T12:40:12Z"
+"OriginalListPrice": 160000
+"OriginatingSystemModificationTimestamp": "2026-05-09T12:45:20Z"
+"OwnerName": "Suzhen Ding"
+"PhotosChangeTimestamp": "2026-05-09T12:46:36Z"
+"PhotosCount": 2
+"PostalCity": "Merrick"
+"PriceChangeTimestamp": "2026-05-09T12:40:12Z"
+"ShowingContactPhone": "9172517918"
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-09T12:40:12Z"
+"StreetName": "Merrick Ave"
+"StreetNumber": "42"
+"StreetNumberNumeric": "42"
+"SyndicateTo": array:3 [
0 => "Realtor.com"
1 => "Crexi"
2 => "OneKeyMLS.com"
]
+"TaxYear": "2026"
+"KEY_CurrentPrice": "160000.00"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_RealEstateIncludedYN": "0"
+"KEY_SourceSystemModificationTimestamp": "2026-05-09T08:40:12.597"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424831071')"
+"provider_name": "One Key"
+"Media": array:2 [
0 => array:12 [ …12]
1 => array:12 [ …12]
]
+"ID": "31206"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5293
+post_id: "31324"
+post_author: 1
+"ListingKey": "KEY424829318"
+"ListingId": "997267"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T23:39:36Z"
+"RFModificationTimestamp": "2026-06-23T23:42:55Z"
+"ListPrice": 799999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 2400.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "167 Shaw Avenue, Hempstead, New York 11580"
+"Coordinates": array:2 [
0 => -73.7145537
1 => 40.6745326
]
+"Latitude": 40.6745326
+"Longitude": -73.7145537
+"YearBuilt": 1926
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Diane Mascellaro"
+"ListOfficeName": "Exit Realty Achieve"
+"ListAgentMlsId": "202689"
+"ListOfficeMlsId": "EXAC01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to this meticulously maintained expanded Cape in the desirable Village of Valley Stream! This versatile home features 3 bedrooms and 2 full baths, along with hardwood floors, crown moldings, skylights, recessed lighting, and an updated kitchen with granite countertops and gas cooking.The full basement with a separate outside entrance offers excellent additional flexible space and great potential for extended living, guest space, home office, gym, recreation area, or storage.Additional highlights include central air conditioning, gas heat, 3-zone heating, in-ground sprinklers, 200-amp electric, generator hook-up, detached garage, paver patio, PVC fencing, and a beautifully landscaped oversized backyard perfect for entertaining and outdoor enjoyment. Conveniently located north of Merrick Road near parks, shopping, transportation, and schools. A must see!"
+"Appliances": array:7 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Gas Cooktop"
3 => "Microwave"
4 => "Oven"
5 => "Refrigerator"
6 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Cape Cod"
]
+"AttributionContact": "631-543-2009"
+"Basement": array:2 [
0 => "Full"
1 => "Partially Finished"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "631-882-5036"
+"CoListAgentEmail": "edpearson.exit@gmail.com"
+"CoListAgentFullName": "Edward Pearson"
+"CoListAgentKey": "326219566"
+"CoListAgentMlsId": "210293"
+"CoListOfficeKey": "326111265"
+"CoListOfficeMlsId": "EXAC01"
+"CoListOfficeName": "Exit Realty Achieve"
+"CoListOfficePhone": "631-543-2009"
+"ConstructionMaterials": array:1 [
0 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-17T02:43:45.971206+00:00"
+"CrossStreet": "Merrick Ave"
+"CumulativeDaysOnMarket": 25
+"DaysOnMarket": 26
+"Directions": "GPS/WAZE"
+"ElementarySchool": "Shaw Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 30"
+"Exclusions": "Chandelier"
+"ExpirationDate": "2026-11-30"
+"ExteriorFeatures": array:2 [
0 => "Lighting"
1 => "Mailbox"
]
+"Fencing": array:1 [
0 => "Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Wood Burning"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:13 [
0 => "First Floor Bedroom"
1 => "Cathedral Ceiling(s)"
2 => "Ceiling Fan(s)"
3 => "Crown Molding"
4 => "Eat-in Kitchen"
5 => "Granite Counters"
6 => "Kitchen Island"
7 => "Open Kitchen"
8 => "Primary Bathroom"
9 => "Recessed Lighting"
10 => "Storage"
11 => "Walk-In Closet(s)"
12 => "Washer/Dryer Hookup"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [
0 => "In Basement"
1 => "Laundry Room"
]
+"Levels": array:1 [
0 => "Two"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-872-5217"
+"ListAgentEmail": "dianemexitrealtor@gmail.com"
+"ListAgentKey": "326212160"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326111265"
+"ListOfficePhone": "631-543-2009"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-16"
+"LivingAreaSource": "Cubi Casa"
+"LotFeatures": array:2 [
0 => "Back Yard"
1 => "Landscaped"
]
+"LotSizeAcres": 0.1194
+"LotSizeDimensions": "40 x 100"
+"LotSizeSquareFeet": 5200
+"MajorChangeTimestamp": "2026-06-22T18:53:15Z"
+"MajorChangeType": "Back On Market"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-29"
+"OriginalEntryTimestamp": "2026-05-17T02:38:01Z"
+"OriginalListPrice": 799999
+"OriginatingSystemModificationTimestamp": "2026-06-23T23:38:18Z"
+"OtherStructures": array:2 [
0 => "Garage(s)"
1 => "Shed(s)"
]
+"OwnerName": "Israel & Maria Cartagena"
+"ParcelNumber": "2035-37-283-00-0237-0"
+"ParkingFeatures": array:3 [
0 => "Driveway"
1 => "Garage"
2 => "Garage Door Opener"
]
+"PatioAndPorchFeatures": array:2 [
0 => "Patio"
1 => "Porch"
]
+"PhotosChangeTimestamp": "2026-05-17T02:39:36Z"
+"PhotosCount": 40
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "3139"
+"RoomsTotal": "7"
+"SecurityFeatures": array:1 [
0 => "Security System"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "800-746-9464"
+"ShowingRequirements": array:2 [
0 => "Appointment Only"
1 => "Showing Service"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-22T18:53:15Z"
+"StreetName": "Shaw"
+"StreetNumber": "167"
+"StreetNumberNumeric": "167"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "10787"
+"TaxAssessedValue": 442
+"TaxYear": "2025"
+"Utilities": array:3 [
0 => "Natural Gas Connected"
1 => "Trash Collection Public"
2 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "Partial"
+"KEY_Village": "Valley Stream"
+"KEY_HoldDate": "2026-05-28"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "799999.00"
+"KEY_OpenHouseCount": "3"
+"KEY_PreviousStatus": "Hold"
+"KEY_DistanceToTrain": "1.50"
+"KEY_ElectricCompany": "PSEG"
+"KEY_OpenHouseUpcoming": "Public: Sat Jun 27, 1:00PM-3:00PM"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Back On Market"
+"KEY_LivingAreaSearchSqFt": "1500.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_OpenHousePublicCount": "2"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_OpenHousePublicUpcoming": "Public: Sat Jun 27, 1:00PM-3:00PM"
+"KEY_RATIO_ListPrice_By_LivingArea": "533.33267"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6700159.1290"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "533.33267"
+"KEY_SourceSystemModificationTimestamp": "2026-05-08T23:29:16.887"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "333.33292"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "333.33292"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424829318')"
+"provider_name": "One Key"
+"Media": array:40 [
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]
38 => array:12 [ …12]
39 => array:12 [ …12]
]
+"ID": "31324"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5297
+post_id: "31262"
+post_author: 1
+"ListingKey": "KEY424822965"
+"ListingId": "997090"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T07:11:41Z"
+"RFModificationTimestamp": "2026-06-23T07:14:22Z"
+"ListPrice": 1250000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2100.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "1811 Wilson Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [
0 => -73.5379321
1 => 40.6702219
]
+"Latitude": 40.6702219
+"Longitude": -73.5379321
+"YearBuilt": 1959
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Kathleen L. Bay"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "80851"
+"ListOfficeMlsId": "SPH09"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to this Stunning 4 bedroom, 3.5 bath expanded split-level home located in desirable Merrick! Living room with vaulted ceilings, beautiful HW Flooring, Updated baths, IGS, 200 amp electric, Weil-McLain boiler, kitchen with granite counters, newer SS appliances. Sliders from kitchen to double tier Trex deck where you can enjoy very private backyard. Family room with full bath and access to yard. Primary Bedroom w/vaulted ceilings, full bath, beautiful windows, WIC. The original primary bedroom also has full bath! Double driveway newly paved. \n
This home is a MUST SEE!
"""
+"Appliances": array:6 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Oven"
3 => "Refrigerator"
4 => "Stainless Steel Appliance(s)"
5 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Split Level"
]
+"AttributionContact": "516-546-6300"
+"Basement": array:1 [
0 => "Finished"
]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Wall/Window Unit(s)"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-13T15:18:46.889302+00:00"
+"CrossStreet": "Decatur"
+"CumulativeDaysOnMarket": 41
+"DaysOnMarket": 42
+"Directions": "Little Whaleneck to Wilson or BELLMORE Ave to Wilson"
+"ElementarySchool": "Harold D Fayette School"
+"ElementarySchoolDistrict": "North Merrick"
+"ExpirationDate": "2026-11-15"
+"ExteriorFeatures": array:1 [
0 => "Mailbox"
]
+"Flooring": array:3 [
0 => "Carpet"
1 => "Hardwood"
2 => "Tile"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Oil"
]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:10 [
0 => "Cathedral Ceiling(s)"
1 => "Ceiling Fan(s)"
2 => "Crown Molding"
3 => "Eat-in Kitchen"
4 => "Entrance Foyer"
5 => "Formal Dining"
6 => "Kitchen Island"
7 => "Open Kitchen"
8 => "Primary Bathroom"
9 => "Walk-In Closet(s)"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In Basement"
]
+"Levels": array:1 [
0 => "Three Or More"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-353-3033"
+"ListAgentEmail": "kbay@signaturepremier.com"
+"ListAgentKey": "326242827"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115717"
+"ListOfficePhone": "516-546-6300"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-13"
+"LivingAreaSource": "Other"
+"LotFeatures": array:7 [
0 => "Back Yard"
1 => "Landscaped"
2 => "Near School"
3 => "Paved"
4 => "Private"
5 => "Sprinklers In Front"
6 => "Sprinklers In Rear"
]
+"LotSizeAcres": 0.143
+"LotSizeSquareFeet": 6230
+"MajorChangeTimestamp": "2026-06-22T19:07:22Z"
+"MajorChangeType": "Back On Market"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-13"
+"OriginalEntryTimestamp": "2026-05-13T15:13:51Z"
+"OriginalListPrice": 1250000
+"OriginatingSystemModificationTimestamp": "2026-06-22T19:07:22Z"
+"OtherStructures": array:1 [
0 => "Shed(s)"
]
+"OwnerName": "Glenn R & Mary McCarthy"
+"ParcelNumber": "2089-50-579-00-0059-0"
+"ParkingFeatures": array:3 [
0 => "Driveway"
1 => "Garage"
2 => "On Street"
]
+"PatioAndPorchFeatures": array:1 [
0 => "Deck"
]
+"PhotosChangeTimestamp": "2026-05-13T15:26:36Z"
+"PhotosCount": 50
+"PostalCity": "Merrick"
+"PostalCodePlus4": "1228"
+"RoadResponsibility": array:1 [
0 => "Public Maintained Road"
]
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-353-3033"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-22T19:07:22Z"
+"StreetName": "Wilson"
+"StreetNumber": "1811"
+"StreetNumberNumeric": "1811"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "14968"
+"TaxAssessedValue": 522
+"TaxYear": "2026"
+"Utilities": array:5 [
0 => "Cable Available"
1 => "Electricity Connected"
2 => "Sewer Connected"
3 => "Trash Collection Public"
4 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "None"
+"KEY_HoldDate": "2026-06-22"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1250000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Hold"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Back On Market"
+"KEY_LivingAreaSearchSqFt": "2100.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "595.23810"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8741258.7413"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "595.23810"
+"KEY_SourceSystemModificationTimestamp": "2026-05-08T14:52:27.943"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424822965')"
+"provider_name": "One Key"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:13 [ …13]
7 => array:12 [ …12]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:12 [ …12]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:12 [ …12]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:12 [ …12]
28 => array:12 [ …12]
29 => array:13 [ …13]
30 => array:12 [ …12]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:12 [ …12]
39 => array:12 [ …12]
40 => array:12 [ …12]
41 => array:12 [ …12]
42 => array:12 [ …12]
43 => array:12 [ …12]
44 => array:12 [ …12]
45 => array:12 [ …12]
46 => array:12 [ …12]
47 => array:12 [ …12]
48 => array:12 [ …12]
49 => array:12 [ …12]
]
+"ID": "31262"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5295
+post_id: "31201"
+post_author: 1
+"ListingKey": "KEY424820681"
+"ListingId": "997036"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-15T14:18:37Z"
+"RFModificationTimestamp": "2026-05-15T14:22:28Z"
+"ListPrice": 2000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 10000.0
+"LivingArea": 0
+"BuildingAreaTotal": 800.0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "15 Ives Road, Hempstead, New York 11557"
+"Coordinates": array:2 [
0 => -73.701602439285
1 => 40.637254525914
]
+"Latitude": 40.637254525914
+"Longitude": -73.701602439285
+"YearBuilt": 1923
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Lori Schlesinger"
+"ListOfficeName": "Lori & Associates LI Realty"
+"ListAgentMlsId": "87462"
+"ListOfficeMlsId": "LORA01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Small Office building with private FREE parking. Office located on the first Floor. Great large open space with a backyard and an outside back door. Handicap accessible. Private Bathroom. Central Air and Heat. Fireplace in the office. Freshly Painted with new window treatments. Lots of light and windows. Tenant pays their own utilities except water."
+"AttributionContact": "516-791-8300"
+"Basement": array:2 [
0 => "Full"
1 => "Storage Space"
]
+"BasementYN": true
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Professional/Office"
+"ConstructionMaterials": array:1 [
0 => "Fiberglass Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-08T17:40:50.673491+00:00"
+"CumulativeDaysOnMarket": 7
+"DaysOnMarket": 47
+"Directions": "Broadway to Ives R....on the right"
+"ElementarySchool": "Franklin Early Childhood Center"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"EntryLevel": 1
+"ExpirationDate": "2026-10-31"
+"Heating": array:1 [
0 => "Baseboard"
]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LeaseAmountFrequency": "Monthly"
+"LeaseTerm": "24 Months"
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "loriandassociates@gmail.com"
+"ListAgentKey": "326247724"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113285"
+"ListOfficePhone": "516-791-8300"
+"ListingAgreement": "Exclusive Right To Lease"
+"ListingContractDate": "2026-05-08"
+"LotSizeAcres": 0.2296
+"LotSizeSquareFeet": 10000
+"MajorChangeTimestamp": "2026-05-08T17:35:39Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"NumberOfBuildings": 1
+"NumberOfUnitsTotal": "1"
+"OnMarketDate": "2026-05-08"
+"OriginalEntryTimestamp": "2026-05-08T17:35:39Z"
+"OriginalListPrice": 2000
+"OriginatingSystemModificationTimestamp": "2026-05-15T14:17:07Z"
+"OwnerName": "WR Management Group"
+"ParcelNumber": "2089-41-001-00-0107-0"
+"ParkingFeatures": array:1 [
0 => "Driveway"
]
+"PhotosChangeTimestamp": "2026-05-15T14:09:37Z"
+"PhotosCount": 10
+"PostalCity": "Hewlett"
+"PostalCodePlus4": "2034"
+"PriceChangeTimestamp": "2026-05-08T17:35:39Z"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "5164104210"
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-08T17:35:39Z"
+"Stories": "1"
+"StoriesTotal": "2"
+"StreetName": "Ives"
+"StreetNumber": "15"
+"StreetNumberNumeric": "15"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "18357.42"
+"TaxAssessedValue": 2775
+"TaxYear": "2023"
+"Utilities": array:7 [
0 => "Cable Available"
1 => "Electricity Available"
2 => "Natural Gas Available"
3 => "Phone Available"
4 => "Sewer Connected"
5 => "Trash Collection Public"
6 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_ElevatorYN": "0"
+"KEY_SubleaseYN": "0"
+"KEY_CurrentPrice": "2000.00"
+"KEY_BuildToSuitYN": "0"
+"KEY_WaterAccessYN": "0"
+"KEY_LeasePriceUnit": "Total"
+"KEY_ElectricCompany": "PSEG"
+"KEY_SecurityDeposits": "2000"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_SprinklerSystemYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_InvestmentPropertyYN": "0"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_NumberOfResidentialUnits": "0"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8710.8014"
+"KEY_SourceSystemModificationTimestamp": "2026-05-08T13:35:39.773"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "2.50000"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "2.50000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424820681')"
+"provider_name": "One Key"
+"Media": array:10 [
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]
]
+"ID": "31201"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5292
+post_id: "31363"
+post_author: 1
+"ListingKey": "KEY424816581"
+"ListingId": "996937"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-30T18:09:48Z"
+"RFModificationTimestamp": "2026-05-30T18:12:55Z"
+"ListPrice": 1579000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3071.0
+"BuildingAreaTotal": 3071.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "33 Nancy Boulevard, Hempstead, New York 11566"
+"Coordinates": array:2 [
0 => -73.5513947
1 => 40.6725801
]
+"Latitude": 40.6725801
+"Longitude": -73.5513947
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Elaine Richheimer"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "174177"
+"ListOfficeMlsId": "DERE28"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to 33 Nancy Blvd, an expansive modern and gorgeous residence located in the heart of Merrick Woods. This one of a kind spectacular home has over 3,000 square feet of living space , a wonderful cobblestone driveway with stunning trees surrounding for privacy. Enjoy fabulous meals in your custom gourmet kitchen featuring a center island, wine fridge, a 6 burner Wolf stove and the freshest cup of coffee with your Miele built-in coffee maker. Entertain guests in your large dining room and then relax in your oversized den with sliders to an incredible backyard with a gazebo, pergola, sound system, pond, and a limestone patio plus a separate shed with air conditioning and heat This property has a wonderful open floor plan with 4/5 bedrooms, a main level with an en-suite bathroom, plus a home office, a large closet/bedroom . Enter upstairs to your grand Primary suite with a sitting area near a beautiful full bathroom and soaking tub. The additional bedroom is oversized with so much room too. There is ample closet space. The home has heated floors, Pella windows, Bella porta doors, security lights and so much more! Located near trendy restaurants, highways and just one exit from fabulous beaches, the location is prime. NYC is just 45 minutes away with trains to Grand Central and Penn Station nearby. Merrick isn't just a great town to live in, it's a lifestyle that you will love. Do not miss this opportunity to live in your dream home ! Won't Last !"
+"Appliances": array:8 [
0 => "Cooktop"
1 => "Dishwasher"
2 => "Gas Cooktop"
3 => "Microwave"
4 => "Refrigerator"
5 => "Stainless Steel Appliance(s)"
6 => "Washer"
7 => "Gas Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Exp Ranch"
]
+"AttributionContact": "516-623-4500"
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [
0 => "Stone"
1 => "Wood Siding"
]
+"Cooling": array:1 [
0 => "Ductless"
]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-21T17:02:05.311580+00:00"
+"CrossStreet": "Merrick Avenue"
+"CumulativeDaysOnMarket": 9
+"DaysOnMarket": 34
+"ElementarySchool": "Camp Avenue School"
+"ElementarySchoolDistrict": "North Merrick"
+"Exclusions": "TBD"
+"ExpirationDate": "2027-05-07"
+"Fencing": array:1 [
0 => "Back Yard"
]
+"FireplaceFeatures": array:2 [
0 => "Family Room"
1 => "Gas"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "0.5"
+"GarageYN": true
+"Heating": array:3 [
0 => "Hot Water"
1 => "Natural Gas"
2 => "Radiant Floor"
]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:21 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
2 => "Breakfast Bar"
3 => "Built-in Features"
4 => "Cathedral Ceiling(s)"
5 => "Chefs Kitchen"
6 => "Eat-in Kitchen"
7 => "ENERGY STAR Qualified Door(s)"
8 => "Entrance Foyer"
9 => "Formal Dining"
10 => "Granite Counters"
11 => "His and Hers Closets"
12 => "Kitchen Island"
13 => "Open Floorplan"
14 => "Open Kitchen"
15 => "Master Downstairs"
16 => "Quartz/Quartzite Counters"
17 => "Soaking Tub"
18 => "Walk-In Closet(s)"
19 => "Washer/Dryer Hookup"
20 => "Wired for Sound"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Laundry Room"
]
+"Levels": array:1 [
0 => "Two"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-721-8316"
+"ListAgentEmail": "Elaine.Richheimer@elliman.com"
+"ListAgentKey": "326185145"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110766"
+"ListOfficePhone": "516-623-4500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-08"
+"ListingTerms": "Contract"
+"LivingAreaSource": "Appraiser"
+"LotSizeAcres": 0.1837
+"LotSizeSquareFeet": 8000
+"MajorChangeTimestamp": "2026-05-21T16:52:48Z"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-21"
+"OriginalEntryTimestamp": "2026-05-21T16:52:48Z"
+"OriginalListPrice": 1579000
+"OriginatingSystemModificationTimestamp": "2026-05-30T18:08:28Z"
+"OwnerName": "Moldwin"
+"ParcelNumber": "2089-56-077-00-0068-0"
+"ParkingFeatures": array:1 [
0 => "Driveway"
]
+"PhotosChangeTimestamp": "2026-05-21T17:19:36Z"
+"PhotosCount": 27
+"PostalCity": "Merrick"
+"PostalCodePlus4": "3122"
+"PropertyCondition": array:1 [
0 => "Updated/Remodeled"
]
+"RoomsTotal": "8"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-623-4500"
+"ShowingRequirements": array:1 [
0 => "Call Listing Office"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-21T16:52:48Z"
+"StreetName": "Nancy"
+"StreetNumber": "33"
+"StreetNumberNumeric": "33"
+"StreetSuffix": "Boulevard"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "22000"
+"TaxBlock": "077"
+"TaxLot": "68"
+"TaxYear": "2026"
+"Utilities": array:6 [
0 => "Cable Connected"
1 => "Electricity Connected"
2 => "Natural Gas Connected"
3 => "Sewer Connected"
4 => "Trash Collection Public"
5 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "56"
+"KEY_CurrentPrice": "1579000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_LivingAreaSearchSqFt": "3071.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-721-8316"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "514.16477"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8595536.2003"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "514.16477"
+"KEY_SourceSystemModificationTimestamp": "2026-05-08T11:17:34.800"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "514.16477"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "514.16477"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424816581')"
+"provider_name": "One Key"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:12 [ …12]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"ID": "31363"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5291
+post_id: "31264"
+post_author: 1
+"ListingKey": "KEY424815660"
+"ListingId": "996911"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-05-29T07:20:36Z"
+"RFModificationTimestamp": "2026-05-29T07:25:42Z"
+"ListPrice": 699999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1908.0
+"BuildingAreaTotal": 2232.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "2000 Merrick Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [
0 => -73.5548331
1 => 40.6694355
]
+"Latitude": 40.6694355
+"Longitude": -73.5548331
+"YearBuilt": 1949
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Lisa Pellegrino"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "163208"
+"ListOfficeMlsId": "DERE28"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Warm and inviting Colonial offering oversized rooms, 3 bedrooms, and updated utilities throughout. A unique attached former dentist office provides endless possibilities — perfect for a mother/daughter setup, professional office, doctor’s practice, or extended living space. A rare opportunity with flexibility, comfort, and charm all in one!"
+"Appliances": array:5 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Electric Range"
3 => "Refrigerator"
4 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-623-4500"
+"Basement": array:2 [
0 => "Bilco Door(s)"
1 => "Storage Space"
]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-581-9007"
+"BuyerAgentEmail": "eduindls1@gmail.com"
+"BuyerAgentFullName": "Eduin De Los Santos"
+"BuyerAgentKey": "326215494"
+"BuyerAgentMlsId": "206091"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110585"
+"BuyerOfficeMlsId": "CSQU02"
+"BuyerOfficeName": "RE/MAX City Square"
+"BuyerOfficePhone": "516-731-2700"
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-13T15:43:48.224105+00:00"
+"CumulativeDaysOnMarket": 5
+"DaysOnMarket": 5
+"ElementarySchool": "Chatterton School"
+"ElementarySchoolDistrict": "Merrick"
+"ExpirationDate": "2026-10-30"
+"FireplaceFeatures": array:2 [
0 => "Masonry"
1 => "Wood Burning"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Pillar/Post/Pier"
]
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Merrick"
+"InteriorFeatures": array:1 [
0 => "Original Details"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-241-7117"
+"ListAgentEmail": "Lisa.Pellegrino@Elliman.com"
+"ListAgentKey": "326175015"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110766"
+"ListOfficePhone": "516-623-4500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-08"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1377
+"LotSizeSquareFeet": 6000
+"MajorChangeTimestamp": "2026-05-28T16:30:17Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Merrick"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-05-28"
+"OnMarketDate": "2026-05-13"
+"OriginalEntryTimestamp": "2026-05-13T15:37:32Z"
+"OriginalListPrice": 699999
+"OriginatingSystemModificationTimestamp": "2026-05-28T16:30:17Z"
+"OwnerName": "Angela Collins Tricarico"
+"ParcelNumber": "2089-55-544-00-0119-0"
+"ParkingFeatures": array:1 [
0 => "Driveway"
]
+"PhotosChangeTimestamp": "2026-05-13T15:37:36Z"
+"PhotosCount": 23
+"PostalCity": "Merrick"
+"PostalCodePlus4": "3125"
+"PurchaseContractDate": "2026-05-28"
+"RoomsTotal": "9"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-28T16:30:17Z"
+"StreetName": "Merrick"
+"StreetNumber": "2000"
+"StreetNumberNumeric": "2000"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "15200"
+"TaxAssessedValue": 527
+"TaxYear": "2024"
+"Utilities": array:6 [
0 => "Cable Available"
1 => "Electricity Connected"
2 => "Natural Gas Connected"
3 => "Phone Available"
4 => "Trash Collection Public"
5 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Private"
]
+"KEY_Attic": "None"
+"KEY_HoldDate": "2026-05-18"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "699999.00"
+"KEY_ContractPrice": "850000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1908.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "366.87579"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5083507.6253"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "366.87579"
+"KEY_SourceSystemModificationTimestamp": "2026-05-08T10:38:11.890"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "313.61962"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "313.61962"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424815660')"
+"provider_name": "One Key"
+"Media": array:23 [
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]
]
+"ID": "31264"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5298
+post_id: "31249"
+post_author: 1
+"ListingKey": "KEY424815179"
+"ListingId": "996902"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T19:09:44Z"
+"RFModificationTimestamp": "2026-06-14T19:13:37Z"
+"ListPrice": 1545000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2302.0
+"BuildingAreaTotal": 2302.0
+"City": "Hempstead"
+"PostalCode": "11598"
+"UnparsedAddress": "994 Singleton Avenue, Hempstead, New York 11598"
+"Coordinates": array:2 [
0 => -73.7043779
1 => 40.6290013
]
+"Latitude": 40.6290013
+"Longitude": -73.7043779
+"YearBuilt": 2026
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Gil R. Shemtov"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "172225"
+"ListOfficeMlsId": "DERE58"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Discover modern luxury in this stunning new construction home featuring four bedrooms and three and a half bathrooms, masterfully designed with high ceilings and state of the art finishes throughout. The chef's kitchen is a culinary masterpiece, complemented by a dedicated beverage station perfect for entertaining. Radiant heat flooring and central air conditioning provides year round comfort in every room, while integrated smart home technology including a Sonos sound system and strategically placed Wi Fi access points ensure seamless connectivity. The expansive full finished basement adds an additional thousand hundred square feet of versatile living space, perfect for a home office, recreation area, or guest suite. Situated in a prime location with close proximity to shops and houses of worship, this contemporary residence represents the pinnacle of modern living"
+"Appliances": array:1 [
0 => "Stainless Steel Appliance(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "516-432-3400"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [
0 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-12T22:08:11.389087+00:00"
+"CumulativeDaysOnMarket": 33
+"DaysOnMarket": 43
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"ExpirationDate": "2026-12-31"
+"Heating": array:1 [
0 => "Radiant"
]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:1 [
0 => "Chefs Kitchen"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-835-3333"
+"ListAgentEmail": "Gil.Shemtov@elliman.com"
+"ListAgentKey": "326183315"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110783"
+"ListOfficePhone": "516-432-3400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-07"
+"LivingAreaSource": "Measured"
+"LotSizeAcres": 0.0806
+"LotSizeSquareFeet": 3510
+"MajorChangeTimestamp": "2026-06-03T19:06:53Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-12"
+"OriginalEntryTimestamp": "2026-05-12T22:01:31Z"
+"OriginalListPrice": 1595000
+"OriginatingSystemModificationTimestamp": "2026-06-14T19:08:19Z"
+"OwnerName": "994 Sing LLC"
+"ParcelNumber": "2089-41-028-00-0006-0"
+"ParkingFeatures": array:1 [
0 => "Driveway"
]
+"PhotosChangeTimestamp": "2026-05-12T22:02:36Z"
+"PhotosCount": 19
+"PostalCity": "Woodmere"
+"PostalCodePlus4": "1718"
+"PreviousListPrice": 1595000
+"PriceChangeTimestamp": "2026-06-03T19:06:53Z"
+"RoomsTotal": "10"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-12T22:01:31Z"
+"StreetName": "Singleton"
+"StreetNumber": "994"
+"StreetNumberNumeric": "994"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "10134.21"
+"TaxAssessedValue": 401
+"TaxYear": "2024"
+"Utilities": array:2 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "Full"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1545000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "2302.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "671.15552"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "19168734.4913"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "671.15552"
+"KEY_SourceSystemModificationTimestamp": "2026-05-08T10:21:44.953"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "671.15552"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.96865"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "671.15552"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424815179')"
+"provider_name": "One Key"
+"Media": array:19 [
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]
]
+"ID": "31249"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5299
+post_id: "31197"
+post_author: 1
+"ListingKey": "KEY424814565"
+"ListingId": "996892"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-16T12:14:36Z"
+"RFModificationTimestamp": "2026-05-16T12:19:15Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 1800.0
+"BuildingAreaTotal": 1800.0
+"City": "Hempstead"
+"PostalCode": "11563"
+"UnparsedAddress": "7 Bristol Street, Hempstead, New York 11563"
+"Coordinates": array:2 [
0 => -73.6635607
1 => 40.6662696
]
+"Latitude": 40.6662696
+"Longitude": -73.6635607
+"YearBuilt": 1929
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Sunita Singh"
+"ListOfficeName": "ILAND Realty"
+"ListAgentMlsId": "173303"
+"ListOfficeMlsId": "ILN01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This beautifully renovated home offers all you've been looking for: a well lit, spacious interior with 6 large bedrooms, 3 newly renovated bathrooms, open living room, formal dining area, an eat in kitchen with new stainless steel appliances and granite countertops, a fully finished basement, brand new gas heating system, new floors, new light fixtures, a cozy sunroom, entry foyer, separate entrance to the basement, a private backyard, garage and a newly paved driveway. This property is a short walk from shopping, dining, schools and a short drive to highways, LIRR, JFK airport and Long Island beaches. Located in Malverne school district in the Village of Lynbrook, this house brings together the charm of suburban living along with the convenience of a short commute to NYC via public transport or private transport. Priced to sell!"
+"Appliances": array:5 [
0 => "Dishwasher"
1 => "Gas Range"
2 => "Microwave"
3 => "Refrigerator"
4 => "Stainless Steel Appliance(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Exp Cape"
]
+"AttributionContact": "718-820-3378"
+"Basement": array:1 [
0 => "Full"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "718-820-3378"
+"CoListAgentEmail": "ilandrealty@gmail.com"
+"CoListAgentFullName": "Pars Singh"
+"CoListAgentKey": "326183693"
+"CoListAgentMlsId": "172628"
+"CoListOfficeKey": "326112256"
+"CoListOfficeMlsId": "ILN01"
+"CoListOfficeName": "ILAND Realty"
+"CoListOfficePhone": "718-820-3378"
+"ConstructionMaterials": array:3 [
0 => "Shingle Siding"
1 => "Stucco"
2 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-08T14:00:11.550666+00:00"
+"CrossStreet": "Lakeview Avenue"
+"CumulativeDaysOnMarket": 1
+"DaysOnMarket": 40
+"Directions": "Southern Parkway Exit 17S to Ocean Ave to Lakeview Ave to Bristol St."
+"ElementarySchool": "Davison Avenue Intermediate School"
+"ElementarySchoolDistrict": "Malverne"
+"ExpirationDate": "2027-05-06"
+"FireplaceYN": true
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Malverne Senior High School"
+"HighSchoolDistrict": "Malverne"
+"InteriorFeatures": array:4 [
0 => "First Floor Bedroom"
1 => "Eat-in Kitchen"
2 => "Entrance Foyer"
3 => "Granite Counters"
]
+"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": "347-440-3822"
+"ListAgentEmail": "sunitadeswal@gmail.com"
+"ListAgentKey": "326184324"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112256"
+"ListOfficePhone": "718-820-3378"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-07"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.0918
+"LotSizeSquareFeet": 4000
+"MajorChangeTimestamp": "2026-05-15T04:31:17Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Howard T Herber Middle School"
+"MiddleOrJuniorSchoolDistrict": "Malverne"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-15"
+"OriginalEntryTimestamp": "2026-05-08T13:55:53Z"
+"OriginalListPrice": 899900
+"OriginatingSystemModificationTimestamp": "2026-05-16T12:13:15Z"
+"OwnerName": "Millennium Contracting & Mgmt"
+"ParcelNumber": "2025-38-049-00-0563-0"
+"ParkingFeatures": array:2 [
0 => "Driveway"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-16T12:14:36Z"
+"PhotosCount": 20
+"PostalCity": "Lynbrook"
+"PostalCodePlus4": "1805"
+"PriceChangeTimestamp": "2026-05-08T13:55:53Z"
+"RoomsTotal": "10"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "347-440-3822"
+"ShowingRequirements": array:1 [
0 => "See Remarks"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-15T04:31:17Z"
+"StreetName": "Bristol"
+"StreetNumber": "7"
+"StreetNumberNumeric": "7"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "10790"
+"TaxAssessedValue": 508
+"TaxYear": "2024"
+"Utilities": array:4 [
0 => "Electricity Connected"
1 => "Natural Gas Connected"
2 => "Sewer Connected"
3 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "Scuttle,See Remarks"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "899900.00"
+"KEY_PreviousStatus": "Coming Soon"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1800.00"
+"KEY_ShowingContactPhone2": "718-820-3378"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "499.94444"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "9802832.2440"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "499.94444"
+"KEY_SourceSystemModificationTimestamp": "2026-05-08T09:55:53.747"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "499.94444"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "499.94444"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424814565')"
+"provider_name": "One Key"
+"Media": array:20 [
0 => array:12 [ …12]
1 => array:12 [ …12]
2 => array:12 [ …12]
3 => array:12 [ …12]
4 => array:12 [ …12]
5 => array:12 [ …12]
6 => array:12 [ …12]
7 => array:12 [ …12]
8 => array:12 [ …12]
9 => array:12 [ …12]
10 => array:12 [ …12]
11 => array:12 [ …12]
12 => array:12 [ …12]
13 => array:12 [ …12]
14 => array:12 [ …12]
15 => array:12 [ …12]
16 => array:12 [ …12]
17 => array:12 [ …12]
18 => array:12 [ …12]
19 => array:13 [ …13]
]
+"ID": "31197"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5300
+post_id: "31352"
+post_author: 1
+"ListingKey": "KEY424813663"
+"ListingId": "996872"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T16:39:38Z"
+"RFModificationTimestamp": "2026-06-20T16:40:54Z"
+"ListPrice": 284900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 800.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11563"
+"UnparsedAddress": "185 Atlantic Avenue Unit B-10, Hempstead, New York 11563"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1920
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Tory E. Foster"
+"ListOfficeName": "BERKSHIRE HATHAWAY"
+"ListAgentMlsId": "83123"
+"ListOfficeMlsId": "BHHS04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Huge 1 Bedroom Apartment W/High Ceilings. Parking, Gym, Laundry Room, Storage. 30 Minutes To Penn Station, Close to shopping, beaches & highway and public transportation. Must see!!!"
+"Appliances": array:3 [
0 => "Dishwasher"
1 => "Gas Oven"
2 => "Refrigerator"
]
+"ArchitecturalStyle": array:2 [
0 => "Mid Rise"
1 => "Other"
]
+"AssociationAmenities": "Fitness Center,Landscaping,Maintenance Grounds,Snow Removal"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:8 [
0 => "Common Area Maintenance"
1 => "Grounds Care"
2 => "Heat"
3 => "Hot Water"
4 => "Sewer"
5 => "Snow Removal"
6 => "Trash"
7 => "Water"
]
+"AttributionContact": "516-295-3000"
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"CommonWalls": array:1 [
0 => "1 Common Wall"
]
+"CommunityFeatures": array:1 [
0 => "Fitness Center"
]
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Wall/Window Unit(s)"
]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-20T15:28:12.437836+00:00"
+"CrossStreet": "Carter Court"
+"CumulativeDaysOnMarket": 31
+"DaysOnMarket": 35
+"Directions": "South Of Sunrise Highway."
+"ElementarySchool": "Marion Street School"
+"ElementarySchoolDistrict": "Lynbrook"
+"EntryLevel": 2
+"ExpirationDate": "2026-12-04"
+"Flooring": array:1 [
0 => "Wood"
]
+"Heating": array:2 [
0 => "Natural Gas"
1 => "Steam"
]
+"HighSchool": "Lynbrook Senior High School"
+"HighSchoolDistrict": "Lynbrook"
+"InteriorFeatures": array:4 [
0 => "Eat-in Kitchen"
1 => "Entrance Foyer"
2 => "High Ceilings"
3 => "Storage"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In Basement"
]
+"Levels": array:1 [
0 => "One"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "toryrealty2@aol.com"
+"ListAgentKey": "326244336"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109740"
+"ListOfficePhone": "516-295-3000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-20"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2026-06-12T16:10:21Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Lynbrook South Middle School"
+"MiddleOrJuniorSchoolDistrict": "Lynbrook"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-20"
+"OriginalEntryTimestamp": "2026-05-20T15:23:03Z"
+"OriginalListPrice": 289000
+"OriginatingSystemModificationTimestamp": "2026-06-20T16:38:18Z"
+"OwnerName": "Lembo"
+"ParkingFeatures": array:2 [
0 => "Assigned"
1 => "Parking Lot"
]
+"ParkingTotal": "1"
+"PetsAllowed": array:2 [
0 => "Cats OK"
1 => "Number Limit"
]
+"PhotosChangeTimestamp": "2026-06-12T16:53:36Z"
+"PhotosCount": 12
+"PostalCity": "Lynbrook"
+"PreviousListPrice": 274900
+"PriceChangeTimestamp": "2026-06-12T16:10:21Z"
+"RoomsTotal": "3"
+"SecurityFeatures": array:2 [
0 => "Security System"
1 => "Video Cameras"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-567-2606"
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-20T15:23:03Z"
+"StoriesTotal": "3"
+"StreetName": "Atlantic"
+"StreetNumber": "185"
+"StreetNumberNumeric": "185"
+"StreetSuffix": "Avenue"
+"StructureType": array:1 [
0 => "Mid Rise"
]
+"SubdivisionName": "Atlantic Gardens"
+"SyndicateTo": array:1 [
0 => "Realtor.com"
]
+"UnitNumber": "B-10"
+"Utilities": array:1 [
0 => "Sewer Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"KEY_Attic": "None"
+"KEY_Village": "Lynbrook"
+"KEY_FlipTaxYN": "0"
+"KEY_ParkingFee": "75"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "284900.00"
+"KEY_FlipTaxAmount": "$10/share"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "4"
+"KEY_SharesNumberOf": "345"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_RentingAllowedYN": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "Price Increase"
+"KEY_PropertyDescription": "Mid Rise"
+"KEY_EstimatedMaintenance": "1131"
+"KEY_LivingAreaSearchSqFt": "800.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-295-3000"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "10"
+"KEY_MinimumIncomeRequiredYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "356.12500"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "356.12500"
+"KEY_SourceSystemModificationTimestamp": "2026-05-08T09:30:00.897"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.98581"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424813663')"
+"provider_name": "One Key"
+"Media": array:12 [
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]
]
+"ID": "31352"
}
10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5301
+post_id: "31233"
+post_author: 1
+"ListingKey": "KEY424808141"
+"ListingId": "996768"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-05-28T07:15:37Z"
+"RFModificationTimestamp": "2026-05-28T07:17:44Z"
+"ListPrice": 1649000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3105.0
+"BuildingAreaTotal": 8002.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "2667 Wynsum Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [
0 => -73.5414604
1 => 40.6552984
]
+"Latitude": 40.6552984
+"Longitude": -73.5414604
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Marci Imber"
+"ListOfficeName": "Realty Connect USA LLC"
+"ListAgentMlsId": "9070310"
+"ListOfficeMlsId": "RLLE02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Better than new, this exceptional 2020 custom Colonial in prime South Merrick blends timeless elegance with today’s most sought-after smart home luxury. From the moment you enter, you’re greeted by soaring 10-foot coffered ceilings, exquisite wainscoting, rich red oak flooring, and impeccable custom millwork throughout. Designed for both grand entertaining and everyday comfort, the gourmet chef’s kitchen is a true showpiece, featuring top-of-the-line Viking appliances, quartz countertops, custom shaker cabinetry with glass transoms, a massive center island with microwave drawer, farm sink, pot filler, 6 burner gas range and second oven, vented hood, and an oversized walk-in pantry.\n
Every detail has been thoughtfully curated — from the custom built-in bar and marble-accented gas fireplace to the luxurious primary suite with a room-sized custom closet and spa-inspired bath complete with freestanding soaking tub and oversized rain shower. Five spacious bedrooms, three full baths upstairs, second-floor laundry, central vac, surround sound wiring, Andersen windows, Hunter Douglas treatments, solid core doors, and professionally outfitted closets elevate the home even further.\n
This fully integrated smart home offers remote control of lighting, climate, security, garage doors, irrigation, locks, and more — delivering modern convenience at your fingertips. Outside, enjoy beautifully landscaped grounds with a composite front porch, paver walkways and patio, PVC fencing, and a two-car garage. A rare offering where craftsmanship, sophistication, and technology come together seamlessly. Too much to list — this is luxury living at its finest.
"""
+"Appliances": array:15 [
0 => "Cooktop"
1 => "Dishwasher"
2 => "Disposal"
3 => "Dryer"
4 => "ENERGY STAR Qualified Appliances"
5 => "Gas Cooktop"
6 => "Gas Oven"
7 => "Gas Range"
8 => "Microwave"
9 => "Oven"
10 => "Range"
11 => "Refrigerator"
12 => "Stainless Steel Appliance(s)"
13 => "Tankless Water Heater"
14 => "Washer"
]
+"ArchitecturalStyle": array:1 [
0 => "Colonial"
]
+"AttributionContact": "mimber@aol.com"
+"Basement": array:1 [
0 => "Crawl Space"
]
+"BathroomsFull": 3
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-459-7222"
+"BuyerAgentEmail": "SARAH.DASILVA@ELLIMAN.COM"
+"BuyerAgentFullName": "Sarah R. Dasilva"
+"BuyerAgentKey": "326227572"
+"BuyerAgentMlsId": "218555"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110766"
+"BuyerOfficeMlsId": "DERE28"
+"BuyerOfficeName": "Douglas Elliman Real Estate"
+"BuyerOfficePhone": "516-623-4500"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "631-834-1892"
+"CoListAgentEmail": "smdelouya@gmail.com"
+"CoListAgentFullName": "Shari M. DeLouya CBR"
+"CoListAgentKey": "326119600"
+"CoListAgentMlsId": "103104"
+"CoListOfficeKey": "326115083"
+"CoListOfficeMlsId": "RLLE02"
+"CoListOfficeName": "Realty Connect USA LLC"
+"CoListOfficePhone": "516-714-3606"
+"ConstructionMaterials": array:3 [
0 => "Blown-In Insulation"
1 => "Shingle Siding"
2 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-12T02:38:00.163118+00:00"
+"CrossStreet": "Arthur"
+"CumulativeDaysOnMarket": 16
+"DaysOnMarket": 16
+"DirectionFaces": "West"
+"Directions": "Merrick Road to Wynsum Ave house on Left hand side"
+"ElementarySchool": "Norman J Levy Lakeside School"
+"ElementarySchoolDistrict": "Merrick"
+"Exclusions": "LR Chandelier, Beverage refrigerator"
+"ExpirationDate": "2026-11-14"
+"Fencing": array:1 [
0 => "Full"
]
+"FireplaceFeatures": array:3 [
0 => "Family Room"
1 => "Gas"
2 => "Living Room"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"Inclusions": "Swing set"
+"InteriorFeatures": array:23 [
0 => "Built-in Features"
1 => "Cathedral Ceiling(s)"
2 => "Central Vacuum"
3 => "Chefs Kitchen"
4 => "Crown Molding"
5 => "Double Vanity"
6 => "Entertainment Cabinets"
7 => "Entrance Foyer"
8 => "High Ceilings"
9 => "High Speed Internet"
10 => "Natural Woodwork"
11 => "Open Floorplan"
12 => "Open Kitchen"
13 => "Pantry"
14 => "Primary Bathroom"
15 => "Quartz/Quartzite Counters"
16 => "Recessed Lighting"
17 => "Smart Thermostat"
18 => "Sound System"
19 => "Storage"
20 => "Tray Ceiling(s)"
21 => "Walk-In Closet(s)"
22 => "Wired for Sound"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Laundry Room"
]
+"Levels": array:1 [
0 => "Bi-Level"
]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-993-4721"
+"ListAgentEmail": "mimber@aol.com"
+"ListAgentKey": "326260685"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115083"
+"ListOfficePhone": "516-714-3606"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-05-08"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.18
+"LotSizeSquareFeet": 8002
+"MajorChangeTimestamp": "2026-05-27T18:58:30Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-05-27"
+"OnMarketDate": "2026-05-11"
+"OriginalEntryTimestamp": "2026-05-12T02:34:25Z"
+"OriginalListPrice": 1649000
+"OriginatingSystemModificationTimestamp": "2026-05-27T18:58:30Z"
+"OwnerName": "Name Withheld"
+"ParcelNumber": "2089-63-126-00-0004-0"
+"ParkingFeatures": array:5 [
0 => "Attached"
1 => "Driveway"
2 => "Garage"
3 => "On Street"
4 => "Private"
]
+"PatioAndPorchFeatures": array:2 [
0 => "Patio"
1 => "Porch"
]
+"PhotosChangeTimestamp": "2026-05-08T14:09:36Z"
+"PhotosCount": 48
+"PostalCity": "Merrick"
+"PropertyAttachedYN": true
+"PropertyCondition": array:1 [
0 => "Actual"
]
+"PurchaseContractDate": "2026-05-27"
+"RoomsTotal": "9"
+"SecurityFeatures": array:4 [
0 => "Fire Alarm"
1 => "Security System"
2 => "Smoke Detector(s)"
3 => "Video Cameras"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "(855)920-8240"
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-27T18:58:30Z"
+"StreetName": "Wynsum"
+"StreetNumber": "2667"
+"StreetNumberNumeric": "2667"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "15497"
+"TaxBlock": "126"
+"TaxLot": "4"
+"TaxYear": "2026"
+"Utilities": array:5 [
0 => "Cable Connected"
1 => "Electricity Connected"
2 => "Natural Gas Connected"
3 => "Sewer Connected"
4 => "Water Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WindowFeatures": array:1 [
0 => "Double Pane Windows"
]
+"KEY_Attic": "Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "63"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1649000.00"
+"KEY_ContractPrice": "1649000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "3105.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "531.07890"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "9161111.1111"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "531.07890"
+"KEY_SourceSystemModificationTimestamp": "2026-05-07T18:46:24.127"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "206.07348"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "206.07348"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424808141')"
+"provider_name": "One Key"
+"Media": array:48 [
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]
38 => array:12 [ …12]
39 => array:12 [ …12]
40 => array:12 [ …12]
41 => array:12 [ …12]
42 => array:12 [ …12]
43 => array:12 [ …12]
44 => array:12 [ …12]
45 => array:12 [ …12]
46 => array:12 [ …12]
47 => array:12 [ …12]
]
+"ID": "31233"
}
11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5302
+post_id: "31190"
+post_author: 1
+"ListingKey": "KEY424806944"
+"ListingId": "996726"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-06-19T13:58:36Z"
+"RFModificationTimestamp": "2026-06-19T14:00:55Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1400.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "421 Marina Pointe Drive Unit 421, Hempstead, New York 11518"
+"Coordinates": array:2 [
0 => -73.6230362
1 => 40.7092836
]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Matthew Hart"
+"ListOfficeName": "World Prop Intl Sea to Sky"
+"ListAgentMlsId": "112688"
+"ListOfficeMlsId": "WOPR01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Waterfront Townhome | Balcony Water Views | Steps to LIRR | Move-In Ready. This exceptional townhouse in East Rockaway features balcony water views, luxury finishes, and 1-minute walk to the LIRR-just 25 minutes to Manhattan. Located in the highly desirable Marina Pointe community, this move-in-ready 2-bedroom, 2.5-bath condominium offers approximately 1,400 square feet of bright, open-concept living space. The main level features a sun-filled living room and dining area with southern exposure and sliding doors to a private balcony overlooking the water-perfect for relaxing or entertaining. The modern eat-in kitchen includes a large center island, quartz countertops, stainless steel appliances, pantry, and ample cabinet space, ideal for everyday living and hosting. Spacious primary bedroom features private en-suite bathroom, with two ample closet spaces, including one walk-in with built-in storage features. A convenient half bath on the main level adds flexibility for guests. Laundry room includes in-unit stackable washer and dryer with custom built-ins, along with office workspace. Additional features include central air conditioning, hardwood flooring, recessed lighting, high ceilings, and a new hot water heater. This home includes covered parking spaces and a private outdoor storage unit. Guest parking available. Marina Pointe residents enjoy resort-style amenities including waterfront walking paths, picnic areas, BBQ area, bocce court, and dog-friendly spaces. Boat slips are available for an additional fee. Prime location directly across from the East Rockaway LIRR station and Lidl grocery store, with easy walkable access to shopping, restaurants, parks, and close proximity to Long Island’s South Shore beaches. HOA includes water, exterior maintenance, sprinkler and alarm systems, and flood insurance. Property tax abatement in place through 2029. Pet-friendly, commuter-friendly, and turnkey—this is waterfront living at its best."
+"Appliances": array:1 [
0 => "Stainless Steel Appliance(s)"
]
+"AssociationFee": "760"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:8 [
0 => "Common Area Maintenance"
1 => "Exterior Maintenance"
2 => "Grounds Care"
3 => "Hot Water"
4 => "Sewer"
5 => "Snow Removal"
6 => "Trash"
7 => "Water"
]
+"AssociationYN": true
+"AttributionContact": "631-961-4626"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-865-2448"
+"BuyerAgentEmail": "ngiannone@coachrealtors.com"
+"BuyerAgentFullName": "Nancy J. Giannone CBR"
+"BuyerAgentKey": "326190709"
+"BuyerAgentMlsId": "180217"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110103"
+"BuyerOfficeMlsId": "CARE17"
+"BuyerOfficeName": "Howard Hanna Coach"
+"BuyerOfficePhone": "516-746-5511"
+"CarportSpaces": "3"
+"CarportYN": true
+"CommonWalls": array:1 [
0 => "2+ Common Walls"
]
+"ConstructionMaterials": array:2 [
0 => "Frame"
1 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-07T21:44:45.564513+00:00"
+"CumulativeDaysOnMarket": 20
+"DaysOnMarket": 20
+"ElementarySchool": "Rhame Avenue Elementary School"
+"ElementarySchoolDistrict": "East Rockaway"
+"EntryLevel": 1
+"ExpirationDate": "2026-06-07"
+"Heating": array:2 [
0 => "Electric"
1 => "Natural Gas"
]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:2 [
0 => "First Floor Bedroom"
1 => "First Floor Full Bath"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-961-4626"
+"ListAgentEmail": "matthew@wpinewyork.com"
+"ListAgentKey": "326128575"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326116516"
+"ListOfficePhone": "631-961-4626"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2026-05-07"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.2004
+"LotSizeSquareFeet": 8728
+"MajorChangeTimestamp": "2026-05-28T01:25:15Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-05-27"
+"OnMarketDate": "2026-05-07"
+"OriginalEntryTimestamp": "2026-05-07T21:35:58Z"
+"OriginalListPrice": 750000
+"OriginatingSystemModificationTimestamp": "2026-06-19T13:57:12Z"
+"OwnerName": "Christopher Lavin"
+"ParcelNumber": "2089-43-055-00-0413-UCA029700421"
+"ParkingFeatures": array:1 [
0 => "Assigned"
]
+"PatioAndPorchFeatures": array:1 [
0 => "Porch"
]
+"PetsAllowed": array:1 [
0 => "Yes"
]
+"PhotosChangeTimestamp": "2026-05-07T21:37:36Z"
+"PhotosCount": 40
+"PostalCity": "East Rockaway"
+"PostalCodePlus4": "2070"
+"PriceChangeTimestamp": "2026-05-07T21:35:58Z"
+"PropertyAttachedYN": true
+"PurchaseContractDate": "2026-05-27"
+"RoomsTotal": "5"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "516-728-1537"
+"ShowingRequirements": array:2 [
0 => "Call Owner"
1 => "See Remarks"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-28T01:25:15Z"
+"StreetName": "Marina Pointe"
+"StreetNumber": "421"
+"StreetNumberNumeric": "421"
+"StreetSuffix": "Drive"
+"StructureType": array:1 [
0 => "Townhouse"
]
+"SyndicateTo": array:2 [
0 => "Realtor.com"
1 => "OneKeyMLS.com"
]
+"TaxAnnualAmount": "5246"
+"TaxAssessedValue": 585
+"TaxYear": "2026"
+"UnitNumber": "421"
+"Utilities": array:1 [
0 => "Electricity Connected"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WaterfrontFeatures": array:2 [
0 => "Bulkhead"
1 => "Canal Front"
]
+"WaterfrontYN": true
+"KEY_Attic": "None"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "750000.00"
+"KEY_ContractPrice": "740000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_BuyerRepresentation": "Buyer's Agent"
+"KEY_LivingAreaSearchSqFt": "1400.00"
+"KEY_ShowingContactPhone2": "516-728-1537"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "535.71429"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3742514.9701"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "535.71429"
+"KEY_SourceSystemModificationTimestamp": "2026-05-07T17:20:05.943"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424806944')"
+"provider_name": "One Key"
+"Media": array:40 [
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]
38 => array:12 [ …12]
39 => array:12 [ …12]
]
+"ID": "31190"
}
]
+success: true
+page_size: 12
+page_count: 239
+count: 2859
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]