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=64&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (City eq 'Merrick' or PostalCity eq 'Merrick')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5269 +items: array:32 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5283 +post_id: "31014" +post_author: 1 +"ListingKey": "KEY424609260" +"ListingId": "991618" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-06-11T07:08:38Z" +"RFModificationTimestamp": "2026-06-11T07:12:07Z" +"ListPrice": 1095000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2873.0 +"BuildingAreaTotal": 2873.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1970 Brook Park Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6507575 +"Longitude": -73.5461905 +"YearBuilt": 1953 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marcell Lobato" +"ListOfficeName": "Graystone Properties Inc" +"ListAgentMlsId": "192990" +"ListOfficeMlsId": "GRYS01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ This well-maintained 4-bedroom, 4-bathroom home sits on an oversized lot and offers a bright, functional layout ideal for everyday living and entertaining. Currently configured as 4 bedrooms, it can be easily converted to a 5-bedroom to fit your needs.\n \n Enjoy a cozy fireplace in the main living area and an additional fireplace in the primary bedroom, adding warmth and charm throughout.\n \n The kitchen flows seamlessly into the main living spaces, while generously sized bedrooms and multiple bathrooms provide comfort and flexibility.\n \n Step outside to a private fenced-in backyard perfect for relaxing, pets, or hosting, all in a convenient location near shopping, dining, and major roadways. """ +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-667-0777" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 4 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "347-617-6558" +"BuyerAgentEmail": "alexio6985@yahoo.com" +"BuyerAgentFullName": "Alexio Boubev" +"BuyerAgentKey": "326227314" +"BuyerAgentMlsId": "218286" +"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-04-28T01:36:49.821872+00:00" +"CumulativeDaysOnMarket": 44 +"DaysOnMarket": 44 +"Disclosures": array:1 [ …1] +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-09-30" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "914-466-4265" +"ListAgentEmail": "marcell@graystonepropertiesny.com" +"ListAgentKey": "326202796" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111824" +"ListOfficePhone": "516-667-0777" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2026-04-27" +"LivingAreaSource": "Measured" +"LotSizeAcres": 0.1946 +"LotSizeSquareFeet": 8475 +"MajorChangeTimestamp": "2026-06-10T20:19:42Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-06-10" +"OnMarketDate": "2026-04-27" +"OriginalEntryTimestamp": "2026-04-28T01:30:03Z" +"OriginalListPrice": 1195000 +"OriginatingSystemModificationTimestamp": "2026-06-10T20:19:42Z" +"OwnerName": "Marcell & Sara Lobato" +"ParcelNumber": "2089-62-193-00-0005-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-28T02:00:36Z" +"PhotosCount": 27 +"PostalCity": "Merrick" +"PostalCodePlus4": "4606" +"PreviousListPrice": 1195000 +"PriceChangeTimestamp": "2026-05-11T18:06:53Z" +"PurchaseContractDate": "2026-06-10" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "9144664265" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-10T20:19:42Z" +"StreetName": "Brook Park" +"StreetNumber": "1970" +"StreetNumberNumeric": "1970" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "19396.95" +"TaxAssessedValue": 675 +"TaxYear": "2024" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Dormer" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1095000.00" +"KEY_ContractPrice": "1067000.00" +"KEY_OpenHouseCount": "0" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2873.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "381.13470" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5626927.0298" +"KEY_RATIO_CurrentPrice_By_LivingArea": "381.13470" +"KEY_SourceSystemModificationTimestamp": "2026-04-27T20:32:26.387" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.91632" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424609260')" +"provider_name": "One Key" +"Media": array:27 [ …27] +"ID": "31014" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5285 +post_id: "30982" +post_author: 1 +"ListingKey": "KEY424552837" +"ListingId": "990032" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-17T16:07:36Z" +"RFModificationTimestamp": "2026-06-17T16:13:29Z" +"ListPrice": 1895000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3432.0 +"BuildingAreaTotal": 3432.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2959 Shore Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.644704 +"Longitude": -73.5454123 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Michael Pesce" +"ListOfficeName": "BERKSHIRE HATHAWAY" +"ListAgentMlsId": "183760" +"ListOfficeMlsId": "BHHS03" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Experience the pinnacle of waterfront living at this spectacular Bayfront residence in the heart of Merrick Estates. Perfectly positioned along the bay, 2959 Shore Road offers an extraordinary lifestyle defined by panoramic water views, seamless indoor-outdoor living, and exceptional boating amenities.\n Set on a prime waterfront parcel, this meticulously maintained high ranch boasts approximately 3,400 square feet of living space, featuring 4 bedrooms and 3 full bathrooms. The home’s thoughtful layout is designed for both everyday comfort and elevated entertaining.\n \n For boating enthusiasts, this property is unmatched, offering a 65-foot pier, boat lift, floating dock, and direct stair access to the beach—delivering the ultimate waterfront lifestyle.\n \n The main level welcomes you with a spacious family room highlighted by a gas fireplace, a full bathroom, dedicated office, bedroom, and laundry room. This level also provides direct access to a stunning indoor pool area, where glass sliding doors open to a beautifully designed paver patio—creating a private retreat that effortlessly blends indoor and outdoor living.\n \n Upstairs, the second level showcases an expansive and sun-drenched living space. A gracious living room, formal dining area, and large open-concept kitchen with breakfast area flow seamlessly into an additional family room. The entire rear of the home is framed by soaring ceilings and dramatic picture windows, capturing breathtaking, unobstructed views of the bay—truly priceless. A private balcony off the kitchen further enhances the experience, offering the perfect setting to enjoy morning coffee or evening sunsets over the water.\n \n The bedroom quarters include two additional bedrooms and a full bathroom, along with a luxurious primary suite featuring a spa-like bathroom complete with a jacuzzi tub.\n \n Additional highlights include a full-house gas generator and a garage ideal for storage.\n \n Ideally located in “Prime Merrick Estates” and just moments from the Merrick Estates Civic Association (MECA), residents enjoy access to a vibrant, members-only lifestyle featuring an Olympic-sized pool, diving board, kiddie pool, sports courts, beach volleyball, playground areas, and a full calendar of social events and activities, themed gatherings, and summer programs—all within a short walk from your front door.\n \n This is a rare opportunity to own a premier waterfront home offering luxury, lifestyle, and location in one of Merrick’s most sought-after communities. """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-224-4600" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-712-8111" +"CoListAgentEmail": "matt@pl-team.com" +"CoListAgentFullName": "Matthew Castor-Nikifor" +"CoListAgentKey": "326229863" +"CoListAgentMlsId": "220909" +"CoListOfficeKey": "326109739" +"CoListOfficeMlsId": "BHHS03" +"CoListOfficeName": "BERKSHIRE HATHAWAY" +"CoListOfficePhone": "516-224-4600" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-24T14:49:54.997588+00:00" +"CumulativeDaysOnMarket": 54 +"DaysOnMarket": 54 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-04-20" +"ExteriorFeatures": array:3 [ …3] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-473-4768" +"ListAgentEmail": "mike@pl-team.com" +"ListAgentKey": "326194012" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109739" +"ListOfficePhone": "516-224-4600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-24" +"LivingAreaSource": "Plans" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.1722 +"LotSizeSquareFeet": 7500 +"MajorChangeTimestamp": "2026-06-17T16:06:36Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-04-24" +"OriginalEntryTimestamp": "2026-04-24T14:47:34Z" +"OriginalListPrice": 2495000 +"OriginatingSystemModificationTimestamp": "2026-06-17T16:06:36Z" +"OtherEquipment": array:1 [ …1] +"OwnerName": "Withheld" +"ParcelNumber": "2089-62-197-00-0036-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-04-24T14:54:36Z" +"PhotosCount": 32 +"PoolFeatures": array:2 [ …2] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PreviousListPrice": 2195000 +"PriceChangeTimestamp": "2026-06-17T16:06:36Z" +"RoomsTotal": "13" +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-712-8111" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-24T14:47:34Z" +"StreetName": "Shore" +"StreetNumber": "2959" +"StreetNumberNumeric": "2959" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "27695" +"TaxBlock": "197" +"TaxLot": "36" +"TaxYear": "2026" +"Utilities": array:6 [ …6] +"View": "Water" +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:1 [ …1] +"WaterfrontYN": true +"KEY_Attic": "Pull Stairs,Storage" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "62" +"KEY_CurrentPrice": "1895000.00" +"KEY_WaterAccessYN": "1" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "3432.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_ShowingContactPhone2": "516-224-4600" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "552.15618" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "11004645.7607" +"KEY_RATIO_CurrentPrice_By_LivingArea": "552.15618" +"KEY_SourceSystemModificationTimestamp": "2026-04-23T19:07:36.073" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "552.15618" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.75952" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "552.15618" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424552837')" +"provider_name": "One Key" +"Media": array:32 [ …32] +"ID": "30982" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5282 +post_id: "31036" +post_author: 1 +"ListingKey": "KEY424549034" +"ListingId": "989914" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-27T16:25:36Z" +"RFModificationTimestamp": "2026-05-27T16:26:55Z" +"ListPrice": 1200000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3334.0 +"BuildingAreaTotal": 3334.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2064 Oliver Way, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.650848 +"Longitude": -73.5415625 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Louise F. Pitlake" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "9038084" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "From the minute you enter the grand foyer you realize this is not your ordinary split level...this is an architectural marvel loaded with every opulent upgrade and amenity you could ever dream of. Spectacularly designer inspired the open plan moves you seamlessly through expansive living and entertaining spaces showcasing the finest in finishes and accessories-dramatic vaulted ceilings add volume to each room while the immense chefs kitchen boasts the most amazing professional suite of appliances and a center island second to none. Three bedrooms include an additional king ensuite with a 5th main level bedroom doubling as a home office. Serenity is everything in this fabulous home and the Hollywood primary features a fireplace, lots of closets and a sprawling spa bath. Add to all this a cozy lounge with tv feature wall, a professional gym plus a finished basement, a private yard with hot tub and patio and fabulous curb appeal and you have a very special home where memories will be made!" +"Appliances": array:10 [ …10] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 4 +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-993-4721" +"BuyerAgentEmail": "mimber@aol.com" +"BuyerAgentFullName": "Marci Imber" +"BuyerAgentKey": "326260685" +"BuyerAgentMlsId": "9070310" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115083" +"BuyerOfficeMlsId": "RLLE02" +"BuyerOfficeName": "Realty Connect USA LLC" +"BuyerOfficePhone": "516-714-3606" +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "631-834-1892" +"CoBuyerAgentEmail": "smdelouya@gmail.com" +"CoBuyerAgentFullName": "Shari M. DeLouya CBR" +"CoBuyerAgentKey": "326119600" +"CoBuyerAgentMlsId": "103104" +"CoBuyerOfficeKey": "326115083" +"CoBuyerOfficeMlsId": "RLLE02" +"CoBuyerOfficeName": "Realty Connect USA LLC" +"CoBuyerOfficePhone": "516-714-3606" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-521-7976" +"CoListAgentEmail": "SPitlake@Elliman.Com" +"CoListAgentFullName": "Seth I. Pitlake SRES" +"CoListAgentKey": "326245944" +"CoListAgentMlsId": "85287" +"CoListOfficeKey": "326110766" +"CoListOfficeMlsId": "DERE28" +"CoListOfficeName": "Douglas Elliman Real Estate" +"CoListOfficePhone": "516-623-4500" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-29T19:49:31.751447+00:00" +"CrossStreet": "Hewlett Avenue" +"CumulativeDaysOnMarket": 26 +"DaysOnMarket": 26 +"Directions": "Hewlett Avenue South To Oliver Way west to home-between hewlett and whaleneck" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"Exclusions": "antique chandelier-check with agents" +"ExpirationDate": "2026-10-23" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:4 [ …4] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": array:2 [ …2] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:16 [ …16] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-297-5260" +"ListAgentEmail": "LPitlake@Elliman.com" +"ListAgentKey": "326258099" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-23" +"ListingTerms": "Cash,Contract,Conventional" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1722 +"LotSizeDimensions": "75x100" +"LotSizeSquareFeet": 7500 +"MajorChangeTimestamp": "2026-05-27T16:23:46Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-25" +"OnMarketDate": "2026-04-29" +"OriginalEntryTimestamp": "2026-04-29T19:40:53Z" +"OriginalListPrice": 1200000 +"OriginatingSystemModificationTimestamp": "2026-05-27T16:23:46Z" +"OtherStructures": array:1 [ …1] +"OwnerName": "Bleistern" +"ParcelNumber": "2089-63-152-00-0052-0" +"ParkingFeatures": array:2 [ …2] +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-04-29T19:34:37Z" +"PhotosCount": 43 +"PostalCity": "Merrick" +"PostalCodePlus4": "5424" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-05-27" +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SpaYN": true +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-27T16:23:46Z" +"StreetName": "Oliver" +"StreetNumber": "2064" +"StreetNumberNumeric": "2064" +"StreetSuffix": "Way" +"SubdivisionName": "South Merrick" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "22600" +"TaxAssessedValue": 735 +"TaxYear": "2026" +"Utilities": array:7 [ …7] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"YearBuiltEffective": 2019 +"KEY_Attic": "Partial" +"KEY_HoldDate": "2026-05-25" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1200000.00" +"KEY_ContractPrice": "1295000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_AdditionalRooms": "Dining Area,Home Office,Library/Den,Media Room" +"KEY_ElectricCompany": "PSEG" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "3334.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "359.92801" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6968641.1150" +"KEY_RATIO_CurrentPrice_By_LivingArea": "359.92801" +"KEY_SourceSystemModificationTimestamp": "2026-04-23T15:41:14.353" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "359.92801" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "359.92801" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424549034')" +"provider_name": "One Key" +"Media": array:43 [ …43] +"ID": "31036" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5286 +post_id: "30959" +post_author: 1 +"ListingKey": "KEY424537798" +"ListingId": "989582" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-12T07:08:40Z" +"RFModificationTimestamp": "2026-05-12T07:11:50Z" +"ListPrice": 729000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1508.0 +"BuildingAreaTotal": 1508.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "5 Argyle Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6594873 +"Longitude": -73.563074 +"YearBuilt": 1937 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Niraj Ghai" +"ListOfficeName": "Rare Holdings LLC" +"ListAgentMlsId": "185820" +"ListOfficeMlsId": "RAHL01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this stunning all-brick Cape Cod nestled in the heart of Merrick, set within one of Long Island's most sought-after school districts. From the moment you arrive, the timeless curb appeal and classic craftsmanship set the tone for everything this exceptional home has to offer. Inside, you'll find a beautifully flowing layout bathed in natural light, anchored by a breathtaking sun room — the perfect retreat for morning coffee or relaxed entertaining year-round. The thoughtful floor plan offers versatility and comfort at every turn, making daily living as effortless as it is elegant. The rear deck extends your living space outdoors, providing an ideal setting for summer gatherings or quiet evenings surrounded by the tranquility of your private backyard. Natural gas throughout ensures efficiency and ease for the seasons ahead. A rare mother-daughter configuration offers incredible flexibility — ideal for extended family, guests, or additional privacy — while the full finished basement with outside separate entrance opens the door to endless possibilities, whether as a recreation space, home office, or private suite. This is Merrick living at its finest — a home where classic character meets modern convenience, all within reach of top-rated schools, local dining, shopping, and the best of the South Shore." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-675-7115" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-675-7115" +"BuyerAgentEmail": "Niraj@myrareholdings.com" +"BuyerAgentFullName": "Niraj Ghai" +"BuyerAgentKey": "326195974" +"BuyerAgentMlsId": "185820" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326114854" +"BuyerOfficeMlsId": "RAHL01" +"BuyerOfficeName": "Rare Holdings LLC" +"BuyerOfficePhone": "516-675-7115" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-23T13:46:21.605453+00:00" +"CumulativeDaysOnMarket": 15 +"DaysOnMarket": 15 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-04-22" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-675-7115" +"ListAgentEmail": "Niraj@myrareholdings.com" +"ListAgentKey": "326195974" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114854" +"ListOfficePhone": "516-675-7115" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2026-04-22" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.1148 +"LotSizeSquareFeet": 5000 +"MajorChangeTimestamp": "2026-05-11T15:57:34Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-11" +"OnMarketDate": "2026-04-23" +"OriginalEntryTimestamp": "2026-04-23T13:42:59Z" +"OriginalListPrice": 729000 +"OriginatingSystemModificationTimestamp": "2026-05-11T15:57:34Z" +"OwnerName": "James Esposito & Theresa Wunner-Esposito" +"ParcelNumber": "2089-55-173-00-0124-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-04-23T13:55:36Z" +"PhotosCount": 31 +"PostalCity": "Merrick" +"PostalCodePlus4": "3706" +"PriceChangeTimestamp": "2026-04-23T13:42:59Z" +"PurchaseContractDate": "2026-05-08" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "917-443-8895" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-11T15:57:34Z" +"StreetName": "Argyle" +"StreetNumber": "5" +"StreetNumberNumeric": "5" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "12567.04" +"TaxAssessedValue": 456 +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Pull Stairs" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "729000.00" +"KEY_ContractPrice": "760000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1508.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "483.42175" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6350174.2160" +"KEY_RATIO_CurrentPrice_By_LivingArea": "483.42175" +"KEY_SourceSystemModificationTimestamp": "2026-04-23T09:42:59.387" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "483.42175" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "483.42175" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424537798')" +"provider_name": "One Key" +"Media": array:31 [ …31] +"ID": "30959" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5284 +post_id: "31082" +post_author: 1 +"ListingKey": "KEY424531975" +"ListingId": "989456" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-10T07:12:39Z" +"RFModificationTimestamp": "2026-05-10T07:16:52Z" +"ListPrice": 999999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2344.0 +"BuildingAreaTotal": 2728.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2039 Ellen Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6468525 +"Longitude": -73.539056 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marci Imber" +"ListOfficeName": "Realty Connect USA LLC" +"ListAgentMlsId": "9070310" +"ListOfficeMlsId": "RLLE02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "The home you have been waiting for. Large Splanch located in South Merrick. Open concept kitchen/dining room which is great for entertaining. New Gas boiler. 200 amp service. Upstairs wood floors under carpet." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "mimber@aol.com" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-698-4372" +"BuyerAgentEmail": "nkatz@signaturepremier.com" +"BuyerAgentFullName": "Nadene J. Katz" +"BuyerAgentKey": "326129248" +"BuyerAgentMlsId": "113424" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115717" +"BuyerOfficeMlsId": "SPH09" +"BuyerOfficeName": "Signature Premier Properties" +"BuyerOfficePhone": "516-546-6300" +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "516-317-1223" +"CoBuyerAgentEmail": "dgerber@signaturepremier.com" +"CoBuyerAgentFullName": "Denise Gerber" +"CoBuyerAgentKey": "326143776" +"CoBuyerAgentMlsId": "129339" +"CoBuyerOfficeKey": "326115717" +"CoBuyerOfficeMlsId": "SPH09" +"CoBuyerOfficeName": "Signature Premier Properties" +"CoBuyerOfficePhone": "516-546-6300" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "631-834-1892" +"CoListAgentEmail": "smdelouya@gmail.com" +"CoListAgentFullName": "Shari M. DeLouya CBR" +"CoListAgentKey": "326119600" +"CoListAgentMlsId": "103104" +"CoListOfficeKey": "326115083" +"CoListOfficeMlsId": "RLLE02" +"CoListOfficeName": "Realty Connect USA LLC" +"CoListOfficePhone": "516-714-3606" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-01T14:03:04.720929+00:00" +"CrossStreet": "Hewlett Avenue" +"CumulativeDaysOnMarket": 7 +"DaysOnMarket": 7 +"Directions": "Hewlett Avenue South left on Ellen" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-11-01" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-993-4721" +"ListAgentEmail": "mimber@aol.com" +"ListAgentKey": "326260685" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115083" +"ListOfficePhone": "516-714-3606" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-01" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-05-10T04:53:25Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-10" +"OnMarketDate": "2026-05-01" +"OriginalEntryTimestamp": "2026-05-01T14:01:02Z" +"OriginalListPrice": 999999 +"OriginatingSystemModificationTimestamp": "2026-05-10T04:53:25Z" +"OwnerName": "Scott Rothman and Ilana Rothman" +"ParcelNumber": "2089-63-283-00-0033-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-01T10:17:36Z" +"PhotosCount": 1 +"PostalCity": "Merrick" +"PostalCodePlus4": "5405" +"PurchaseContractDate": "2026-05-08" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "(855)920-8240" +"ShowingRequirements": array:5 [ …5] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-10T04:53:25Z" +"StreetName": "Ellen" +"StreetNumber": "2039" +"StreetNumberNumeric": "2039" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "20724" +"TaxAssessedValue": 666 +"TaxBlock": "283" +"TaxLot": "33" +"TaxYear": "2026" +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partially Finished" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "63" +"KEY_CurrentPrice": "999999.00" +"KEY_ContractPrice": "1100000.00" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2344.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "426.62073" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7262156.8627" +"KEY_RATIO_CurrentPrice_By_LivingArea": "426.62073" +"KEY_SourceSystemModificationTimestamp": "2026-04-22T19:17:01.313" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "366.56855" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "366.56855" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424531975')" +"provider_name": "One Key" +"Media": array:1 [ …1] +"ID": "31082" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5281 +post_id: "31022" +post_author: 1 +"ListingKey": "KEY424528719" +"ListingId": "989361" +"PropertyType": "Residential" +"PropertySubType": "Manufactured On Land" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-12T07:08:40Z" +"RFModificationTimestamp": "2026-05-12T07:11:51Z" +"ListPrice": 878000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1908.0 +"BuildingAreaTotal": 1908.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2056 Illona Lane, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6462482 +"Longitude": -73.537673 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lisa Pellegrino" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "163208" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this beautiful high ranch home nestled in one of Merrick’s most desirable locations! Set on a generously sized piece of property, this spacious home offers the perfect blend of comfort, style, and convenience.\n ? Features include:\n • 4 spacious bedrooms\n • 3 full bathrooms\n • Bright and airy layout with plenty of natural light\n • Ideal space for extended family or entertaining\n • Large property with endless outdoor possibilities\n Located in a quiet, picturesque neighborhood, this home offers both privacy and easy access to everything Merrick has to offer—parks, shopping, dining, and transportation.\n This is the perfect opportunity to own a stunning home in a truly beautiful setting! """ +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"BathroomsFull": 3 +"BodyType": array:1 [ …1] +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentEmail": "tcelvis1835@aol.com" +"BuyerAgentFullName": "JoAnn Passalacqua" +"BuyerAgentKey": "326251519" +"BuyerAgentMlsId": "9008649" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115553" +"BuyerOfficeMlsId": "SHNE01" +"BuyerOfficeName": "Shane's Anchor Realty Corp" +"BuyerOfficePhone": "516-783-4540" +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-29T00:03:26.730280+00:00" +"CumulativeDaysOnMarket": 13 +"DaysOnMarket": 13 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-30" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-241-7117" +"ListAgentEmail": "Lisa.Pellegrino@Elliman.com" +"ListAgentKey": "326175015" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-22" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-05-11T16:36:56Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-11" +"OnMarketDate": "2026-04-28" +"OriginalEntryTimestamp": "2026-04-28T23:59:31Z" +"OriginalListPrice": 887000 +"OriginatingSystemModificationTimestamp": "2026-05-11T16:36:56Z" +"OwnerName": "Evan Perroncino" +"ParcelNumber": "2089-63-295-00-0012-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-28T23:58:36Z" +"PhotosCount": 20 +"PostalCity": "Merrick" +"PostalCodePlus4": "5427" +"PreviousListPrice": 887000 +"PriceChangeTimestamp": "2026-04-29T11:53:54Z" +"PurchaseContractDate": "2026-05-11" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-241-7117" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-11T16:36:56Z" +"StreetName": "Illona" +"StreetNumber": "2056" +"StreetNumberNumeric": "2056" +"StreetSuffix": "Lane" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "16391.79" +"TaxAssessedValue": 606 +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "878000.00" +"KEY_ContractPrice": "925000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1908.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "460.16771" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6376180.1017" +"KEY_RATIO_CurrentPrice_By_LivingArea": "460.16771" +"KEY_SourceSystemModificationTimestamp": "2026-04-22T16:43:08.163" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "460.16771" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.98985" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "460.16771" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424528719')" +"provider_name": "One Key" +"Media": array:20 [ …20] +"ID": "31022" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5280 +post_id: "30920" +post_author: 1 +"ListingKey": "KEY424499439" +"ListingId": "988586" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-13T07:13:39Z" +"RFModificationTimestamp": "2026-05-13T07:18:24Z" +"ListPrice": 1090000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 2 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2530.0 +"BuildingAreaTotal": 2572.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2137 3rd Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6785891 +"Longitude": -73.5533737 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Xiaomeng C. Zhang PSA" +"ListOfficeName": "Keller Williams Realty Greater" +"ListAgentMlsId": "209845" +"ListOfficeMlsId": "KEWG01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this timeless elegance and exquisite Colonial in one of Merrick’s most desirable neighborhoods, this exceptional Residence offers privacy, scale, and refined living at every turn. Step into the entry welcomes you into sun-filled interiors featuring Generous Living spaces rich hardwood floors and thoughtfully designed spaces ideal for both everyday living and elegant entertaining. The expansive gourmet kitchen with S/S appliances, granite countertops, & custom cabinetry opens seamlessly to a warm family room. The cathedral ceiling upper level features a luxurious primary suite with a spa-like bathroom, separate shower, & walk-in closet. Along with 2 generously sized bedrooms and full size bathroom. All bedrooms are enhanced with custom built-ins closets. Basement offers large family room —creating a perfect retreat for relaxation and recreation. \n \n Additional highlights central air conditioning, gas heat, custom outdoor Kitchen integrated grills and smart lighting, a two-car garage, and driveway parking for up to four vehicles. Relax on the charming front porch or enjoy the beautifully landscaped and Decked Yard, ideal for outdoor gatherings! It is a rare opportunity to own a distinguished home offering exceptional space, comfort, and lifestyle in Merrick. """ +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-873-7100" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "646-552-0887" +"BuyerAgentEmail": "zoe_214@hotmail.com" +"BuyerAgentFullName": "Xiaofen Wu" +"BuyerAgentKey": "326189073" +"BuyerAgentMlsId": "178464" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326116457" +"BuyerOfficeMlsId": "WIN02" +"BuyerOfficeName": "Winzone Realty Inc" +"BuyerOfficePhone": "718-899-7000" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-21T21:41:55.492731+00:00" +"CrossStreet": "Central Ave." +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 16 +"Directions": "Please see Google Map for direction." +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-10-21" +"Fencing": array:1 [ …1] +"Flooring": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:11 [ …11] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-873-7100" +"ListAgentEmail": "zhang@kw.com" +"ListAgentKey": "326219128" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112861" +"ListOfficePhone": "516-873-7100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-21" +"LotSizeAcres": 0.1045 +"LotSizeSquareFeet": 4550 +"MajorChangeTimestamp": "2026-05-12T20:30:58Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-12" +"OnMarketDate": "2026-04-26" +"OriginalEntryTimestamp": "2026-04-21T21:40:26Z" +"OriginalListPrice": 1090000 +"OriginatingSystemModificationTimestamp": "2026-05-12T20:30:58Z" +"OwnerName": "Yin" +"ParcelNumber": "2089-56-074-00-0282-0" +"ParkingFeatures": array:3 [ …3] +"ParkingTotal": "4" +"PatioAndPorchFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-04-26T15:12:36Z" +"PhotosCount": 35 +"PostalCity": "Merrick" +"PostalCodePlus4": "2436" +"PurchaseContractDate": "2026-05-12" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "9176696887" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-12T20:30:58Z" +"StreetName": "3rd" +"StreetNumber": "2137" +"StreetNumberNumeric": "2137" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "16138.81" +"TaxAssessedValue": 676 +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"VirtualTourURLBranded": "https://zhang.kw.com/property/2137-3rd-Avenue-Merrick-NY-11566/2107409716479650" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"KEY_Attic": "See Remarks" +"KEY_TaxSource": "Other" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1090000.00" +"KEY_ContractPrice": "1165000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2530.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "430.83004" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "10430622.0096" +"KEY_RATIO_CurrentPrice_By_LivingArea": "430.83004" +"KEY_SourceSystemModificationTimestamp": "2026-04-21T14:38:36.680" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "423.79471" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "423.79471" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424499439')" +"provider_name": "One Key" +"Media": array:35 [ …35] +"ID": "30920" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5287 +post_id: "30921" +post_author: 1 +"ListingKey": "KEY424494781" +"ListingId": "988420" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-04T18:21:36Z" +"RFModificationTimestamp": "2026-05-04T18:24:28Z" +"ListPrice": 888000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2591.0 +"BuildingAreaTotal": 2591.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1954 Brook Park Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6505165 +"Longitude": -73.5465937 +"YearBuilt": 1953 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "David J. Pastorini CBR" +"ListOfficeName": "Coldwell Banker Phillips" +"ListAgentMlsId": "126201" +"ListOfficeMlsId": "PLPS01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Curb Appeal Galore! Stunning split-level home with both a finished attic and a full finished basement awaits its new owner in the ideal location of South Merrick! Entering the home, you are greeted with an entrance foyer, large formal dining room that opens into the entertainment room/den and spacious living room. Your bright and airy eat in kitchen with tons of counter space provides access to the enormous private fenced in backyard via sliding doors. The upper level of this split-level home features a huge master bedroom with an ensuite full bathroom, a second modern full bathroom, and two additional bedrooms. The attic features the fourth bedroom with a built-in air conditioner, as well as a large living room/sitting area/office/potential bedroom. The basement is finished and provides a laundry area and ample space for storage or additional recreation space. Updates include an updated heating system, updated hot water heater, and a new stove and high hat lighting in the kitchen. Park with ease in your extra-wide private driveway, providing space for 2 cars, side by side, as well as your private 1 car garage. As this home sits on a large 75x110 lot, your private fenced-in backyard oasis has a gas grill hooked up to the home's gas line, so no need to buy or exchange propane tanks anymore! This beautifully maintained South Merrick residence provides an unbeatable location just moments away from the Merrick Bay waterfront and surrounding marinas, parks such as the Norman J. Levy Park and Preserve, providing a scenic space for trails and panoramic water views, golf courses, shopping and restaurant options, the Long Island Railroad, places of worship, as well as zoned for the Merrick School District, with zoning for the award winning John F. Kennedy High School." +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "718-326-3900" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaSource": "Measured" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "718-326-3900" +"BuyerAgentEmail": "ajp957@aol.com" +"BuyerAgentFullName": "Antonio Petsche" +"BuyerAgentKey": "422078930" +"BuyerAgentMlsId": "505262" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326114568" +"BuyerOfficeMlsId": "PLPS01" +"BuyerOfficeName": "Coldwell Banker Phillips" +"BuyerOfficePhone": "718-326-3900" +"CarportSpaces": "2" +"CarportYN": true +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "718-757-5881" +"CoBuyerAgentEmail": "davepastorini@gmail.com" +"CoBuyerAgentFullName": "David J. Pastorini CBR" +"CoBuyerAgentKey": "326140981" +"CoBuyerAgentMlsId": "126201" +"CoBuyerOfficeKey": "326114568" +"CoBuyerOfficeMlsId": "PLPS01" +"CoBuyerOfficeName": "Coldwell Banker Phillips" +"CoBuyerOfficePhone": "718-326-3900" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "718-326-3900" +"CoListAgentEmail": "ajp957@aol.com" +"CoListAgentFullName": "Antonio Petsche" +"CoListAgentKey": "422078930" +"CoListAgentMlsId": "505262" +"CoListOfficeKey": "326114568" +"CoListOfficeMlsId": "PLPS01" +"CoListOfficeName": "Coldwell Banker Phillips" +"CoListOfficePhone": "718-326-3900" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-21T17:57:17.988329+00:00" +"CrossStreet": "Lindenmere Drive" +"CumulativeDaysOnMarket": 9 +"DaysOnMarket": 9 +"Directions": "Waze/Google Maps" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-10-21" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:2 [ …2] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "718-757-5881" +"ListAgentEmail": "davepastorini@gmail.com" +"ListAgentKey": "326140981" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114568" +"ListOfficePhone": "718-326-3900" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-21" +"LivingAreaSource": "Measured" +"LotFeatures": array:4 [ …4] +"LotSizeAcres": 0.1894 +"LotSizeDimensions": "75x110" +"LotSizeSquareFeet": 8250 +"MajorChangeTimestamp": "2026-05-04T18:19:45Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-04" +"OnMarketDate": "2026-04-25" +"OriginalEntryTimestamp": "2026-04-21T17:48:47Z" +"OriginalListPrice": 888000 +"OriginatingSystemModificationTimestamp": "2026-05-04T18:19:45Z" +"OwnerName": "Margolis" +"ParcelNumber": "2089-62-193-00-0003-0" +"ParkingFeatures": array:4 [ …4] +"ParkingTotal": "3" +"PhotosChangeTimestamp": "2026-04-21T17:50:36Z" +"PhotosCount": 32 +"PostalCity": "Merrick" +"PostalCodePlus4": "4606" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-05-04" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "800-746-9464" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-04T18:19:45Z" +"StreetName": "Brook Park" +"StreetNumber": "1954" +"StreetNumberNumeric": "1954" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "21026" +"TaxBlock": "193" +"TaxLot": "3" +"TaxYear": "2026" +"Utilities": array:9 [ …9] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Finished,Full,Stairs,Walkup" +"KEY_Village": "Hempstead" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "62" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "888000.00" +"KEY_ContractPrice": "910000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_DistanceToTrain": "1.30" +"KEY_ElectricCompany": "NYSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2591.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "342.72482" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4688489.9683" +"KEY_RATIO_CurrentPrice_By_LivingArea": "342.72482" +"KEY_SourceSystemModificationTimestamp": "2026-04-21T11:56:59.647" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "342.72482" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "342.72482" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424494781')" +"provider_name": "One Key" +"Media": array:32 [ …32] +"ID": "30921" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5288 +post_id: "30958" +post_author: 1 +"ListingKey": "KEY424489465" +"ListingId": "988283" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-06T16:39:37Z" +"RFModificationTimestamp": "2026-06-06T16:41:56Z" +"ListPrice": 899000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1794.0 +"BuildingAreaTotal": 1794.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1678 Park Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6779686 +"Longitude": -73.5498767 +"YearBuilt": 1967 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Charles Chul Chang CBR" +"ListOfficeName": "Exit Realty Team" +"ListAgentMlsId": "109138" +"ListOfficeMlsId": "CHAC01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this sun-drenched and spacious raised ranch in the heart of North Merrick.\n This well-maintained home offers a bright, open layout with gleaming hardwood floors and a fresh coat of paint throughout. The main level features three bedrooms, a full bathroom, a clean and well-kept eat-in kitchen, a formal dining room, and a generously sized living room. The dining area leads to a deck with a retractable awning, which is perfect for seamless indoor-outdoor entertaining.\n The lower level provides an additional bedroom and flexible space, ideal for a home office, guest suite, or recreation area. Step outside to your private outdoor oasis with a beautifully landscaped backyard.\n Additional highlights include a two-car garage and a prime location close to shopping, dining, parks, and transportation. """ +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "718-358-4000" +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "718-358-4000" +"CoListAgentEmail": "info@exitrealtyteam.com" +"CoListAgentFullName": "Hae Ryung A. Chang" +"CoListAgentKey": "326127243" +"CoListAgentMlsId": "111246" +"CoListOfficeKey": "326110247" +"CoListOfficeMlsId": "CHAC01" +"CoListOfficeName": "Exit Realty Team" +"CoListOfficePhone": "718-358-4000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-23T01:22:28.199046+00:00" +"CrossStreet": "Park Avenue" +"CumulativeDaysOnMarket": 31 +"DaysOnMarket": 42 +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-10-20" +"Fencing": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentEmail": "info@exitrealtyteam.com" +"ListAgentKey": "326125268" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110247" +"ListOfficePhone": "718-358-4000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-22" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1578 +"LotSizeSquareFeet": 6875 +"MajorChangeTimestamp": "2026-05-20T22:31:53Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-05-06" +"OriginalEntryTimestamp": "2026-04-23T01:15:39Z" +"OriginalListPrice": 925000 +"OriginatingSystemModificationTimestamp": "2026-06-06T16:38:31Z" +"OwnerName": "Frieda Scopelitis" +"ParcelNumber": "2089-56-065-00-0231-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "4" +"PhotosChangeTimestamp": "2026-05-05T14:27:36Z" +"PhotosCount": 21 +"PostalCity": "Merrick" +"PostalCodePlus4": "2833" +"PreviousListPrice": 925000 +"PriceChangeTimestamp": "2026-05-20T22:31:53Z" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "718-358-4000" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-06T04:31:25Z" +"StreetName": "Park" +"StreetNumber": "1678" +"StreetNumberNumeric": "1678" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14808" +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"View": "Open" +"VirtualTourURLUnbranded": "https://homediagroup.com/1678-Park-Ave/idx" +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "899000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Coming Soon" +"KEY_ElectricCompany": "PSEG" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "1794.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "501.11483" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5697084.9176" +"KEY_RATIO_CurrentPrice_By_LivingArea": "501.11483" +"KEY_SourceSystemModificationTimestamp": "2026-04-21T08:47:15.290" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "501.11483" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97189" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "501.11483" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424489465')" +"provider_name": "One Key" +"Media": array:21 [ …21] +"ID": "30958" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5289 +post_id: "30972" +post_author: 1 +"ListingKey": "KEY424475760" +"ListingId": "987814" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-08T07:15:40Z" +"RFModificationTimestamp": "2026-05-08T07:17:41Z" +"ListPrice": 1674999.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2706.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1989 Carman Court, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6610897 +"Longitude": -73.5522684 +"YearBuilt": 1951 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tricia Ryan" +"ListOfficeName": "Coldwell Banker American Homes" +"ListAgentMlsId": "196599" +"ListOfficeMlsId": "BRMN04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this stunning custom 4 bedroom Center Hall Colonial, fully renovated in 2016 and ideally located midblock on a quiet cul-de-sac in Merrick’s Lindenmere section, a neighborhood where homes rarely come to market, just under a half mile from the train station. This exceptional home features a grand entry with vaulted ceilings and offers custom moldings, Andersen windows, 4 inch plank wood floors, and solid wood doors throughout. The open concept gourmet kitchen flows seamlessly into the dining area and showcases 2 inch thick marble countertops, a farmhouse sink, custom recessed panel cabinetry, a 6 burner gas cooktop, double wall ovens, a warming drawer, wine bar, beverage refrigerator, and a large center island with additional cabinetry and a built in microwave drawer, all complemented by premium KitchenAid and Miele appliances. The first floor bath is beautifully finished with marble flooring and polished nickel Kohler hardware. Upstairs, you will find four spacious bedrooms with large custom closets, including a luxurious primary suite with vaulted ceilings and two walk in closets. The primary bath features a large rain shower, double vanity, and private water closet, while the additional full bath on the second floor offers a double vanity, marble countertops, and herringbone tile flooring. A convenient second floor laundry room adds to the home’s thoughtful design. The fully finished basement provides additional living space with custom shelving, a full bath, and a separate room perfect for an office or storage, along with a built in dehumidifier. Outside, enjoy a paver patio, expansive yard, lush landscaping, teak fencing, and a 5 zone in ground sprinkler system. Additional highlights include a garage with custom shelving, Navien tankless heating and hot water system, central air, central vacuum, pull down attic, chandelier key lift system, smart blinds, 200 amp electric, Tesla charger, Ring camera, and exterior security camera system. Filled with natural light and finished with exceptional quality throughout, this home offers the perfect blend of luxury, comfort, and everyday functionality." +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-302-8500" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-574-3491" +"BuyerAgentEmail": "kaitlynn.mccartney@compass.com" +"BuyerAgentFullName": "Kaitlynn McCartney" +"BuyerAgentKey": "326222507" +"BuyerAgentMlsId": "213328" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110404" +"BuyerOfficeMlsId": "CMPA07" +"BuyerOfficeName": "Compass Greater NY LLC" +"BuyerOfficePhone": "516-764-6060" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-23T17:24:03.203533+00:00" +"CrossStreet": "Lindenmere" +"CumulativeDaysOnMarket": 14 +"DaysOnMarket": 14 +"Directions": "Eastbound take Southern State Parkway to 22S/Jones Beach. Merge onto Meadowbrook Pkwy to exit M8E. Continue on Sunrise Hwy and turn right onto City Place then left onto City Ave. Turn right on Lindenmere Drive and left on Carman Court." +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-10-23" +"Fencing": array:1 [ …1] +"Flooring": array:1 [ …1] +"GarageSpaces": "1.5" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:16 [ …16] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-567-6422" +"ListAgentEmail": "tryan@cbamhomes.com" +"ListAgentKey": "326206275" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109935" +"ListOfficePhone": "516-302-8500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-23" +"LivingAreaSource": "Plans" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.1719 +"LotSizeSquareFeet": 7490 +"MajorChangeTimestamp": "2026-05-07T13:26:19Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-07" +"OnMarketDate": "2026-04-23" +"OriginalEntryTimestamp": "2026-04-23T17:17:40Z" +"OriginalListPrice": 1674999 +"OriginatingSystemModificationTimestamp": "2026-05-07T13:26:19Z" +"OwnerName": "Kevin R & Jennifer L Hartmann" +"ParcelNumber": "2089-55-047-00-0037-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-04-23T17:20:36Z" +"PhotosCount": 33 +"PostalCity": "Merrick" +"PostalCodePlus4": "4336" +"PurchaseContractDate": "2026-05-07" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-567-6422" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-07T13:26:19Z" +"StreetName": "Carman" +"StreetNumber": "1989" +"StreetNumberNumeric": "1989" +"StreetSuffix": "Court" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "12540" +"TaxAssessedValue": 561 +"TaxYear": "2026" +"Utilities": array:7 [ …7] +"WaterSource": array:1 [ …1] +"YearBuiltEffective": 2016 +"KEY_Attic": "Full,Stairs" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1674999.00" +"KEY_ContractPrice": "1617500.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_DistanceToTrain": "0.40" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2706.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "618.99446" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "9744031.4136" +"KEY_RATIO_CurrentPrice_By_LivingArea": "618.99446" +"KEY_SourceSystemModificationTimestamp": "2026-04-20T12:57:44.233" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424475760')" +"provider_name": "One Key" +"Media": array:33 [ …33] +"ID": "30972" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5290 +post_id: "30970" +post_author: 1 +"ListingKey": "KEY424472455" +"ListingId": "987681" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-12T20:21:36Z" +"RFModificationTimestamp": "2026-05-12T20:23:19Z" +"ListPrice": 1195000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2147.0 +"BuildingAreaTotal": 2147.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2026 Bliss Place, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.647951 +"Longitude": -73.5408014 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Robyn Jacobson Azus" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "210241" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Located in Merrick, this spacious 4 Bedroom, 2.5 Bathroom Colonial offers a thoughtfully designed layout perfect for comfortable living & entertaining. The home features a bright and open floor plan, with gas cooking, central air and highlighted by an open concept kitchen, with elegant formal dining room and expansive living areas! The inviting Den area is a standout, showcasing a striking stone accent wall and a cozy fireplace, while the living room provides plenty of space to enjoy your favorite book or tv show! Upstairs, you’ll find 4 generously sized bedrooms, each with ample closet space. The primary bedroom serves as a retreat, complete with an ensuite bath and oversized closets, with 3 other generously sized bedrooms and a brand new full bathroom! Outside, enjoy your own outdoor oasis, featuring a spacious paved patio and a fully fenced yard, perfect for gatherings, relaxation, and entertaining. Conveniently located near shopping, marinas, the LIRR, and Long Island’s stunning South Shore beaches, this home combines comfort, style, and an unbeatable location! Interior sq footage is approximate." +"Appliances": array:10 [ …10] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"BathroomsFull": 2 +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-721-8316" +"BuyerAgentEmail": "Elaine.Richheimer@elliman.com" +"BuyerAgentFullName": "Elaine Richheimer" +"BuyerAgentKey": "326185145" +"BuyerAgentMlsId": "174177" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110766" +"BuyerOfficeMlsId": "DERE28" +"BuyerOfficeName": "Douglas Elliman Real Estate" +"BuyerOfficePhone": "516-623-4500" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-546-6300" +"CoListAgentEmail": "slevy@signaturepremier.com" +"CoListAgentFullName": "Seth B. Levy" +"CoListAgentKey": "326172773" +"CoListAgentMlsId": "160761" +"CoListOfficeKey": "326115717" +"CoListOfficeMlsId": "SPH09" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "516-546-6300" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-23T16:23:59.693678+00:00" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 16 +"DirectionFaces": "North" +"Disclosures": array:2 [ …2] +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-10-01" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:3 [ …3] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:9 [ …9] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-245-7270" +"ListAgentEmail": "robynazus@gmail.com" +"ListAgentKey": "326219517" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-23" +"LivingAreaSource": "Public Records" +"LotFeatures": array:10 [ …10] +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-05-12T20:19:52Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-09" +"OnMarketDate": "2026-04-23" +"OriginalEntryTimestamp": "2026-04-23T16:22:11Z" +"OriginalListPrice": 1195000 +"OriginatingSystemModificationTimestamp": "2026-05-12T20:19:52Z" +"OwnerName": "Flatow" +"ParcelNumber": "2089-63-156-00-0044-0" +"ParkingFeatures": array:5 [ …5] +"PhotosChangeTimestamp": "2026-04-29T23:59:36Z" +"PhotosCount": 36 +"PostalCity": "Merrick" +"PostalCodePlus4": "5330" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-05-12" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "8" +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-245-7270" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-12T20:19:52Z" +"StreetName": "Bliss" +"StreetNumber": "2026" +"StreetNumberNumeric": "2026" +"StreetSuffix": "Place" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17456" +"TaxAssessedValue": 594 +"TaxLot": "154" +"TaxYear": "2026" +"Utilities": array:10 [ …10] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"KEY_Attic": "Full" +"KEY_HoldDate": "2026-05-09" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "63" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1195000.00" +"KEY_ContractPrice": "1125000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2147.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "556.59059" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8678286.1293" +"KEY_RATIO_CurrentPrice_By_LivingArea": "556.59059" +"KEY_SourceSystemModificationTimestamp": "2026-04-20T11:14:13.680" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "556.59059" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "556.59059" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424472455')" +"provider_name": "One Key" +"Media": array:36 [ …36] +"ID": "30970" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5291 +post_id: "30922" +post_author: 1 +"ListingKey": "KEY424466800" +"ListingId": "987535" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-13T16:46:36Z" +"RFModificationTimestamp": "2026-05-13T16:52:31Z" +"ListPrice": 939000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2068.0 +"BuildingAreaTotal": 2068.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "38 Orchard Street, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6862741 +"Longitude": -73.5597147 +"YearBuilt": 1930 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lisa Adragna" +"ListOfficeName": "Compass Greater NY LLC" +"ListAgentMlsId": "170671" +"ListOfficeMlsId": "CMPA10" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome home to this beautifully expanded, impeccably maintained and renovated home, offering over 2,000 sq ft of versatile, multi-level living space in the heart of Merrick. With 5 bedrooms, 3.5 baths, and a full finished basement with egress, this move-in-ready home has been thoughtfully updated inside and out. The inviting layout showcases a newly renovated kitchen, beautifully updated bathrooms, and a bonus entertainment area complete with a half bath, wine fridge, and additional refrigerator, perfect for seamless indoor-outdoor entertaining. From the charming front porch to the private backyard retreat with gorgeous pavers, every space feels warm, welcoming, and thoughtfully designed. Inside, soaring cathedral ceilings, an open and airy floor plan, and skylights fill the home with natural light. Additional highlights include stainless steel appliances, a garbage disposal, trash compactor, central air, central vacuum, gas heat and cooking, updated electric heat pumps, multiple heating zones, and radiant heat for year-round comfort. The home is complete with stunning hardwood floors and a balcony overlooking the serene backyard, perfect for morning coffee. With its flexible layout and generous living space, this home offers a range of possibilities to suit your needs, all while maintaining a cohesive, polished, and truly move-in-ready feel. Do not miss this opportunity!" +"Appliances": array:10 [ …10] +"ArchitecturalStyle": array:2 [ …2] +"AttributionContact": "516-707-5489" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "HGAR" +"BuyerAgentDirectPhone": "000-000-0000" +"BuyerAgentFullName": "Unrepresented Buyer" +"BuyerAgentKey": "421786246" +"BuyerAgentMlsId": "347752" +"BuyerOfficeAOR": "HGAR" +"BuyerOfficeKey": "1262827" +"BuyerOfficeMlsId": "888888" +"BuyerOfficeName": "Buyer Representation Office" +"BuyerOfficePhone": "000-000-0000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:2 [ …2] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-21T14:43:50.614937+00:00" +"CrossStreet": "Little Whaleneck Rd" +"CumulativeDaysOnMarket": 22 +"DaysOnMarket": 22 +"ElementarySchool": "Old Mill Road School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-10-31" +"Heating": array:3 [ …3] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-707-5489" +"ListAgentEmail": "gemini777128@aol.com" +"ListAgentKey": "326181870" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110407" +"ListOfficePhone": "516-517-4866" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-21" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.0918 +"LotSizeDimensions": "40x100" +"LotSizeSquareFeet": 4000 +"MajorChangeTimestamp": "2026-05-13T16:45:37Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-13" +"OnMarketDate": "2026-04-21" +"OriginalEntryTimestamp": "2026-04-21T14:41:50Z" +"OriginalListPrice": 939000 +"OriginatingSystemModificationTimestamp": "2026-05-13T16:45:37Z" +"OwnerName": "Sabel" +"ParcelNumber": "2089-56-006-00-0090-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-21T15:15:36Z" +"PhotosCount": 48 +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "1608" +"PriceChangeTimestamp": "2026-04-21T14:41:50Z" +"PurchaseContractDate": "2026-05-13" +"RoomsTotal": "12" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-707-5489" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-13T16:45:37Z" +"StreetName": "Orchard" +"StreetNumber": "38" +"StreetNumberNumeric": "38" +"StreetSuffix": "Street" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "16504" +"TaxAssessedValue": 569 +"TaxBlock": "6" +"TaxLot": "90" +"TaxYear": "2025" +"Utilities": array:6 [ …6] +"VirtualTourURLUnbranded": "https://timhillphoto.hd.pics/38-Orchard-St/idx" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Pull Stairs" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "56" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "939000.00" +"KEY_ContractPrice": "985000.00" +"KEY_PreviousStatus": "Active" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2068.00" +"KEY_NumberOfHeatingZones": "7" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "454.06190" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "10228758.1699" +"KEY_RATIO_CurrentPrice_By_LivingArea": "454.06190" +"KEY_SourceSystemModificationTimestamp": "2026-04-19T21:53:46.097" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "454.06190" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "454.06190" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424466800')" +"provider_name": "One Key" +"Media": array:48 [ …48] +"ID": "30922" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5292 +post_id: "30900" +post_author: 1 +"ListingKey": "KEY424459492" +"ListingId": "987310" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-14T07:15:38Z" +"RFModificationTimestamp": "2026-05-14T07:16:04Z" +"ListPrice": 989000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2088.0 +"BuildingAreaTotal": 2088.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2897 Wynsum Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.651426 +"Longitude": -73.537984 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gloria Gallagher" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "189092" +"ListOfficeMlsId": "SPH12" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this beautifully maintained 4 bedroom, 2.5 bath split level home nestled in the highly desirable community of Merrick. Offering a perfect blend of comfort, space and functionality, this home is designed for both everyday living and entertaining. \n \n This light and bright home features warm oakwood flooring flowing throughout the main living area, creating a welcoming and timeless feel. The spacious family den features a cozy wood-burning fireplace, perfect for relaxing evenings. The spacious eat-in-kitchen is perfect for entertaining, offering plenty of room for gathering, meal prep, and casual dining. Designed with an easy, open flow, it provides a seamless walk-through to the dining room, making hosting effortless and keeping everyone connected during meals and celebrations. \n \n The primary suite offers a peaceful retreat with its own en-suite bathroom and a generous walk-in closet. Three additional bedrooms and full bathroom provide ample space for family, guests, or a home office. \n \n Downstairs, enjoy a versatile half-finished basement with added prep kitchenette space, perfect for entertaining, hosting, or extended living needs. A two car garage adds convenience and additional storage. \n \n The expansive deck overlooks the private backyard, an ideal space for entertaining or relaxing. With plenty of room for outdoor dining, lounge seating, and gatherings, it's perfect for hosting summer barbecues or enjoying quiet mornings in a serene setting. \n \n This lovely home is perfectly situated on a beautiful block in the sought after southern Merrick, known for its charm, and close proximity to Wynsum Park and Norman J Levy Park, LIRR, shopping, dining, and within an exemplary school district; let's not forget Jones Beach, making it the total package. Don't miss the opportunity to make this your next home! """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-929-3600" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "HGAR" +"BuyerAgentDirectPhone": "000-000-0000" +"BuyerAgentFullName": "Unrepresented Buyer" +"BuyerAgentKey": "421786246" +"BuyerAgentMlsId": "347752" +"BuyerOfficeAOR": "HGAR" +"BuyerOfficeKey": "1262827" +"BuyerOfficeMlsId": "888888" +"BuyerOfficeName": "Buyer Representation Office" +"BuyerOfficePhone": "000-000-0000" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "631-885-3079" +"CoListAgentEmail": "dgallagher@signaturepremier.com" +"CoListAgentFullName": "Daniel Gallagher" +"CoListAgentKey": "326203141" +"CoListAgentMlsId": "193351" +"CoListOfficeKey": "326115720" +"CoListOfficeMlsId": "SPH12" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "631-929-3600" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-19T12:54:09.530459+00:00" +"CrossStreet": "Merrick Road" +"CumulativeDaysOnMarket": 24 +"DaysOnMarket": 24 +"Directions": "Merrick Road to Wynsum Avenue" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-30" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"Inclusions": "Ping-Pong Table, Weber Grill" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-507-7159" +"ListAgentEmail": "ggallagher@signaturepremier.com" +"ListAgentKey": "326199099" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115720" +"ListOfficePhone": "631-929-3600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-30" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.164 +"LotSizeSquareFeet": 7144 +"MajorChangeTimestamp": "2026-05-13T19:42:45Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-13" +"OnMarketDate": "2026-04-19" +"OriginalEntryTimestamp": "2026-04-19T12:52:26Z" +"OriginalListPrice": 989000 +"OriginatingSystemModificationTimestamp": "2026-05-13T19:42:45Z" +"OwnerName": "Drossman" +"ParcelNumber": "2089-63-131-00-0021-0" +"ParkingFeatures": array:2 [ …2] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-27T18:22:36Z" +"PhotosCount": 31 +"PostalCity": "Merrick" +"PostalCodePlus4": "5412" +"PurchaseContractDate": "2026-05-13" +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-13T19:42:45Z" +"StreetName": "Wynsum" +"StreetNumber": "2897" +"StreetNumberNumeric": "2897" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "20973" +"TaxAssessedValue": 674 +"TaxYear": "2025" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "989000.00" +"KEY_ContractPrice": "999999.00" +"KEY_WaterAccessYN": "0" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2088.00" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "473.65900" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6030487.8049" +"KEY_RATIO_CurrentPrice_By_LivingArea": "473.65900" +"KEY_SourceSystemModificationTimestamp": "2026-04-18T20:31:57.050" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "473.65900" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "473.65900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424459492')" +"provider_name": "One Key" +"Media": array:31 [ …31] +"ID": "30900" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5293 +post_id: "30886" +post_author: 1 +"ListingKey": "KEY424442296" +"ListingId": "986817" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-27T07:05:39Z" +"RFModificationTimestamp": "2026-05-27T07:07:27Z" +"ListPrice": 1249000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2676.0 +"BuildingAreaTotal": 2716.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2794 Covered Bridge Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6472305 +"Longitude": -73.5561769 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Natan Amos" +"ListOfficeName": "Resource Realty Group" +"ListAgentMlsId": "190248" +"ListOfficeMlsId": "DAAR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this stunning and spacious 5-bedroom, 3 full bathroom Hi-Ranch, ideally situated on a quiet residential block in the highly sought-after South Merrick neighborhood. One of the largest model Hi-Ranches available, this home offers approximately 2,700 square feet of living space, providing the perfect blend of comfort, functionality, and modern upgrades.\n \n The upper level features 3 generously sized bedrooms and 2 full bathrooms. The spacious primary suite serves as a private retreat highlighted by vaulted ceilings and an abundance of natural light streaming through the custom windows. Additionally, the primary suite showcases custom closets and an en suite bathroom. \n \n This property also features 2-zone central air conditioning, a 2-car garage, multiple large closets for storage throughout both levels, and a convenient laundry room located on the ground floor.\n \n The oversized eat-in kitchen is the heart of the home, showcasing elegant marble countertops, a large center island, stainless steel appliances, and glass sliding doors with built-in privacy screens leading towards a large trex deck perfect for seamless indoor/outdoor living. A cozy gas fireplace adds warmth and charm to the main living area.\n \n The ground level offers 2 additional bedrooms and 1 full bathroom, ideal for extended guests or flexible living arrangements. One of the bedrooms features a charming wood-burning fireplace, adding character and comfort to the space.\n \n Step outside to a beautifully designed backyard featuring pavers throughout, a semi in-ground heated pool, deck, and gazebo—perfect for entertaining or relaxing in your own private oasis.\n \n This exceptional home truly has it all—size, style, and location. Don’t miss this rare opportunity! """ +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "917-654-9835" +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "347-647-6981" +"BuyerAgentEmail": "jacob@reyeselsamad.com" +"BuyerAgentFullName": "Jacob Poore" +"BuyerAgentKey": "326213470" +"BuyerAgentMlsId": "204019" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115345" +"BuyerOfficeMlsId": "RYS01" +"BuyerOfficeName": "Reyes & Elsamad R E Group" +"BuyerOfficePhone": "212-235-2776" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-17T16:49:52.590173+00:00" +"CumulativeDaysOnMarket": 39 +"DaysOnMarket": 39 +"Directions": "GPS" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-01" +"FireplaceFeatures": array:4 [ …4] +"FireplaceYN": true +"FireplacesTotal": "2" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:16 [ …16] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-341-8471" +"ListAgentEmail": "natanamos@resourcerealtyny.com" +"ListAgentKey": "326200195" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110639" +"ListOfficePhone": "917-654-9835" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-17" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-05-26T21:23:32Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-26" +"OnMarketDate": "2026-04-17" +"OriginalEntryTimestamp": "2026-04-17T16:43:48Z" +"OriginalListPrice": 1249000 +"OriginatingSystemModificationTimestamp": "2026-05-26T21:23:32Z" +"OwnerName": "Goldes" +"ParcelNumber": "2089-62-218-00-0006-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-04-17T16:46:36Z" +"PhotosCount": 39 +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "4817" +"PriceChangeTimestamp": "2026-04-17T16:43:48Z" +"PurchaseContractDate": "2026-05-26" +"RoomsTotal": "14" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-341-8471" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-26T21:23:32Z" +"StreetName": "Covered Bridge" +"StreetNumber": "2794" +"StreetNumberNumeric": "2794" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "16512.02" +"TaxAssessedValue": 662 +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial,Unfinished" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1249000.00" +"KEY_ContractPrice": "1210000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2676.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "466.74141" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "9070442.9920" +"KEY_RATIO_CurrentPrice_By_LivingArea": "466.74141" +"KEY_SourceSystemModificationTimestamp": "2026-04-17T12:43:48.530" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "459.86745" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "459.86745" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424442296')" +"provider_name": "One Key" +"Media": array:39 [ …39] +"ID": "30886" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5294 +post_id: "30849" +post_author: 1 +"ListingKey": "KEY424397149" +"ListingId": "985659" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-21T01:21:36Z" +"RFModificationTimestamp": "2026-05-21T01:25:21Z" +"ListPrice": 845000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1381.0 +"BuildingAreaTotal": 1381.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1580 N Jerusalem Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6976812 +"Longitude": -73.5651968 +"YearBuilt": 1963 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Glenda Moran" +"ListOfficeName": "Progressive Realty Grp USA Inc" +"ListAgentMlsId": "117201" +"ListOfficeMlsId": "PROG02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this beautiful FULLY updated 3 bedroom, 2 bathroom + ranch, on an over size lot, offering designer living throughout!\n This home was redesigned with modern living in mind, it showcases a bright, functional layout enhanced by tastefull upgrades throughout. The stunning fully renovated kitchen serves as the centerpiece of the home, featuring sleek modern cabinetry, high end appliances, gas cooking, and elegant countertops. Designed for both everyday living and stylish entertaining, it is truly a space where form meets function effortlessly. Large living room with high ceilings, a sizeable formal dining room, three well proportioned bedrooms filled with natural light. Gas heating and cooling ensures year round confort, while newer roof just 5 yeas old provides peace of mind. Full finished basement, complete with both side and rear entrances presents exceptional versatility and future potential for the space of your dreams. In addition to a splendid interior, the backyard is just as stunning! Enjoy a private oasis featuring a pave patio, inground sprinklers, mature manicured privacy trees and PVC fencing, perfect for stylish entertaining as well as peacefull relaxation. """ +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-997-9000" +"Basement": array:4 [ …4] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-998-8960" +"BuyerAgentEmail": "stevesh9988@gmail.com" +"BuyerAgentFullName": "Ren Sheng" +"BuyerAgentKey": "326223576" +"BuyerAgentMlsId": "214421" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110273" +"BuyerOfficeMlsId": "CHGL01" +"BuyerOfficeName": "Skylux Realty Inc" +"BuyerOfficePhone": "718-500-2231" +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "516-587-9113" +"CoBuyerAgentEmail": "fei@skyluxny.com" +"CoBuyerAgentFullName": "Fei Guo" +"CoBuyerAgentKey": "326161856" +"CoBuyerAgentMlsId": "149028" +"CoBuyerOfficeKey": "326110273" +"CoBuyerOfficeMlsId": "CHGL01" +"CoBuyerOfficeName": "Skylux Realty Inc" +"CoBuyerOfficePhone": "718-500-2231" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-16T00:39:50.206494+00:00" +"CrossStreet": "Merrick Ave" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 16 +"ElementarySchool": "Harold D Fayette School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-10-15" +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:12 [ …12] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-967-6290" +"ListAgentEmail": "gmoransolutions@gmail.com" +"ListAgentKey": "326132766" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114700" +"ListOfficePhone": "516-997-9000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-15" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.2215 +"LotSizeDimensions": "48" +"LotSizeSquareFeet": 9648 +"MajorChangeTimestamp": "2026-05-02T01:20:47Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-01" +"OnMarketDate": "2026-04-15" +"OriginalEntryTimestamp": "2026-04-16T00:35:24Z" +"OriginalListPrice": 845000 +"OriginatingSystemModificationTimestamp": "2026-05-21T01:19:39Z" +"OwnerName": "Michael Monaco" +"ParcelNumber": "2089-50-347-00-0673-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "4" +"PhotosChangeTimestamp": "2026-04-16T23:20:36Z" +"PhotosCount": 37 +"PostalCity": "Merrick" +"PostalCodePlus4": "1210" +"PurchaseContractDate": "2026-05-01" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5169676290" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-02T01:20:47Z" +"StreetDirPrefix": "N" +"StreetName": "Jerusalem" +"StreetNumber": "1580" +"StreetNumberNumeric": "1580" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14580.66" +"TaxAssessedValue": 525 +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Pull Stairs" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "845000.00" +"KEY_ContractPrice": "880000.00" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalRooms": "Home Office" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1381.00" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "611.87545" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "3814898.4199" +"KEY_RATIO_CurrentPrice_By_LivingArea": "611.87545" +"KEY_SourceSystemModificationTimestamp": "2026-04-15T13:12:47.117" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "611.87545" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "611.87545" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424397149')" +"provider_name": "One Key" +"Media": array:37 [ …37] +"ID": "30849" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5295 +post_id: "30927" +post_author: 1 +"ListingKey": "KEY424353537" +"ListingId": "984469" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-07T16:39:37Z" +"RFModificationTimestamp": "2026-06-07T16:45:08Z" +"ListPrice": 989000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2064.0 +"BuildingAreaTotal": 2064.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2038 Ripley Lane, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.657415 +"Longitude": -73.548648 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Elaine Richheimer" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "174177" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to 2038 Ripley Lane, a stunning split-level home nestled in the heart of the Lindenmere section of Merrick in a wonderful cul-de-sac location. This home offers an inviting blend of comfort, style, and convenience, perfect for those who appreciate quality living.\n Boasting four spacious bedrooms and three bathrooms, this home is designed to accommodate a variety of living arrangements. The primary\n bedroom features an en-suite bathroom for added privacy and convenience. The additional three bedrooms offer ample space and versatility to meet your unique needs. Home has solar panels and central air . The heart of the home, the kitchen, has been updated with sleek granite countertops and is perfectly suited for both everyday living and entertaining. The formal dining room adjacent to the kitchen creates an ideal setting for hosting gatherings and creating lasting memories. The expansive living room, complemented by a den with a vaulted ceiling provides a welcoming atmosphere for relaxation and entertainment. Throughout the home, beautiful hardwood floors add a touch of elegance and warmth.\n Venture downstairs to a roomy basement, a versatile space that can be tailored to your lifestyle. Whether you need a home office, a workout room, or a play area, this space is ready to accommodate your needs. Enjoy those warm days in your backyard for spending time to relax or to soak up the sun.\n The location offers a sense of community and tranquility. Nearby, you will find a variety of shopping and dining options to explore. For those who commute, transportation is conveniently close, making your daily journey that much easier. Trains go to Penn Station and Grand Central and beautiful beaches are just one exit away !\n Don't miss this unique opportunity to own a piece of Merrick's charm. This home offers a blend of style, convenience and comfort. Won't last! Enjoy the lifestyle Merrick has to offer! Must See! """ +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-21T20:55:30.613894+00:00" +"CrossStreet": "Merrick Avenue" +"CumulativeDaysOnMarket": 47 +"DaysOnMarket": 57 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"Exclusions": "To Be Determined" +"ExpirationDate": "2026-10-13" +"Flooring": array:2 [ …2] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-721-8316" +"ListAgentEmail": "Elaine.Richheimer@elliman.com" +"ListAgentKey": "326185145" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-13" +"ListingTerms": "Contract" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1519 +"LotSizeSquareFeet": 6615 +"MajorChangeTimestamp": "2026-04-21T20:48:49Z" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-04-21" +"OriginalEntryTimestamp": "2026-04-21T20:48:49Z" +"OriginalListPrice": 989000 +"OriginatingSystemModificationTimestamp": "2026-06-07T16:38:17Z" +"OwnerName": "David & Melva Novak" +"ParcelNumber": "2089-56-176-00-0222-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-22T20:18:36Z" +"PhotosCount": 22 +"PostalCity": "Merrick" +"PostalCodePlus4": "3929" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-623-4500" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-21T20:48:49Z" +"StreetName": "Ripley" +"StreetNumber": "2038" +"StreetNumberNumeric": "2038" +"StreetSuffix": "Lane" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "21471.76" +"TaxAssessedValue": 690 +"TaxBlock": "176" +"TaxLot": "222" +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Crawl" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "56" +"KEY_CurrentPrice": "989000.00" +"KEY_OpenHouseCount": "1" +"KEY_SolarOwnership": "Owned" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_ShowingTimeFlagYN": "1" +"KEY_LivingAreaSearchSqFt": "2064.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "479.16667" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6510862.4095" +"KEY_RATIO_CurrentPrice_By_LivingArea": "479.16667" +"KEY_SourceSystemModificationTimestamp": "2026-04-13T14:43:24.740" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "479.16667" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "479.16667" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424353537')" +"provider_name": "One Key" +"Media": array:22 [ …22] +"ID": "30927" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5296 +post_id: "31035" +post_author: 1 +"ListingKey": "KEY424343357" +"ListingId": "984171" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-13T20:39:36Z" +"RFModificationTimestamp": "2026-06-13T20:41:01Z" +"ListPrice": 1099000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 2 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2308.0 +"BuildingAreaTotal": 2308.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "26 Maeder Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.678075 +"Longitude": -73.56415 +"YearBuilt": 2004 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nicholas Speirs" …113 } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5297 …144} 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5298 …179} 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5299 …159} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5300 …140} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5301 …155} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5302 …138} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5303 …158} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5304 …169} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5306 …156} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5275 …155} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5274 …168} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5273 …156} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5272 …144} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5271 …120} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5270 …120} ] +success: true +page_size: 32 +page_count: 7 +count: 206 +after_key: "" } "RF Response Time" => "0.15 seconds" ] ]