Begin your home search journey in Merrick, NY by browsing available listings in one place. This page is dedicated to showcasing current homes for sale, complete with essential details such as property type, Price filter, and zip code search. Whether you’re searching for your first home or your next upgrade, Merrick offers a variety of options to meet your needs. View homes with pools, renovated kitchens, or generous backyard space—all with current pricing and images. Start exploring the Merrick housing market today and filter your search based on your must-have features, budget, and lifestyle goals.
Our simple, step-by-step process ensures a smooth experience for buying new property without any worries or hustle.
Go through the our all listings and find the ideal home that is relevant for your requirements.
Click on the listing you like and then fill out the form to get start with your buying journey.
We guide buyers through offers and agreements to secure the best outcomes.
We handle all paperwork, ensure a smooth closing process, and support you through your next steps.
Our simple, step-by-step process ensures a smooth experience for buying new property without any worries or hustle.
We know Merrick NY street by street — not just by ZIP code. From districts to commute routes, we help you buy smarter based on real neighborhood insight.
You won’t find any sales pressure here. We focus on what works best for you, offering honest input so you can make confident, informed choices.
You won’t be left waiting on answers. We stay connected through every step of the process, so your questions get real replies — not delays.
We tap into local networks to get early access to listings — giving you a head start in a competitive market.
From inspections to paperwork, we manage the chaos so you can focus on the fun part — finding a place you’ll love.
Tight schedule? Need to tour after hours or on weekends? We’re flexible. We work how and when it’s convenient for you.
It’s not just about buying now — we’ll help you choose a home that fits future needs too, like family growth or property value trends.
We’re not here to just close a deal. We look out for your best interest like we would for our own family. Every decision is made with care.
Read what our clients have to say about their experience with us
I highly recommend Kaya Homes if you are looking to buy or sell your home. My home was sold for over ask within 1 week! The process was so simple and easy. Avi had a professional photographer photograph our home and has excellent marketing strategies which led to a speedy transaction. Thank you !!!
Bad Services.
KAYA Homes, and specifically Kamy, is a real estate business with a heart. Before I signed a contract Kamy gave me months of her time, business acumen and understanding. I have bought/sold my homes over many decades. Never have I known a realtor to be so incredibly kind. Everything about how KAYA Homes conduct their business is above reproach.
I had the absolute pleasure of working with Kamy when leasing my new apartment, and I couldn't be happier with the experience! She was fantastic to work with, simplifying the rental process and providing thorough explanations every step of the way. Highly recommend!
This is the third year im using Kaya Homes for my rental, they are very professional. They walk you through everything from start to finish. The owner Kami is awesome!! She is very responsive A+ I highly recommend kaya homes!!
We started our journey with Kaya homes a while back when my husband met Kamy. He knew instantly that we found the right ones to help us with purchasing a new home. Kamy is highly responsive, thoughtful, considerate and very professional on her approach with finding you the right home. We wanted to stay in the area and with such a crazy market, I didn't think it would be possible for us to find our home, but we did. Kamy's reassured us and said we will find your home and we did. Thank you Kamy and also meeting Izzy was a bonus, great family owned business, truly you will not be disappointed. If you are looking to rent, own or sell give them a call.
Absolutely wonderful to work with! I highly suggest if you are looking or selling she is definitely your go to!
Amazing experience with Kaya Homes. She was very helpful and found us our dream home as fast as anyone could wish for!
WOW! Kamy went above and beyond to find us an apartment, my lease was over and I needed to move ASAP and couldn’t find any rentals but when I got in contact with Kamy at Kaya Homes she casted all my worries and stress away. I’ve worked with other realtors in the past which was ok but Kaya Homes over exceeded all of my expectations. Kamy was able to find us a beautiful contemporary apartment in the neighborhood that I appointed and that fit right in our price range within a month we moved in. Kamy is extremely kind, friendly, transparent professional, communicative and easy to reach to answer any of our questions at all times. In addition, since we’ve moved the landlord continues to maintain the apartment beautifully: they provide a cleaning service who comes in to clean inside and outside the complex, landscaper comes weekly, the garbage is pick up 2-3x a week, if there’s ever any issue or something needs fixing they send someone the next day which is a plus because you know they CARE AND APPRECIATE THEIR TENANTS. I recommend Kaya Homes to all my friends & family and to anyone who needs a realtor because they are simply the VERY BEST IN THE BUSINESS. Thank you again Kamy.
I had the pleasure of working on my home selling with Kaya homes and specialty with Kamy Roditi who is a very professional and reliable person. Kamy worked very on my transaction with a fair and quick way and honestly without her my home would not have been sold as fast and for the best possible price as it was. I would highly recomand Kaya homes and Kamy for any Real Estate and business venture, selling and buying Real Estate .
If you are in the market for a new home, I highly recommend going to see Kamy Roditi @ Kaya Homes. She is one of the most knowledgeable realtors I've ever met in the industry hands down. She's honest, trustworthy, responsive and an all around pleasure to work with. She worked diligently to help find the perfect house for my family and smoothly guided me through the process by answering all of my questions thoroughly. Buying a new home can be stressful, but it doesn't have to be if your lucky enough to work with Kamy Roditi. You'll be in good hands, I promise!
I thought about selling my house myself and I’m so glad I didn’t. Kaya Homes was a total blessing for me, the buyers of my home were beyond difficult and they handled every step for me beyond my expectations. They took the stress off of me entirely. I’d highly recommend them to anyone. Thank you again Kaya Homes!!
Highly recommend the team at Kaya Homes. The team is not only knowledgeable but also provides great advice for all real estate needs. Weather your looking to buy, sell, rent or get advice, Kaya homes should be your first call.
array:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=32&$skip=32&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (City eq 'Merrick' or PostalCity eq 'Merrick')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5269 +items: array:32 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5283 +post_id: "31283" +post_author: 1 +"ListingKey": "KEY424920589" +"ListingId": "999713" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-26T21:25:36Z" +"RFModificationTimestamp": "2026-05-26T21:30:09Z" +"ListPrice": 1299000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2304.0 +"BuildingAreaTotal": 2304.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "11 Ranch Place, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6676706 +"Longitude": -73.549666 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jonathan Schuman" +"ListOfficeName": "Blue Island Homes NY LLC" +"ListAgentMlsId": "205023" +"ListOfficeMlsId": "BLHM01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome To Your Merrick Woods Dream Home! Checkout This Fully Gut Renovated, 4 Bedroom/3 Bathroom Ranger Ranch In The Heart Of Merrick Woods On A Tree-Lined Street With Well Maintained Homes. On The Main Level, This Incredible Home Features An Airy Open Concept Layout With A Unique Large Loft Overlooking The Main Level, Formal Living Room With Soaring Vaulted Ceilings, Two Story Fireplace With Beautiful Stonework & Wood Mantel, New 7.5” Wide Plank Engineered Hardwood Flooring Throughout The Entire House, All-New Chef’s Eat-In Kitchen With Large Center Island, Stainless Steel Appliances, Quartz Countertop & Backsplash, Natural Gas Cooking & Elegant Under Cabinet Lighting, Spacious Formal Dining Room With Room For An Extra Large Table Or An Additional Sitting Area, Lots Of Natural Light, Plenty Of Storage/Closet Space Throughout, Dedicated Laundry Room With New Washer, Dryer & Sink. Additionally, Your 4 Bedrooms Include The Primary Bedroom With Two Large Closets & An Expanded En-Suite Bathroom With Extra Large Shower With Stunning Herringbone Tile Accent Wall, (1st Floor Primary Bedroom!), New Electrical (Full Re-Wire!) & New Recessed Lighting & New Fixtures Throughout, New Plumbing (Full Re-Pipe!), New Navien Gas Boiler, New Rudd HVAC System & New Ductwork, New Insulation Throughout The Entire House And More! Your Exterior Features New James Hardie Board Siding (On All 4 Sides) & Beautiful Stonework, All New Large Windows, New Sliding Door, New Architectural Roofing, New Gutters & Soffits, New Craftsman Style Front Door, New Insulated Garage Door, All New Masonry Work Including A Full Paver Porch, Paver Walkway & Backyard Paver Patio In The Backyard (All Cambridge Pavers), New Asphalt Driveway With Paver Border, Fully Fenced Backyard With Space For A Pool And So Much More!! About 1/4 Mile To The LIRR And Just A 44-46 Minute Train Ride To NYC! Close Proximity To Shops, Dining, Schools, Houses Of Worship, Major Highways & Parkways And Just 12 Mins To Jones Beach. A Truly Rare Opportunity To Own A Turnkey “Ranger Ranch” Style Home In Highly Sought After Merrick Woods!" +"Appliances": array:10 [ …10] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-613-3600" +"BathroomsFull": 3 +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-417-0714" +"BuyerAgentEmail": "soldbystephanieny@gmail.com" +"BuyerAgentFullName": "Stephanie Leger" +"BuyerAgentKey": "423757433" +"BuyerAgentMlsId": "506453" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326111209" +"BuyerOfficeMlsId": "EREA02" +"BuyerOfficeName": "EXIT Realty Premier" +"BuyerOfficePhone": "516-795-1000" +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "516-790-0721" +"CoBuyerAgentEmail": "Boylansells@gmail.com" +"CoBuyerAgentFullName": "Chris J. Boylan" +"CoBuyerAgentKey": "326188717" +"CoBuyerAgentMlsId": "178073" +"CoBuyerOfficeKey": "326111209" +"CoBuyerOfficeMlsId": "EREA02" +"CoBuyerOfficeName": "EXIT Realty Premier" +"CoBuyerOfficePhone": "516-795-1000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-14T12:59:16.123942+00:00" +"CrossStreet": "Range Drive" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 8 +"Directions": "Sunrise Hwy To Hewlett Ave, Right On Smith Street, Left On Range Dr, Right On Ranch Place" +"Disclosures": array:1 [ …1] +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-14" +"Fencing": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:18 [ …18] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-359-1353" +"ListAgentEmail": "jonathan@blueislandhomesny.com" +"ListAgentKey": "326214445" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109840" +"ListOfficePhone": "516-613-3600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-14" +"LivingAreaSource": "Other" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.1607 +"LotSizeSquareFeet": 7000 +"MajorChangeTimestamp": "2026-05-26T21:24:23Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-22" +"OnMarketDate": "2026-05-14" +"OriginalEntryTimestamp": "2026-05-14T12:55:03Z" +"OriginalListPrice": 1299000 +"OriginatingSystemModificationTimestamp": "2026-05-26T21:24:23Z" +"OwnerName": "11 Ranch Place Llc" +"ParcelNumber": "2089-56-439-00-0002-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-18T07:47:36Z" +"PhotosCount": 40 +"PostalCity": "Merrick" +"PostalCodePlus4": "3232" +"PurchaseContractDate": "2026-05-26" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-359-1353" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-26T21:24:23Z" +"StreetName": "Ranch" +"StreetNumber": "11" +"StreetNumberNumeric": "11" +"StreetSuffix": "Place" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "18516" +"TaxAssessedValue": 604 +"TaxYear": "2026" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"KEY_Attic": "Crawl,Storage" +"KEY_HoldDate": "2026-05-22" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1299000.00" +"KEY_ContractPrice": "1372000.00" +"KEY_OpenHouseCount": "3" +"KEY_PreviousStatus": "Hold" +"KEY_AdditionalRooms": "Dining Area,Loft" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2304.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "563.80208" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8083385.1898" +"KEY_RATIO_CurrentPrice_By_LivingArea": "563.80208" +"KEY_SourceSystemModificationTimestamp": "2026-05-14T08:00:02.397" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "563.80208" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "563.80208" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424920589')" +"provider_name": "One Key" +"Media": array:40 [ …40] +"ID": "31283" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5285 +post_id: "31295" +post_author: 1 +"ListingKey": "KEY424915987" +"ListingId": "999626" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-06-04T01:09:36Z" +"RFModificationTimestamp": "2026-06-04T01:14:56Z" +"ListPrice": 1499999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2916.0 +"BuildingAreaTotal": 3069.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "100 Byron Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.654081 +"Longitude": -73.5491395 +"YearBuilt": 1949 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Michael D. Toporek" +"ListOfficeName": "EXIT Realty Premier" +"ListAgentMlsId": "187947" +"ListOfficeMlsId": "EREA02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this stunning custom Colonial in the Lindenmere Estates section of South Merrick, where luxury, comfort, and exceptional craftsmanship come together seamlessly. Designed for both elegant everyday living and high-end entertaining, this remarkable residence showcases premium finishes and thoughtful upgrades throughout.\n \n Step outside to your own resort-style backyard oasis. The porcelain-paved outdoor space is centered around a spectacular heated 8-foot deep pool with a waterfall feature, creating the ultimate setting for relaxation and entertaining. The fully equipped outdoor kitchen is truly unparalleled, featuring luxurious dolomite countertops, a pizza oven, refrigerator, sink, beverage center, glass washer station, ice chest, built-in storage, fan, Bluetooth speakers, full LED lighting, and a 42-inch six-burner grill with dedicated TV outlets for the ultimate outdoor entertainment experience.\n \n Inside, the home is adorned with rich hardwood flooring and enhanced by modern conveniences including motion-sensor lighting and whole-home exterior security cameras. The spacious eat-in kitchen offers both style and functionality, featuring generous cabinetry, expansive prep space, and a deep sink perfectly suited for entertaining or daily living. A beautiful wood-burning fireplace adds warmth and character, creating an inviting atmosphere within the home’s elegant living space. \n \n The primary suite is a true private retreat, highlighted by soaring 10-foot ceilings, oversized 6-foot windows that fill the room with natural light, dual closets, and a spa-inspired en suite bathroom complete with radiant heated floors. Both bathrooms are beautifully appointed in marble, with the upstairs bath featuring dual vanities and exceptional storage space.\n \n Car enthusiasts and hobbyists will appreciate the extraordinary heated 3-car garage featuring impressive 13-foot ceilings, a lift, epoxy flooring, and a built-in Bluetooth stereo system. Even the heated driveway and front walkway add an additional level of luxury and convenience during every season.\n \n Recently refinished in 2026, the basement adds exceptional additional living space and flexibility. Adding to the home’s exceptional value and efficiency are owned HUGO Green Solutions solar panels, helping maintain an approximate balanced electric billing of just $80 per month.\n \n Additional highlights include 7-zone heating and a 6-zone in-ground sprinkler system. Electric car charger. Plenty of storage room. Close proximity to Lakeside Elementary School, Cammanns Pond, Shops, and more. """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-236-3482" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "631-275-3336" +"BuyerAgentEmail": "robynschatz@compass.com" +"BuyerAgentFullName": "Robyn Schatz CBR" +"BuyerAgentKey": "326178449" +"BuyerAgentMlsId": "166935" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110401" +"BuyerOfficeMlsId": "CMPA04" +"BuyerOfficeName": "Compass Greater NY LLC" +"BuyerOfficePhone": "631-629-7719" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-946-9558" +"CoListAgentEmail": "peter@exitpremiersells.com" +"CoListAgentFullName": "Peter Raneri" +"CoListAgentKey": "326201713" +"CoListAgentMlsId": "191852" +"CoListOfficeKey": "326111209" +"CoListOfficeMlsId": "EREA02" +"CoListOfficeName": "EXIT Realty Premier" +"CoListOfficePhone": "516-795-1000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-14T15:48:33.641783+00:00" +"CrossStreet": "Lindenmere" +"CumulativeDaysOnMarket": 15 +"DaysOnMarket": 15 +"Directions": "GPS" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-11-13" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "3" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:12 [ …12] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-236-3482" +"ListAgentEmail": "michaeltoporek@exitpremiersells.com" +"ListAgentKey": "326198007" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111209" +"ListOfficePhone": "516-795-1000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-13" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.2202 +"LotSizeSquareFeet": 9590 +"MajorChangeTimestamp": "2026-06-02T05:17:28Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-29" +"OnMarketDate": "2026-05-14" +"OriginalEntryTimestamp": "2026-05-14T15:41:09Z" +"OriginalListPrice": 1499999 +"OriginatingSystemModificationTimestamp": "2026-06-04T01:08:29Z" +"OwnerName": "Damon L & Lori Boccadoro" +"ParcelNumber": "2089-62-026-00-0013-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "4" +"PhotosChangeTimestamp": "2026-05-14T15:43:37Z" +"PhotosCount": 50 +"PoolFeatures": array:2 [ …2] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "4632" +"PurchaseContractDate": "2026-06-01" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-02T05:17:28Z" +"StreetName": "Byron" +"StreetNumber": "100" +"StreetNumberNumeric": "100" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "23276" +"TaxAssessedValue": 825 +"TaxBlock": "026" +"TaxLot": "13" +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Pull Stairs" +"KEY_HoldDate": "2026-05-29" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "62" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1499999.00" +"KEY_ContractPrice": "1500000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Hold" +"KEY_SolarOwnership": "Owned" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2916.00" +"KEY_NumberOfHeatingZones": "7" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "514.40295" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6811984.5595" +"KEY_RATIO_CurrentPrice_By_LivingArea": "514.40295" +"KEY_SourceSystemModificationTimestamp": "2026-05-13T20:16:03.967" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "488.75823" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "488.75823" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424915987')" +"provider_name": "One Key" +"Media": array:50 [ …50] +"ID": "31295" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5282 +post_id: "31302" +post_author: 1 +"ListingKey": "KEY424911100" +"ListingId": "999520" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-07T19:10:37Z" +"RFModificationTimestamp": "2026-06-07T19:12:35Z" +"ListPrice": 849900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1445.0 +"BuildingAreaTotal": 1445.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1254 Parkwood Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6911202 +"Longitude": -73.5642573 +"YearBuilt": 1951 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jennifer E. Nader" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "85576" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Price Improvement!\n Welcome to this beautifully maintained home offering the perfect blend\n of comfort, style, and modern living. Filled with natural light, this home features four generously sized bedrooms, including a primary suite with a new private en-suite bathroom, for a total of 2 1/2 bathrooms, all new and designed with today’s buyer in mind. Gleaming hardwood floors flow throughout the home, while the inviting living room fireplace creates a warm and welcoming atmosphere. Sliding doors lead directly to the spacious backyard, making indoor-outdoor entertaining effortless. The fully functional finished basement provides exceptional bonus space ideal for a home office, recreation room, gym, or playroom. Recent upgrades include a new roof and gutters, new oil tank and oil burner offering peace of mind for years to come, along with new PVC fencing surrounding the entire property for added privacy. Situated on a large, irregularly shaped lot, the outdoor space is perfect for entertaining, relaxing, or creating your dream backyard oasis. Please see photos 35-37 for the lot description and house layout. """ +"Appliances": array:12 [ …12] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-14T17:45:12.210849+00:00" +"CumulativeDaysOnMarket": 24 +"DaysOnMarket": 34 +"ElementarySchool": "Harold D Fayette School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-12-21" +"ExteriorFeatures": array:2 [ …2] +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ …3] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentEmail": "jennader@verizon.net" +"ListAgentKey": "326246179" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-14" +"LivingAreaSource": "Public Records" +"LotFeatures": array:2 [ …2] +"LotSizeAcres": 0.163 +"LotSizeSquareFeet": 7100 +"MajorChangeTimestamp": "2026-05-30T19:02:03Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-05-14" +"OriginalEntryTimestamp": "2026-05-14T17:43:08Z" +"OriginalListPrice": 869000 +"OriginatingSystemModificationTimestamp": "2026-06-07T19:08:18Z" +"OtherStructures": array:1 [ …1] +"OwnerName": "Julian" +"ParcelNumber": "2089-55-540-00-0017-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-19T21:15:36Z" +"PhotosCount": 37 +"PostalCity": "Merrick" +"PostalCodePlus4": "1334" +"PreviousListPrice": 869000 +"PriceChangeTimestamp": "2026-05-30T19:02:03Z" +"RoomsTotal": "7" +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-650-0986" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-14T17:43:08Z" +"StreetName": "Parkwood" +"StreetNumber": "1254" +"StreetNumberNumeric": "1254" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13958.89" +"TaxAssessedValue": 495 +"TaxBlock": "540" +"TaxLot": "17" +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"KEY_Attic": "Partial,Pull Stairs,Storage,Unfinished" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "55-540" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "849900.00" +"KEY_OpenHouseCount": "1" +"KEY_AdditionalRooms": "Dining Area" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "1445.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "588.16609" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5214110.4294" +"KEY_RATIO_CurrentPrice_By_LivingArea": "588.16609" +"KEY_SourceSystemModificationTimestamp": "2026-05-13T16:25:39.743" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "588.16609" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97802" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "588.16609" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424911100')" +"provider_name": "One Key" +"Media": array:37 [ …37] +"ID": "31302" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5286 +post_id: "31299" +post_author: 1 +"ListingKey": "KEY424906534" +"ListingId": "999400" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-30T07:22:37Z" +"RFModificationTimestamp": "2026-05-30T07:24:50Z" +"ListPrice": 649000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1524.0 +"BuildingAreaTotal": 1524.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "35 Orchard Street, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6866336 +"Longitude": -73.5598602 +"YearBuilt": 1927 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Casey E. Balnis" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "504791" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Filled with warmth and opportunity, this 3 bedroom, 1 bath Cape style home offers a versatile layout with plenty of space to make your own. Hardwood floors, gas cooking, and an enclosed front porch create a comfortable and inviting atmosphere, while thoughtful updates throughout add to the home’s appeal. The full finished basement with a separate private outdoor entrance offers flexible bonus space with endless potential for extended living. Additional features include washer and dryer setups on both the first floor and basement level, a detached garage, new vinyl flooring in two bedrooms, and a finished upper level adding even more usable space. Outside, enjoy a back patio perfect for relaxing, along with a recently redone front stoop and walkway that enhance the home’s curb appeal. A wonderful opportunity for buyers looking for a home with character, functionality, and room to add their own vision over time." +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-743-2372" +"BuyerAgentEmail": "louis@oversouthre.com" +"BuyerAgentFullName": "Louis J. Porcellini" +"BuyerAgentKey": "326225279" +"BuyerAgentMlsId": "216185" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "406610771" +"BuyerOfficeMlsId": "OVRS02" +"BuyerOfficeName": "Oversouth LLC" +"BuyerOfficePhone": "631-770-0030" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-546-6300" +"CoListAgentEmail": "slevy@signaturepremier.com" +"CoListAgentFullName": "Seth B. Levy" +"CoListAgentKey": "326172773" +"CoListAgentMlsId": "160761" +"CoListOfficeKey": "326115717" +"CoListOfficeMlsId": "SPH09" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "516-546-6300" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-14T16:32:34.686692+00:00" +"CrossStreet": "Little Whaleneck" +"CumulativeDaysOnMarket": 15 +"DaysOnMarket": 15 +"Disclosures": array:2 [ …2] +"ElementarySchool": "Old Mill Road School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-11-14" +"ExteriorFeatures": array:2 [ …2] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-492-2732" +"ListAgentEmail": "cbalnis@signaturepremier.com" +"ListAgentKey": "421314509" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-14" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.0918 +"LotSizeDimensions": "40x100" +"LotSizeSquareFeet": 4000 +"MajorChangeTimestamp": "2026-05-29T20:46:12Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-29" +"OnMarketDate": "2026-05-14" +"OriginalEntryTimestamp": "2026-05-14T16:29:22Z" +"OriginalListPrice": 649000 +"OriginatingSystemModificationTimestamp": "2026-05-29T20:46:12Z" +"OwnerName": "Jill Balnis" +"ParcelNumber": "2089-56-005-00-0025-0" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-14T16:30:36Z" +"PhotosCount": 41 +"PostalCity": "Merrick" +"PostalCodePlus4": "1607" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-05-29" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-492-2732" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-29T20:46:12Z" +"StreetName": "Orchard" +"StreetNumber": "35" +"StreetNumberNumeric": "35" +"StreetSuffix": "Street" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14393" +"TaxAssessedValue": 484 +"TaxYear": "2026" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Finished" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "649000.00" +"KEY_ContractPrice": "670000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1524.00" +"KEY_NumberOfHeatingZones": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-528-1737" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "425.85302" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7069716.7756" +"KEY_RATIO_CurrentPrice_By_LivingArea": "425.85302" +"KEY_SourceSystemModificationTimestamp": "2026-05-13T14:25:50.133" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "425.85302" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "425.85302" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424906534')" +"provider_name": "One Key" +"Media": array:41 [ …41] +"ID": "31299" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5284 +post_id: "31258" +post_author: 1 +"ListingKey": "KEY424881335" +"ListingId": "998732" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-16T18:24:36Z" +"RFModificationTimestamp": "2026-06-16T18:28:56Z" +"ListPrice": 995000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2271.0 +"BuildingAreaTotal": 2322.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "11 E Webster Street, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7571587 +"Longitude": -73.5997239 +"YearBuilt": 1938 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Louisa Borriello" +"ListOfficeName": "Charles Rutenberg Realty Inc" +"ListAgentMlsId": "117451" +"ListOfficeMlsId": "CHRU01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Spacious Expanded Cape in North Merrick - Room to Make it Your Own! Welcome to this warm and inviting 5-Bedroom, 3 Full Bath Cape, Offering over 2,500 sqft. of well designed living space on a 65 x 100 lot. Located in North Merrick, minutes to the Southern State Parkway. Step inside to all Hardwood Floors thru-out the house to a large living room with a woodburning fireplace, a formal dining room with potential for a Butlers' pantry, and an oversized eat-in kitchen with sliding doors leading to a spacious covered porch- perfect for entertaining and everyday living. The first floor also includes two versatile bedrooms, ideal for a guest suite or home office and full bathroom. Upstairs, the expansive primary suite features his and her custom walk-in closets and a luxurious en-sutie bath with Jacuzzi tub and separate shower. Two additional oversized bedrooms and a third full bath complete the second level. Additional highlights include on car attached garage with direct access to house, basement with laundry, in ground sprinklers, and a spacious backyard ready for your personal touch. Make this home with great timeless charm - and with just and few finishing touches it will truly shine. Whether you're looking to move right in or update over time or customize to your taste, this home offers space, functionality and endless potential." +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "rpfeffer@crrli.net" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-13T14:04:05.819290+00:00" +"CrossStreet": "Merrick Avenue" +"CumulativeDaysOnMarket": 34 +"DaysOnMarket": 35 +"DirectionFaces": "South" +"Directions": "GPS" +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2027-05-12" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-805-0318" +"ListAgentEmail": "Louisa.Borriello@crrnys.com" +"ListAgentKey": "326132990" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110310" +"ListOfficePhone": "516-575-7500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-13" +"LivingAreaSource": "Public Records" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.1515 +"LotSizeDimensions": "65 x 100" +"LotSizeSquareFeet": 6600 +"MajorChangeTimestamp": "2026-06-01T22:43:30Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-05-13" +"OriginalEntryTimestamp": "2026-05-13T13:58:32Z" +"OriginalListPrice": 1100000 +"OriginatingSystemModificationTimestamp": "2026-06-16T18:23:18Z" +"OwnerName": "Hubbard" +"ParcelNumber": "2089-56-073-00-0144-0" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-13T13:59:36Z" +"PhotosCount": 16 +"PostalCity": "Merrick" +"PostalCodePlus4": "2721" +"PreviousListPrice": 1100000 +"PriceChangeTimestamp": "2026-06-01T22:43:30Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-805-0318" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-13T13:58:32Z" +"StreetDirPrefix": "E" +"StreetName": "Webster" +"StreetNumber": "11" +"StreetNumberNumeric": "11" +"StreetSuffix": "Street" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17193" +"TaxAssessedValue": 611 +"TaxBlock": "073" +"TaxLot": "144" +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "56" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "995000.00" +"KEY_OpenHouseCount": "2" +"KEY_AdditionalFeesYN": "0" +"KEY_OpenHouseUpcoming": "Public: Sat Jun 20, 12:00PM-3:00PM" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "2271.00" +"KEY_OpenHousePublicCount": "1" +"KEY_DownPaymentResourceYN": "1" +"KEY_OpenHousePublicUpcoming": "Public: Sat Jun 20, 12:00PM-3:00PM" +"KEY_RATIO_ListPrice_By_LivingArea": "438.13298" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6567656.7657" +"KEY_RATIO_CurrentPrice_By_LivingArea": "438.13298" +"KEY_SourceSystemModificationTimestamp": "2026-05-12T15:21:20.040" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "428.50991" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.90455" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "428.50991" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424881335')" +"provider_name": "One Key" +"Media": array:16 [ …16] +"ID": "31258" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5281 +post_id: "31422" +post_author: 1 +"ListingKey": "KEY424863047" +"ListingId": "998193" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T14:39:36Z" +"RFModificationTimestamp": "2026-06-02T14:41:49Z" +"ListPrice": 1399999.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3460.0 +"BuildingAreaTotal": 3460.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "9 Avenue C, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.655347493904 +"Longitude": -73.542840138428 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nicholas Campasano" +"ListOfficeName": "The Agency Northshore NY" +"ListAgentMlsId": "176791" +"ListOfficeMlsId": "SFGR02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Updated & Expanded South Merrick Colonial Featuring A Versatile Set Up With Spacious Living Areas Ideal For Extended Family, Guests Or Multi Generational Living. Thoughtfully Designed With Flexibility In Mind, The Layout Offers Separate Living Possibilities While Still Maintaining A Seamless Flow Throughout The Home.\n \n The Heart Of The Residence Is A Stunning Gourmet Kitchen Complete With Stainless Steel Appliances, Oversized Center Island, Custom Cabinetry & An Open Concept Design Perfect For Both Everyday Living & Entertaining. The Kitchen & Living Room Are Enhanced By Radiant Heated Floors Adding An Additional Level Of Comfort & Luxury Throughout The Main Living Space.\n \n The Home Offers Generously Sized Bedrooms, Updated Baths & A Flexible Floor Plan Designed For Modern Living. The Primary Suite Provides A Comfortable Retreat While Additional Living Areas Offer Endless Possibilities For Recreation, Home Office Space Or Extended Stay Accommodations. Major Mechanical Updates Have Already Been Taken Care Of Including A Boiler & Hot Water Heater.\n \n Sliding Doors Lead To A True Resort Style Backyard Featuring An In Ground Pool, Expansive Patio Space, Outdoor Kitchen & Bar Creating The Ultimate Indoor/Outdoor Entertaining Experience. Whether Hosting Summer Gatherings Or Enjoying Quiet Nights At Home, The Outdoor Space Has Been Curated To Feel Like A Private Vacation Retreat.\n \n Beautifully Landscaped Grounds, Exceptional Entertaining Space & Thoughtful Upgrades Throughout Make This A Rare South Merrick Opportunity Combining Comfort, Style, Functionality & Versatility. """ +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-870-0753" +"BathroomsFull": 5 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "631-402-2303" +"CoListAgentEmail": "Jake.lastorino@theagencyre.com" +"CoListAgentFullName": "Jake E. Lastorino" +"CoListAgentKey": "326237544" +"CoListAgentMlsId": "228827" +"CoListOfficeKey": "326115514" +"CoListOfficeMlsId": "SFGR02" +"CoListOfficeName": "The Agency Northshore NY" +"CoListOfficePhone": "631-870-0753" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-27T18:52:09.836384+00:00" +"CumulativeDaysOnMarket": 6 +"DaysOnMarket": 21 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-11" +"FireplaceYN": true +"FireplacesTotal": "2" +"Heating": array:4 [ …4] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-848-6515" +"ListAgentEmail": "NicholasC@TheAgencyRE.com" +"ListAgentKey": "326187531" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115514" +"ListOfficePhone": "631-870-0753" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-11" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1637 +"LotSizeSquareFeet": 7130 +"MajorChangeTimestamp": "2026-05-27T18:49:35Z" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-05-27" +"OriginalEntryTimestamp": "2026-05-27T18:49:35Z" +"OriginalListPrice": 1399999 +"OriginatingSystemModificationTimestamp": "2026-06-02T14:37:39Z" +"OwnerName": "Larsen" +"ParcelNumber": "2089-63-133-00-0080-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-05-27T18:06:36Z" +"PhotosCount": 30 +"PoolFeatures": array:2 [ …2] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "4721" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "855-220-0610" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-27T18:49:35Z" +"StreetName": "Avenue C" +"StreetNumber": "9" +"StreetNumberNumeric": "9" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "27354" +"TaxYear": "2026" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1399999.00" +"KEY_OpenHouseCount": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_LivingAreaSearchSqFt": "3460.00" +"KEY_NumberOfHeatingZones": "7" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "404.62399" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8552223.5797" +"KEY_RATIO_CurrentPrice_By_LivingArea": "404.62399" +"KEY_SourceSystemModificationTimestamp": "2026-05-11T18:17:09.170" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "404.62399" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "404.62399" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424863047')" +"provider_name": "One Key" +"Media": array:30 [ …30] +"ID": "31422" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5280 +post_id: "31499" +post_author: 1 +"ListingKey": "KEY424861966" +"ListingId": "998163" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-17T13:49:36Z" +"RFModificationTimestamp": "2026-06-17T13:53:18Z" +"ListPrice": 839000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1585.0 +"BuildingAreaTotal": 1585.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1871 Relyea Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.675516 +"Longitude": -73.5633329 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nicole A. Calandro" +"ListOfficeName": "Cornerstone Properties of LI" +"ListAgentMlsId": "104846" +"ListOfficeMlsId": "CNR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Beautifully renovated and move-in ready corner property located on a quiet dead-end street in the highly sought-after North Merrick school district. This sun-filled home features 4 spacious bedrooms and 2 updated full baths on the main level, including an oversized 21’ x 19’ primary en-suite with potential for separate living quarters or extended family setup. Updated kitchen with modern cabinetry, sleek countertops, stainless steel appliances, skylights, high-end finishes, and backyard access. Finished basement with full bath and separate outside entrance offers flexible living space for guests, office, gym, or recreation. Private backyard with wood patio and storage shed. Gas available on street for future conversion. Conveniently located near shopping, dining, parks, and transportation. A rare turnkey opportunity in Merrick!" +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-573-6394" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-13T14:21:34.880119+00:00" +"CumulativeDaysOnMarket": 78 +"DaysOnMarket": 33 +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-09-11" +"Flooring": array:2 [ …2] +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentEmail": "nicolepieroni78@gmail.com" +"ListAgentKey": "326121228" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110439" +"ListOfficePhone": "631-573-6394" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-11" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1837 +"LotSizeSquareFeet": 8000 +"MajorChangeTimestamp": "2026-06-04T13:02:30Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-05-15" +"OriginalEntryTimestamp": "2026-05-13T14:15:00Z" +"OriginalListPrice": 899000 +"OriginatingSystemModificationTimestamp": "2026-06-17T13:48:32Z" +"OwnerName": "Jawed" +"ParcelNumber": "2089-55-046-00-0128-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-06-04T13:05:36Z" +"PhotosCount": 40 +"PostalCity": "Merrick" +"PostalCodePlus4": "2552" +"PreviousListPrice": 899000 +"PriceChangeTimestamp": "2026-06-04T13:02:30Z" +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-664-3373" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-15T04:30:58Z" +"StreetName": "Relyea" +"StreetNumber": "1871" +"StreetNumberNumeric": "1871" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15909" +"TaxAssessedValue": 535 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Pull Stairs" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "839000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Coming Soon" +"KEY_NumberOfKitchens": "1" +"KEY_OpenHouseUpcoming": "Public: Sun Jun 21, 1:00PM-2:30PM" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "1585.00" +"KEY_OpenHousePublicCount": "1" +"KEY_DownPaymentResourceYN": "1" +"KEY_OpenHousePublicUpcoming": "Public: Sun Jun 21, 1:00PM-2:30PM" +"KEY_RATIO_ListPrice_By_LivingArea": "529.33754" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4567229.1780" +"KEY_RATIO_CurrentPrice_By_LivingArea": "529.33754" +"KEY_SourceSystemModificationTimestamp": "2026-05-11T17:37:10.143" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "529.33754" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.93326" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "529.33754" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424861966')" +"provider_name": "One Key" +"Media": array:40 [ …40] +"ID": "31499" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5287 +post_id: "31223" +post_author: 1 +"ListingKey": "KEY424859167" +"ListingId": "998072" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-17T18:10:44Z" +"RFModificationTimestamp": "2026-05-17T18:15:10Z" +"ListPrice": 829000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1818.0 +"BuildingAreaTotal": 1818.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2688 Rosebud Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6507732 +"Longitude": -73.5537851 +"YearBuilt": 1931 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Vishal Maraj" +"ListOfficeName": "RE/MAX 2000" +"ListAgentMlsId": "182439" +"ListOfficeMlsId": "R2K01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This elegant single-family residence boasts numerous recent upgrades, including a renovated kitchen and oak flooring, situated in a prime residential location. The interior features spacious bedrooms and bathrooms with high ceilings, abundant natural light, granite counter-tops and tasteful decor complemented by glamorous lighting throughout. The backyard is ideally suited for entertainment or relaxation, taking advantage of serene evening sunsets. Highly-rated schools, proximity to shopping centers, restaurants, highways and places of worship are among the many attractions and conveniences offered by this exceptional property." +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "718-848-2500" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-11T20:08:42.538317+00:00" +"CrossStreet": "Florence St." +"CumulativeDaysOnMarket": 6 +"DaysOnMarket": 37 +"Directions": "GPS" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-11-11" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "718-848-1966" +"ListAgentEmail": "vishalmaraj@hotmail.com" +"ListAgentKey": "326192775" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "418065586" +"ListOfficePhone": "718-848-2500" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2026-05-11" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.0918 +"LotSizeSquareFeet": 4000 +"MajorChangeTimestamp": "2026-05-11T20:00:41Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-05-11" +"OriginalEntryTimestamp": "2026-05-11T20:00:41Z" +"OriginalListPrice": 829000 +"OriginatingSystemModificationTimestamp": "2026-05-17T18:08:27Z" +"OwnerName": "John Smith" +"ParcelNumber": "2089-62-008-00-0030-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-05-11T20:02:36Z" +"PhotosCount": 26 +"PostalCity": "Merrick" +"PostalCodePlus4": "4523" +"PriceChangeTimestamp": "2026-05-11T20:00:41Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-11T20:00:41Z" +"StreetName": "Rosebud" +"StreetNumber": "2688" +"StreetNumberNumeric": "2688" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13537.19" +"TaxAssessedValue": 486 +"TaxYear": "2024" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Finished,Full" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "829000.00" +"KEY_OpenHouseCount": "2" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "1818.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "455.99560" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "9030501.0893" +"KEY_RATIO_CurrentPrice_By_LivingArea": "455.99560" +"KEY_SourceSystemModificationTimestamp": "2026-05-11T16:00:41.320" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "455.99560" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "455.99560" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424859167')" +"provider_name": "One Key" +"Media": array:26 [ …26] +"ID": "31223" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5288 +post_id: "31427" +post_author: 1 +"ListingKey": "KEY424854406" +"ListingId": "997914" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-06-17T16:38:36Z" +"RFModificationTimestamp": "2026-06-17T16:44:36Z" +"ListPrice": 789990.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 1367.0 +"BuildingAreaTotal": 1367.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "69 Lewis Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6795295 +"Longitude": -73.5624583 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Brittany Hamilton" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "200274" +"ListOfficeMlsId": "DERE10" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Don’t Miss this charming, expanded Cape home featuring 5 bedrooms and 2 full baths, full basement, and oversized detached garage providing lots of storage and workspace potential. This well-maintained home features hardwood floors, abundant natural light, and living room with gas fireplace. Conveniently located near parks, shopping, dining, schools, parkways and the LIRR for an easy commute." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-589-8500" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-508-6944" +"BuyerAgentEmail": "jonathan@amrhomes.com" +"BuyerAgentFullName": "Jonathan Matute" +"BuyerAgentKey": "326175835" +"BuyerAgentMlsId": "164104" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326109312" +"BuyerOfficeMlsId": "ALX01" +"BuyerOfficeName": "Alexander Madison Realty Inc" +"BuyerOfficePhone": "516-307-0800" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-27T21:18:53.259436+00:00" +"CrossStreet": "Henry Road" +"CumulativeDaysOnMarket": 7 +"DaysOnMarket": 7 +"Directions": "Merrick Ave to Henry Road to Lewis Road" +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"Exclusions": "Light Fixture in Living Room" +"ExpirationDate": "2026-11-12" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-233-4836" +"ListAgentEmail": "brittany.hamilton@elliman.com" +"ListAgentKey": "326209807" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110757" +"ListOfficePhone": "631-589-8500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-12" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1309 +"LotSizeDimensions": "60x100" +"LotSizeSquareFeet": 5700 +"MajorChangeTimestamp": "2026-06-17T16:36:39Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-06-03" +"OnMarketDate": "2026-05-27" +"OriginalEntryTimestamp": "2026-05-27T21:08:41Z" +"OriginalListPrice": 789990 +"OriginatingSystemModificationTimestamp": "2026-06-17T16:36:39Z" +"OwnerName": "Eatz" +"ParcelNumber": "2089-55-003-00-0064-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-05-21T00:47:36Z" +"PhotosCount": 29 +"PostalCity": "Merrick" +"PostalCodePlus4": "2310" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-06-17" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-233-4836" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-17T16:36:39Z" +"StreetName": "Lewis" +"StreetNumber": "69" +"StreetNumberNumeric": "69" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "12996" +"TaxBlock": "003" +"TaxLot": "64" +"TaxYear": "2026" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Scuttle" +"KEY_HoldDate": "2026-06-03" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "003" +"KEY_CurrentPrice": "789990.00" +"KEY_ContractPrice": "855000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_ElectricCompany": "PSEG" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_BuyerRepresentation": "Buyer's Agent" +"KEY_LivingAreaSearchSqFt": "1367.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "577.90051" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6035064.9351" +"KEY_RATIO_CurrentPrice_By_LivingArea": "577.90051" +"KEY_SourceSystemModificationTimestamp": "2026-05-11T13:48:46.037" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "577.90051" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "577.90051" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424854406')" +"provider_name": "One Key" +"Media": array:29 [ …29] +"ID": "31427" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5289 +post_id: "31516" +post_author: 1 +"ListingKey": "KEY424851359" +"ListingId": "997821" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-07T17:09:43Z" +"RFModificationTimestamp": "2026-06-07T17:12:55Z" +"ListPrice": 1188000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2698.0 +"BuildingAreaTotal": 2698.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2912 Bay Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.647918 +"Longitude": -73.543964 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Vincent DiLemme" +"ListOfficeName": "NextHome OrangeDot" +"ListAgentMlsId": "128129" +"ListOfficeMlsId": "ORG01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Experience the pinnacle of waterfront living at this spectacular residence in the heart of Merrick, situated at the end of a quiet Cul De Sac. Perfectly positioned along the bay, 2912 Bay Drive offers an extraordinary lifestyle defined by panoramic water views, seamless indoor-outdoor living, and exceptional boating amenities. Set on a prime 60 feet of waterfront, this Splanch offers 4 bedrooms and 3.5 bathrooms offering indoor spacious design. 2 car attached garage, Gas heat with a thoughtful layout designed for both everyday comfort and elevated entertaining. The outdoor experience is where this property truly distinguishes itself. Fantastic sun exposure provides spectacular sunset skies, while a private dock and great backyard space creates a resort-style environment ideal for both relaxation and entertaining. Whether boating, jet skiing, kayaking, or simply enjoying the peaceful waterfront backdrop, this home offers a lifestyle that is difficult to replicate. Located on one of South Merrick’s most desirable waterfront streets, this is a rare offering that seamlessly combines location, views, and lifestyle." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-314-4880" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "631-314-4880" +"CoListAgentEmail": "anthony@nhorange.com" +"CoListAgentFullName": "Anthony J. Pellicane" +"CoListAgentKey": "326152312" +"CoListAgentMlsId": "138776" +"CoListOfficeKey": "326114344" +"CoListOfficeMlsId": "ORG01" +"CoListOfficeName": "NextHome OrangeDot" +"CoListOfficePhone": "631-314-4880" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-06-02T17:31:21.746556+00:00" +"CumulativeDaysOnMarket": 5 +"DaysOnMarket": 15 +"Directions": "Google Maps" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-01-05" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FrontageLength": "60" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-314-4880" +"ListAgentEmail": "vdilemmerealtor@gmail.com" +"ListAgentKey": "326142706" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114344" +"ListOfficePhone": "631-314-4880" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-06-02" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.14 +"LotSizeSquareFeet": 6100 +"MajorChangeTimestamp": "2026-06-02T17:27:17Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-06-02" +"OriginalEntryTimestamp": "2026-06-02T17:27:17Z" +"OriginalListPrice": 1188000 +"OriginatingSystemModificationTimestamp": "2026-06-07T17:08:18Z" +"OwnerName": "Tracy Banner" +"ParcelNumber": "2089-62-194-00-0064-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-06-02T17:28:36Z" +"PhotosCount": 50 +"PostalCity": "Merrick" +"PostalCodePlus4": "4604" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-02T17:27:17Z" +"StreetName": "Bay" +"StreetNumber": "2912" +"StreetNumberNumeric": "2912" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "26712.54" +"TaxAssessedValue": 897 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://360mm.com/vincent/2912BayDrMerrick.mp4" +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:1 [ …1] +"WaterfrontYN": true +"KEY_Attic": "Crawl" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1188000.00" +"KEY_OpenHouseCount": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "2698.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "440.32617" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8485714.2857" +"KEY_RATIO_CurrentPrice_By_LivingArea": "440.32617" +"KEY_SourceSystemModificationTimestamp": "2026-05-11T12:23:24.907" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "440.32617" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "440.32617" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424851359')" +"provider_name": "One Key" +"Media": array:50 [ …50] +"ID": "31516" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5290 +post_id: "31359" +post_author: 1 +"ListingKey": "KEY424850235" +"ListingId": "997789" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-06-08T22:30:36Z" +"RFModificationTimestamp": "2026-06-08T22:34:12Z" +"ListPrice": 699000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1035.0 +"BuildingAreaTotal": 1097.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1700 Rugby Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6558607 +"Longitude": -73.5630715 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Cindy DiBiasi" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "116237" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "The one you’ve been waiting for! If you’ve been searching for the perfect turn-key home, look no further than 1700 Rugby Rd. This beautifully updated home is ready for you to enjoy this summer. From the moment you step inside, you’ll feel right at home. The first floor offers an open-concept layout featuring a living room, dining area, and a stunning chef’s kitchen complete with wood cabinetry, stainless steel appliances, granite countertops, pot filler, and a large pantry, with easy access to the backyard, gleaming hardwood floors throughout .This level also includes a bedroom and an updated full bath. Upstairs, you’ll find two additional bedrooms and another updated full bath. The partially finished basement offers two bonus rooms, laundry area, and utilities, providing extra space for work, guests, or recreation. The fully fenced yard and oversized detached garage make this home perfect for entertaining and social gatherings. Conveniently located close to shopping, dining, transportation, and more, this is a home you do not want to miss!" +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-728-8275" +"BuyerAgentEmail": "mikewalsh1@optonline.net" +"BuyerAgentFullName": "Michael P. Walsh" +"BuyerAgentKey": "326129771" +"BuyerAgentMlsId": "113976" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115083" +"BuyerOfficeMlsId": "RLLE02" +"BuyerOfficeName": "Realty Connect USA LLC" +"BuyerOfficePhone": "516-714-3606" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-20T22:47:57.080007+00:00" +"CrossStreet": "Central Blvd" +"CumulativeDaysOnMarket": 9 +"DaysOnMarket": 9 +"Directions": "Merrick Rd To Dobson To Rugby" +"Disclosures": array:3 [ …3] +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-11-30" +"Fencing": array:3 [ …3] +"Flooring": array:2 [ …2] +"GarageSpaces": "1.5" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LeaseConsideredYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-524-1954" +"ListAgentEmail": "cindydibiasi@yahoo.com" +"ListAgentKey": "326131896" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-12" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1033 +"LotSizeSquareFeet": 4500 +"MajorChangeTimestamp": "2026-06-08T22:29:09Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-29" +"OnMarketDate": "2026-05-20" +"OriginalEntryTimestamp": "2026-05-20T22:41:50Z" +"OriginalListPrice": 699000 +"OriginatingSystemModificationTimestamp": "2026-06-08T22:29:09Z" +"OwnerName": "Cheryl Low" +"ParcelNumber": "2089-55-178-00-0112-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-05-13T22:05:36Z" +"PhotosCount": 22 +"PostalCity": "Merrick" +"PostalCodePlus4": "3704" +"PurchaseContractDate": "2026-06-08" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-524-1954" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-08T22:29:09Z" +"StreetName": "Rugby" +"StreetNumber": "1700" +"StreetNumberNumeric": "1700" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "12870.61" +"TaxAssessedValue": 424 +"TaxLot": "45x100" +"TaxYear": "2024" +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"KEY_Attic": "None" +"KEY_HoldDate": "2026-05-29" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "699000.00" +"KEY_ContractPrice": "699000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_ElectricCompany": "PSEG" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1035.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "675.36232" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6766698.9351" +"KEY_RATIO_CurrentPrice_By_LivingArea": "675.36232" +"KEY_SourceSystemModificationTimestamp": "2026-05-11T11:58:43.263" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "637.19234" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "637.19234" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424850235')" +"provider_name": "One Key" +"Media": array:22 [ …22] +"ID": "31359" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5291 +post_id: "31215" +post_author: 1 +"ListingKey": "KEY424849775" +"ListingId": "997773" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-17T16:28:36Z" +"RFModificationTimestamp": "2026-06-17T16:33:00Z" +"ListPrice": 499999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 496.0 +"BuildingAreaTotal": 496.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2084 Washington Street, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6658375 +"Longitude": -73.5600003 +"YearBuilt": 1928 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Francheska Gomez" +"ListOfficeName": "Aventus Real Estate Corp" +"ListAgentMlsId": "191167" +"ListOfficeMlsId": "AVNT01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this charming 1 bedroom, 1 bathroom single family home located in the heart of Merrick. This cozy home offers comfortable living with a bright and inviting layout, perfect for first time buyers, down-sizers, or anyone looking for the privacy of a single family residence in a desirable Long Island neighborhood. Enjoy convenient access to shopping, restaurants, parks, transportation, and major roadways, all while being located within the highly regarded Merrick school district. A wonderful opportunity to own a beautiful home in a prime location. Schedule your private showing!" +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-234-6519" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-11T15:54:59.397815+00:00" +"CumulativeDaysOnMarket": 37 +"DaysOnMarket": 37 +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-05-08" +"FoundationDetails": array:1 [ …1] +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-234-6519" +"ListAgentEmail": "fran@aventusrealestate.com" +"ListAgentKey": "326201062" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326306836" +"ListOfficePhone": "516-234-6519" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-08" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.0574 +"LotSizeSquareFeet": 2500 +"MajorChangeTimestamp": "2026-05-26T16:46:01Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-05-11" +"OriginalEntryTimestamp": "2026-05-11T15:45:42Z" +"OriginalListPrice": 549999 +"OriginatingSystemModificationTimestamp": "2026-06-17T16:26:38Z" +"OwnerName": "Francisco & Dorka Guasp" +"ParcelNumber": "2089-55-492-00-0694-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-05-28T14:34:37Z" +"PhotosCount": 23 +"PostalCity": "Merrick" +"PostalCodePlus4": "3334" +"PreviousListPrice": 549999 +"PriceChangeTimestamp": "2026-05-26T16:46:01Z" +"RoomsTotal": "4" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-234-6519" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-11T15:45:42Z" +"StreetName": "Washington" +"StreetNumber": "2084" +"StreetNumberNumeric": "2084" +"StreetSuffix": "Street" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "8620.88" +"TaxAssessedValue": 284 +"TaxYear": "2024" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Crawl" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "499999.00" +"KEY_OpenHouseCount": "2" +"KEY_NumberOfKitchens": "1" +"KEY_OpenHouseUpcoming": "Broker: Sat Jun 20, 11:00AM-1:00PM" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "496.00" +"KEY_OpenHousePublicCount": "1" +"KEY_DownPaymentResourceYN": "1" +"KEY_OpenHousePublicUpcoming": "Public: Sat Jun 20, 11:00AM-1:00PM" +"KEY_RATIO_ListPrice_By_LivingArea": "1008.06250" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8710783.9721" +"KEY_RATIO_CurrentPrice_By_LivingArea": "1008.06250" +"KEY_SourceSystemModificationTimestamp": "2026-05-11T11:45:41.527" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1008.06250" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.90909" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1008.06250" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424849775')" +"provider_name": "One Key" +"Media": array:23 [ …23] +"ID": "31215" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5292 +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 [ …2] +"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": 39 +"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 [ …1] +"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 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-09T12:40:12Z" +"StreetName": "Merrick Ave" +"StreetNumber": "42" +"StreetNumberNumeric": "42" +"SyndicateTo": array:3 [ …3] +"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 [ …2] +"ID": "31206" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5293 +post_id: "31262" +post_author: 1 +"ListingKey": "KEY424822965" +"ListingId": "997090" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-19T20:36:36Z" +"RFModificationTimestamp": "2026-05-19T20:37: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 [ …2] +"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 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-13T15:18:46.889302+00:00" +"CrossStreet": "Decatur" +"CumulativeDaysOnMarket": 6 +"DaysOnMarket": 35 +"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 [ …1] +"Flooring": array:3 [ …3] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"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 [ …7] +"LotSizeAcres": 0.143 +"LotSizeSquareFeet": 6230 +"MajorChangeTimestamp": "2026-05-13T15:13:51Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-05-13" +"OriginalEntryTimestamp": "2026-05-13T15:13:51Z" +"OriginalListPrice": 1250000 +"OriginatingSystemModificationTimestamp": "2026-05-19T20:34:58Z" +"OtherStructures": array:1 [ …1] +"OwnerName": "Glenn R & Mary McCarthy" +"ParcelNumber": "2089-50-579-00-0059-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-05-13T15:26:36Z" +"PhotosCount": 50 +"PostalCity": "Merrick" +"PostalCodePlus4": "1228" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-353-3033" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-13T15:13:51Z" +"StreetName": "Wilson" +"StreetNumber": "1811" +"StreetNumberNumeric": "1811" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14968" +"TaxAssessedValue": 522 +"TaxYear": "2026" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1250000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"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 [ …50] +"ID": "31262" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5294 +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 [ …2] +"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 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-21T17:02:05.311580+00:00" +"CrossStreet": "Merrick Avenue" +"CumulativeDaysOnMarket": 9 +"DaysOnMarket": 27 +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"Exclusions": "TBD" +"ExpirationDate": "2027-05-07" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "0.5" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:21 [ …21] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"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 [ …1] +"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 [ …1] +"PhotosChangeTimestamp": "2026-05-21T17:19:36Z" +"PhotosCount": 27 +"PostalCity": "Merrick" +"PostalCodePlus4": "3122" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-623-4500" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-21T16:52:48Z" +"StreetName": "Nancy" +"StreetNumber": "33" +"StreetNumberNumeric": "33" +"StreetSuffix": "Boulevard" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "22000" +"TaxBlock": "077" +"TaxLot": "68" +"TaxYear": "2026" +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"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 [ …27] +"ID": "31363" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5295 +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 [ …2] +"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 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:2 [ …2] +"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 [ …1] +"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 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:1 [ …1] +"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 [ …1] +"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 [ …1] +"PhotosChangeTimestamp": "2026-05-13T15:37:36Z" +"PhotosCount": 23 +"PostalCity": "Merrick" +"PostalCodePlus4": "3125" +"PurchaseContractDate": "2026-05-28" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-28T16:30:17Z" +"StreetName": "Merrick" +"StreetNumber": "2000" +"StreetNumberNumeric": "2000" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15200" +"TaxAssessedValue": 527 +"TaxYear": "2024" +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"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 [ …23] +"ID": "31264" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5296 +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 [ …2] +"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 [ …15] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "mimber@aol.com" +"Basement": array:1 [ …1] +"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 [ …3] +"Cooling": array:1 [ …1] +"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 [ …1] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"Inclusions": "Swing set" +"InteriorFeatures": array:23 [ …23] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"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 [ …1] +"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 [ …5] +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-08T14:09:36Z" +"PhotosCount": 48 +"PostalCity": "Merrick" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-05-27" +"RoomsTotal": "9" +"SecurityFeatures": array:4 [ …4] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "(855)920-8240" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-27T18:58:30Z" +"StreetName": "Wynsum" +"StreetNumber": "2667" +"StreetNumberNumeric": "2667" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15497" +"TaxBlock": "126" +"TaxLot": "4" +"TaxYear": "2026" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"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 [ …48] +"ID": "31233" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5297 +post_id: "31491" +post_author: 1 +"ListingKey": "KEY424768406" +"ListingId": "995712" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-12T03:45:36Z" +"RFModificationTimestamp": "2026-06-12T03:48:04Z" +"ListPrice": 1125000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2348.0 +"BuildingAreaTotal": 2628.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "3089 Monterey Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6417074 +"Longitude": -73.5504772 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "AnnMarie Wisnieski" +"ListOfficeName": "BERKSHIRE HATHAWAY" +"ListAgentMlsId": "167643" +"ListOfficeMlsId": "BHHS05" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to 3089 Monterey Drive a Spacious and well-maintained 4-bedroom, 2.5-bath home featuring a welcoming layout and many desirable upgrades. The first floor offers a formal living room, dining room, eat-in kitchen with pantry, and a cozy den with fireplace. The kitchen is equipped with GE Profile stainless steel appliances and an electric stove.\n \n Upstairs includes four generously sized bedrooms, including a primary suite with multiple closets and a huge walk-in closet. The upstairs full bathroom features a skylight, bringing in natural light. Additional attic space is accessible from the primary bedroom. Wood flooring lies beneath the upstairs carpeting.\n \n Additional highlights include a 2-car garage, central air conditioning, oil heat, boiler system, Andersen windows, security and fire alarm systems, and a half basement for extra storage. The roof is approximately 5 years old. Enjoy partial water views from one of the bedrooms and living room.\n \n This home combines comfort, space, and functionality in a desirable setting. """ +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "917-837-1085" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-698-7882" +"CoListAgentEmail": "danielle@pl-team.com" +"CoListAgentFullName": "Danielle P. Grossman" +"CoListAgentKey": "421556097" +"CoListAgentMlsId": "504974" +"CoListOfficeKey": "326109739" +"CoListOfficeMlsId": "BHHS03" +"CoListOfficeName": "BERKSHIRE HATHAWAY" +"CoListOfficePhone": "516-224-4600" …91 } 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5298 …139} 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5299 …123} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5300 …169} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5301 …144} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5302 …151} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5303 …155} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5304 …163} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5306 …167} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5275 …152} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5274 …167} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5273 …145} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5272 …153} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5271 …129} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5270 …149} ] +success: true +page_size: 32 +page_count: 7 +count: 206 +after_key: "" } "RF Response Time" => "0.17 seconds" ] ]