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=128&$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: "29685" +post_author: 1 +"ListingKey": "KEY423089631" +"ListingId": "947275" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2026-02-26T07:04:38Z" +"RFModificationTimestamp": "2026-02-26T07:08:30Z" +"ListPrice": 979000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2230.0 +"BuildingAreaTotal": 2230.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2415 Babylon Turnpike, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6575157 +"Longitude": -73.5569395 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rodolpho V. Miller" +"ListOfficeName": "Real Broker NY LLC" +"ListAgentMlsId": "130762" +"ListOfficeMlsId": "HOWO09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this stunning Colonial nestled in the heart of Merrick and located in the highly sought-after Merrick School District. This true dream home features 4 bedrooms and 2.5 baths, including 3 large bedrooms and a spacious 4th bedroom, plus a private primary suite with its own master bathroom. The open-concept first floor is filled with natural light and showcases an updated kitchen with modern appliances and a generous living/dining area perfect for entertaining.\n \n Enjoy year-round comfort with central air and the efficiency of solar panels. Additional highlights include a full finished basement, an attached 1-car garage, and a backyard oasis featuring a full legal in-ground pool and newly installed pavers—creating the perfect outdoor living and entertainment space for family gatherings, BBQs, and summer fun.\n \n This beautiful home checks all the boxes: comfort, space, location, and lifestyle. A perfect place to raise your family. This one will not last! """ +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-427-7271" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-12-31T23:19:25.950895+00:00" +"CumulativeDaysOnMarket": 43 +"DaysOnMarket": 43 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-30" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "718-962-4781" +"ListAgentEmail": "info@sellyournyhome.com" +"ListAgentKey": "326145015" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112141" +"ListOfficePhone": "516-427-7271" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-12-31" +"LotSizeAcres": 0.1792 +"LotSizeSquareFeet": 7807 +"MajorChangeTimestamp": "2026-02-25T18:30:52Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Hold" +"OffMarketDate": "2026-02-25" +"OnMarketDate": "2026-01-13" +"OriginalEntryTimestamp": "2025-12-31T23:14:46Z" +"OriginalListPrice": 899999 +"OriginatingSystemModificationTimestamp": "2026-02-25T18:30:52Z" +"OwnerName": "Salvatore & Rose Adela Strano" +"ParcelNumber": "2089-55-138-00-0531-0" +"ParkingFeatures": array:3 [ …3] +"ParkingTotal": "2" +"PhotosChangeTimestamp": "2026-01-13T15:34:36Z" +"PhotosCount": 32 +"PoolFeatures": array:2 [ …2] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "4206" +"PreviousListPrice": 899999 +"PriceChangeTimestamp": "2026-02-05T22:44:53Z" +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "7189624781" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-25T18:30:52Z" +"StreetName": "Babylon" +"StreetNumber": "2415" +"StreetNumberNumeric": "2415" +"StreetSuffix": "Turnpike" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "18850.54" +"TaxAssessedValue": 621 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=1ZnPZAv8Xdo&mls=1" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Crawl" +"KEY_HoldDate": "2026-02-25" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "979000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "0" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "2230.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "439.01345" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5463169.6429" +"KEY_RATIO_CurrentPrice_By_LivingArea": "439.01345" +"KEY_SourceSystemModificationTimestamp": "2025-12-31T14:29:07.870" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "439.01345" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.08778" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "439.01345" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423089631')" +"provider_name": "One Key" +"Media": array:32 [ …32] +"ID": "29685" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5285 +post_id: "29606" +post_author: 1 +"ListingKey": "KEY422996377" +"ListingId": "944739" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-18T10:01:38Z" +"RFModificationTimestamp": "2025-12-18T10:43:41Z" +"ListPrice": 999000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1603.0 +"BuildingAreaTotal": 1603.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "80 Dobson Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6578137 +"Longitude": -73.5617886 +"YearBuilt": 1929 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Afshin Termechi" +"ListOfficeName": "Keller Williams Landmark II" +"ListAgentMlsId": "113751" +"ListOfficeMlsId": "KLRW01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this well-maintained and inviting Charming Cape-style home with Stained Glass Windows, located in the heart of Merrick, Long Island. Offering timeless character and practical living space, this home features **4 generously sized bedrooms and 2 full bathrooms**, ideal for flexible living arrangements.\n \n The main level offers a **sunlit living room with a classic wood burning fireplace**, a **formal dining room** perfect for gatherings, and an **eat-in kitchen** with plenty of room to cook and gather the old-fashioned way.\n \n Downstairs, a **full finished basement with a separate entrance** provides valuable bonus space—perfect for extended family, a home office, or recreation area.\n \n Additional highlights include a **detached one-car garage**, **private driveway**, and a pleasant yard that’s just the right size—easy to maintain, easy to enjoy. """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "347-846-1200" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-12-17T15:34:16.297854+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 182 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-17" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "347-846-1200" +"ListAgentEmail": "afshin@adasells.com" +"ListAgentKey": "326129554" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112906" +"ListOfficePhone": "347-846-1200" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-12-17" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1322 +"LotSizeDimensions": "61 X 102" +"LotSizeSquareFeet": 5760 +"MajorChangeTimestamp": "2025-12-17T15:30:04Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-12-17" +"OriginalEntryTimestamp": "2025-12-17T15:30:04Z" +"OriginalListPrice": 999000 +"OriginatingSystemModificationTimestamp": "2025-12-18T10:00:23Z" +"OwnerName": "Claudette Baran & John Heide" +"ParcelNumber": "2089-55-175-00-0133-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-12-17T15:31:36Z" +"PhotosCount": 21 +"PostalCity": "Merrick" +"PostalCodePlus4": "4136" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "917-972-9597" +"ShowingRequirements": array:6 [ …6] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-12-17T15:30:04Z" +"StreetName": "Dobson" +"StreetNumber": "80" +"StreetNumberNumeric": "80" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15663.29" +"TaxAssessedValue": 516 +"TaxBlock": "175" +"TaxLot": "133" +"TaxYear": "2024" +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Finished,Full,Stairs,Walkup" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "55" +"KEY_CurrentPrice": "999000.00" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "1603.00" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "623.20649" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7556732.2239" +"KEY_RATIO_CurrentPrice_By_LivingArea": "623.20649" +"KEY_SourceSystemModificationTimestamp": "2025-12-17T10:26:57.463" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "623.20649" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "623.20649" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY422996377')" +"provider_name": "One Key" +"Media": array:21 [ …21] +"ID": "29606" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5282 +post_id: "29389" +post_author: 1 +"ListingKey": "KEY422736844" +"ListingId": "937449" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2026-01-28T21:25:36Z" +"RFModificationTimestamp": "2026-01-28T21:29:34Z" +"ListPrice": 1625000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3597.0 +"BuildingAreaTotal": 3597.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "72 Lake End Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6535877 +"Longitude": -73.5469718 +"YearBuilt": 1952 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jan Metri ABR LHC" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "207679" +"ListOfficeMlsId": "DERE03" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Experience North Shore living on the South Shore in this extended custom ranch located on a prestigious street in South Lindenmere. Set on over one-third of an acre, this home offers approximately 3,600 sq. ft. of beautifully designed living space with a stately curb appeal. Enjoy a professionally landscaped property with in-ground sprinklers, a Trex deck, a motorized awning, and a private, secluded backyard with a long driveway—perfect for comfortable, elegant living. Inside, the home offers two primary suites with walk-in closets (including a cedar closet), 3.5 baths, and three-zone central air and heating. The sun-filled granite eat-in kitchen boasts Thermador appliances, two sinks, two dishwashers, a 4-burner stove with grill, a wall oven, a center island, and a spacious breakfast area with electric skylights. Additional highlights include hardwood floors, a banquet-sized formal dining room with French doors, and a grand living room with a mantled fireplace—ideal for entertaining. Fine craftsmanship shines through with Andersen windows, recessed lighting, decorative medallions, and crown moldings throughout. Tesla Charging Station included. Leased Solar Panels.\n With gas heat, guest quarters, a separate water heater, and mint++ condition, this rare find combines space, luxury, and timeless style—a true one-of-a-kind home! """ +"Appliances": array:10 [ …10] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-921-2262" +"BathroomsFull": 3 +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-19T21:28:15.837646+00:00" +"CumulativeDaysOnMarket": 70 +"DaysOnMarket": 70 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-05-30" +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"GreenEnergyGeneration": array:1 [ …1] +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:11 [ …11] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-680-9047" +"ListAgentEmail": "jan.metri@elliman.com" +"ListAgentKey": "326217038" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110753" +"ListOfficePhone": "516-921-2262" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-11-18" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Public Records" +"LotFeatures": array:8 [ …8] +"LotSizeAcres": 0.3843 +"LotSizeDimensions": "106x155" +"LotSizeSquareFeet": 16740 +"MajorChangeTimestamp": "2026-01-28T21:23:37Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Hold" +"OffMarketDate": "2026-01-28" +"OnMarketDate": "2025-11-19" +"OriginalEntryTimestamp": "2025-11-19T21:22:41Z" +"OriginalListPrice": 1625000 +"OriginatingSystemModificationTimestamp": "2026-01-28T21:23:37Z" +"OwnerName": "Karam & Mary F Awad" +"ParcelNumber": "2089-62-027-00-0011-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-11-25T16:07:37Z" +"PhotosCount": 42 +"PostalCity": "Merrick" +"PostalCodePlus4": "4612" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-680-9047" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-28T21:23:37Z" +"StreetName": "Lake End" +"StreetNumber": "72" +"StreetNumberNumeric": "72" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "27532.16" +"TaxAssessedValue": 945 +"TaxBlock": "027" +"TaxLot": "11" +"TaxYear": "2025" +"Utilities": array:2 [ …2] +"VirtualTourURLUnbranded": "https://sites.allmediatours.com/mls/223474276" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial,Pull Stairs" +"KEY_HoldDate": "2026-01-28" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "62" +"KEY_CurrentPrice": "1625000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_SolarOwnership": "Leased" +"KEY_ElectricCompany": "PSEG" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "3597.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "451.76536" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4228467.3432" +"KEY_RATIO_CurrentPrice_By_LivingArea": "451.76536" +"KEY_SourceSystemModificationTimestamp": "2025-11-19T16:09:55.760" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "451.76536" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "451.76536" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY422736844')" +"provider_name": "One Key" +"Media": array:42 [ …42] +"ID": "29389" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5286 +post_id: "29318" +post_author: 1 +"ListingKey": "KEY422630313" +"ListingId": "934389" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-29T23:09:36Z" +"RFModificationTimestamp": "2026-05-29T23:15:37Z" +"ListPrice": 1229000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1634.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2729 Shore Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 1957 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jimmy Amram" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "213013" +"ListOfficeMlsId": "DERE58" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Opportunity Knocks! Welcome to this stunning South Merrick waterfront split, offering a contemporary vibe with an open, airy layout and soaring vaulted ceilings. This sun-drenched home combines modern comfort with casual elegance, featuring an updated eat-in kitchen, cozy den with fireplace, and a bright four-season room perfect for year-round enjoyment. Step outside to your own private oasis—beautifully landscaped grounds with multiple decks, a tranquil koi pond, and deep-water docking just minutes to the open bay. Ideal for the boating or fishing enthusiast, this property truly captures the best of coastal living. Custom windows, skylights, and gleaming hardwood floors enhance the natural light throughout, while sliders provide easy access to all your outdoor entertaining areas. With low taxes, great curb appeal, this home is a rare find. Experience the South Merrick waterfront lifestyle at its finest!" +"Appliances": array:13 [ …13] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-432-3400" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-12T19:22:50.816333+00:00" +"CrossStreet": "George Court" +"CumulativeDaysOnMarket": 198 +"DaysOnMarket": 216 +"Directions": "GPS" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-30" +"ExteriorFeatures": array:2 [ …2] +"FireplaceYN": true +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:15 [ …15] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-244-2466" +"ListAgentEmail": "jimmy.amram@elliman.com" +"ListAgentKey": "326222205" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110783" +"ListOfficePhone": "516-432-3400" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-11-11" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1687 +"LotSizeSquareFeet": 7350 +"MajorChangeTimestamp": "2025-11-12T19:15:36Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-11-12" +"OriginalEntryTimestamp": "2025-11-12T19:15:36Z" +"OriginalListPrice": 1229000 +"OriginatingSystemModificationTimestamp": "2026-05-29T23:07:46Z" +"OwnerName": "Marina Blekh" +"ParcelNumber": "2089-62-197-00-0002-0" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-11-12T19:16:36Z" +"PhotosCount": 32 +"PostalCity": "Merrick" +"PostalCodePlus4": "5218" +"RoomsTotal": "8" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-244-2466" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-11-12T19:15:36Z" +"StreetName": "Shore" +"StreetNumber": "2729" +"StreetNumberNumeric": "2729" +"StreetSuffix": "Drive" +"SubdivisionName": "Merrick Estates" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "20034.41" +"TaxAssessedValue": 717 +"TaxYear": "2024" +"Utilities": array:3 [ …3] +"View": "Water" +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:5 [ …5] +"WaterfrontYN": true +"KEY_Attic": "Partial" +"KEY_Hamlet": "Merrick" +"KEY_Village": "Hempstead" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1229000.00" +"KEY_ElectricCompany": "PSEG" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "0.00" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7285121.5175" +"KEY_SourceSystemModificationTimestamp": "2025-11-10T21:54:47.757" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY422630313')" +"provider_name": "One Key" +"Media": array:32 [ …32] +"ID": "29318" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5284 +post_id: "29278" +post_author: 1 +"ListingKey": "KEY422580639" +"ListingId": "932877" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-01-31T07:06:38Z" +"RFModificationTimestamp": "2026-01-31T07:13:09Z" +"ListPrice": 679000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1226.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "43 Wynsum Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6626707 +"Longitude": -73.5472105 +"YearBuilt": 1927 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Armen H. Caprielian" +"ListOfficeName": "LAFFEY REAL ESTATE" +"ListAgentMlsId": "154032" +"ListOfficeMlsId": "LRE09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to 43 Wynsum Avenue in Merrick! The perfect opportunity for builders, investors, or anyone eager to create their dream home. Ideally situated in a beautiful Merrick neighborhood, this property offers endless potential to customize, expand, or rebuild to your exact vision. Enjoy the convenience of nearby shopping, dining, parks, and public transportation—all just moments from your doorstep. Whether you’re looking to invest or settle down in a welcoming community, this location provides the perfect balance of suburban tranquility and accessibility. Don’t miss your chance this home won’t last!" +"Appliances": array:3 [ …3] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-625-0944" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-528-2630" +"BuyerAgentEmail": "michcerv@aol.com" +"BuyerAgentFullName": "Michelle S. Cervoni CBR" +"BuyerAgentKey": "326211419" +"BuyerAgentMlsId": "201936" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115604" +"BuyerOfficeMlsId": "SJP02" +"BuyerOfficeName": "Stephen Joseph Properties" +"BuyerOfficePhone": "516-809-9288" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-06T19:36:48.985419+00:00" +"CrossStreet": "Sunrise Highway" +"CumulativeDaysOnMarket": 84 +"DaysOnMarket": 84 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-05-06" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-625-0944" +"ListAgentEmail": "acaprielian@laffeyre.com" +"ListAgentKey": "326166571" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113309" +"ListOfficePhone": "516-625-0944" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-11-06" +"ListingTerms": "Contract" +"LivingAreaSource": "Public Records" +"LotFeatures": array:2 [ …2] +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-01-30T18:53:15Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-01-30" +"OnMarketDate": "2025-11-06" +"OriginalEntryTimestamp": "2025-11-06T19:31:53Z" +"OriginalListPrice": 679000 +"OriginatingSystemModificationTimestamp": "2026-01-30T18:53:15Z" +"OwnerName": "Lederman" +"ParcelNumber": "2089-56-182-00-0044-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-11-06T19:33:58Z" +"PhotosCount": 23 +"PostalCity": "Merrick" +"PostalCodePlus4": "4035" +"PurchaseContractDate": "2026-01-29" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "917-767-8545" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-30T18:53:15Z" +"StreetName": "Wynsum" +"StreetNumber": "43" +"StreetNumberNumeric": "43" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14449.05" +"TaxAssessedValue": 476 +"TaxBlock": "182" +"TaxLot": "44" +"TaxYear": "2025" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "56" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "679000.00" +"KEY_ContractPrice": "630000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1226.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-625-0944" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "553.83361" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4931009.4408" +"KEY_RATIO_CurrentPrice_By_LivingArea": "553.83361" +"KEY_SourceSystemModificationTimestamp": "2025-11-06T11:44:20.650" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY422580639')" +"provider_name": "One Key" +"Media": array:23 [ …23] +"ID": "29278" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5281 +post_id: "29266" +post_author: 1 +"ListingKey": "KEY422576414" +"ListingId": "932742" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-01-12T07:05:38Z" +"RFModificationTimestamp": "2026-01-12T07:06:05Z" +"ListPrice": 879000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 2236.0 +"BuildingAreaTotal": 2236.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1911 Carroll Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.670136 +"Longitude": -73.5594145 +"YearBuilt": 1951 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Oakar Reinstein" +"ListOfficeName": "Realty Connect USA L I Inc" +"ListAgentMlsId": "196115" +"ListOfficeMlsId": "RLLE10" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Fully renovated 6-bed, 3-bath home in the heart of Merrick! Brand new inside and out. Premium sidings, black windows, new boiler & mechanical. Features a stunning two-tone kitchen with quartz counters, shaker cabinets & stainless appliances, luxury vinyl floors, and designer bathrooms with modern finishes. Huge primary suite with lounge area & custom walk-in shower. Two bedrooms on main level ideal for guests or extended family. Fenced yard, central air, energy-efficient lighting, and prime location near LIRR, Sunrise Hwy, schools & parks. Literally, they are all less than a mile away. Truly the best priced, move in ready home in or around Merrick! Put this on your MUST SEE LIST!" +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-881-5160" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-837-7558" +"BuyerAgentEmail": "nadav@c21kr.com" +"BuyerAgentFullName": "Nadav Kauderer CBR" +"BuyerAgentKey": "326174840" +"BuyerAgentMlsId": "163016" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326113995" +"BuyerOfficeMlsId": "NATN01" +"BuyerOfficeName": "Century 21 KR Realty" +"BuyerOfficePhone": "516-837-7558" +"CarportSpaces": "1" +"CarportYN": true +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "347-323-9477" +"CoListAgentEmail": "kbudhu@hotmail.com" +"CoListAgentFullName": "Khammath Budhu" +"CoListAgentKey": "326221360" +"CoListAgentMlsId": "212151" +"CoListOfficeKey": "326115091" +"CoListOfficeMlsId": "RLLE10" +"CoListOfficeName": "Realty Connect USA L I Inc" +"CoListOfficePhone": "631-881-5160" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-06T13:02:13.369148+00:00" +"CumulativeDaysOnMarket": 64 +"DaysOnMarket": 64 +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-05-06" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:12 [ …12] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-561-7015" +"ListAgentEmail": "oakar@homesonli.com" +"ListAgentKey": "326205806" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115091" +"ListOfficePhone": "631-881-5160" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-11-06" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.0918 +"LotSizeSquareFeet": 4000 +"MajorChangeTimestamp": "2026-01-12T01:05:48Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-01-11" +"OnMarketDate": "2025-11-06" +"OriginalEntryTimestamp": "2025-11-06T12:56:37Z" +"OriginalListPrice": 879000 +"OriginatingSystemModificationTimestamp": "2026-01-12T01:05:48Z" +"OwnerName": "Sell House Homebuyers Llc" +"ParcelNumber": "2089-55-544-00-0308-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-11-06T12:57:57Z" +"PhotosCount": 35 +"PostalCity": "Merrick" +"PostalCodePlus4": "2624" +"PurchaseContractDate": "2026-01-09" +"RoomsTotal": "12" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-561-7015" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-12T01:05:48Z" +"StreetName": "Carroll" +"StreetNumber": "1911" +"StreetNumberNumeric": "1911" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15669.2" +"TaxAssessedValue": 538 +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "879000.00" +"KEY_ContractPrice": "879000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2236.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "393.11270" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "9575163.3987" +"KEY_RATIO_CurrentPrice_By_LivingArea": "393.11270" +"KEY_SourceSystemModificationTimestamp": "2025-11-06T07:25:27.990" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "393.11270" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "393.11270" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY422576414')" +"provider_name": "One Key" +"Media": array:35 [ …35] +"ID": "29266" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5280 +post_id: "28990" +post_author: 1 +"ListingKey": "KEY422569092" +"ListingId": "932557" +"PropertyType": "Commercial Sale" +"PropertySubType": "Business" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-12-01T07:09:38Z" +"RFModificationTimestamp": "2025-12-01T07:12:11Z" +"ListPrice": 90000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 10000.0 +"LivingArea": 0 +"BuildingAreaTotal": 20083.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2116 Merrick Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6665888 +"Longitude": -73.5534776 +"YearBuilt": 1966 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tanisha Brown" +"ListOfficeName": "EXP Realty" +"ListAgentMlsId": "209293" +"ListOfficeMlsId": "EXP04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Business Listing — ? Metaphysical Crystal Shop for Sale (Merrick, NY) ?\n \n Asking Price: $90,000\n Monthly Rent: $1,200\n Location: Merrick, New York\n Business Type: Retail / Metaphysical & Wellness\n \n Step into a world of light, energy, and abundance with this magical metaphysical crystal boutique in the heart of Merrick, NY! This is more than a business — it’s a spiritual sanctuary that radiates positivity and attracts a loyal community of crystal lovers, healers, and seekers. Whether you’re a seasoned entrepreneur or a passionate soul ready to bring healing energy to others, this turn-key operation offers everything you need to start strong and shine bright!\n \n Key Features\n \n Turn-key & Profitable: Fully furnished, stocked, and beautifully branded — ready for its next enlightened owner.\n \n Gorgeous Ambience: Custom crystal displays, soft lighting, calming music, and an atmosphere that instantly uplifts everyone who walks through the door.\n \n Expansive Inventory: Crystals, stones, tarot decks, candles, incense, jewelry, sage, and more — valued at thousands of dollars.\n \n Community Hotspot: Known locally for hosting full moon circles, sound baths, tarot nights, and manifestation workshops.\n \n Prime Location: Nestled in a high-traffic Merrick plaza near restaurants, boutiques, and wellness studios — endless walk-in potential.\n \n Strong Online Presence: Social media following, e-commerce opportunities, and a loyal returning customer base.\n \n Growth Potential\n \n The possibilities are limitless — expand into online sales, monthly subscription boxes, or pop-up events. Offer private readings, reiki sessions, or holistic coaching. Build collaborations with yoga instructors, therapists, and local businesses to grow your spiritual brand and impact. """ +"AttributionContact": "888-276-0630" +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Jewelry" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-05T20:11:14.017811+00:00" +"CrossStreet": "smith" +"CumulativeDaysOnMarket": 26 +"DaysOnMarket": 26 +"ExpirationDate": "2025-12-01" +"Heating": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "908-906-7125" +"ListAgentEmail": "info@r2rrealestate.com" +"ListAgentKey": "326218597" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111284" +"ListOfficePhone": "888-276-0630" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-11-01" +"LotSizeAcres": 0.2296 +"LotSizeSquareFeet": 10000 +"MajorChangeTimestamp": "2025-12-01T05:10:25Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"OffMarketDate": "2025-12-01" +"OnMarketDate": "2025-11-05" +"OriginalEntryTimestamp": "2025-11-05T20:01:37Z" +"OriginalListPrice": 90000 +"OriginatingSystemModificationTimestamp": "2025-12-01T05:10:25Z" +"OwnerName": "Meita" +"ParcelNumber": "2089-55-113-00-0009-0" +"PhotosChangeTimestamp": "2025-11-05T20:30:00Z" +"PhotosCount": 6 +"PostalCity": "Merrick" +"PriceChangeTimestamp": "2025-11-05T20:01:37Z" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5168055303" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-12-01T05:10:25Z" +"StreetName": "Merrick" +"StreetNumber": "2116" +"StreetNumberNumeric": "2116" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "135237.22" +"TaxAssessedValue": 20869 +"TaxYear": "2024" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_CurrentPrice": "90000.00" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "391986.0627" +"KEY_SourceSystemModificationTimestamp": "2025-11-05T15:01:37.860" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "4.48140" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "4.48140" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY422569092')" +"provider_name": "One Key" +"Media": array:6 [ …6] +"ID": "28990" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5287 +post_id: "28823" +post_author: 1 +"ListingKey": "KEY422510242" +"ListingId": "930825" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-07T22:19:36Z" +"RFModificationTimestamp": "2026-04-07T22:22:05Z" +"ListPrice": 1249000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2273.0 +"BuildingAreaTotal": 2408.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2884 Bay Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.648763 +"Longitude": -73.5442514 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Elaine Richheimer" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "174177" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Dreaming of the summer? Buy your 2026 beautiful waterfront home! Welcome to 2884 Bay Drive, a beautiful residence nestled in the heart of Merrick's coveted Lindenmere Section. This spacious home, situated on a serene dead-end street, offers an abundance of space and tranquility. This property boasts four well appointed bedrooms and 2.5 bathrooms offering ample space for relaxation and comfort and so close to the Great South Bay. An additional large room upstairs provides flexibility for a great home office or a fifth bedroom, ensuring this home can adapt to suit your needs. Enjoy swimming in your semi-inground pool on those warm summer days ahead. Central air and inground sprinklers add to the home's appeal, ensuring comfort and ease of maintenance, A generous 70 feet of bulkhead and a private dock make this home a boater's paradise right in your backyard.\n Wake up each morning to breakfast with a view, as you enjoy the sight of the wide canal just beyond your doorstep. Living here is akin to a permanent vacation, with the beauty of Cammans Pond nearby and the allure of the waterfront at your beck and call.\n This home is conveniently located near a variety of trendy restaurants, shops, and local transportation options with NYC just 45 minutes away by train, ensuring you're never far from the action. Beautiful beaches are just one exit away on the parkway, inviting you to enjoy the sun, surf, and sand whenever the mood strikes. In this vibrant community, there's always something exciting to do and new places to explore. 2884 Bay Drive is the perfect blend of peace and excitement. Discover the joy of waterfront living in a community that truly has it all ! Don't miss this wonderful opportunity to own this great residence! """ +"Appliances": array:9 [ …9] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-680-2184" +"BuyerAgentEmail": "bking@signaturepremier.com" +"BuyerAgentFullName": "Brenda King" +"BuyerAgentKey": "326138029" +"BuyerAgentMlsId": "122895" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115717" +"BuyerOfficeMlsId": "SPH09" +"BuyerOfficeName": "Signature Premier Properties" +"BuyerOfficePhone": "516-546-6300" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-05T17:55:42.072939+00:00" +"CumulativeDaysOnMarket": 152 +"DaysOnMarket": 152 +"DirectionFaces": "East" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-30" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"Flooring": array:3 [ …3] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-721-8316" +"ListAgentEmail": "Elaine.Richheimer@elliman.com" +"ListAgentKey": "326185145" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-10-31" +"ListingTerms": "Contract" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1607 +"LotSizeSquareFeet": 7000 +"MajorChangeTimestamp": "2026-04-07T22:17:45Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-06" +"OnMarketDate": "2025-11-05" +"OriginalEntryTimestamp": "2025-10-31T16:29:36Z" +"OriginalListPrice": 1299000 +"OriginatingSystemModificationTimestamp": "2026-04-07T22:17:45Z" +"OwnerName": "Yong Xiang Li & Jun Ying Weng" +"ParcelNumber": "2089-62-194-00-0059-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-11-26T22:23:36Z" +"PhotosCount": 31 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "4603" +"PreviousListPrice": 1299000 +"PriceChangeTimestamp": "2026-03-13T17:32:08Z" +"PurchaseContractDate": "2026-04-07" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5166234500" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-07T22:17:45Z" +"StreetName": "Bay" +"StreetNumber": "2884" +"StreetNumberNumeric": "2884" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "20942.75" +"TaxAssessedValue": 798 +"TaxBlock": "194" +"TaxLot": "59" +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:5 [ …5] +"WaterfrontYN": true +"KEY_Attic": "None" +"KEY_HoldDate": "2026-04-06" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "4" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1249000.00" +"KEY_ContractPrice": "1200000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Hold" +"KEY_AdditionalRooms": "Home Office" +"KEY_DistanceToTrain": "1.00" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2273.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "5167218316" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "549.49406" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7772246.4219" +"KEY_RATIO_CurrentPrice_By_LivingArea": "549.49406" +"KEY_SourceSystemModificationTimestamp": "2025-10-31T12:29:36.867" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "518.68771" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.96151" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "518.68771" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY422510242')" +"provider_name": "One Key" +"Media": array:31 [ …31] +"ID": "28823" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5288 +post_id: "29337" +post_author: 1 +"ListingKey": "KEY422201928" +"ListingId": "922406" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-01-13T01:21:36Z" +"RFModificationTimestamp": "2026-01-13T01:22:27Z" +"ListPrice": 725000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1531.0 +"BuildingAreaTotal": 1531.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2845 Whaleneck Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6509045 +"Longitude": -73.5427001 +"YearBuilt": 1956 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ellen Fuschillo CBR" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "187771" +"ListOfficeMlsId": "SPH23" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this beautifully maintained split-level home located on one of the most picturesque blocks in South Merrick. This inviting residence features 3 bedrooms and 2.5 baths offering comfort and style throughout. Enjoy hardwood floors, wainscoting details and abundant natural light. The updated kitchen includes brand new stove and dishwasher. Additional highlights include a finished basement as well as full attic for ample storage and a private yard ideal for out door gatherings. Don't miss this opportunity to own a home in one of South Merrick's most desirable neighborhoods!" +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-785-0100" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-603-9215" +"BuyerAgentEmail": "loriscrobe@danielgale.com" +"BuyerAgentFullName": "Loredana V. Scrobe CBR" +"BuyerAgentKey": "326170630" +"BuyerAgentMlsId": "158428" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326111554" +"BuyerOfficeMlsId": "GALE11" +"BuyerOfficeName": "Daniel Gale Sothebys Intl Rlty" +"BuyerOfficePhone": "516-627-4440" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-13T19:50:34.200501+00:00" +"CrossStreet": "Oliver Way" +"CumulativeDaysOnMarket": 37 +"DaysOnMarket": 37 +"Directions": "GPS" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-05-08" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-857-7443" +"ListAgentEmail": "efuschillo@signaturepremier.com" +"ListAgentKey": "326197836" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115731" +"ListOfficePhone": "516-785-0100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-11-12" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1579 +"LotSizeSquareFeet": 6880 +"MajorChangeTimestamp": "2026-01-13T01:20:34Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-01-12" +"OnMarketDate": "2025-11-13" +"OriginalEntryTimestamp": "2025-11-13T19:46:23Z" +"OriginalListPrice": 875000 +"OriginatingSystemModificationTimestamp": "2026-01-13T01:20:34Z" +"OwnerName": "Michael Katz" +"ParcelNumber": "2089-63-151-00-0047-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-11-13T19:47:36Z" +"PhotosCount": 20 +"PostalCity": "Merrick" +"PostalCodePlus4": "5322" +"PreviousListPrice": 875000 +"PriceChangeTimestamp": "2025-12-23T16:59:34Z" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-01-12" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-857-7443" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-13T01:20:34Z" +"StreetName": "Whaleneck" +"StreetNumber": "2845" +"StreetNumberNumeric": "2845" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "18516" +"TaxYear": "2025" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_HoldDate": "2025-11-25" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "725000.00" +"KEY_ContractPrice": "750000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1531.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "473.54670" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4591513.6162" +"KEY_RATIO_CurrentPrice_By_LivingArea": "473.54670" +"KEY_SourceSystemModificationTimestamp": "2025-10-08T14:09:19.453" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "473.54670" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.82857" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "473.54670" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY422201928')" +"provider_name": "One Key" +"Media": array:20 [ …20] +"ID": "29337" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5289 +post_id: "28527" +post_author: 1 +"ListingKey": "KEY422122836" +"ListingId": "920107" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-28T18:20:36Z" +"RFModificationTimestamp": "2026-02-28T18:24:08Z" +"ListPrice": 1588000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3600.0 +"BuildingAreaTotal": 3600.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "526 Park Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6876806 +"Longitude": -73.5488443 +"YearBuilt": 2026 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dennis Arango" +"ListOfficeName": "John Savoretti Realty" +"ListAgentMlsId": "108161" +"ListOfficeMlsId": "JOSV01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "THIS BEAUTIFUL 3600SQFT 5 BEDROOM COLONIAL IS BUILT WITH SO MUCH ATTENTION TO DETAIL AND SO MANY EXTRAS ALREADY ADDED IN. THIS BUILDER OFFERS A PRODUCT THAT IS SECOND TO NONE AND BUILT LIKE THEY ARE GONNA LIVE IN IT. WITH A TREMENDOUS AMOUNT TO OFFER IT IS ADVISABLE TO LOOK AT A MODEL THAT WILL BETTER EXPLAIN ALL THATS INCLUDED. OPEN FLOOR PLAN WITH AN OVERSIZED PROPERTY AND A TWO CAR GARAGE IN THE MERRICK SCHOOL DISTRICT WITH GREAT PROXIMITY TO ALL. PLANS AND SPEC SHEETS AVAILABLE TO VIEW." +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-459-3655" +"Basement": array:3 [ …3] +"BathroomsFull": 4 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-721-7257" +"CoListAgentEmail": "lou.tullo@gmail.com" +"CoListAgentFullName": "Louis M. Tullo" +"CoListAgentKey": "326121137" +"CoListAgentMlsId": "104752" +"CoListOfficeKey": "326112691" +"CoListOfficeMlsId": "JOSV01" +"CoListOfficeName": "John Savoretti Realty" +"CoListOfficePhone": "516-327-6400" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-10-08T21:27:45.203328+00:00" +"CrossStreet": "Central Ave. or Grant Ave." +"CumulativeDaysOnMarket": 129 +"DaysOnMarket": 238 +"DirectionFaces": "West" +"Directions": "Mapquest" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-30" +"ExteriorFeatures": array:3 [ …3] +"Fencing": array:3 [ …3] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:3 [ …3] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:23 [ …23] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ …3] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-459-3655" +"ListAgentEmail": "dennis@dennisarango.com" +"ListAgentKey": "326124339" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112691" +"ListOfficePhone": "516-327-6400" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-10-08" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.202 +"LotSizeDimensions": "80X140" +"LotSizeSquareFeet": 8800 +"MajorChangeTimestamp": "2025-10-22T04:31:07Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-10-22" +"OriginalEntryTimestamp": "2025-10-08T21:22:07Z" +"OriginalListPrice": 1588000 +"OriginatingSystemModificationTimestamp": "2026-02-28T18:18:46Z" +"OwnerName": "Brook-City Developoment Llc" +"ParcelNumber": "2089-56-115-00-0190-0" +"ParkingFeatures": array:4 [ …4] +"ParkingTotal": "6" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-22T13:15:36Z" +"PhotosCount": 9 +"PostalCity": "Merrick" +"PostalCodePlus4": "1825" +"PreviousListPrice": 158888 +"PriceChangeTimestamp": "2025-10-08T21:22:07Z" +"PropertyCondition": array:2 [ …2] +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5167217257" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-10-22T04:31:07Z" +"StreetName": "Park" +"StreetNumber": "526" +"StreetNumberNumeric": "526" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxBlock": "115" +"TaxLot": "190" +"TaxYear": "2026" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:5 [ …5] +"KEY_Attic": "Full,Pull Stairs,Storage" +"KEY_TaxSource": "Other" +"KEY_TaxSection": "56" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1588000.00" +"KEY_PreviousStatus": "Coming Soon" +"KEY_DistanceToTrain": "1.00" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "3600.00" +"KEY_ShowingContactPhone2": "5164593655" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "441.11111" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7861386.1386" +"KEY_RATIO_CurrentPrice_By_LivingArea": "441.11111" +"KEY_SourceSystemModificationTimestamp": "2025-10-02T15:49:17.777" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "441.11111" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "441.11111" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY422122836')" +"provider_name": "One Key" +"Media": array:9 [ …9] +"ID": "28527" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5290 +post_id: "28300" +post_author: 1 +"ListingKey": "KEY421958192" +"ListingId": "915451" +"PropertyType": "Commercial Lease" +"PropertySubType": "Business" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-03-16T07:02:41Z" +"RFModificationTimestamp": "2026-03-16T07:03:36Z" +"ListPrice": 8000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 10416.0 +"LivingArea": 0 +"BuildingAreaTotal": 2300.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2056-2058 Merrick Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6569511 +"Longitude": -73.5484209 +"YearBuilt": 1977 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nicole J. Myrie" +"ListOfficeName": "Coldwell Banker American Homes" +"ListAgentMlsId": "201219" +"ListOfficeMlsId": "BRMN04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to Merrick Road — one of Long Island’s busiest commercial corridors. This property sits front and center, with nonstop visibility to over 100,000 passing vehicles. 2300 square feet of accessible space is available for use with accessible deep freezer and refrigerator, large prep stations, gas range, additional storage and a host of other available equipment.\n \n Location is everything. Just minutes from the Meadowbrook Parkway and Sunrise Highway, you’re instantly connected to the South Shore of Long Island and beyond.\n \n A large on-site lot with 11 spaces makes access effortless for both customers and staff.\n \n The neighborhood? Surrounded by retail, dining and community hubs, this is a prime spot where people live, shop, and gather.\n \n High traffic. Easy access. Strong community presence and great Acai Bowl partner store right next door.\n \n This property checks every box for a business looking to stand out in Nassau County. All legal sources of funds are accepted. """ +"AccessibilityFeatures": array:2 [ …2] +"Appliances": array:5 [ …5] +"AttributionContact": "516-302-8500" +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Butcher" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-410-0565" +"CoListAgentEmail": "michele3459@gmail.com" +"CoListAgentFullName": "Michele S. Mosca" +"CoListAgentKey": "326191785" +"CoListAgentMlsId": "181370" +"CoListOfficeKey": "326109945" +"CoListOfficeMlsId": "BRMN14" +"CoListOfficeName": "Coldwell Banker American Homes" +"CoListOfficePhone": "516-665-2000" +"CommonWalls": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-09-21T13:27:22.899509+00:00" +"CumulativeDaysOnMarket": 176 +"DaysOnMarket": 176 +"Directions": "GOOGLE MAPS" +"ExpirationDate": "2026-03-16" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeasableArea": 2300 +"LeaseAmountFrequency": "Monthly" +"LeaseTerm": "Over 12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "917-757-1677" +"ListAgentEmail": "nmyrie@cbamhomes.com" +"ListAgentKey": "326210728" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109935" +"ListOfficePhone": "516-302-8500" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-09-20" +"LotSizeAcres": 0.2391 +"LotSizeSquareFeet": 10416 +"MajorChangeTimestamp": "2026-03-16T04:11:44Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"NumberOfBuildings": 1 +"OffMarketDate": "2026-03-16" +"OnMarketDate": "2025-09-21" +"OriginalEntryTimestamp": "2025-09-21T13:24:21Z" +"OriginalListPrice": 8000 +"OriginatingSystemModificationTimestamp": "2026-03-16T04:11:44Z" +"OwnerName": "Astino" +"ParcelNumber": "2089-63-135-00-0892-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "11" +"PhotosChangeTimestamp": "2026-02-28T15:11:36Z" +"PhotosCount": 10 +"PostalCity": "Merrick" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "9177571677" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-16T04:11:44Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Merrick" +"StreetNumber": "2056" +"StreetNumberNumeric": "2056" +"StreetSuffix": "Road" +"SyndicateTo": array:3 [ …3] +"TaxAnnualAmount": "25346.75" +"TaxBlock": "135" +"TaxLot": "892" +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"VirtualTourURLUnbranded": "https://2056-merrick-road.mostevephoto.com/set/93a1a086-0871-4883-a617-8165e3b26a82?pgid=93a1a086-0871-4883-a617-8165e3b26a82_86331adf-725d-4064-b2b9-a65f842157bc" +"WaterSource": array:1 [ …1] +"Zoning": "Retail" +"KEY_Hamlet": "Merrick" +"KEY_ElevatorYN": "0" +"KEY_SubleaseYN": "0" +"KEY_TaxSection": "63" +"KEY_UsableArea": "2300.00" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "8000.00" +"KEY_BuildToSuitYN": "1" +"KEY_PermittedUses": "Business,Food Services,Mixed" +"KEY_WaterAccessYN": "0" +"KEY_LeasePriceUnit": "Total" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_SprinklerSystemYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LocationDescription": "Ground Floor" +"KEY_InvestmentPropertyYN": "0" +"KEY_NumberOfHeatingZones": "1" +"KEY_ShowingContactPhone2": "5164100565" +"KEY_MaximumContiguousSqft": "2300" +"KEY_NumberOfResidentialUnits": "0" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "33458.8038" +"KEY_SourceSystemModificationTimestamp": "2025-09-21T07:35:27.920" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "3.47826" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "3.47826" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY421958192')" +"provider_name": "One Key" +"Media": array:10 [ …10] +"ID": "28300" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5291 +post_id: "28130" +post_author: 1 +"ListingKey": "KEY421748680" +"ListingId": "909661" +"PropertyType": "Residential Lease" +"PropertySubType": "Apartment" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-09-25T07:09:39Z" +"RFModificationTimestamp": "2025-09-25T08:19:00Z" +"ListPrice": 3495.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1000.0 +"BuildingAreaTotal": 1993.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1444 Park Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 1984 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jatinder P. Singh" +"ListOfficeName": "LA Rosa Realty New York LLC" +"ListAgentMlsId": "142082" +"ListOfficeMlsId": "BOEH01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Newly Renovated 3-BR / 1-Bath Apartment, Beautiful & updated Kitchen, updated Bath, Nice Floors, Gas cooking, Shared Laundry, Tenant Pays own Utility Bills, very convenient location near Major Hwys, Shopping, LIRR 7 min drive, No Pets, No Smoking, (Income+ Credit Verification Required) Available Immediately." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-942-2003" +"AvailabilityDate": "2025-09-06" +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "917-815-2472" +"CoListAgentEmail": "SWARJOTSELLSHOMES@GMAIL.COM" +"CoListAgentFullName": "Swarjot Singh Gill" +"CoListAgentKey": "326218655" +"CoListAgentMlsId": "209353" +"CoListOfficeKey": "326109880" +"CoListOfficeMlsId": "BOEH01" +"CoListOfficeName": "LA Rosa Realty New York LLC" +"CoListOfficePhone": "516-942-2003" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-09-08T22:16:26.698558+00:00" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 16 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-05" +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "Over 12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-445-1300" +"ListAgentEmail": "Singh Sells NY@gmail.com" +"ListAgentKey": "326155389" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109880" +"ListOfficePhone": "516-942-2003" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-09-05" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1182 +"LotSizeSquareFeet": 5150 +"MajorChangeTimestamp": "2025-09-24T16:34:31Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Hold" +"OffMarketDate": "2025-09-24" +"OnMarketDate": "2025-09-08" +"OriginalEntryTimestamp": "2025-09-08T22:14:14Z" +"OriginalListPrice": 3495 +"OriginatingSystemModificationTimestamp": "2025-09-24T16:34:31Z" +"OwnerName": "Undisclosed" +"ParcelNumber": "2089-56-025-00-0404-0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-09-24T16:35:36Z" +"PhotosCount": 18 +"PostalCity": "Merrick" +"PostalCodePlus4": "1839" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-445-1300" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-09-24T16:34:31Z" +"StreetName": "Park" +"StreetNumber": "1444" +"StreetNumberNumeric": "1444" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"UnitNumber": "2nd FL" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_HoldDate": "2025-09-24" +"KEY_SmokingYN": "0" +"KEY_RentSpreeYN": "1" +"KEY_CurrentPrice": "3495.00" +"KEY_RentSpreeURL": "https://apply.link/10EjFAs" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_SecurityDeposits": "1 Month Rent" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "1000.00" +"KEY_RATIO_ListPrice_By_LivingArea": "3.49500" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "29568.5279" +"KEY_RATIO_CurrentPrice_By_LivingArea": "3.49500" +"KEY_SourceSystemModificationTimestamp": "2025-09-05T22:19:37.637" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.75364" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.75364" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY421748680')" +"provider_name": "One Key" +"Media": array:18 [ …18] +"ID": "28130" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5292 +post_id: "28029" +post_author: 1 +"ListingKey": "KEY421653713" +"ListingId": "907065" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-03T16:50:36Z" +"RFModificationTimestamp": "2026-06-03T16:53:33Z" +"ListPrice": 1299000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2180.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2 Garfield Street, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6754943 +"Longitude": -73.5577305 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gregory J. Masaitis" +"ListOfficeName": "Keller Williams Realty Elite" +"ListAgentMlsId": "171423" +"ListOfficeMlsId": "KWE02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Brand new pre-construction offering in Merrick! Anticipated start in May and completion in July. Magnificent new build with high end appliances, CAC and every detail is carefully completed. Act now and choose your colors, tiles and any detail you want to add. New construction in Merrick is rare so act quickly." +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-795-6900" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-551-7309" +"CoListAgentEmail": "Sdecee@aol.com" +"CoListAgentFullName": "Steven E. DeCillis" +"CoListAgentKey": "326185877" +"CoListAgentMlsId": "174967" +"CoListOfficeKey": "326113000" +"CoListOfficeMlsId": "KWE02" +"CoListOfficeName": "Keller Williams Realty Elite" +"CoListOfficePhone": "516-795-6900" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-30T16:01:54.814519+00:00" +"CrossStreet": "Merrick Avenue" +"CumulativeDaysOnMarket": 277 +"DaysOnMarket": 291 +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-08-30" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-241-4109" +"ListAgentEmail": "greg@masaitisteam.com" +"ListAgentKey": "326182572" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113000" +"ListOfficePhone": "516-795-6900" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-30" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.1148 +"LotSizeSquareFeet": 5000 +"MajorChangeTimestamp": "2025-08-30T16:00:01Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-08-30" +"OriginalEntryTimestamp": "2025-08-30T16:00:01Z" +"OriginalListPrice": 1299000 +"OriginatingSystemModificationTimestamp": "2026-06-03T16:49:05Z" +"OwnerName": "Danie Mascary" +"ParcelNumber": "2089-55-053-00-0025-0" +"PhotosChangeTimestamp": "2026-01-18T18:16:36Z" +"PhotosCount": 3 +"PostalCity": "Merrick" +"PostalCodePlus4": "2623" +"PriceChangeTimestamp": "2025-08-30T16:00:01Z" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-551-7309" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-08-30T16:00:01Z" +"StreetName": "Garfield" +"StreetNumber": "2" +"StreetNumberNumeric": "2" +"StreetSuffix": "Street" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "10947" +"TaxYear": "2025" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1299000.00" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "2180.00" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "595.87156" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "11315331.0105" +"KEY_RATIO_CurrentPrice_By_LivingArea": "595.87156" +"KEY_SourceSystemModificationTimestamp": "2025-08-30T12:00:00.653" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY421653713')" +"provider_name": "One Key" +"Media": array:3 [ …3] +"ID": "28029" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5293 +post_id: "28398" +post_author: 1 +"ListingKey": "KEY421571882" +"ListingId": "904724" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-02-26T07:01:42Z" +"RFModificationTimestamp": "2026-02-26T07:02:41Z" +"ListPrice": 1325000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 3000.0 +"BuildingAreaTotal": 3248.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2998 Joyce Lane, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6434061 +"Longitude": -73.546603 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Richard M. Shane" +"ListOfficeName": "All Island Estates Realty Corp" +"ListAgentMlsId": "198897" +"ListOfficeMlsId": "CBE01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Nestled in the desirable Deep South Merrick, this exceptional home offers luxury and comfort in a non-flood zone setting. The backyard is truly a retreat, featuring a breathtaking in-ground heated saltwater pool, perfect for both relaxation and entertainment. Inside, modern finishes combine with inviting wood floors to create a warm, elegant atmosphere. The house provides 6 bedrooms and a total of 3 baths. The open floor plan is designed with cathedral ceilings throughout the living room. The spacious formal dining room and chef’s kitchen with a large center island are ideal for hosting, while the home also boasts a beautiful gym, full bathroom, office space, and family room with a designer fireplace. The expansive two-car garage provides not only room for vehicles but also extra space for storage and supplies. Don’t miss your chance to own this one-of-a-kind property with all the features you’ve been dreaming of!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-783-5600" +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-319-8363" +"CoListAgentEmail": "sch.t.matthew@gmail.com" +"CoListAgentFullName": "Matthew Scherer" +"CoListAgentKey": "418739773" +"CoListAgentMlsId": "502982" +"CoListOfficeKey": "326115553" +"CoListOfficeMlsId": "SHNE01" +"CoListOfficeName": "Shane's Anchor Realty Corp" +"CoListOfficePhone": "516-783-4540" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-25T18:02:02.709486+00:00" +"CrossStreet": "Shore Drive" +"CumulativeDaysOnMarket": 183 +"DaysOnMarket": 183 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-02-26" +"FireplaceYN": true +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-783-5600" +"ListAgentEmail": "mrsold4@aol.com" +"ListAgentKey": "326208468" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110144" +"ListOfficePhone": "516-783-5600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-25" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.2206 +"LotSizeSquareFeet": 9610 +"MajorChangeTimestamp": "2026-02-26T06:24:19Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2026-02-26" +"OnMarketDate": "2025-08-27" +"OriginalEntryTimestamp": "2025-08-25T17:56:43Z" +"OriginalListPrice": 1448000 +"OriginatingSystemModificationTimestamp": "2026-02-26T06:24:19Z" +"OwnerName": "Reitano" +"ParcelNumber": "2089-62-210-00-0010-0" +"PhotosChangeTimestamp": "2026-02-05T15:44:36Z" +"PhotosCount": 43 +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "5208" +"PreviousListPrice": 1399800 +"PriceChangeTimestamp": "2025-10-23T15:58:32Z" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-783-5600" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-26T06:24:19Z" +"StreetName": "Joyce" +"StreetNumber": "2998" +"StreetNumberNumeric": "2998" +"StreetSuffix": "Lane" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "18941.52" +"TaxYear": "2025" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1325000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "3000.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-783-5600" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "441.66667" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6006346.3282" +"KEY_RATIO_CurrentPrice_By_LivingArea": "441.66667" +"KEY_SourceSystemModificationTimestamp": "2025-08-23T13:14:16.960" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "407.94335" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.91506" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "407.94335" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY421571882')" +"provider_name": "One Key" +"Media": array:43 [ …43] +"ID": "28398" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5294 +post_id: "27946" +post_author: 1 +"ListingKey": "KEY421545063" +"ListingId": "903984" +"PropertyType": "Residential Lease" +"PropertySubType": "Apartment" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-01-04T07:03:37Z" +"RFModificationTimestamp": "2026-01-05T09:12:11Z" +"ListPrice": 2950.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1597.0 +"BuildingAreaTotal": 1597.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": null +"Coordinates": array:2 [ …2] +"Latitude": null +"Longitude": null +"YearBuilt": 1914 +"InternetAddressDisplayYN": false +"FeedTypes": "IDX" +"ListAgentFullName": "Lisa J. DeTurris" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "89375" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "2 Bedrooms, 1 bath, new kitchen, carpeting, large closets (walk-in), parking spot in driveway, top floor with separate entrance, tenant pays gas and electric and the landlord pays heat." +"Appliances": array:3 [ …3] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"AvailabilityDate": "2025-09-01" +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"CarportSpaces": "1" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-21T19:55:06.690669+00:00" +"CrossStreet": "Jefferson" +"CumulativeDaysOnMarket": 135 +"DaysOnMarket": 135 +"Directions": "Merrick Ave to Smith Street to Jefferson to Commonwealth" +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"Exclusions": "gas and electric" +"ExpirationDate": "2026-01-03" +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"Inclusions": "heat" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-477-4723" +"ListAgentEmail": "ldeturris@elliman.com" +"ListAgentKey": "326249313" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-08-21" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1435 +"LotSizeSquareFeet": 6250 +"MajorChangeTimestamp": "2026-01-03T21:07:03Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2026-01-03" +"OnMarketDate": "2025-08-21" +"OriginalEntryTimestamp": "2025-08-21T19:47:23Z" +"OriginalListPrice": 2950 +"OriginatingSystemModificationTimestamp": "2026-01-03T21:07:03Z" +"OwnerName": "Mellilo" +"ParcelNumber": "2089-55-116-00-0287-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-13T13:59:36Z" +"PhotosCount": 14 +"PostalCity": "Merrick" +"PostalCodePlus4": "3430" +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-477-4723" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-03T21:07:03Z" +"StreetName": "Commonwealth" +"StreetNumber": "1924" +"StreetNumberNumeric": "1924" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_Village": "Hempstead" +"KEY_SmokingYN": "0" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "2950.00" +"KEY_WaterAccessYN": "0" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_PermitRequiredYN": "0" +"KEY_SecurityDeposits": "1 month" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "1597.00" +"KEY_RATIO_ListPrice_By_LivingArea": "1.84721" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "20557.4913" +"KEY_RATIO_CurrentPrice_By_LivingArea": "1.84721" +"KEY_SourceSystemModificationTimestamp": "2025-08-21T13:00:35.423" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.84721" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.84721" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY421545063')" +"provider_name": "One Key" +"Media": array:14 [ …14] +"ID": "27946" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5295 +post_id: "27995" +post_author: 1 +"ListingKey": "KEY421525901" +"ListingId": "903457" +"PropertyType": "Commercial Lease" +"PropertySubType": "Business" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-11-21T07:04:39Z" +"RFModificationTimestamp": "2025-11-21T07:07:59Z" +"ListPrice": 1450.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 247.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "25 Merrick Ave Unit 25, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dorothy P. Powell SRES" +"ListOfficeName": "Realty Pros Plus Inc" +"ListAgentMlsId": "173882" +"ListOfficeMlsId": "RLTP01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Large, bright, private office for lease on 2nd floor in prestigious law office building. This office/ flex space, located in the south west wing also offers the addition of a beautiful adjoining client waiting room and private bathroom...with the possibility of two extra small office spaces for your admin/staff. All of this space is contiguous for a cohesive turn-key professional business presence that will surly impress your clients. Use of conference room included along with a receptionist on the first floor with a general waiting room to meet and greet your clients. Conveniently located next to train station and in the heart of Merrick Village with plenty of parking right behind building. This space is perfect for a professional: law, accounting, mortgage professional or similar industry. Note: Additional space use TBD -- inquire within. (1st floor handicap conference room also available for client convenience.)" +"AttributionContact": "516-804-9000" +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Professional/Office" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-491-1775" +"CoListAgentEmail": "realtyprosplus@gmail.com" +"CoListAgentFullName": "Dorothy P. Powell SRES" +"CoListAgentKey": "326184865" +"CoListAgentMlsId": "173882" +"CoListOfficeKey": "326115113" +"CoListOfficeMlsId": "RLTP01" +"CoListOfficeName": "Realty Pros Plus Inc" +"CoListOfficePhone": "516-804-9000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-26T18:17:58.545224+00:00" +"CumulativeDaysOnMarket": 87 +"DaysOnMarket": 87 +"Directions": "Located on the corner of Merrick Ave & Fisher Ave. just north of Sunrise Highway" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2025-11-21" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"Inclusions": "Two Additional Clerical Office Spaces Avail. w/waiting room" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseAmountFrequency": "Monthly" +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-491-1775" +"ListAgentEmail": "realtyprosplus@gmail.com" +"ListAgentKey": "326184865" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115113" +"ListOfficePhone": "516-804-9000" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-08-20" +"MajorChangeTimestamp": "2025-11-21T05:10:34Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"OffMarketDate": "2025-11-21" +"OnMarketDate": "2025-08-26" +"OriginalEntryTimestamp": "2025-08-26T18:12:42Z" +"OriginalListPrice": 1450 +"OriginatingSystemModificationTimestamp": "2025-11-21T05:10:34Z" +"OwnerName": "Krohn, Rosenblum & Rosenblum" +"PhotosChangeTimestamp": "2025-11-21T05:11:36Z" +"PhotosCount": 13 +"PostalCity": "Merrick" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516 868-0808" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-11-21T05:10:34Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Merrick Ave" +"StreetNumber": "25" +"StreetNumberNumeric": "25" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "73000" +"TaxYear": "2025" +"UnitNumber": "25" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_ElevatorYN": "0" +"KEY_SubleaseYN": "0" +"KEY_CurrentPrice": "1450.00" +"KEY_LeasePriceUnit": "Per SqFt" +"KEY_PreviousStatus": "Active" +"KEY_SecurityDeposits": "Yes" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_SourceSystemModificationTimestamp": "2025-08-20T12:29:54.887" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "5.87045" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "5.87045" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY421525901')" +"provider_name": "One Key" +"Media": array:13 [ …13] +"ID": "27995" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5296 +post_id: "27917" +post_author: 1 +"ListingKey": "KEY421423698" +"ListingId": "900653" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-10-02T07:11:39Z" +"RFModificationTimestamp": "2025-10-02T07:15:46Z" +"ListPrice": 899000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2271.0 +"BuildingAreaTotal": 2322.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "11 E Webster Street, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7571587 +"Longitude": -73.5997239 +"YearBuilt": 1938 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Louisa Borriello" +"ListOfficeName": "Charles Rutenberg Realty Inc" +"ListAgentMlsId": "117451" +"ListOfficeMlsId": "CHRU01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Spacious Expanded Cape in North Merrick – Room to Make It Your Own!\n Welcome to this warm and inviting 5-bedroom, 3-bath Expanded Cape, offering over 2,500 sq ft of well-designed living space on a 65 x 100 lot located in North Merrick.\n Step inside to a large living room with a fireplace, a formal dining room with potential for a butler’s pantry, and an oversized eat-in kitchen with sliding doors leading to a spacious covered porch—perfect for entertaining and everyday living.\n The first floor also includes two versatile bedrooms, ideal for a guest suite or home office, and a full bathroom. Upstairs, the expansive primary suite features his and her custom walk-in closets and a luxurious en-suite bath with Jacuzzi tub and separate shower. Two additional oversized bedrooms and a third full bath complete the second level.\n Additional highlights include basement with laundry, in-ground sprinklers, and a spacious backyard ready for your personal touch.\n Make this home with great bones and timeless charm—and with just a few finishing touches, it can truly shine. Whether you’re looking to move right in and update over time or customize to your taste, this home offers space, functionality, and endless potential """ +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "Louisa.Borriello@crrnys.com" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-19T23:36:28.925331+00:00" +"CrossStreet": "Merrick Avenue" +"CumulativeDaysOnMarket": 43 +"DaysOnMarket": 43 +"DirectionFaces": "South" +"Directions": "From Southern State Parkway to Merrick Avenue South, Make Left onto E Webster Street." +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-08-18" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-805-0318" +"ListAgentEmail": "Louisa.Borriello@crrnys.com" +"ListAgentKey": "326132990" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110310" +"ListOfficePhone": "516-575-7500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-19" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.1515 +"LotSizeDimensions": "65 x 100" +"LotSizeSquareFeet": 6500 +"MajorChangeTimestamp": "2025-10-01T18:19:17Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Hold" +"OffMarketDate": "2025-10-01" +"OnMarketDate": "2025-08-19" +"OriginalEntryTimestamp": "2025-08-19T23:32:15Z" +"OriginalListPrice": 950000 +"OriginatingSystemModificationTimestamp": "2025-10-01T18:19:17Z" +"OwnerName": "Hubbard" +"ParcelNumber": "2089-56-073-00-0144-0" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "4" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-10-01T18:20:36Z" +"PhotosCount": 21 +"PostalCity": "Merrick" +"PostalCodePlus4": "2721" +"PreviousListPrice": 950000 +"PriceChangeTimestamp": "2025-09-19T21:37:43Z" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-805-0318" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-10-01T18:19:17Z" +"StreetDirPrefix": "E" +"StreetName": "Webster" +"StreetNumber": "11" +"StreetNumberNumeric": "11" +"StreetSuffix": "Street" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "17694.79" +"TaxAssessedValue": 611 +"TaxBlock": "73" +"TaxLot": "144" +"TaxYear": "2024" +"Utilities": array:3 [ …3] +"VirtualTourURLBranded": "https://my.matterport.com/show/?m=iS268QZTSx6" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Scuttle" +"KEY_HoldDate": "2025-10-01" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "56" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "899000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "2271.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "395.86085" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5933993.3993" +"KEY_RATIO_CurrentPrice_By_LivingArea": "395.86085" +"KEY_SourceSystemModificationTimestamp": "2025-08-12T16:41:43.460" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "387.16624" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.94632" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "387.16624" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY421423698')" +"provider_name": "One Key" +"Media": array:21 [ …21] +"ID": "27917" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5297 +post_id: "27756" +post_author: 1 +"ListingKey": "KEY421339501" +"ListingId": "898317" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-01-02T07:07:37Z" +"RFModificationTimestamp": "2026-01-02T07:10:12Z" +"ListPrice": 1799999.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3600.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "217 Bayview, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.657605 +"Longitude": -73.5457486 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Luis Barreto" +"ListOfficeName": "Compass Greater NY LLC" +"ListAgentMlsId": "219746" +"ListOfficeMlsId": "CMPA07" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Discover modern elegance in this exquisite new construction home located in the beautiful town of Merrick!. This 3400 square foot stunning residence offers 5 spacious bedrooms and 4.5 luxurious bathrooms, providing ample space for comfort and privacy. The home's design features a two-car garage and a versatile basement with a separate entrance, perfect for personalized use. Nestled on an expansive 75 by 150 lot, this property offers a serene setting while being conveniently close to restaurants, LIRR, and vibrant shopping destinations. The heart of this home is the gourmet kitchen, featuring custom cabinetry, a pot filler, a farm sink, and a massive custom quartz island—ideal for entertaining or casual family meals. The primary bedroom offers a tray ceiling with two walk-in closets and a custom bathroom, equipped with double sinks, a stand-up shower, and a soaker tub. With plenty of time to customize every detail to your liking, this home is a rare opportunity to create your dream oasis. Embrace the chance to tailor this elegant modern masterpiece to your unique lifestyle!" +"Appliances": array:9 [ …9] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "917-971-4627" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 4 +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-06T23:04:50.672787+00:00" +"CumulativeDaysOnMarket": 149 +"DaysOnMarket": 149 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-01-02" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:4 [ …4] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:23 [ …23] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ …3] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "917-971-4627" +"ListAgentEmail": "luis.barreto@compass.com" +"ListAgentKey": "326228733" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110404" +"ListOfficePhone": "516-764-6060" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-01" +"LivingAreaSource": "Plans" +"LotSizeDimensions": "75 x 150" +"LotSizeSquareFeet": 11250 +"MajorChangeTimestamp": "2026-01-02T05:11:50Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2026-01-02" +"OnMarketDate": "2025-08-06" +"OriginalEntryTimestamp": "2025-08-06T23:01:19Z" +"OriginalListPrice": 1799999 +"OriginatingSystemModificationTimestamp": "2026-01-02T05:11:50Z" +"OwnerName": "not available" +"PhotosChangeTimestamp": "2025-10-13T18:22:36Z" +"PhotosCount": 4 +"PostalCity": "Merrick" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "13" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-02T05:11:50Z" +"StreetName": "Bayview" +"StreetNumber": "217" +"StreetNumberNumeric": "217" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "4995" +"TaxYear": "2025" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"KEY_Attic": "Full,Pull Stairs,Unfinished" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "1" +"KEY_CurrentPrice": "1799999.00" +"KEY_WaterAccessYN": "0" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "3600.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "499.99972" …7 } 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5298 …135} 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5299 …165} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5300 …108} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5301 …123} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5302 …129} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5303 …151} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5304 …138} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5306 …119} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5275 …153} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5274 …133} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5273 …135} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5272 …125} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5271 …127} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5270 …114} ] +success: true +page_size: 32 +page_count: 7 +count: 206 +after_key: "" } "RF Response Time" => "0.15 seconds" ] ]