Begin your home search journey in Merrick, NY by browsing available listings in one place. This page is dedicated to showcasing current homes for sale, complete with essential details such as property type, Price filter, and zip code search. Whether you’re searching for your first home or your next upgrade, Merrick offers a variety of options to meet your needs. View homes with pools, renovated kitchens, or generous backyard space—all with current pricing and images. Start exploring the Merrick housing market today and filter your search based on your must-have features, budget, and lifestyle goals.
Our simple, step-by-step process ensures a smooth experience for buying new property without any worries or hustle.
Go through the our all listings and find the ideal home that is relevant for your requirements.
Click on the listing you like and then fill out the form to get start with your buying journey.
We guide buyers through offers and agreements to secure the best outcomes.
We handle all paperwork, ensure a smooth closing process, and support you through your next steps.
Our simple, step-by-step process ensures a smooth experience for buying new property without any worries or hustle.
We know Merrick NY street by street — not just by ZIP code. From districts to commute routes, we help you buy smarter based on real neighborhood insight.
You won’t find any sales pressure here. We focus on what works best for you, offering honest input so you can make confident, informed choices.
You won’t be left waiting on answers. We stay connected through every step of the process, so your questions get real replies — not delays.
We tap into local networks to get early access to listings — giving you a head start in a competitive market.
From inspections to paperwork, we manage the chaos so you can focus on the fun part — finding a place you’ll love.
Tight schedule? Need to tour after hours or on weekends? We’re flexible. We work how and when it’s convenient for you.
It’s not just about buying now — we’ll help you choose a home that fits future needs too, like family growth or property value trends.
We’re not here to just close a deal. We look out for your best interest like we would for our own family. Every decision is made with care.
Read what our clients have to say about their experience with us
I highly recommend Kaya Homes if you are looking to buy or sell your home. My home was sold for over ask within 1 week! The process was so simple and easy. Avi had a professional photographer photograph our home and has excellent marketing strategies which led to a speedy transaction. Thank you !!!
Bad Services.
KAYA Homes, and specifically Kamy, is a real estate business with a heart. Before I signed a contract Kamy gave me months of her time, business acumen and understanding. I have bought/sold my homes over many decades. Never have I known a realtor to be so incredibly kind. Everything about how KAYA Homes conduct their business is above reproach.
I had the absolute pleasure of working with Kamy when leasing my new apartment, and I couldn't be happier with the experience! She was fantastic to work with, simplifying the rental process and providing thorough explanations every step of the way. Highly recommend!
This is the third year im using Kaya Homes for my rental, they are very professional. They walk you through everything from start to finish. The owner Kami is awesome!! She is very responsive A+ I highly recommend kaya homes!!
We started our journey with Kaya homes a while back when my husband met Kamy. He knew instantly that we found the right ones to help us with purchasing a new home. Kamy is highly responsive, thoughtful, considerate and very professional on her approach with finding you the right home. We wanted to stay in the area and with such a crazy market, I didn't think it would be possible for us to find our home, but we did. Kamy's reassured us and said we will find your home and we did. Thank you Kamy and also meeting Izzy was a bonus, great family owned business, truly you will not be disappointed. If you are looking to rent, own or sell give them a call.
Absolutely wonderful to work with! I highly suggest if you are looking or selling she is definitely your go to!
Amazing experience with Kaya Homes. She was very helpful and found us our dream home as fast as anyone could wish for!
WOW! Kamy went above and beyond to find us an apartment, my lease was over and I needed to move ASAP and couldn’t find any rentals but when I got in contact with Kamy at Kaya Homes she casted all my worries and stress away. I’ve worked with other realtors in the past which was ok but Kaya Homes over exceeded all of my expectations. Kamy was able to find us a beautiful contemporary apartment in the neighborhood that I appointed and that fit right in our price range within a month we moved in. Kamy is extremely kind, friendly, transparent professional, communicative and easy to reach to answer any of our questions at all times. In addition, since we’ve moved the landlord continues to maintain the apartment beautifully: they provide a cleaning service who comes in to clean inside and outside the complex, landscaper comes weekly, the garbage is pick up 2-3x a week, if there’s ever any issue or something needs fixing they send someone the next day which is a plus because you know they CARE AND APPRECIATE THEIR TENANTS. I recommend Kaya Homes to all my friends & family and to anyone who needs a realtor because they are simply the VERY BEST IN THE BUSINESS. Thank you again Kamy.
I had the pleasure of working on my home selling with Kaya homes and specialty with Kamy Roditi who is a very professional and reliable person. Kamy worked very on my transaction with a fair and quick way and honestly without her my home would not have been sold as fast and for the best possible price as it was. I would highly recomand Kaya homes and Kamy for any Real Estate and business venture, selling and buying Real Estate .
If you are in the market for a new home, I highly recommend going to see Kamy Roditi @ Kaya Homes. She is one of the most knowledgeable realtors I've ever met in the industry hands down. She's honest, trustworthy, responsive and an all around pleasure to work with. She worked diligently to help find the perfect house for my family and smoothly guided me through the process by answering all of my questions thoroughly. Buying a new home can be stressful, but it doesn't have to be if your lucky enough to work with Kamy Roditi. You'll be in good hands, I promise!
I thought about selling my house myself and I’m so glad I didn’t. Kaya Homes was a total blessing for me, the buyers of my home were beyond difficult and they handled every step for me beyond my expectations. They took the stress off of me entirely. I’d highly recommend them to anyone. Thank you again Kaya Homes!!
Highly recommend the team at Kaya Homes. The team is not only knowledgeable but also provides great advice for all real estate needs. Weather your looking to buy, sell, rent or get advice, Kaya homes should be your first call.
array:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=32&$skip=64&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (City eq 'Merrick' or PostalCity eq 'Merrick')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5285 +items: array:32 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5299 +post_id: "31027" +post_author: 1 +"ListingKey": "KEY424231191" +"ListingId": "981093" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-21T16:47:36Z" +"RFModificationTimestamp": "2026-05-21T16:55:17Z" +"ListPrice": 625000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1326.0 +"BuildingAreaTotal": 1326.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "8 Garden Place, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6667245 +"Longitude": -73.5648765 +"YearBuilt": 1951 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Michelle Folan" +"ListOfficeName": "Coldwell Banker M&D Good Life" +"ListAgentMlsId": "505006" +"ListOfficeMlsId": "MJM04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Endless Potential – Bring Your Vision!\n Calling all investors, contractors, and savvy buyers! This property is a prime opportunity for a full renovation or rebuild. Situated on a desirable lot, this 4 bedroom 1 bath home is ready for transformation and offers the chance to create something truly special. Conveniently located near the LIRR (approximately 0.8 miles), Jones Beach, shopping, and schools, this is an opportunity you won’t want to miss! With the right vision and updates, the possibilities are endless. Sold as-is—bring your imagination and make it your next successful project! """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-929-3700" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "917-705-3603" +"BuyerAgentEmail": "shenkell@signaturepremier.com" +"BuyerAgentFullName": "Shari Henkell SRES" +"BuyerAgentKey": "326221116" +"BuyerAgentMlsId": "211890" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115731" +"BuyerOfficeMlsId": "SPH23" +"BuyerOfficeName": "Signature Premier Properties" +"BuyerOfficePhone": "516-785-0100" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-29T15:20:08.936799+00:00" +"CrossStreet": "Meadowbrook Rd" +"CumulativeDaysOnMarket": 22 +"DaysOnMarket": 22 +"DirectionFaces": "South" +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-12-31" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-882-8150" +"ListAgentEmail": "mfolan@mdgoodlife.com" +"ListAgentKey": "421613796" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113722" +"ListOfficePhone": "631-929-3700" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-04" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.1607 +"LotSizeSquareFeet": 7000 +"MajorChangeTimestamp": "2026-05-21T15:13:30Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-21" +"OnMarketDate": "2026-04-29" +"OriginalEntryTimestamp": "2026-04-29T15:10:59Z" +"OriginalListPrice": 625000 +"OriginatingSystemModificationTimestamp": "2026-05-21T16:46:07Z" +"OwnerName": "Eileen R Dahlen" +"ParcelNumber": "2089-55-099-00-0312-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-29T15:03:36Z" +"PhotosCount": 12 +"PostalCity": "Merrick" +"PostalCodePlus4": "3308" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-05-21" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-882-8150" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-21T15:13:30Z" +"StreetName": "Garden" +"StreetNumber": "8" +"StreetNumberNumeric": "8" +"StreetSuffix": "Place" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14065" +"TaxAssessedValue": 487 +"TaxYear": "2026" +"Utilities": array:7 [ …7] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Crawl" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "625000.00" +"KEY_ContractPrice": "732500.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_DistanceToTrain": "0.80" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1326.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "471.34238" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "3889234.5986" +"KEY_RATIO_CurrentPrice_By_LivingArea": "471.34238" +"KEY_SourceSystemModificationTimestamp": "2026-04-06T12:09:06.640" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "471.34238" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "471.34238" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424231191')" +"provider_name": "One Key" +"Media": array:12 [ …12] +"ID": "31027" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5301 +post_id: "30857" +post_author: 1 +"ListingKey": "KEY424208899" +"ListingId": "980431" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-28T18:05:36Z" +"RFModificationTimestamp": "2026-04-28T18:24:05Z" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2200.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2187 Loines Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6705961 +"Longitude": -73.5482507 +"YearBuilt": 1968 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Teri Catapano Black" +"ListOfficeName": "Century 21 Catapano Homes" +"ListAgentMlsId": "9007878" +"ListOfficeMlsId": "JOCA01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Stunning colonial 4 bedrooms, 2.5 baths with exceptional curb appeal. Nestled in the highly desirable Merrick community and located within the top rated Merrick school district. The property is set in beautiful Merrick Woods close to essential amenities such as supermarkets, shopping, and a 0.8 mile to the LIRR. The main level includes a large foyer, spacious living room, an elegant formal dining room, eat in kitchen and a cozy family room with a fireplace. Sliding doors open seamlessly to the deck, fenced in backyard, creating an ideal setting for indoor outdoor living and entertaining. Hardwood floors throughout the house with abundant natural light. The upper level includes 4 bedrooms, laundry room, and an oversized king size plus primary bedroom with a walk in closet and full bath. The layout complements the well-maintained interior with convenient access to the garage. Enjoy the natural light in the large basement which includes new full size windows. Additional highlights include gas heating, central air conditioning, hardwood and tile flooring. Convenient to the Amazing Hamlet of Merrick with lots of shopping, restaurants, recreation and LIRR station. A Real Gem that is Beautifully maintained. Don't delay on this beauty!" +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-938-0021" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-574-3491" +"BuyerAgentEmail": "kaitlynn.mccartney@compass.com" +"BuyerAgentFullName": "Kaitlynn McCartney" +"BuyerAgentKey": "326222507" +"BuyerAgentMlsId": "213328" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110404" +"BuyerOfficeMlsId": "CMPA07" +"BuyerOfficeName": "Compass Greater NY LLC" +"BuyerOfficePhone": "516-764-6060" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-938-0021" +"CoListAgentEmail": "moerlerlynch@aol.com" +"CoListAgentFullName": "Linda M. Lynch" +"CoListAgentKey": "326176098" +"CoListAgentMlsId": "164391" +"CoListOfficeKey": "326112634" +"CoListOfficeMlsId": "JOCA01" +"CoListOfficeName": "Century 21 Catapano Homes" +"CoListOfficePhone": "516-938-0021" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-15T14:42:19.562044+00:00" +"CumulativeDaysOnMarket": 6 +"DaysOnMarket": 6 +"DirectionFaces": "South" +"Disclosures": array:2 [ …2] +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-07-15" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:2 [ …2] +"GarageSpaces": "1.5" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentEmail": "C21TeriBlack@gmail.com" +"ListAgentKey": "326251382" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112634" +"ListOfficePhone": "516-938-0021" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-15" +"LivingAreaSource": "Public Records" +"LotFeatures": array:2 [ …2] +"LotSizeAcres": 0.1377 +"LotSizeDimensions": "60 x 100" +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-04-28T18:04:06Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-21" +"OnMarketDate": "2026-04-15" +"OriginalEntryTimestamp": "2026-04-15T14:35:11Z" +"OriginalListPrice": 1100000 +"OriginatingSystemModificationTimestamp": "2026-04-28T18:04:06Z" +"OwnerName": "Reantillo" +"ParcelNumber": "2089-56-095-00-0069-0" +"ParkingFeatures": array:5 [ …5] +"ParkingTotal": "3" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-15T14:37:36Z" +"PhotosCount": 34 +"PostalCity": "Merrick" +"PurchaseContractDate": "2026-04-27" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "855-953-8211" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-28T18:04:06Z" +"StreetName": "Loines" +"StreetNumber": "2187" +"StreetNumberNumeric": "2187" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17422.66" +"TaxAssessedValue": 634 +"TaxBlock": "95" +"TaxLot": "69" +"TaxYear": "2026" +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full,Pull Stairs" +"KEY_HoldDate": "2026-04-21" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1100000.00" +"KEY_ContractPrice": "1230000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_DistanceToTrain": "0.80" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2200.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-777-2424" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "500.00000" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7988380.5374" +"KEY_RATIO_CurrentPrice_By_LivingArea": "500.00000" +"KEY_SourceSystemModificationTimestamp": "2026-04-03T13:15:34.563" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424208899')" +"provider_name": "One Key" +"Media": array:34 [ …34] +"ID": "30857" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5298 +post_id: "30588" +post_author: 1 +"ListingKey": "KEY424095969" +"ListingId": "977173" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-09T00:13:36Z" +"RFModificationTimestamp": "2026-07-09T00:14:33Z" +"ListPrice": 890000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1631.0 +"BuildingAreaTotal": 1631.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1656 Michalicki Place, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.671593 +"Longitude": -73.5686562 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jaime H. Mesa" +"ListOfficeName": "RE/MAX Team" +"ListAgentMlsId": "9012366" +"ListOfficeMlsId": "CSQU04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Excellent House in a quiet Block. Great Location in Merrick . Close to All Amenities, Worship, Schools and Shopping. Close to Meadowbrook Parkway. Property includes Garage, Private Driveway and Backyard." +"Appliances": array:3 [ …3] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "718-429-4400" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-26T23:40:00.334730+00:00" +"CrossStreet": "Meadowbrook Road" +"CumulativeDaysOnMarket": 104 +"DaysOnMarket": 128 +"Directions": "Meadowbrook Road to Michalicki Place" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-09-27" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchoolDistrict": "North Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "347-684-4135" +"ListAgentEmail": "jaimehmesa@hotmail.com" +"ListAgentKey": "326251992" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110587" +"ListOfficePhone": "718-429-4400" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-26" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1326 +"LotSizeDimensions": "55x108" +"LotSizeSquareFeet": 5778 +"MajorChangeTimestamp": "2026-07-09T00:11:59Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchoolDistrict": "North Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-03-26" +"OriginalEntryTimestamp": "2026-03-26T23:37:14Z" +"OriginalListPrice": 950000 +"OriginatingSystemModificationTimestamp": "2026-07-09T00:11:59Z" +"OwnerName": "Mario Rodriguez" +"ParcelNumber": "2089-55-094-00-1364-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-26T23:38:36Z" +"PhotosCount": 4 +"PostalCity": "Merrick" +"PostalCodePlus4": "2509" +"PreviousListPrice": 950000 +"PriceChangeTimestamp": "2026-07-09T00:11:59Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "347 684-4135" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-26T23:37:14Z" +"StreetName": "Michalicki" +"StreetNumber": "1656" +"StreetNumberNumeric": "1656" +"StreetSuffix": "Place" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13725.73" +"TaxAssessedValue": 508 +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "890000.00" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "1631.00" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "545.67750" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6711915.5354" +"KEY_RATIO_CurrentPrice_By_LivingArea": "545.67750" +"KEY_SourceSystemModificationTimestamp": "2026-03-26T19:33:21.840" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "545.67750" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.93684" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "545.67750" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424095969')" +"provider_name": "One Key" +"Media": array:4 [ …4] +"ID": "30588" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5302 +post_id: "30509" +post_author: 1 +"ListingKey": "KEY423990651" +"ListingId": "974356" +"PropertyType": "Commercial Sale" +"PropertySubType": "Mixed Use" +"StandardStatus": "Hold" +"ModificationTimestamp": "2026-05-12T07:05:42Z" +"RFModificationTimestamp": "2026-05-12T07:06:25Z" +"ListPrice": 729000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 2322.0 +"LivingArea": 0 +"BuildingAreaTotal": 1700.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "174 Merrick Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6537613 +"Longitude": -73.5561503 +"YearBuilt": 1952 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marc Jeret" +"ListOfficeName": "M & J Partners Realty LLC" +"ListAgentMlsId": "221570" +"ListOfficeMlsId": "MJPR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Mixed-use property for sale in the heart of Merrick.\n \n The property consists of 1 credit retail tenant (Allstate Insurance) in the front paying $2678 per month with 3 year lease with increases and a renewal option remaining (newly renovated).\n \n + a vacant flex space in the back newly renovated that can be used/rented out as an apartment/office and a large newly renovated patio.\n \n There is a also a shed and a shared driveway that comes with the property.\n \n Approximately 1700 +/- sq ft which includes the front retail space the back flex office/apartment space and the backyard patio not including shared driveway in measurements.\n \n Please verify all property information and do proper research. """ +"AttributionContact": "516-874-0263" +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Commercial,Mixed,Other,Professional Service,Professional/Office" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-233-9888" +"CoListAgentEmail": "mberrios@mjpartnersrealty.com" +"CoListAgentFullName": "Meliza Berrios" +"CoListAgentKey": "326220813" +"CoListAgentMlsId": "211571" +"CoListOfficeKey": "417764778" +"CoListOfficeMlsId": "MJPR01" +"CoListOfficeName": "M & J Partners Realty LLC" +"CoListOfficePhone": "516-874-0263" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-20T15:55:13.457610+00:00" +"CumulativeDaysOnMarket": 52 +"DaysOnMarket": 52 +"ExpirationDate": "2026-05-20" +"FoundationDetails": array:1 [ …1] +"Heating": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-839-3748" +"ListAgentEmail": "mj@mjpartnersrealty.com" +"ListAgentKey": "326230497" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "417764778" +"ListOfficePhone": "516-874-0263" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-20" +"LotSizeAcres": 0.0533 +"LotSizeSquareFeet": 2322 +"MajorChangeTimestamp": "2026-05-11T13:41:46Z" +"MajorChangeType": "Hold" +"MlgCanUse": array:3 [ …3] +"MlsStatus": "Hold" +"OffMarketDate": "2026-05-11" +"OnMarketDate": "2026-03-20" +"OriginalEntryTimestamp": "2026-03-20T15:49:49Z" +"OriginalListPrice": 729000 +"OriginatingSystemModificationTimestamp": "2026-05-11T13:41:46Z" +"OwnerName": "Name Withheld" +"ParcelNumber": "2089-55-167-00-0195-0" +"PhotosChangeTimestamp": "2026-03-20T15:59:36Z" +"PhotosCount": 13 +"PostalCity": "Merrick" +"PostalCodePlus4": "4532" +"PreviousListPrice": 709999 +"PriceChangeTimestamp": "2026-05-11T13:41:13Z" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "6318393748" +"ShowingRequirements": array:5 [ …5] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-11T13:41:46Z" +"StreetName": "Merrick" +"StreetNumber": "174" +"StreetNumberNumeric": "174" +"StreetSuffix": "Road" +"SyndicateTo": array:3 [ …3] +"TaxAnnualAmount": "12338" +"TaxYear": "2026" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_HoldDate": "2026-05-11" +"KEY_CurrentPrice": "729000.00" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_ShowingContactPhone2": "5162339888" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "13677298.3114" +"KEY_SourceSystemModificationTimestamp": "2026-03-20T11:49:49.273" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "428.82353" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "428.82353" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423990651')" +"provider_name": "One Key" +"Media": array:13 [ …13] +"ID": "30509" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5300 +post_id: "30269" +post_author: 1 +"ListingKey": "KEY423815446" +"ListingId": "969113" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-21T07:07:37Z" +"RFModificationTimestamp": "2026-04-21T07:11:45Z" +"ListPrice": 710000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1183.0 +"BuildingAreaTotal": 1378.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2016 Abbot Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6801837 +"Longitude": -73.5565799 +"YearBuilt": 1927 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Anthony Napolitano Jr" +"ListOfficeName": "Anthony Napolitano Homes" +"ListAgentMlsId": "106653" +"ListOfficeMlsId": "NAPL01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to 2016 Abbot Avenue in beautiful Merrick. This charming Ranch offers comfortable one-level living in a convenient location with 2 year old roof & updated hot water heater. Step inside through the welcoming entrance foyer with office/sitting room that leads to a bright and spacious living room and dining room combination, perfect for everyday living and entertaining. This home features eat-in-kitchen with wood cabinetry, black appliances & granite countertops, three bedrooms, full hall bathroom, laundry room/mudroom, walk-up attic & full basement with office, storage & utilities. A detached 1.5 car garage & in-ground sprinklers complete this home. Located near schools, shopping, restaurants & transportation. Just unpack and enjoy your new home ! Pre-Approval Or Pof Required By All." +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-798-4200" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-807-4315" +"BuyerAgentEmail": "anapolitano78@gmail.com" +"BuyerAgentFullName": "Anthony Napolitano Jr" +"BuyerAgentKey": "326122925" +"BuyerAgentMlsId": "106653" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326113984" +"BuyerOfficeMlsId": "NAPL01" +"BuyerOfficeName": "Anthony Napolitano Homes" +"BuyerOfficePhone": "516-798-4200" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-09T17:46:14.144198+00:00" +"CrossStreet": "Bascom Avenue" +"CumulativeDaysOnMarket": 42 +"DaysOnMarket": 42 +"Directions": "Little Whaleneck Road To Abbot Avenue" +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-06-09" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:2 [ …2] +"Flooring": array:3 [ …3] +"GarageSpaces": "1.5" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:11 [ …11] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-807-4315" +"ListAgentEmail": "anapolitano78@gmail.com" +"ListAgentKey": "326122925" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113984" +"ListOfficePhone": "516-798-4200" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-09" +"LivingAreaSource": "Public Records" +"LotFeatures": array:9 [ …9] +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-04-20T17:53:05Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-20" +"OnMarketDate": "2026-03-09" +"OriginalEntryTimestamp": "2026-03-09T17:38:10Z" +"OriginalListPrice": 710000 +"OriginatingSystemModificationTimestamp": "2026-04-20T17:53:05Z" +"OwnerName": "Michele B Michelson" +"ParcelNumber": "2089-56-125-00-0149-0" +"ParkingFeatures": array:2 [ …2] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-09T17:39:36Z" +"PhotosCount": 26 +"PostalCity": "Merrick" +"PostalCodePlus4": "2404" +"PurchaseContractDate": "2026-04-20" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-807-4315" +"ShowingRequirements": array:3 [ …3] +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-20T17:53:05Z" +"StreetName": "Abbot" +"StreetNumber": "2016" +"StreetNumberNumeric": "2016" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "12311.58" +"TaxAssessedValue": 452 +"TaxBlock": "125" +"TaxLot": "149" +"TaxYear": "2026" +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"KEY_Attic": "Pull Stairs" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "56" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "710000.00" +"KEY_ContractPrice": "715000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalRooms": "Dining Area" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1183.00" +"KEY_NumberOfHeatingZones": "4" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "600.16906" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5156136.5287" +"KEY_RATIO_CurrentPrice_By_LivingArea": "600.16906" +"KEY_SourceSystemModificationTimestamp": "2026-03-09T12:56:31.340" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "515.23948" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "515.23948" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423815446')" +"provider_name": "One Key" +"Media": array:26 [ …26] +"ID": "30269" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5297 +post_id: "31493" +post_author: 1 +"ListingKey": "KEY423764023" +"ListingId": "967481" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-06-24T07:09:38Z" +"RFModificationTimestamp": "2026-06-24T07:11:16Z" +"ListPrice": 849000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1541.0 +"BuildingAreaTotal": 1541.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2716 Hewlett Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6543365 +"Longitude": -73.5443506 +"YearBuilt": 1954 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "John Sinetos" +"ListOfficeName": "Voro LLC" +"ListAgentMlsId": "136631" +"ListOfficeMlsId": "VORO01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Charming and lovingly maintained wide-line Ranch nestled in desirable South Merrick within the sought-after Merrick/Belmore School District. Filled with natural light, this inviting home features an updated kitchen, a cozy wood-burning fireplace, and a versatile bonus room ideal as a bedroom, home office, playroom, or additional living space. Recent improvements include new roof, siding, gutters, landscaping with the furnace, water heater, central air updated over recent years. Also features 200-amp electric service. The full unfinished basement provides abundant storage and endless possibilities. A spacious circular driveway accommodates 6+ vehicles, completing this wonderful home that blends comfort, charm, and convenience!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "877-943-8676" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "917-923-2430" +"BuyerAgentEmail": "blarussarealtor@gmail.com" +"BuyerAgentFullName": "Baldassare LaRussa" +"BuyerAgentKey": "326204043" +"BuyerAgentMlsId": "194299" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326113002" +"BuyerOfficeMlsId": "KWLG01" +"BuyerOfficeName": "Keller Williams Legendary" +"BuyerOfficePhone": "516-328-8600" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "631-767-2830" +"CoListAgentEmail": "mroger@coachrealtors.com" +"CoListAgentFullName": "Melissa Roger" +"CoListAgentKey": "326215666" +"CoListAgentMlsId": "206268" +"CoListOfficeKey": "326110104" +"CoListOfficeMlsId": "CARE18" +"CoListOfficeName": "Howard Hanna Coach" +"CoListOfficePhone": "631-587-1700" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:2 [ …2] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-06-01T15:38:31.800795+00:00" +"CumulativeDaysOnMarket": 22 +"DaysOnMarket": 22 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-11-30" +"ExteriorFeatures": array:2 [ …2] +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:11 [ …11] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "877-943-8676" +"ListAgentEmail": "jsinc21@gmail.com" +"ListAgentKey": "326150329" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326116380" +"ListOfficePhone": "877-943-8676" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-06-01" +"LivingAreaSource": "Measured" +"LotFeatures": array:9 [ …9] +"LotSizeAcres": 0.1607 +"LotSizeSquareFeet": 7000 +"MajorChangeTimestamp": "2026-06-23T18:25:18Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-06-23" +"OnMarketDate": "2026-06-01" +"OriginalEntryTimestamp": "2026-06-01T15:32:25Z" +"OriginalListPrice": 849000 +"OriginatingSystemModificationTimestamp": "2026-06-23T18:25:18Z" +"OwnerName": "Hw 27 Llc" +"ParcelNumber": "2089-63-146-00-0016-0" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-06-02T14:08:36Z" +"PhotosCount": 49 +"PostalCity": "Merrick" +"PostalCodePlus4": "5040" +"PurchaseContractDate": "2026-06-23" +"RoomsTotal": "7" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-767-2830" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-23T18:25:18Z" +"StreetName": "Hewlett" +"StreetNumber": "2716" +"StreetNumberNumeric": "2716" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17453.02" +"TaxAssessedValue": 611 +"TaxYear": "2024" +"Utilities": array:2 [ …2] +"View": "Neighborhood" +"VirtualTourURLUnbranded": "https://visithome.ai/WFdd6P7R9s9hZXvC4sptvr?mu=ft&t=1780364123" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Unfinished" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "849000.00" +"KEY_ContractPrice": "900000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_BuyerRepresentation": "Buyer's Agent" +"KEY_LivingAreaSearchSqFt": "1541.00" +"KEY_NumberOfHeatingZones": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "550.94095" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5283136.2788" +"KEY_RATIO_CurrentPrice_By_LivingArea": "550.94095" +"KEY_SourceSystemModificationTimestamp": "2026-03-04T14:59:39.917" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "550.94095" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "550.94095" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423764023')" +"provider_name": "One Key" +"Media": array:49 [ …49] +"ID": "31493" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5296 +post_id: "30411" +post_author: 1 +"ListingKey": "KEY423669794" +"ListingId": "964894" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-22T13:31:36Z" +"RFModificationTimestamp": "2026-04-22T13:35:36Z" +"ListPrice": 1299000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2374.0 +"BuildingAreaTotal": 2774.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "3000 Holiday Park Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6420802 +"Longitude": -73.5520783 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nancy A. Jarvis CBR" +"ListOfficeName": "Daniel Gale Sothebys Intl Rlty" +"ListAgentMlsId": "9018684" +"ListOfficeMlsId": "GALE19" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Manhattan Sophistication comes to Merrick. Exceptional doesn’t even begin to explain this total and extraordinary 2-year renovation. Down to the studs and rebuilt with every bell and whistle this state-of-the-art “smart” home embraces the latest technology and presents itself as a warm and inviting place to call home. The entry leads you up to the main level where the great room encompasses the living room, dining room and kitchen. This open space is flooded with light from the triple windows in the living room to the 8ft Anderson sliding glass door. The kitchen features custom cabinetry, and the paneled appliances include a Thermador refrigerator, Bosch dishwasher and wine fridge. The kitchen island, with Quartz waterfall countertop, houses TWO Thermador ovens. There is a 6-burner Thermador gas cooktop and a pot-filler faucet. A built-in bar cabinet has lighting and a granite counter. The statement piece in the living room is the gorgeous Negresco honed-leathered granite wall that houses the linear gas fireplace and TV, which is flanked by cabinetry with shelving and drawers. The dining room with sliders gives convenient access to the Trex deck, lower patio and property. Also on this level is a full guest bath with Porcelanosa tile, vanity and a soaker tub, 2 bedrooms and the primary suite. The primary bedroom has been expanded with a separate dressing area that houses a wall of custom closets with triple glass sliding doors, custom lighting, dressers and custom shelving. The spa-like primary bath has a Madelli “smart” mirrored cabinet, Kohler toilet, heated floors, Porcelanosa tile, custom glass shower doors and oversized granite accented niche. The two additional bedrooms have Elfa fitted closets. Down to the ground level the renovation continues. The den has new Anderson 6ft sliders out to the large patio with gas firepit. There is an additional bedroom, with Elfa fitted double closet, the laundry room with “smart” LG washer & dryer and shelving, HVAC closet, another Porcelanosa full bath with shower and the attached two-car garage with Dalton doors, epoxy flooring, Level 2 EV charger, built-in custom shelving, large cabinets, custom server and data rack that connects to all in the house, and is heated by a Fujitsu split duct system. The property is newly landscaped with 7-zone inground sprinklers and is fully fenced and protected with CCTV security. Everything in the wonderous custom “Smart” home is literally at your fingertips and the features include but are not limited to Lutron lights and blackout shades, Viewrail railings, Napoleon gas fireplace, Hewn flooring, Moen faucets, Ecobee thermostat, built-in Sonos speakers (inside and out) Doca lighting, Porcelanosa baths, and Elfa closet systems throughout. The exterior has Hardiplank siding, Techobloc pavers, new fencing & landscaping. Everything related to the utilities has been replaced and upgraded including all new plumbing, all new electric (200Amp service). The whole house and attic has new small-cell sprayed foam insulation." +"Appliances": array:12 [ …12] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-334-3606" +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "347-972-5378" +"BuyerAgentEmail": "vivikinwen1991@gmail.com" +"BuyerAgentFullName": "Dongqin Wen" +"BuyerAgentKey": "326230406" +"BuyerAgentMlsId": "221473" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110487" +"BuyerOfficeMlsId": "CPLI01" +"BuyerOfficeName": "CPRE Elite Inc" +"BuyerOfficePhone": "917-920-0022" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:3 [ …3] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-13T16:34:40.277557+00:00" +"CrossStreet": "Clubhouse Road" +"CumulativeDaysOnMarket": 31 +"DaysOnMarket": 31 +"Directions": "Merrick Avenue to Clubhouse Road to Holiday Park Drive" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-11-22" +"ExteriorFeatures": array:5 [ …5] +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:4 [ …4] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:29 [ …29] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-850-2110" +"ListAgentEmail": "nancyjarvis@danielgale.com" +"ListAgentKey": "326253175" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111561" +"ListOfficePhone": "516-334-3606" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-13" +"LivingAreaSource": "Plans" +"LotFeatures": array:14 [ …14] +"LotSizeAcres": 0.1358 +"LotSizeDimensions": "66 x 91" +"LotSizeSquareFeet": 5915 +"MajorChangeTimestamp": "2026-04-22T13:30:03Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-18" +"OnMarketDate": "2026-03-18" +"OriginalEntryTimestamp": "2026-03-13T16:31:53Z" +"OriginalListPrice": 1459000 +"OriginatingSystemModificationTimestamp": "2026-04-22T13:30:03Z" +"OwnerName": "Spaces With Meraki Llc" +"ParcelNumber": "2089-62-219-00-0022-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "6" +"PatioAndPorchFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-03-13T16:33:36Z" +"PhotosCount": 29 +"PostalCity": "Merrick" +"PostalCodePlus4": "4825" +"PreviousListPrice": 1459000 +"PriceChangeTimestamp": "2026-03-27T14:43:26Z" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-04-21" +"RoomsTotal": "9" +"SecurityFeatures": array:3 [ …3] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "800-746-9464" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-22T13:30:03Z" +"StreetName": "Holiday Park" +"StreetNumber": "3000" +"StreetNumberNumeric": "3000" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15206.93" +"TaxAssessedValue": 556 +"TaxBlock": "219" +"TaxLot": "22" +"TaxYear": "2026" +"Utilities": array:3 [ …3] +"VirtualTourURLUnbranded": "https://kevinspelmanstudio.hd.pics/3000-Holiday-Park-Dr/idx" +"WaterSource": array:1 [ …1] +"YearBuiltEffective": 2024 +"KEY_Attic": "Full,Pull Stairs,Unfinished" +"KEY_HoldDate": "2026-04-18" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "62" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1299000.00" +"KEY_ContractPrice": "1360000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_AdditionalRooms": "Library/Den" +"KEY_DistanceToTrain": "2.00" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2374.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "547.17776" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "9565537.5552" +"KEY_RATIO_CurrentPrice_By_LivingArea": "547.17776" +"KEY_SourceSystemModificationTimestamp": "2026-02-25T12:56:59.747" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "468.27686" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.89034" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "468.27686" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423669794')" +"provider_name": "One Key" +"Media": array:29 [ …29] +"ID": "30411" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5303 +post_id: "30131" +post_author: 1 +"ListingKey": "KEY423656944" +"ListingId": "964461" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-08T07:08:37Z" +"RFModificationTimestamp": "2026-05-08T07:12:24Z" +"ListPrice": 769000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1272.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2341 Dobson Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6576358 +"Longitude": -73.561339 +"YearBuilt": 1955 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jeanene Sloane" +"ListOfficeName": "Eric G Ramsay Jr Assoc LLC" +"ListAgentMlsId": "502579" +"ListOfficeMlsId": "RAMS01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this charming and spacious 3-bedroom 2-bathroom Cape-style home located in the desirable community of Merrick. This home offers bright living areas, formal dining, an eat-in kitchen, cozy den, and an enclosed sunroom overlooking a private backyard. A partially finished basement with a separate entrance provides added versatility. Conveniently located near parks, shopping, dining, and transportation, this Merrick home offers comfort, versatility, and an excellent opportunity to make it your own" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-665-1500" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "646-712-2712" +"BuyerAgentEmail": "umadbronxexperts@gmail.com" +"BuyerAgentFullName": "Umad Saeed" +"BuyerAgentKey": "326194704" +"BuyerAgentMlsId": "184484" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326116380" +"BuyerOfficeMlsId": "VORO01" +"BuyerOfficeName": "Voro LLC" +"BuyerOfficePhone": "877-943-8676" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-24T19:06:54.116597+00:00" +"CumulativeDaysOnMarket": 69 +"DaysOnMarket": 69 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-25" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-456-6495" +"ListAgentEmail": "jeanenesloane@ericramsay.com" +"ListAgentKey": "418383048" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114868" +"ListOfficePhone": "631-665-1500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-02-24" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.17 +"LotSizeSquareFeet": 7400 +"MajorChangeTimestamp": "2026-05-07T18:32:09Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-05-07" +"OnMarketDate": "2026-02-27" +"OriginalEntryTimestamp": "2026-02-24T19:04:34Z" +"OriginalListPrice": 829000 +"OriginatingSystemModificationTimestamp": "2026-05-07T18:32:09Z" +"OwnerName": "Estate of Louis & Caroline Fontinha" +"ParcelNumber": "2089-55-158-00-0006-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-02-24T19:05:36Z" +"PhotosCount": 19 +"PostalCity": "Merrick" +"PreviousListPrice": 829000 +"PriceChangeTimestamp": "2026-03-23T15:25:20Z" +"PurchaseContractDate": "2026-05-07" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-456-6495" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-07T18:32:09Z" +"StreetName": "Dobson" +"StreetNumber": "2341" +"StreetNumberNumeric": "2341" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14283.39" +"TaxBlock": "158" +"TaxLot": "6" +"TaxYear": "2026" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "See Remarks" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "55" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "769000.00" +"KEY_ContractPrice": "720000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_MlsDistrictCode": "2089" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1272.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "604.55975" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4523529.4118" +"KEY_RATIO_CurrentPrice_By_LivingArea": "604.55975" +"KEY_SourceSystemModificationTimestamp": "2026-02-24T12:14:49.233" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.92762" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423656944')" +"provider_name": "One Key" +"Media": array:19 [ …19] +"ID": "30131" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5304 +post_id: "30003" +post_author: 1 +"ListingKey": "KEY423490180" +"ListingId": "959327" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-02T07:07:38Z" +"RFModificationTimestamp": "2026-07-02T07:10:53Z" +"ListPrice": 1350000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3247.0 +"BuildingAreaTotal": 3247.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "18 Helene Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6698276 +"Longitude": -73.5469467 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Keith Barnes" +"ListOfficeName": "REO First Choice Realty LLC" +"ListAgentMlsId": "9032733" +"ListOfficeMlsId": "MISH01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "5 Large Bedrooms, Master suite with breath taking bathroom" +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-483-5400" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerOfficeAOR": "HGAR" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-06T20:25:12.994347+00:00" +"CumulativeDaysOnMarket": 61 +"DaysOnMarket": 91 +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-12-31" +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-327-5365" +"ListAgentEmail": "reofirstchoice@gmail.com" +"ListAgentKey": "326257451" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113706" +"ListOfficePhone": "516-483-5400" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2026-02-06" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1607 +"LotSizeSquareFeet": 7000 +"MajorChangeTimestamp": "2026-07-01T17:21:09Z" +"MajorChangeType": "Back On Market" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-02-06" +"OriginalEntryTimestamp": "2026-02-06T20:18:39Z" +"OriginalListPrice": 1420000 +"OriginatingSystemModificationTimestamp": "2026-07-01T17:21:09Z" +"OwnerName": "Eddyli Rosario" +"ParcelNumber": "2089-56-448-00-0003-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-02-13T23:07:36Z" +"PhotosCount": 5 +"PostalCity": "Merrick" +"PostalCodePlus4": "3205" +"PreviousListPrice": 1300000 +"PriceChangeTimestamp": "2026-07-01T17:20:16Z" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-07-01T17:21:09Z" +"StreetName": "Helene" +"StreetNumber": "18" +"StreetNumberNumeric": "18" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17301" +"TaxAssessedValue": 1057 +"TaxYear": "2024" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1350000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Pending" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Back On Market" +"KEY_BuyerRepresentation": " - Buyer Unrepresented" +"KEY_LivingAreaSearchSqFt": "3247.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "415.76840" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8400746.7330" +"KEY_RATIO_CurrentPrice_By_LivingArea": "415.76840" +"KEY_SourceSystemModificationTimestamp": "2026-02-06T15:18:39.487" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "415.76840" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.95070" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "415.76840" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423490180')" +"provider_name": "One Key" +"Media": array:5 [ …5] +"ID": "30003" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5305 +post_id: "29994" +post_author: 1 +"ListingKey": "KEY423475140" +"ListingId": "958901" +"PropertyType": "Commercial Lease" +"PropertySubType": "Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-24T07:05:38Z" +"RFModificationTimestamp": "2026-04-24T07:15:00Z" +"ListPrice": 1450.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 500.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "25 Merrick Ave Unit 25, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dorothy P. Powell SRES" +"ListOfficeName": "Realty Pros Plus Inc" +"ListAgentMlsId": "173882" +"ListOfficeMlsId": "RLTP01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "2 SPACES NOW AVAIL - Large, bright, private office for lease on 2nd floor in prestigious law office building. This office/ flex space, located in the south west wing also offers the addition of a beautiful adjoining client waiting room and private bathroom...with the possibility of two extra small office spaces for your admin/staff. All of this space is contiguous for a cohesive turn-key professional business presence that will surly impress your clients. Use of conference room included along with a receptionist on the first floor with a general waiting room to meet and greet your clients. Conveniently located next to train station and in the heart of Merrick Village with plenty of parking right behind building. This space is perfect for a professional: law, accounting, mortgage professional or similar industry. Note: Additional space use TBD -- inquire within. (1st floor handicap conference room also available for client convenience.)" +"AttributionContact": "516-804-9000" +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Professional/Office" +"BuyerOfficeAOR": "LIBOR" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-05T18:55:48.939648+00:00" +"CumulativeDaysOnMarket": 48 +"DaysOnMarket": 147 +"Directions": "Located on the corner of Merrick Ave & Fisher Ave. just north of Sunrise Highway" +"ExpirationDate": "2026-12-01" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeasableArea": 500 +"LeaseAmountFrequency": "Annually" +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-491-1775" +"ListAgentEmail": "realtyprosplus@gmail.com" +"ListAgentKey": "326184865" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115113" +"ListOfficePhone": "516-804-9000" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2026-02-05" +"MajorChangeTimestamp": "2026-04-23T14:21:24Z" +"MajorChangeType": "Back On Market" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-02-05" +"OriginalEntryTimestamp": "2026-02-05T18:51:41Z" +"OriginalListPrice": 1450 +"OriginatingSystemModificationTimestamp": "2026-04-23T14:21:24Z" +"OwnerName": "Krohn, Rosenblum & Rosenblum" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-02-10T02:33:36Z" +"PhotosCount": 17 +"PostalCity": "Merrick" +"PriceChangeTimestamp": "2026-02-05T18:51:41Z" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516 491-1775" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-23T14:21:24Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Merrick Ave" +"StreetNumber": "25" +"StreetNumberNumeric": "25" +"SyndicateTo": array:3 [ …3] +"TaxAnnualAmount": "73000" +"TaxYear": "2025" +"UnitNumber": "25" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_ElevatorYN": "0" +"KEY_SqFtOffice": "500" +"KEY_UsableArea": "500.00" +"KEY_CurrentPrice": "1450.00" +"KEY_PermittedUses": "Office" +"KEY_LeasePriceUnit": "Total" +"KEY_PreviousStatus": "Pending" +"KEY_SecurityDeposits": "1450" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Back On Market" +"KEY_SourceSystemModificationTimestamp": "2026-02-05T13:14:38.170" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "2.90000" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "2.90000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423475140')" +"provider_name": "One Key" +"Media": array:17 [ …17] +"ID": "29994" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5306 +post_id: "29993" +post_author: 1 +"ListingKey": "KEY423459074" +"ListingId": "958397" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-06-06T07:04:37Z" +"RFModificationTimestamp": "2026-06-06T07:11:36Z" +"ListPrice": 1549000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1959.0 +"BuildingAreaTotal": 1959.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2077 Byron Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6559335 +"Longitude": -73.5458057 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Seth B. Levy" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "160761" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "CALLING ALL MERRICK INVESTORS & HOMEOWNERS! TAKE ADVANTAGE OF THIS RARE OPPORTUNITY TO BUILD 2 CUSTOM HOMES IN MERRICK’S LINDENMERE ESTATES!! LOCATED CLOSE TO THE LIRR, MERRICK VILLAGE, PARKS, BEACHES, MARINAS & WATERFRONT DINING, THIS PROPERTY CAN BE DIVIDED TO ACCOMMODATE 2 BRAND NEW HOMES ON 6,000 SQ. FT. LOTS EACH OR 1 BRAND NEW HOME ON A SPRAWLING 12,000 SQ. FT. ESTATE STYLE PROPERTY!" +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BodyType": array:1 [ …1] +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-02-05T18:01:56.287646+00:00" +"CumulativeDaysOnMarket": 121 +"DaysOnMarket": 121 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-06" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-546-6300" +"ListAgentEmail": "slevy@signaturepremier.com" +"ListAgentKey": "326172773" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-02-05" +"LivingAreaSource": "Public Records" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.2755 +"LotSizeSquareFeet": 12001 +"MajorChangeTimestamp": "2026-06-06T04:11:34Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:3 [ …3] +"MlsStatus": "Expired" +"OffMarketDate": "2026-06-06" +"OnMarketDate": "2026-02-05" +"OriginalEntryTimestamp": "2026-02-05T18:00:14Z" +"OriginalListPrice": 1700000 +"OriginatingSystemModificationTimestamp": "2026-06-06T04:11:34Z" +"OwnerName": "Kudler" +"ParcelNumber": "2089-63-135-00-0839-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-02-05T18:01:36Z" +"PhotosCount": 4 +"PostalCity": "Merrick" +"PostalCodePlus4": "5033" +"PreviousListPrice": 1599000 +"PriceChangeTimestamp": "2026-05-27T15:20:12Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-528-1737" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-06T04:11:34Z" +"StreetName": "Byron" +"StreetNumber": "2077" +"StreetNumberNumeric": "2077" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17909.55" +"TaxAssessedValue": 608 +"TaxYear": "2025" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1549000.00" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "1959.00" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "790.70955" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5622504.5372" +"KEY_RATIO_CurrentPrice_By_LivingArea": "790.70955" +"KEY_SourceSystemModificationTimestamp": "2026-02-04T11:53:23.560" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "790.70955" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.91118" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "790.70955" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423459074')" +"provider_name": "One Key" +"Media": array:4 [ …4] +"ID": "29993" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5307 +post_id: "30643" +post_author: 1 +"ListingKey": "KEY423417620" +"ListingId": "957150" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-01T22:12:36Z" +"RFModificationTimestamp": "2026-04-01T22:15:05Z" +"ListPrice": 749900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 1648.0 +"BuildingAreaTotal": 1648.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "56 Beach Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6517836 +"Longitude": -73.5557472 +"YearBuilt": 1931 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gus Lafkas" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "148804" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this spacious 5-Bedroom , 2-Bath Bath Colonial featuring classic stucco exterior and plenty of curb appeal on a desirable corner property. Enjoy the convenience of a detached garage and ample outdoor space for gardening, play, or future expansion.\n Inside, you’ll find generous living areas perfect for family living and entertaining. The home’s layout offers flexibility for a home office, playroom, or guest space. Natural light fills the rooms, creating a warm and inviting atmosphere.\n Located near transportation, this home provides easy access to commuting options, shopping, dining, and more — an ideal blend of suburban comfort and commuter convenience. Don’t miss out on this exceptional property! """ +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-01T22:14:51.556833+00:00" +"CrossStreet": "Bernard St" +"Directions": "Merrick Rd to Beach" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-31" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-445-0657" +"ListAgentEmail": "guslafkasrealestate@yahoo.com" +"ListAgentKey": "326161645" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-01-31" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.0964 +"LotSizeSquareFeet": 4200 +"MajorChangeTimestamp": "2026-04-01T22:11:17Z" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-04-01" +"OriginalEntryTimestamp": "2026-04-01T22:11:17Z" +"OriginalListPrice": 749900 +"OriginatingSystemModificationTimestamp": "2026-04-01T22:11:17Z" +"OwnerName": "56 Beach Drive Llc" +"ParcelNumber": "2089-62-007-00-0006-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-03-26T12:59:36Z" +"PhotosCount": 9 +"PostalCity": "Merrick" +"PostalCodePlus4": "4595" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5164450657" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-01T22:11:17Z" +"StreetName": "Beach" +"StreetNumber": "56" +"StreetNumberNumeric": "56" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13225" +"TaxAssessedValue": 449 +"TaxYear": "2024" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial,Partially Finished" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "749900.00" +"KEY_ShowingTimeFlagYN": "1" +"KEY_LivingAreaSearchSqFt": "1648.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "455.03641" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7779045.6432" +"KEY_RATIO_CurrentPrice_By_LivingArea": "455.03641" +"KEY_SourceSystemModificationTimestamp": "2026-01-31T16:04:22.810" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "455.03641" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "455.03641" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423417620')" +"provider_name": "One Key" +"short_address": "Hempstead, New York 11566, USA" +"Media": array:9 [ …9] +"DaysOnMarket": 122 +"ID": "30643" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5308 +post_id: "29942" +post_author: 1 +"ListingKey": "KEY423407905" +"ListingId": "956874" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-09T20:42:36Z" +"RFModificationTimestamp": "2026-06-09T20:46:19Z" +"ListPrice": 1599000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3000.0 +"BuildingAreaTotal": 6820.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2043 Ripley, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6577567 +"Longitude": -73.5485189 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ken I. Deutsch CBR GRI" +"ListOfficeName": "Deutsch Realty Inc" +"ListAgentMlsId": "124451" +"ListOfficeMlsId": "KDEU01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Located in the heart of Merrick lies in a cul-de-sac this beautiful 4 bedroom 3 1/2 bath plus 2 dens flanked by a large pool with plenty of deck space to enjoy outdoor living. Top of the line appliances such as a Wolf gas burner, Wolf double oven, Wolf microwave, trash compactor, sub-Zero fridge and more. Open floor plan with multiple places to dine and entertain. Walking distance to the train. This home has been maintained to the highest level within the last 6 years improvements include a new roof, insulation, siding, gutters with gutter guard protection screens, new front entry door and 2 central air conditioning units. Most recently on 6/2026 the home has completed a brand new yard/ pool remodel. The updates include new pool liner and cover, retaining wall replacement, new PVC fence, landscaping, sprinkler system, a new well that supports the new sprinkler system. The 3rd AC unit was replaced at this time as well. This gem is ready to move in and enjoy." +"Appliances": array:11 [ …11] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-931-8600" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "972-672-9909" +"CoListAgentEmail": "brenda@deutschrealty.com" +"CoListAgentFullName": "Brenda Donnelly" +"CoListAgentKey": "422961945" +"CoListAgentMlsId": "505840" +"CoListOfficeKey": "326112832" +"CoListOfficeMlsId": "KDEU01" +"CoListOfficeName": "Deutsch Realty Inc" +"CoListOfficePhone": "516-931-8600" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-01-30T19:42:18.968322+00:00" +"CumulativeDaysOnMarket": 121 +"DaysOnMarket": 174 +"DirectionFaces": "South" +"Directions": "See map quest" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-01-30" +"ExteriorFeatures": array:3 [ …3] +"Fencing": array:3 [ …3] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:9 [ …9] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-931-8600" +"ListAgentEmail": "ken@deutschrealty.com" +"ListAgentKey": "326139417" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112832" +"ListOfficePhone": "516-931-8600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-01-30" +"LivingAreaSource": "Other" +"LotFeatures": array:6 [ …6] +"LotSizeAcres": 0.1566 +"LotSizeDimensions": "42X107" +"LotSizeSquareFeet": 6820 +"MajorChangeTimestamp": "2026-02-09T21:37:23Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-02-08" +"OriginalEntryTimestamp": "2026-01-30T19:39:01Z" +"OriginalListPrice": 1348000 +"OriginatingSystemModificationTimestamp": "2026-06-09T20:40:46Z" +"OtherStructures": array:2 [ …2] +"OwnerName": "withheld" +"ParcelNumber": "2089-56-176-00-0224-0" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-06-09T15:48:36Z" +"PhotosCount": 42 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PreviousListPrice": 1348000 +"PriceChangeTimestamp": "2026-02-09T21:37:23Z" +"RoomsTotal": "10" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-578-2617" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-08T05:30:59Z" +"StreetName": "Ripley" +"StreetNumber": "2043" +"StreetNumberNumeric": "2043" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "19284" +"TaxYear": "2026" +"Utilities": array:2 [ …2] +"VirtualTourURLBranded": "https://jumpvisualtours.com/489735" +"VirtualTourURLUnbranded": "https://jumpvisualtours.com/r/489735" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_TaxSource": "Other" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1599000.00" +"KEY_PreviousStatus": "Coming Soon" +"KEY_DistanceToTrain": "0.05" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Increase" +"KEY_LivingAreaSearchSqFt": "3000.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_ShowingContactPhone2": "972-672-9909" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "533.00000" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "10210727.9693" +"KEY_RATIO_CurrentPrice_By_LivingArea": "533.00000" +"KEY_SourceSystemModificationTimestamp": "2026-01-30T13:41:31.453" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "234.45748" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.18620" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "234.45748" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423407905')" +"provider_name": "One Key" +"Media": array:42 [ …42] +"ID": "29942" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5309 +post_id: "29924" +post_author: 1 +"ListingKey": "KEY423378725" +"ListingId": "956035" +"PropertyType": "Residential Lease" +"PropertySubType": "Duplex" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-01-30T07:10:38Z" +"RFModificationTimestamp": "2026-01-30T07:16:15Z" +"ListPrice": 2900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 868.0 +"BuildingAreaTotal": 1968.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": null +"Coordinates": array:2 [ …2] +"Latitude": null +"Longitude": null +"YearBuilt": 1970 +"InternetAddressDisplayYN": false +"FeedTypes": "IDX" +"ListAgentFullName": "Baoqi Dong" +"ListOfficeName": "Han Tang Realty Inc." +"ListAgentMlsId": "62716" +"ListOfficeMlsId": "HANTAN" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this bright and spacious duplex apartment in desirable North Merrick.\n Offering approximately 900 square feet across two levels with a private entrance.\n \n The first floor features a comfortable living room, dining area, full kitchen, one bedroom, and a full bathroom.\n Upstairs offers a generously sized primary bedroom with its own private full bathroom, creating a perfect separation of living and sleeping spaces.\n \n Located within a great School Districts.\n Conveniently situated just a 5–8 minute drive to the LIRR, providing an easy commute.\n \n All utilities included — water, electricity, gas, and Wi-Fi.\n Unfurnished. One-year lease minimum.\n Credit and income verification required.\n \n Available for immediate occupancy.\n Easy to show — don’t miss this opportunity. """ +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "646-573-3603" +"AvailabilityDate": "2026-01-28" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:2 [ …2] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-01-28T15:21:15.314487+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 1 +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"EntryLevel": 1 +"ExpirationDate": "2026-01-29" +"FoundationDetails": array:1 [ …1] +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "12 Months" +"ListAOR": "HGAR" +"ListAgentAOR": "HGAR" +"ListAgentDirectPhone": "646-573-3603" +"ListAgentEmail": "Queenie3270@gmail.com" +"ListAgentKey": "102168771" +"ListOfficeAOR": "HGAR" +"ListOfficeKey": "23145787" +"ListOfficePhone": "718-513-1111" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2026-01-28" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1535 +"LotSizeSquareFeet": 6688 +"MajorChangeTimestamp": "2026-01-29T20:01:02Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2026-01-29" +"OnMarketDate": "2026-01-28" +"OriginalEntryTimestamp": "2026-01-28T15:14:50Z" +"OriginalListPrice": 2900 +"OriginatingSystemModificationTimestamp": "2026-01-29T20:01:02Z" +"OwnerName": "XIAOCHEN ZHOU" +"ParcelNumber": "2089-56-140-00-0352-0" +"ParkingFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-01-29T03:28:36Z" +"PhotosCount": 8 +"PostalCity": "Merrick" +"PostalCodePlus4": "2472" +"PriceChangeTimestamp": "2026-01-28T15:14:50Z" +"RentIncludes": "Cable TV,Electricity,Gas,Hot Water,See Remarks,Water" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "6466410639" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-29T20:01:02Z" +"StreetName": "Abbot" +"StreetNumber": "2005" +"StreetNumberNumeric": "2005" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "See Remarks" +"KEY_SmokingYN": "0" +"KEY_RentSpreeYN": "1" +"KEY_CurrentPrice": "2900.00" +"KEY_RentSpreeURL": "https://apply.link/m0xdbwE" +"KEY_PreviousStatus": "Active" +"KEY_SecurityDeposits": "2900" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "868.00" +"KEY_RATIO_ListPrice_By_LivingArea": "3.34101" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "18892.5081" +"KEY_RATIO_CurrentPrice_By_LivingArea": "3.34101" +"KEY_SourceSystemModificationTimestamp": "2026-01-28T10:14:50.547" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.47358" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.47358" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423378725')" +"provider_name": "One Key" +"Media": array:8 [ …8] +"ID": "29924" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5310 +post_id: "29701" +post_author: 1 +"ListingKey": "KEY423113503" +"ListingId": "947786" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-01-21T07:07:41Z" +"RFModificationTimestamp": "2026-01-21T07:10:43Z" +"ListPrice": 1799999.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3600.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "217 Bayview Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.657605 +"Longitude": -73.5457486 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Luis Barreto" +"ListOfficeName": "Compass Greater NY LLC" +"ListAgentMlsId": "219746" +"ListOfficeMlsId": "CMPA07" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Discover modern elegance in this exquisite new construction home located in the beautiful town of Merrick!. This 3600 square foot stunning residence offers 5 spacious bedrooms and 4.5 luxurious bathrooms, providing ample space for comfort and privacy. The home's design features a two-car garage and a versatile basement with a separate entrance, perfect for personalized use. Nestled on an expansive 75 by 150 lot, this property offers a serene setting while being conveniently close to restaurants, LIRR, and vibrant shopping destinations. The heart of this home is the gourmet kitchen, featuring custom cabinetry, a pot filler, a farm sink, and a massive custom quartz island—ideal for entertaining or casual meals. The primary bedroom offers a tray ceiling with two walk-in closets and a custom bathroom, equipped with double sinks, a stand-up shower, and a soaker tub. With plenty of time to customize every detail to your liking, this home is a rare opportunity to create your dream oasis. Embrace the chance to tailor this elegant modern masterpiece to your unique lifestyle!" +"Appliances": array:9 [ …9] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "917-971-4627" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 4 +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "HGAR" +"BuyerAgentDirectPhone": "000-000-0000" +"BuyerAgentFullName": "Unrepresented Buyer" +"BuyerAgentKey": "421786246" +"BuyerAgentMlsId": "347752" +"BuyerOfficeAOR": "HGAR" +"BuyerOfficeKey": "1262827" +"BuyerOfficeMlsId": "888888" +"BuyerOfficeName": "Buyer Representation Office" +"BuyerOfficePhone": "000-000-0000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-01-03T16:39:35.430236+00:00" +"CumulativeDaysOnMarket": 166 +"DaysOnMarket": 17 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-07-03" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:4 [ …4] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:23 [ …23] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ …3] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "917-971-4627" +"ListAgentEmail": "luis.barreto@compass.com" +"ListAgentKey": "326228733" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110404" +"ListOfficePhone": "516-764-6060" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-01-03" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.26 +"LotSizeDimensions": "75 x 150" +"LotSizeSquareFeet": 11250 +"MajorChangeTimestamp": "2026-01-20T16:54:37Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-01-20" +"OnMarketDate": "2026-01-03" +"OriginalEntryTimestamp": "2026-01-03T16:37:14Z" +"OriginalListPrice": 1799999 +"OriginatingSystemModificationTimestamp": "2026-01-20T16:54:37Z" +"OwnerName": "not available" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-01-03T16:50:36Z" +"PhotosCount": 4 +"PostalCity": "Merrick" +"PriceChangeTimestamp": "2026-01-03T16:37:14Z" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-01-20" +"RoomsTotal": "13" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-20T16:54:37Z" +"StreetName": "Bayview" +"StreetNumber": "217" +"StreetNumberNumeric": "217" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "4995" +"TaxYear": "2025" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"KEY_Attic": "Full,Pull Stairs,Unfinished" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1799999.00" +"KEY_ContractPrice": "1675000.00" +"KEY_WaterAccessYN": "0" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "3600.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "499.99972" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6923073.0769" +"KEY_RATIO_CurrentPrice_By_LivingArea": "499.99972" +"KEY_SourceSystemModificationTimestamp": "2026-01-03T11:37:14.850" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423113503')" +"provider_name": "One Key" +"Media": array:4 [ …4] +"ID": "29701" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5311 +post_id: "29694" +post_author: 1 +"ListingKey": "KEY423109938" +"ListingId": "947687" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-07-04T07:02:37Z" +"RFModificationTimestamp": "2026-07-04T07:04:51Z" +"ListPrice": 2399999.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 1 +"BedroomsTotal": 8.0 +"LotSizeArea": 0 +"LivingArea": 6818.0 +"BuildingAreaTotal": 8400.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2829 Frankel Boulevard, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6535185 +"Longitude": -73.538364 +"YearBuilt": 1991 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Natan Amos" +"ListOfficeName": "Resource Realty Group" +"ListAgentMlsId": "190248" +"ListOfficeMlsId": "DAAR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ A one of a kind masterpiece of unique architecture.\n \n Waterfront home, where luxury meets comfort and breathtaking views!\n \n The home boasts a magnificent indoor pool that is designed for both relaxation and recreation. The pool is adorned with sparkling tiles and offers a serene oasis right within the comfort of your home. \n \n The oversized kitchen in this home is a culinary haven. It is meticulously designed with ample space for meal preparation and entertaining. The countertops, crafted from beautiful granite, provide a luxurious touch and plenty of room for cooking and serving. State-of-the-art appliances.\n \n Convenience is paramount in this home, which is why it includes not just one, but two well-equipped laundry rooms. These rooms are equipped with high-quality washers and dryers, allowing for efficient and organized laundry care. \n \n To accommodate your vehicles and provide secure parking, this home features a spacious two-car garage. This garage offers ample space for your cars, along with extra storage room for tools, equipment, or recreational gear. \n \n In this home, you'll find a spacious cedar closet. This closet is custom-built with high-quality cedar wood, which not only exudes a pleasant aroma \n \n Enhancing both warmth and ambiance, this home features two gas working fireplaces. These fireplaces are designed to create a cozy atmosphere and serve as focal points in both the formal living room and the office. \n \n This home includes formal living and dining rooms that exude elegance and sophistication. The formal living room is tastefully decorated with beautiful hardwood floors, creating a warm and inviting space for relaxation and socializing. The formal dining room, adjacent to the living room, offers a refined setting for hosting formal dinners and special occasions, complemented by the stunning waterfront views.\n \n The office in this home is a dedicated space for work or study. \n \n Throughout this home, you'll find a seamless blend of hardwood and granite floors. The hardwood floors exude timeless elegance and add warmth to the living spaces, while the granite floors in the kitchen and bathrooms provide a luxurious touch. \n \n Indulge in ultimate relaxation and rejuvenation with the steam shower this home provides. This luxurious feature allows you to unwind and melt away the stress of the day. \n \n The walk-in closet in this home is designed to accommodate your storage needs while providing a touch of luxury. This spacious closet offers ample room for organizing and displaying your wardrobe, shoes, and accessories. With custom-built ins.\n \n Too much to list this property is a must see!! """ +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "917-654-9835" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 5 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "HGAR" +"BuyerAgentDirectPhone": "000-000-0000" +"BuyerAgentFullName": "Non Member-MLS" +"BuyerAgentKey": "1262689" +"BuyerAgentMlsId": "8888" +"BuyerOfficeAOR": "HGAR" +"BuyerOfficeKey": "1262827" +"BuyerOfficeMlsId": "888888" +"BuyerOfficeName": "Buyer Representation Office" +"BuyerOfficePhone": "000-000-0000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-01-02T21:19:10.140284+00:00" +"CumulativeDaysOnMarket": 182 +"DaysOnMarket": 182 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-12-31" +"FireplaceYN": true +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:22 [ …22] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-341-8471" +"ListAgentEmail": "natanamos@resourcerealtyny.com" +"ListAgentKey": "326200195" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110639" +"ListOfficePhone": "917-654-9835" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-01-02" +"LivingAreaSource": "Cubi Casa" +"LotSizeAcres": 0.3719 +"LotSizeSquareFeet": 16200 +"MajorChangeTimestamp": "2026-07-03T11:21:18Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-07-03" +"OnMarketDate": "2026-01-02" +"OriginalEntryTimestamp": "2026-01-02T21:17:15Z" +"OriginalListPrice": 2399999 +"OriginatingSystemModificationTimestamp": "2026-07-03T11:21:18Z" +"OwnerName": "Lois David" +"ParcelNumber": "2089-63-129-00-0096-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-01-02T21:18:36Z" +"PhotosCount": 46 +"PoolFeatures": array:2 [ …2] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "5431" +"PurchaseContractDate": "2026-07-03" +"RoomsTotal": "20" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-07-03T11:21:18Z" +"StreetName": "Frankel" +"StreetNumber": "2829" +"StreetNumberNumeric": "2829" +"StreetSuffix": "Boulevard" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "40918.76" +"TaxAssessedValue": 1567 +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:4 [ …4] +"WaterfrontYN": true +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "2399999.00" +"KEY_ContractPrice": "2250000.00" +"KEY_PreviousStatus": "Active" +"KEY_NumberOfKitchens": "2" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_BuyerRepresentation": "Buyer's Agent" +"KEY_LivingAreaSearchSqFt": "6818.00" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "352.00924" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6453344.9852" +"KEY_RATIO_CurrentPrice_By_LivingArea": "352.00924" +"KEY_SourceSystemModificationTimestamp": "2026-01-02T16:11:46.937" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "285.71417" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "285.71417" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423109938')" +"provider_name": "One Key" +"Media": array:46 [ …46] +"ID": "29694" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5312 +post_id: "29685" +post_author: 1 +"ListingKey": "KEY423089631" +"ListingId": "947275" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2026-02-26T07:04:38Z" +"RFModificationTimestamp": "2026-02-26T07:08:30Z" +"ListPrice": 979000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2230.0 +"BuildingAreaTotal": 2230.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2415 Babylon Turnpike, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6575157 +"Longitude": -73.5569395 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rodolpho V. Miller" +"ListOfficeName": "Real Broker NY LLC" +"ListAgentMlsId": "130762" +"ListOfficeMlsId": "HOWO09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this stunning Colonial nestled in the heart of Merrick and located in the highly sought-after Merrick School District. This true dream home features 4 bedrooms and 2.5 baths, including 3 large bedrooms and a spacious 4th bedroom, plus a private primary suite with its own master bathroom. The open-concept first floor is filled with natural light and showcases an updated kitchen with modern appliances and a generous living/dining area perfect for entertaining.\n \n Enjoy year-round comfort with central air and the efficiency of solar panels. Additional highlights include a full finished basement, an attached 1-car garage, and a backyard oasis featuring a full legal in-ground pool and newly installed pavers—creating the perfect outdoor living and entertainment space for family gatherings, BBQs, and summer fun.\n \n This beautiful home checks all the boxes: comfort, space, location, and lifestyle. A perfect place to raise your family. This one will not last! """ +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-427-7271" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-12-31T23:19:25.950895+00:00" +"CumulativeDaysOnMarket": 43 +"DaysOnMarket": 43 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-30" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "718-962-4781" +"ListAgentEmail": "info@sellyournyhome.com" +"ListAgentKey": "326145015" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112141" +"ListOfficePhone": "516-427-7271" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-12-31" +"LotSizeAcres": 0.1792 +"LotSizeSquareFeet": 7807 +"MajorChangeTimestamp": "2026-02-25T18:30:52Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Hold" +"OffMarketDate": "2026-02-25" +"OnMarketDate": "2026-01-13" +"OriginalEntryTimestamp": "2025-12-31T23:14:46Z" +"OriginalListPrice": 899999 +"OriginatingSystemModificationTimestamp": "2026-02-25T18:30:52Z" +"OwnerName": "Salvatore & Rose Adela Strano" +"ParcelNumber": "2089-55-138-00-0531-0" +"ParkingFeatures": array:3 [ …3] +"ParkingTotal": "2" +"PhotosChangeTimestamp": "2026-01-13T15:34:36Z" +"PhotosCount": 32 +"PoolFeatures": array:2 [ …2] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "4206" +"PreviousListPrice": 899999 +"PriceChangeTimestamp": "2026-02-05T22:44:53Z" +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "7189624781" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-25T18:30:52Z" +"StreetName": "Babylon" +"StreetNumber": "2415" +"StreetNumberNumeric": "2415" +"StreetSuffix": "Turnpike" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "18850.54" +"TaxAssessedValue": 621 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=1ZnPZAv8Xdo&mls=1" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Crawl" +"KEY_HoldDate": "2026-02-25" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "979000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "0" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "2230.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "439.01345" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5463169.6429" +"KEY_RATIO_CurrentPrice_By_LivingArea": "439.01345" +"KEY_SourceSystemModificationTimestamp": "2025-12-31T14:29:07.870" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "439.01345" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.08778" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "439.01345" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423089631')" +"provider_name": "One Key" +"Media": array:32 [ …32] +"ID": "29685" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5313 +post_id: "29606" +post_author: 1 +"ListingKey": "KEY422996377" +"ListingId": "944739" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-06-18T07:03:36Z" +"RFModificationTimestamp": "2026-06-18T07:05:36Z" +"ListPrice": 999000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1603.0 +"BuildingAreaTotal": 1603.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "80 Dobson Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6578137 +"Longitude": -73.5617886 +"YearBuilt": 1929 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Afshin Termechi" +"ListOfficeName": "Keller Williams Landmark II" +"ListAgentMlsId": "113751" +"ListOfficeMlsId": "KLRW01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this well-maintained and inviting Charming Cape-style home with Stained Glass Windows, located in the heart of Merrick, Long Island. Offering timeless character and practical living space, this home features **4 generously sized bedrooms and 2 full bathrooms**, ideal for flexible living arrangements.\n \n The main level offers a **sunlit living room with a classic wood burning fireplace**, a **formal dining room** perfect for gatherings, and an **eat-in kitchen** with plenty of room to cook and gather the old-fashioned way.\n \n Downstairs, a **full finished basement with a separate entrance** provides valuable bonus space—perfect for extended family, a home office, or recreation area.\n \n Additional highlights include a **detached one-car garage**, **private driveway**, and a pleasant yard that’s just the right size—easy to maintain, easy to enjoy. """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "347-846-1200" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-12-17T15:34:16.297854+00:00" +"CumulativeDaysOnMarket": 183 +"DaysOnMarket": 183 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-18" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "347-846-1200" +"ListAgentEmail": "afshin@adasells.com" +"ListAgentKey": "326129554" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112906" +"ListOfficePhone": "347-846-1200" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-12-17" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1322 +"LotSizeDimensions": "61 X 102" +"LotSizeSquareFeet": 5760 +"MajorChangeTimestamp": "2026-06-18T04:11:04Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:3 [ …3] +"MlsStatus": "Expired" +"OffMarketDate": "2026-06-18" +"OnMarketDate": "2025-12-17" +"OriginalEntryTimestamp": "2025-12-17T15:30:04Z" +"OriginalListPrice": 999000 …47 } 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5314 …135} 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5315 …137} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5316 …150} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5317 …101} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5318 …155} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5319 …146} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5320 …131} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5322 …130} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5291 …135} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5290 …130} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5289 …118} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5288 …148} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5287 …123} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5286 …135} ] +success: true +page_size: 32 +page_count: 7 +count: 193 +after_key: "" } "RF Response Time" => "0.12 seconds" ] ]