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&$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')) and ListPrice le 5000000) and (City eq 'Merrick' or PostalCity eq 'Merrick')/Property?$select=ALL&$orderby=ListingId DESC&$top=32&$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')) and ListPrice le 5000000) and (City eq 'Merrick' or PostalCity eq 'Merrick')&$expand=Media/Property?$select=ALL&$orderby=ListingId DESC&$top=32&$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')) and ListPrice le 5000000) and (City eq 'Merrick' or PostalCity eq 'Merrick')/Property?$select=ALL&$orderby=ListingId DESC&$top=32&$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')) 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 {#4907 +items: array:32 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4919 +post_id: "17431" +post_author: 1 +"ListingKey": "KEY417769090" +"ListingId": "L3590159" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-10-03T19:10:36Z" +"RFModificationTimestamp": "2025-10-03T19:11:14Z" +"ListPrice": 1329000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.15 +"LivingArea": 2644.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1956 Leonard Lane, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6482822 +"Longitude": -73.5488354 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sundeep S. Chawla" +"ListOfficeName": "LAFFEY REAL ESTATE" +"ListAgentMlsId": "107048" +"ListOfficeMlsId": "LRE16" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to Your Dream Home in Merrick! Located in the desirable Lindenmere section just south of Merrick Road, this brand-new Modern Farmhouse Expanded Split offers 4 bedrooms, 2.5 baths, and exceptional design across multiple levels. The open-concept layout features a gourmet kitchen with LG stainless steel appliances, quartz countertops, and sleek cabinetry, flowing seamlessly into the living and dining areas, perfect for entertaining.\n \n The private top-level primary suite includes a custom walk-in closet and spa-like bath with dual vanities, soaking tub, and separate shower. Additional highlights include a home office that can serve as a fifth bedroom, a finished basement with natural light, three-zone HVAC, oak floors, Andersen windows, spray foam insulation, and a one-car garage with a car charging outlet.\n \n Enjoy outdoor living with a TimberTech deck, PVC-fenced yard, and professional landscaping. Conveniently located near schools, parks, golf, shopping, and transportation with optional neighborhood pool club access. This is the lifestyle you have been waiting for! """ +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Park" +"AttributionContact": "631-547-5300" +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "631-678-3834" +"BuyerAgentEmail": "jstanco@coachrealtors.com" +"BuyerAgentFullName": "Jessica L. Stanco AHWD PSA SRES" +"BuyerAgentKey": "326172870" +"BuyerAgentMlsId": "160862" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326110095" +"BuyerOfficeMlsId": "CARE07" +"BuyerOfficeName": "Howard Hanna Coach" +"BuyerOfficePhone": "631-757-4000" +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "631-220-5528" +"CoBuyerAgentEmail": "kcordray@coachrealtors.com" +"CoBuyerAgentFullName": "Kellyann Cordray" +"CoBuyerAgentKey": "326208320" +"CoBuyerAgentMlsId": "198743" +"CoBuyerOfficeKey": "326110095" +"CoBuyerOfficeMlsId": "CARE07" +"CoBuyerOfficeName": "Howard Hanna Coach" +"CoBuyerOfficePhone": "631-757-4000" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-11-08T20:29:27.494529+00:00" +"CrossStreet": "Shore Drive" +"CumulativeDaysOnMarket": 329 +"DaysOnMarket": 329 +"Directions": "Meadowbrook PKWY South to MAE Merrick Road East, Right on Lindenmere Drive, Right on Shore & Right on Leonard Lane." +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2025-11-08" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:2 [ …2] +"Flooring": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-375-4409" +"ListAgentEmail": "smcconsulting1@aol.com" +"ListAgentKey": "326123298" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113315" +"ListOfficePhone": "631-547-5300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-11-08" +"LotFeatures": array:5 [ …5] +"LotSizeDimensions": "0.15" +"LotSizeSquareFeet": 6500 +"MajorChangeTimestamp": "2025-10-03T18:45:39Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2025-10-03" +"OnMarketDate": "2024-11-08" +"OriginalEntryTimestamp": "2024-11-08T19:01:59Z" +"OriginalListPrice": 1449000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3590159" +"OriginatingSystemModificationTimestamp": "2025-10-03T19:09:32Z" +"OwnerName": "Name Withheld" +"ParcelNumber": "2089-62-199-00-0023-0" +"ParkingFeatures": array:4 [ …4] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-03T18:47:39Z" +"PhotosCount": 33 +"PostalCity": "Merrick" +"PreviousListPrice": 1379000 +"PriceChangeTimestamp": "2025-09-03T15:40:27Z" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2025-10-03" +"RoomsTotal": "8" +"ShowingContactPhone": "516-375-4409" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3590159" +"SourceSystemKey": "3590159" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-10-03T18:45:39Z" +"StreetName": "Leonard" +"StreetNumber": "1956" +"StreetNumberNumeric": "1956" +"StreetSuffix": "Lane" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "16508.89" +"TaxBlock": "199" +"TaxLot": "23" +"View": "Open" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"YearBuiltEffective": 2024 +"KEY_Attic": "Pull Stairs,Partial" +"KEY_TaxSection": "62" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1329000.00" +"KEY_ContractPrice": "1310000.00" +"KEY_AdditionalFees": "0.00" +"KEY_NumOf1BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf4BedRooms": "0" +"KEY_OpenHouseCount": "0" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalRooms": "Home Office" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Pending" +"KEY_NumberOfHeatingZones": "3" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_OriginatingSystemTimestamp": "2024-12-02T12:36:03.000" +"KEY_RATIO_ListPrice_By_LivingArea": "502.64750" +"KEY_RATIO_CurrentPrice_By_LivingArea": "502.64750" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.91718" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY417769090')" +"provider_name": "One Key" +"Media": array:33 [ …33] +"ID": "17431" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4921 +post_id: "17433" +post_author: 1 +"ListingKey": "KEY417285486" +"ListingId": "L3588140" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-15T20:45:36Z" +"RFModificationTimestamp": "2025-09-15T20:47:45Z" +"ListPrice": 1549000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.16 +"LivingArea": 4000.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "70 Nancy Boulevard, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6732106 +"Longitude": -73.5479907 +"YearBuilt": 1949 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nadene J. Katz" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "113424" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to your dream home! This stunning 5 bedroom, 3.5 bath colonial with approximately 4000 square feet will be completely renovated and expanded. There is still time for you to participate in adding your own personal touches. Situated on an oversized property in beautiful Merrick Woods, this home will boast modern amenities and luxurious finishes throughout. You can enjoy spacious living areas, a gourmet kitchen and exquisite bathrooms. Don't miss out on the opportunity to customize your ideal home." +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CoBuyerAgentDirectPhone": "516-317-1223" +"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": "2024-10-29T19:23:16.415163+00:00" +"CrossStreet": "Park Ave" +"CumulativeDaysOnMarket": 475 +"DaysOnMarket": 528 +"Directions": "Camp Avenue to Park Avenue. East on Nancy Blvd." +"ElementarySchool": "Park Avenue School - North Bellmore" +"ElementarySchoolDistrict": "North Bellmore" +"ExpirationDate": "2026-05-28" +"FireplacesTotal": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Wellington C Mepham High Sch" +"HighSchoolDistrict": "Bellmore-Merrick" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"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": "2024-05-28" +"LivingAreaSource": "Plans" +"LotSizeDimensions": "70x100" +"LotSizeSquareFeet": 7000 +"MajorChangeTimestamp": "2024-10-29T04:00:00Z" +"MiddleOrJuniorSchool": "Grand Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OnMarketDate": "2024-05-28" +"OriginalEntryTimestamp": "2024-10-29T19:02:10Z" +"OriginalListPrice": 1549000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3588140" +"OriginatingSystemModificationTimestamp": "2025-09-15T20:44:26Z" +"OwnerName": "Nancy Woods Llc" +"ParcelNumber": "2089-56-083-00-0103-0" +"ParkingFeatures": array:4 [ …4] +"PhotosChangeTimestamp": "2025-09-15T17:29:36Z" +"PhotosCount": 9 +"PostalCity": "Merrick" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-698-4372" +"SourceSystemID": "3588140" +"SourceSystemKey": "3588140" +"StateOrProvince": "NY" +"StreetName": "Nancy" +"StreetNumber": "70" +"StreetNumberNumeric": "70" +"StreetSuffix": "Boulevard" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "16413.46" +"TaxBlock": "83" +"TaxLot": "103" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSection": "56" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1549000.00" +"KEY_AdditionalFees": "0.00" +"KEY_NumOf1BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf4BedRooms": "0" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "4000.00" +"KEY_OriginatingSystemTimestamp": "2024-10-29T15:12:16.000" +"KEY_RATIO_ListPrice_By_LivingArea": "387.25000" +"KEY_RATIO_CurrentPrice_By_LivingArea": "387.25000" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY417285486')" +"provider_name": "One Key" +"Media": array:9 [ …9] +"ID": "17433" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4918 +post_id: "22541" +post_author: 1 +"ListingKey": "KEY416038933" +"ListingId": "L3584718" +"PropertyType": "Business Opportunity" +"PropertySubType": "Retail" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-02-01T05:14:36Z" +"RFModificationTimestamp": "2025-02-01T05:18:55Z" +"ListPrice": 180000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 1800.0 +"BuildingAreaTotal": 1800.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2063 Merrick Road, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6575031 +"Longitude": -73.5477488 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sergey Babayev M" +"ListOfficeName": "Kingsland Properties" +"ListAgentMlsId": "202102" +"ListOfficeMlsId": "KNGL01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Sushi & Asian Restaurant for Sale in Merrick Long Island. It has been in business for over 14 years and has a full bar & Liquor License. It has great foot traffic in its desirable location and has a spacious parking lot in the back. The Restaurant's seating capacity is 63 people. The Annual Gross sales are around $1 million, and the sales receipt will be provided upon request. The restaurant includes a Walk-In Cooler, 3 Free Standing freezers, 1 chest freezer, an Ice Machine, Fixtures & Equipment., Additional information: Dining seats:63" +"AttributionContact": "718-380-7400" +"BusinessName": "Sushi Ko" +"BusinessType": "Restaurant" +"CountyOrParish": "Nassau County" +"CreationDate": "2024-10-11T18:31:19.901724+00:00" +"CrossStreet": "Merrick Ave" +"CumulativeDaysOnMarket": 113 +"DaysOnMarket": 113 +"Directions": "GPS" +"ExpirationDate": "2025-02-01" +"Heating": array:1 [ …1] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "646-267-3979" +"ListAgentEmail": "babayevsergey888@gmail.com" +"ListAgentKey": "326211583" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112922" +"ListOfficePhone": "718-380-7400" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-10-11" +"MajorChangeTimestamp": "2025-02-01T05:13:18Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"OffMarketDate": "2025-02-01" +"OnMarketDate": "2024-10-11" +"OriginalEntryTimestamp": "2024-10-11T17:52:31Z" +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3584718" +"OriginatingSystemModificationTimestamp": "2025-02-01T05:13:18Z" +"OwnerName": "Liyun Xiang" +"PhotosChangeTimestamp": "2024-11-02T03:08:56Z" +"PhotosCount": 13 +"PostalCity": "Merrick" +"SourceSystemID": "3584718" +"SourceSystemKey": "3584718" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-02-01T05:13:18Z" +"StreetName": "Merrick Road" +"StreetNumber": "2063" +"StreetNumberNumeric": "2063" +"TaxAnnualAmount": "1252" +"Zoning": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_AdditionalParcelYN": "0" +"KEY_OriginatingSystemTimestamp": "2024-10-13T10:16:38.000" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_CurrentPrice": "180000.00" +"KEY_AdditionalFees": "0.00" +"KEY_NumberOfTailBoards": "1" +"KEY_Hamlet": "Merrick" +"KEY_MlsMajorChangeType": "Expired" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "100.00000" +"KEY_NumOf4BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_OpenHouseCount": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "100.00000" +"KEY_ConcessionYN": "0" +"KEY_PermittedUses": "Food Services" +"KEY_NumOf1BedRooms": "0" +"KEY_SeasonalYN": "0" +"KEY_RentSpreeYN": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY416038933')" +"provider_name": "One Key" +"Media": array:13 [ …13] +"ID": "22541" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4922 +post_id: "22535" +post_author: 1 +"ListingKey": "KEY3581014" +"ListingId": "L3581014" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-10-22T04:24:23Z" +"RFModificationTimestamp": "2024-12-21T06:20:45Z" +"ListPrice": 899999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.23 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Merrick" +"PostalCode": "11566" +"UnparsedAddress": "1760 E Berkshire Road, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 0.01 +"Longitude": 0.01 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rahreese Kenchen" +"ListOfficeName": "Fave Realty Inc" +"ListAgentMlsId": "159247" +"ListOfficeMlsId": "FVE01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to your NEW Beautiful, Fully Renovated Home nestled in the heart of Merrick. This stunning home boasts 4 Bedrooms and 2.5 Bathrooms, featuring a Contemporary Open Concept with soaring High Ceilings. The entry foyers modern staircase, and 15+ ft ceilings is truly spectacular and one of a kind. Enjoy the luxurious primary bedroom, complete with a Full Bathroom, Double Vanity & radiant heated floors. The large Open Concept Kitchen, Living room & Dining area ensures comfort and elegance at every turn. Step through the French doors onto the 2nd floor porch which looks out to the backyard oasis, spanning close to a quarter of an acre lot. The 1st level features a large Open Floor Plan, 1 Bedroom, Laundry room, Half Bath & an Oversized 2 Car Garage. Walk out to the paved patio from the 1st level, to enjoy the 96x96 yard. This home comes equipped with radiant heat in 2 bathrooms, a sprinkler system, 7+ exterior cameras, double garage door openers, & modern details throughout. Very conveniently located close to schools, buses, highways, restaurants, grocery stores, gyms & places of worship. This a Must See! Won't Last!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttachedGarageYN": true +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"CommonWalls": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-09-25T04:30:31.290517+00:00" +"CrossStreet": "Dobson" +"Directions": "See Google Maps" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2024-10-21" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Merrick" +"Inclusions": "Dishwasher,Dryer,Garage Door Opener,Garage Remote,Microwave,Refrigerator,Shades/Blinds,Speakers Outdoor,Video Cameras,Washer" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentEmail": "reesetherealtor@gmail.com" +"ListAgentFirstName": "Rahreese" +"ListAgentKey": "159247" +"ListAgentLastName": "Kenchen" +"ListAgentPreferredPhone": "516-519-8049" +"ListOfficeKey": "159247000" +"ListOfficePhone": "516-519-8049" +"ListPriceLow": 899999 +"ListingContractDate": "2024-09-24" +"LotSizeAcres": 0.23 +"LotSizeDimensions": "96x96" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 9880 +"MLSAreaMinor": "5" +"MajorChangeTimestamp": "2024-10-22T04:10:14Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "U" +"OffMarketDate": "2024-10-21" +"OnMarketDate": "2024-09-24" +"OriginalEntryTimestamp": "2024-09-25T03:34:34Z" +"OriginalListPrice": 899999 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3581014" +"OriginatingSystemModificationTimestamp": "2024-10-22T04:10:14Z" +"OwnerName": "Kenchen" +"ParcelNumber": "2089-55-P-00-0087-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-09-25T04:23:24Z" +"PhotosCount": 21 +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "646-642-4340" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3581014" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetDirPrefix": "E" +"StreetName": "Berkshire" +"StreetNumber": "1760" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Welcome to your NEW Beautiful, Fully Renovated Home nestled in the heart of Merrick. This stunning home boasts 4 Bedrooms and 2.5 Bathrooms, featuring a Contemporary Open Concept with soaring High Ceilings. The entry foyers modern staircase, and 15+ ft ceilings is truly spectacular and one of a kind. Enjoy the luxurious primary bedroom, complete with a Full Bathroom, Double Vanity & radiant heated floors. The large Open Concept Kitchen, Living room & Dining area ensures comfort and elegance at every turn. Step through the French doors onto the 2nd floor porch which looks out to the backyard oasis, spanning close to a quarter of an acre lot. The 1st level features a large Open Floor Plan, 1 Bedroom, Laundry room, Half Bath & an Oversized 2 Car Garage. Walk out to the paved patio from the 1st level, to enjoy the 96x96 yard. This home comes equipped with radiant heat in 2 bathrooms, a sprinkler system, 7+ exterior cameras, double garage door openers, & modern details throughout. Very conveniently located close to schools, buses, highways, restaurants, grocery stores, gyms & places of worship. This a Must See! Won't Last!" +"TaxAnnualAmount": "15615" +"TaxBlock": "P" +"TaxLot": "87" +"TaxMapNumber": "2089-55-P-00-0087-0" +"Township": "Hempstead" +"WaterSource": array:1 [ …1] +"KEY_HighPriceDollars": "899999" +"KEY_HotWater": "Gas Stand Alone" +"KEY_OfferPresentation": "Cannot be Present" +"KEY_AttributionContact": "516-519-8049" +"KEY_FloodZoneReportYN": "1" +"KEY_NumberOfKitchens": "1" +"KEY_OriginatingSystemOfficeKey": "159247000" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "M6 Disclosure of Ownership Interest" +"KEY_FloodZoneDate": "2024-10-07" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "FVE01" +"KEY_MinorChangeTimestamp": "2024-10-22T00:00:00-04:00" +"KEY_AtticDescription": "Dormer" +"KEY_SourceSystemModificationTimestamp": "2024-10-22T00:22:56-04:00" +"KEY_AlternateMlsNumber": "3581014" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY3581014')" +"coordinates": array:2 [ …2] +"location_extra_data": array:1 [ …1] +"full_address": "1760 E Berkshire Road, Merrick, NY 11566" +"provider_name": "One Key" +"short_address": "Merrick, New York 11566, US" +"Media": array:21 [ …21] +"ID": "22535" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4920 +post_id: "18150" +post_author: 1 +"ListingKey": "KEY406415116" +"ListingId": "L3575552" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-20T17:09:37Z" +"RFModificationTimestamp": "2025-09-20T17:13:11Z" +"ListPrice": 1299000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.19 +"LivingArea": 2340.0 +"BuildingAreaTotal": 2340.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1056 North Drive, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.628360161616 +"Longitude": -73.595126535354 +"YearBuilt": 1949 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Steven E. DeCillis" +"ListOfficeName": "Keller Williams Realty Elite" +"ListAgentMlsId": "174967" +"ListOfficeMlsId": "KWE02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Beautiful colonial in Merrick Woods completely updated in 2019. Spacious circular driveway with pavers in front and back. In ground pool with hot tub and waterfall plus gazebo and gas line to BBQ for entertaining. Gas fireplace in den and 4" oak flooring throughout. MBR en suite with WIC and terrace, second bedroom with terrace. Quartz countertop on huge island with Viking appliances. Security system, High end TDC steel front door. Custom window treatments will remain. Great house in a great area., Additional information: Appearance:Mint,Interior Features:Lr/Dr" +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Park" +"AttributionContact": "516-795-6900" +"Basement": array:3 [ …3] +"BathroomsFull": 3 +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-08-30T20:02:40.577679+00:00" +"CrossStreet": "Ava Road" +"CumulativeDaysOnMarket": 386 +"DaysOnMarket": 434 +"Directions": "Merrick Avenue North, left on Jerusalem Avenue, Left on North Drive to property." +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-30" +"ExteriorFeatures": array:2 [ …2] +"Fencing": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-551-7309" +"ListAgentEmail": "Sdecee@aol.com" +"ListAgentKey": "326185877" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113000" +"ListOfficePhone": "516-795-6900" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-08-30" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeDimensions": "94x105" +"LotSizeSquareFeet": 8375 +"MajorChangeTimestamp": "2025-09-16T14:16:35Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OnMarketDate": "2024-08-30" +"OriginalEntryTimestamp": "2024-08-30T17:10:21Z" +"OriginalListPrice": 1700000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3575552" +"OriginatingSystemModificationTimestamp": "2025-09-20T17:08:16Z" +"OwnerName": "Danie Mascary" +"ParcelNumber": "2089-55-521-00-0006-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-09-19T20:52:54Z" +"PhotosCount": 41 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PreviousListPrice": 1399999 +"PriceChangeTimestamp": "2025-09-16T14:16:35Z" +"RoomsTotal": "8" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-551-7309" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3575552" +"SourceSystemKey": "3575552" +"StateOrProvince": "NY" +"StreetName": "North" +"StreetNumber": "1056" +"StreetNumberNumeric": "1056" +"StreetSuffix": "Drive" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "18197" +"TaxBlock": "521" +"TaxLot": "6" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=xdV6s2596S2" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:4 [ …4] +"YearBuiltEffective": 2019 +"KEY_Attic": "Pull Stairs,Full" +"KEY_TaxSection": "55" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1299000.00" +"KEY_AdditionalFees": "0.00" +"KEY_NumOf1BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf4BedRooms": "0" +"KEY_OpenHouseCount": "2" +"KEY_AdditionalRooms": "Library/Den" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_OriginatingSystemTimestamp": "2024-09-17T13:17:27.000" +"KEY_RATIO_ListPrice_By_LivingArea": "555.12821" +"KEY_RATIO_CurrentPrice_By_LivingArea": "555.12821" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "555.12821" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.76412" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "555.12821" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY406415116')" +"provider_name": "One Key" +"Media": array:41 [ …41] +"ID": "18150" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4917 +post_id: "18302" +post_author: 1 +"ListingKey": "KEY326304092" +"ListingId": "L3572414" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-10-17T16:34:36Z" +"RFModificationTimestamp": "2025-10-17T16:38:00Z" +"ListPrice": 1699000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.17 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1824 Gildersleeve Street, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6721195 +"Longitude": -73.567498237132 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Laurie A. Riechert" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "119789" +"ListOfficeMlsId": "SPH01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to 1824 Gildersleeve. This stunning custom build is truly breathtaking . Designer quality with the epitome of luxury and comfort. This 3800 sq ft show piece has 9 ft ceilings and grand entrance with double height foyer. The interior has a spacious open floor plan with custom millwork and fluted panels. The entire home has white oak flooring giving it a timeless charm. Each room has been thoughtfully designed for both function and beauty. The kitchen is a true work of art with high end Viking appliances and Miraggio quartz counters and island. Marble tiled bathrooms with double vanities and gas fire place, Solid wood doors throughout the home. Tray and coffered ceilings. The primary bedroom suite is stunning. The primary shower and soaking tub offers a fabulous retreat after a long day. The home is equipped with security alarm, surround sound speakers and smart switches. 2 zone heat/cac and central vacuum. The exterior boasts Azek trim with natural stone siding. Pella windows throughout. Decorative designed pavers and a completely fenced yard. In ground sprinkler system. Huge unfinished basement with an outside entry., Additional information: Appearance:Mint,Interior Features:Marble Bath,Separate Hotwater Heater:Y" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-673-3700" +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-458-0776" +"BuyerAgentEmail": "jriechert@signaturepremier.com" +"BuyerAgentFullName": "Jonathan Riechert" +"BuyerAgentKey": "326231850" +"BuyerAgentMlsId": "222970" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115709" +"BuyerOfficeMlsId": "SPH01" +"BuyerOfficeName": "Signature Premier Properties" +"BuyerOfficePhone": "631-673-3700" +"CoBuyerAgentDirectPhone": "516-404-3955" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-404-3955" +"CoListAgentEmail": "billyriechert@signaturepremier.com" +"CoListAgentFullName": "William Riechert" +"CoListAgentKey": "326223817" +"CoListAgentMlsId": "214673" +"CoListOfficeKey": "326115709" +"CoListOfficeMlsId": "SPH01" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "631-673-3700" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-08-14T21:44:00.262797+00:00" +"CrossStreet": "Gianelli Avenue" +"DaysOnMarket": 8 +"ElementarySchool": "Camp Avenue School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2025-12-15" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-448-8195" +"ListAgentEmail": "lriechert@signaturepremier.com" +"ListAgentKey": "326135156" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115709" +"ListOfficePhone": "631-673-3700" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-08-13" +"LotFeatures": array:2 [ …2] +"LotSizeDimensions": "75x100" +"LotSizeSquareFeet": 7500 +"MajorChangeTimestamp": "2024-08-21T04:00:00Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Grand Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2024-08-21" +"OnMarketDate": "2024-08-14" +"OriginalEntryTimestamp": "2024-08-14T21:13:20Z" +"OriginalListPrice": 1699000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3572414" +"OriginatingSystemModificationTimestamp": "2025-10-17T16:32:56Z" +"OwnerName": "Twin Oaks Real Estate Dev Inc" +"ParcelNumber": "2089-55-092-00-1262-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2025-10-17T16:34:36Z" +"PhotosCount": 44 +"PostalCity": "Merrick" +"PropertyCondition": array:1 [ …1] +"PurchaseContractDate": "2024-08-21" +"RoomsTotal": "10" +"SecurityFeatures": array:1 [ …1] +"ShowingContactPhone": "631-673-3700" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3572414" +"SourceSystemKey": "3572414" +"StateOrProvince": "NY" +"StreetName": "Gildersleeve" +"StreetNumber": "1824" +"StreetNumberNumeric": "1824" +"StreetSuffix": "Street" +"SyndicateTo": array:1 [ …1] +"TaxBlock": "92" +"TaxLot": "1262" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_Hamlet": "Merrick" +"KEY_TaxSection": "55" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1699000.00" +"KEY_AdditionalFees": "0.00" +"KEY_NumOf1BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf4BedRooms": "0" +"KEY_OpenHouseCount": "0" +"KEY_AdditionalRooms": "Library/Den" +"KEY_IncludedInTaxes": "Sewer" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Pending" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_OriginatingSystemTimestamp": "2024-08-21T16:39:11.000" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY326304092')" +"provider_name": "One Key" +"Media": array:44 [ …44] +"ID": "18302" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4916 +post_id: "18256" +post_author: 1 +"ListingKey": "KEY326299951" +"ListingId": "L3572089" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-08-08T17:06:36Z" +"RFModificationTimestamp": "2025-08-08T17:08:32Z" +"ListPrice": 759990.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.25 +"LivingArea": 2198.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "138 Hewlett Avenue, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6691611 +"Longitude": -73.551522158163 +"YearBuilt": 1927 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "William L. Kutsch" +"ListOfficeName": "Daniel Gale Sothebys Intl Rlty" +"ListAgentMlsId": "202788" +"ListOfficeMlsId": "GALE06" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Step into this charming and cozy 3BR, 1 Bath expanded Cape Cod home located in prestigious Merrick Woods, where possibilities abound. The main level features a living room, a den with elegant French doors that let in plenty of sunlight, an adjoining formal dining room, and an eat-in kitchen that's perfect for hosting events. The first level also includes two bedrooms and a full bathroom. Upstairs, there's ample storage and alternative living spaces such as a third bedroom and bonus room. The full basement is unfinished. Outside, you'll find a huge fenced-in property perfect for outdoor gatherings. There's plenty of room for a pool, garden, gazebo, fire pit, or a lush lawn. Recent upgrades include the roof, HVAC, HW heater, dehumidifier, vinyl windows, 150A electric, and PVC piping. Plus, the home offers easy expansion opportunities. There's also a two-car detached garage. With its proximity to the LIRR (less than an hour to Penn or GCM) and major highways, commuting is a breeze. You'll also have easy access to the Merrick Mall, restaurants, shopping, and all the amenities that Merrick has to offer. Welcome to your new home!, Additional information: Cooling:SEER Rating 12+,Separate Hotwater Heater:Y" +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Park" +"AttributionContact": "631-689-6980" +"Basement": array:2 [ …2] +"BathroomsFull": 1 +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-729-4788" +"BuyerAgentEmail": "deanna@longislandlegacy.com" +"BuyerAgentFullName": "Deanna Arecco" +"BuyerAgentKey": "326235933" +"BuyerAgentMlsId": "227179" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326113763" +"BuyerOfficeMlsId": "MLSH01" +"BuyerOfficeName": "Exit Realty Everyday" +"BuyerOfficePhone": "631-343-8700" +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "516-633-1188" +"CoBuyerAgentEmail": "colleen@longislandlegacy.com" +"CoBuyerAgentFullName": "Colleen Chase" +"CoBuyerAgentKey": "326207702" +"CoBuyerAgentMlsId": "198109" +"CoBuyerOfficeKey": "326113763" +"CoBuyerOfficeMlsId": "MLSH01" +"CoBuyerOfficeName": "Exit Realty Everyday" +"CoBuyerOfficePhone": "631-343-8700" +"ConstructionMaterials": array:4 [ …4] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-10-02T15:26:07.657920+00:00" +"CrossStreet": "Loines Avenue" +"CumulativeDaysOnMarket": 455 +"DaysOnMarket": 455 +"DirectionFaces": "West" +"Directions": "Sunrise Highway, north on Hewlett Avenue, past Smith, before Loines." +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-08" +"Fencing": array:1 [ …1] +"Flooring": array:2 [ …2] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-428-9866" +"ListAgentEmail": "williamkutsch@danielgale.com" +"ListAgentKey": "326212256" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111550" +"ListOfficePhone": "631-689-6980" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2023-08-07" +"LivingAreaSource": "Appraiser" +"LotFeatures": array:5 [ …5] +"LotSizeDimensions": ".25" +"LotSizeSquareFeet": 10800 +"MajorChangeTimestamp": "2024-12-06T22:04:28Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Grand Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2024-12-06" +"OnMarketDate": "2023-08-07" +"OriginalEntryTimestamp": "2024-08-13T19:14:26Z" +"OriginalListPrice": 819990 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3572089" +"OriginatingSystemModificationTimestamp": "2025-08-08T17:04:58Z" +"OwnerName": "Estate of Szabo" +"ParcelNumber": "2089-56-098-00-0007-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-11-02T02:18:28Z" +"PhotosCount": 35 +"PostalCity": "Merrick" +"PreviousListPrice": 779990 +"PriceChangeTimestamp": "2024-11-12T15:09:34Z" +"PurchaseContractDate": "2024-12-06" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "855-746-9901" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "3572089" +"SourceSystemKey": "3572089" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2024-12-06T22:04:28Z" +"StreetName": "Hewlett" +"StreetNumber": "138" +"StreetNumberNumeric": "138" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "17423.85" +"TaxBlock": "98" +"TaxLot": "7" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"Zoning": "210" +"KEY_Attic": "Full" +"KEY_Hamlet": "Merrick" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "56" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "759990.00" +"KEY_ContractPrice": "749000.00" +"KEY_WaterAccessYN": "0" +"KEY_AdditionalFees": "0.00" +"KEY_NumOf1BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf4BedRooms": "0" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalRooms": "Library/Den" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Pending" +"KEY_NumberOfHeatingZones": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_OriginatingSystemTimestamp": "2024-11-20T13:21:16.000" +"KEY_RATIO_ListPrice_By_LivingArea": "345.76433" +"KEY_RATIO_CurrentPrice_By_LivingArea": "345.76433" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.92683" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY326299951')" +"provider_name": "One Key" +"Media": array:35 [ …35] +"ID": "18256" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4923 +post_id: "22456" +post_author: 1 +"ListingKey": "KEY3570309" +"ListingId": "L3570309" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-11-15T05:21:25Z" +"RFModificationTimestamp": "2024-11-15T05:33:01Z" +"ListPrice": 675000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.13 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Merrick" +"PostalCode": "11566" +"UnparsedAddress": "210 Elsie Avenue, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.66843 +"Longitude": -73.56292650925 +"YearBuilt": 1949 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jasmine T Kattermann" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "206109" +"ListOfficeMlsId": "SPH21" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Come and see this charming Sunny 4 bedroom 2.5 bathroom cape! Hardwood floors on 1st floor, New wall to wall carpet on 2nd floor and stairs. There is a large family room perfect for entertaining." +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"CancellationDate": "2024-11-13" +"CoListAgentEmail": "amandasellslongisland@gmail.com" +"CoListAgentFullName": "Amanda Dubester" +"CoListAgentKey": "215964" +"CoListAgentMlsId": "215964" +"CoListAgentPreferredPhone": "631-922-2944" +"CoListOfficeKey": "21817020" +"CoListOfficeMlsId": "SPH20" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "631-647-4880" +"CommonWalls": array:1 [ …1] +"ConstructionMaterials": array:4 [ …4] +"Cooling": array:3 [ …3] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-08-05T13:51:30.710571+00:00" +"CrossStreet": "Meadowbrook Rd" +"DirectionFaces": "South" +"Directions": "GPS" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2024-11-07" +"Fencing": array:1 [ …1] +"Flooring": array:2 [ …2] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Merrick" +"Inclusions": "A/C Units,Dehumidifier,Light Fixtures,Mailbox,Refrigerator,Screens" +"InteriorFeatures": array:5 [ …5] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentEmail": "jkattermann@signaturepremier.com" +"ListAgentFirstName": "Jasmine" +"ListAgentKey": "206109" +"ListAgentLastName": "Kattermann" +"ListAgentPreferredPhone": "631-334-1447" +"ListOfficeKey": "21817021" +"ListOfficePhone": "631-567-0100" +"ListPriceLow": 675000 +"ListingContractDate": "2024-08-05" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.13 +"LotSizeDimensions": "50x113" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 5600 +"MLSAreaMinor": "5" +"MajorChangeTimestamp": "2024-11-15T05:10:39Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "U" +"OffMarketDate": "2024-08-23" +"OnMarketDate": "2024-08-07" +"OriginalEntryTimestamp": "2024-08-05T12:55:19Z" +"OriginalListPrice": 675000 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3570309" +"OriginatingSystemModificationTimestamp": "2024-11-15T05:10:39Z" +"OwnerName": "Mildred A Young Revocable Trust" +"ParcelNumber": "2089-55-066-00-0140-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-08-05T13:47:24Z" +"PhotosCount": 28 +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-334-1447" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3570309" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Elsie" +"StreetNumber": "210" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Come and see this charming Sunny 4 bedroom 2.5 bathroom cape! Hardwood floors on 1st floor, New wall to wall carpet on 2nd floor and stairs. There is a large family room perfect for entertaining." +"TaxAnnualAmount": "13941.08" +"TaxBlock": "66" +"TaxLot": "140" +"TaxMapNumber": "2089-55-066-00-0140-0" +"Township": "Hempstead" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"KEY_HighPriceDollars": "675000" +"KEY_IncludedInTaxes": "Sewer,Trash,Water" +"KEY_HotWater": "Gas Stand Alone" +"KEY_OfferPresentation": "Cannot be Present" +"KEY_AttributionContact": "631-567-0100" +"KEY_HoldEndDate": "2024-08-29" +"KEY_HoldStartDate": "2024-08-23" +"KEY_SeparateHotwaterHeaterDetail": "Y" +"KEY_CoListMainOfficeMlsId": "SPH01" +"KEY_FloodZoneReportYN": "1" +"KEY_GarbageRemoval": "Public" +"KEY_NumberOfKitchens": "1" +"KEY_SellerConsiderConcessionYN": "0" +"KEY_OriginatingSystemOfficeKey": "21817021" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "None" +"KEY_FloodZoneDate": "2024-08-19" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "SPH01" +"KEY_MinorChangeTimestamp": "2024-11-15T00:00:00-05:00" +"KEY_AtticDescription": "None" +"KEY_NumberOfHeatingZones": "2" +"KEY_SourceSystemModificationTimestamp": "2024-11-15T00:20:52-05:00" +"KEY_AlternateMlsNumber": "3570309" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY3570309')" +"provider_name": "One Key" +"Media": array:28 [ …28] +"ID": "22456" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4924 +post_id: "22567" +post_author: 1 +"ListingKey": "KEY3569455" +"ListingId": "L3569455" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-11-02T04:24:24Z" +"RFModificationTimestamp": "2024-11-02T04:28:38Z" +"ListPrice": 699000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.17 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Merrick" +"PostalCode": "11566" +"UnparsedAddress": "1591 Rhode Avenue, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6788835 +"Longitude": -73.5652365 +"YearBuilt": 1924 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "John O McConnell" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "187605" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "A beautiful home, in a great location, in a great neighborhood!!!!! Turn the key and move right in. A exceptionally well maintained craftsman home in the Briarcliff area. The house features large rooms, updated kitchen and bathrooms, central AC, an expansive two car garage, and a multi-car driveway. House also comes with a new en-suite master bath with zero entry shower, second bathroom newly renovated. Crown moldings galore !!! Custom cabinetry, beautiful wood flooring, Attractive brick wood burning fireplace. beautiful deck and paver patio with grassy area perfect for entertaining and kids. Close to all schools in a top district. Major appliances recently replaced. Low taxes and move in Ready! BRAND NEW ROOF!!!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-08-01T05:17:56.604907+00:00" +"CrossStreet": "Camp Ave." +"DirectionFaces": "West" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2024-11-01" +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Merrick" +"Inclusions": "A/C Units,Cook Top,Curtains/Drapes,Dishwasher,Door Hardware,Energy Star Appliance(s),Fireplace Equip,Front Gate,Garage Door Opener,Garage Remote,Microwave,Refrigerator" +"InteriorFeatures": array:11 [ …11] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentEmail": "John.Mc Connell@elliman.com" +"ListAgentFirstName": "John" +"ListAgentKey": "187605" +"ListAgentLastName": "Mc Connell" +"ListAgentPreferredPhone": "516-623-4500" +"ListOfficeKey": "5305028" +"ListOfficePhone": "516-623-4500" +"ListPriceLow": 699000 +"ListingContractDate": "2024-08-01" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.17 +"LotSizeDimensions": "58x125" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 7250 +"MLSAreaMinor": "5" +"MajorChangeTimestamp": "2024-11-02T04:10:27Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "U" +"OffMarketDate": "2024-11-01" +"OnMarketDate": "2024-08-01" +"OriginalEntryTimestamp": "2024-08-01T04:05:20Z" +"OriginalListPrice": 699000 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3569455" +"OriginatingSystemModificationTimestamp": "2024-11-02T04:10:27Z" +"OwnerName": "Mckenna" +"ParcelNumber": "2089-55-009-00-0722-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2024-08-01T20:59:24Z" +"PhotosCount": 21 +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-557-4618" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3569455" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Rhode" +"StreetNumber": "1591" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "A beautiful home, in a great location, in a great neighborhood!!!!! Turn the key and move right in. A exceptionally well maintained craftsman home in the Briarcliff area. The house features large rooms, updated kitchen and bathrooms, central AC, an expansive two car garage, and a multi-car driveway. House also comes with a new en-suite master bath with zero entry shower, second bathroom newly renovated. Crown moldings galore !!! Custom cabinetry, beautiful wood flooring, Attractive brick wood burning fireplace. beautiful deck and paver patio with grassy area perfect for entertaining and kids. Close to all schools in a top district. Major appliances recently replaced. Low taxes and move in Ready! BRAND NEW ROOF!!!" +"TaxAnnualAmount": "12400" +"TaxBlock": "9" +"TaxLot": "722" +"TaxMapNumber": "2089-55-009-00-0722-0" +"Township": "Hempstead" +"WaterSource": array:1 [ …1] +"YearBuiltEffective": 2005 +"KEY_HighPriceDollars": "699000" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_HotWater": "Gas Stand Alone" +"KEY_OfferPresentation": "Can be Present" +"KEY_AttributionContact": "516-623-4500" +"KEY_FloodZoneReportYN": "1" +"KEY_GarbageRemoval": "Public" +"KEY_NumberOfKitchens": "1" +"KEY_OriginatingSystemOfficeKey": "5305028" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "None" +"KEY_FloodZoneDate": "2024-08-19" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "DERE01" +"KEY_MinorChangeTimestamp": "2024-11-02T00:00:00-04:00" +"KEY_AtticDescription": "None" +"KEY_NumberOfHeatingZones": "1" +"KEY_SourceSystemModificationTimestamp": "2024-11-02T00:22:51-04:00" +"KEY_AlternateMlsNumber": "3569455" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY3569455')" +"location_extra_data": array:4 [ …4] +"full_address": "1591 Rhode Avenue, Merrick, NY 11566" +"provider_name": "One Key" +"short_address": "Merrick, New York 11566, US" +"Media": array:21 [ …21] +"ID": "22567" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4925 +post_id: "22544" +post_author: 1 +"ListingKey": "KEY3563495" +"ListingId": "L3563495" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-08-12T04:25:24Z" +"RFModificationTimestamp": "2024-12-13T03:57:35Z" +"ListPrice": 1349888.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.33 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Merrick" +"PostalCode": "11566" +"UnparsedAddress": "2169 E Seneca Drive, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6666881 +"Longitude": -73.54666528125 +"YearBuilt": 1951 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Earnest Brown Downie" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "209420" +"ListOfficeMlsId": "SPH22" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to 2169 Seneca Dr East, a one-of-a-kind Masciola expanded ranch located in the heart of Merrick Woods. This elegant and comfortable home boasts five spacious bedrooms, including two primary bedrooms, and three full baths. The first floor features a cozy wood-burning fireplace, creating a warm and inviting atmosphere. The formal dining room is perfect for entertaining guests, while the spacious den with skylight and large Pella windows that offers stunning views of the private, resort-like backyard overlooking the lake. The eat-in kitchen has picturesque lake views right from the kitchen sink. The updated bathrooms add a modern touch, and the full unfinished basement provides ample storage or potential for customization to suit your needs. Step outside to your own private paradise, where Pella sliding doors open to a huge upper deck with breathtaking lake views. The 16x36 in-ground pool is surrounded by another large deck, making it the perfect spot for outdoor entertaining. Situated on a generous 80x180 lakefront property, this home is completely move-in ready. Enjoy the convenience of being just a few blocks from the Long Island Railroad and in close proximity to nearby beaches, parkways, and shopping. Don't miss this rare opportunity to own an exceptional home in Merrick Woods!" +"ArchitecturalStyle": array:1 [ …1] +"AttachedGarageYN": true +"Basement": array:2 [ …2] +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CoListAgentEmail": "kevinsoldmyhome@gmail.com" +"CoListAgentFullName": "Kevin Iglesias" +"CoListAgentKey": "180504" +"CoListAgentMlsId": "180504" +"CoListAgentPreferredPhone": "631-618-7413" +"CoListOfficeKey": "21817022" +"CoListOfficeMlsId": "SPH22" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "631-642-2300" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-07-03T23:01:52.273986+00:00" +"CrossStreet": "Cayuga Drive" +"Directions": "GPS Navy Blue House with Sign" +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"Exclusions": "Chandelier(s)" +"ExpirationDate": "2024-08-11" +"ExteriorFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:5 [ …5] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentEmail": "ebrown@signaturepremier.com" +"ListAgentFirstName": "Earnest" +"ListAgentKey": "209420" +"ListAgentLastName": "Brown Downie" +"ListAgentPreferredPhone": "631-512-9019" +"ListOfficeKey": "21817022" +"ListOfficePhone": "631-642-2300" +"ListPriceLow": 1349888 +"ListingContractDate": "2024-07-03" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.33 +"LotSizeDimensions": "80x180" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 14400 +"MLSAreaMinor": "5" +"MajorChangeTimestamp": "2024-08-12T04:10:34Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "U" +"OffMarketDate": "2024-08-11" +"OnMarketDate": "2024-07-03" +"OriginalEntryTimestamp": "2024-07-03T04:00:00Z" +"OriginalListPrice": 1349888 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3563495" +"OriginatingSystemModificationTimestamp": "2024-08-12T04:10:34Z" +"OwnerName": "Cooke" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2024-07-19T21:47:23Z" +"PhotosCount": 31 +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-512-9019" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3563495" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetDirPrefix": "E" +"StreetName": "Seneca" +"StreetNumber": "2169" +"StreetSuffix": "Drive" +"SubdivisionName": "Merrick Woods" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Welcome to 2169 Seneca Dr East, a one-of-a-kind Masciola expanded ranch located in the heart of Merrick Woods. This elegant and comfortable home boasts five spacious bedrooms, including two primary bedrooms, and three full baths. The first floor features a cozy wood-burning fireplace, creating a warm and inviting atmosphere. The formal dining room is perfect for entertaining guests, while the spacious den with skylight and large Pella windows that offers stunning views of the private, resort-like backyard overlooking the lake. The eat-in kitchen has picturesque lake views right from the kitchen sink. The updated bathrooms add a modern touch, and the full unfinished basement provides ample storage or potential for customization to suit your needs. Step outside to your own private paradise, where Pella sliding doors open to a huge upper deck with breathtaking lake views. The 16x36 in-ground pool is surrounded by another large deck, making it the perfect spot for outdoor entertaining. Situated on a generous 80x180 lakefront property, this home is completely move-in ready. Enjoy the convenience of being just a few blocks from the Long Island Railroad and in close proximity to nearby beaches, parkways, and shopping. Don't miss this rare opportunity to own an exceptional home in Merrick Woods!" +"TaxAnnualAmount": "19993" +"TaxBlock": "455" +"TaxLot": "0024" +"Township": "Hempstead" +"VirtualTourURLBranded": "https://my.matterport.com/show/?m=gMBEUrtiRC9&mls=1" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=gMBEUrtiRC9&mls=1" +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:2 [ …2] +"WindowFeatures": array:1 [ …1] +"KEY_DevelopmentName": "Merrick Woods" +"KEY_HighPriceDollars": "1349888" +"KEY_HotWater": "See Remarks" +"KEY_OfferPresentation": "Cannot be Present" +"KEY_AttributionContact": "631-642-2300" +"KEY_VirtualTourURLUnbranded2": "https://my.matterport.com/show/?m=gMBEUrtiRC9&mls=1" +"KEY_SeparateHotwaterHeaterDetail": "Yes" +"KEY_CoListMainOfficeMlsId": "SPH01" +"KEY_VirtualTourURLUnbranded3": "https://my.matterport.com/show/?m=gMBEUrtiRC9&mls=1" +"KEY_FloodZoneReportYN": "0" +"KEY_VirtualTourURLUnbranded4": "https://my.matterport.com/show/?m=gMBEUrtiRC9&mls=1" +"KEY_NumberOfKitchens": "1" +"KEY_OriginatingSystemOfficeKey": "21817022" +"KEY_DPRYN": "0" +"KEY_ModificationsExclusions": "None" +"KEY_RentIncome": "0" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "SPH01" +"KEY_MinorChangeTimestamp": "2024-08-12T00:00:00-04:00" +"KEY_AtticDescription": "Full" +"KEY_NumberOfHeatingZones": "4" +"KEY_SourceSystemModificationTimestamp": "2024-08-12T00:24:16-04:00" +"KEY_VideoTourURL": "https://my.matterport.com/show/?m=gMBEUrtiRC9&mls=1" +"KEY_AlternateMlsNumber": "3563495" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY3563495')" +"provider_name": "OneKey" +"Media": array:31 [ …31] +"ID": "22544" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4926 +post_id: "22543" +post_author: 1 +"ListingKey": "KEY323147470" +"ListingId": "L3563141" +"PropertyType": "Commercial Sale" +"PropertySubType": "Retail" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-01-05T05:11:37Z" +"RFModificationTimestamp": "2025-01-05T05:15:23Z" +"ListPrice": 88000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "1377 Jerusalem Ave, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6938796 +"Longitude": -73.5689521 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gangtang Fa" +"ListOfficeName": "Royalux Realty LLC" +"ListAgentMlsId": "225709" +"ListOfficeMlsId": "RLXX01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Nail salon business for sale. High foot traffic, stable customer base. Ready for the new business owner to take over business at any time, good business." +"AttributionContact": "516-260-2269" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "347-345-6211" +"CoListAgentEmail": "carmenli84323@gmail.com" +"CoListAgentFullName": "Carmen Li" +"CoListAgentKey": "326228386" +"CoListAgentMlsId": "219390" +"CoListOfficeKey": "326115117" +"CoListOfficeMlsId": "RLXX01" +"CoListOfficeName": "Royalux Realty LLC" +"CoListOfficePhone": "718-666-6066" +"CountyOrParish": "Nassau County" +"CreationDate": "2024-07-02T19:22:33.797381+00:00" +"CrossStreet": "Midian St" +"CumulativeDaysOnMarket": 187 +"DaysOnMarket": 187 +"ExpirationDate": "2025-01-05" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-260-2269" +"ListAgentEmail": "fa_1000_1000@icloud.com" +"ListAgentKey": "326234484" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115117" +"ListOfficePhone": "718-666-6066" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-07-02" +"MajorChangeTimestamp": "2025-01-05T05:10:23Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"OffMarketDate": "2025-01-05" +"OnMarketDate": "2024-07-02" +"OriginalEntryTimestamp": "2024-07-02T19:05:59Z" +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3563141" +"OriginatingSystemModificationTimestamp": "2025-01-05T05:10:23Z" +"OwnerName": "Xu" +"PhotosChangeTimestamp": "2024-11-02T02:15:55Z" +"PhotosCount": 4 +"PostalCity": "Merrick" +"SourceSystemID": "3563141" +"SourceSystemKey": "3563141" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-01-05T05:10:23Z" +"StreetName": "Jerusalem Ave" +"StreetNumber": "1377" +"StreetNumberNumeric": "1377" +"Zoning": "-" +"KEY_OpenHousePublicCount": "0" +"KEY_AdditionalParcelYN": "0" +"KEY_OriginatingSystemTimestamp": "2024-08-07T12:49:19.000" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_CurrentPrice": "88000.00" +"KEY_AdditionalFees": "0.00" +"KEY_NumberOfTailBoards": "0" +"KEY_Hamlet": "Merrick" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_OpenHouseCount": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_SeasonalYN": "0" +"KEY_RentSpreeYN": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY323147470')" +"provider_name": "One Key" +"Media": array:4 [ …4] +"ID": "22543" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4927 +post_id: "22376" +post_author: 1 +"ListingKey": "KEY3555294" +"ListingId": "L3555294" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-10-30T04:24:23Z" +"RFModificationTimestamp": "2024-10-30T04:28:02Z" +"ListPrice": 969900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.18 +"LivingArea": 2087.0 +"BuildingAreaTotal": 0 +"City": "Merrick" +"PostalCode": "11566" +"UnparsedAddress": "1277 Jerusalem Avenue, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.694335928571 +"Longitude": -73.576302642857 +"YearBuilt": 1929 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Yasminda Peralta Lowe" +"ListOfficeName": "Charles Rutenberg Realty Inc" +"ListAgentMlsId": "114150" +"ListOfficeMlsId": "CHRU01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This beautiful colonial home has a lot to offer....so much that you will have no desire to leave home. You enter this home either from your circular driveway or from a driveway on side of the house. This home boast hard wood floors through-out. It has a living room with a working wood burning fireplace, Office with French doors, Den/TV area with panoramic views of a heated saltwater pool. The full bathroom also has direct exit to pool area. The Updated kitchen has a 6 burner Viking Gas stove, Miele/ kitchenAid appliances and custom kitchen cabinets. Master Bedroom suite has a Walk-in closet, and the Master bathroom has a powder area for her and a jacuzzi bathtub made for 2! This Master Bedroom suite also has a balcony that overlooks the pool. Beautiful night view of the lit pool. The 2 other bedrooms has an updated full bathroom to share. this home has inground sprinklers to maintain this garden style landscaping with lights and beautiful perennial flowers. 2 Zone HVAC/Central AC. 1.5 Car garage with auto Door (wifi) Opener. This staycation home is a private Oasis. A must see!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-05-30T20:55:56.473048+00:00" +"CrossStreet": "North Drive" +"DirectionFaces": "South" +"Directions": "Maps" +"ElementarySchool": "Harold D Fayette School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2024-10-29" +"ExteriorFeatures": array:3 [ …3] +"Fencing": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:4 [ …4] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "North Merrick" +"Inclusions": "Dishwasher, Dryer, Washer" +"InteriorFeatures": array:9 [ …9] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentEmail": "yasminda_peralta@yahoo.com" +"ListAgentFirstName": "Yasminda" +"ListAgentKey": "114150" +"ListAgentLastName": "Peralta Lowe" +"ListAgentPreferredPhone": "516-575-7500" +"ListOfficeKey": "138745000" +"ListOfficePhone": "516-575-7500" +"ListPriceLow": 969900 +"ListingContractDate": "2024-05-30" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.18 +"LotSizeDimensions": "60x125" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 7625 +"MLSAreaMinor": "5" +"MajorChangeTimestamp": "2024-10-30T04:10:27Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "North Merrick" +"MlsStatus": "U" +"OffMarketDate": "2024-10-29" +"OnMarketDate": "2024-05-30" +"OriginalEntryTimestamp": "2024-05-30T17:50:50Z" +"OriginalListPrice": 997000 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3555294" +"OriginatingSystemModificationTimestamp": "2024-10-30T04:10:27Z" +"OwnerName": "Kopecky" +"ParcelNumber": "2089-50-588-00-0009-0" +"ParkingFeatures": array:5 [ …5] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-10-23T12:27:23Z" +"PhotosCount": 20 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PreviousListPrice": 969000 +"PriceChangeTimestamp": "2024-07-15T15:03:53Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "917-346-5171" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3555294" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Jerusalem" +"StreetNumber": "1277" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "This beautiful colonial home has a lot to offer....so much that you will have no desire to leave home. You enter this home either from your circular driveway or from a driveway on side of the house. This home boast hard wood floors through-out. It has a living room with a working wood burning fireplace, Office with French doors, Den/TV area with panoramic views of a heated saltwater pool. The full bathroom also has direct exit to pool area. The Updated kitchen has a 6 burner Viking Gas stove, Miele/ kitchenAid appliances and custom kitchen cabinets. Master Bedroom suite has a Walk-in closet, and the Master bathroom has a powder area for her and a jacuzzi bathtub made for 2! This Master Bedroom suite also has a balcony that overlooks the pool. Beautiful night view of the lit pool. The 2 other bedrooms has an updated full bathroom to share. this home has inground sprinklers to maintain this garden style landscaping with lights and beautiful perennial flowers. 2 Zone HVAC/Central AC. 1.5 Car garage with auto Door (wifi) Opener. This staycation home is a private Oasis. A must see!" +"TaxAnnualAmount": "15533.3" +"TaxBlock": "588" +"TaxLot": "9" +"TaxMapNumber": "2089-50-588-00-0009-0" +"Township": "Hempstead" +"WaterSource": array:1 [ …1] +"KEY_HighPriceDollars": "969900" +"KEY_SquareFootageSource": "Other" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_HotWater": "Gas Stand Alone" +"KEY_OfferPresentation": "Cannot be Present" +"KEY_AttributionContact": "516-575-7500" +"KEY_SeparateHotwaterHeaterDetail": "yes" +"KEY_FloodZoneReportYN": "1" +"KEY_GarbageRemoval": "Public" +"KEY_NumberOfKitchens": "1" +"KEY_OriginatingSystemOfficeKey": "138745000" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "None" +"KEY_FloodZoneDate": "2024-06-04" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "CHRU01" +"KEY_MinorChangeTimestamp": "2024-10-30T00:00:00-04:00" +"KEY_AtticDescription": "Partial" +"KEY_SquareFootage": "2087.00" +"KEY_SourceSystemModificationTimestamp": "2024-10-30T00:22:43-04:00" +"KEY_AlternateMlsNumber": "3555294" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY3555294')" +"location_extra_data": array:4 [ …4] +"full_address": "1277 Jerusalem Avenue, Merrick, NY 11566" +"provider_name": "One Key" +"short_address": "Merrick, New York 11566, US" +"Media": array:20 [ …20] +"ID": "22376" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4928 +post_id: "18319" +post_author: 1 +"ListingKey": "KEY322500258" +"ListingId": "L3543730" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2024-12-03T02:16:44Z" +"RFModificationTimestamp": "2024-12-04T18:28:42Z" +"ListPrice": 1399000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.24 +"LivingArea": 3300.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "101 Northridge Avenue, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6839662 +"Longitude": -73.5692536 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jonathan M. Miller" +"ListOfficeName": "NYONLINEREALTY.COM" +"ListAgentMlsId": "149602" +"ListOfficeMlsId": "NYOR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Brand-New Custom Colonial TO-BE-BUILT on ENORMOUS PROPERTY (APPROX 185' DEEP LOT) in PRIME N. MERRICK location! Open Floor Plan with Endless High-End Amenities and Top-of-the-Line Finishes. Huge 4 Bdrm, 2.5 Bath Home (9' first floor ceilings) w/ Front Porch, Large Garage, & Full Basement with 8' ceilings and outside entrance. Comes Fully Loaded W/ Stunning Trim-work throughout, Custom Kitchen & Vanities w/ Granite Countertops, Custom Gas Fireplace, 2nd Floor Laundry Room, Master En-Suite, Walk In Closets, Attic Storage, & Many "Extras"/Upgrades INCLUDED, such as: Surround Sound & Security System, High-end Professional SS Appliances, Front Yard Landscaping Pkg w/ UGS & sod, & MUCH MORE! Built By QUALITY Builder of over 400 New Homes over 35+years... THE TIME TO CUSTOMIZE INTERIOR & EXTERIOR FINISHES IS NOW (OCTOBER 2024 EST. COMPLETION)! The Next Door You Open Will Be That Of Your Dream Home., Additional information: Appearance:brand-new,Green Features:Green Certified,Insulated Doors" +"Appliances": array:10 [ …10] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Park" +"AttributionContact": "516-798-3000" +"Basement": array:3 [ …3] +"BathroomsFull": 2 +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-799-4776" +"BuyerAgentEmail": "jmmiller516@gmail.com" +"BuyerAgentFullName": "Jonathan M. Miller" +"BuyerAgentKey": "326162401" +"BuyerAgentMlsId": "149602" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326114247" +"BuyerOfficeMlsId": "NYOR01" +"BuyerOfficeName": "NYONLINEREALTY.COM" +"BuyerOfficePhone": "516-798-3000" +"CoBuyerAgentDirectPhone": "516-695-7902" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-695-7902" +"CoListAgentEmail": "carlo.iacona@nyonlinerealty.com" +"CoListAgentFullName": "Carl Iacona" +"CoListAgentKey": "326207539" +"CoListAgentMlsId": "197937" +"CoListOfficeKey": "326114247" +"CoListOfficeMlsId": "NYOR01" +"CoListOfficeName": "NYONLINEREALTY.COM" +"CoListOfficePhone": "516-798-3000" +"ConstructionMaterials": array:7 [ …7] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-04-10T20:51:33.801739+00:00" +"CrossStreet": "William St" +"DaysOnMarket": 131 +"Directions": "Merrick Ave to William St to north on Northridge (#101 at very end of block)." +"Disclosures": array:1 [ …1] +"ElementarySchool": "Old Mill Road School" +"ExpirationDate": "2024-10-10" +"ExteriorFeatures": array:2 [ …2] +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GreenBuildingVerificationType": "HERS Index Score" +"Heating": array:4 [ …4] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "North Merrick" +"InteriorFeatures": array:15 [ …15] +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-799-4776" +"ListAgentEmail": "jmmiller516@gmail.com" +"ListAgentKey": "326162401" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114247" +"ListOfficePhone": "516-798-3000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-04-10" +"LivingAreaSource": "Plans" +"LotFeatures": array:7 [ …7] +"LotSizeDimensions": "59'x184'" +"LotSizeSquareFeet": 10412 +"MajorChangeTimestamp": "2024-08-20T04:00:00Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2024-08-19" +"OriginalEntryTimestamp": "2024-04-10T19:17:32Z" +"OriginalListPrice": 1399000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3543730" +"OriginatingSystemModificationTimestamp": "2024-12-03T02:09:33Z" +"OwnerName": "L I Home Builders Corp" +"ParcelNumber": "2089-55-019-00-0045-0" +"ParkingFeatures": array:4 [ …4] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-11-02T02:09:48Z" +"PhotosCount": 34 +"PostalCity": "Merrick" +"PropertyCondition": array:2 [ …2] +"PurchaseContractDate": "2024-08-19" +"RoomsTotal": "9" +"SecurityFeatures": array:1 [ …1] +"ShowingContactPhone": "877-598-7816" +"SourceSystemID": "3543730" +"SourceSystemKey": "3543730" +"StateOrProvince": "NY" +"StreetName": "Northridge" +"StreetNumber": "101" +"StreetNumberNumeric": "101" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "15586.81" +"TaxBlock": "19" +"TaxLot": "45-46,118" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:5 [ …5] +"Zoning": "res" +"KEY_AdditionalParcelYN": "0" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_DownPaymentResourceYN": "0" +"KEY_AdditionalRooms": "Library/Den" +"KEY_AdditionalFeesYN": "0" +"KEY_AdditionalFees": "0.00" +"KEY_NumberOfKitchens": "1" +"KEY_RATIO_CurrentPrice_By_LivingArea": "423.93939" +"KEY_SeasonalYN": "0" +"KEY_OpenHousePublicCount": "0" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_OriginatingSystemTimestamp": "2024-08-20T13:00:02.000" +"KEY_CurrentPrice": "1399000.00" +"KEY_RoomDescription": "Enormous Fully insulated Basement with high ceilings and Outside Entrance to/from Backyard.||Big 1-car garage with approx 12' ceilings.||2-story entry foyer, formal living room, formal dining rm, eat-in-kitchen, fam room w/ gas fplc, half bathroom.||master bdrm w/ 2x walk-in-closets & full master bathroom w/ FS tub or Jacuzzi + glass stall shower + skylight... 3 add'l bdrms, full hall bathroom, laundry room.||attic storage space." +"KEY_Hamlet": "Merrick" +"KEY_MlsMajorChangeType": "Pending" +"KEY_NumOf4BedRooms": "0" +"KEY_Attic": "Pull Stairs,Partial,Unfinished" +"KEY_NumOf3BedRooms": "0" +"KEY_OpenHouseCount": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_RentSpreeYN": "0" +"KEY_NumberOfHeatingZones": "2" +"KEY_TaxSection": "55" +"KEY_RATIO_ListPrice_By_LivingArea": "423.93939" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY322500258')" +"provider_name": "One Key" +"Media": array:34 [ …34] +"ID": "18319" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4929 +post_id: "22492" +post_author: 1 +"ListingKey": "KEY3543552" +"ListingId": "L3543552" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-10-04T04:23:27Z" +"RFModificationTimestamp": "2024-10-04T04:46:59Z" +"ListPrice": 1549900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.18 +"LivingArea": 2805.0 +"BuildingAreaTotal": 0 +"City": "Merrick" +"PostalCode": "11566" +"UnparsedAddress": "2848 Bay Drive, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6496815 +"Longitude": -73.544528424979 +"YearBuilt": 1956 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Thomas S Hennerty" +"ListOfficeName": "Thomas S Hennerty" +"ListAgentMlsId": "150498" +"ListOfficeMlsId": "HENN01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to 2848 Bay Drive, a recently renovated gem nestled at the end of a serene dead end street in the highly desirable Lindemere section of South Merrick. This spectacular 2,800 sqft residence offers an inviting open floor plan with 10ft high ceilings designed for comfort and functionality, making it the perfect setting for both relaxation and entertaining. Boasting 5 well appointed bedrooms and 3.5 modern bathrooms, 2 of them in suite, equipped with radiant heat floors, this house is a haven of peace and luxury. The heart of this home is a beautiful living area that seamlessly flows into a newly remodeled two toned modern kitchen in 2022 equipped with stainless steel appliances, quartz countertops with a waterfall island, ample storage, making every meal a joy to prepare. New boiler installed in 2019, providing peace of mind and energy efficiency. The house is equipped with a WIFI controlled heating/cooling system. It comes with a 16 channel 4K interior/exterior 24/7 video/audio. Step outside to discover the deep water canal, offering direct access to breathtaking views and water activities right from your backyard. WiFi controlled sprinkler system makes it easy to care for your gorgeous landscaping that was newly designed in 2022. Tempered glass railing provides safety without obstructing the water views. Step outside your kitchen onto the trex deck covered by the master balcony above. The new roof, added in 2019, exemplifies the commitment to quality and durability in this remarkable home. Fema Flood Insurance is only $1953. Low taxes, only $18,640. You'll appreciate the convenience of being close to everything. In addition, this home qualifies for the bus to Lakeside Elementary, Middle and JFK High Schools. Merrick train station and bus stops are within easy reach, offering seamless commuting options. Don't miss the opportunity to own this waterfront sanctuary, where every day feels like a vacation. Schedule your visit today and start living the dream!" +"Appliances": array:12 [ …12] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Powered Boats Allowed" +"AttachedGarageYN": true +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CancellationDate": "2024-08-30" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:2 [ …2] +"ConstructionMaterials": array:5 [ …5] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-04-10T14:35:16.399931+00:00" +"CrossStreet": "Harbor Rd" +"DirectionFaces": "East" +"Directions": "2848 bay drive Merrick NY 11566" +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2024-10-03" +"ExteriorFeatures": array:5 [ …5] +"Fencing": array:1 [ …1] +"Flooring": array:1 [ …1] +"FrontageLength": "70" +"GarageSpaces": "2" +"GarageYN": true +"GreenWaterConservation": array:1 [ …1] +"Heating": array:3 [ …3] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"Inclusions": "A/C Units,Attic Fan,Ceiling Fan,Chandelier(s),Convection Oven,Cook Top,Curtains/Drapes,Dishwasher,Disposal,Door Hardware,Dryer,Flat Screen TV Bracket,Freezer,Low Flow fixtures,Mailbox,Nanny Cam/Comp Serv,Playset,Refrigerator,Screens,Shades/Blinds,Washer" +"InteriorFeatures": array:9 [ …9] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentEmail": "tom@netrealtynow.com" +"ListAgentFirstName": "Thomas" +"ListAgentKey": "150498" +"ListAgentLastName": "Hennerty" +"ListAgentPreferredPhone": "703-581-8605" +"ListOfficeKey": "150498000" +"ListOfficePhone": "703-581-8605" +"ListPriceLow": 1549900 +"ListingContractDate": "2024-04-10" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.18 +"LotSizeDimensions": "70 x 114" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 7980 +"MLSAreaMinor": "5" +"MajorChangeTimestamp": "2024-10-04T04:10:32Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "U" +"OffMarketDate": "2024-10-03" +"OnMarketDate": "2024-04-10" +"OriginalEntryTimestamp": "2024-04-10T13:14:53Z" +"OriginalListPrice": 1799900 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3543552" +"OriginatingSystemModificationTimestamp": "2024-10-04T04:10:32Z" +"OwnerName": "Saggese" +"ParcelNumber": "2089-62-194-00-0054-0" +"ParkingFeatures": array:6 [ …6] +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2024-04-10T16:21:24Z" +"PhotosCount": 36 +"PreviousListPrice": 1649999 +"PriceChangeTimestamp": "2024-09-18T11:27:23Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "11" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "347-784-7799" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3543552" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Bay" +"StreetNumber": "2848" +"StreetSuffix": "Drive" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Welcome to 2848 Bay Drive, a recently renovated gem nestled at the end of a serene dead end street in the highly desirable Lindemere section of South Merrick. This spectacular 2,800 sqft residence offers an inviting open floor plan with 10ft high ceilings designed for comfort and functionality, making it the perfect setting for both relaxation and entertaining. Boasting 5 well appointed bedrooms and 3.5 modern bathrooms, 2 of them in suite, equipped with radiant heat floors, this house is a haven of peace and luxury. The heart of this home is a beautiful living area that seamlessly flows into a newly remodeled two toned modern kitchen in 2022 equipped with stainless steel appliances, quartz countertops with a waterfall island, ample storage, making every meal a joy to prepare. New boiler installed in 2019, providing peace of mind and energy efficiency. The house is equipped with a WIFI controlled heating/cooling system. It comes with a 16 channel 4K interior/exterior 24/7 video/audio. Step outside to discover the deep water canal, offering direct access to breathtaking views and water activities right from your backyard. WiFi controlled sprinkler system makes it easy to care for your gorgeous landscaping that was newly designed in 2022. Tempered glass railing provides safety without obstructing the water views. Step outside your kitchen onto the trex deck covered by the master balcony above. The new roof, added in 2019, exemplifies the commitment to quality and durability in this remarkable home. Fema Flood Insurance is only $1953. Low taxes, only $18,640. You'll appreciate the convenience of being close to everything. In addition, this home qualifies for the bus to Lakeside Elementary, Middle and JFK High Schools. Merrick train station and bus stops are within easy reach, offering seamless commuting options. Don't miss the opportunity to own this waterfront sanctuary, where every day feels like a vacation. Schedule your visit today and start living the dream!" +"TaxAnnualAmount": "18640" +"TaxBlock": "194" +"TaxLot": "54" +"TaxMapNumber": "2089-62-194-00-0054-0" +"Township": "Hempstead" +"View": "Water" +"ViewYN": true +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:3 [ …3] +"WindowFeatures": array:1 [ …1] +"YearBuiltEffective": 2022 +"KEY_HighPriceDollars": "1549900" +"KEY_HotWater": "Gas Stand Alone" +"KEY_AttributionContact": "703-581-8605" +"KEY_SeparateHotwaterHeaterDetail": "sep" +"KEY_FloodZoneReportYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_OriginatingSystemOfficeKey": "150498000" +"KEY_DPRYN": "0" +"KEY_ModificationsExclusions": "None" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "HENN01" +"KEY_MinorChangeTimestamp": "2024-10-04T00:00:00-04:00" +"KEY_AtticDescription": "Unfinished" +"KEY_SquareFootage": "2805.00" +"KEY_SourceSystemModificationTimestamp": "2024-10-04T00:22:49-04:00" +"KEY_AlternateMlsNumber": "3543552" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY3543552')" +"provider_name": "One Key" +"Media": array:36 [ …36] +"ID": "22492" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4930 +post_id: "22600" +post_author: 1 +"ListingKey": "KEY3542398" +"ListingId": "L3542398" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-07-09T04:23:27Z" +"RFModificationTimestamp": "2024-07-09T04:28:06Z" +"ListPrice": 669999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.1 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Merrick" +"PostalCode": "11566" +"UnparsedAddress": "4 Farragut Road, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.637394 +"Longitude": -73.92986 +"YearBuilt": 1929 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Argelia M Gonzalez" +"ListOfficeName": "Realty Masters International" +"ListAgentMlsId": "131900" +"ListOfficeMlsId": "REX01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This enchanting Tudor home embodies timeless elegance and architectural grace. Boasting a blend of classic Tudor features this residence offers a unique and inviting atmosphere for comfortable living. This home features four bedrooms, Two Full bathrooms, Living Room, Large Dinning Room Eat In kitchen." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "0" +"CommonWalls": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-04-25T04:22:17.684519+00:00" +"CrossStreet": "Dobson Ave" +"Directions": "See Google Maps" +"ElementarySchool": "Birch School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2024-07-08" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentEmail": "melissa.renycity@gmail.com" +"ListAgentFirstName": "Argelia" +"ListAgentKey": "131900" +"ListAgentLastName": "Gonzalez" +"ListAgentPreferredPhone": "516-481-6005" +"ListOfficeKey": "50452004" +"ListOfficePhone": "516-481-6005" +"ListPriceLow": 669999 +"ListingContractDate": "2024-04-04" +"LotSizeAcres": 0.1 +"LotSizeDimensions": "45x100" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 4500 +"MLSAreaMinor": "5" +"MajorChangeTimestamp": "2024-07-09T04:10:32Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "U" +"OffMarketDate": "2024-07-08" +"OnMarketDate": "2024-04-08" +"OriginalEntryTimestamp": "2024-04-04T20:21:43Z" +"OriginalListPrice": 669999 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3542398" +"OriginatingSystemModificationTimestamp": "2024-07-09T04:10:32Z" +"OwnerName": "Cipolla" +"ParcelNumber": "2089-55-175-00-0139-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2024-04-24T15:19:23Z" +"PhotosCount": 1 +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-256-4600" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3542398" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Farragut" +"StreetNumber": "4" +"StreetSuffix": "Road" +"SubAgencyCompensation": "0" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "This enchanting Tudor home embodies timeless elegance and architectural grace. Boasting a blend of classic Tudor features this residence offers a unique and inviting atmosphere for comfortable living. This home features four bedrooms, Two Full bathrooms, Living Room, Large Dinning Room Eat In kitchen." +"TaxAnnualAmount": "12559.16" +"TaxBlock": "175" +"TaxLot": "139" +"TaxMapNumber": "2089-55-175-00-0139-0" +"Township": "Hempstead" +"WaterSource": array:1 [ …1] +"YearBuiltSource": "Owner" +"KEY_HighPriceDollars": "669999" +"KEY_HotWater": "Gas Stand Alone" +"KEY_AttributionContact": "516-481-6005" +"KEY_HoldEndDate": "2024-04-24" +"KEY_HoldStartDate": "2024-04-21" +"KEY_FloodZoneReportYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_BrokerAgencyCompensation": "02" +"KEY_OriginatingSystemOfficeKey": "50452004" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "None" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "REX01" +"KEY_MinorChangeTimestamp": "2024-07-09T00:00:00-04:00" +"KEY_AtticDescription": "None" +"KEY_SourceSystemModificationTimestamp": "2024-07-09T00:22:13-04:00" +"KEY_AlternateMlsNumber": "3542398" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY3542398')" +"provider_name": "OneKey" +"Media": array:1 [ …1] +"ID": "22600" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4931 +post_id: "22485" +post_author: 1 +"ListingKey": "KEY3542354" +"ListingId": "L3542354" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-09-25T04:23:25Z" +"RFModificationTimestamp": "2024-09-25T04:29:10Z" +"ListPrice": 1399000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0.22 +"LivingArea": 3000.0 +"BuildingAreaTotal": 0 +"City": "Merrick" +"PostalCode": "11566" +"UnparsedAddress": "2998 Joyce Lane, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6434061 +"Longitude": -73.546603 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Phoebe Altman" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "214977" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this stunning, fully expanded and renovated, all brick custom designed 6 bedroom home in the heart of desirable deep South Merrick. This sought after home is not in a flood zone and features a one of a kind, priceless, country club resort backyard. The in-ground, salt water heated pool and private landscaped shy-1/4 acre property are breathtaking. The open floor plan is designed with cathedral ceilings in the living room, formal dining room and a spacious center Island. The chefs kitchen is equipped with all high end stainless steel appliances, granite and cabinets. There are too many features to list from the elegant double door and entry hall to expanded primary suite and bathroom. The fully finished, entertainers lower level/family room has a designer fireplace, and 2 bedrooms/office/gym and full bathroom. The high-end finishes through out the home add an elegant touch while the wood floors and family room create a warm inviting home to entertain family and friends. The 2 car garage provides convenience and added storage space and there is plenty of room for extended living space and options. Close to the neighborhood parks and pool club and buses to schools. Don't miss the opportunity to make this exquisite home yours." +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttachedGarageYN": true +"Basement": array:2 [ …2] +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-04-04T21:13:43.573142+00:00" +"CrossStreet": "Shore" +"Directions": "Gps Shore to Joyce." +"DoorFeatures": array:2 [ …2] +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2024-09-24" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:3 [ …3] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentEmail": "phoebe.altman@elliman.com" +"ListAgentFirstName": "Phoebe" +"ListAgentKey": "214977" +"ListAgentLastName": "Altman" +"ListAgentPreferredPhone": "516-680-6466" +"ListOfficeKey": "5305028" +"ListOfficePhone": "516-623-4500" +"ListPriceLow": 1399000 +"ListingContractDate": "2024-04-04" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.22 +"LotSizeDimensions": "67x144" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 9610 +"MLSAreaMinor": "5" +"MajorChangeTimestamp": "2024-09-25T04:10:15Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlsStatus": "U" +"OffMarketDate": "2024-09-24" +"OnMarketDate": "2024-04-10" +"OriginalEntryTimestamp": "2024-04-04T18:47:39Z" +"OriginalListPrice": 1399000 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3542354" +"OriginatingSystemModificationTimestamp": "2024-09-25T04:10:15Z" +"OwnerName": "Reitano" +"ParcelNumber": "2089-62-210-00-0010-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-04-17T18:54:24Z" +"PhotosCount": 33 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-680-6466" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3542354" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Joyce" +"StreetNumber": "2998" +"StreetSuffix": "Lane" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Welcome to this stunning, fully expanded and renovated, all brick custom designed 6 bedroom home in the heart of desirable deep South Merrick. This sought after home is not in a flood zone and features a one of a kind, priceless, country club resort backyard. The in-ground, salt water heated pool and private landscaped shy-1/4 acre property are breathtaking. The open floor plan is designed with cathedral ceilings in the living room, formal dining room and a spacious center Island. The chefs kitchen is equipped with all high end stainless steel appliances, granite and cabinets. There are too many features to list from the elegant double door and entry hall to expanded primary suite and bathroom. The fully finished, entertainers lower level/family room has a designer fireplace, and 2 bedrooms/office/gym and full bathroom. The high-end finishes through out the home add an elegant touch while the wood floors and family room create a warm inviting home to entertain family and friends. The 2 car garage provides convenience and added storage space and there is plenty of room for extended living space and options. Close to the neighborhood parks and pool club and buses to schools. Don't miss the opportunity to make this exquisite home yours." +"TaxAnnualAmount": "19877.25" +"TaxBlock": "210" +"TaxLot": "10" +"TaxMapNumber": "2089-62-210-00-0010-0" +"Township": "Hempstead" +"VirtualTourURLBranded": "https://jumpvisualtours.com/462040" +"VirtualTourURLUnbranded": "https://jumpvisualtours.com/u/462040" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"KEY_HighPriceDollars": "1399000" +"KEY_SquareFootageSource": "Municipality" +"KEY_IncludedInTaxes": "Sewer,Trash,Water" +"KEY_HotWater": "Gas Stand Alone,On Demand" +"KEY_OfferPresentation": "Cannot be Present" +"KEY_AttributionContact": "516-623-4500" +"KEY_FloodZoneReportYN": "1" +"KEY_NumberOfKitchens": "1" +"KEY_OriginatingSystemOfficeKey": "5305028" +"KEY_DPRYN": "0" +"KEY_ModificationsExclusions": "None" +"KEY_FloodZoneDate": "2024-05-30" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "DERE01" +"KEY_MinorChangeTimestamp": "2024-09-25T00:00:00-04:00" +"KEY_AtticDescription": "Pull Stairs" +"KEY_SquareFootage": "3000.00" +"KEY_SourceSystemModificationTimestamp": "2024-09-25T00:22:51-04:00" +"KEY_AlternateMlsNumber": "3542354" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY3542354')" +"provider_name": "One Key" +"Media": array:33 [ …33] +"ID": "22485" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4932 +post_id: "22484" +post_author: 1 +"ListingKey": "KEY3541929" +"ListingId": "L3541929" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-08-04T04:24:23Z" +"RFModificationTimestamp": "2024-08-04T04:27:11Z" +"ListPrice": 950000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.28 +"LivingArea": 1658.0 +"BuildingAreaTotal": 0 +"City": "Merrick" +"PostalCode": "11566" +"UnparsedAddress": "978 Little Whaleneck Road, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6975047 +"Longitude": -73.5625639 +"YearBuilt": 1965 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Mohsan Hussain" +"ListOfficeName": "Best American Homes Inc" +"ListAgentMlsId": "138665" +"ListOfficeMlsId": "BEAM01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this charming hi-ranch home nestled in the heart of Merrick! Boasting 4 bedrooms, 1 full bathroom, and a convenient half bath, this spacious residence offers comfortable living for families of any size. Enjoy gatherings in the generous living and dining areas, complemented by an inviting eat-in kitchen perfect for culinary creations. With a lot size of 40x258, there's ample space for outdoor activities and potential expansions. Make cherished memories in this well-appointed home, offering 1658 square feet of versatile living space. Your dream home awaits!" +"ArchitecturalStyle": array:1 [ …1] +"AttachedGarageYN": true +"Basement": array:1 [ …1] +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "2" +"CommonWalls": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-04-03T15:24:26.709139+00:00" +"CrossStreet": "N. Jerusalem Rd" +"Directions": "N. Jerusalem to Little Whaleneck" +"ElementarySchool": "Harold D Fayette School" +"ElementarySchoolDistrict": "North Merrick" +"ExpirationDate": "2024-08-03" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "North Merrick" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentEmail": "nyc512@gmail.com" +"ListAgentFirstName": "Mohsan" +"ListAgentKey": "138665" +"ListAgentLastName": "Hussain" +"ListAgentPreferredPhone": "914-771-0523" +"ListOfficeKey": "138665000" +"ListOfficePhone": "516-792-6252" +"ListPriceLow": 950000 +"ListingContractDate": "2024-04-03" +"LotSizeAcres": 0.28 +"LotSizeDimensions": "40x245" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 12031 +"MLSAreaMinor": "5" +"MajorChangeTimestamp": "2024-08-04T04:10:18Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "North Merrick" +"MlsStatus": "U" +"OffMarketDate": "2024-08-03" +"OnMarketDate": "2024-04-03" +"OriginalEntryTimestamp": "2024-04-03T15:03:48Z" +"OriginalListPrice": 950000 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3541929" +"OriginatingSystemModificationTimestamp": "2024-08-04T04:10:18Z" +"OwnerName": "Shazar" +"ParcelNumber": "2089-50-347-00-0696-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2024-06-05T16:19:23Z" +"PhotosCount": 1 +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "914-771-0523" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3541929" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Little Whaleneck" +"StreetNumber": "978" +"StreetSuffix": "Road" +"SubAgencyCompensation": "0" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Welcome to this charming hi-ranch home nestled in the heart of Merrick! Boasting 4 bedrooms, 1 full bathroom, and a convenient half bath, this spacious residence offers comfortable living for families of any size. Enjoy gatherings in the generous living and dining areas, complemented by an inviting eat-in kitchen perfect for culinary creations. With a lot size of 40x258, there's ample space for outdoor activities and potential expansions. Make cherished memories in this well-appointed home, offering 1658 square feet of versatile living space. Your dream home awaits!" +"TaxAnnualAmount": "15887.99" +"TaxBlock": "347" +"TaxLot": "696" +"TaxMapNumber": "2089-50-347-00-0696-0" +"Township": "Hempstead" +"WaterSource": array:1 [ …1] +"KEY_HighPriceDollars": "950000" +"KEY_BuildingSize": "1658" +"KEY_HotWater": "Fuel Oil Stand Alone" +"KEY_OfferPresentation": "Cannot be Present" +"KEY_AttributionContact": "516-792-6252" +"KEY_SeparateHotwaterHeaterDetail": "Y" +"KEY_FloodZoneReportYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_BrokerAgencyCompensation": "2" +"KEY_OriginatingSystemOfficeKey": "138665000" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "None" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "BEAM01" +"KEY_MinorChangeTimestamp": "2024-08-04T00:00:00-04:00" +"KEY_AtticDescription": "Partial" +"KEY_NumberOfHeatingZones": "2" +"KEY_SquareFootage": "1658.00" +"KEY_SourceSystemModificationTimestamp": "2024-08-04T00:22:38-04:00" +"KEY_AlternateMlsNumber": "3541929" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY3541929')" +"provider_name": "OneKey" +"Media": array:1 [ …1] +"ID": "22484" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4933 …117} 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4934 …148} 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4935 …123} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4936 …105} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4937 …133} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4938 …103} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4939 …122} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4940 …136} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4941 …118} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4943 …111} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4912 …155} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4911 …98} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4910 …145} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4909 …135} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4908 …168} ] +success: true +page_size: 32 +page_count: 5 +count: 141 +after_key: "" } "RF Response Time" => "0.15 seconds" ] ]
