Begin your home search journey in Merrick, NY by browsing available listings in one place. This page is dedicated to showcasing current homes for sale, complete with essential details such as property type, Price filter, and zip code search. Whether you’re searching for your first home or your next upgrade, Merrick offers a variety of options to meet your needs. View homes with pools, renovated kitchens, or generous backyard space—all with current pricing and images. Start exploring the Merrick housing market today and filter your search based on your must-have features, budget, and lifestyle goals.
Our simple, step-by-step process ensures a smooth experience for buying new property without any worries or hustle.
Go through the our all listings and find the ideal home that is relevant for your requirements.
Click on the listing you like and then fill out the form to get start with your buying journey.
We guide buyers through offers and agreements to secure the best outcomes.
We handle all paperwork, ensure a smooth closing process, and support you through your next steps.
Our simple, step-by-step process ensures a smooth experience for buying new property without any worries or hustle.
We know Merrick NY street by street — not just by ZIP code. From districts to commute routes, we help you buy smarter based on real neighborhood insight.
You won’t find any sales pressure here. We focus on what works best for you, offering honest input so you can make confident, informed choices.
You won’t be left waiting on answers. We stay connected through every step of the process, so your questions get real replies — not delays.
We tap into local networks to get early access to listings — giving you a head start in a competitive market.
From inspections to paperwork, we manage the chaos so you can focus on the fun part — finding a place you’ll love.
Tight schedule? Need to tour after hours or on weekends? We’re flexible. We work how and when it’s convenient for you.
It’s not just about buying now — we’ll help you choose a home that fits future needs too, like family growth or property value trends.
We’re not here to just close a deal. We look out for your best interest like we would for our own family. Every decision is made with care.
Read what our clients have to say about their experience with us
I highly recommend Kaya Homes if you are looking to buy or sell your home. My home was sold for over ask within 1 week! The process was so simple and easy. Avi had a professional photographer photograph our home and has excellent marketing strategies which led to a speedy transaction. Thank you !!!
Bad Services.
KAYA Homes, and specifically Kamy, is a real estate business with a heart. Before I signed a contract Kamy gave me months of her time, business acumen and understanding. I have bought/sold my homes over many decades. Never have I known a realtor to be so incredibly kind. Everything about how KAYA Homes conduct their business is above reproach.
I had the absolute pleasure of working with Kamy when leasing my new apartment, and I couldn't be happier with the experience! She was fantastic to work with, simplifying the rental process and providing thorough explanations every step of the way. Highly recommend!
This is the third year im using Kaya Homes for my rental, they are very professional. They walk you through everything from start to finish. The owner Kami is awesome!! She is very responsive A+ I highly recommend kaya homes!!
We started our journey with Kaya homes a while back when my husband met Kamy. He knew instantly that we found the right ones to help us with purchasing a new home. Kamy is highly responsive, thoughtful, considerate and very professional on her approach with finding you the right home. We wanted to stay in the area and with such a crazy market, I didn't think it would be possible for us to find our home, but we did. Kamy's reassured us and said we will find your home and we did. Thank you Kamy and also meeting Izzy was a bonus, great family owned business, truly you will not be disappointed. If you are looking to rent, own or sell give them a call.
Absolutely wonderful to work with! I highly suggest if you are looking or selling she is definitely your go to!
Amazing experience with Kaya Homes. She was very helpful and found us our dream home as fast as anyone could wish for!
WOW! Kamy went above and beyond to find us an apartment, my lease was over and I needed to move ASAP and couldn’t find any rentals but when I got in contact with Kamy at Kaya Homes she casted all my worries and stress away. I’ve worked with other realtors in the past which was ok but Kaya Homes over exceeded all of my expectations. Kamy was able to find us a beautiful contemporary apartment in the neighborhood that I appointed and that fit right in our price range within a month we moved in. Kamy is extremely kind, friendly, transparent professional, communicative and easy to reach to answer any of our questions at all times. In addition, since we’ve moved the landlord continues to maintain the apartment beautifully: they provide a cleaning service who comes in to clean inside and outside the complex, landscaper comes weekly, the garbage is pick up 2-3x a week, if there’s ever any issue or something needs fixing they send someone the next day which is a plus because you know they CARE AND APPRECIATE THEIR TENANTS. I recommend Kaya Homes to all my friends & family and to anyone who needs a realtor because they are simply the VERY BEST IN THE BUSINESS. Thank you again Kamy.
I had the pleasure of working on my home selling with Kaya homes and specialty with Kamy Roditi who is a very professional and reliable person. Kamy worked very on my transaction with a fair and quick way and honestly without her my home would not have been sold as fast and for the best possible price as it was. I would highly recomand Kaya homes and Kamy for any Real Estate and business venture, selling and buying Real Estate .
If you are in the market for a new home, I highly recommend going to see Kamy Roditi @ Kaya Homes. She is one of the most knowledgeable realtors I've ever met in the industry hands down. She's honest, trustworthy, responsive and an all around pleasure to work with. She worked diligently to help find the perfect house for my family and smoothly guided me through the process by answering all of my questions thoroughly. Buying a new home can be stressful, but it doesn't have to be if your lucky enough to work with Kamy Roditi. You'll be in good hands, I promise!
I thought about selling my house myself and I’m so glad I didn’t. Kaya Homes was a total blessing for me, the buyers of my home were beyond difficult and they handled every step for me beyond my expectations. They took the stress off of me entirely. I’d highly recommend them to anyone. Thank you again Kaya Homes!!
Highly recommend the team at Kaya Homes. The team is not only knowledgeable but also provides great advice for all real estate needs. Weather your looking to buy, sell, rent or get advice, Kaya homes should be your first call.
array:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=32&$skip=128&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (City eq 'Merrick' or PostalCity eq 'Merrick')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5108 +items: array:32 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5122 +post_id: "29278" +post_author: 1 +"ListingKey": "KEY422580639" +"ListingId": "932877" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-01-31T07:06:38Z" +"RFModificationTimestamp": "2026-01-31T07:13:09Z" +"ListPrice": 679000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1226.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "43 Wynsum Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6626707 +"Longitude": -73.5472105 +"YearBuilt": 1927 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Armen H. Caprielian" +"ListOfficeName": "LAFFEY REAL ESTATE" +"ListAgentMlsId": "154032" +"ListOfficeMlsId": "LRE09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to 43 Wynsum Avenue in Merrick! The perfect opportunity for builders, investors, or anyone eager to create their dream home. Ideally situated in a beautiful Merrick neighborhood, this property offers endless potential to customize, expand, or rebuild to your exact vision. Enjoy the convenience of nearby shopping, dining, parks, and public transportation—all just moments from your doorstep. Whether you’re looking to invest or settle down in a welcoming community, this location provides the perfect balance of suburban tranquility and accessibility. Don’t miss your chance this home won’t last!" +"Appliances": array:3 [ …3] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-625-0944" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-528-2630" +"BuyerAgentEmail": "michcerv@aol.com" +"BuyerAgentFullName": "Michelle S. Cervoni CBR" +"BuyerAgentKey": "326211419" +"BuyerAgentMlsId": "201936" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115604" +"BuyerOfficeMlsId": "SJP02" +"BuyerOfficeName": "Stephen Joseph Properties" +"BuyerOfficePhone": "516-809-9288" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-06T19:36:48.985419+00:00" +"CrossStreet": "Sunrise Highway" +"CumulativeDaysOnMarket": 84 +"DaysOnMarket": 84 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-05-06" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-625-0944" +"ListAgentEmail": "acaprielian@laffeyre.com" +"ListAgentKey": "326166571" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113309" +"ListOfficePhone": "516-625-0944" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-11-06" +"ListingTerms": "Contract" +"LivingAreaSource": "Public Records" +"LotFeatures": array:2 [ …2] +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-01-30T18:53:15Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-01-30" +"OnMarketDate": "2025-11-06" +"OriginalEntryTimestamp": "2025-11-06T19:31:53Z" +"OriginalListPrice": 679000 +"OriginatingSystemModificationTimestamp": "2026-01-30T18:53:15Z" +"OwnerName": "Lederman" +"ParcelNumber": "2089-56-182-00-0044-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-11-06T19:33:58Z" +"PhotosCount": 23 +"PostalCity": "Merrick" +"PostalCodePlus4": "4035" +"PurchaseContractDate": "2026-01-29" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "917-767-8545" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-30T18:53:15Z" +"StreetName": "Wynsum" +"StreetNumber": "43" +"StreetNumberNumeric": "43" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14449.05" +"TaxAssessedValue": 476 +"TaxBlock": "182" +"TaxLot": "44" +"TaxYear": "2025" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "56" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "679000.00" +"KEY_ContractPrice": "630000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1226.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-625-0944" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "553.83361" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4931009.4408" +"KEY_RATIO_CurrentPrice_By_LivingArea": "553.83361" +"KEY_SourceSystemModificationTimestamp": "2025-11-06T11:44:20.650" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422580639')" +"provider_name": "One Key" +"Media": array:23 [ …23] +"ID": "29278" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5124 +post_id: "29266" +post_author: 1 +"ListingKey": "KEY422576414" +"ListingId": "932742" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-01-12T07:05:38Z" +"RFModificationTimestamp": "2026-01-12T07:06:05Z" +"ListPrice": 879000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 2236.0 +"BuildingAreaTotal": 2236.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1911 Carroll Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.670136 +"Longitude": -73.5594145 +"YearBuilt": 1951 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Oakar Reinstein" +"ListOfficeName": "Realty Connect USA L I Inc" +"ListAgentMlsId": "196115" +"ListOfficeMlsId": "RLLE10" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Fully renovated 6-bed, 3-bath home in the heart of Merrick! Brand new inside and out. Premium sidings, black windows, new boiler & mechanical. Features a stunning two-tone kitchen with quartz counters, shaker cabinets & stainless appliances, luxury vinyl floors, and designer bathrooms with modern finishes. Huge primary suite with lounge area & custom walk-in shower. Two bedrooms on main level ideal for guests or extended family. Fenced yard, central air, energy-efficient lighting, and prime location near LIRR, Sunrise Hwy, schools & parks. Literally, they are all less than a mile away. Truly the best priced, move in ready home in or around Merrick! Put this on your MUST SEE LIST!" +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-881-5160" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-837-7558" +"BuyerAgentEmail": "nadav@c21kr.com" +"BuyerAgentFullName": "Nadav Kauderer CBR" +"BuyerAgentKey": "326174840" +"BuyerAgentMlsId": "163016" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326113995" +"BuyerOfficeMlsId": "NATN01" +"BuyerOfficeName": "Century 21 KR Realty" +"BuyerOfficePhone": "516-837-7558" +"CarportSpaces": "1" +"CarportYN": true +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "347-323-9477" +"CoListAgentEmail": "kbudhu@hotmail.com" +"CoListAgentFullName": "Khammath Budhu" +"CoListAgentKey": "326221360" +"CoListAgentMlsId": "212151" +"CoListOfficeKey": "326115091" +"CoListOfficeMlsId": "RLLE10" +"CoListOfficeName": "Realty Connect USA L I Inc" +"CoListOfficePhone": "631-881-5160" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-06T13:02:13.369148+00:00" +"CumulativeDaysOnMarket": 64 +"DaysOnMarket": 64 +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-05-06" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:12 [ …12] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-561-7015" +"ListAgentEmail": "oakar@homesonli.com" +"ListAgentKey": "326205806" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115091" +"ListOfficePhone": "631-881-5160" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-11-06" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.0918 +"LotSizeSquareFeet": 4000 +"MajorChangeTimestamp": "2026-01-12T01:05:48Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-01-11" +"OnMarketDate": "2025-11-06" +"OriginalEntryTimestamp": "2025-11-06T12:56:37Z" +"OriginalListPrice": 879000 +"OriginatingSystemModificationTimestamp": "2026-01-12T01:05:48Z" +"OwnerName": "Sell House Homebuyers Llc" +"ParcelNumber": "2089-55-544-00-0308-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-11-06T12:57:57Z" +"PhotosCount": 35 +"PostalCity": "Merrick" +"PostalCodePlus4": "2624" +"PurchaseContractDate": "2026-01-09" +"RoomsTotal": "12" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-561-7015" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-12T01:05:48Z" +"StreetName": "Carroll" +"StreetNumber": "1911" +"StreetNumberNumeric": "1911" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15669.2" +"TaxAssessedValue": 538 +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "879000.00" +"KEY_ContractPrice": "879000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2236.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "393.11270" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "9575163.3987" +"KEY_RATIO_CurrentPrice_By_LivingArea": "393.11270" +"KEY_SourceSystemModificationTimestamp": "2025-11-06T07:25:27.990" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "393.11270" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "393.11270" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422576414')" +"provider_name": "One Key" +"Media": array:35 [ …35] +"ID": "29266" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5121 +post_id: "28990" +post_author: 1 +"ListingKey": "KEY422569092" +"ListingId": "932557" +"PropertyType": "Commercial Sale" +"PropertySubType": "Business" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-12-01T07:09:38Z" +"RFModificationTimestamp": "2025-12-01T07:12:11Z" +"ListPrice": 90000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 10000.0 +"LivingArea": 0 +"BuildingAreaTotal": 20083.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2116 Merrick Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6665888 +"Longitude": -73.5534776 +"YearBuilt": 1966 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tanisha Brown" +"ListOfficeName": "EXP Realty" +"ListAgentMlsId": "209293" +"ListOfficeMlsId": "EXP04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Business Listing — ? Metaphysical Crystal Shop for Sale (Merrick, NY) ?\n \n Asking Price: $90,000\n Monthly Rent: $1,200\n Location: Merrick, New York\n Business Type: Retail / Metaphysical & Wellness\n \n Step into a world of light, energy, and abundance with this magical metaphysical crystal boutique in the heart of Merrick, NY! This is more than a business — it’s a spiritual sanctuary that radiates positivity and attracts a loyal community of crystal lovers, healers, and seekers. Whether you’re a seasoned entrepreneur or a passionate soul ready to bring healing energy to others, this turn-key operation offers everything you need to start strong and shine bright!\n \n Key Features\n \n Turn-key & Profitable: Fully furnished, stocked, and beautifully branded — ready for its next enlightened owner.\n \n Gorgeous Ambience: Custom crystal displays, soft lighting, calming music, and an atmosphere that instantly uplifts everyone who walks through the door.\n \n Expansive Inventory: Crystals, stones, tarot decks, candles, incense, jewelry, sage, and more — valued at thousands of dollars.\n \n Community Hotspot: Known locally for hosting full moon circles, sound baths, tarot nights, and manifestation workshops.\n \n Prime Location: Nestled in a high-traffic Merrick plaza near restaurants, boutiques, and wellness studios — endless walk-in potential.\n \n Strong Online Presence: Social media following, e-commerce opportunities, and a loyal returning customer base.\n \n Growth Potential\n \n The possibilities are limitless — expand into online sales, monthly subscription boxes, or pop-up events. Offer private readings, reiki sessions, or holistic coaching. Build collaborations with yoga instructors, therapists, and local businesses to grow your spiritual brand and impact. """ +"AttributionContact": "888-276-0630" +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Jewelry" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-05T20:11:14.017811+00:00" +"CrossStreet": "smith" +"CumulativeDaysOnMarket": 26 +"DaysOnMarket": 26 +"ExpirationDate": "2025-12-01" +"Heating": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "908-906-7125" +"ListAgentEmail": "info@r2rrealestate.com" +"ListAgentKey": "326218597" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111284" +"ListOfficePhone": "888-276-0630" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-11-01" +"LotSizeAcres": 0.2296 +"LotSizeSquareFeet": 10000 +"MajorChangeTimestamp": "2025-12-01T05:10:25Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"OffMarketDate": "2025-12-01" +"OnMarketDate": "2025-11-05" +"OriginalEntryTimestamp": "2025-11-05T20:01:37Z" +"OriginalListPrice": 90000 +"OriginatingSystemModificationTimestamp": "2025-12-01T05:10:25Z" +"OwnerName": "Meita" +"ParcelNumber": "2089-55-113-00-0009-0" +"PhotosChangeTimestamp": "2025-11-05T20:30:00Z" +"PhotosCount": 6 +"PostalCity": "Merrick" +"PriceChangeTimestamp": "2025-11-05T20:01:37Z" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5168055303" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-12-01T05:10:25Z" +"StreetName": "Merrick" +"StreetNumber": "2116" +"StreetNumberNumeric": "2116" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "135237.22" +"TaxAssessedValue": 20869 +"TaxYear": "2024" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_CurrentPrice": "90000.00" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "391986.0627" +"KEY_SourceSystemModificationTimestamp": "2025-11-05T15:01:37.860" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "4.48140" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "4.48140" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422569092')" +"provider_name": "One Key" +"Media": array:6 [ …6] +"ID": "28990" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5125 +post_id: "30582" +post_author: 1 +"ListingKey": "KEY422554857" +"ListingId": "932133" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-13T16:26:36Z" +"RFModificationTimestamp": "2026-04-13T16:30:51Z" +"ListPrice": 649000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1258.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "34 Shaw Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6896306 +"Longitude": -73.5536943 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joann Laucella" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "146423" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "WELCOME TO THIS WENSHAW PARK CHARMING CAPE COD NESTLED ON A PICTURESQUE TREE-LINED STREET IN WENSHAW PARK. THIS INVIITING HOME FEATURES A SUN-FILLED LIVING ROOM WITH A COZY FIREPLACE, A FORMAL DINING ROOM, AND A FUNCTIONAL KITCHEN PERFECT FOR EVERYDAY LIVING AND ENTERTAINING. THE MAIN LEVEL OFFERS TWO COMFORTABLE BEDROOMS, WITH EXCITING POTENTIAL TO EXPAND AN ATTIC CONVERSION…ITS ALREADY PREPPED FOR TWO ADDITIONAL BEDROOMS AND A FULL BATH WITH PLUMBING AND WATER LINES IN PLACE. ENJOY RELAXING IN THE LOVELY SCREENED-IN PORCH OVERLOOKING THE PROPERTY, PLUS, A FULLY FINISHED BASEMENT PROVIDING EXTRA LIVING OR RECREATIONAL SPACE. ADDITIONAL HIGHLIGHTS INCLUDE GAS HEAT, UPDATED WINDOWS, VINYL SIDING, A FOUR-YEAR YOUNG ROOF AND A HOT WATER HEATER OFFERING BOTH COMFORT AND PEACE OF MIND. A WONDERFUL OPPORTUNITY TO OWN A WELL-MAINTAINED HOME WITH ROOM TO GROW!! Interior sq footage is approximate." +"Appliances": array:3 [ …3] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-590-4576" +"BuyerAgentEmail": "jake.sakin@elliman.com" +"BuyerAgentFullName": "Jake B. Sakin" +"BuyerAgentKey": "326236110" +"BuyerAgentMlsId": "227363" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110766" +"BuyerOfficeMlsId": "DERE28" +"BuyerOfficeName": "Douglas Elliman Real Estate" +"BuyerOfficePhone": "516-623-4500" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-26T18:56:15.505453+00:00" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 8 +"ElementarySchool": "Park Avenue School - North Bellmore" +"ElementarySchoolDistrict": "North Bellmore" +"ExpirationDate": "2026-09-26" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Wellington C Mepham High Sch" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-546-6300" +"ListAgentEmail": "jlaucella@signaturepremier.com" +"ListAgentKey": "326159364" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-26" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.141 +"LotSizeDimensions": "68x93" +"LotSizeSquareFeet": 6144 +"MajorChangeTimestamp": "2026-04-13T16:25:02Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Grand Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-03" +"OnMarketDate": "2026-03-26" +"OriginalEntryTimestamp": "2026-03-26T18:53:01Z" +"OriginalListPrice": 649000 +"OriginatingSystemModificationTimestamp": "2026-04-13T16:25:02Z" +"OwnerName": "Estate of Herrmann" +"ParcelNumber": "2089-56-A-02-0009-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-03-26T18:55:36Z" +"PhotosCount": 25 +"PostalCity": "Merrick" +"PurchaseContractDate": "2026-04-10" +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-643-5564" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-13T16:25:02Z" +"StreetName": "Shaw" +"StreetNumber": "34" +"StreetNumberNumeric": "34" +"StreetSuffix": "Drive" +"SubdivisionName": "Wenshaw Park" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "12711.43" +"TaxYear": "2026" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_HoldDate": "2026-04-03" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "649000.00" +"KEY_ContractPrice": "690000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1258.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-546-6300" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "515.89825" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4602836.8794" +"KEY_RATIO_CurrentPrice_By_LivingArea": "515.89825" +"KEY_SourceSystemModificationTimestamp": "2025-11-04T16:05:51.213" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422554857')" +"provider_name": "One Key" +"Media": array:25 [ …25] +"ID": "30582" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5123 +post_id: "29650" +post_author: 1 +"ListingKey": "KEY422534245" +"ListingId": "931469" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-01-29T07:04:43Z" +"RFModificationTimestamp": "2026-01-29T07:08:36Z" +"ListPrice": 1149888.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2388.0 +"BuildingAreaTotal": 2668.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "3034 Bond Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.641897 +"Longitude": -73.5499721 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "William Ortiz" +"ListOfficeName": "Redfin Real Estate" +"ListAgentMlsId": "175529" +"ListOfficeMlsId": "CNDE01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to 3034 Bond Drive, a beautifully updated Merrick gem showcasing a striking exterior with brick accents, manicured landscaping, and an inviting wide-open entry that sets the tone for the contemporary design within. This turn-key, move-in-ready home features high-end finishes throughout and an open, airy floorplan ideal for both everyday living and entertaining. The main level offers a floating living room with a dramatic dual staircase, a formal dining room perfect for gatherings, and a sunlit den with a convenient half bath. The updated eat-in kitchen impresses with quartz countertops, new stainless-steel appliances, and abundant custom cabinetry.\n \n The private quarters include a spacious primary suite highlighted by a spa-like primary bathroom featuring radiant heated floors and a luxurious steam shower, creating a true retreat. Three additional generously sized bedrooms offer excellent closet space, while a partial basement provides laundry and flexible storage options.\n \n Outside, enjoy a beautifully maintained backyard complete with an 18' retractable awning, brick and bluestone patio, and lush green space—perfect for relaxing or entertaining. Additional features include in-ground sprinklers, central air conditioning, and updated systems for year-round comfort.\n \n Ideally located in one of Merrick’s most sought-after neighborhoods near parks, shopping, dining, and top-rated schools, this exceptional contemporary home offers style, comfort, and convenience—just unpack and enjoy. """ +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-337-8238" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-729-0419" +"BuyerAgentEmail": "pam.miller827@gmail.com" +"BuyerAgentFullName": "Pam E. Miller" +"BuyerAgentKey": "326134317" +"BuyerAgentMlsId": "118879" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115717" +"BuyerOfficeMlsId": "SPH09" +"BuyerOfficeName": "Signature Premier Properties" +"BuyerOfficePhone": "516-546-6300" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-12-23T16:41:33.661111+00:00" +"CumulativeDaysOnMarket": 30 +"DaysOnMarket": 30 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-30" +"Flooring": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-922-0560" +"ListAgentEmail": "william.ortiz@redfin.com" +"ListAgentKey": "326186387" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110429" +"ListOfficePhone": "631-337-8238" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-12-23" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1816 +"LotSizeSquareFeet": 7910 +"MajorChangeTimestamp": "2026-01-29T01:05:24Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-01-28" +"OnMarketDate": "2025-12-29" +"OriginalEntryTimestamp": "2025-12-23T16:38:59Z" +"OriginalListPrice": 1149888 +"OriginatingSystemModificationTimestamp": "2026-01-29T01:05:24Z" +"OwnerName": "Glassman" +"ParcelNumber": "2089-62-214-00-0041-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-01-21T15:25:36Z" +"PhotosCount": 28 +"PostalCity": "Merrick" +"PostalCodePlus4": "5125" +"PurchaseContractDate": "2026-01-28" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-29T01:05:24Z" +"StreetName": "Bond" +"StreetNumber": "3034" +"StreetNumberNumeric": "3034" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "19468.47" +"TaxAssessedValue": 723 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "See Remarks" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "1" +"KEY_CurrentPrice": "1149888.00" +"KEY_ContractPrice": "1285000.00" +"KEY_OpenHouseCount": "3" +"KEY_PreviousStatus": "Active" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2388.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "481.52764" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6331982.3789" +"KEY_RATIO_CurrentPrice_By_LivingArea": "481.52764" +"KEY_SourceSystemModificationTimestamp": "2025-11-03T11:29:29.160" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "430.99250" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "430.99250" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422534245')" +"provider_name": "One Key" +"Media": array:28 [ …28] +"ID": "29650" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5120 +post_id: "28823" +post_author: 1 +"ListingKey": "KEY422510242" +"ListingId": "930825" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-07T22:19:36Z" +"RFModificationTimestamp": "2026-04-07T22:22:05Z" +"ListPrice": 1249000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2273.0 +"BuildingAreaTotal": 2408.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2884 Bay Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.648763 +"Longitude": -73.5442514 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Elaine Richheimer" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "174177" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Dreaming of the summer? Buy your 2026 beautiful waterfront home! Welcome to 2884 Bay Drive, a beautiful residence nestled in the heart of Merrick's coveted Lindenmere Section. This spacious home, situated on a serene dead-end street, offers an abundance of space and tranquility. This property boasts four well appointed bedrooms and 2.5 bathrooms offering ample space for relaxation and comfort and so close to the Great South Bay. An additional large room upstairs provides flexibility for a great home office or a fifth bedroom, ensuring this home can adapt to suit your needs. Enjoy swimming in your semi-inground pool on those warm summer days ahead. Central air and inground sprinklers add to the home's appeal, ensuring comfort and ease of maintenance, A generous 70 feet of bulkhead and a private dock make this home a boater's paradise right in your backyard.\n Wake up each morning to breakfast with a view, as you enjoy the sight of the wide canal just beyond your doorstep. Living here is akin to a permanent vacation, with the beauty of Cammans Pond nearby and the allure of the waterfront at your beck and call.\n This home is conveniently located near a variety of trendy restaurants, shops, and local transportation options with NYC just 45 minutes away by train, ensuring you're never far from the action. Beautiful beaches are just one exit away on the parkway, inviting you to enjoy the sun, surf, and sand whenever the mood strikes. In this vibrant community, there's always something exciting to do and new places to explore. 2884 Bay Drive is the perfect blend of peace and excitement. Discover the joy of waterfront living in a community that truly has it all ! Don't miss this wonderful opportunity to own this great residence! """ +"Appliances": array:9 [ …9] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-680-2184" +"BuyerAgentEmail": "bking@signaturepremier.com" +"BuyerAgentFullName": "Brenda King" +"BuyerAgentKey": "326138029" +"BuyerAgentMlsId": "122895" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115717" +"BuyerOfficeMlsId": "SPH09" +"BuyerOfficeName": "Signature Premier Properties" +"BuyerOfficePhone": "516-546-6300" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-05T17:55:42.072939+00:00" +"CumulativeDaysOnMarket": 152 +"DaysOnMarket": 152 +"DirectionFaces": "East" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-30" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"Flooring": array:3 [ …3] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-721-8316" +"ListAgentEmail": "Elaine.Richheimer@elliman.com" +"ListAgentKey": "326185145" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-10-31" +"ListingTerms": "Contract" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1607 +"LotSizeSquareFeet": 7000 +"MajorChangeTimestamp": "2026-04-07T22:17:45Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-06" +"OnMarketDate": "2025-11-05" +"OriginalEntryTimestamp": "2025-10-31T16:29:36Z" +"OriginalListPrice": 1299000 +"OriginatingSystemModificationTimestamp": "2026-04-07T22:17:45Z" +"OwnerName": "Yong Xiang Li & Jun Ying Weng" +"ParcelNumber": "2089-62-194-00-0059-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-11-26T22:23:36Z" +"PhotosCount": 31 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "4603" +"PreviousListPrice": 1299000 +"PriceChangeTimestamp": "2026-03-13T17:32:08Z" +"PurchaseContractDate": "2026-04-07" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5166234500" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-07T22:17:45Z" +"StreetName": "Bay" +"StreetNumber": "2884" +"StreetNumberNumeric": "2884" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "20942.75" +"TaxAssessedValue": 798 +"TaxBlock": "194" +"TaxLot": "59" +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:5 [ …5] +"WaterfrontYN": true +"KEY_Attic": "None" +"KEY_HoldDate": "2026-04-06" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "4" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1249000.00" +"KEY_ContractPrice": "1200000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Hold" +"KEY_AdditionalRooms": "Home Office" +"KEY_DistanceToTrain": "1.00" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2273.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "5167218316" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "549.49406" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7772246.4219" +"KEY_RATIO_CurrentPrice_By_LivingArea": "549.49406" +"KEY_SourceSystemModificationTimestamp": "2025-10-31T12:29:36.867" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "518.68771" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.96151" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "518.68771" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422510242')" +"provider_name": "One Key" +"Media": array:31 [ …31] +"ID": "28823" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5119 +post_id: "28664" +post_author: 1 +"ListingKey": "KEY422380899" +"ListingId": "927503" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-03-18T20:04:36Z" +"RFModificationTimestamp": "2026-03-18T20:05:28Z" +"ListPrice": 919000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2708.0 +"BuildingAreaTotal": 2708.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "160 Bedford Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.661991 +"Longitude": -73.5612599 +"YearBuilt": 1863 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Zaheer Khanzada SRS AHWD PSA" +"ListOfficeName": "ALUX Realty" +"ListAgentMlsId": "197345" +"ListOfficeMlsId": "ZWRK01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Bright and spacious Colonial on a quiet Merrick block. Five comfortable bedrooms and two full baths give you the space you need. The main level features a sunlit living room, dining room, and an eat-in kitchen that opens through sliders to an incredible backyard. Enjoy an oversized deck with a covered lounge, grill area, and a wide, private lawn that is perfect for gatherings and play. Charming front porch for morning coffee. Close to the LIRR, parks, shopping, Sunrise Hwy, and Meadowbrook Pkwy. A move-in-ready Merrick home with room to live, work, and entertain." +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-587-0000" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-642-4435" +"BuyerAgentEmail": "jeneferjoseph@gmail.com" +"BuyerAgentFullName": "Jenefer Joseph" +"BuyerAgentKey": "326117650" +"BuyerAgentMlsId": "101029" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326112483" +"BuyerOfficeMlsId": "JEJO01" +"BuyerOfficeName": "Jenefer Joseph & Associates" +"BuyerOfficePhone": "516-837-9595" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-10-22T19:46:47.764606+00:00" +"CumulativeDaysOnMarket": 146 +"DaysOnMarket": 146 +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-06-29" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-587-0000" +"ListAgentEmail": "zaheer@aluxrealty.com" +"ListAgentKey": "326206976" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326116679" +"ListOfficePhone": "516-587-0000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-10-22" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.2264 +"LotSizeSquareFeet": 9864 +"MajorChangeTimestamp": "2026-03-18T20:03:15Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-03-18" +"OnMarketDate": "2025-10-22" +"OriginalEntryTimestamp": "2025-10-22T19:36:31Z" +"OriginalListPrice": 929000 +"OriginatingSystemModificationTimestamp": "2026-03-18T20:03:15Z" +"OwnerName": "Aqeel J & Adeel J Ahmad" +"ParcelNumber": "2089-55-126-00-0028-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2025-10-23T16:04:36Z" +"PhotosCount": 32 +"PostalCity": "Merrick" +"PreviousListPrice": 929000 +"PriceChangeTimestamp": "2026-02-26T16:11:11Z" +"PurchaseContractDate": "2026-03-17" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516 218 0348" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-18T20:03:15Z" +"StreetName": "Bedford" +"StreetNumber": "160" +"StreetNumberNumeric": "160" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15268.63" +"TaxAssessedValue": 584 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Other" +"KEY_CurrentPrice": "919000.00" +"KEY_ContractPrice": "934000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2708.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516 218 0348" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "339.36484" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4059187.2792" +"KEY_RATIO_CurrentPrice_By_LivingArea": "339.36484" +"KEY_SourceSystemModificationTimestamp": "2025-10-22T15:36:31.677" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.98924" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422380899')" +"provider_name": "One Key" +"Media": array:32 [ …32] +"ID": "28664" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5126 +post_id: "28689" +post_author: 1 +"ListingKey": "KEY422329042" +"ListingId": "925957" +"PropertyType": "Commercial Lease" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-10T21:49:36Z" +"RFModificationTimestamp": "2026-04-10T21:55:02Z" +"ListPrice": 4000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1128.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "373 Merrick Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7127366 +"Longitude": -73.5725202 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Katherine Koniecko" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "192700" +"ListOfficeMlsId": "SPH06" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Prime Merrick Avenue location! This vacant storefront offers 1,128 sq. ft. of versatile space, ready for your custom build-out. Whether you’re opening a retail shop, boutique, office, or specialty service, this property provides the perfect blank canvas to bring your vision to life.\n Situated in the heart of Merrick’s bustling commercial district with excellent visibility, steady foot traffic, and close proximity to major roadways and public transportation.\n Come build out your dream space at 373 Merrick Avenue and join the thriving Merrick business community! """ +"AttributionContact": "516-232-5888" +"Basement": array:1 [ …1] +"BasementYN": true +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Retail" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "917-816-0239" +"CoListAgentEmail": "mkaramoshos@signaturepremier.com" +"CoListAgentFullName": "Marguerite Karamoshos" +"CoListAgentKey": "326194806" +"CoListAgentMlsId": "184590" +"CoListOfficeKey": "326115726" +"CoListOfficeMlsId": "SPH18" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "516-799-7100" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-10-24T16:13:05.011032+00:00" +"CumulativeDaysOnMarket": 168 +"DaysOnMarket": 190 +"ExpirationDate": "2026-06-01" +"Heating": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseAmountFrequency": "Monthly" +"LeaseTerm": "Negotiable" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-232-5888" +"ListAgentEmail": "kkoniecko@signaturepremier.com" +"ListAgentKey": "326202518" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115714" +"ListOfficePhone": "516-921-1400" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-10-24" +"MajorChangeTimestamp": "2025-10-24T16:09:26Z" +"MajorChangeType": "New Listing" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-10-24" +"OriginalEntryTimestamp": "2025-10-24T16:09:26Z" +"OriginalListPrice": 4000 +"OriginatingSystemModificationTimestamp": "2026-04-10T21:48:00Z" +"OwnerName": "Reyes" +"ParcelNumber": "2089-55-053-00-0001-0" +"PhotosChangeTimestamp": "2025-10-24T16:10:36Z" +"PhotosCount": 9 +"PostalCity": "Merrick" +"PriceChangeTimestamp": "2025-10-24T16:09:26Z" +"PropertyAttachedYN": true +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-232-5888" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-10-24T16:09:26Z" +"StreetName": "Merrick" +"StreetNumber": "373" +"StreetNumberNumeric": "373" +"StreetSuffix": "Avenue" +"SyndicateTo": array:3 [ …3] +"TaxBlock": "053" +"TaxLot": "1" +"TaxYear": "2025" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_ElevatorYN": "0" +"KEY_TaxSection": "55" +"KEY_CurrentPrice": "4000.00" +"KEY_BuildToSuitYN": "0" +"KEY_LeasePriceUnit": "Total" +"KEY_ElectricCompany": "PSEG" +"KEY_SecurityDeposits": "4000" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_SourceSystemModificationTimestamp": "2025-10-17T22:32:19.657" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "3.54610" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "3.54610" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422329042')" +"provider_name": "One Key" +"Media": array:9 [ …9] +"ID": "28689" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5127 +post_id: "29337" +post_author: 1 +"ListingKey": "KEY422201928" +"ListingId": "922406" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-01-13T01:21:36Z" +"RFModificationTimestamp": "2026-01-13T01:22:27Z" +"ListPrice": 725000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1531.0 +"BuildingAreaTotal": 1531.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2845 Whaleneck Drive, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6509045 +"Longitude": -73.5427001 +"YearBuilt": 1956 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ellen Fuschillo CBR" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "187771" +"ListOfficeMlsId": "SPH23" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this beautifully maintained split-level home located on one of the most picturesque blocks in South Merrick. This inviting residence features 3 bedrooms and 2.5 baths offering comfort and style throughout. Enjoy hardwood floors, wainscoting details and abundant natural light. The updated kitchen includes brand new stove and dishwasher. Additional highlights include a finished basement as well as full attic for ample storage and a private yard ideal for out door gatherings. Don't miss this opportunity to own a home in one of South Merrick's most desirable neighborhoods!" +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-785-0100" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-603-9215" +"BuyerAgentEmail": "loriscrobe@danielgale.com" +"BuyerAgentFullName": "Loredana V. Scrobe CBR" +"BuyerAgentKey": "326170630" +"BuyerAgentMlsId": "158428" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326111554" +"BuyerOfficeMlsId": "GALE11" +"BuyerOfficeName": "Daniel Gale Sothebys Intl Rlty" +"BuyerOfficePhone": "516-627-4440" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-11-13T19:50:34.200501+00:00" +"CrossStreet": "Oliver Way" +"CumulativeDaysOnMarket": 37 +"DaysOnMarket": 37 +"Directions": "GPS" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-05-08" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-857-7443" +"ListAgentEmail": "efuschillo@signaturepremier.com" +"ListAgentKey": "326197836" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115731" +"ListOfficePhone": "516-785-0100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-11-12" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1579 +"LotSizeSquareFeet": 6880 +"MajorChangeTimestamp": "2026-01-13T01:20:34Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-01-12" +"OnMarketDate": "2025-11-13" +"OriginalEntryTimestamp": "2025-11-13T19:46:23Z" +"OriginalListPrice": 875000 +"OriginatingSystemModificationTimestamp": "2026-01-13T01:20:34Z" +"OwnerName": "Michael Katz" +"ParcelNumber": "2089-63-151-00-0047-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-11-13T19:47:36Z" +"PhotosCount": 20 +"PostalCity": "Merrick" +"PostalCodePlus4": "5322" +"PreviousListPrice": 875000 +"PriceChangeTimestamp": "2025-12-23T16:59:34Z" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-01-12" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-857-7443" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-13T01:20:34Z" +"StreetName": "Whaleneck" +"StreetNumber": "2845" +"StreetNumberNumeric": "2845" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "18516" +"TaxYear": "2025" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_HoldDate": "2025-11-25" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "725000.00" +"KEY_ContractPrice": "750000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1531.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "473.54670" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4591513.6162" +"KEY_RATIO_CurrentPrice_By_LivingArea": "473.54670" +"KEY_SourceSystemModificationTimestamp": "2025-10-08T14:09:19.453" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "473.54670" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.82857" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "473.54670" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422201928')" +"provider_name": "One Key" +"Media": array:20 [ …20] +"ID": "29337" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5128 +post_id: "28482" +post_author: 1 +"ListingKey": "KEY422145478" +"ListingId": "920732" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-10-21T07:11:39Z" +"RFModificationTimestamp": "2025-10-21T07:15:05Z" +"ListPrice": 749000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1607.0 +"BuildingAreaTotal": 1607.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "110 Hampton Way, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6538555 +"Longitude": -73.542031 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shari M. DeLouya CBR" +"ListOfficeName": "Realty Connect USA LLC" +"ListAgentMlsId": "103104" +"ListOfficeMlsId": "RLLE02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Move right in to this perfectly located and updated S. Merrick ranch with 3 large bedrooms and 2 full updated bathrooms. The large private yard is fully fenced with PVC fencing. The home features an Eat in Kitchen with Quartz Center Island with counter seating added in 2024. All new Stainless Steel appliances were replaced in 2023 along with Brizo touchless kitchen faucet added in 2023. Custom banquette in an open concept dining area. Primary Bedroom enjoys an ensuite full bathroom. Both bathroom fixtures and Toto toilets are 2 years young. New roof as well as Gas heating and Central AC (2 Zone operated by Nest thermostats) as of 2023. Brand new Navien Tankless Boiler replaced in 2025. New attic pull down access in garage in 2025. All custom closets, 200 Amp Electric, LED lighting on dimmers, fresh painted walls and ceilings, Ring Doorbell and Security cameras, alarm system and Luxury Vinyl wide Plank Flooring throughout the home providing a wood feel with easy maintenance. This home offers so many great features in highly desirable neighborhood and South Merrick School District! Not to be missed!" +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "smdelouya@gmail.com" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-297-5260" +"BuyerAgentEmail": "LPitlake@Elliman.com" +"BuyerAgentFullName": "Louise F. Pitlake SRES" +"BuyerAgentKey": "326258099" +"BuyerAgentMlsId": "9038084" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110766" +"BuyerOfficeMlsId": "DERE28" +"BuyerOfficeName": "Douglas Elliman Real Estate" +"BuyerOfficePhone": "516-623-4500" +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "516-521-7976" +"CoBuyerAgentEmail": "SPitlake@Elliman.Com" +"CoBuyerAgentFullName": "Seth I. Pitlake SRES" +"CoBuyerAgentKey": "326245944" +"CoBuyerAgentMlsId": "85287" +"CoBuyerOfficeKey": "326110766" +"CoBuyerOfficeMlsId": "DERE28" +"CoBuyerOfficeName": "Douglas Elliman Real Estate" +"CoBuyerOfficePhone": "516-623-4500" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-993-4721" +"CoListAgentEmail": "mimber@aol.com" +"CoListAgentFullName": "Marci Imber" +"CoListAgentKey": "326260685" +"CoListAgentMlsId": "9070310" +"CoListOfficeKey": "326115083" +"CoListOfficeMlsId": "RLLE02" +"CoListOfficeName": "Realty Connect USA LLC" +"CoListOfficePhone": "516-714-3606" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-10-06T14:17:02.877109+00:00" +"CrossStreet": "Hewlett Ave" +"CumulativeDaysOnMarket": 10 +"DaysOnMarket": 10 +"Directions": "Hewlett Ave South to Hampton Way" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-04-20" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:14 [ …14] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-834-1892" +"ListAgentEmail": "smdelouya@gmail.com" +"ListAgentKey": "326119600" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115083" +"ListOfficePhone": "516-714-3606" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-10-06" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1377 +"LotSizeDimensions": "60 x 100" +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2025-10-20T23:41:52Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2025-10-20" +"OnMarketDate": "2025-10-10" +"OriginalEntryTimestamp": "2025-10-06T14:10:43Z" +"OriginalListPrice": 749000 +"OriginatingSystemModificationTimestamp": "2025-10-20T23:41:52Z" +"OwnerName": "Kaplan" +"ParcelNumber": "2089-63-138-00-0071-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-06T14:12:36Z" +"PhotosCount": 24 +"PostalCity": "Merrick" +"PostalCodePlus4": "5025" +"PurchaseContractDate": "2025-10-20" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "855-920-8240" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-10-20T23:41:52Z" +"StreetName": "Hampton" +"StreetNumber": "110" +"StreetNumberNumeric": "110" +"StreetSuffix": "Way" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "16129.28" +"TaxYear": "2025" +"Utilities": array:7 [ …7] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Finished,Pull Stairs" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "749000.00" +"KEY_ContractPrice": "778000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1607.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "466.08587" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5439360.9296" +"KEY_RATIO_CurrentPrice_By_LivingArea": "466.08587" +"KEY_SourceSystemModificationTimestamp": "2025-10-03T23:20:08.067" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "466.08587" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "466.08587" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422145478')" +"provider_name": "One Key" +"Media": array:24 [ …24] +"ID": "28482" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5129 +post_id: "28527" +post_author: 1 +"ListingKey": "KEY422122836" +"ListingId": "920107" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-28T18:20:36Z" +"RFModificationTimestamp": "2026-02-28T18:24:08Z" +"ListPrice": 1588000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3600.0 +"BuildingAreaTotal": 3600.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "526 Park Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6876806 +"Longitude": -73.5488443 +"YearBuilt": 2026 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dennis Arango" +"ListOfficeName": "John Savoretti Realty" +"ListAgentMlsId": "108161" +"ListOfficeMlsId": "JOSV01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "THIS BEAUTIFUL 3600SQFT 5 BEDROOM COLONIAL IS BUILT WITH SO MUCH ATTENTION TO DETAIL AND SO MANY EXTRAS ALREADY ADDED IN. THIS BUILDER OFFERS A PRODUCT THAT IS SECOND TO NONE AND BUILT LIKE THEY ARE GONNA LIVE IN IT. WITH A TREMENDOUS AMOUNT TO OFFER IT IS ADVISABLE TO LOOK AT A MODEL THAT WILL BETTER EXPLAIN ALL THATS INCLUDED. OPEN FLOOR PLAN WITH AN OVERSIZED PROPERTY AND A TWO CAR GARAGE IN THE MERRICK SCHOOL DISTRICT WITH GREAT PROXIMITY TO ALL. PLANS AND SPEC SHEETS AVAILABLE TO VIEW." +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-459-3655" +"Basement": array:3 [ …3] +"BathroomsFull": 4 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-721-7257" +"CoListAgentEmail": "lou.tullo@gmail.com" +"CoListAgentFullName": "Louis M. Tullo" +"CoListAgentKey": "326121137" +"CoListAgentMlsId": "104752" +"CoListOfficeKey": "326112691" +"CoListOfficeMlsId": "JOSV01" +"CoListOfficeName": "John Savoretti Realty" +"CoListOfficePhone": "516-327-6400" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-10-08T21:27:45.203328+00:00" +"CrossStreet": "Central Ave. or Grant Ave." +"CumulativeDaysOnMarket": 129 +"DaysOnMarket": 192 +"DirectionFaces": "West" +"Directions": "Mapquest" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-30" +"ExteriorFeatures": array:3 [ …3] +"Fencing": array:3 [ …3] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:3 [ …3] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:23 [ …23] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ …3] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-459-3655" +"ListAgentEmail": "dennis@dennisarango.com" +"ListAgentKey": "326124339" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112691" +"ListOfficePhone": "516-327-6400" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-10-08" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.202 +"LotSizeDimensions": "80X140" +"LotSizeSquareFeet": 8800 +"MajorChangeTimestamp": "2025-10-22T04:31:07Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-10-22" +"OriginalEntryTimestamp": "2025-10-08T21:22:07Z" +"OriginalListPrice": 1588000 +"OriginatingSystemModificationTimestamp": "2026-02-28T18:18:46Z" +"OwnerName": "Brook-City Developoment Llc" +"ParcelNumber": "2089-56-115-00-0190-0" +"ParkingFeatures": array:4 [ …4] +"ParkingTotal": "6" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-22T13:15:36Z" +"PhotosCount": 9 +"PostalCity": "Merrick" +"PostalCodePlus4": "1825" +"PreviousListPrice": 158888 +"PriceChangeTimestamp": "2025-10-08T21:22:07Z" +"PropertyCondition": array:2 [ …2] +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5167217257" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-10-22T04:31:07Z" +"StreetName": "Park" +"StreetNumber": "526" +"StreetNumberNumeric": "526" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxBlock": "115" +"TaxLot": "190" +"TaxYear": "2026" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:5 [ …5] +"KEY_Attic": "Full,Pull Stairs,Storage" +"KEY_TaxSource": "Other" +"KEY_TaxSection": "56" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1588000.00" +"KEY_PreviousStatus": "Coming Soon" +"KEY_DistanceToTrain": "1.00" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "3600.00" +"KEY_ShowingContactPhone2": "5164593655" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "441.11111" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7861386.1386" +"KEY_RATIO_CurrentPrice_By_LivingArea": "441.11111" +"KEY_SourceSystemModificationTimestamp": "2025-10-02T15:49:17.777" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "441.11111" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "441.11111" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422122836')" +"provider_name": "One Key" +"Media": array:9 [ …9] +"ID": "28527" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5130 +post_id: "28300" +post_author: 1 +"ListingKey": "KEY421958192" +"ListingId": "915451" +"PropertyType": "Commercial Lease" +"PropertySubType": "Business" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-03-16T07:02:41Z" +"RFModificationTimestamp": "2026-03-16T07:03:36Z" +"ListPrice": 8000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 10416.0 +"LivingArea": 0 +"BuildingAreaTotal": 2300.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2056-2058 Merrick Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6569511 +"Longitude": -73.5484209 +"YearBuilt": 1977 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nicole J. Myrie" +"ListOfficeName": "Coldwell Banker American Homes" +"ListAgentMlsId": "201219" +"ListOfficeMlsId": "BRMN04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to Merrick Road — one of Long Island’s busiest commercial corridors. This property sits front and center, with nonstop visibility to over 100,000 passing vehicles. 2300 square feet of accessible space is available for use with accessible deep freezer and refrigerator, large prep stations, gas range, additional storage and a host of other available equipment.\n \n Location is everything. Just minutes from the Meadowbrook Parkway and Sunrise Highway, you’re instantly connected to the South Shore of Long Island and beyond.\n \n A large on-site lot with 11 spaces makes access effortless for both customers and staff.\n \n The neighborhood? Surrounded by retail, dining and community hubs, this is a prime spot where people live, shop, and gather.\n \n High traffic. Easy access. Strong community presence and great Acai Bowl partner store right next door.\n \n This property checks every box for a business looking to stand out in Nassau County. All legal sources of funds are accepted. """ +"AccessibilityFeatures": array:2 [ …2] +"Appliances": array:5 [ …5] +"AttributionContact": "516-302-8500" +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Butcher" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-410-0565" +"CoListAgentEmail": "michele3459@gmail.com" +"CoListAgentFullName": "Michele S. Mosca" +"CoListAgentKey": "326191785" +"CoListAgentMlsId": "181370" +"CoListOfficeKey": "326109945" +"CoListOfficeMlsId": "BRMN14" +"CoListOfficeName": "Coldwell Banker American Homes" +"CoListOfficePhone": "516-665-2000" +"CommonWalls": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-09-21T13:27:22.899509+00:00" +"CumulativeDaysOnMarket": 176 +"DaysOnMarket": 176 +"Directions": "GOOGLE MAPS" +"ExpirationDate": "2026-03-16" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeasableArea": 2300 +"LeaseAmountFrequency": "Monthly" +"LeaseTerm": "Over 12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "917-757-1677" +"ListAgentEmail": "nmyrie@cbamhomes.com" +"ListAgentKey": "326210728" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109935" +"ListOfficePhone": "516-302-8500" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-09-20" +"LotSizeAcres": 0.2391 +"LotSizeSquareFeet": 10416 +"MajorChangeTimestamp": "2026-03-16T04:11:44Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"NumberOfBuildings": 1 +"OffMarketDate": "2026-03-16" +"OnMarketDate": "2025-09-21" +"OriginalEntryTimestamp": "2025-09-21T13:24:21Z" +"OriginalListPrice": 8000 +"OriginatingSystemModificationTimestamp": "2026-03-16T04:11:44Z" +"OwnerName": "Astino" +"ParcelNumber": "2089-63-135-00-0892-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "11" +"PhotosChangeTimestamp": "2026-02-28T15:11:36Z" +"PhotosCount": 10 +"PostalCity": "Merrick" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "9177571677" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-16T04:11:44Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Merrick" +"StreetNumber": "2056" +"StreetNumberNumeric": "2056" +"StreetSuffix": "Road" +"SyndicateTo": array:3 [ …3] +"TaxAnnualAmount": "25346.75" +"TaxBlock": "135" +"TaxLot": "892" +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"VirtualTourURLUnbranded": "https://2056-merrick-road.mostevephoto.com/set/93a1a086-0871-4883-a617-8165e3b26a82?pgid=93a1a086-0871-4883-a617-8165e3b26a82_86331adf-725d-4064-b2b9-a65f842157bc" +"WaterSource": array:1 [ …1] +"Zoning": "Retail" +"KEY_Hamlet": "Merrick" +"KEY_ElevatorYN": "0" +"KEY_SubleaseYN": "0" +"KEY_TaxSection": "63" +"KEY_UsableArea": "2300.00" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "8000.00" +"KEY_BuildToSuitYN": "1" +"KEY_PermittedUses": "Business,Food Services,Mixed" +"KEY_WaterAccessYN": "0" +"KEY_LeasePriceUnit": "Total" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_SprinklerSystemYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LocationDescription": "Ground Floor" +"KEY_InvestmentPropertyYN": "0" +"KEY_NumberOfHeatingZones": "1" +"KEY_ShowingContactPhone2": "5164100565" +"KEY_MaximumContiguousSqft": "2300" +"KEY_NumberOfResidentialUnits": "0" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "33458.8038" +"KEY_SourceSystemModificationTimestamp": "2025-09-21T07:35:27.920" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "3.47826" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "3.47826" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421958192')" +"provider_name": "One Key" +"Media": array:10 [ …10] +"ID": "28300" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5131 +post_id: "28130" +post_author: 1 +"ListingKey": "KEY421748680" +"ListingId": "909661" +"PropertyType": "Residential Lease" +"PropertySubType": "Apartment" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-09-25T07:09:39Z" +"RFModificationTimestamp": "2025-09-25T08:19:00Z" +"ListPrice": 3495.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1000.0 +"BuildingAreaTotal": 1993.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1444 Park Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 1984 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jatinder P. Singh" +"ListOfficeName": "LA Rosa Realty New York LLC" +"ListAgentMlsId": "142082" +"ListOfficeMlsId": "BOEH01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Newly Renovated 3-BR / 1-Bath Apartment, Beautiful & updated Kitchen, updated Bath, Nice Floors, Gas cooking, Shared Laundry, Tenant Pays own Utility Bills, very convenient location near Major Hwys, Shopping, LIRR 7 min drive, No Pets, No Smoking, (Income+ Credit Verification Required) Available Immediately." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-942-2003" +"AvailabilityDate": "2025-09-06" +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "917-815-2472" +"CoListAgentEmail": "SWARJOTSELLSHOMES@GMAIL.COM" +"CoListAgentFullName": "Swarjot Singh Gill" +"CoListAgentKey": "326218655" +"CoListAgentMlsId": "209353" +"CoListOfficeKey": "326109880" +"CoListOfficeMlsId": "BOEH01" +"CoListOfficeName": "LA Rosa Realty New York LLC" +"CoListOfficePhone": "516-942-2003" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-09-08T22:16:26.698558+00:00" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 16 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-05" +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "Over 12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-445-1300" +"ListAgentEmail": "Singh Sells NY@gmail.com" +"ListAgentKey": "326155389" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109880" +"ListOfficePhone": "516-942-2003" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-09-05" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1182 +"LotSizeSquareFeet": 5150 +"MajorChangeTimestamp": "2025-09-24T16:34:31Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Hold" +"OffMarketDate": "2025-09-24" +"OnMarketDate": "2025-09-08" +"OriginalEntryTimestamp": "2025-09-08T22:14:14Z" +"OriginalListPrice": 3495 +"OriginatingSystemModificationTimestamp": "2025-09-24T16:34:31Z" +"OwnerName": "Undisclosed" +"ParcelNumber": "2089-56-025-00-0404-0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-09-24T16:35:36Z" +"PhotosCount": 18 +"PostalCity": "Merrick" +"PostalCodePlus4": "1839" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-445-1300" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-09-24T16:34:31Z" +"StreetName": "Park" +"StreetNumber": "1444" +"StreetNumberNumeric": "1444" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"UnitNumber": "2nd FL" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_HoldDate": "2025-09-24" +"KEY_SmokingYN": "0" +"KEY_RentSpreeYN": "1" +"KEY_CurrentPrice": "3495.00" +"KEY_RentSpreeURL": "https://apply.link/10EjFAs" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_SecurityDeposits": "1 Month Rent" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "1000.00" +"KEY_RATIO_ListPrice_By_LivingArea": "3.49500" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "29568.5279" +"KEY_RATIO_CurrentPrice_By_LivingArea": "3.49500" +"KEY_SourceSystemModificationTimestamp": "2025-09-05T22:19:37.637" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.75364" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.75364" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421748680')" +"provider_name": "One Key" +"Media": array:18 [ …18] +"ID": "28130" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5132 +post_id: "28029" +post_author: 1 +"ListingKey": "KEY421653713" +"ListingId": "907065" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-20T15:28:36Z" +"RFModificationTimestamp": "2026-04-20T15:32:26Z" +"ListPrice": 1299000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2180.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2 Garfield Street, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6754943 +"Longitude": -73.5577305 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Steven E. DeCillis" +"ListOfficeName": "Keller Williams Realty Elite" +"ListAgentMlsId": "174967" +"ListOfficeMlsId": "KWE02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Brand new pre-construction offering in Merrick! Anticipated start in May and completion in July. Magnificent new build with high end appliances, CAC and every detail is carefully completed. Act now and choose your colors, tiles and any detail you want to add. New construction in Merrick is rare so act quickly." +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-795-6900" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-30T16:01:54.814519+00:00" +"CrossStreet": "Merrick Avenue" +"CumulativeDaysOnMarket": 233 +"DaysOnMarket": 246 +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-08-30" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-551-7309" +"ListAgentEmail": "Sdecee@aol.com" +"ListAgentKey": "326185877" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113000" +"ListOfficePhone": "516-795-6900" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-30" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.1148 +"LotSizeSquareFeet": 5000 +"MajorChangeTimestamp": "2025-08-30T16:00:01Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-08-30" +"OriginalEntryTimestamp": "2025-08-30T16:00:01Z" +"OriginalListPrice": 1299000 +"OriginatingSystemModificationTimestamp": "2026-04-20T15:27:19Z" +"OwnerName": "Danie Mascary" +"ParcelNumber": "2089-55-053-00-0025-0" +"PhotosChangeTimestamp": "2026-01-18T18:16:36Z" +"PhotosCount": 3 +"PostalCity": "Merrick" +"PostalCodePlus4": "2623" +"PriceChangeTimestamp": "2025-08-30T16:00:01Z" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-551-7309" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-08-30T16:00:01Z" +"StreetName": "Garfield" +"StreetNumber": "2" +"StreetNumberNumeric": "2" +"StreetSuffix": "Street" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "10947" +"TaxYear": "2025" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1299000.00" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "2180.00" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "595.87156" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "11315331.0105" +"KEY_RATIO_CurrentPrice_By_LivingArea": "595.87156" +"KEY_SourceSystemModificationTimestamp": "2025-08-30T12:00:00.653" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421653713')" +"provider_name": "One Key" +"Media": array:3 [ …3] +"ID": "28029" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5133 +post_id: "28398" +post_author: 1 +"ListingKey": "KEY421571882" +"ListingId": "904724" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-02-26T07:01:42Z" +"RFModificationTimestamp": "2026-02-26T07:02:41Z" +"ListPrice": 1325000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 3000.0 +"BuildingAreaTotal": 3248.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2998 Joyce Lane, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6434061 +"Longitude": -73.546603 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Richard M. Shane" +"ListOfficeName": "All Island Estates Realty Corp" +"ListAgentMlsId": "198897" +"ListOfficeMlsId": "CBE01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Nestled in the desirable Deep South Merrick, this exceptional home offers luxury and comfort in a non-flood zone setting. The backyard is truly a retreat, featuring a breathtaking in-ground heated saltwater pool, perfect for both relaxation and entertainment. Inside, modern finishes combine with inviting wood floors to create a warm, elegant atmosphere. The house provides 6 bedrooms and a total of 3 baths. The open floor plan is designed with cathedral ceilings throughout the living room. The spacious formal dining room and chef’s kitchen with a large center island are ideal for hosting, while the home also boasts a beautiful gym, full bathroom, office space, and family room with a designer fireplace. The expansive two-car garage provides not only room for vehicles but also extra space for storage and supplies. Don’t miss your chance to own this one-of-a-kind property with all the features you’ve been dreaming of!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-783-5600" +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-319-8363" +"CoListAgentEmail": "sch.t.matthew@gmail.com" +"CoListAgentFullName": "Matthew Scherer" +"CoListAgentKey": "418739773" +"CoListAgentMlsId": "502982" +"CoListOfficeKey": "326115553" +"CoListOfficeMlsId": "SHNE01" +"CoListOfficeName": "Shane's Anchor Realty Corp" +"CoListOfficePhone": "516-783-4540" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-25T18:02:02.709486+00:00" +"CrossStreet": "Shore Drive" +"CumulativeDaysOnMarket": 183 +"DaysOnMarket": 183 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-02-26" +"FireplaceYN": true +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-783-5600" +"ListAgentEmail": "mrsold4@aol.com" +"ListAgentKey": "326208468" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110144" +"ListOfficePhone": "516-783-5600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-25" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.2206 +"LotSizeSquareFeet": 9610 +"MajorChangeTimestamp": "2026-02-26T06:24:19Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2026-02-26" +"OnMarketDate": "2025-08-27" +"OriginalEntryTimestamp": "2025-08-25T17:56:43Z" +"OriginalListPrice": 1448000 +"OriginatingSystemModificationTimestamp": "2026-02-26T06:24:19Z" +"OwnerName": "Reitano" +"ParcelNumber": "2089-62-210-00-0010-0" +"PhotosChangeTimestamp": "2026-02-05T15:44:36Z" +"PhotosCount": 43 +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "5208" +"PreviousListPrice": 1399800 +"PriceChangeTimestamp": "2025-10-23T15:58:32Z" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-783-5600" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-26T06:24:19Z" +"StreetName": "Joyce" +"StreetNumber": "2998" +"StreetNumberNumeric": "2998" +"StreetSuffix": "Lane" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "18941.52" +"TaxYear": "2025" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1325000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "3000.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-783-5600" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "441.66667" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6006346.3282" +"KEY_RATIO_CurrentPrice_By_LivingArea": "441.66667" +"KEY_SourceSystemModificationTimestamp": "2025-08-23T13:14:16.960" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "407.94335" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.91506" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "407.94335" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421571882')" +"provider_name": "One Key" +"Media": array:43 [ …43] +"ID": "28398" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5134 +post_id: "27946" +post_author: 1 +"ListingKey": "KEY421545063" +"ListingId": "903984" +"PropertyType": "Residential Lease" +"PropertySubType": "Apartment" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-01-04T07:03:37Z" +"RFModificationTimestamp": "2026-01-05T09:12:11Z" +"ListPrice": 2950.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1597.0 +"BuildingAreaTotal": 1597.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": null +"Coordinates": array:2 [ …2] +"Latitude": null +"Longitude": null +"YearBuilt": 1914 +"InternetAddressDisplayYN": false +"FeedTypes": "IDX" +"ListAgentFullName": "Lisa J. DeTurris" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "89375" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "2 Bedrooms, 1 bath, new kitchen, carpeting, large closets (walk-in), parking spot in driveway, top floor with separate entrance, tenant pays gas and electric and the landlord pays heat." +"Appliances": array:3 [ …3] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"AvailabilityDate": "2025-09-01" +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"CarportSpaces": "1" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-21T19:55:06.690669+00:00" +"CrossStreet": "Jefferson" +"CumulativeDaysOnMarket": 135 +"DaysOnMarket": 135 +"Directions": "Merrick Ave to Smith Street to Jefferson to Commonwealth" +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"Exclusions": "gas and electric" +"ExpirationDate": "2026-01-03" +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"Inclusions": "heat" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-477-4723" +"ListAgentEmail": "ldeturris@elliman.com" +"ListAgentKey": "326249313" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-08-21" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1435 +"LotSizeSquareFeet": 6250 +"MajorChangeTimestamp": "2026-01-03T21:07:03Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Expired" +"OffMarketDate": "2026-01-03" +"OnMarketDate": "2025-08-21" +"OriginalEntryTimestamp": "2025-08-21T19:47:23Z" +"OriginalListPrice": 2950 +"OriginatingSystemModificationTimestamp": "2026-01-03T21:07:03Z" +"OwnerName": "Mellilo" +"ParcelNumber": "2089-55-116-00-0287-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-13T13:59:36Z" +"PhotosCount": 14 +"PostalCity": "Merrick" +"PostalCodePlus4": "3430" +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-477-4723" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-03T21:07:03Z" +"StreetName": "Commonwealth" +"StreetNumber": "1924" +"StreetNumberNumeric": "1924" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_Village": "Hempstead" +"KEY_SmokingYN": "0" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "2950.00" +"KEY_WaterAccessYN": "0" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_PermitRequiredYN": "0" +"KEY_SecurityDeposits": "1 month" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "1597.00" +"KEY_RATIO_ListPrice_By_LivingArea": "1.84721" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "20557.4913" +"KEY_RATIO_CurrentPrice_By_LivingArea": "1.84721" +"KEY_SourceSystemModificationTimestamp": "2025-08-21T13:00:35.423" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.84721" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.84721" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421545063')" +"provider_name": "One Key" +"Media": array:14 [ …14] +"ID": "27946" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5135 +post_id: "27995" +post_author: 1 +"ListingKey": "KEY421525901" +"ListingId": "903457" +"PropertyType": "Commercial Lease" +"PropertySubType": "Business" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-11-21T07:04:39Z" +"RFModificationTimestamp": "2025-11-21T07:07:59Z" +"ListPrice": 1450.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 247.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "25 Merrick Ave Unit 25, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dorothy P. Powell SRES" +"ListOfficeName": "Realty Pros Plus Inc" +"ListAgentMlsId": "173882" +"ListOfficeMlsId": "RLTP01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Large, bright, private office for lease on 2nd floor in prestigious law office building. This office/ flex space, located in the south west wing also offers the addition of a beautiful adjoining client waiting room and private bathroom...with the possibility of two extra small office spaces for your admin/staff. All of this space is contiguous for a cohesive turn-key professional business presence that will surly impress your clients. Use of conference room included along with a receptionist on the first floor with a general waiting room to meet and greet your clients. Conveniently located next to train station and in the heart of Merrick Village with plenty of parking right behind building. This space is perfect for a professional: law, accounting, mortgage professional or similar industry. Note: Additional space use TBD -- inquire within. (1st floor handicap conference room also available for client convenience.)" +"AttributionContact": "516-804-9000" +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Professional/Office" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-491-1775" +"CoListAgentEmail": "realtyprosplus@gmail.com" +"CoListAgentFullName": "Dorothy P. Powell SRES" +"CoListAgentKey": "326184865" +"CoListAgentMlsId": "173882" +"CoListOfficeKey": "326115113" +"CoListOfficeMlsId": "RLTP01" +"CoListOfficeName": "Realty Pros Plus Inc" +"CoListOfficePhone": "516-804-9000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-26T18:17:58.545224+00:00" +"CumulativeDaysOnMarket": 87 +"DaysOnMarket": 87 +"Directions": "Located on the corner of Merrick Ave & Fisher Ave. just north of Sunrise Highway" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2025-11-21" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"Inclusions": "Two Additional Clerical Office Spaces Avail. w/waiting room" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseAmountFrequency": "Monthly" +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-491-1775" +"ListAgentEmail": "realtyprosplus@gmail.com" +"ListAgentKey": "326184865" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115113" +"ListOfficePhone": "516-804-9000" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-08-20" +"MajorChangeTimestamp": "2025-11-21T05:10:34Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"OffMarketDate": "2025-11-21" +"OnMarketDate": "2025-08-26" +"OriginalEntryTimestamp": "2025-08-26T18:12:42Z" +"OriginalListPrice": 1450 +"OriginatingSystemModificationTimestamp": "2025-11-21T05:10:34Z" +"OwnerName": "Krohn, Rosenblum & Rosenblum" +"PhotosChangeTimestamp": "2025-11-21T05:11:36Z" +"PhotosCount": 13 +"PostalCity": "Merrick" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516 868-0808" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-11-21T05:10:34Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Merrick Ave" +"StreetNumber": "25" +"StreetNumberNumeric": "25" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "73000" +"TaxYear": "2025" +"UnitNumber": "25" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_ElevatorYN": "0" +"KEY_SubleaseYN": "0" +"KEY_CurrentPrice": "1450.00" +"KEY_LeasePriceUnit": "Per SqFt" +"KEY_PreviousStatus": "Active" +"KEY_SecurityDeposits": "Yes" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_SourceSystemModificationTimestamp": "2025-08-20T12:29:54.887" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "5.87045" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "5.87045" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421525901')" +"provider_name": "One Key" +"Media": array:13 [ …13] +"ID": "27995" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5136 +post_id: "27917" +post_author: 1 +"ListingKey": "KEY421423698" +"ListingId": "900653" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-10-02T07:11:39Z" +"RFModificationTimestamp": "2025-10-02T07:15:46Z" +"ListPrice": 899000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2271.0 +"BuildingAreaTotal": 2322.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "11 E Webster Street, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.7571587 +"Longitude": -73.5997239 +"YearBuilt": 1938 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Louisa Borriello" +"ListOfficeName": "Charles Rutenberg Realty Inc" +"ListAgentMlsId": "117451" +"ListOfficeMlsId": "CHRU01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Spacious Expanded Cape in North Merrick – Room to Make It Your Own!\n Welcome to this warm and inviting 5-bedroom, 3-bath Expanded Cape, offering over 2,500 sq ft of well-designed living space on a 65 x 100 lot located in North Merrick.\n Step inside to a large living room with a fireplace, a formal dining room with potential for a butler’s pantry, and an oversized eat-in kitchen with sliding doors leading to a spacious covered porch—perfect for entertaining and everyday living.\n The first floor also includes two versatile bedrooms, ideal for a guest suite or home office, and a full bathroom. Upstairs, the expansive primary suite features his and her custom walk-in closets and a luxurious en-suite bath with Jacuzzi tub and separate shower. Two additional oversized bedrooms and a third full bath complete the second level.\n Additional highlights include basement with laundry, in-ground sprinklers, and a spacious backyard ready for your personal touch.\n Make this home with great bones and timeless charm—and with just a few finishing touches, it can truly shine. Whether you’re looking to move right in and update over time or customize to your taste, this home offers space, functionality, and endless potential """ +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "Louisa.Borriello@crrnys.com" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-19T23:36:28.925331+00:00" +"CrossStreet": "Merrick Avenue" +"CumulativeDaysOnMarket": 43 +"DaysOnMarket": 43 +"DirectionFaces": "South" +"Directions": "From Southern State Parkway to Merrick Avenue South, Make Left onto E Webster Street." +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-08-18" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-805-0318" +"ListAgentEmail": "Louisa.Borriello@crrnys.com" +"ListAgentKey": "326132990" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110310" +"ListOfficePhone": "516-575-7500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-19" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.1515 +"LotSizeDimensions": "65 x 100" +"LotSizeSquareFeet": 6500 +"MajorChangeTimestamp": "2025-10-01T18:19:17Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "Hold" +"OffMarketDate": "2025-10-01" +"OnMarketDate": "2025-08-19" +"OriginalEntryTimestamp": "2025-08-19T23:32:15Z" +"OriginalListPrice": 950000 +"OriginatingSystemModificationTimestamp": "2025-10-01T18:19:17Z" +"OwnerName": "Hubbard" +"ParcelNumber": "2089-56-073-00-0144-0" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "4" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-10-01T18:20:36Z" +"PhotosCount": 21 +"PostalCity": "Merrick" +"PostalCodePlus4": "2721" +"PreviousListPrice": 950000 …48 } 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5137 …123} 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5138 …135} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5139 …165} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5140 …108} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5141 …123} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5142 …129} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5143 …151} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5145 …138} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5114 …119} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5113 …153} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5112 …133} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5111 …135} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5110 …125} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5109 …165} ] +success: true +page_size: 32 +page_count: 6 +count: 166 +after_key: "" } "RF Response Time" => "0.18 seconds" ] ]