Begin your home search journey in Merrick, NY by browsing available listings in one place. This page is dedicated to showcasing current homes for sale, complete with essential details such as property type, Price filter, and zip code search. Whether you’re searching for your first home or your next upgrade, Merrick offers a variety of options to meet your needs. View homes with pools, renovated kitchens, or generous backyard space—all with current pricing and images. Start exploring the Merrick housing market today and filter your search based on your must-have features, budget, and lifestyle goals.
Our simple, step-by-step process ensures a smooth experience for buying new property without any worries or hustle.
Go through the our all listings and find the ideal home that is relevant for your requirements.
Click on the listing you like and then fill out the form to get start with your buying journey.
We guide buyers through offers and agreements to secure the best outcomes.
We handle all paperwork, ensure a smooth closing process, and support you through your next steps.
Our simple, step-by-step process ensures a smooth experience for buying new property without any worries or hustle.
We know Merrick NY street by street — not just by ZIP code. From districts to commute routes, we help you buy smarter based on real neighborhood insight.
You won’t find any sales pressure here. We focus on what works best for you, offering honest input so you can make confident, informed choices.
You won’t be left waiting on answers. We stay connected through every step of the process, so your questions get real replies — not delays.
We tap into local networks to get early access to listings — giving you a head start in a competitive market.
From inspections to paperwork, we manage the chaos so you can focus on the fun part — finding a place you’ll love.
Tight schedule? Need to tour after hours or on weekends? We’re flexible. We work how and when it’s convenient for you.
It’s not just about buying now — we’ll help you choose a home that fits future needs too, like family growth or property value trends.
We’re not here to just close a deal. We look out for your best interest like we would for our own family. Every decision is made with care.
Read what our clients have to say about their experience with us
I highly recommend Kaya Homes if you are looking to buy or sell your home. My home was sold for over ask within 1 week! The process was so simple and easy. Avi had a professional photographer photograph our home and has excellent marketing strategies which led to a speedy transaction. Thank you !!!
Bad Services.
KAYA Homes, and specifically Kamy, is a real estate business with a heart. Before I signed a contract Kamy gave me months of her time, business acumen and understanding. I have bought/sold my homes over many decades. Never have I known a realtor to be so incredibly kind. Everything about how KAYA Homes conduct their business is above reproach.
I had the absolute pleasure of working with Kamy when leasing my new apartment, and I couldn't be happier with the experience! She was fantastic to work with, simplifying the rental process and providing thorough explanations every step of the way. Highly recommend!
This is the third year im using Kaya Homes for my rental, they are very professional. They walk you through everything from start to finish. The owner Kami is awesome!! She is very responsive A+ I highly recommend kaya homes!!
We started our journey with Kaya homes a while back when my husband met Kamy. He knew instantly that we found the right ones to help us with purchasing a new home. Kamy is highly responsive, thoughtful, considerate and very professional on her approach with finding you the right home. We wanted to stay in the area and with such a crazy market, I didn't think it would be possible for us to find our home, but we did. Kamy's reassured us and said we will find your home and we did. Thank you Kamy and also meeting Izzy was a bonus, great family owned business, truly you will not be disappointed. If you are looking to rent, own or sell give them a call.
Absolutely wonderful to work with! I highly suggest if you are looking or selling she is definitely your go to!
Amazing experience with Kaya Homes. She was very helpful and found us our dream home as fast as anyone could wish for!
WOW! Kamy went above and beyond to find us an apartment, my lease was over and I needed to move ASAP and couldn’t find any rentals but when I got in contact with Kamy at Kaya Homes she casted all my worries and stress away. I’ve worked with other realtors in the past which was ok but Kaya Homes over exceeded all of my expectations. Kamy was able to find us a beautiful contemporary apartment in the neighborhood that I appointed and that fit right in our price range within a month we moved in. Kamy is extremely kind, friendly, transparent professional, communicative and easy to reach to answer any of our questions at all times. In addition, since we’ve moved the landlord continues to maintain the apartment beautifully: they provide a cleaning service who comes in to clean inside and outside the complex, landscaper comes weekly, the garbage is pick up 2-3x a week, if there’s ever any issue or something needs fixing they send someone the next day which is a plus because you know they CARE AND APPRECIATE THEIR TENANTS. I recommend Kaya Homes to all my friends & family and to anyone who needs a realtor because they are simply the VERY BEST IN THE BUSINESS. Thank you again Kamy.
I had the pleasure of working on my home selling with Kaya homes and specialty with Kamy Roditi who is a very professional and reliable person. Kamy worked very on my transaction with a fair and quick way and honestly without her my home would not have been sold as fast and for the best possible price as it was. I would highly recomand Kaya homes and Kamy for any Real Estate and business venture, selling and buying Real Estate .
If you are in the market for a new home, I highly recommend going to see Kamy Roditi @ Kaya Homes. She is one of the most knowledgeable realtors I've ever met in the industry hands down. She's honest, trustworthy, responsive and an all around pleasure to work with. She worked diligently to help find the perfect house for my family and smoothly guided me through the process by answering all of my questions thoroughly. Buying a new home can be stressful, but it doesn't have to be if your lucky enough to work with Kamy Roditi. You'll be in good hands, I promise!
I thought about selling my house myself and I’m so glad I didn’t. Kaya Homes was a total blessing for me, the buyers of my home were beyond difficult and they handled every step for me beyond my expectations. They took the stress off of me entirely. I’d highly recommend them to anyone. Thank you again Kaya Homes!!
Highly recommend the team at Kaya Homes. The team is not only knowledgeable but also provides great advice for all real estate needs. Weather your looking to buy, sell, rent or get advice, Kaya homes should be your first call.
array:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=32&$skip=96&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (City eq 'Merrick' or PostalCity eq 'Merrick')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5285 +items: array:32 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5299 +post_id: "26701" +post_author: 1 +"ListingKey": "KEY421289023" +"ListingId": "896750" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-09-25T07:06:41Z" +"RFModificationTimestamp": "2025-09-25T08:50:50Z" +"ListPrice": 1900000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3720.0 +"BuildingAreaTotal": 6429.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "942 Putnam Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6959812 +"Longitude": -73.5600084 +"YearBuilt": 2008 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nathan M. Kamara" +"ListOfficeName": "Keller Williams Realty Greater" +"ListAgentMlsId": "118283" +"ListOfficeMlsId": "KEWG01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This is a massive custom built home on a premier and very wide block in North Merrick. The home boasts 6,429 sqft including the full finished basement and garage. No expense was spared during the construction as it incorporates the highest quality building materials and top end finishes. Once you enter this home you are greeted by a large foyer with 18' ceilings! You immediately notice the open concept floor plan and the astonishing size of every room. The den has a floor to ceiling stone fireplace which flows into the dining room, with its entire wall of sliding glass French doors, that can easily host parties of 30 or more people, which continues to flow into the gourmet kitchen. The kitchen is stunningly vast with its 14' cathedral ceilings, all stainless appliances, granite countertops abound, immense kitchen island, two skylights, and reclaimed real brick wall where each brick was meticulously hand cut prior to being placed one by one. The kitchen has enough seating to easily hold 8 people. There is also a living room, office, unique powder room, mud room on this level with 9' ceilings! All of the tile flooring in the kitchen and dining room are radiant heated. The second floor has four large bedrooms and two full bathrooms, including the primary bedroom and bathroom. In the primary suite, the bedroom is huge with its 11' cathedral ceilings and full wall of windows supplying the space with tons of natural light. The primary bathroom has radiant heated floors, a steam shower, a jacuzzi, and a separate room with the toilet. And the primary walk in closet actually has its own, even larger, walk in closet!! There is also a laundry room on this level to make doing laundry convenient. The full finished basement, with its private outside entrance, sports 9' clear ceiling heights throughout!! Its perfect for entertaining or a space for family members or guests to escape and enjoy! The basement has the second laundry room in the home as well. Now when it comes to entertaining, this back yard is hard to beat. The entire back yard is fenced in and surrounded by lush mature trees, where privacy is paramount! With its paver stone patio, Heated SALT WATER POOL, stone and granite full bar, covered cedar outdoor roof, BBQ station with its natural gas hookup, and additional grass lawn, you will keep everyone and yourself entertained all year long! Some premium extras that are worth noting is a GAF Grand Manor lifetime warranty roof with all copper flashings (Top of the line roof money can buy!), 300 amp electric service!! Automatic elephant pool cover, heated and air-conditioned garage, and more! There are too much extras to list here, so you have to visit this home to see everything that it has to offer!" +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-873-7100" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-873-7100" +"CoListAgentEmail": "zmarszalek@aol.com" +"CoListAgentFullName": "Zyamund Marszalek" +"CoListAgentKey": "326160854" +"CoListAgentMlsId": "147988" +"CoListOfficeKey": "326112861" +"CoListOfficeMlsId": "KEWG01" +"CoListOfficeName": "Keller Williams Realty Greater" +"CoListOfficePhone": "516-873-7100" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-02T20:33:58.051231+00:00" +"CrossStreet": "Linden Pl" +"CumulativeDaysOnMarket": 53 +"DaysOnMarket": 53 +"DirectionFaces": "East" +"ElementarySchool": "Harold D Fayette School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-08-02" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:2 [ …2] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:4 [ …4] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:15 [ …15] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:7 [ …7] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-424-1404" +"ListAgentEmail": "nkamara@kw.com" +"ListAgentKey": "326133752" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112861" +"ListOfficePhone": "516-873-7100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-02" +"LivingAreaSource": "Plans" +"LotFeatures": array:6 [ …6] +"LotSizeAcres": 0.1963 +"LotSizeDimensions": "90 x 95" +"LotSizeSquareFeet": 8550 +"MajorChangeTimestamp": "2025-09-24T16:31:12Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlsStatus": "Hold" +"OffMarketDate": "2025-09-24" +"OnMarketDate": "2025-08-02" +"OriginalEntryTimestamp": "2025-08-02T20:32:00Z" +"OriginalListPrice": 1900000 +"OriginatingSystemModificationTimestamp": "2025-09-24T16:31:12Z" +"OwnerName": "Sampogna" +"ParcelNumber": "2089-50-577-00-0225-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2025-09-24T16:31:52Z" +"PhotosCount": 41 +"PoolFeatures": array:3 [ …3] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "1200" +"PriceChangeTimestamp": "2025-08-02T20:32:00Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-424-1404" +"ShowingRequirements": array:4 [ …4] +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-09-24T16:31:12Z" +"StreetName": "Putnam" +"StreetNumber": "942" +"StreetNumberNumeric": "942" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "22706.67" +"TaxAssessedValue": 838 +"TaxBlock": "577" +"TaxLot": "225" +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"VirtualTourURLBranded": "https://player.vimeo.com/video/1106592250?badge=0&autopause=0&player_id=0&app_id=58479" +"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1106562340?badge=0&autopause=0&player_id=0&app_id=58479" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"KEY_Attic": "None" +"KEY_HoldDate": "2025-09-24" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "50" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1900000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "3720.00" +"KEY_NumberOfHeatingZones": "5" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-455-0960" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "510.75269" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "9679062.6592" +"KEY_RATIO_CurrentPrice_By_LivingArea": "510.75269" +"KEY_SourceSystemModificationTimestamp": "2025-08-02T16:32:00.360" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "295.53585" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "295.53585" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY421289023')" +"provider_name": "One Key" +"Media": array:41 [ …41] +"ID": "26701" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5301 +post_id: "26666" +post_author: 1 +"ListingKey": "KEY421236179" +"ListingId": "895424" +"PropertyType": "Commercial Sale" +"PropertySubType": "Mixed Use" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-11-02T07:08:38Z" +"RFModificationTimestamp": "2025-11-02T07:14:23Z" +"ListPrice": 1150000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2117.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "128 Merrick Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6681054 +"Longitude": -73.5536652 +"YearBuilt": 1900 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kevin Coons" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "180629" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Prime investment or end-user opportunity in the heart of Merrick! This mixed-use property at 128 Merrick Ave, offers three legal apartments with dependable long-term tenants generating $5,225/month. A 750 sq ft office space will be delivered vacant – ideal for owner use or rental income of up to $27,000/year. Private parking lot with 12 spaces. Conveniently located near Merrick Mall, Stop & Shop, CVS, banks and the LIRR. Exceptional exposure on high-traffic Merrick Ave makes this an ideal property for investors or business owner seeking visibility and steady income." +"AttributionContact": "516-546-6300" +"Basement": array:1 [ …1] +"BasementYN": true +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Mixed" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-07-30T20:07:41.324865+00:00" +"CumulativeDaysOnMarket": 95 +"DaysOnMarket": 95 +"DirectionFaces": "West" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2025-11-02" +"Heating": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-641-8466" +"ListAgentEmail": "KCoons Sig Homes@gmail.com" +"ListAgentKey": "326191097" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-07-30" +"MajorChangeTimestamp": "2025-11-02T04:10:42Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"NetOperatingIncome": 41500 +"NumberOfBuildings": 1 +"OffMarketDate": "2025-11-02" +"OnMarketDate": "2025-07-30" +"OperatingExpense": "5500" +"OriginalEntryTimestamp": "2025-07-30T19:50:53Z" +"OriginalListPrice": 1150000 +"OriginatingSystemModificationTimestamp": "2025-11-02T04:10:42Z" +"OwnerName": "LI Property Partners, LLC" +"ParcelNumber": "2089-56-097-0-0017-0" +"ParkingTotal": "12" +"PhotosChangeTimestamp": "2025-11-02T04:12:39Z" +"PhotosCount": 37 +"PostalCity": "Merrick" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-641-8466" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-11-02T04:10:42Z" +"StoriesTotal": "2" +"StreetName": "Merrick" +"StreetNumber": "128" +"StreetNumberNumeric": "128" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15700" +"TaxYear": "2025" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_CurrentPrice": "1150000.00" +"KEY_PermittedUses": "Mixed" +"KEY_PreviousStatus": "Active" +"KEY_IncomeExpenseInfo": "Actual" +"KEY_ShowingTimeFlagYN": "0" +"KEY_TotalExpensesYear": "21200" +"KEY_AnnualRentalIncome": "62700" +"KEY_MlsMajorChangeType": "Expired" +"KEY_SourceSystemModificationTimestamp": "2025-07-30T12:47:22.183" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "543.22154" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "543.22154" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY421236179')" +"provider_name": "One Key" +"Media": array:37 [ …37] +"ID": "26666" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5298 +post_id: "26232" +post_author: 1 +"ListingKey": "KEY420691370" +"ListingId": "880811" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-10-15T07:04:37Z" +"RFModificationTimestamp": "2025-10-15T07:10:11Z" +"ListPrice": 900000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 2385.0 +"BuildingAreaTotal": 2385.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "3214 Monterey Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6392627 +"Longitude": -73.5485585 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Chiarina Loverde" +"ListOfficeName": "HomeSmart Premier Living Rlty" +"ListAgentMlsId": "175008" +"ListOfficeMlsId": "HMSM03" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to Merrick Point!\n This expansive 6-bedroom, 3-bathroom high-range style home offers incredible potential in one of Merrick’s most desirable neighborhoods. With a spacious layout and solid structure, it’s perfect for investors or buyers looking to customize and create their dream home.\n \n Features include large bedrooms, generous living space, and plenty of natural light throughout. The layout offers flexibility and can be converted to a M/D setup with proper permits.\n Ideal for investors or anyone looking to add their personal touch and make it their own\n The property sits on a sizable lot with endless possibilities for renovation, expansion, or reconfiguration.\n \n Conveniently located near shopping, restaurants, and train stations, this home combines space, location, and opportunity.\n Being sold as-is. A rare find with exceptional value—don’t miss it! """ +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-234-7244" +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-06-22T20:26:26.751221+00:00" +"CumulativeDaysOnMarket": 110 +"DaysOnMarket": 110 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-03-18" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-710-2765" +"ListAgentEmail": "chiarina_usa@hotmail.com" +"ListAgentKey": "326185913" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112061" +"ListOfficePhone": "516-234-7244" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-19" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1837 +"LotSizeSquareFeet": 8000 +"MajorChangeTimestamp": "2025-10-14T20:43:26Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Grand Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlsStatus": "Hold" +"OffMarketDate": "2025-10-14" +"OnMarketDate": "2025-06-26" +"OriginalEntryTimestamp": "2025-06-22T20:20:12Z" +"OriginalListPrice": 900000 +"OriginatingSystemModificationTimestamp": "2025-10-14T20:43:26Z" +"OwnerName": "Pilitiz/Carpio" +"ParcelNumber": "2089-62-226-00-0018-0" +"PhotosChangeTimestamp": "2025-10-14T20:44:36Z" +"PhotosCount": 17 +"PostalCity": "Merrick" +"PostalCodePlus4": "5134" +"PriceChangeTimestamp": "2025-06-22T20:20:12Z" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-710-2765" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-10-14T20:43:26Z" +"StreetName": "Monterey" +"StreetNumber": "3214" +"StreetNumberNumeric": "3214" +"StreetSuffix": "Drive" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "18972.96" +"TaxAssessedValue": 630 +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_HoldDate": "2025-10-14" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "900000.00" +"KEY_PreviousStatus": "Active" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "2385.00" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "377.35849" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4899292.3244" +"KEY_RATIO_CurrentPrice_By_LivingArea": "377.35849" +"KEY_SourceSystemModificationTimestamp": "2025-06-22T16:20:12.167" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "377.35849" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "377.35849" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY420691370')" +"provider_name": "One Key" +"Media": array:17 [ …17] +"ID": "26232" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5302 +post_id: "26213" +post_author: 1 +"ListingKey": "KEY420663520" +"ListingId": "880084" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-07-20T19:09:44Z" +"RFModificationTimestamp": "2025-07-20T19:24:17Z" +"ListPrice": 1525000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3500.0 +"BuildingAreaTotal": 3268.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1660 Bridge Street, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6809105 +"Longitude": -73.570563 +"YearBuilt": 2011 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Matthew Hart" +"ListOfficeName": "World Prop Intl Sea to Sky" +"ListAgentMlsId": "112688" +"ListOfficeMlsId": "WOPR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this exquisite Colonial home in Merrick! Offering five generously sized bedrooms and three full baths, this residence is designed for both comfort and sophistication. Step into the impressive two story foyer, where youll be greeted by custom tilework, wrought iron banisters and a crystal chandelier. The second floor boasts four additional bedrooms including a luxurious primary suite with walk- in closet. Completely custom built, come see it for yourself! Additional features include EV charger, chandelier lift, all blinds and light fixtures to stay." +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-961-4626" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-06-20T02:00:06.905971+00:00" +"CumulativeDaysOnMarket": 112 +"DaysOnMarket": 31 +"ElementarySchool": "Old Mill Road School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2025-07-20" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-961-4626" +"ListAgentEmail": "matthew@wpinewyork.com" +"ListAgentKey": "326128575" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326116516" +"ListOfficePhone": "631-961-4626" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2025-06-19" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.202 +"LotSizeSquareFeet": 8800 +"MajorChangeTimestamp": "2025-07-20T04:10:55Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2025-07-20" +"OnMarketDate": "2025-06-19" +"OriginalEntryTimestamp": "2025-06-20T01:55:31Z" +"OriginalListPrice": 1525000 +"OriginatingSystemModificationTimestamp": "2025-07-20T19:08:23Z" +"OwnerName": "Khalfan" +"ParcelNumber": "2089-55-032-00-0550-0" +"PhotosChangeTimestamp": "2025-06-20T01:56:36Z" +"PhotosCount": 13 +"PostalCity": "Merrick" +"PostalCodePlus4": "1901" +"PriceChangeTimestamp": "2025-06-20T01:55:31Z" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "518-858-2016" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-07-20T04:10:55Z" +"StreetName": "Bridge" +"StreetNumber": "1660" +"StreetNumberNumeric": "1660" +"StreetSuffix": "Street" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "23573.76" +"TaxAssessedValue": 869 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Unfinished" +"KEY_TaxSource": "Other" +"KEY_ConcessionYN": "1" +"KEY_CurrentPrice": "1525000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "3500.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "435.71429" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7549504.9505" +"KEY_RATIO_CurrentPrice_By_LivingArea": "435.71429" +"KEY_SourceSystemModificationTimestamp": "2025-06-19T21:37:26.443" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "466.64627" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "466.64627" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY420663520')" +"provider_name": "One Key" +"Media": array:13 [ …13] +"ID": "26213" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5300 +post_id: "26127" +post_author: 1 +"ListingKey": "KEY420533320" +"ListingId": "876688" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-30T12:38:36Z" +"RFModificationTimestamp": "2026-07-30T12:50:27Z" +"ListPrice": 939000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2087.0 +"BuildingAreaTotal": 2087.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1277 Jerusalem Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6947347 +"Longitude": -73.5727249 +"YearBuilt": 1929 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Alex A. Rubin" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "152725" +"ListOfficeMlsId": "DERE58" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Merrick - Charming and Beautiful Colonial home with relaxing pool featuring living room with a working wood burning fireplace, Chef's kitchen with Viking Gas stove, Miele & KitchenAid appliances, custom kitchen cabinets, formal dining room, office, den with French doors overlooking the heated saltwater pool. 3 bedrooms, 3 Bath. Primary Bedroom suite with a Walk-in closet. Primary bathroom with a powder area and a jacuzzi bathtub. Hard wood floors through-out. Circular driveway for your convenience. Also featuring: inground sprinklers, 2 Zone HVAC/Central AC. 1.5 Car garage. Long Driveway." +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-432-3400" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-286-1453" +"CoListAgentEmail": "mdvorak@elliman.com" +"CoListAgentFullName": "Monika Dvorak" +"CoListAgentKey": "326244914" +"CoListAgentMlsId": "83847" +"CoListOfficeKey": "326110783" +"CoListOfficeMlsId": "DERE58" +"CoListOfficeName": "Douglas Elliman Real Estate" +"CoListOfficePhone": "516-432-3400" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-06-12T18:19:07.431452+00:00" +"CumulativeDaysOnMarket": 400 +"DaysOnMarket": 402 +"Directions": "Merrick Ave, East on Jerusalem Ave" +"Disclosures": array:2 [ …2] +"ElementarySchool": "Harold D Fayette School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-08-31" +"ExteriorFeatures": array:1 [ …1] +"Fencing": 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:6 [ …6] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-236-3924" +"ListAgentEmail": "arubin@elliman.com" +"ListAgentKey": "326165345" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110783" +"ListOfficePhone": "516-432-3400" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-11" +"ListingTerms": "1031 Exchange,Cash,Conventional,FHA,VA" +"LivingAreaSource": "Public Records" +"LotFeatures": array:4 [ …4] +"LotSizeAcres": 0.175 +"LotSizeDimensions": "60x125" +"LotSizeSquareFeet": 7625 +"MajorChangeTimestamp": "2026-06-23T13:21:53Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-06-25" +"OriginalEntryTimestamp": "2025-06-12T18:16:41Z" +"OriginalListPrice": 950000 +"OriginatingSystemModificationTimestamp": "2026-07-30T12:37:35Z" +"OwnerName": "Kopecky" +"ParcelNumber": "2089-50-588-00-0009-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-12-11T15:46:36Z" +"PhotosCount": 22 +"PoolFeatures": array:3 [ …3] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "1310" +"PreviousListPrice": 950000 +"PriceChangeTimestamp": "2026-06-23T13:21:53Z" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516 236 3924" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-06-25T04:30:50Z" +"StreetName": "Jerusalem" +"StreetNumber": "1277" +"StreetNumberNumeric": "1277" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15445.12" +"TaxYear": "2025" +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "939000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Coming Soon" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "2087.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-286-1453" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "449.92813" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5365714.2857" +"KEY_RATIO_CurrentPrice_By_LivingArea": "449.92813" +"KEY_SourceSystemModificationTimestamp": "2025-06-11T21:11:57.473" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "449.92813" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.98842" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "449.92813" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY420533320')" +"provider_name": "One Key" +"Media": array:22 [ …22] +"ID": "26127" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5297 +post_id: "26043" +post_author: 1 +"ListingKey": "KEY420475663" +"ListingId": "874899" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2026-02-27T07:01:39Z" +"RFModificationTimestamp": "2026-02-27T07:04:35Z" +"ListPrice": 890000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2000.0 +"BuildingAreaTotal": 2788.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1938 Meadowbrook Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6692845 +"Longitude": -73.5672745 +"YearBuilt": 1838 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Cindy O Brien CBR" +"ListOfficeName": "Realty Connect USA LLC" +"ListAgentMlsId": "9024075" +"ListOfficeMlsId": "RLLE02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Beautiful Extra-Large Renovated Colonial in the heart of Merrick. Partially Finished Basement, Attic, Driveway or 4 Cars, Huge Garage for addition 4 Cars, 34'x34' in size. This 2 Story Vintage House in a 1/2 acre of Property, Roof is only 10 years old, Electric is 200 AMP, French Drain System, most all upgrades are from 2003, No CO's. for a couple of additions to the house. Close to Parkway, Schools, Shopping. Too much to List. A Must to see!\n Motivated Seller! """ +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "cobrien254@yahoo.com" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CarportYN": true +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-06-08T17:48:59.166561+00:00" +"CumulativeDaysOnMarket": 263 +"DaysOnMarket": 263 +"Directions": "WAZE From your Location" +"Disclosures": array:1 [ …1] +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-01" +"Fencing": array:1 [ …1] +"GarageSpaces": "4" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-526-7232" +"ListAgentEmail": "cobrien254@yahoo.com" +"ListAgentKey": "326254426" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115083" +"ListOfficePhone": "516-714-3606" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-08" +"ListingTerms": "Contract" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.314 +"LotSizeDimensions": "71x198" +"LotSizeSquareFeet": 13678 +"MajorChangeTimestamp": "2026-02-27T02:39:00Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Hold" +"OffMarketDate": "2026-02-26" +"OnMarketDate": "2025-06-08" +"OriginalEntryTimestamp": "2025-06-08T17:44:37Z" +"OriginalListPrice": 890 +"OriginatingSystemModificationTimestamp": "2026-02-27T02:39:00Z" +"OwnerName": "Amaruso" +"ParcelNumber": "2089-55-095-00-0361-0" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "8" +"PhotosChangeTimestamp": "2025-10-13T20:08:36Z" +"PhotosCount": 8 +"PostalCity": "Merrick" +"PostalCodePlus4": "2936" +"PreviousListPrice": 890 +"PriceChangeTimestamp": "2025-06-08T19:44:13Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-526-7232" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-27T02:39:00Z" +"StreetName": "Meadowbrook" +"StreetNumber": "1938" +"StreetNumberNumeric": "1938" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15764.97" +"TaxAssessedValue": 604 +"TaxYear": "2023" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_HoldDate": "2026-02-26" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "890000.00" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "2000.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "445.00000" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "2834394.9045" +"KEY_RATIO_CurrentPrice_By_LivingArea": "445.00000" +"KEY_SourceSystemModificationTimestamp": "2025-06-08T13:44:37.807" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "319.22525" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1000.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "319.22525" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY420475663')" +"provider_name": "One Key" +"Media": array:8 [ …8] +"ID": "26043" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5296 +post_id: "26034" +post_author: 1 +"ListingKey": "KEY420465898" +"ListingId": "874651" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-14T07:01:37Z" +"RFModificationTimestamp": "2026-07-14T07:03:11Z" +"ListPrice": 4200.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1280.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1695 Merrick Avenue Unit 1695, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ameet Sikka" +"ListOfficeName": "National Real Estate Agency" +"ListAgentMlsId": "208146" +"ListOfficeMlsId": "NTLR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this newly renovated, first floor professional office space in a charming brick building located in the heart of North Merrick.\n \n This spacious unit features an inviting foyer, large waiting area, spacious reception area, 4 private office rooms, a kitchenette, 2 bathrooms, and 2 storage closets, perfect for a variety of professionals or medical uses.\n \n Positioned in a prime high traffic location on Merrick Avenue, this building is conveniently adjacent to Starbucks, 7-Eleven, Taquitos Grill, a nail salon, hairdressers, spa, and other retail and dining options. The building is also home to a dentist office, two medical offices, and additional professional tenants, making it a great environment for wellness or business professionals.\n \n Just minutes from the Southern State Parkway and Sunrise Highway, this office offers excellent accessibility and visibility. The space is currently vacant and available for immediate occupancy. \n \n Don’t miss this opportunity to lease a professional space in a highly desirable North Merrick location! """ +"AttributionContact": "516-519-4363" +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"BuildingFeatures": array:4 [ …4] +"BusinessType": "Barber/Beauty,Dental,Medical,Professional/Office" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-06-07T02:49:01.866114+00:00" +"CrossStreet": "Camp Avenue" +"CumulativeDaysOnMarket": 379 +"DaysOnMarket": 397 +"Directions": "Merrick Avenue to Camp Avenue" +"EntryLevel": 1 +"ExpirationDate": "2027-12-31" +"Flooring": array:1 [ …1] +"Heating": array:2 [ …2] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseAmountFrequency": "Monthly" +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-519-4363" +"ListAgentEmail": "contactameetsikka@gmail.com" +"ListAgentKey": "326217497" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114175" +"ListOfficePhone": "516-888-0884" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-06-06" +"MajorChangeTimestamp": "2026-07-13T21:26:10Z" +"MajorChangeType": "Back On Market" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OnMarketDate": "2025-06-06" +"OriginalEntryTimestamp": "2025-06-07T02:43:20Z" +"OriginalListPrice": 4999 +"OriginatingSystemModificationTimestamp": "2026-07-13T21:26:10Z" +"OwnerName": "1703 Merrick Corp" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "25" +"PhotosChangeTimestamp": "2025-11-06T11:35:36Z" +"PhotosCount": 18 +"PostalCity": "Merrick" +"PreviousListPrice": 4500 +"PriceChangeTimestamp": "2026-01-23T18:42:07Z" +"PropertyCondition": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-817-6447" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-07-13T21:26:10Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Merrick" +"StreetNumber": "1695" +"StreetNumberNumeric": "1695" +"StreetSuffix": "Avenue" +"SyndicateTo": array:3 [ …3] +"TaxAnnualAmount": "47000" +"TaxYear": "2025" +"UnitNumber": "1695" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_HoldDate": "2026-06-24" +"KEY_ElevatorYN": "0" +"KEY_SqFtOffice": "1280" +"KEY_SubleaseYN": "0" +"KEY_UsableArea": "1280.00" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "4200.00" +"KEY_LeasePriceUnit": "Total" +"KEY_PreviousStatus": "Hold" +"KEY_SecurityDeposits": "8400" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Back On Market" +"KEY_LocationDescription": "First Floor" +"KEY_SourceSystemModificationTimestamp": "2025-06-06T22:43:20.580" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "3.28125" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.84017" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "3.28125" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY420465898')" +"provider_name": "One Key" +"Media": array:18 [ …18] +"ID": "26034" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5303 +post_id: "26018" +post_author: 1 +"ListingKey": "KEY420452769" +"ListingId": "874316" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-08-16T04:12:37Z" +"RFModificationTimestamp": "2025-08-16T04:14:22Z" +"ListPrice": 1199999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2811.0 +"BuildingAreaTotal": 2811.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1674 Birch Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6571228 +"Longitude": -73.5609499 +"YearBuilt": 2005 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jordan Cabral Martin" +"ListOfficeName": "Keller Williams Legendary" +"ListAgentMlsId": "190398" +"ListOfficeMlsId": "KWLG01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Step into space, style, and comfort with this expansive 5-bedroom, 2.5-bath center-hall Colonial, perfectly positioned mid-block on a quiet residential street. Built in 2005, this beautifully maintained home offers an abundance of room for both everyday living and entertaining.\n \n The layout is generous and thoughtfully designed, featuring large, sunlit rooms, elegant decorative moldings, and a seamless flow throughout. The granite eat-in kitchen is a true centerpiece, offering both beauty and function. A stunning chandelier serves as a striking focal point, adding elegance and character to the home’s refined atmosphere.\n \n Upstairs, you'll find five full-sized bedrooms—ideal for those seeking maximum flexibility for living, working, or hosting—while the 2.5 bathrooms ensure convenience and privacy for all. The home is finished with hardwood and ceramic tile flooring, two-zone central air conditioning, and a private PVC-fenced yard with an in-ground sprinkler system.\n \n The backyard is spacious and inviting—perfect for outdoor entertaining, weekend lounging, or quiet enjoyment. Additional features include an attached 1-car garage, offering both convenience and storage.\n \n Ideally located near major public transportation, shopping, and dining, this home provides exceptional space, style, and convenience all in one. Don’t miss this opportunity to own a spacious, move-in ready home that checks every box! """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "347-524-1659" +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"CancellationDate": "2025-08-14" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-425-8996" +"CoListAgentEmail": "Rebeccap@kw.com" +"CoListAgentFullName": "Rebecca Pissalidis" +"CoListAgentKey": "326216048" +"CoListAgentMlsId": "206661" +"CoListOfficeKey": "326113002" +"CoListOfficeMlsId": "KWLG01" +"CoListOfficeName": "Keller Williams Legendary" +"CoListOfficePhone": "516-328-8600" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-06-06T15:01:01.653359+00:00" +"CumulativeDaysOnMarket": 63 +"DaysOnMarket": 63 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2025-08-16" +"Fencing": array:2 [ …2] +"Flooring": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:11 [ …11] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "347-524-1659" +"ListAgentEmail": "JCM@Vision Elite Team.com" +"ListAgentKey": "326200337" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113002" +"ListOfficePhone": "516-328-8600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-06" +"LivingAreaSource": "Public Records" +"LotFeatures": array:6 [ …6] +"LotSizeAcres": 0.1377 +"LotSizeDimensions": "60x100" +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2025-08-16T04:11:12Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2025-08-14" +"OnMarketDate": "2025-06-12" +"OriginalEntryTimestamp": "2025-06-06T14:55:24Z" +"OriginalListPrice": 1275000 +"OriginatingSystemModificationTimestamp": "2025-08-16T04:11:12Z" +"OtherStructures": array:1 [ …1] +"OwnerName": "Kerr" +"ParcelNumber": "2089-55-P-00-0113-0" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-06-06T15:02:36Z" +"PhotosCount": 33 +"PostalCity": "Merrick" +"PostalCodePlus4": "4101" +"PreviousListPrice": 1275000 +"PriceChangeTimestamp": "2025-07-06T21:30:46Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-407-7286" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-08-16T04:11:12Z" +"StreetName": "Birch" +"StreetNumber": "1674" +"StreetNumberNumeric": "1674" +"StreetSuffix": "Drive" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "19579.07" +"TaxAssessedValue": 703 +"TaxBlock": "P" +"TaxLot": "113" +"TaxYear": "2025" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial,Pull Stairs" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "55" +"KEY_CurrentPrice": "1199999.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Canceled" +"KEY_AdditionalRooms": "Dining Area" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "2811.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "426.89399" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8714589.6877" +"KEY_RATIO_CurrentPrice_By_LivingArea": "426.89399" +"KEY_SourceSystemModificationTimestamp": "2025-06-06T09:59:44.770" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "426.89399" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.94118" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "426.89399" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY420452769')" +"provider_name": "One Key" +"Media": array:33 [ …33] +"ID": "26018" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5304 +post_id: "26003" +post_author: 1 +"ListingKey": "KEY420438941" +"ListingId": "873981" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-10-01T04:16:01Z" +"RFModificationTimestamp": "2025-10-01T04:18:42Z" +"ListPrice": 764999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1700.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "9 Troy Place, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6620166 +"Longitude": -73.5534026 +"YearBuilt": 1931 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Bernard Miglio" +"ListOfficeName": "Bernard Miglio Real Estate Inc" +"ListAgentMlsId": "9049089" +"ListOfficeMlsId": "MGLO01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Solid Brick Tudor on quiet residential street \n Living room W/ Fireplace, Large Formal Dining Room, Den Kitchen w/ separate dining area, full bath\n 3 Large Bedrooms & Full Bath\n Close to LIRR\n Excellent Merrick School District """ +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-872-6100" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-06-05T22:10:03.795025+00:00" +"CrossStreet": "Sunrise hwy" +"CumulativeDaysOnMarket": 118 +"DaysOnMarket": 118 +"DirectionFaces": "West" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2025-10-01" +"FireplaceYN": true +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-872-6100" +"ListAgentEmail": "bmiglio@aol.com" +"ListAgentKey": "326258927" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113637" +"ListOfficePhone": "516-872-6100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-05" +"ListingTerms": "Conventional" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.099 +"LotSizeSquareFeet": 4300 +"MajorChangeTimestamp": "2025-10-01T04:15:05Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2025-10-01" +"OnMarketDate": "2025-06-05" +"OriginalEntryTimestamp": "2025-06-05T22:07:26Z" +"OriginalListPrice": 799900 +"OriginatingSystemModificationTimestamp": "2025-10-01T04:15:05Z" +"OwnerName": "Gorinsky" +"ParkingTotal": "3" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-01T04:16:01Z" +"PhotosCount": 17 +"PostalCity": "Merrick" +"PostalCodePlus4": "3815" +"PreviousListPrice": 799900 +"PriceChangeTimestamp": "2025-07-22T16:05:08Z" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-10-01T04:15:05Z" +"StreetName": "Troy" +"StreetNumber": "9" +"StreetNumberNumeric": "9" +"StreetSuffix": "Place" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "13458.57" +"TaxLot": "131" +"TaxYear": "2025" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"YearBuiltEffective": 1931 +"KEY_Attic": "Full" +"KEY_TaxSource": "Other" +"KEY_TaxSection": "55" +"KEY_CurrentPrice": "764999.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "1700.00" +"KEY_NumberOfHeatingZones": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "449.99941" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7727262.6263" +"KEY_RATIO_CurrentPrice_By_LivingArea": "449.99941" +"KEY_SourceSystemModificationTimestamp": "2025-06-05T13:39:02.817" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.95637" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY420438941')" +"provider_name": "One Key" +"Media": array:17 [ …17] +"ID": "26003" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5305 +post_id: "26140" +post_author: 1 +"ListingKey": "KEY420411615" +"ListingId": "873302" +"PropertyType": "Commercial Sale" +"PropertySubType": "Office" +"StandardStatus": "Hold" +"ModificationTimestamp": "2026-06-25T07:01:38Z" +"RFModificationTimestamp": "2026-06-29T08:29:26Z" +"ListPrice": 2625000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 17372.0 +"LivingArea": 0 +"BuildingAreaTotal": 5482.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "On Merrick Ave Merrick Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 1956 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ameet Sikka" +"ListOfficeName": "National Real Estate Agency" +"ListAgentMlsId": "KEY208146" +"ListOfficeMlsId": "KEYNTLR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Newly Renovated Freestanding Commercial Building in Prime North Merrick Location\n \n Exceptional opportunity to own a fully updated brick commercial property situated on a 17,303 sq ft corner lot along a high-traffic main road in North Merrick, NY. This impressive building offers approximately 5,482 sq ft of interior space and is ideally suited for both investors and owner-users.\n \n The property features 6 spacious units, each with private entrances, modern flooring, and energy-efficient LED lighting. Additional highlights include 5 bathrooms, storage closets, an unfinished basement ideal for storage and building systems, and a private parking lot with 28 spaces, recently repaved with new blacktop and a newly constructed walkway.\n \n The building is currently occupied by a strong mix of professional tenants, including a dentist, psychiatrist, internal medicine physician, cardiologist (featuring a mini operating room), and a foot spa. One unit is currently vacant, presenting an excellent opportunity for an owner-user or additional rental income.\n \n Conveniently located near the heart of North Merrick, with close proximity to Starbucks, restaurants, schools, major highways, and shopping centers, this property offers outstanding visibility and accessibility.\n \n Don’t miss this rare chance to acquire a turnkey commercial asset in a thriving and highly desirable area. """ +"AttributionContact": "516-519-4363" +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BuildingFeatures": array:3 [ …3] +"BusinessType": "Barber/Beauty,Commercial,Dental,Medical,Mixed,Professional/Office" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-778-7771" +"CoListAgentEmail": "contactsikka@gmail.com" +"CoListAgentFullName": "Sandeep S. Sikka" +"CoListAgentKey": "KEY326189806" +"CoListAgentMlsId": "KEY179239" +"CoListOfficeKey": "KEY326114175" +"CoListOfficeMlsId": "KEYNTLR01" +"CoListOfficeName": "National Real Estate Agency" +"CoListOfficePhone": "516-888-0884" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-06-15T01:57:49.660984+00:00" +"CrossStreet": "Camp Avenue" +"CumulativeDaysOnMarket": 227 +"DaysOnMarket": 227 +"Directions": "On Merrick Avenue - Cross street is Camp Avenue" +"Electric": "200+ Amp Service" +"EntryLevel": 1 +"ExpirationDate": "2027-12-31" +"Flooring": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"Heating": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-519-4363" +"ListAgentEmail": "contactameetsikka@gmail.com" +"ListAgentKey": "KEY326217497" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "KEY326114175" +"ListOfficePhone": "516-888-0884" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-14" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.3988 +"LotSizeSquareFeet": 17372 +"MajorChangeTimestamp": "2026-06-24T15:18:52Z" +"MajorChangeType": "Hold" +"MlgCanUse": array:3 [ …3] +"MlsStatus": "Hold" +"NumberOfBuildings": 1 +"NumberOfUnitsTotal": "6" +"OffMarketDate": "2026-06-24" +"OnMarketDate": "2025-06-14" +"OriginalEntryTimestamp": "2025-06-15T01:53:41Z" +"OriginalListPrice": 2700000 +"OriginatingSystemModificationTimestamp": "2026-06-24T15:18:52Z" +"OwnerName": "Merrick Corp" +"ParcelNumber": "2089-56-101-00-0015-0" +"ParkingFeatures": array:3 [ …3] +"ParkingTotal": "28" +"PhotosChangeTimestamp": "2025-11-05T00:43:53Z" +"PhotosCount": 48 +"PostalCity": "Merrick" +"PreviousListPrice": 2700000 +"PriceChangeTimestamp": "2026-04-01T20:03:07Z" +"PropertyCondition": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-519-4363" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-24T15:18:52Z" +"Stories": "1" +"StoriesTotal": "2" +"StreetName": "Merrick" +"StreetNumber": "On Merrick Road" +"StreetSuffix": "Avenue" +"SyndicateTo": array:3 [ …3] +"TaxAnnualAmount": "66887.3" +"TaxAssessedValue": 12029 +"TaxYear": "2023" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"Zoning": "C" +"KEY_HoldDate": "2026-06-24" +"KEY_ElevatorYN": "0" +"KEY_UsableArea": "5482.00" +"KEY_CurrentPrice": "2625000.00" +"KEY_WaterAccessYN": "0" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6582246.7402" +"KEY_SourceSystemModificationTimestamp": "2025-06-04T11:38:31.587" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "478.83984" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97222" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "478.83984" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY420411615')" +"provider_name": "One Key" +"Media": array:48 [ …48] +"ID": "26140" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5306 +post_id: "25889" +post_author: 1 +"ListingKey": "KEY420294722" +"ListingId": "868530" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-11-30T07:01:52Z" +"RFModificationTimestamp": "2025-11-30T07:04:27Z" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1959.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2077 Byron Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6559335 +"Longitude": -73.5458057 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Seth B. Levy" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "160761" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "CALLING ALL MERRICK INVESTORS & HOMEOWNERS! TAKE ADVANTAGE OF THIS RARE OPPORTUNITY TO BUILD 2 CUSTOM HOMES IN MERRICK’S LINDENMERE ESTATES!! LOCATED CLOSE TO THE LIRR, MERRICK VILLAGE, PARKS, BEACHES, MARINAS & WATERFRONT DINING, THIS PROPERTY CAN BE DIVIDED TO ACCOMMODATE 2 BRAND NEW HOMES ON 6,000 SQ. FT. LOTS EACH OR 1 BRAND NEW HOME ON A SPRAWLING 12,000 SQ. FT. ESTATE STYLE PROPERTY!" +"AdditionalParcelsYN": true +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BodyType": array:1 [ …1] +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-05-29T15:35:45.854424+00:00" +"CumulativeDaysOnMarket": 185 +"DaysOnMarket": 185 +"DirectionFaces": "East" +"ElementarySchool": "Contact Agent" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2025-11-30" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Contact Agent" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-546-6300" +"ListAgentEmail": "slevy@signaturepremier.com" +"ListAgentKey": "326172773" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-29" +"LivingAreaSource": "Public Records" +"LotSizeDimensions": "120x100" +"LotSizeSquareFeet": 12000 +"MajorChangeTimestamp": "2025-11-30T05:10:40Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Call Listing Agent" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2025-11-30" +"OnMarketDate": "2025-05-29" +"OriginalEntryTimestamp": "2025-05-29T15:32:44Z" +"OriginalListPrice": 1800000 +"OriginatingSystemModificationTimestamp": "2025-11-30T05:10:40Z" +"OwnerName": "Kudler" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-11-03T20:02:36Z" +"PhotosCount": 4 +"PostalCity": "Merrick" +"PreviousListPrice": 1800000 +"PriceChangeTimestamp": "2025-11-03T20:01:03Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-528-1737" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-11-30T05:10:40Z" +"StreetName": "Byron" +"StreetNumber": "2077" +"StreetNumberNumeric": "2077" +"StreetSuffix": "Road" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "17909.55" +"TaxYear": "2025" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1750000.00" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "1959.00" +"KEY_NumberOfHeatingZones": "1" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "893.31291" +"KEY_RATIO_CurrentPrice_By_LivingArea": "893.31291" +"KEY_SourceSystemModificationTimestamp": "2025-05-29T10:31:59.033" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97222" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY420294722')" +"provider_name": "One Key" +"Media": array:4 [ …4] +"ID": "25889" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5307 +post_id: "25540" +post_author: 1 +"ListingKey": "KEY419872718" +"ListingId": "856759" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-11-03T07:01:54Z" +"RFModificationTimestamp": "2025-11-03T07:08:09Z" +"ListPrice": 1495000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2788.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2035 Sans Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6477675 +"Longitude": -73.5404444 +"YearBuilt": 1963 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Zachary Elliott" +"ListOfficeName": "Nest Seekers LLC" +"ListAgentMlsId": "162894" +"ListOfficeMlsId": "NSST03" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this one-of-a-kind, expanded and customized Chalet Splanch located in Merrick’s desirable Hewlett Peninsula. The striking stucco and stone exterior makes a bold first impression, enhanced by a tranquil front water feature. Step through double doors into a stunning entryway with custom coffered ceilings that set the tone for this distinctive home.\n \n The upper level features four spacious bedrooms, including a primary suite with its own custom bathroom. A walk-up attic provides excellent storage and a versatile space perfect for a home office or potential fifth bedroom.\n \n The formal dining area impresses with vaulted ceilings and a skylight, while the eat-in kitchen and dining room are equipped with radiant heated floors. A rear extension with a gas fireplace and walls of windows offers a panoramic view of your private, resort-style backyard, complete with a heated in-ground saltwater pool and a second water feature that adds to the serene outdoor setting. Dine and entertain under the Tiki hut with built-in BBQ, ideal for summer gatherings.\n \n Additional highlights include a finished basement, 200-amp service with sub-panels, 2-zone central air, a whole-house generator, fenced yard with pavers, and more. This is a truly unique home that stands apart from the rest. """ +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-922-2878" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-05-02T22:17:01.879301+00:00" +"CumulativeDaysOnMarket": 185 +"DaysOnMarket": 185 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2025-11-03" +"Fencing": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Contact Agent" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-695-1547" +"ListAgentEmail": "zache@nestseekers.com" +"ListAgentKey": "326174729" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114168" +"ListOfficePhone": "516-922-2878" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-02" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.2259 +"LotSizeSquareFeet": 9840 +"MajorChangeTimestamp": "2025-11-03T05:10:57Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Call Listing Agent" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2025-11-03" +"OnMarketDate": "2025-05-02" +"OriginalEntryTimestamp": "2025-05-02T22:10:35Z" +"OriginalListPrice": 1495000 +"OriginatingSystemModificationTimestamp": "2025-11-03T05:10:57Z" +"OwnerName": "James Cuccias" +"ParcelNumber": "2089-63-156-00-0042-0" +"ParkingFeatures": array:4 [ …4] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-11-03T05:12:37Z" +"PhotosCount": 35 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "5331" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-695-1547" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-11-03T05:10:57Z" +"StreetName": "Sans" +"StreetNumber": "2035" +"StreetNumberNumeric": "2035" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "23158.66" +"TaxYear": "2023" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Walkup" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1495000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "2788.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "536.22669" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6617972.5542" +"KEY_RATIO_CurrentPrice_By_LivingArea": "536.22669" +"KEY_SourceSystemModificationTimestamp": "2025-05-02T12:11:30.947" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419872718')" +"provider_name": "One Key" +"Media": array:35 [ …35] +"ID": "25540" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5308 +post_id: "25224" +post_author: 1 +"ListingKey": "KEY419482932" +"ListingId": "846507" +"PropertyType": "Commercial Lease" +"PropertySubType": "Business" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-01-01T07:04:38Z" +"RFModificationTimestamp": "2026-01-01T07:07:39Z" +"ListPrice": 3850.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 4600.0 +"LivingArea": 0 +"BuildingAreaTotal": 6992.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "139-151 Merrick Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.679113153992 +"Longitude": -73.558486803675 +"YearBuilt": 1952 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Irene Rallis" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "167636" +"ListOfficeMlsId": "DERE52" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Prime location in Merrick. One space available. 1,000 interior SF. Price includes taxes, insurance and CAM." +"AttributionContact": "516-627-2800" +"Basement": array:1 [ …1] +"BasementYN": true +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Commercial" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-04-08T20:29:27.949312+00:00" +"CrossStreet": "Loines Ave" +"CumulativeDaysOnMarket": 268 +"DaysOnMarket": 268 +"Directions": "Google Maps" +"ExpirationDate": "2026-01-01" +"Heating": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseAmountFrequency": "Monthly" +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-241-9848" +"ListAgentEmail": "irene.rallis@elliman.com" +"ListAgentKey": "326179091" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110779" +"ListOfficePhone": "516-627-2800" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-04-08" +"LotSizeAcres": 0.1056 +"LotSizeSquareFeet": 4600 +"MajorChangeTimestamp": "2026-01-01T05:31:33Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"NumberOfBuildings": 1 +"OffMarketDate": "2026-01-01" +"OnMarketDate": "2025-04-08" +"OriginalEntryTimestamp": "2025-04-08T20:27:08Z" +"OriginalListPrice": 3850 +"OriginatingSystemModificationTimestamp": "2026-01-01T05:31:33Z" +"OwnerName": "CFED Realty LLC" +"ParcelNumber": "2089-55-502-00-0038-0" +"PhotosChangeTimestamp": "2026-01-01T05:31:39Z" +"PhotosCount": 9 +"PostalCity": "Merrick" +"PropertyAttachedYN": true +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-241-9848" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-01T05:31:33Z" +"StreetName": "Merrick" +"StreetNumber": "139-145" +"StreetNumberNumeric": "139" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "33763.12" +"TaxAssessedValue": 4812 +"TaxYear": "2023" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_ElevatorYN": "0" +"KEY_SqFtOffice": "900" +"KEY_SubleaseYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "3850.00" +"KEY_LeasePriceUnit": "Total" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumberOfResidentialUnits": "0" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "36458.3333" +"KEY_SourceSystemModificationTimestamp": "2025-04-08T16:19:32.643" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "0.55063" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "0.55063" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419482932')" +"provider_name": "One Key" +"Media": array:9 [ …9] +"ID": "25224" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5309 +post_id: "30421" +post_author: 1 +"ListingKey": "KEY419433536" +"ListingId": "844884" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-03-14T04:13:36Z" +"RFModificationTimestamp": "2026-03-14T04:14:48Z" +"ListPrice": 749999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1600.0 +"BuildingAreaTotal": 1605.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1493 N Meadow Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.626074714367 +"Longitude": -73.750609513768 +"YearBuilt": 1952 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dorothy P. Powell SRES" +"ListOfficeName": "Realty Pros Plus Inc" +"ListAgentMlsId": "173882" +"ListOfficeMlsId": "RLTP01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Storybook Perfect! Immaculate, Expanded Cape Cod on Quiet Cul-de-sac Featuring Outstanding Merrick Schools. LOW Taxes & Move-in Ready! Highlights Include: Huge Sundrenched 20'x11' Great Room Addition, and Large Fireplace -- Perfect for Everyday or Gatherings. Gleaming Hardwood Floors, Fresh Paint Throughout, Brand New Carpet in Den, Open Floor plan with 4 Spacious Bedrooms with built-in's,, Kitchen, Dining Room & lg. Livingroom. This Home is Super Well Maintained In & Out! Maintenance Free Vinyl Siding Exterior with Fieldstone Front on 60x100 Fenced Mid Block Parcel. Large Backyard with New Patio and Extensive Beautiful, New Custom Paver Driveway and Walkways -- for Great Curb Appeal. Full Unobstructed Basement with All New Thermal Pane Windows, Upgraded Electric Panel and High Ceilings for Endless Expansion Possibilities. Won't Last!" +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-804-9000" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"CancellationDate": "2026-03-13" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-804-9000" +"CoListAgentEmail": "christiep94@gmail.com" +"CoListAgentFullName": "Christie Powell" +"CoListAgentKey": "326210372" +"CoListAgentMlsId": "200853" +"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-04-04T22:05:24.306735+00:00" +"CrossStreet": "Meadowbrook Rd" +"CumulativeDaysOnMarket": 338 +"DaysOnMarket": 338 +"DirectionFaces": "South" +"Directions": "Take N. Meadow rd, off Meadowbrook Rd" +"ElementarySchool": "Harold D Fayette School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-03-14" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplacesTotal": "1" +"Heating": array:1 [ …1] +"HighSchool": "Contact Agent" +"HighSchoolDistrict": "North Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"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 Sell" +"ListingContractDate": "2025-04-04" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1373 +"LotSizeSquareFeet": 5980 +"MajorChangeTimestamp": "2026-03-14T04:12:33Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Call Listing Agent" +"MiddleOrJuniorSchoolDistrict": "North Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2026-03-13" +"OnMarketDate": "2025-04-09" +"OriginalEntryTimestamp": "2025-04-04T21:55:24Z" +"OriginalListPrice": 649000 +"OriginatingSystemModificationTimestamp": "2026-03-14T04:12:33Z" +"OwnerName": "Chacon" +"ParcelNumber": "2089-55-540-00-0045-0" +"PhotosChangeTimestamp": "2026-03-02T05:13:37Z" +"PhotosCount": 26 +"PostalCity": "Merrick" +"PostalCodePlus4": "1338" +"PreviousListPrice": 649000 +"PriceChangeTimestamp": "2025-04-04T22:07:08Z" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-14T04:12:33Z" +"StreetDirPrefix": "N" +"StreetName": "Meadow" +"StreetNumber": "1493" +"StreetNumberNumeric": "1493" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "11584.17" +"TaxAssessedValue": 410 +"TaxYear": "2023" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "749999.00" +"KEY_PreviousStatus": "Canceled" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "1600.00" +"KEY_RATIO_ListPrice_By_LivingArea": "468.74938" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5462483.6125" +"KEY_RATIO_CurrentPrice_By_LivingArea": "468.74938" +"KEY_SourceSystemModificationTimestamp": "2025-04-04T14:27:00.600" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "467.28910" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.15562" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "467.28910" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419433536')" +"provider_name": "One Key" +"Media": array:26 [ …26] +"ID": "30421" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5310 +post_id: "24199" +post_author: 1 +"ListingKey": "KEY419077695" +"ListingId": "834658" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-09-14T04:12:45Z" +"RFModificationTimestamp": "2025-09-14T04:15:14Z" +"ListPrice": 1598000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3300.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "103 Frankel Boulevard, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6614536 +"Longitude": -73.5451255 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Linda Donnelly Birdsall CBR RSPS A" +"ListOfficeName": "Daniel Gale Sothebys Intl Rlty" +"ListAgentMlsId": "187045" +"ListOfficeMlsId": "GALE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This Stunning New 2025 Colonial in the heart of Merrick is a Must See to fully appreciate the Superior Finishes. Featuring 5 Spacious Bedrooms, 4 spa-like Full Baths and a Fully-Finished 1200sf Basement, this exceptional home is unlike anything else on the market. Curated with today’s discerning homeowner in mind, the home showcases a striking blend of Stone and Board and Batten construction on the front facade with a wide 10’ Portico setting the tone of the quality of materials used throughout. Upon entering the impressive double-height foyer, some of the many high-end finishes you will experience include 6” White Oak Hardwood Floors, Custom Wood & Wrought Iron Banister, Coffered Ceiling in Dining Room, Stone-surrounded Gas Linear Fireplace in Family Room and a Chef’s Kitchen that would make any family chef proud. The Modern Kitchen embraces simplicity and elegance with beautiful Quartz countertops, GE Monogram appliances including both a SmartHQ Wall Oven and a Professional 36” Range, Large Dining Island and Ceramic Farm Sink accented by Brushed Bronze hardware. A Private Bedroom/Office and Full Bathroom are situated away from the Entertaining spaces on the First Level. The Second Floor features Four additional Bedrooms including the Primary En-Suite where you can unwind in your Private Sanctuary to recharge after a long day's work or intense workout. Relax in your designer Wet Room with Two Rain Shower heads, Soaking Tub, Heated Floors and Water Closet with a Bidet Toilet. This Spa Experience is enhanced by impressive floor-to-ceiling tile, as is the case with every Bathroom in this Home. Completing the Second Level is an oversized Linen Closet and Laundry Room outfitted with custom cabinetry, stainless steel sink and LG Front Load Washer and Dryer. The Finished Lower Level goes above and beyond with wide plank wood-grain ceramic tile offering beauty and easy maintenance, Full Bathroom and Outside Entrance. Other features include Andersen 400 Windows, Chandelier Lift, Central Vac, Tankless Navien Boiler, 4-Zone Irrigation System, Extra-Wide Driveway, Large Pavered Rear Patio and Fully-Fenced Property with 2 Gates. Conveniently located near LIRR, Shopping and Dining." +"Appliances": array:12 [ …12] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-678-1510" +"Basement": array:4 [ …4] +"BasementYN": true +"BathroomsFull": 4 +"BuildingAreaUnits": "Square Feet" +"CancellationDate": "2025-09-11" +"ConstructionMaterials": array:6 [ …6] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-03-14T00:01:04.862511+00:00" +"CumulativeDaysOnMarket": 165 +"DaysOnMarket": 165 +"Directions": "Sunrise Highway or Merrick Road to Frankel Blvd." +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2025-09-14" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:18 [ …18] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-808-1845" +"ListAgentEmail": "lindadonnelly@danielgale.com" +"ListAgentKey": "326197146" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111569" +"ListOfficePhone": "516-678-1510" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-13" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.1377 +"LotSizeDimensions": "60 x 100" +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2025-09-14T04:11:16Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2025-09-11" +"OnMarketDate": "2025-03-24" +"OriginalEntryTimestamp": "2025-03-13T23:58:22Z" +"OriginalListPrice": 1699888 +"OriginatingSystemModificationTimestamp": "2025-09-14T04:11:16Z" +"OwnerName": "Xiotis" +"ParcelNumber": "2089-56-188-00-0331-0" +"PhotosChangeTimestamp": "2025-08-01T07:47:36Z" +"PhotosCount": 25 +"PostalCity": "Merrick" +"PostalCodePlus4": "4030" +"PreviousListPrice": 1649000 +"PriceChangeTimestamp": "2025-07-11T13:19:52Z" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-808-1845" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-09-14T04:11:16Z" +"StreetName": "Frankel" +"StreetNumber": "103" +"StreetNumberNumeric": "103" +"StreetSuffix": "Boulevard" +"SyndicateTo": array:1 [ …1] +"TaxAssessedValue": 471 +"TaxBlock": "188" +"TaxLot": "331" +"TaxYear": "2025" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Other" +"KEY_TaxSection": "56" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1598000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Canceled" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "3300.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "484.24242" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "11604938.2716" +"KEY_RATIO_CurrentPrice_By_LivingArea": "484.24242" +"KEY_SourceSystemModificationTimestamp": "2025-03-12T14:34:09.047" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.94006" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419077695')" +"provider_name": "One Key" +"Media": array:25 [ …25] +"ID": "24199" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5311 +post_id: "23889" +post_author: 1 +"ListingKey": "KEY419015569" +"ListingId": "832536" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-04-11T09:28:42Z" +"RFModificationTimestamp": "2025-04-11T09:43:28Z" +"ListPrice": 440000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1287.0 +"BuildingAreaTotal": 1287.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1415 Rhode Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.68396555 +"Longitude": -73.56532835 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "David A. Constantino" +"ListOfficeName": "David R Maltz And Co Inc" +"ListAgentMlsId": "156364" +"ListOfficeMlsId": "DAML01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Online Auction: 2 Family Merrick Home. Bidding opens 4/7 at 1:00 pm & Ends 4/9 at 1:00 pm (appx). The listing price of $440,000 represents the Opening Bid Amount Only. Please conduct due diligence as the property sells "as-is" and the information provided is not guaranteed to be accurate. Bidder must send in signed Terms and Conditions of Sale, signed Online Bidding Form, and a $44,000 deposit to be approved for bidding." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-349-7022" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-03-10T18:21:20.758408+00:00" +"CrossStreet": "William St" +"CumulativeDaysOnMarket": 32 +"DaysOnMarket": 32 +"Directions": """ Meadowbrook Road, to William to Rhode.\n Google Maps """ +"ElementarySchool": "Old Mill Road School" +"ExpirationDate": "2025-04-11" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Contact Agent" +"HighSchoolDistrict": "North Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-349-7022" +"ListAgentEmail": "dc@maltzauctions.com" +"ListAgentKey": "326168751" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110669" +"ListOfficePhone": "516-349-7022" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-07" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1578 +"LotSizeSquareFeet": 6875 +"MajorChangeTimestamp": "2025-04-11T04:10:48Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Contact Agent" +"MlsStatus": "Expired" +"OffMarketDate": "2025-04-11" +"OnMarketDate": "2025-03-10" +"OriginalEntryTimestamp": "2025-03-10T18:04:19Z" +"OriginalListPrice": 440000 +"OriginatingSystemModificationTimestamp": "2025-04-11T09:05:02Z" +"OwnerName": "Donovan" +"ParcelNumber": "2089-55-007-00-0631-0" +"PhotosChangeTimestamp": "2025-03-10T18:05:37Z" +"PhotosCount": 9 +"PostalCity": "Merrick" +"PostalCodePlus4": "2032" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-349-7022" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-04-11T04:10:48Z" +"StreetName": "Rhode" +"StreetNumber": "1415" +"StreetNumberNumeric": "1415" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "6754.03" +"TaxYear": "2025" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_TaxSource": "Municipality" +"KEY_LivingAreaSearchSqFt": "1287.00" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_CurrentPrice": "440000.00" +"KEY_NumberOfKitchens": "2" +"KEY_RATIO_CurrentPrice_By_LivingArea": "341.88034" +"KEY_MlsMajorChangeType": "Expired" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "341.88034" +"KEY_Attic": "None" +"KEY_OpenHouseCount": "2" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "2788339.6705" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "341.88034" +"KEY_ShowingTimeFlagYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "341.88034" +"KEY_SourceSystemModificationTimestamp": "2025-03-07T14:42:01.190" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY419015569')" +"provider_name": "One Key" +"Media": array:9 [ …9] +"ID": "23889" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5312 +post_id: "23908" +post_author: 1 +"ListingKey": "KEY418309381" +"ListingId": "810646" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-05-01T07:05:38Z" +"RFModificationTimestamp": "2025-05-01T07:15:49Z" +"ListPrice": 1199000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2949.0 +"BuildingAreaTotal": 2949.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2810 Wynsum Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.653195 +"Longitude": -73.540026942673 +"YearBuilt": 1954 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Susan Lombardi" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "181694" +"ListOfficeMlsId": "DERE24" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome Home to your newly renovated Dream Home nestled South of Merrick Road in the heart of South Merrick! This exquisite 5-Bedroom, 3-Bathroom Split Level masterpiece showcases nearly 3,000 square feet of luxurious living space. Thoughtfully designed and meticulously customized, this home offers an unparalleled blend of elegance, comfort, and modern living. The open-concept layout creates a bright and inviting atmosphere which is perfect for both everyday living and entertaining. At the heart of the home is the stunning Gourmet Kitchen featuring White Shaker Cabinetry adorned by Chic Modern Gold Hardware, Quartz Countertops, Marble Backsplash and Premium Stainless Steel Appliances.. Walnut colored Hardwood Floors give this home a classic look that seamlessly balances elegance with warmth. A true entertainer's paradise, this home provides a seamless transition from indoor luxury and outdoor splendor. Step through the sliding doors from the Dining Room to your private backyard oasis where you can relax on the sprawling outdoor deck or gather around the outdoor kitchen to grill your favorite meal. The Primary En-Suite is a true tranquil retreat offering a walk-in closet, sitting area and en-suite full bathroom with radiant heat flooring. Additional features include: 5 Bedrooms, 3 Full Bathrooms, Family Room, New Air Conditioning, Wine Refrigerator, Pot Filler, Smart Home Technology, Alexa Ready Smart Home Lighting, 3 Zone Heating, In-Ground Sprinklers and 200 AMP Electric. Close proximity to all Major Parkways, Restaurants, Shopping, Parks, Beaches, LIRR. Your Dream Home awaits you!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-422-7510" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"Cooling": array:3 [ …3] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-01-10T18:39:27.094505+00:00" +"CumulativeDaysOnMarket": 111 +"DaysOnMarket": 111 +"ElementarySchool": "Norman J Levy Lakeside School" +"ExpirationDate": "2025-05-01" +"Fencing": array:1 [ …1] +"Flooring": array:4 [ …4] +"Heating": array:1 [ …1] +"HighSchool": "Contact Agent" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:17 [ …17] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-456-6644" +"ListAgentEmail": "Susan.Lombardi@elliman.com" +"ListAgentKey": "326192080" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110764" +"ListOfficePhone": "631-422-7510" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-01-10" +"LotFeatures": array:8 [ …8] +"LotSizeDimensions": "75 x 100" +"LotSizeSquareFeet": 7500 +"MajorChangeTimestamp": "2025-05-01T04:13:02Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Contact Agent" +"MlsStatus": "Expired" +"OffMarketDate": "2025-05-01" +"OnMarketDate": "2025-01-10" +"OriginalEntryTimestamp": "2025-01-10T18:34:59Z" +"OriginalListPrice": 1249000 +"OriginatingSystemModificationTimestamp": "2025-05-01T04:13:02Z" +"OtherStructures": array:1 [ …1] +"OwnerName": "Gem Hunter" +"ParcelNumber": "2089-63-140-00-0069-0" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-03-12T07:11:37Z" +"PhotosCount": 33 +"PostalCity": "Merrick" +"PostalCodePlus4": "5409" +"PreviousListPrice": 1249000 +"PriceChangeTimestamp": "2025-02-27T02:31:43Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-456-6644" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-05-01T04:13:02Z" +"StreetName": "Wynsum" +"StreetNumber": "2810" +"StreetNumberNumeric": "2810" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "19336.23" +"TaxBlock": "140" +"TaxYear": "2025" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_ElectricCompany": "PSEG" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.95997" +"KEY_TaxSource": "Municipality" +"KEY_LivingAreaSearchSqFt": "2949.00" +"KEY_PreviousStatus": "Active" +"KEY_CurrentPrice": "1199000.00" +"KEY_RATIO_CurrentPrice_By_LivingArea": "406.57850" +"KEY_MlsMajorChangeType": "Expired" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "406.57850" +"KEY_Attic": "Full" +"KEY_OpenHouseCount": "1" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "406.57850" +"KEY_ConcessionYN": "0" +"KEY_ShowingTimeFlagYN": "0" +"KEY_NumberOfHeatingZones": "3" +"KEY_TaxSection": "63" +"KEY_RATIO_ListPrice_By_LivingArea": "406.57850" +"KEY_SourceSystemModificationTimestamp": "2025-01-06T22:40:44.650" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY418309381')" +"provider_name": "One Key" +"Media": array:33 [ …33] +"ID": "23908" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5313 +post_id: "32321" +post_author: 1 +"ListingKey": "KEY426331145" +"ListingId": "1032980" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-01T19:09:49Z" +"RFModificationTimestamp": "2026-08-01T19:15:41Z" +"ListPrice": 795900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2012.0 +"BuildingAreaTotal": 2012.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1706 Washington Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6763875 +"Longitude": -73.5590585 +"YearBuilt": 1988 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Paul F. Generosa" +"ListOfficeName": "Newman Realty Inc" +"ListAgentMlsId": "195918" +"ListOfficeMlsId": "NWMN01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ New to Market 1706 Washington Drive Merrick NY Spacious High Ranch \n 3-4 bedrooms. 2 full baths. Room for extended family \n Opportunity is knocking! This well-maintained High Ranch offers space, flexibility, and value Whether you need room to grow, a multi-generational living arrangement, or a home with versatile space, this property delivers. The main level features a bright and inviting living space, formal dining area, eat-in-kitchen, with dishwasher and stove. three bedrooms an updated full bath with a walk-in shower and hardwood floors throughout. Wall air-conditioning units provide seasonal comfort. The ground level expands your possibilities with a private outside entrance, a full bath with tub, laundry room with washer dryer, attached garage gas heat, and a flex room ideal as a fourth bedroom, home office, gym, playroom or guest suite, perfect for extended family, work-from home needs or additional living space. Outside, enjoy attractive curb appeal a private driveway and beautifully maintained property """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-599-2800" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-07-31T15:28:01.241788+00:00" +"CrossStreet": "Camp Ave" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 1 +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-12-31" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-581-7175" +"ListAgentEmail": "Pgenerosa@icloud.com" +"ListAgentKey": "326205617" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114200" +"ListOfficePhone": "516-599-2800" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-07-30" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1148 +"LotSizeSquareFeet": 5000 +"MajorChangeTimestamp": "2026-07-31T15:22:39Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-07-31" +"OriginalEntryTimestamp": "2026-07-31T15:22:39Z" +"OriginalListPrice": 795900 +"OriginatingSystemModificationTimestamp": "2026-08-01T19:08:18Z" +"OwnerName": "Sama" +"ParcelNumber": "2089-55-051-00-0274-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-07-31T15:24:36Z" +"PhotosCount": 12 +"PostalCity": "Merrick" +"PostalCodePlus4": "2626" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516 581- 7175" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-07-31T15:22:39Z" +"StreetName": "Washington" +"StreetNumber": "1706" +"StreetNumberNumeric": "1706" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13919" +"TaxAssessedValue": 544 +"TaxYear": "2024" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Pull Stairs" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "795900.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "2012.00" +"KEY_NumberOfHeatingZones": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516 599-2800" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "395.57654" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6932926.8293" +"KEY_RATIO_CurrentPrice_By_LivingArea": "395.57654" +"KEY_SourceSystemModificationTimestamp": "2026-07-30T18:19:45.570" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "395.57654" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "395.57654" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY426331145')" +"provider_name": "One Key" +"Media": array:12 [ …12] +"ID": "32321" } 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5314 +post_id: "32322" +post_author: 1 +"ListingKey": "KEY426320461" +"ListingId": "1032652" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-01T20:09:44Z" +"RFModificationTimestamp": "2026-08-01T20:14:04Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2398.0 +"BuildingAreaTotal": 2398.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2514 Lindenmere Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6565388 +"Longitude": -73.5526022 +"YearBuilt": 1955 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Moira R. Connolly CBR" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "119813" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Spacious 4 bedroom, 3 bath split level, just shy of 2,400 sq ft, situated on an oversized 0.37 acre lot in the Lindenmere section. This home is centrally located under a mile from the Merrick LIRR station, library, shops, restaurants & houses of worship. Features include an EIK w/granite counters & white cabinetry, a formal dining room w/hardwood floors, a living room w/vaulted ceiling & decorative fireplace, a den w/2nd decorative fireplace, full bath, picture window & access to the rear patio & 76' x 207' lot. The primary ensuite bedroom offers a wall of closets. The separate laundry/utility room is on the lower level. Inground sprinklers in the front yard (front only) and attached 1-car garage. The expansive backyard provides endless possibilities for entertaining, recreation, or creating your dream outdoor oasis. This home is ready for your customizations!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-07-31T15:44:19.668590+00:00" +"CrossStreet": "Yale Rd" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 1 +"DirectionFaces": "East" +"Directions": "From Sunrise Hwy, head south on Merrick Ave. Turn right on Kirkwood Ave. Bear left onto Lindenmere Drive. #2514 is on the right mid-block." +"Disclosures": array:1 [ …1] +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-01-31" +"FireplaceFeatures": array:1 [ …1] +"FireplacesTotal": "2" +"Flooring": array:3 [ …3] +"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 +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-581-1594" +"ListAgentEmail": "mconnolly@signaturepremier.com" +"ListAgentKey": "326135180" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-07-31" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.3651 +"LotSizeDimensions": "76x207" +"LotSizeSquareFeet": 15904 +"MajorChangeTimestamp": "2026-07-31T15:37:03Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-07-31" +"OriginalEntryTimestamp": "2026-07-31T15:37:03Z" +"OriginalListPrice": 799000 …59 } 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5315 …125} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5316 …125} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5317 …139} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5318 …140} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5319 …131} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5320 …122} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5322 …144} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5291 …156} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5290 …136} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5289 …124} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5288 …141} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5287 …165} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5286 …138} ] +success: true +page_size: 32 +page_count: 7 +count: 193 +after_key: "" } "RF Response Time" => "0.15 seconds" ] ]