Begin your home search journey in Merrick, NY by browsing available listings in one place. This page is dedicated to showcasing current homes for sale, complete with essential details such as property type, Price filter, and zip code search. Whether you’re searching for your first home or your next upgrade, Merrick offers a variety of options to meet your needs. View homes with pools, renovated kitchens, or generous backyard space—all with current pricing and images. Start exploring the Merrick housing market today and filter your search based on your must-have features, budget, and lifestyle goals.
Our simple, step-by-step process ensures a smooth experience for buying new property without any worries or hustle.
Go through the our all listings and find the ideal home that is relevant for your requirements.
Click on the listing you like and then fill out the form to get start with your buying journey.
We guide buyers through offers and agreements to secure the best outcomes.
We handle all paperwork, ensure a smooth closing process, and support you through your next steps.
Our simple, step-by-step process ensures a smooth experience for buying new property without any worries or hustle.
We know Merrick NY street by street — not just by ZIP code. From districts to commute routes, we help you buy smarter based on real neighborhood insight.
You won’t find any sales pressure here. We focus on what works best for you, offering honest input so you can make confident, informed choices.
You won’t be left waiting on answers. We stay connected through every step of the process, so your questions get real replies — not delays.
We tap into local networks to get early access to listings — giving you a head start in a competitive market.
From inspections to paperwork, we manage the chaos so you can focus on the fun part — finding a place you’ll love.
Tight schedule? Need to tour after hours or on weekends? We’re flexible. We work how and when it’s convenient for you.
It’s not just about buying now — we’ll help you choose a home that fits future needs too, like family growth or property value trends.
We’re not here to just close a deal. We look out for your best interest like we would for our own family. Every decision is made with care.
Read what our clients have to say about their experience with us
I highly recommend Kaya Homes if you are looking to buy or sell your home. My home was sold for over ask within 1 week! The process was so simple and easy. Avi had a professional photographer photograph our home and has excellent marketing strategies which led to a speedy transaction. Thank you !!!
Bad Services.
KAYA Homes, and specifically Kamy, is a real estate business with a heart. Before I signed a contract Kamy gave me months of her time, business acumen and understanding. I have bought/sold my homes over many decades. Never have I known a realtor to be so incredibly kind. Everything about how KAYA Homes conduct their business is above reproach.
I had the absolute pleasure of working with Kamy when leasing my new apartment, and I couldn't be happier with the experience! She was fantastic to work with, simplifying the rental process and providing thorough explanations every step of the way. Highly recommend!
This is the third year im using Kaya Homes for my rental, they are very professional. They walk you through everything from start to finish. The owner Kami is awesome!! She is very responsive A+ I highly recommend kaya homes!!
We started our journey with Kaya homes a while back when my husband met Kamy. He knew instantly that we found the right ones to help us with purchasing a new home. Kamy is highly responsive, thoughtful, considerate and very professional on her approach with finding you the right home. We wanted to stay in the area and with such a crazy market, I didn't think it would be possible for us to find our home, but we did. Kamy's reassured us and said we will find your home and we did. Thank you Kamy and also meeting Izzy was a bonus, great family owned business, truly you will not be disappointed. If you are looking to rent, own or sell give them a call.
Absolutely wonderful to work with! I highly suggest if you are looking or selling she is definitely your go to!
Amazing experience with Kaya Homes. She was very helpful and found us our dream home as fast as anyone could wish for!
WOW! Kamy went above and beyond to find us an apartment, my lease was over and I needed to move ASAP and couldn’t find any rentals but when I got in contact with Kamy at Kaya Homes she casted all my worries and stress away. I’ve worked with other realtors in the past which was ok but Kaya Homes over exceeded all of my expectations. Kamy was able to find us a beautiful contemporary apartment in the neighborhood that I appointed and that fit right in our price range within a month we moved in. Kamy is extremely kind, friendly, transparent professional, communicative and easy to reach to answer any of our questions at all times. In addition, since we’ve moved the landlord continues to maintain the apartment beautifully: they provide a cleaning service who comes in to clean inside and outside the complex, landscaper comes weekly, the garbage is pick up 2-3x a week, if there’s ever any issue or something needs fixing they send someone the next day which is a plus because you know they CARE AND APPRECIATE THEIR TENANTS. I recommend Kaya Homes to all my friends & family and to anyone who needs a realtor because they are simply the VERY BEST IN THE BUSINESS. Thank you again Kamy.
I had the pleasure of working on my home selling with Kaya homes and specialty with Kamy Roditi who is a very professional and reliable person. Kamy worked very on my transaction with a fair and quick way and honestly without her my home would not have been sold as fast and for the best possible price as it was. I would highly recomand Kaya homes and Kamy for any Real Estate and business venture, selling and buying Real Estate .
If you are in the market for a new home, I highly recommend going to see Kamy Roditi @ Kaya Homes. She is one of the most knowledgeable realtors I've ever met in the industry hands down. She's honest, trustworthy, responsive and an all around pleasure to work with. She worked diligently to help find the perfect house for my family and smoothly guided me through the process by answering all of my questions thoroughly. Buying a new home can be stressful, but it doesn't have to be if your lucky enough to work with Kamy Roditi. You'll be in good hands, I promise!
I thought about selling my house myself and I’m so glad I didn’t. Kaya Homes was a total blessing for me, the buyers of my home were beyond difficult and they handled every step for me beyond my expectations. They took the stress off of me entirely. I’d highly recommend them to anyone. Thank you again Kaya Homes!!
Highly recommend the team at Kaya Homes. The team is not only knowledgeable but also provides great advice for all real estate needs. Weather your looking to buy, sell, rent or get advice, Kaya homes should be your first call.
array:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=32&$skip=64&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (City eq 'Merrick' or PostalCity eq 'Merrick')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5108 +items: array:32 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5122 +post_id: "31027" +post_author: 1 +"ListingKey": "KEY424231191" +"ListingId": "981093" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-02T18:09:43Z" +"RFModificationTimestamp": "2026-05-02T18:10:23Z" +"ListPrice": 625000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1326.0 +"BuildingAreaTotal": 1326.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "8 Garden Place, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6667245 +"Longitude": -73.5648765 +"YearBuilt": 1951 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Michelle Folan" +"ListOfficeName": "Coldwell Banker M&D Good Life" +"ListAgentMlsId": "505006" +"ListOfficeMlsId": "MJM04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Endless Potential – Bring Your Vision!\n Calling all investors, contractors, and savvy buyers! This property is a prime opportunity for a full renovation or rebuild. Situated on a desirable lot, this 4 bedroom 1 bath home is ready for transformation and offers the chance to create something truly special. Conveniently located near the LIRR (approximately 0.8 miles), Jones Beach, shopping, and schools, this is an opportunity you won’t want to miss! With the right vision and updates, the possibilities are endless. Sold as-is—bring your imagination and make it your next successful project! """ +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-929-3700" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-29T15:20:08.936799+00:00" +"CrossStreet": "Meadowbrook Rd" +"CumulativeDaysOnMarket": 3 +"DaysOnMarket": 3 +"DirectionFaces": "South" +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-12-31" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-882-8150" +"ListAgentEmail": "mfolan@mdgoodlife.com" +"ListAgentKey": "421613796" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113722" +"ListOfficePhone": "631-929-3700" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-04" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.1607 +"LotSizeSquareFeet": 7000 +"MajorChangeTimestamp": "2026-04-29T15:10:59Z" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-04-29" +"OriginalEntryTimestamp": "2026-04-29T15:10:59Z" +"OriginalListPrice": 625000 +"OriginatingSystemModificationTimestamp": "2026-05-02T18:08:19Z" +"OwnerName": "Eileen R Dahlen" +"ParcelNumber": "2089-55-099-00-0312-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-29T15:03:36Z" +"PhotosCount": 12 +"PostalCity": "Merrick" +"PostalCodePlus4": "3308" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-882-8150" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-29T15:10:59Z" +"StreetName": "Garden" +"StreetNumber": "8" +"StreetNumberNumeric": "8" +"StreetSuffix": "Place" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14065" +"TaxAssessedValue": 487 +"TaxYear": "2026" +"Utilities": array:7 [ …7] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Crawl" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "625000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "1" +"KEY_DistanceToTrain": "0.80" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "1" +"KEY_LivingAreaSearchSqFt": "1326.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "471.34238" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "3889234.5986" +"KEY_RATIO_CurrentPrice_By_LivingArea": "471.34238" +"KEY_SourceSystemModificationTimestamp": "2026-04-06T12:09:06.640" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "471.34238" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "471.34238" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424231191')" +"provider_name": "One Key" +"Media": array:12 [ …12] +"ID": "31027" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5124 +post_id: "30678" +post_author: 1 +"ListingKey": "KEY424230052" +"ListingId": "981057" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-23T07:11:38Z" +"RFModificationTimestamp": "2026-04-23T07:14:58Z" +"ListPrice": 1199999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2371.0 +"BuildingAreaTotal": 2656.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1968 Cynthia Lane, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6429311 +"Longitude": -73.547466 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nadene J. Katz" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "113424" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this 4 bedroom, 2.5 bath Splanch with exceptional curb appeal, offering a striking stacked stone front with classic siding. This well maintained home features an updated kitchen with granite countertops and rich cabinetry leading into a formal dining room. A cozy family room completes the first floor. Just up a short staircase you will find a welcoming living room with a wood burning fireplace. Upstairs you will find generously sized bedrooms including a primary suite. Updated roof and gas heating system. Outside in the backyard you will find a beautiful paver patio. Flood Zone X. Interior sq footage is approximate." +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-796-8900" +"BuyerAgentEmail": "carrie1060@aol.com" +"BuyerAgentFullName": "Carrie Rubinstein" +"BuyerAgentKey": "326134148" +"BuyerAgentMlsId": "118705" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326109932" +"BuyerOfficeMlsId": "BRMN01" +"BuyerOfficeName": "Coldwell Banker American Homes" +"BuyerOfficePhone": "516-796-8900" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-546-6300" +"CoListAgentEmail": "dgerber@signaturepremier.com" +"CoListAgentFullName": "Denise Gerber" +"CoListAgentKey": "326143776" +"CoListAgentMlsId": "129339" +"CoListOfficeKey": "326115717" +"CoListOfficeMlsId": "SPH09" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "516-546-6300" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-06T17:43:26.040946+00:00" +"CrossStreet": "Stanley" +"CumulativeDaysOnMarket": 15 +"DaysOnMarket": 15 +"DirectionFaces": "East" +"Disclosures": array:2 [ …2] +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-04-06" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-546-6300" +"ListAgentEmail": "nkatz@signaturepremier.com" +"ListAgentKey": "326129248" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-06" +"LivingAreaSource": "Public Records" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.1647 +"LotSizeDimensions": "76x87" +"LotSizeSquareFeet": 7176 +"MajorChangeTimestamp": "2026-04-22T15:46:01Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-22" +"OnMarketDate": "2026-04-06" +"OriginalEntryTimestamp": "2026-04-06T17:37:27Z" +"OriginalListPrice": 1199999 +"OriginatingSystemModificationTimestamp": "2026-04-22T15:46:01Z" +"OwnerName": "Weitzman" +"ParcelNumber": "2089-62-221-00-0012-0" +"ParkingFeatures": array:3 [ …3] +"ParkingTotal": "4" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-10T01:51:36Z" +"PhotosCount": 32 +"PostalCity": "Merrick" +"PostalCodePlus4": "5110" +"PurchaseContractDate": "2026-04-21" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-698-4372" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-22T15:46:01Z" +"StreetName": "Cynthia" +"StreetNumber": "1968" +"StreetNumberNumeric": "1968" +"StreetSuffix": "Lane" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "19013.37" +"TaxAssessedValue": 735 +"TaxBlock": "221" +"TaxLot": "12" +"TaxYear": "2026" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "62" +"KEY_CurrentPrice": "1199999.00" +"KEY_ContractPrice": "1380000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalRooms": "Dining Area,Library/Den" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2371.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-317-1223" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "506.11514" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7285968.4274" +"KEY_RATIO_CurrentPrice_By_LivingArea": "506.11514" +"KEY_SourceSystemModificationTimestamp": "2026-04-06T11:32:32.717" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "451.80685" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "451.80685" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424230052')" +"provider_name": "One Key" +"Media": array:32 [ …32] +"ID": "30678" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5121 +post_id: "30672" +post_author: 1 +"ListingKey": "KEY424225267" +"ListingId": "980910" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-30T00:34:36Z" +"RFModificationTimestamp": "2026-04-30T00:38:53Z" +"ListPrice": 779000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1292.0 +"BuildingAreaTotal": 1292.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "9 Aster Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6922705 +"Longitude": -73.5629246 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marlene S. Gross" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "145419" +"ListOfficeMlsId": "SPH15" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Beautiful & Totally Turn-key Home in Desirable North Merrick SD#29!! This Beauty Boasts a New Kitchen w/ Island/Quartz Ctrps/SS Appls/Pot Filler/Undermount Sink/Water Filtration Reverse Osmosis on Frig/Garbage Disposal, Dining Area, 4 Bedrooms, 2 Updated Full Bathrooms, Cozy Den/Office with Sliders to Yard, Recessed Lighting, New 200 Amp Electric, Gas Heat & Central Air Thruout, Smart Thermostat, All New Siding/Andersen Windows/Exterior Doors/Driveway, New PVC Fencing, IGS System, Attached Garage w/ New Sheetrock & Loft Space for Storage, Huge Unfinished Basement w/ High Ceilings, 3 Skylights, Large & Gated 88' wide Yard with Patio/Electric Awning/New Pergola/Gardening Beds & So Much More! Commuters Delight...Only 2 blocks from Southern State Pkwy & Very Closet to Stores. Wow...Don't Miss this One!!" +"Appliances": array:10 [ …10] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-766-7900" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "631-625-4500" +"BuyerAgentEmail": "GinaLollo@northshorepropertiesrealty.com" +"BuyerAgentFullName": "Gina R. Lollo CBR" +"BuyerAgentKey": "326163525" +"BuyerAgentMlsId": "150790" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326114153" +"BuyerOfficeMlsId": "NRSH01" +"BuyerOfficeName": "Northshore Properties Realty" +"BuyerOfficePhone": "631-625-4500" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-06T15:26:25.754650+00:00" +"CrossStreet": "Columbine" +"CumulativeDaysOnMarket": 6 +"DaysOnMarket": 6 +"Directions": "Southern State to Jersulam to Aster Ave. House on Right Side." +"ElementarySchool": "Harold D Fayette School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2027-04-05" +"Fencing": array:1 [ …1] +"Flooring": array:2 [ …2] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-766-7900" +"ListAgentEmail": "marlenegross@optonline.net" +"ListAgentKey": "326158440" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115723" +"ListOfficePhone": "516-766-7900" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-05" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.1928 +"LotSizeDimensions": "88X95" +"LotSizeSquareFeet": 8400 +"MajorChangeTimestamp": "2026-04-30T00:33:12Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-14" +"OnMarketDate": "2026-04-08" +"OriginalEntryTimestamp": "2026-04-06T15:22:26Z" +"OriginalListPrice": 779000 +"OriginatingSystemModificationTimestamp": "2026-04-30T00:33:12Z" +"OwnerName": "Gatoff" +"ParcelNumber": "2089-50-357-00-0001-0" +"ParkingFeatures": array:3 [ …3] +"ParkingTotal": "3" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-09T18:17:36Z" +"PhotosCount": 24 +"PostalCity": "Merrick" +"PostalCodePlus4": "1137" +"PurchaseContractDate": "2026-04-29" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-359-8152" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-30T00:33:12Z" +"StreetName": "Aster" +"StreetNumber": "9" +"StreetNumberNumeric": "9" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "14730.42" +"TaxYear": "2026" +"Utilities": array:6 [ …6] +"VirtualTourURLUnbranded": "https://homediagroup.com/9-Aster-Ave/idx" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"KEY_Attic": "Storage" +"KEY_HoldDate": "2026-04-14" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "779000.00" +"KEY_ContractPrice": "871599.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1292.00" +"KEY_NumberOfHeatingZones": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "602.94118" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4040456.4315" +"KEY_RATIO_CurrentPrice_By_LivingArea": "602.94118" +"KEY_SourceSystemModificationTimestamp": "2026-04-06T03:38:13.817" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "602.94118" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "602.94118" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424225267')" +"provider_name": "One Key" +"Media": array:24 [ …24] +"ID": "30672" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5125 +post_id: "30857" +post_author: 1 +"ListingKey": "KEY424208899" +"ListingId": "980431" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-28T18:05:36Z" +"RFModificationTimestamp": "2026-04-28T18:24:05Z" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2200.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2187 Loines Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6705961 +"Longitude": -73.5482507 +"YearBuilt": 1968 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Teri Catapano Black" +"ListOfficeName": "Century 21 Catapano Homes" +"ListAgentMlsId": "9007878" +"ListOfficeMlsId": "JOCA01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Stunning colonial 4 bedrooms, 2.5 baths with exceptional curb appeal. Nestled in the highly desirable Merrick community and located within the top rated Merrick school district. The property is set in beautiful Merrick Woods close to essential amenities such as supermarkets, shopping, and a 0.8 mile to the LIRR. The main level includes a large foyer, spacious living room, an elegant formal dining room, eat in kitchen and a cozy family room with a fireplace. Sliding doors open seamlessly to the deck, fenced in backyard, creating an ideal setting for indoor outdoor living and entertaining. Hardwood floors throughout the house with abundant natural light. The upper level includes 4 bedrooms, laundry room, and an oversized king size plus primary bedroom with a walk in closet and full bath. The layout complements the well-maintained interior with convenient access to the garage. Enjoy the natural light in the large basement which includes new full size windows. Additional highlights include gas heating, central air conditioning, hardwood and tile flooring. Convenient to the Amazing Hamlet of Merrick with lots of shopping, restaurants, recreation and LIRR station. A Real Gem that is Beautifully maintained. Don't delay on this beauty!" +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-938-0021" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-574-3491" +"BuyerAgentEmail": "kaitlynn.mccartney@compass.com" +"BuyerAgentFullName": "Kaitlynn McCartney" +"BuyerAgentKey": "326222507" +"BuyerAgentMlsId": "213328" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110404" +"BuyerOfficeMlsId": "CMPA07" +"BuyerOfficeName": "Compass Greater NY LLC" +"BuyerOfficePhone": "516-764-6060" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-938-0021" +"CoListAgentEmail": "moerlerlynch@aol.com" +"CoListAgentFullName": "Linda M. Lynch" +"CoListAgentKey": "326176098" +"CoListAgentMlsId": "164391" +"CoListOfficeKey": "326112634" +"CoListOfficeMlsId": "JOCA01" +"CoListOfficeName": "Century 21 Catapano Homes" +"CoListOfficePhone": "516-938-0021" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-15T14:42:19.562044+00:00" +"CumulativeDaysOnMarket": 6 +"DaysOnMarket": 6 +"DirectionFaces": "South" +"Disclosures": array:2 [ …2] +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-07-15" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:2 [ …2] +"GarageSpaces": "1.5" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentEmail": "C21TeriBlack@gmail.com" +"ListAgentKey": "326251382" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112634" +"ListOfficePhone": "516-938-0021" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-15" +"LivingAreaSource": "Public Records" +"LotFeatures": array:2 [ …2] +"LotSizeAcres": 0.1377 +"LotSizeDimensions": "60 x 100" +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-04-28T18:04:06Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-21" +"OnMarketDate": "2026-04-15" +"OriginalEntryTimestamp": "2026-04-15T14:35:11Z" +"OriginalListPrice": 1100000 +"OriginatingSystemModificationTimestamp": "2026-04-28T18:04:06Z" +"OwnerName": "Reantillo" +"ParcelNumber": "2089-56-095-00-0069-0" +"ParkingFeatures": array:5 [ …5] +"ParkingTotal": "3" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-15T14:37:36Z" +"PhotosCount": 34 +"PostalCity": "Merrick" +"PurchaseContractDate": "2026-04-27" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "855-953-8211" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-28T18:04:06Z" +"StreetName": "Loines" +"StreetNumber": "2187" +"StreetNumberNumeric": "2187" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17422.66" +"TaxAssessedValue": 634 +"TaxBlock": "95" +"TaxLot": "69" +"TaxYear": "2026" +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full,Pull Stairs" +"KEY_HoldDate": "2026-04-21" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1100000.00" +"KEY_ContractPrice": "1230000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_DistanceToTrain": "0.80" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2200.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-777-2424" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "500.00000" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7988380.5374" +"KEY_RATIO_CurrentPrice_By_LivingArea": "500.00000" +"KEY_SourceSystemModificationTimestamp": "2026-04-03T13:15:34.563" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424208899')" +"provider_name": "One Key" +"Media": array:34 [ …34] +"ID": "30857" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5123 +post_id: "30655" +post_author: 1 +"ListingKey": "KEY424196684" +"ListingId": "980076" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-25T17:49:36Z" +"RFModificationTimestamp": "2026-04-25T17:51:33Z" +"ListPrice": 1049000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2000.0 +"BuildingAreaTotal": 2550.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "19 Rugby Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6558735 +"Longitude": -73.5625939 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Vullnet Limanoski" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "501444" +"ListOfficeMlsId": "SPH18" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Be the first to own this stunning, newly expanded custom-built home, thoughtfully designed for modern living. Showcasing exceptional craftsmanship and high-end finishes throughout, this 5-bedroom, 3- Full bathroom residence offers a spacious and functional layout ideal for both everyday living and effortless entertaining. Step inside to a bright, open-concept interior featuring a generous living and dining area filled with abundant natural light from oversized, energy-efficient new construction windows. The seamless flow creates an inviting atmosphere perfect for gatherings or quiet relaxation. The kitchen is a true centerpiece, complete with brand-new appliances, custom cabinetry, expansive countertop space, and a large center island—perfect for cooking, hosting, and everyday convenience. The master bedroom offers high cathedral ceilings, a beautifully appointed en-suite bathroom, and dual closets. Additional bedrooms are well-proportioned, each with its own closet, providing flexibility for guests, a home office, or growing needs. Built with quality and efficiency in mind, this home features brand-new, high-efficiency heating and cooling systems, helping to reduce maintenance and energy costs for years to come. Additional highlights include a full standing attic and its original full basement layout, that is finished. Offering ample storage and usable space. Enjoy outdoor living in the private backyard, complemented by a long, newly paved driveway and a generously sized detached garage. Ideally situated in the heart of Merrick, this home presents a rare opportunity to enjoy the feel of owning a new construction quality style home without the added tax burden. Conveniently located to award-winning Merrick schools, shopping, dining, parks, and major transportation routes. Interior Square footage is approximate." +"Appliances": array:13 [ …13] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-799-7100" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-603-1456" +"BuyerAgentEmail": "Christopher.white@compass.com" +"BuyerAgentFullName": "Christopher White" +"BuyerAgentKey": "326209008" +"BuyerAgentMlsId": "199453" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110407" +"BuyerOfficeMlsId": "CMPA10" +"BuyerOfficeName": "Compass Greater NY LLC" +"BuyerOfficePhone": "516-517-4866" +"ConstructionMaterials": array:5 [ …5] +"Cooling": array:2 [ …2] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-02T19:18:52.406449+00:00" +"CumulativeDaysOnMarket": 14 +"DaysOnMarket": 14 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-09" +"Fencing": array:3 [ …3] +"Flooring": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:18 [ …18] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:4 [ …4] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-585-9768" +"ListAgentEmail": "vlimanoski@signaturepremier.com" +"ListAgentKey": "406620213" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115726" +"ListOfficePhone": "516-799-7100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-02" +"ListingTerms": "Cash,Conventional,FHA" +"LivingAreaSource": "Other" +"LotFeatures": array:8 [ …8] +"LotSizeAcres": 0.1033 +"LotSizeDimensions": "45X100" +"LotSizeSquareFeet": 4500 +"MajorChangeTimestamp": "2026-04-25T17:48:17Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-24" +"OnMarketDate": "2026-04-10" +"OriginalEntryTimestamp": "2026-04-02T19:14:05Z" +"OriginalListPrice": 1049000 +"OriginatingSystemModificationTimestamp": "2026-04-25T17:48:17Z" +"OtherStructures": array:1 [ …1] +"OwnerName": "Kemal Limani" +"ParcelNumber": "2089-55-178-00-0118-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-04T00:05:36Z" +"PhotosCount": 39 +"PostalCity": "Merrick" +"PostalCodePlus4": "3704" +"PriceChangeTimestamp": "2026-04-02T19:14:05Z" +"PurchaseContractDate": "2026-04-24" +"RoomsTotal": "11" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-585-9768" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-25T17:48:17Z" +"StreetName": "Rugby" +"StreetNumber": "19" +"StreetNumberNumeric": "19" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "11695.67" +"TaxAssessedValue": 411 +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"YearBuiltEffective": 2026 +"KEY_Attic": "Full,Pull Stairs,Storage" +"KEY_HoldDate": "2026-04-24" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1049000.00" +"KEY_ContractPrice": "1150000.00" +"KEY_OpenHouseCount": "4" +"KEY_PreviousStatus": "Hold" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2000.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "524.50000" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "10154888.6738" +"KEY_RATIO_CurrentPrice_By_LivingArea": "524.50000" +"KEY_SourceSystemModificationTimestamp": "2026-04-02T15:14:05.273" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "411.37255" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "411.37255" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424196684')" +"provider_name": "One Key" +"Media": array:39 [ …39] +"ID": "30655" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5120 +post_id: "30647" +post_author: 1 +"ListingKey": "KEY424163378" +"ListingId": "979221" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T19:26:36Z" +"RFModificationTimestamp": "2026-04-29T19:31:00Z" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3687.0 +"BuildingAreaTotal": 3687.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "57 Maeder Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6791955 +"Longitude": -73.5646755 +"YearBuilt": 2026 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rosanna Sordilli" +"ListOfficeName": "Charles Rutenberg Realty Inc" +"ListAgentMlsId": "192166" +"ListOfficeMlsId": "CHRU01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this beautiful newly constructed center hall colonial set on a oversized 75ft x 125ft lot. Featuring 3687 sq feet of living space with no detail spared! \n This home includes 5 bedrooms, 3 full baths. Hardwood floors, custom EIK with large island, Quartz countertops, marble backsplash, SS Bertazzoni appliances, including a wine fridge, microwave drawer and double wall oven. 1st floor features 9ft ceilings with custom molding work throughout with a great room w/gas fireplace and built-in custom bookshelves. FDR, LR, Bdrm and full bath and 2 car garage. 2nd floor features a Main suite with vaulted ceilings, and 2 custom WICs. 3 additional bedrooms, 1 bath and a walk-in laundry room. Full basement with 8ft ceilings, 2 zone heating and CAC. Outside features a brick pavered driveway, brick pavered back patio. PVC fence around perimeter of house. Cellar entrance, Front and back steps are brick with bluestone steps with rot iron railings. This home also includes in-ground sprinklers in front and back yard and fully grassed (sod). Alarm system connection installed. Make this beautiful home your own! """ +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "rpfeffer@crrli.net" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-02T12:14:30.810232+00:00" +"CrossStreet": "Henry Rd" +"CumulativeDaysOnMarket": 26 +"DaysOnMarket": 29 +"Directions": "Southern state to exit 24S. left on Henry Rd, left onto Maeder avenue." +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2027-04-01" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:12 [ …12] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-857-8219" +"ListAgentEmail": "Rosanna.sordilli@crrnys.com" +"ListAgentKey": "326202012" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110310" +"ListOfficePhone": "516-575-7500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-02" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.215 +"LotSizeDimensions": "75 x 125" +"LotSizeSquareFeet": 9375 +"MajorChangeTimestamp": "2026-04-05T16:56:16Z" +"MajorChangeType": "Back On Market" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-04-02" +"OriginalEntryTimestamp": "2026-04-02T12:10:33Z" +"OriginalListPrice": 1750000 +"OriginatingSystemModificationTimestamp": "2026-04-29T19:25:23Z" +"OwnerName": "VR Homes LLC" +"ParcelNumber": "2089-55-009-00-0669-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-04-02T12:11:36Z" +"PhotosCount": 39 +"PostalCity": "Merrick" +"PostalCodePlus4": "2321" +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5168578219" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-05T16:56:16Z" +"StreetName": "Maeder" +"StreetNumber": "57" +"StreetNumberNumeric": "57" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAssessedValue": 428 +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full,Unfinished" +"KEY_HoldDate": "2026-04-04" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1750000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Hold" +"KEY_OpenHouseUpcoming": "Public: Sun May 3, 1:00PM-3:00PM" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Back On Market" +"KEY_LivingAreaSearchSqFt": "3687.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "1" +"KEY_DownPaymentResourceYN": "0" +"KEY_OpenHousePublicUpcoming": "Public: Sun May 3, 1:00PM-3:00PM" +"KEY_RATIO_ListPrice_By_LivingArea": "474.64063" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8139534.8837" +"KEY_RATIO_CurrentPrice_By_LivingArea": "474.64063" +"KEY_SourceSystemModificationTimestamp": "2026-03-31T22:31:37.877" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "474.64063" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "474.64063" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424163378')" +"provider_name": "One Key" +"Media": array:39 [ …39] +"ID": "30647" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5119 +post_id: "30603" +post_author: 1 +"ListingKey": "KEY424114983" +"ListingId": "977685" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-12T19:09:50Z" +"RFModificationTimestamp": "2026-04-12T19:12:36Z" +"ListPrice": 1345000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2373.0 +"BuildingAreaTotal": 3373.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2292 Vassar Place, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6601241 +"Longitude": -73.5591105 +"YearBuilt": 1954 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Larissa N. Marin" +"ListOfficeName": "Blackstone Realty" +"ListAgentMlsId": "194140" +"ListOfficeMlsId": "RCHB01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this stunning, fully renovated luxury residence that perfectly blends modern elegance with everyday comfort. This expansive 5-bedroom, 3-bathroom home offers exceptional space, high-end finishes and thoughtful design throughout. Step inside to discover a bright, open-concept layout featuring gleaming floors, custom millwork and designer touches at every turn. The gourmet kitchen is a true centerpiece, outfitted with premium appliances, sleek cabinetry, and elegant countertops, ideal for both entertaining and daily living.\n The spacious bedrooms provide comfort and versatility, while the beautifully updated bathrooms showcase contemporary style and quality craftsmanship. A fully finished basement adds valuable living space, perfect for a home theater, gym, playroom, or guest suite. Outside, enjoy a private setting ideal for relaxation or hosting gatherings. Every detail of this home has been carefully curated to offer a turnkey luxury lifestyle. Located in the desirable Merrick community, this exceptional property is close to parks, shopping, dining, and transportation. Move right in and experience the perfect combination of sophistication, space and convenience, this is the home you’ve been waiting for. """ +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-802-3939" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-28T03:33:35.256202+00:00" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 36 +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-27" +"GarageSpaces": "1" +"Heating": array:1 [ …1] +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "646-508-9514" +"ListAgentEmail": "Larymarin90@gmail.com" +"ListAgentKey": "326203893" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114911" +"ListOfficePhone": "516-802-3939" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-27" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1722 +"LotSizeSquareFeet": 7500 +"MajorChangeTimestamp": "2026-03-28T03:28:17Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-03-27" +"OriginalEntryTimestamp": "2026-03-28T03:28:17Z" +"OriginalListPrice": 1345000 +"OriginatingSystemModificationTimestamp": "2026-04-12T19:08:18Z" +"OwnerName": "Diamond Dev Properties Corp" +"ParcelNumber": "2089-55-147-00-0122-0" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2" +"PhotosChangeTimestamp": "2026-03-28T03:34:36Z" +"PhotosCount": 34 +"PostalCity": "Merrick" +"PostalCodePlus4": "3816" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "646-508-9514" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-28T03:28:17Z" +"StreetName": "Vassar" +"StreetNumber": "2292" +"StreetNumberNumeric": "2292" +"StreetSuffix": "Place" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17636.34" +"TaxAssessedValue": 581 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Other" +"KEY_CurrentPrice": "1345000.00" +"KEY_OpenHouseCount": "2" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "2373.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "566.79309" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7810685.2497" +"KEY_RATIO_CurrentPrice_By_LivingArea": "566.79309" +"KEY_SourceSystemModificationTimestamp": "2026-03-27T23:15:06.617" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "398.75482" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "398.75482" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424114983')" +"provider_name": "One Key" +"Media": array:34 [ …34] +"ID": "30603" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5126 +post_id: "30588" +post_author: 1 +"ListingKey": "KEY424095969" +"ListingId": "977173" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-27T09:01:46Z" +"RFModificationTimestamp": "2026-03-27T09:05:12Z" +"ListPrice": 950000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1631.0 +"BuildingAreaTotal": 1631.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1656 Michalicki Place, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.671593 +"Longitude": -73.5686562 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jaime H. Mesa" +"ListOfficeName": "RE/MAX Team" +"ListAgentMlsId": "9012366" +"ListOfficeMlsId": "CSQU04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Excellent House in a quiet Block. Great Location in Merrick . Close to All Amenities, Worship, Schools and Shopping. Close to Meadowbrook Parkway. Property includes Garage, Private Driveway and Backyard." +"Appliances": array:3 [ …3] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "718-429-4400" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-26T23:40:00.334730+00:00" +"CrossStreet": "Meadowbrook Road" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 38 +"Directions": "Meadowbrook Road to Michalicki Place" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-09-27" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchoolDistrict": "North Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "347-684-4135" +"ListAgentEmail": "jaimehmesa@hotmail.com" +"ListAgentKey": "326251992" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110587" +"ListOfficePhone": "718-429-4400" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-26" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1326 +"LotSizeDimensions": "55x108" +"LotSizeSquareFeet": 5778 +"MajorChangeTimestamp": "2026-03-26T23:37:14Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchoolDistrict": "North Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-03-26" +"OriginalEntryTimestamp": "2026-03-26T23:37:14Z" +"OriginalListPrice": 950000 +"OriginatingSystemModificationTimestamp": "2026-03-27T09:00:23Z" +"OwnerName": "Mario Rodriguez" +"ParcelNumber": "2089-55-094-00-1364-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-26T23:38:36Z" +"PhotosCount": 4 +"PostalCity": "Merrick" +"PostalCodePlus4": "2509" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "347 684-4135" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-26T23:37:14Z" +"StreetName": "Michalicki" +"StreetNumber": "1656" +"StreetNumberNumeric": "1656" +"StreetSuffix": "Place" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13725.73" +"TaxAssessedValue": 508 +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "950000.00" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "1631.00" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "582.46475" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "7164404.2232" +"KEY_RATIO_CurrentPrice_By_LivingArea": "582.46475" +"KEY_SourceSystemModificationTimestamp": "2026-03-26T19:33:21.840" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "582.46475" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "582.46475" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424095969')" +"provider_name": "One Key" +"Media": array:4 [ …4] +"ID": "30588" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5127 +post_id: "30859" +post_author: 1 +"ListingKey": "KEY424087088" +"ListingId": "976907" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2026-04-24T07:09:41Z" +"RFModificationTimestamp": "2026-04-24T07:15:27Z" +"ListPrice": 850000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1808.0 +"BuildingAreaTotal": 1836.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "5 Hawthorne Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.670173 +"Longitude": -73.556785 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Arlene Gregory" +"ListOfficeName": "Coldwell Banker American Homes" +"ListAgentMlsId": "77860" +"ListOfficeMlsId": "BRMN01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ This charming split-level home is located on a quiet street in the desirable Merrick Lea section.This home is zoned for the Chatterton Elementary School. .\n This spacious 1808 square foot home features an 8 room layout including an oversized den and an expansive primary suite featuring a private bath with a Jacuzzi tub. Notable amenities include hardwood floors throughout, a dedicated laundry room, gas-powered hot air heat, and central air (installed in 2020) & inground sprinklers. The outdoor space is perfect for entertaining with a backyard deck, while the existing sheds and swing set are included as gifts. """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-796-8900" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-15T14:41:10.630166+00:00" +"CrossStreet": "Alfred Rd East" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 8 +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-30" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-817-9222" +"ListAgentEmail": "agregory@CBamhomes.com" +"ListAgentKey": "326240888" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109932" +"ListOfficePhone": "516-796-8900" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-15" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-04-23T14:51:39Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:3 [ …3] +"MlsStatus": "Hold" +"OffMarketDate": "2026-04-23" +"OnMarketDate": "2026-04-15" +"OriginalEntryTimestamp": "2026-04-15T14:38:20Z" +"OriginalListPrice": 850000 +"OriginatingSystemModificationTimestamp": "2026-04-23T14:51:39Z" +"OwnerName": "Edward & Jill McAvoy" +"ParcelNumber": "2089-55-514-00-0022-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-15T14:39:36Z" +"PhotosCount": 34 +"PostalCity": "Merrick" +"PostalCodePlus4": "3025" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-796-8900" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-23T14:51:39Z" +"StreetName": "Hawthorne" +"StreetNumber": "5" +"StreetNumberNumeric": "5" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17239.62" +"TaxAssessedValue": 564 +"TaxLot": "22" +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_HoldDate": "2026-04-23" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "53" +"KEY_ConcessionYN": "1" +"KEY_CurrentPrice": "850000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "1808.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "470.13274" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6172839.5062" +"KEY_RATIO_CurrentPrice_By_LivingArea": "470.13274" +"KEY_SourceSystemModificationTimestamp": "2026-03-26T12:46:55.617" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "462.96296" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "462.96296" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424087088')" +"provider_name": "One Key" +"Media": array:34 [ …34] +"ID": "30859" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5128 +post_id: "30581" +post_author: 1 +"ListingKey": "KEY424082616" +"ListingId": "976782" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-07T07:06:41Z" +"RFModificationTimestamp": "2026-04-07T07:11:04Z" +"ListPrice": 719000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1764.0 +"BuildingAreaTotal": 1764.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1165 Meadowbrook Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6922622 +"Longitude": -73.5670164 +"YearBuilt": 1920 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Thomas J. Nails" +"ListOfficeName": "Coldwell Banker American Homes" +"ListAgentMlsId": "107887" +"ListOfficeMlsId": "BRMN02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this charming 1,764 sq. ft. 4-bedroom Colonial, where timeless curb appeal begins with a welcoming front porch—perfect for relaxing and enjoying the neighborhood. Enter inside and experience true old-world charm, highlighted by beautiful hardwood floors and a spacious living room filled with natural light. The formal dining room is ideal for hosting, while the large eat-in kitchen offers plenty of space for everyday living. A rear mudroom with a convenient half bath adds both function and flexibility.\n \n Upstairs, you’ll find four generously sized bedrooms and a full bathroom, providing comfortable accommodations for guests, or a home office. The full basement offers excellent storage and additional potential.\n \n The exterior features a spacious yard with a beautiful paver patio—perfect for entertaining or unwinding outdoors. Ideally located in Merrick and zoned for Calhoun High School, this home is close to major highways, shopping, and the LIRR, making commuting and daily errands effortless.\n \n A perfect blend of charm, space, and location—this is truly a must-see home! """ +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-334-4333" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "631-327-0776" +"BuyerAgentEmail": "belcebolvadin@gmail.com" +"BuyerAgentFullName": "Belce Bolvadin" +"BuyerAgentKey": "326232938" +"BuyerAgentMlsId": "224110" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "419608232" +"BuyerOfficeMlsId": "OVRS03" +"BuyerOfficeName": "OverSouth LLC" +"BuyerOfficePhone": "631-770-0071" +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-26T16:24:49.736067+00:00" +"CumulativeDaysOnMarket": 11 +"DaysOnMarket": 11 +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-09-26" +"FoundationDetails": array:1 [ …1] +"Heating": array:1 [ …1] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentEmail": "tnails@cbamhomes.com" +"ListAgentKey": "326124087" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109933" +"ListOfficePhone": "516-334-4333" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-26" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1376 +"LotSizeSquareFeet": 5995 +"MajorChangeTimestamp": "2026-04-06T18:21:12Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-06" +"OnMarketDate": "2026-03-26" +"OriginalEntryTimestamp": "2026-03-26T16:20:14Z" +"OriginalListPrice": 719000 +"OriginatingSystemModificationTimestamp": "2026-04-06T18:21:12Z" +"OwnerName": "Kevin & Laura Dolan" +"ParcelNumber": "2089-55-540-00-0063-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-26T16:21:36Z" +"PhotosCount": 36 +"PostalCity": "Merrick" +"PostalCodePlus4": "1332" +"PurchaseContractDate": "2026-04-06" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-334-4333" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-06T18:21:12Z" +"StreetName": "Meadowbrook" +"StreetNumber": "1165" +"StreetNumberNumeric": "1165" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15136.7" +"TaxAssessedValue": 509 +"TaxYear": "2026" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "719000.00" +"KEY_ContractPrice": "760000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1764.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-770-1091" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "407.59637" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5225290.6977" +"KEY_RATIO_CurrentPrice_By_LivingArea": "407.59637" +"KEY_SourceSystemModificationTimestamp": "2026-03-26T09:46:34.683" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "407.59637" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "407.59637" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424082616')" +"provider_name": "One Key" +"Media": array:36 [ …36] +"ID": "30581" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5129 +post_id: "30551" +post_author: 1 +"ListingKey": "KEY424050104" +"ListingId": "976198" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-10T18:57:36Z" +"RFModificationTimestamp": "2026-04-10T19:02:52Z" +"ListPrice": 749000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1559.0 +"BuildingAreaTotal": 1559.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1261 Meadowbrook Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6879305 +"Longitude": -73.5676691 +"YearBuilt": 1952 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kelly A. Cafiso" +"ListOfficeName": "Coldwell Banker American Homes" +"ListAgentMlsId": "156584" +"ListOfficeMlsId": "BRMN04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this beautifully maintained ranch offering comfortable one-level living with thoughtful upgrades throughout. This home features 3 bedrooms and 2 full bathrooms, including a primary bedroom with a jetted tub and a Bath Fitter shower with a lifetime transferable warranty.\n \n The spacious layout includes a sun-filled living room, dining room, inviting family room, granite kitchen with stainless steel appliances, featuring a 5-burner range with large center griddle. Eight skylights located throughout the home bring in abundant natural light. Hardwood floors installed throughout in 2021, wood blinds in the living room and family room, central air conditioning, and natural gas heat and cooking provide everyday comfort and efficiency.\n \n Additional features include three-zone heating, a reverse osmosis water treatment system with separate kitchen tap (serviced annually with new tank and filters in August 2025), upgraded 200-amp electrical service, and a full basement with laundry area and freezer. Major updates include a gas boiler conversion in 2014, roof with architectural shingles, main bathroom remodel (2017), hot water heater replacement (2021), new AC condenser with 10-year warranty (2021), Bosch dishwasher (2021), Liebherr refrigerator with ice maker and double freezer (2020), and new front entry and storm doors (2024).\n \n The exterior offers mature landscaping with 7-zone in-ground sprinklers, a paved driveway, front patio with stonework, backyard patio pavers, and PVC fencing. A newer PVC waste line to the street with convenient curb access adds peace of mind. Ideally located close to parkways, shopping, and local amenities, this move-in ready home is a wonderful opportunity. """ +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-302-8500" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-698-8619" +"BuyerAgentEmail": "steve@steveosellsny.com" +"BuyerAgentFullName": "Stephen T. Orlando" +"BuyerAgentKey": "326189354" +"BuyerAgentMlsId": "178762" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326111209" +"BuyerOfficeMlsId": "EREA02" +"BuyerOfficeName": "EXIT Realty Premier" +"BuyerOfficePhone": "516-795-1000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-25T04:07:34.162112+00:00" +"CrossStreet": "Lednam Court" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 16 +"Directions": "See mapquest" +"ElementarySchool": "Harold D Fayette School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2026-09-30" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"HighSchoolDistrict": "North Merrick" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-425-2214" +"ListAgentEmail": "kcafiso@cbamhomes.com" +"ListAgentKey": "326168958" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109935" +"ListOfficePhone": "516-302-8500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-25" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1954 +"LotSizeSquareFeet": 8510 +"MajorChangeTimestamp": "2026-04-10T18:56:19Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-10" +"OnMarketDate": "2026-03-25" +"OriginalEntryTimestamp": "2026-03-25T04:05:30Z" +"OriginalListPrice": 749000 +"OriginatingSystemModificationTimestamp": "2026-04-10T18:56:19Z" +"OwnerName": "George P Garvey & Christine M Garvey" +"ParcelNumber": "2089-55-534-00-0003-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-25T04:06:36Z" +"PhotosCount": 40 +"PostalCity": "Merrick" +"PostalCodePlus4": "1512" +"PurchaseContractDate": "2026-04-10" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-302-8500" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-10T18:56:19Z" +"StreetName": "Meadowbrook" +"StreetNumber": "1261" +"StreetNumberNumeric": "1261" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15076" +"TaxAssessedValue": 515 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Crawl" +"KEY_TaxSource": "Other" +"KEY_CurrentPrice": "749000.00" +"KEY_ContractPrice": "795000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1559.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "480.43618" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "3833162.7431" +"KEY_RATIO_CurrentPrice_By_LivingArea": "480.43618" +"KEY_SourceSystemModificationTimestamp": "2026-03-24T23:09:27.390" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "480.43618" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "480.43618" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424050104')" +"provider_name": "One Key" +"Media": array:40 [ …40] +"ID": "30551" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5130 +post_id: "30571" +post_author: 1 +"ListingKey": "KEY424049756" +"ListingId": "976188" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-12T19:09:47Z" +"RFModificationTimestamp": "2026-04-12T19:12:42Z" +"ListPrice": 599900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 900.0 +"BuildingAreaTotal": 900.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2668 Rosebud Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6512353 +"Longitude": -73.5541746 +"YearBuilt": 1931 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marcia G. November" +"ListOfficeName": "M November Realty Inc" +"ListAgentMlsId": "9050442" +"ListOfficeMlsId": "MNOV01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Wonderful opportunity to decorate to your personal taste this perfectly located adorable ranch in south Merrick; features new full bath; newer gas heat and hot water heater; new roof; pull down attic with potential for second floor dormer; long driveway with detached garage; private yard with deck, large shed; conveniently located to schools, parks, shopping, highways, LIRR. Great starter or retirement home." +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-870-0557" +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-26T00:59:25.954978+00:00" +"CrossStreet": "Dorothy Court" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 36 +"DirectionFaces": "East" +"Disclosures": array:1 [ …1] +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-30" +"Fencing": array:1 [ …1] +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-870-0557" +"ListAgentEmail": "novemberrealty@hotmail.com" +"ListAgentKey": "326259218" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113786" +"ListOfficePhone": "516-870-0557" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-24" +"LivingAreaSource": "Public Records" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.0918 +"LotSizeSquareFeet": 4000 +"MajorChangeTimestamp": "2026-03-27T04:30:52Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-03-27" +"OriginalEntryTimestamp": "2026-03-26T00:56:36Z" +"OriginalListPrice": 599900 +"OriginatingSystemModificationTimestamp": "2026-04-12T19:08:18Z" +"OwnerName": "Josemyr Jeanty-Bertrand & Jerry Bertrand" +"ParcelNumber": "2089-62-008-00-0020-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-28T21:31:36Z" +"PhotosCount": 10 +"PostalCity": "Merrick" +"PostalCodePlus4": "4523" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5165823331" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-27T04:30:52Z" +"StreetName": "Rosebud" +"StreetNumber": "2668" +"StreetNumberNumeric": "2668" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "9989.02" +"TaxAssessedValue": 346 +"TaxBlock": "008" +"TaxLot": "20" +"TaxYear": "2026" +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Pull Stairs" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "62" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "599900.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Coming Soon" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_MlsDistrictCode": "2089" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "900.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "666.55556" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6534858.3878" +"KEY_RATIO_CurrentPrice_By_LivingArea": "666.55556" +"KEY_SourceSystemModificationTimestamp": "2026-03-24T22:41:33.563" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "666.55556" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "666.55556" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424049756')" +"provider_name": "One Key" +"Media": array:10 [ …10] +"ID": "30571" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5131 +post_id: "30555" +post_author: 1 +"ListingKey": "KEY424047314" +"ListingId": "976121" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-16T07:15:38Z" +"RFModificationTimestamp": "2026-04-16T07:18:58Z" +"ListPrice": 749900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1238.0 +"BuildingAreaTotal": 1238.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "140 Frankel Boulevard, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6602197 +"Longitude": -73.5447447 +"YearBuilt": 1927 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Aaron J. Bates" +"ListOfficeName": "Real Broker NY LLC" +"ListAgentMlsId": "169321" +"ListOfficeMlsId": "HOWO04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Set in the Merrick Gables section of Merrick, this 1927 brick bungalow blends original architectural character with thoughtful updates. Located less than one mile from the Merrick train station and positioned conveniently between Sunrise Highway and Merrick Road, the property offers convenient access to transportation, beaches, shopping, and local amenities. The home showcases many original details consistent with the neighborhood’s historic design, including inlaid hardwood floors, crown and original base moulding, glass-paned doors, natural woodwork, an arched doorway, and a wood-burning fireplace. An oversized covered front porch and patio provide inviting outdoor spaces for everyday enjoyment or gatherings. The interior includes three bedrooms and updated bathrooms, along with improvements such as a roof replaced in 2021 (15-year warranty), windows updated in 2022, and new central air conditioning installed in 2023. Additional features include gas heating, fenced yard, and a detached two-car garage. Merrick Gables is known for its early 20th-century homes, originally developed with distinctive architectural elements that continue to define the character of the area today." +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-528-4824" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "518-730-4228" +"BuyerAgentEmail": "jany@aaronbatesrealestate.com" +"BuyerAgentFullName": "Jany Figueroa" +"BuyerAgentKey": "423429920" +"BuyerAgentMlsId": "506242" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326112136" +"BuyerOfficeMlsId": "HOWO04" +"BuyerOfficeName": "Real Broker NY LLC" +"BuyerOfficePhone": "518-730-4228" +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "516-528-4824" +"CoBuyerAgentEmail": "aaron@aaronbatesrealestate.com" +"CoBuyerAgentFullName": "Aaron J. Bates" +"CoBuyerAgentKey": "326180632" +"CoBuyerAgentMlsId": "169321" +"CoBuyerOfficeKey": "326112136" +"CoBuyerOfficeMlsId": "HOWO04" +"CoBuyerOfficeName": "Real Broker NY LLC" +"CoBuyerOfficePhone": "518-730-4228" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "314-221-5101" +"CoListAgentEmail": "rebecca@aaronbatesrealestate.com" +"CoListAgentFullName": "Rebecca A. Bates" +"CoListAgentKey": "326200114" +"CoListAgentMlsId": "190167" +"CoListOfficeKey": "326112136" +"CoListOfficeMlsId": "HOWO04" +"CoListOfficeName": "Real Broker NY LLC" +"CoListOfficePhone": "518-730-4228" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-25T13:15:08.378466+00:00" +"CrossStreet": "Merrick Rd" +"CumulativeDaysOnMarket": 21 +"DaysOnMarket": 21 +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-18" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:2 [ …2] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-528-4824" +"ListAgentEmail": "aaron@aaronbatesrealestate.com" +"ListAgentKey": "326180632" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112136" +"ListOfficePhone": "518-730-4228" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-18" +"LivingAreaSource": "Cubi Casa" +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-04-15T15:37:40Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-15" +"OnMarketDate": "2026-03-25" +"OriginalEntryTimestamp": "2026-03-25T13:10:35Z" +"OriginalListPrice": 749900 +"OriginatingSystemModificationTimestamp": "2026-04-15T15:37:40Z" +"OwnerName": "Joseph Mancuso & Kristin Mancuso" +"ParcelNumber": "2089-56-192-00-0588-0" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-03-25T13:11:37Z" +"PhotosCount": 31 +"PostalCity": "Merrick" +"PostalCodePlus4": "4033" +"PurchaseContractDate": "2026-04-15" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "314-221-5101" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-15T15:37:40Z" +"StreetName": "Frankel" +"StreetNumber": "140" +"StreetNumberNumeric": "140" +"StreetSuffix": "Boulevard" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13692.14" +"TaxYear": "2025" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "1" +"KEY_CurrentPrice": "749900.00" +"KEY_ContractPrice": "805000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_DistanceToTrain": "0.80" +"KEY_ElectricCompany": "PSEG" +"KEY_AdditionalFeesYN": "0" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1238.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "605.73506" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5445896.8773" +"KEY_RATIO_CurrentPrice_By_LivingArea": "605.73506" +"KEY_SourceSystemModificationTimestamp": "2026-03-24T18:25:57.493" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "605.73506" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "605.73506" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY424047314')" +"provider_name": "One Key" +"Media": array:31 [ …31] +"ID": "30555" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5132 +post_id: "30537" +post_author: 1 +"ListingKey": "KEY423997855" +"ListingId": "974573" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-28T18:08:36Z" +"RFModificationTimestamp": "2026-04-28T18:23:53Z" +"ListPrice": 699999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1260.0 +"BuildingAreaTotal": 1260.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2002 Murray Place, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.667314 +"Longitude": -73.5636355 +"YearBuilt": 1957 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eileen Familia" +"ListOfficeName": "Howard Hanna Coach" +"ListAgentMlsId": "193570" +"ListOfficeMlsId": "CARE20" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Beautifully maintained 4-bedroom, 2-bath Cape featuring a warm and inviting layout. This home offers a cozy den perfect for relaxing or entertaining, along with a bright living room and a functional kitchen with adjoining dining area. There is Wood floors under carpets, The full basement provides additional space for storage, recreation, A truly nice home. Conveniently located near schools, shopping, dining, parks, and transportation." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-581-7979" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "347-538-4825" +"BuyerAgentEmail": "jrrealtime@yahoo.com" +"BuyerAgentFullName": "Jacqueline Rodriguez CBR" +"BuyerAgentKey": "326269760" +"BuyerAgentMlsId": "98408" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326111979" +"BuyerOfficeMlsId": "HEUS01" +"BuyerOfficeName": "Quality Homes Realty Group" +"BuyerOfficePhone": "718-343-4446" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "631-835-4898" +"CoListAgentEmail": "twright@coachrealtors.com" +"CoListAgentFullName": "Tara J. Wright" +"CoListAgentKey": "326118741" +"CoListAgentMlsId": "102175" +"CoListOfficeKey": "326110106" +"CoListOfficeMlsId": "CARE20" +"CoListOfficeName": "Howard Hanna Coach" +"CoListOfficePhone": "631-581-7979" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-24T13:14:44.820107+00:00" +"CrossStreet": "Thelma" +"CumulativeDaysOnMarket": 21 +"DaysOnMarket": 21 +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-03-20" +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-495-3061" +"ListAgentEmail": "efamilia@coachrealtors.com" +"ListAgentKey": "326203350" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110106" +"ListOfficePhone": "631-581-7979" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-12" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.124 +"LotSizeSquareFeet": 5400 +"MajorChangeTimestamp": "2026-04-28T16:52:59Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-14" +"OnMarketDate": "2026-03-24" +"OriginalEntryTimestamp": "2026-03-24T13:10:06Z" +"OriginalListPrice": 699999 +"OriginatingSystemModificationTimestamp": "2026-04-28T18:06:05Z" +"OwnerName": "Cathy Tauro" +"ParcelNumber": "2089-55-099-00-0287-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-24T13:11:36Z" +"PhotosCount": 37 +"PostalCity": "Merrick" +"PostalCodePlus4": "3330" +"PurchaseContractDate": "2026-04-28" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-495-3061" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-28T16:52:59Z" +"StreetName": "Murray" +"StreetNumber": "2002" +"StreetNumberNumeric": "2002" +"StreetSuffix": "Place" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13184.55" +"TaxAssessedValue": 464 +"TaxYear": "2024" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "See Remarks" +"KEY_HoldDate": "2026-04-14" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "699999.00" +"KEY_ContractPrice": "675000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Hold" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1260.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "631-495-3061" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "555.55476" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5645153.2258" +"KEY_RATIO_CurrentPrice_By_LivingArea": "555.55476" +"KEY_SourceSystemModificationTimestamp": "2026-03-20T17:06:12.970" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "555.55476" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "555.55476" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423997855')" +"provider_name": "One Key" +"Media": array:37 [ …37] +"ID": "30537" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5133 +post_id: "30509" +post_author: 1 +"ListingKey": "KEY423990651" +"ListingId": "974356" +"PropertyType": "Commercial Sale" +"PropertySubType": "Mixed Use" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-12T15:09:36Z" +"RFModificationTimestamp": "2026-04-12T15:10:33Z" +"ListPrice": 709999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 2322.0 +"LivingArea": 0 +"BuildingAreaTotal": 1700.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "174 Merrick Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6537613 +"Longitude": -73.5561503 +"YearBuilt": 1952 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marc Jeret" +"ListOfficeName": "M & J Partners Realty LLC" +"ListAgentMlsId": "221570" +"ListOfficeMlsId": "MJPR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Mixed-use property for sale in the heart of Merrick.\n \n The property consists of 1 credit retail tenant (Allstate Insurance) in the front paying $2678 per month with 3 year lease with increases and a renewal option remaining (newly renovated).\n \n + a vacant flex space in the back newly renovated that can be used/rented out as an apartment/office and a large newly renovated patio.\n \n There is a also a shed and a shared driveway that comes with the property.\n \n Approximately 1700 +/- sq ft which includes the front retail space the back flex office/apartment space and the backyard patio not including shared driveway in measurements.\n \n Please verify all property information and do proper research. """ +"AttributionContact": "516-874-0263" +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Commercial,Mixed,Other,Professional Service,Professional/Office" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-233-9888" +"CoListAgentEmail": "mberrios@mjpartnersrealty.com" +"CoListAgentFullName": "Meliza Berrios" +"CoListAgentKey": "326220813" +"CoListAgentMlsId": "211571" +"CoListOfficeKey": "417764778" +"CoListOfficeMlsId": "MJPR01" +"CoListOfficeName": "M & J Partners Realty LLC" +"CoListOfficePhone": "516-874-0263" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-20T15:55:13.457610+00:00" +"CumulativeDaysOnMarket": 23 +"DaysOnMarket": 44 +"ExpirationDate": "2026-05-20" +"FoundationDetails": array:1 [ …1] +"Heating": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-839-3748" +"ListAgentEmail": "mj@mjpartnersrealty.com" +"ListAgentKey": "326230497" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "417764778" +"ListOfficePhone": "516-874-0263" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-20" +"LotSizeAcres": 0.0533 +"LotSizeSquareFeet": 2322 +"MajorChangeTimestamp": "2026-04-05T15:39:09Z" +"MajorChangeType": "Price Change" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-03-20" +"OriginalEntryTimestamp": "2026-03-20T15:49:49Z" +"OriginalListPrice": 729000 +"OriginatingSystemModificationTimestamp": "2026-04-12T15:08:16Z" +"OwnerName": "Name Withheld" +"ParcelNumber": "2089-55-167-00-0195-0" +"PhotosChangeTimestamp": "2026-03-20T15:59:36Z" +"PhotosCount": 13 +"PostalCity": "Merrick" +"PostalCodePlus4": "4532" +"PreviousListPrice": 719000 +"PriceChangeTimestamp": "2026-04-05T15:39:09Z" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "6318393748" +"ShowingRequirements": array:5 [ …5] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-20T15:49:49Z" +"StreetName": "Merrick" +"StreetNumber": "174" +"StreetNumberNumeric": "174" +"StreetSuffix": "Road" +"SyndicateTo": array:3 [ …3] +"TaxAnnualAmount": "12338" +"TaxYear": "2026" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_CurrentPrice": "709999.00" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_ShowingContactPhone2": "5162339888" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "13320806.7542" +"KEY_SourceSystemModificationTimestamp": "2026-03-20T11:49:49.273" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "417.64647" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97394" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "417.64647" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423990651')" +"provider_name": "One Key" +"Media": array:13 [ …13] +"ID": "30509" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5134 +post_id: "30514" +post_author: 1 +"ListingKey": "KEY423989664" +"ListingId": "974332" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-07T07:06:38Z" +"RFModificationTimestamp": "2026-04-07T07:11:25Z" +"ListPrice": 1195000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2391.0 +"BuildingAreaTotal": 2431.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2812 Covered Bridge Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6467466 +"Longitude": -73.5560481 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Natan Amos" +"ListOfficeName": "Resource Realty Group" +"ListAgentMlsId": "190248" +"ListOfficeMlsId": "DAAR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to this exceptional wide-line Hi-Ranch in the heart of South Merrick, offering 2,391 sq ft of beautifully updated living space - larger than most homes of its kind.\n \n This spacious residence features 5 bedrooms and 2.5 bathrooms, designed with a modern open floor plan perfect for both everyday living and entertaining. The centerpiece of the home is a completely updated chef’s kitchen, showcasing a large center island, high-end stainless steel appliances, and abundant cabinetry and countertop space.\n \n Natural light pours in throughout the home thanks to custom skylights and oversized windows, enhancing the bright and airy feel. The main living area boasts vaulted ceilings and beautiful hardwood floors throughout, adding warmth and elegance.\n \n Enjoy seamless indoor-outdoor living with sliding glass doors leading to a backyard deck, ideal for relaxing or hosting gatherings. Additional features include central air conditioning, a 2-car garage, and generous living space across both levels.\n \n The primary suite offers two closets and a private en-suite bathroom, providing a comfortable and peaceful space.\n \n Situated on a quiet residential block in desirable South Merrick, this oversized Hi-Ranch combines space, style, and location—an incredible opportunity you won’t want to miss! """ +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "917-654-9835" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "HGAR" +"BuyerAgentDirectPhone": "516-575-7500" +"BuyerAgentEmail": "larry.albert5@yahoo.com" +"BuyerAgentFullName": "Ladislau Albert" +"BuyerAgentKey": "18479927" +"BuyerAgentMlsId": "33075" +"BuyerOfficeAOR": "HGAR" +"BuyerOfficeKey": "1263353" +"BuyerOfficeMlsId": "RUTENB" +"BuyerOfficeName": "Charles Rutenberg Realty, Inc." +"BuyerOfficePhone": "516-575-7500" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-03-20T18:27:03.774727+00:00" +"CrossStreet": "Clubhouse Rd" +"CumulativeDaysOnMarket": 17 +"DaysOnMarket": 17 +"Directions": "GPS" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-07-20" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-341-8471" +"ListAgentEmail": "natanamos@resourcerealtyny.com" +"ListAgentKey": "326200195" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110639" +"ListOfficePhone": "917-654-9835" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-20" +"LivingAreaSource": "Cubi Casa" +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-04-06T18:42:03Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-06" +"OnMarketDate": "2026-03-20" +"OriginalEntryTimestamp": "2026-03-20T18:22:03Z" +"OriginalListPrice": 1195000 +"OriginatingSystemModificationTimestamp": "2026-04-06T18:42:03Z" +"OwnerName": "Gorelik" +"ParcelNumber": "2089-62-218-00-0009-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-03-20T18:24:36Z" +"PhotosCount": 35 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PurchaseContractDate": "2026-04-06" +"RoomsTotal": "14" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-341-8471" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-06T18:42:03Z" +"StreetName": "Covered Bridge" +"StreetNumber": "2812" +"StreetNumberNumeric": "2812" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "18638.05" +"TaxAssessedValue": 667 +"TaxYear": "2024" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full,Unfinished" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "1195000.00" +"KEY_ContractPrice": "1270000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "2391.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "499.79088" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8678286.1293" +"KEY_RATIO_CurrentPrice_By_LivingArea": "499.79088" +"KEY_SourceSystemModificationTimestamp": "2026-03-20T11:13:58.697" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "491.56726" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "491.56726" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423989664')" +"provider_name": "One Key" +"Media": array:35 [ …35] +"ID": "30514" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5135 +post_id: "30674" +post_author: 1 +"ListingKey": "KEY423967418" +"ListingId": "973736" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-23T17:15:36Z" +"RFModificationTimestamp": "2026-04-23T17:20:48Z" +"ListPrice": 749000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1472.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2263 Cameron Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6834748 +"Longitude": -73.5485391 +"YearBuilt": 1955 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Cindy DiBiasi" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "116237" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "The One You've Been Waiting For!! Welcome to 2263 Cameron Ave Merrick. This Lovingly Maintained 3 Bed 2.5 Bath Home Is Ready For You This Summer. From The Moment, You Enter You Will Feel At Home. This Light And Bright Home Has 3 Zone Gas Heat, CAC ,New Front Bay Window, Finished Basement, PVC Fenced In Yard With Screened In Sunroom And Slate Patio For Great Entertaining! Off The Family Room Is A Half Bath / Laundry Room / Entry To Yard And Garage That Makes For Easy Living. This Is A Must See Home And Won't Last! Come Fall In Love!!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentEmail": "mwidmann@cbamhomes.com" +"BuyerAgentFullName": "Marianne Widmann" +"BuyerAgentKey": "326254517" +"BuyerAgentMlsId": "9024375" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326109932" +"BuyerOfficeMlsId": "BRMN01" +"BuyerOfficeName": "Coldwell Banker American Homes" +"BuyerOfficePhone": "516-796-8900" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-06T16:01:45.515306+00:00" +"CrossStreet": "Sherman" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 16 +"Directions": "GPS" +"Disclosures": array:1 [ …1] +"ElementarySchool": "Park Avenue School - North Bellmore" +"ElementarySchoolDistrict": "North Bellmore" +"ExpirationDate": "2026-09-30" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "Wellington C Mepham High Sch" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-524-1954" +"ListAgentEmail": "cindydibiasi@yahoo.com" +"ListAgentKey": "326131896" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-03-19" +"ListingTerms": "Cash,Conventional,FHA,VA" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.138 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-04-23T17:14:30Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Grand Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-23" +"OnMarketDate": "2026-04-06" +"OriginalEntryTimestamp": "2026-04-06T15:55:48Z" +"OriginalListPrice": 749000 +"OriginatingSystemModificationTimestamp": "2026-04-23T17:14:30Z" +"OwnerName": "Duranona" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2026-04-06T15:58:36Z" +"PhotosCount": 21 +"PostalCity": "Merrick" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2026-04-22" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "5165241954" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-04-23T17:14:30Z" +"StreetName": "Cameron" +"StreetNumber": "2263" +"StreetNumberNumeric": "2263" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "13800" +"TaxLot": "60x100" +"TaxYear": "2025" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"KEY_Attic": "Crawl" +"KEY_HoldDate": "2026-04-14" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "749000.00" +"KEY_ContractPrice": "749000.00" +"KEY_WaterAccessYN": "0" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1472.00" +"KEY_NumberOfHeatingZones": "3" +"KEY_ShowingContactPhone2": "516-623-4500" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "508.83152" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5427536.2319" +"KEY_RATIO_CurrentPrice_By_LivingArea": "508.83152" +"KEY_SourceSystemModificationTimestamp": "2026-03-19T08:14:42.427" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423967418')" +"provider_name": "One Key" +"Media": array:21 [ …21] +"ID": "30674" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5136 +post_id: "30494" +post_author: 1 +"ListingKey": "KEY423960424" +"ListingId": "973552" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-04-15T07:08:38Z" +"RFModificationTimestamp": "2026-04-15T07:11:42Z" +"ListPrice": 773000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1188.0 +"BuildingAreaTotal": 1188.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1844 Old Mill Road, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.685634 +"Longitude": -73.564105 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Margaret A. Biegelman CBR E-PRO GR" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "102596" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Going! Going! Gone! Immaculate Move-in condition! Updated Rear Dormered 4 bedroom 2 bath Center Hall Cape with 3 bedrooms up! Renovated within the last 15 years! Granite Eat-in Kitchen with plenty of cabinets, sliders leading to the backyard and 1 1/2 car detached garage. Approximately 8 year old roof, Hardwood floors, 200 amp electric, Approximately 8 year old windows, Finished basement, Separate laundry room and utility room. Convenient to the Elementary School, House of Worship, shopping, parkways. Close to the heart of town, publlic transportation and the LIRR. Low Taxes! Won't Last!" +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 …106 } 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5137 …131} 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5138 …176} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5139 …153} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5140 …167} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5141 …145} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5142 …151} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5143 …153} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5145 …154} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5114 …164} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5113 …158} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5112 …144} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5111 …152} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5110 …171} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5109 …153} ] +success: true +page_size: 32 +page_count: 6 +count: 166 +after_key: "" } "RF Response Time" => "0.16 seconds" ] ]