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=96&$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 {#5108 +items: array:32 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5122 +post_id: "30198" +post_author: 1 +"ListingKey": "KEY423689104" +"ListingId": "965205" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-01T14:46:37Z" +"RFModificationTimestamp": "2026-05-01T15:00:03Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2316.0 +"BuildingAreaTotal": 2316.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "25 Old Mill Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6873671 +"Longitude": -73.5606152 +"YearBuilt": 1936 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Michael DellAccio" +"ListOfficeName": "Century 21 AA Realty" +"ListAgentMlsId": "211202" +"ListOfficeMlsId": "AA02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this exceptional 4 Bedroom, 2 Bathroom Expanded Cape in North Merrick! Step inside to a semi–open concept first floor featuring a warm and inviting Living Room with a classic wood-burning fireplace and an appealing rear stair layout. The Formal Dining Room flows seamlessly into a stunning Kitchen, complete with an Island and a large Peninsula that opens to a spacious Den with Andersen sliders leading to the backyard—ideal for everyday living and entertaining. The first floor also includes a large Bedroom, a Full Bathroom, and convenient main-level Laundry. Gorgeous hardwood floors and abundant natural light create an airy, welcoming atmosphere throughout. Upstairs, the second floor offers a comfortable layout with a Primary Bedroom, two additional Bedrooms, and a Full Bathroom. All bedrooms offer generous closet space. The full unfinished Basement provides excellent additional living space—perfect for recreation, a home office, or gym. Step outside to a beautifully designed backyard with a large paver patio, offering the perfect setting for entertaining or relaxing. A new bluestone paver walkway and porch enhance the home’s curb appeal and charm. Located close to major parkways, the LIRR, schools, shops, and restaurants, this home combines convenience with exceptional suburban living. Don’t miss the opportunity to make this North Merrick gem yours!" +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-826-8100" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-03T01:22:56.411479+00:00" +"CrossStreet": "Merrick Avenue" +"CumulativeDaysOnMarket": 50 +"DaysOnMarket": 52 +"Disclosures": array:2 [ …2] +"ElementarySchool": "Old Mill Road School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-09-30" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:9 [ …9] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-374-1662" +"ListAgentEmail": "michaeld@century21aa.com" +"ListAgentKey": "326220458" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109064" +"ListOfficePhone": "516-826-8100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-02-24" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.1309 +"LotSizeSquareFeet": 5700 +"MajorChangeTimestamp": "2026-04-08T14:48:16Z" +"MajorChangeType": "Back On Market" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-03-05" +"OriginalEntryTimestamp": "2026-03-03T01:21:00Z" +"OriginalListPrice": 799000 +"OriginatingSystemModificationTimestamp": "2026-05-01T14:45:00Z" +"OwnerName": "Donofrio" +"ParcelNumber": "2089-56-432-00-0001-0" +"ParkingFeatures": array:3 [ …3] +"ParkingTotal": "2" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-08T14:44:36Z" +"PhotosCount": 17 +"PostalCity": "Merrick" +"PostalCodePlus4": "1605" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-826-8100" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-08T14:48:16Z" +"StreetName": "Old Mill" +"StreetNumber": "25" +"StreetNumberNumeric": "25" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15463.81" +"TaxAssessedValue": 520 +"TaxYear": "2026" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_HoldDate": "2026-04-01" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "799000.00" +"KEY_OpenHouseCount": "0" +"KEY_PreviousStatus": "Hold" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Back On Market" +"KEY_LivingAreaSearchSqFt": "2316.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "344.99136" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6103896.1039" +"KEY_RATIO_CurrentPrice_By_LivingArea": "344.99136" +"KEY_SourceSystemModificationTimestamp": "2026-02-26T10:06:10.227" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "344.99136" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "344.99136" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423689104')" +"provider_name": "One Key" +"Media": array:17 [ …17] +"ID": "30198" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5124 +post_id: "30200" +post_author: 1 +"ListingKey": "KEY423675281" +"ListingId": "965063" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-03-13T07:11:39Z" +"RFModificationTimestamp": "2026-03-13T07:16:54Z" +"ListPrice": 1359000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2635.0 +"BuildingAreaTotal": 2635.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "3311 Hewlett Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.642022 +"Longitude": -73.5335205 +"YearBuilt": 1966 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shari M. DeLouya CBR" +"ListOfficeName": "Realty Connect USA LLC" +"ListAgentMlsId": "103104" +"ListOfficeMlsId": "RLLE02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This is the Deep S Merrick Home you have been waiting for! This redesigned dream Splanch with 4 Bedrooms and 2.5 Baths has a top of the line Chefs Kitchen with White Shaker Full Height Cabinets, Quartz Counters with Center Island, Full Suite of Thermador Appliances with 6 Burner Range, Beverage Refrigerator and Microwave drawer. The Open Floor plan has a Wonderful Flow with Practical and Creative Space including a Huge Mud Room with Refrigerator Drawers, Family Room that opens to Dining Room and the Magnificent Kitchen overlooking the Private yard. The Stately appeal of the Brick Front with Specimen Plantings creating beautiful curb appeal. The Living Room with Vaulted Ceiling and Wall of Windows offers privacy and serenity. The Bedrooms are all well sized and the convenience of spacious LG Washer and Dryer on the Bedroom level is fabulous. The primary suite has a Walk in Shower, Double Quartz Vanity and Separate Tub. All Updated Andersen and Replacement Windows, Young Roof, Custom window Treatments, Tons of LED Recessed Lighting, Wood Floors with Radiant Heat on the entire Main Level, Closet Organizers, 2 Zone Gas Heat and CAC, IGS, Finished Basement with LV FLoors, and Electric charger make this the perfect place to call home!" +"Appliances": array:12 [ …12] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "smdelouya@gmail.com" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-457-4050" +"BuyerAgentEmail": "cathy.stone@elliman.com" +"BuyerAgentFullName": "Cathy Stone CBR" +"BuyerAgentKey": "326197835" +"BuyerAgentMlsId": "187770" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110766" +"BuyerOfficeMlsId": "DERE28" +"BuyerOfficeName": "Douglas Elliman Real Estate" +"BuyerOfficePhone": "516-623-4500" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-993-4721" +"CoListAgentEmail": "mimber@aol.com" +"CoListAgentFullName": "Marci Imber" +"CoListAgentKey": "326260685" +"CoListAgentMlsId": "9070310" +"CoListOfficeKey": "326115083" +"CoListOfficeMlsId": "RLLE02" +"CoListOfficeName": "Realty Connect USA LLC" +"CoListOfficePhone": "516-714-3606" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-03T05:23:59.483326+00:00" +"CrossStreet": "Donna Dr" +"CumulativeDaysOnMarket": 6 +"DaysOnMarket": 6 +"Directions": "Hewlett Ave South past Donna Drive" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-06" +"FireplaceFeatures": array:2 [ …2] +"FireplacesTotal": "1" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:19 [ …19] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-834-1892" +"ListAgentEmail": "smdelouya@gmail.com" +"ListAgentKey": "326119600" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115083" +"ListOfficePhone": "516-714-3606" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-03" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-03-13T00:19:38Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-03-12" +"OnMarketDate": "2026-03-06" +"OriginalEntryTimestamp": "2026-03-03T05:17:59Z" +"OriginalListPrice": 1359000 +"OriginatingSystemModificationTimestamp": "2026-03-13T00:19:38Z" +"OwnerName": "Diplacido" +"ParcelNumber": "2089-63-327-00-0004-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-03T05:19:36Z" +"PhotosCount": 46 +"PostalCity": "Merrick" +"PostalCodePlus4": "5533" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-03-12" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "855-920-8240" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-13T00:19:38Z" +"StreetName": "Hewlett" +"StreetNumber": "3311" +"StreetNumberNumeric": "3311" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "21502.88" +"TaxAssessedValue": 752 +"TaxBlock": "327" +"TaxLot": "4" +"TaxYear": "2026" +"Utilities": array:7 [ …7] +"WaterSource": array:1 [ …1] +"YearBuiltEffective": 2017 +"KEY_Attic": "Scuttle" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "63" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1359000.00" +"KEY_ContractPrice": "1440600.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2635.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-993-4721" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "515.74953" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "9869281.0458" +"KEY_RATIO_CurrentPrice_By_LivingArea": "515.74953" +"KEY_SourceSystemModificationTimestamp": "2026-02-25T18:47:50.530" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "515.74953" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "515.74953" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423675281')" +"provider_name": "One Key" +"Media": array:46 [ …46] +"ID": "30200" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5121 +post_id: "30411" +post_author: 1 +"ListingKey": "KEY423669794" +"ListingId": "964894" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-22T13:31:36Z" +"RFModificationTimestamp": "2026-04-22T13:35:36Z" +"ListPrice": 1299000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2374.0 +"BuildingAreaTotal": 2774.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "3000 Holiday Park Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6420802 +"Longitude": -73.5520783 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nancy A. Jarvis CBR" +"ListOfficeName": "Daniel Gale Sothebys Intl Rlty" +"ListAgentMlsId": "9018684" +"ListOfficeMlsId": "GALE19" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Manhattan Sophistication comes to Merrick. Exceptional doesn’t even begin to explain this total and extraordinary 2-year renovation. Down to the studs and rebuilt with every bell and whistle this state-of-the-art “smart” home embraces the latest technology and presents itself as a warm and inviting place to call home. The entry leads you up to the main level where the great room encompasses the living room, dining room and kitchen. This open space is flooded with light from the triple windows in the living room to the 8ft Anderson sliding glass door. The kitchen features custom cabinetry, and the paneled appliances include a Thermador refrigerator, Bosch dishwasher and wine fridge. The kitchen island, with Quartz waterfall countertop, houses TWO Thermador ovens. There is a 6-burner Thermador gas cooktop and a pot-filler faucet. A built-in bar cabinet has lighting and a granite counter. The statement piece in the living room is the gorgeous Negresco honed-leathered granite wall that houses the linear gas fireplace and TV, which is flanked by cabinetry with shelving and drawers. The dining room with sliders gives convenient access to the Trex deck, lower patio and property. Also on this level is a full guest bath with Porcelanosa tile, vanity and a soaker tub, 2 bedrooms and the primary suite. The primary bedroom has been expanded with a separate dressing area that houses a wall of custom closets with triple glass sliding doors, custom lighting, dressers and custom shelving. The spa-like primary bath has a Madelli “smart” mirrored cabinet, Kohler toilet, heated floors, Porcelanosa tile, custom glass shower doors and oversized granite accented niche. The two additional bedrooms have Elfa fitted closets. Down to the ground level the renovation continues. The den has new Anderson 6ft sliders out to the large patio with gas firepit. There is an additional bedroom, with Elfa fitted double closet, the laundry room with “smart” LG washer & dryer and shelving, HVAC closet, another Porcelanosa full bath with shower and the attached two-car garage with Dalton doors, epoxy flooring, Level 2 EV charger, built-in custom shelving, large cabinets, custom server and data rack that connects to all in the house, and is heated by a Fujitsu split duct system. The property is newly landscaped with 7-zone inground sprinklers and is fully fenced and protected with CCTV security. Everything in the wonderous custom “Smart” home is literally at your fingertips and the features include but are not limited to Lutron lights and blackout shades, Viewrail railings, Napoleon gas fireplace, Hewn flooring, Moen faucets, Ecobee thermostat, built-in Sonos speakers (inside and out) Doca lighting, Porcelanosa baths, and Elfa closet systems throughout. The exterior has Hardiplank siding, Techobloc pavers, new fencing & landscaping. Everything related to the utilities has been replaced and upgraded including all new plumbing, all new electric (200Amp service). The whole house and attic has new small-cell sprayed foam insulation." +"Appliances": array:12 [ …12] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-334-3606" +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "347-972-5378" +"BuyerAgentEmail": "vivikinwen1991@gmail.com" +"BuyerAgentFullName": "Dongqin Wen" +"BuyerAgentKey": "326230406" +"BuyerAgentMlsId": "221473" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110487" +"BuyerOfficeMlsId": "CPLI01" +"BuyerOfficeName": "CPRE Elite Inc" +"BuyerOfficePhone": "917-920-0022" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:3 [ …3] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-13T16:34:40.277557+00:00" +"CrossStreet": "Clubhouse Road" +"CumulativeDaysOnMarket": 31 +"DaysOnMarket": 31 +"Directions": "Merrick Avenue to Clubhouse Road to Holiday Park Drive" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-11-22" +"ExteriorFeatures": array:5 [ …5] +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:4 [ …4] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:29 [ …29] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-850-2110" +"ListAgentEmail": "nancyjarvis@danielgale.com" +"ListAgentKey": "326253175" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111561" +"ListOfficePhone": "516-334-3606" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-13" +"LivingAreaSource": "Plans" +"LotFeatures": array:14 [ …14] +"LotSizeAcres": 0.1358 +"LotSizeDimensions": "66 x 91" +"LotSizeSquareFeet": 5915 +"MajorChangeTimestamp": "2026-04-22T13:30:03Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-18" +"OnMarketDate": "2026-03-18" +"OriginalEntryTimestamp": "2026-03-13T16:31:53Z" +"OriginalListPrice": 1459000 +"OriginatingSystemModificationTimestamp": "2026-04-22T13:30:03Z" +"OwnerName": "Spaces With Meraki Llc" +"ParcelNumber": "2089-62-219-00-0022-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "6" +"PatioAndPorchFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-03-13T16:33:36Z" +"PhotosCount": 29 +"PostalCity": "Merrick" +"PostalCodePlus4": "4825" +"PreviousListPrice": 1459000 +"PriceChangeTimestamp": "2026-03-27T14:43:26Z" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-04-21" +"RoomsTotal": "9" +"SecurityFeatures": array:3 [ …3] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "800-746-9464" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-22T13:30:03Z" +"StreetName": "Holiday Park" +"StreetNumber": "3000" +"StreetNumberNumeric": "3000" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15206.93" +"TaxAssessedValue": 556 +"TaxBlock": "219" +"TaxLot": "22" +"TaxYear": "2026" +"Utilities": array:3 [ …3] +"VirtualTourURLUnbranded": "https://kevinspelmanstudio.hd.pics/3000-Holiday-Park-Dr/idx" +"WaterSource": array:1 [ …1] +"YearBuiltEffective": 2024 +"KEY_Attic": "Full,Pull Stairs,Unfinished" +"KEY_HoldDate": "2026-04-18" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "62" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1299000.00" +"KEY_ContractPrice": "1360000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_AdditionalRooms": "Library/Den" +"KEY_DistanceToTrain": "2.00" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2374.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "547.17776" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "9565537.5552" +"KEY_RATIO_CurrentPrice_By_LivingArea": "547.17776" +"KEY_SourceSystemModificationTimestamp": "2026-02-25T12:56:59.747" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "468.27686" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.89034" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "468.27686" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423669794')" +"provider_name": "One Key" +"Media": array:29 [ …29] +"ID": "30411" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5125 +post_id: "30131" +post_author: 1 +"ListingKey": "KEY423656944" +"ListingId": "964461" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-28T18:09:43Z" +"RFModificationTimestamp": "2026-03-28T18:12:25Z" +"ListPrice": 769000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1272.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2341 Dobson Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6576358 +"Longitude": -73.561339 +"YearBuilt": 1955 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jeanene Sloane" +"ListOfficeName": "Eric G Ramsay Jr Assoc LLC" +"ListAgentMlsId": "502579" +"ListOfficeMlsId": "RAMS01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this charming and spacious 3-bedroom 2-bathroom Cape-style home located in the desirable community of Merrick. This home offers bright living areas, formal dining, an eat-in kitchen, cozy den, and an enclosed sunroom overlooking a private backyard. A partially finished basement with a separate entrance provides added versatility. Conveniently located near parks, shopping, dining, and transportation, this Merrick home offers comfort, versatility, and an excellent opportunity to make it your own" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-665-1500" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-24T19:06:54.116597+00:00" +"CumulativeDaysOnMarket": 29 +"DaysOnMarket": 64 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-25" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-456-6495" +"ListAgentEmail": "jeanenesloane@ericramsay.com" +"ListAgentKey": "418383048" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114868" +"ListOfficePhone": "631-665-1500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-02-24" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.17 +"LotSizeSquareFeet": 7400 +"MajorChangeTimestamp": "2026-03-23T15:25:20Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-02-27" +"OriginalEntryTimestamp": "2026-02-24T19:04:34Z" +"OriginalListPrice": 829000 +"OriginatingSystemModificationTimestamp": "2026-03-28T18:08:27Z" +"OwnerName": "Estate of Louis & Caroline Fontinha" +"ParcelNumber": "2089-55-158-00-0006-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-02-24T19:05:36Z" +"PhotosCount": 19 +"PostalCity": "Merrick" +"PreviousListPrice": 829000 +"PriceChangeTimestamp": "2026-03-23T15:25:20Z" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-456-6495" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-27T05:30:52Z" +"StreetName": "Dobson" +"StreetNumber": "2341" +"StreetNumberNumeric": "2341" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14283.39" +"TaxBlock": "158" +"TaxLot": "6" +"TaxYear": "2026" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "See Remarks" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "55" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "769000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Coming Soon" +"KEY_MlsDistrictCode": "2089" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "1272.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "604.55975" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4523529.4118" +"KEY_RATIO_CurrentPrice_By_LivingArea": "604.55975" +"KEY_SourceSystemModificationTimestamp": "2026-02-24T12:14:49.233" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.92762" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423656944')" +"provider_name": "One Key" +"Media": array:19 [ …19] +"ID": "30131" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5123 +post_id: "30299" +post_author: 1 +"ListingKey": "KEY423648106" +"ListingId": "964176" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-11T12:59:36Z" +"RFModificationTimestamp": "2026-04-11T13:00:01Z" +"ListPrice": 969000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1549.0 +"BuildingAreaTotal": 1549.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "45 Gregory Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6599894 +"Longitude": -73.5549814 +"YearBuilt": 1941 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Christopher J. Hubbard CBR" +"ListOfficeName": "RE/MAX Best" +"ListAgentMlsId": "107922" +"ListOfficeMlsId": "RBST01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this Renovated Custom Expanded Cape on Oversized Corner Property in Merrick! Updated Kitchen with Cherry Cabinets, Granite Counter Tops, New Tile Backsplash, Stainless Steel Appliances- Frigidaire Gallery, Gas Cooking!, Sliding doors to Yard-Andersen, HI-Hat Lighting and New Light Fixtures, Ceiling Fans, New Oak Floors, New Vinyl Floors, 1 New Custom Finished Bath, 1 Updated Bath, All New Doors, Hardware, Moldings & Paint Throughout, New Staircase & Banister, All New Andersen Exterior Doors, Living Room w/ Woodburning Fireplace and Culture Stone Wall, 5 All New Split Ductless AC Units, Additional Sitting Room/Breezeway to 1 Car Attached Garage, New Siding, Arch Roof, 200 Amp, New Gas Navien Boiler w/HW on demand, Brand New Washer Machine, Full Finished Basement with Outside Entrance and Bath, Professionally Landscaped yard w/ In Ground Sprinklers, Pavers Galore- Entire Driveway, Walkway, New Front Stoop/bluestone, Pavered Patio, All New Sewer Line to Street, PVC Fence, Oversized 87x100 Corner Lot! Amazing Curb Appeal! Close to All, LIRR, Shopping, Merrick Schools! Come See! Won’t Last!" +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-321-0100" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-665-2000" +"BuyerAgentEmail": "lweber@cbamhomes.com" +"BuyerAgentFullName": "Lorraine Weber" +"BuyerAgentKey": "326143112" +"BuyerAgentMlsId": "128584" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326109945" +"BuyerOfficeMlsId": "BRMN14" +"BuyerOfficeName": "Coldwell Banker American Homes" +"BuyerOfficePhone": "516-665-2000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-11T22:38:56.460610+00:00" +"CumulativeDaysOnMarket": 22 +"DaysOnMarket": 22 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-11" +"FireplaceYN": true +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentEmail": "chris@hubbardteam.com" +"ListAgentKey": "326124120" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114899" +"ListOfficePhone": "631-321-0100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-11" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1997 +"LotSizeDimensions": "8700" +"LotSizeSquareFeet": 8700 +"MajorChangeTimestamp": "2026-04-11T12:58:30Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-02" +"OnMarketDate": "2026-03-11" +"OriginalEntryTimestamp": "2026-03-11T22:33:19Z" +"OriginalListPrice": 969000 +"OriginatingSystemModificationTimestamp": "2026-04-11T12:58:30Z" +"OwnerName": "Crociata" +"ParcelNumber": "2089-55-144-00-0516-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-12T15:10:36Z" +"PhotosCount": 43 +"PostalCity": "Merrick" +"PostalCodePlus4": "4243" +"PurchaseContractDate": "2026-04-10" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-11T12:58:30Z" +"StreetName": "Gregory" +"StreetNumber": "45" +"StreetNumberNumeric": "45" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14084.78" +"TaxAssessedValue": 516 +"TaxBlock": "144" +"TaxLot": "516" +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_HoldDate": "2026-04-02" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "969000.00" +"KEY_ContractPrice": "950000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Hold" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1549.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "625.56488" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4852278.4176" +"KEY_RATIO_CurrentPrice_By_LivingArea": "625.56488" +"KEY_SourceSystemModificationTimestamp": "2026-02-23T11:26:18.827" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "625.56488" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "625.56488" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423648106')" +"provider_name": "One Key" +"Media": array:43 [ …43] +"ID": "30299" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5120 +post_id: "30105" +post_author: 1 +"ListingKey": "KEY423600743" +"ListingId": "962771" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-03-02T16:19:36Z" +"RFModificationTimestamp": "2026-03-02T16:25:38Z" +"ListPrice": 1199000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2200.0 +"BuildingAreaTotal": 1287.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1415 Rhode Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6839655 +"Longitude": -73.5653284 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joseph Panetta" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "197605" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome To This Stunning Better Than New Construction 5 Bedroom, 4 Full Bath Home Tucked Away On A Cul De Sac In The Heart Of Merrick, Scheduled For Full Completion In Spring 2026. This Beautifully Crafted 2,200 Sq Ft Residence Offers A Perfect Blend Of Modern Luxury And Thoughtful Design. The Open Concept Layout Features A Spacious Living And Dining Area Ideal For Entertaining, A Gourmet Kitchen With Premium Finishes, And Generously Sized Bedrooms Including A Luxurious Primary Suite With A Spa Like Bath. High End Materials, Energy Efficient Systems, And Contemporary Finishes Throughout Make This Home Truly Turnkey. Enjoy The Privacy And Tranquility Of Cul De Sac Living While Being Conveniently Located Near Shopping, Dining, Parks, Schools, And Transportation. A Rare Opportunity To Own A Brand New Custom Style Home In Merrick. Interior sq footage is approximate." +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 4 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "631-356-9283" +"BuyerAgentEmail": "jpanetta@signaturepremier.com" +"BuyerAgentFullName": "Joseph Panetta" +"BuyerAgentKey": "326207221" +"BuyerAgentMlsId": "197605" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115717" +"BuyerOfficeMlsId": "SPH09" +"BuyerOfficeName": "Signature Premier Properties" +"BuyerOfficePhone": "516-546-6300" +"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:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-19T17:11:40.909567+00:00" +"CumulativeDaysOnMarket": 6 +"DaysOnMarket": 6 +"ElementarySchool": "Old Mill Road School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-06-19" +"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": "631-356-9283" +"ListAgentEmail": "jpanetta@signaturepremier.com" +"ListAgentKey": "326207221" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-02-19" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.1578 +"LotSizeSquareFeet": 6875 +"MajorChangeTimestamp": "2026-02-25T21:49:13Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-02-25" +"OnMarketDate": "2026-02-19" +"OriginalEntryTimestamp": "2026-02-19T17:03:05Z" +"OriginalListPrice": 1199000 +"OriginatingSystemModificationTimestamp": "2026-03-02T16:17:56Z" +"OwnerName": "Jel Const & Maint Corp" +"ParcelNumber": "2089-55-007-00-0631-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-03-02T16:19:36Z" +"PhotosCount": 21 +"PostalCity": "Merrick" +"PostalCodePlus4": "2032" +"PurchaseContractDate": "2026-02-25" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-356-9283" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-25T21:49:13Z" +"StreetName": "Rhode" +"StreetNumber": "1415" +"StreetNumberNumeric": "1415" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13501.1" +"TaxAssessedValue": 454 +"TaxYear": "2024" +"Utilities": array:9 [ …9] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Other" +"KEY_CurrentPrice": "1199000.00" +"KEY_ContractPrice": "1250000.00" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalRooms": "Dining Area" +"KEY_IncludedInTaxes": "Sewer,Trash,Water" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2200.00" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "545.00000" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7598225.6020" +"KEY_RATIO_CurrentPrice_By_LivingArea": "545.00000" +"KEY_SourceSystemModificationTimestamp": "2026-02-18T11:19:30.783" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "931.62393" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "931.62393" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423600743')" +"provider_name": "One Key" +"Media": array:21 [ …21] +"ID": "30105" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5119 +post_id: "30124" +post_author: 1 +"ListingKey": "KEY423589164" +"ListingId": "962365" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-03-14T07:07:39Z" +"RFModificationTimestamp": "2026-03-14T07:12:32Z" +"ListPrice": 1250000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2424.0 +"BuildingAreaTotal": 2424.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1827 Glenn Lane, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6413929 +"Longitude": -73.5490505 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Paul M. DeTurris" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "177637" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": ""Entertainers Delight," Spectacular 4 bedroom/3 full bath, Hi-Ranch on Oversized 1/4 acre park-sized property, "Open Concept" main level with cathedral ceilings. Double entry foyer, Hardwood Floors, All modern EIK w/stainless steel appliances (gas ready-hook-up) w/ balcony terrace. Primary bedroom 1st floor w/new full bath. Lower level has large entertainment area or family room, 4th bedroom and bath. Laundry room, Park-sized yard is pool ready. Outdoor kitchen, fireplace. Pergola. Fenced in property. Ingrnd sprinklers, pavers. reverse-osmosis water treatment system, fully alarmed. attic. C/A, 2 car garage." +"Appliances": array:9 [ …9] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentEmail": "bpugh@elliman.com" +"BuyerAgentFullName": "Barbara A. Pugh" +"BuyerAgentKey": "326264329" +"BuyerAgentMlsId": "92298" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110766" +"BuyerOfficeMlsId": "DERE28" +"BuyerOfficeName": "Douglas Elliman Real Estate" +"BuyerOfficePhone": "516-623-4500" +"CarportSpaces": "2" +"CarportYN": true +"CoListAgentAOR": "LIBOR" +"CoListAgentEmail": "carmela.dragonetti@elliman.com" +"CoListAgentFullName": "Carmela Dragonetti" +"CoListAgentKey": "326141666" +"CoListAgentMlsId": "126970" +"CoListOfficeKey": "326110766" +"CoListOfficeMlsId": "DERE28" +"CoListOfficeName": "Douglas Elliman Real Estate" +"CoListOfficePhone": "516-623-4500" +"ConstructionMaterials": array:4 [ …4] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-22T23:12:46.109820+00:00" +"CrossStreet": "Lonni Ln / Monterey Dr" +"CumulativeDaysOnMarket": 19 +"DaysOnMarket": 19 +"Disclosures": array:1 [ …1] +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-31" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:3 [ …3] +"Flooring": array:3 [ …3] +"FoundationDetails": array:3 [ …3] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy 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-509-0907" +"ListAgentEmail": "paul.deturris@elliman.com" +"ListAgentKey": "326188316" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-02-16" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Public Records" +"LotFeatures": array:5 [ …5] +"LotSizeAcres": 0.2025 +"LotSizeDimensions": "59x114" +"LotSizeSquareFeet": 8820 +"MajorChangeTimestamp": "2026-03-13T16:48:06Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-03-13" +"OnMarketDate": "2026-02-22" +"OriginalEntryTimestamp": "2026-02-22T23:10:30Z" +"OriginalListPrice": 1250000 +"OriginatingSystemModificationTimestamp": "2026-03-13T16:48:06Z" +"OtherStructures": array:2 [ …2] +"OwnerName": "Sean Burke & Jeanette Dragonetti" +"ParcelNumber": "2089-62-215-00-0056-0" +"ParkingFeatures": array:6 [ …6] +"ParkingTotal": "2" +"PatioAndPorchFeatures": array:4 [ …4] +"PhotosChangeTimestamp": "2026-02-22T23:47:36Z" +"PhotosCount": 38 +"PostalCity": "Merrick" +"PostalCodePlus4": "5127" +"PurchaseContractDate": "2026-03-13" +"RoomsTotal": "9" +"SecurityFeatures": array:3 [ …3] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516 623-4500" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-13T16:48:06Z" +"StreetName": "Glenn" +"StreetNumber": "1827" +"StreetNumberNumeric": "1827" +"StreetSuffix": "Lane" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "18789.85" +"TaxAssessedValue": 656 +"TaxBlock": "215" +"TaxLot": "56" +"TaxYear": "2024" +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"KEY_Attic": "Full" +"KEY_HoldDate": "2026-03-03" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "62-215" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1250000.00" +"KEY_ContractPrice": "1250000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_MlsDistrictCode": "6221500560" +"KEY_AdditionalFeesYN": "0" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2424.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "515.67657" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6172839.5062" +"KEY_RATIO_CurrentPrice_By_LivingArea": "515.67657" +"KEY_SourceSystemModificationTimestamp": "2026-02-17T12:05:32.333" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "515.67657" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "515.67657" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423589164')" +"provider_name": "One Key" +"Media": array:38 [ …38] +"ID": "30124" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5126 +post_id: "30017" +post_author: 1 +"ListingKey": "KEY423510862" +"ListingId": "959968" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-03-06T19:46:36Z" +"RFModificationTimestamp": "2026-03-06T19:54:19Z" +"ListPrice": 749000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1462.0 +"BuildingAreaTotal": 1462.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "840 Jerusalem Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6913537 +"Longitude": -73.5599895 +"YearBuilt": 1949 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Emily LaRocca" +"ListOfficeName": "The Agency Northshore NY" +"ListAgentMlsId": "203249" +"ListOfficeMlsId": "SFGR02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Beautifully maintained and thoughtfully expanded, this 4 bedroom, 2 bath Cape offers the perfect blend of classic charm and modern comfort. Featuring a spacious rear addition, the home provides generous living space ideal for everyday living and entertaining. The layout includes two bedrooms and a full bath on the first floor, along with two additional bedrooms and a second full bath upstairs, offering flexibility for guests, a home office, or additional household needs.The large rear extension creates an open and inviting flow, while the full basement provides excellent storage. A one car garage adds convenience, and the Trex deck overlooks the backyard, offering a low maintenance outdoor space perfect for relaxing or hosting.Pride of ownership is evident throughout this move in ready home." +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-870-0753" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-724-1909" +"BuyerAgentEmail": "hemantkhanna29@gmail.com" +"BuyerAgentFullName": "Hemant Khanna" +"BuyerAgentKey": "326234717" +"BuyerAgentMlsId": "225955" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326116380" +"BuyerOfficeMlsId": "VORO01" +"BuyerOfficeName": "Voro LLC" +"BuyerOfficePhone": "877-943-8676" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-09T20:51:12.851788+00:00" +"CrossStreet": "Crocus Avenue" +"CumulativeDaysOnMarket": 18 +"DaysOnMarket": 18 +"ElementarySchool": "Harold D Fayette School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-08-09" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-813-9229" +"ListAgentEmail": "emily.larocca@theagencyre.com" +"ListAgentKey": "326212707" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115514" +"ListOfficePhone": "631-870-0753" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-02-09" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1281 +"LotSizeDimensions": "60x97" +"LotSizeSquareFeet": 5580 +"MajorChangeTimestamp": "2026-03-06T19:45:31Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-02-27" +"OnMarketDate": "2026-02-09" +"OriginalEntryTimestamp": "2026-02-09T20:46:07Z" +"OriginalListPrice": 749000 +"OriginatingSystemModificationTimestamp": "2026-03-06T19:45:31Z" +"OwnerName": "Bennett" +"ParcelNumber": "2089-56-429-00-0036-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-02-09T20:15:36Z" +"PhotosCount": 29 +"PostalCity": "Merrick" +"PostalCodePlus4": "1140" +"PurchaseContractDate": "2026-03-02" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "6318139229" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-06T19:45:31Z" +"StreetName": "Jerusalem" +"StreetNumber": "840" +"StreetNumberNumeric": "840" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "10480.4" +"TaxAssessedValue": 443 +"TaxBlock": "429" +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "See Remarks" +"KEY_HoldDate": "2026-02-27" +"KEY_TaxSource": "Other" +"KEY_TaxSection": "56" +"KEY_CurrentPrice": "749000.00" +"KEY_ContractPrice": "770000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Hold" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1462.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "512.31190" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5846994.5355" +"KEY_RATIO_CurrentPrice_By_LivingArea": "512.31190" +"KEY_SourceSystemModificationTimestamp": "2026-02-09T15:14:07.400" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "512.31190" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "512.31190" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423510862')" +"provider_name": "One Key" +"Media": array:29 [ …29] +"ID": "30017" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5127 +post_id: "30401" +post_author: 1 +"ListingKey": "KEY423506620" +"ListingId": "959817" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-15T00:05:36Z" +"RFModificationTimestamp": "2026-04-15T00:10:30Z" +"ListPrice": 624999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 980.0 +"BuildingAreaTotal": 980.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "75 Riverside Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6505372 +"Longitude": -73.5562489 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Victoria Monahan SRES" +"ListOfficeName": "Keller Williams Realty Greater" +"ListAgentMlsId": "197351" +"ListOfficeMlsId": "KEWG01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Charming 3-bedroom, 1-bath cape located in desirable South Merrick. This well-maintained home features an updated kitchen and bath, owned solar panels for energy efficiency, and a functional layout ideal for everyday living. Two main floor bedrooms and an additional second floor bedroom provide ultimate flexibility. A separate laundry room offers ample additional space—perfect for storage, a home office, or flex use. Oil heating and electric cooking with gas in the house (gas hot water heater). Detached garage and ample driveway parking. A fantastic opportunity in a sought-after neighborhood close to parks, shopping, and major roadways. **Use house number 2667 for GPS**" +"Appliances": array:9 [ …9] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-873-7100" +"Basement": array:1 [ …1] +"BathroomsFull": 1 +"BuildingAreaSource": "Cubi Casa" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-709-5046" +"BuyerAgentEmail": "Bonanno Russ@gmail.com" +"BuyerAgentFullName": "Russell J. Bonanno Jr" +"BuyerAgentKey": "326175350" +"BuyerAgentMlsId": "163576" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326109887" +"BuyerOfficeMlsId": "BON01" +"BuyerOfficeName": "Bon Anno Realty ERA Powered" +"BuyerOfficePhone": "516-420-9055" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-200-4694" +"CoListAgentEmail": "gina@theginapadroteam.com" +"CoListAgentFullName": "Gina M. Padro HFR PSA RSPS SFR SRS" +"CoListAgentKey": "326243734" +"CoListAgentMlsId": "82224" +"CoListOfficeKey": "326112861" +"CoListOfficeMlsId": "KEWG01" +"CoListOfficeName": "Keller Williams Realty Greater" +"CoListOfficePhone": "516-873-7100" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-12T14:54:52.095728+00:00" +"CrossStreet": "Bernard Street" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 8 +"DirectionFaces": "West" +"Directions": "Merrick Road to Clubhouse Road to Bernard Street to Riverside Avenue (house # is 2667 Riverside - use this for GPS!)." +"Disclosures": array:2 [ …2] +"DoorFeatures": array:1 [ …1] +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-04" +"ExteriorFeatures": array:3 [ …3] +"Fencing": array:2 [ …2] +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:4 [ …4] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-897-6869" +"ListAgentEmail": "victoria@theginapadroteam.com" +"ListAgentKey": "326206983" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112861" +"ListOfficePhone": "516-873-7100" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2026-03-06" +"ListingTerms": "Cash,Conventional,FHA,VA" +"LivingAreaSource": "Public Records" +"LotFeatures": array:8 [ …8] +"LotSizeAcres": 0.1263 +"LotSizeDimensions": "55x100" +"LotSizeSquareFeet": 5500 +"MajorChangeTimestamp": "2026-04-15T00:04:26Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-03-20" +"OnMarketDate": "2026-03-12" +"OriginalEntryTimestamp": "2026-03-12T14:47:26Z" +"OriginalListPrice": 624999 +"OriginatingSystemModificationTimestamp": "2026-04-15T00:04:26Z" +"OtherStructures": array:1 [ …1] +"OwnerName": "Werner" +"ParcelNumber": "2089-62-006-00-0102-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-12T14:48:36Z" +"PhotosCount": 23 +"PostalCity": "Merrick" +"PostalCodePlus4": "4555" +"PurchaseContractDate": "2026-04-10" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-897-6869" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-15T00:04:26Z" +"StreetName": "Riverside" +"StreetNumber": "75" +"StreetNumberNumeric": "75" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "11638.32" +"TaxAssessedValue": 374 +"TaxBlock": "6" +"TaxLot": "102" +"TaxYear": "2026" +"Utilities": array:6 [ …6] +"View": "Neighborhood" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"KEY_Attic": "Scuttle" +"KEY_HoldDate": "2026-03-20" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "62" +"KEY_CurrentPrice": "624999.00" +"KEY_ContractPrice": "650000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Hold" +"KEY_SolarOwnership": "Owned" +"KEY_DistanceToTrain": "1.90" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "980.00" +"KEY_NumberOfHeatingZones": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "637.75408" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4948527.3159" +"KEY_RATIO_CurrentPrice_By_LivingArea": "637.75408" +"KEY_SourceSystemModificationTimestamp": "2026-02-09T11:59:51.750" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "637.75408" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "637.75408" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423506620')" +"provider_name": "One Key" +"Media": array:23 [ …23] +"ID": "30401" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5128 +post_id: "30003" +post_author: 1 +"ListingKey": "KEY423490180" +"ListingId": "959327" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-08T07:05:42Z" +"RFModificationTimestamp": "2026-04-08T07:10:59Z" +"ListPrice": 1380000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3247.0 +"BuildingAreaTotal": 3247.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "18 Helene Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6698276 +"Longitude": -73.5469467 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Keith Barnes" +"ListOfficeName": "REO First Choice Realty LLC" +"ListAgentMlsId": "9032733" +"ListOfficeMlsId": "MISH01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "We are thrilled to announce that the Short Sale for this stunning residence in the heart of Merrick has been approved. This incredible home boasts an impressive array of features that are sure to delight even the most discerning buyer. With five spacious bedrooms, including a luxurious master suite that is a true lady's dream and a serene retreat, complete with double walk in closets and a opulent bathroom featuring a jacuzzi tub. The large open kitchen is perfect for entertaining with ample space to cook, dine and socialize. The home features a range of modern amenities, including a Navien tankless heating system, heated marble floors, and a threatre room. Don't miss out on this incredible opportunity." +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-483-5400" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "HGAR" +"BuyerAgentDirectPhone": "000-000-0000" +"BuyerAgentFullName": "Non Member-MLS" +"BuyerAgentKey": "1262689" +"BuyerAgentMlsId": "8888" +"BuyerOfficeAOR": "HGAR" +"BuyerOfficeKey": "1262827" +"BuyerOfficeMlsId": "888888" +"BuyerOfficeName": "Buyer Representation Office" +"BuyerOfficePhone": "000-000-0000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-06T20:25:12.994347+00:00" +"CumulativeDaysOnMarket": 60 +"DaysOnMarket": 60 +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-12-31" +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-327-5365" +"ListAgentEmail": "reofirstchoice@gmail.com" +"ListAgentKey": "326257451" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113706" +"ListOfficePhone": "516-483-5400" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2026-02-06" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1607 +"LotSizeSquareFeet": 7000 +"MajorChangeTimestamp": "2026-04-07T22:18:16Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-07" +"OnMarketDate": "2026-02-06" +"OriginalEntryTimestamp": "2026-02-06T20:18:39Z" +"OriginalListPrice": 1420000 +"OriginatingSystemModificationTimestamp": "2026-04-07T22:18:16Z" +"OwnerName": "Eddyli Rosario" +"ParcelNumber": "2089-56-448-00-0003-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-02-13T23:07:36Z" +"PhotosCount": 5 +"PostalCity": "Merrick" +"PostalCodePlus4": "3205" +"PreviousListPrice": 1420000 +"PriceChangeTimestamp": "2026-02-13T01:24:20Z" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-04-07" +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-07T22:18:16Z" +"StreetName": "Helene" +"StreetNumber": "18" +"StreetNumberNumeric": "18" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17301" +"TaxAssessedValue": 1057 +"TaxYear": "2024" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1380000.00" +"KEY_ContractPrice": "1300000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "3247.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "425.00770" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8587429.9938" +"KEY_RATIO_CurrentPrice_By_LivingArea": "425.00770" +"KEY_SourceSystemModificationTimestamp": "2026-02-06T15:18:39.487" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "425.00770" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97183" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "425.00770" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423490180')" +"provider_name": "One Key" +"Media": array:5 [ …5] +"ID": "30003" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5129 +post_id: "29994" +post_author: 1 +"ListingKey": "KEY423475140" +"ListingId": "958901" +"PropertyType": "Commercial Lease" +"PropertySubType": "Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-24T07:05:38Z" +"RFModificationTimestamp": "2026-04-24T07:15:00Z" +"ListPrice": 1450.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 500.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "25 Merrick Ave Unit 25, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dorothy P. Powell SRES" +"ListOfficeName": "Realty Pros Plus Inc" +"ListAgentMlsId": "173882" +"ListOfficeMlsId": "RLTP01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "2 SPACES NOW AVAIL - Large, bright, private office for lease on 2nd floor in prestigious law office building. This office/ flex space, located in the south west wing also offers the addition of a beautiful adjoining client waiting room and private bathroom...with the possibility of two extra small office spaces for your admin/staff. All of this space is contiguous for a cohesive turn-key professional business presence that will surly impress your clients. Use of conference room included along with a receptionist on the first floor with a general waiting room to meet and greet your clients. Conveniently located next to train station and in the heart of Merrick Village with plenty of parking right behind building. This space is perfect for a professional: law, accounting, mortgage professional or similar industry. Note: Additional space use TBD -- inquire within. (1st floor handicap conference room also available for client convenience.)" +"AttributionContact": "516-804-9000" +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Professional/Office" +"BuyerOfficeAOR": "LIBOR" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-05T18:55:48.939648+00:00" +"CumulativeDaysOnMarket": 48 +"DaysOnMarket": 57 +"Directions": "Located on the corner of Merrick Ave & Fisher Ave. just north of Sunrise Highway" +"ExpirationDate": "2026-12-01" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeasableArea": 500 +"LeaseAmountFrequency": "Annually" +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-491-1775" +"ListAgentEmail": "realtyprosplus@gmail.com" +"ListAgentKey": "326184865" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115113" +"ListOfficePhone": "516-804-9000" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2026-02-05" +"MajorChangeTimestamp": "2026-04-23T14:21:24Z" +"MajorChangeType": "Back On Market" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-02-05" +"OriginalEntryTimestamp": "2026-02-05T18:51:41Z" +"OriginalListPrice": 1450 +"OriginatingSystemModificationTimestamp": "2026-04-23T14:21:24Z" +"OwnerName": "Krohn, Rosenblum & Rosenblum" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-02-10T02:33:36Z" +"PhotosCount": 17 +"PostalCity": "Merrick" +"PriceChangeTimestamp": "2026-02-05T18:51:41Z" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516 491-1775" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-23T14:21:24Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Merrick Ave" +"StreetNumber": "25" +"StreetNumberNumeric": "25" +"SyndicateTo": array:3 [ …3] +"TaxAnnualAmount": "73000" +"TaxYear": "2025" +"UnitNumber": "25" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_ElevatorYN": "0" +"KEY_SqFtOffice": "500" +"KEY_UsableArea": "500.00" +"KEY_CurrentPrice": "1450.00" +"KEY_PermittedUses": "Office" +"KEY_LeasePriceUnit": "Total" +"KEY_PreviousStatus": "Pending" +"KEY_SecurityDeposits": "1450" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Back On Market" +"KEY_SourceSystemModificationTimestamp": "2026-02-05T13:14:38.170" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "2.90000" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "2.90000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423475140')" +"provider_name": "One Key" +"Media": array:17 [ …17] +"ID": "29994" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5130 +post_id: "29993" +post_author: 1 +"ListingKey": "KEY423459074" +"ListingId": "958397" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-30T15:24:36Z" +"RFModificationTimestamp": "2026-04-30T15:30:39Z" +"ListPrice": 1599000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1959.0 +"BuildingAreaTotal": 1959.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2077 Byron Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6559335 +"Longitude": -73.5458057 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Seth B. Levy" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "160761" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "CALLING ALL MERRICK INVESTORS & HOMEOWNERS! TAKE ADVANTAGE OF THIS RARE OPPORTUNITY TO BUILD 2 CUSTOM HOMES IN MERRICK’S LINDENMERE ESTATES!! LOCATED CLOSE TO THE LIRR, MERRICK VILLAGE, PARKS, BEACHES, MARINAS & WATERFRONT DINING, THIS PROPERTY CAN BE DIVIDED TO ACCOMMODATE 2 BRAND NEW HOMES ON 6,000 SQ. FT. LOTS EACH OR 1 BRAND NEW HOME ON A SPRAWLING 12,000 SQ. FT. ESTATE STYLE PROPERTY!" +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BodyType": array:1 [ …1] +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-05T18:01:56.287646+00:00" +"CumulativeDaysOnMarket": 84 +"DaysOnMarket": 87 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-05" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-546-6300" +"ListAgentEmail": "slevy@signaturepremier.com" +"ListAgentKey": "326172773" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-02-05" +"LivingAreaSource": "Public Records" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.2755 +"LotSizeSquareFeet": 12001 +"MajorChangeTimestamp": "2026-04-30T15:23:05Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-02-05" +"OriginalEntryTimestamp": "2026-02-05T18:00:14Z" +"OriginalListPrice": 1700000 +"OriginatingSystemModificationTimestamp": "2026-04-30T15:23:05Z" +"OwnerName": "Kudler" +"ParcelNumber": "2089-63-135-00-0839-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-02-05T18:01:36Z" +"PhotosCount": 4 +"PostalCity": "Merrick" +"PostalCodePlus4": "5033" +"PreviousListPrice": 1650000 +"PriceChangeTimestamp": "2026-04-30T15:23:05Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-528-1737" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-05T18:00:14Z" +"StreetName": "Byron" +"StreetNumber": "2077" +"StreetNumberNumeric": "2077" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17909.55" +"TaxAssessedValue": 608 +"TaxYear": "2025" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1599000.00" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "1959.00" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "816.23277" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5803992.7405" +"KEY_RATIO_CurrentPrice_By_LivingArea": "816.23277" +"KEY_SourceSystemModificationTimestamp": "2026-02-04T11:53:23.560" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "816.23277" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.94059" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "816.23277" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423459074')" +"provider_name": "One Key" +"Media": array:4 [ …4] +"ID": "29993" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5131 +post_id: "30919" +post_author: 1 +"ListingKey": "KEY423457743" +"ListingId": "958347" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-28T01:17:36Z" +"RFModificationTimestamp": "2026-04-28T01:20:28Z" +"ListPrice": 2100000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3544.0 +"BuildingAreaTotal": 3544.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2883 Shore Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6468396 +"Longitude": -73.54638 +"YearBuilt": 1960 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shari M. DeLouya CBR" +"ListOfficeName": "Realty Connect USA LLC" +"ListAgentMlsId": "103104" +"ListOfficeMlsId": "RLLE02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Discover luxury waterfront living in this meticulously expanded South Merrick post-modern retreat. Featuring 4/5 bedrooms and 3.5 bathrooms, this home offers a stunning chef’s kitchen with high-end appliances, soaring 20-foot ceilings in the dramatic great room with a stone fireplace, and a massive, resort-style backyard on a protected wide canal. Engineered for enjoyment and security with a Navy bulkhead, pool, hot tub, boat lift, and top-tier upgrades throughout. \n \n The 10-year-old chef's kitchen boasts white shaker cabinets, quartz countertops, coordinating tile backsplash, Wolf double oven with 6-burner gas cooktop/griddle with vented hood, GE Monogram beverage refrigerator in Island, KitchenAid refrigerator, Miele dishwasher, GE microwave drawer, and a dedicated center island with gray hued shaker cabinets. Overlooking the Spectacular wide canal views, enjoy a 70-foot Navy bulkhead completely protected with 35 helical piles, a 18,000 ton boat lift (7 years old), gas-heated pool with waterfall/Loop-Loc cover, a heated hot tub, and composite deck with a full granite outdoor kitchen including BBQ, sink and refrigerator.\n The great room is a true WOW with floor-to-ceiling Eldorado stone fireplace, Andersen windows, and custom window treatments. Hardwood Floors throughout, The home is hardwired cat-5, 200-amp electric, surround sound indoors and out, 3-zone CAC/4-zone gas heat via Nest thermostats, and fully paid-off 6 year old solar panels for efficient and low cost energy. Electricity is just $14 a month!\n Fabulous curb appeal with Cedar impression siding, stunning double mahogany front doors, paving stone driveway, estate fencing, Ring doorbell, and a comprehensive security system. The Multi level layout has a thoughtful flow where the main level spaces are inviting and open. The Gourmet kitchen and dining room overlooks the calming large canal and together with the Great room create the heart of the home! Three bedrooms and 2 full baths offer privacy while the primary suite creates the tranquility and relaxation you deserve. A stunning spa bathroom with separate large shower and jetted tub, a walk in closet and a balcony to take in the morning sunrise over the water! A main level office/ guest room and powder room lead out to the country club yard or bring you back to the additional family room, gym with double egress and large laundry room with Newer LG Front loaders. The 2 car garage includes epoxy floors and full garage tech system. Pull down attic, Ceiling Fans in all Bedrooms, 2 zone Baseboard gas heat and 2 Zone forced air gas heat. Rheem 72 gallon hot water heater and Burnham gas burner. Custom cast iron railings.\n This exceptional home combines high end craftsmanship with unbeatable waterfront living! This is truly a one of a kind Entertainers paradise in one of South Merricks most desirable locations! Do not miss this opportunity! Flood insurance $1593 """ +"Appliances": array:11 [ …11] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "smdelouya@gmail.com" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-993-4721" +"CoListAgentEmail": "mimber@aol.com" +"CoListAgentFullName": "Marci Imber" +"CoListAgentKey": "326260685" +"CoListAgentMlsId": "9070310" +"CoListOfficeKey": "326115083" +"CoListOfficeMlsId": "RLLE02" +"CoListOfficeName": "Realty Connect USA LLC" +"CoListOfficePhone": "516-714-3606" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-21T20:41:50.949124+00:00" +"CrossStreet": "Julian Lane" +"CumulativeDaysOnMarket": 4 +"DaysOnMarket": 9 +"Directions": "Merrick Rd to Lindenmere Dr to Shore Drive" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-10-21" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"FrontageLength": "70 Ft" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:4 [ …4] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:25 [ …25] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-834-1892" +"ListAgentEmail": "smdelouya@gmail.com" +"ListAgentKey": "326119600" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115083" +"ListOfficePhone": "516-714-3606" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-21" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.1768 +"LotSizeSquareFeet": 7700 +"MajorChangeTimestamp": "2026-04-23T10:00:26Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-04-23" +"OriginalEntryTimestamp": "2026-04-21T20:38:23Z" +"OriginalListPrice": 2100000 +"OriginatingSystemModificationTimestamp": "2026-04-28T01:16:28Z" +"OtherEquipment": array:1 [ …1] +"OwnerName": "Name Withheld" +"ParcelNumber": "2089-62-197-00-0024-0" +"ParkingFeatures": array:2 [ …2] +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-04-21T21:10:36Z" +"PhotosCount": 50 +"PoolFeatures": array:2 [ …2] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "5220" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "9" +"SecurityFeatures": array:3 [ …3] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "855-920-8240" +"ShowingRequirements": array:1 [ …1] +"SpaFeatures": array:1 [ …1] +"SpaYN": true +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-23T10:00:26Z" +"StreetName": "Shore" +"StreetNumber": "2883" +"StreetNumberNumeric": "2883" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "26793.01" +"TaxAssessedValue": 938 +"TaxYear": "2026" +"Utilities": array:7 [ …7] +"View": "Water" +"VirtualTourURLBranded": "https://homediagroup.com/2883-Shore-Dr" +"VirtualTourURLUnbranded": "https://homediagroup.com/2883-Shore-Dr/idx" +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:2 [ …2] +"WaterfrontYN": true +"WindowFeatures": array:4 [ …4] +"KEY_Attic": "Pull Stairs" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "2100000.00" +"KEY_WaterAccessYN": "1" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Coming Soon" +"KEY_SolarOwnership": "Owned" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ConcessionInPrice": "0.00" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "3544.00" +"KEY_NumberOfHeatingZones": "4" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-993-4721" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "592.55079" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "11877828.0543" +"KEY_RATIO_CurrentPrice_By_LivingArea": "592.55079" +"KEY_SourceSystemModificationTimestamp": "2026-02-04T10:32:13.180" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "592.55079" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "592.55079" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423457743')" +"provider_name": "One Key" +"Media": array:50 [ …50] +"ID": "30919" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5132 +post_id: "30044" +post_author: 1 +"ListingKey": "KEY423435806" +"ListingId": "957689" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-03-09T15:02:36Z" +"RFModificationTimestamp": "2026-03-09T15:10:25Z" +"ListPrice": 629000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1111.0 +"BuildingAreaTotal": 1300.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "29 Babylon Turnpike, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.662083 +"Longitude": -73.562699 +"YearBuilt": 1936 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Karen Richter Rett" +"ListOfficeName": "Branch Real Estate Group" +"ListAgentMlsId": "168724" +"ListOfficeMlsId": "BCRE01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to Merrick! This well kept 2 bedroom/could possibly be 3 Cape Cod Style home, is located in the heart of Merrick! The beautiful wood floors and brick fire place make this home a perfect starter home! The dining room has beautiful built in cabinetry to host some great meals. The kitchen is steps away from a beautiful back sun filled room full of windows. A room which leads to the private, fenced in yard. There is a rear end extension for extra space which could be considered a bedroom, den, whatever your needs might be! Some extra features are gas stove and dryer. Newer replacement windows, Separate Hot Water Heater. Fairly new driveway and sidewalk. Reasonable taxes! You won't want to miss this and I'm sure won't last too long! Pictures to follow!" +"Appliances": array:3 [ …3] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-671-4400" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "646-423-9865" +"BuyerAgentEmail": "stevenleong11@gmail.com" +"BuyerAgentFullName": "Steven Leong" +"BuyerAgentKey": "326127917" +"BuyerAgentMlsId": "111979" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326112207" +"BuyerOfficeMlsId": "HUZH01" +"BuyerOfficeName": "New Group Realty Inc" +"BuyerOfficePhone": "718-255-9100" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:2 [ …2] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-12T09:12:45.922764+00:00" +"CrossStreet": "Bedford Avenue" +"CumulativeDaysOnMarket": 22 +"DaysOnMarket": 22 +"Directions": "GPS or WAZE" +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-03" +"Fencing": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-317-1750" +"ListAgentEmail": "karenrichter@branchreg.com" +"ListAgentKey": "326180081" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109661" +"ListOfficePhone": "516-671-4400" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-02-02" +"LivingAreaSource": "Measured" +"LotSizeAcres": 0.1113 +"LotSizeSquareFeet": 4850 +"MajorChangeTimestamp": "2026-03-09T15:01:29Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-03-06" +"OnMarketDate": "2026-02-12" +"OriginalEntryTimestamp": "2026-02-12T09:07:25Z" +"OriginalListPrice": 629000 +"OriginatingSystemModificationTimestamp": "2026-03-09T15:01:29Z" +"OtherStructures": array:1 [ …1] +"OwnerName": "Ayala" +"ParcelNumber": "2089-55-G-00-0020-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2" +"PhotosChangeTimestamp": "2026-02-10T14:45:36Z" +"PhotosCount": 28 +"PostalCity": "Merrick" +"PostalCodePlus4": "3534" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-03-09" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516 317 1750" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-09T15:01:29Z" +"StreetName": "Babylon" +"StreetNumber": "29" +"StreetNumberNumeric": "29" +"StreetSuffix": "Turnpike" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "12202.79" +"TaxAssessedValue": 402 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_HoldDate": "2026-03-06" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "629000.00" +"KEY_ContractPrice": "668000.00" +"KEY_OpenHouseCount": "3" +"KEY_PreviousStatus": "Hold" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1111.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "566.15662" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5651392.6325" +"KEY_RATIO_CurrentPrice_By_LivingArea": "566.15662" +"KEY_SourceSystemModificationTimestamp": "2026-02-02T15:48:23.170" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "483.84615" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "483.84615" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423435806')" +"provider_name": "One Key" +"Media": array:28 [ …28] +"ID": "30044" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5133 +post_id: "30643" +post_author: 1 +"ListingKey": "KEY423417620" +"ListingId": "957150" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-01T22:12:36Z" +"RFModificationTimestamp": "2026-04-01T22:15:05Z" +"ListPrice": 749900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 1648.0 +"BuildingAreaTotal": 1648.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "56 Beach Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6517836 +"Longitude": -73.5557472 +"YearBuilt": 1931 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gus Lafkas" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "148804" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this spacious 5-Bedroom , 2-Bath Bath Colonial featuring classic stucco exterior and plenty of curb appeal on a desirable corner property. Enjoy the convenience of a detached garage and ample outdoor space for gardening, play, or future expansion.\n Inside, you’ll find generous living areas perfect for family living and entertaining. The home’s layout offers flexibility for a home office, playroom, or guest space. Natural light fills the rooms, creating a warm and inviting atmosphere.\n Located near transportation, this home provides easy access to commuting options, shopping, dining, and more — an ideal blend of suburban comfort and commuter convenience. Don’t miss out on this exceptional property! """ +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-01T22:14:51.556833+00:00" +"CrossStreet": "Bernard St" +"Directions": "Merrick Rd to Beach" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-31" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-445-0657" +"ListAgentEmail": "guslafkasrealestate@yahoo.com" +"ListAgentKey": "326161645" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-01-31" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.0964 +"LotSizeSquareFeet": 4200 +"MajorChangeTimestamp": "2026-04-01T22:11:17Z" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-04-01" +"OriginalEntryTimestamp": "2026-04-01T22:11:17Z" +"OriginalListPrice": 749900 +"OriginatingSystemModificationTimestamp": "2026-04-01T22:11:17Z" +"OwnerName": "56 Beach Drive Llc" +"ParcelNumber": "2089-62-007-00-0006-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-03-26T12:59:36Z" +"PhotosCount": 9 +"PostalCity": "Merrick" +"PostalCodePlus4": "4595" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5164450657" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-01T22:11:17Z" +"StreetName": "Beach" +"StreetNumber": "56" +"StreetNumberNumeric": "56" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13225" +"TaxAssessedValue": 449 +"TaxYear": "2024" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial,Partially Finished" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "749900.00" +"KEY_ShowingTimeFlagYN": "1" +"KEY_LivingAreaSearchSqFt": "1648.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "455.03641" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7779045.6432" +"KEY_RATIO_CurrentPrice_By_LivingArea": "455.03641" +"KEY_SourceSystemModificationTimestamp": "2026-01-31T16:04:22.810" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "455.03641" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "455.03641" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423417620')" +"provider_name": "One Key" +"short_address": "Hempstead, New York 11566, USA" +"Media": array:9 [ …9] +"ID": "30643" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5134 +post_id: "29942" +post_author: 1 +"ListingKey": "KEY423407905" +"ListingId": "956874" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-26T14:35:36Z" +"RFModificationTimestamp": "2026-03-26T14:39:08Z" +"ListPrice": 1599000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3000.0 +"BuildingAreaTotal": 6820.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2043 Ripley, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6577567 +"Longitude": -73.5485189 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ken I. Deutsch CBR GRI" +"ListOfficeName": "Deutsch Realty Inc" +"ListAgentMlsId": "124451" +"ListOfficeMlsId": "KDEU01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Located in the heart of Merrick lies in a cul-de-sac this beautiful 4 bedroom 3 1/2 bath plus 2 dens flanked by a large pool with plenty of deck space to enjoy outdoor living. Top of the line appliances such as a Wolf gas burner, Wolf double oven, Wolf microwave, trash compactor, sub-Zero fridge and more. Open floor plan with multiple places to dine and entertain. Walking distance to the train. This gem is ready to move in and enjoy." +"Appliances": array:11 [ …11] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-931-8600" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "972-672-9909" +"CoListAgentEmail": "brenda@deutschrealty.com" +"CoListAgentFullName": "Brenda Donnelly" +"CoListAgentKey": "422961945" +"CoListAgentMlsId": "505840" +"CoListOfficeKey": "326112832" +"CoListOfficeMlsId": "KDEU01" +"CoListOfficeName": "Deutsch Realty Inc" +"CoListOfficePhone": "516-931-8600" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-01-30T19:42:18.968322+00:00" +"CumulativeDaysOnMarket": 46 +"DaysOnMarket": 84 +"DirectionFaces": "South" +"Directions": "See map quest" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-01-30" +"ExteriorFeatures": array:3 [ …3] +"Fencing": array:3 [ …3] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:9 [ …9] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-931-8600" +"ListAgentEmail": "ken@deutschrealty.com" +"ListAgentKey": "326139417" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112832" +"ListOfficePhone": "516-931-8600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-01-30" +"LivingAreaSource": "Other" +"LotFeatures": array:6 [ …6] +"LotSizeAcres": 0.1566 +"LotSizeDimensions": "42X107" +"LotSizeSquareFeet": 6820 +"MajorChangeTimestamp": "2026-02-09T21:37:23Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-02-08" +"OriginalEntryTimestamp": "2026-01-30T19:39:01Z" +"OriginalListPrice": 1348000 +"OriginatingSystemModificationTimestamp": "2026-03-26T14:34:26Z" +"OtherStructures": array:2 [ …2] +"OwnerName": "withheld" +"ParcelNumber": "2089-56-176-00-0224-0" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-02-07T23:27:36Z" +"PhotosCount": 37 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PreviousListPrice": 1348000 +"PriceChangeTimestamp": "2026-02-09T21:37:23Z" +"RoomsTotal": "10" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-578-2617" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-08T05:30:59Z" +"StreetName": "Ripley" +"StreetNumber": "2043" +"StreetNumberNumeric": "2043" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "19284" +"TaxYear": "2026" +"Utilities": array:2 [ …2] +"VirtualTourURLBranded": "https://jumpvisualtours.com/489735" +"VirtualTourURLUnbranded": "https://jumpvisualtours.com/r/489735" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_TaxSource": "Other" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1599000.00" +"KEY_PreviousStatus": "Coming Soon" +"KEY_DistanceToTrain": "0.05" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Increase" +"KEY_LivingAreaSearchSqFt": "3000.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_ShowingContactPhone2": "972-672-9909" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "533.00000" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "10210727.9693" +"KEY_RATIO_CurrentPrice_By_LivingArea": "533.00000" +"KEY_SourceSystemModificationTimestamp": "2026-01-30T13:41:31.453" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "234.45748" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.18620" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "234.45748" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423407905')" +"provider_name": "One Key" +"Media": array:37 [ …37] +"ID": "29942" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5135 +post_id: "29931" +post_author: 1 +"ListingKey": "KEY423389442" +"ListingId": "956362" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-03-23T07:05:38Z" +"RFModificationTimestamp": "2026-03-23T07:08:08Z" +"ListPrice": 849999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1386.0 +"BuildingAreaTotal": 1386.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1709 Camp Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6781445 +"Longitude": -73.5687095 +"YearBuilt": 1949 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rahreese Kenchen" +"ListOfficeName": "Fave Realty Inc" +"ListAgentMlsId": "159247" +"ListOfficeMlsId": "FVE01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Beautifully renovated one-family home in the heart of North Merrick, conveniently located just off the Meadowbrook Parkway. This spacious residence offers 4 generously sized bedrooms and 3 full bathrooms, including a primary bedroom with a private en-suite bath. Featuring hardwood floors throughout, a brand-new kitchen with stainless steel appliances, and modern ductless HVAC for year-round comfort. The fully finished basement provides additional living or recreational space. Exterior highlights include sleek modern black windows, a one-car garage, and a newly installed sprinkler system. A perfect blend of style, space, and convenience—move-in ready and not to be missed!" +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-519-8049" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-210-6689" +"BuyerAgentEmail": "willkarlnyc@gmail.com" +"BuyerAgentFullName": "William Karl" +"BuyerAgentKey": "326196592" +"BuyerAgentMlsId": "186464" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326111282" +"BuyerOfficeMlsId": "EXP02" +"BuyerOfficeName": "EXP Realty" +"BuyerOfficePhone": "888-276-0630" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-01-29T01:33:50.386812+00:00" +"CumulativeDaysOnMarket": 54 +"DaysOnMarket": 52 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-03-28" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-519-8049" +"ListAgentEmail": "reesetherealtor@gmail.com" +"ListAgentKey": "326171381" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "418046046" +"ListOfficePhone": "516-519-8049" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2026-01-28" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1297 +"LotSizeSquareFeet": 5650 +"MajorChangeTimestamp": "2026-03-22T15:24:07Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-03-22" +"OnMarketDate": "2026-01-28" +"OriginalEntryTimestamp": "2026-01-29T01:26:57Z" +"OriginalListPrice": 899999 +"OriginatingSystemModificationTimestamp": "2026-03-22T15:24:07Z" +"OwnerName": "South Meadow Dev Llc" +"ParcelNumber": "2089-55-024-00-0243-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-02-18T20:22:36Z" +"PhotosCount": 22 +"PostalCity": "Merrick" +"PostalCodePlus4": "2542" +"PreviousListPrice": 899999 +"PriceChangeTimestamp": "2026-02-17T16:21:02Z" +"PurchaseContractDate": "2026-03-21" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] …35 } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5136 …123} 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5137 …149} 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5138 …188} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5139 …164} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5140 …143} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5141 …140} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5142 …126} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5143 …134} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5145 …127} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5114 …132} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5113 …151} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5112 …130} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5111 …130} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5110 …135} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5109 …137} ] +success: true +page_size: 32 +page_count: 6 +count: 166 +after_key: "" } "RF Response Time" => "0.19 seconds" ] ]