Begin your property search in Hewlett, NY with verified real estate listings tailored for buyers seeking specific features. Each listing includes detailed specifications, high-resolution photos, price history, and listing status. Browse homes based on size, amenities, or location. This Hewlett real estate section provides consistent updates and allows you to explore available properties with clarity. Whether your focus is research or shortlisting options, everything you need to compare homes is available here.
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 Hewlett NY street by street — not just by ZIP code. From districts to commute routes, we help you buy smarter based on real neighborhood insight.
You won’t find any sales pressure here. We focus on what works best for you, offering honest input so you can make confident, informed choices.
You won’t be left waiting on answers. We stay connected through every step of the process, so your questions get real replies — not delays.
We tap into local networks to get early access to listings — giving you a head start in a competitive market.
From inspections to paperwork, we manage the chaos so you can focus on the fun part — finding a place you’ll love.
Tight schedule? Need to tour after hours or on weekends? We’re flexible. We work how and when it’s convenient for you.
It’s not just about buying now — we’ll help you choose a home that fits future needs too, like family growth or property value trends.
We’re not here to just close a deal. We look out for your best interest like we would for our own family. Every decision is made with care.
Read what our clients have to say about their experience with us
I highly recommend Kaya Homes if you are looking to buy or sell your home. My home was sold for over ask within 1 week! The process was so simple and easy. Avi had a professional photographer photograph our home and has excellent marketing strategies which led to a speedy transaction. Thank you !!!
Bad Services.
KAYA Homes, and specifically Kamy, is a real estate business with a heart. Before I signed a contract Kamy gave me months of her time, business acumen and understanding. I have bought/sold my homes over many decades. Never have I known a realtor to be so incredibly kind. Everything about how KAYA Homes conduct their business is above reproach.
I had the absolute pleasure of working with Kamy when leasing my new apartment, and I couldn't be happier with the experience! She was fantastic to work with, simplifying the rental process and providing thorough explanations every step of the way. Highly recommend!
This is the third year im using Kaya Homes for my rental, they are very professional. They walk you through everything from start to finish. The owner Kami is awesome!! She is very responsive A+ I highly recommend kaya homes!!
We started our journey with Kaya homes a while back when my husband met Kamy. He knew instantly that we found the right ones to help us with purchasing a new home. Kamy is highly responsive, thoughtful, considerate and very professional on her approach with finding you the right home. We wanted to stay in the area and with such a crazy market, I didn't think it would be possible for us to find our home, but we did. Kamy's reassured us and said we will find your home and we did. Thank you Kamy and also meeting Izzy was a bonus, great family owned business, truly you will not be disappointed. If you are looking to rent, own or sell give them a call.
Absolutely wonderful to work with! I highly suggest if you are looking or selling she is definitely your go to!
Amazing experience with Kaya Homes. She was very helpful and found us our dream home as fast as anyone could wish for!
WOW! Kamy went above and beyond to find us an apartment, my lease was over and I needed to move ASAP and couldn’t find any rentals but when I got in contact with Kamy at Kaya Homes she casted all my worries and stress away. I’ve worked with other realtors in the past which was ok but Kaya Homes over exceeded all of my expectations. Kamy was able to find us a beautiful contemporary apartment in the neighborhood that I appointed and that fit right in our price range within a month we moved in. Kamy is extremely kind, friendly, transparent professional, communicative and easy to reach to answer any of our questions at all times. In addition, since we’ve moved the landlord continues to maintain the apartment beautifully: they provide a cleaning service who comes in to clean inside and outside the complex, landscaper comes weekly, the garbage is pick up 2-3x a week, if there’s ever any issue or something needs fixing they send someone the next day which is a plus because you know they CARE AND APPRECIATE THEIR TENANTS. I recommend Kaya Homes to all my friends & family and to anyone who needs a realtor because they are simply the VERY BEST IN THE BUSINESS. Thank you again Kamy.
I had the pleasure of working on my home selling with Kaya homes and specialty with Kamy Roditi who is a very professional and reliable person. Kamy worked very on my transaction with a fair and quick way and honestly without her my home would not have been sold as fast and for the best possible price as it was. I would highly recomand Kaya homes and Kamy for any Real Estate and business venture, selling and buying Real Estate .
If you are in the market for a new home, I highly recommend going to see Kamy Roditi @ Kaya Homes. She is one of the most knowledgeable realtors I've ever met in the industry hands down. She's honest, trustworthy, responsive and an all around pleasure to work with. She worked diligently to help find the perfect house for my family and smoothly guided me through the process by answering all of my questions thoroughly. Buying a new home can be stressful, but it doesn't have to be if your lucky enough to work with Kamy Roditi. You'll be in good hands, I promise!
I thought about selling my house myself and I’m so glad I didn’t. Kaya Homes was a total blessing for me, the buyers of my home were beyond difficult and they handled every step for me beyond my expectations. They took the stress off of me entirely. I’d highly recommend them to anyone. Thank you again Kaya Homes!!
Highly recommend the team at Kaya Homes. The team is not only knowledgeable but also provides great advice for all real estate needs. Weather your looking to buy, sell, rent or get advice, Kaya homes should be your first call.
array:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=32&$skip=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','Lawrence')) and ListPrice le 5000000) and (contains(UnparsedAddress, 'Hewlett'))&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5299 +items: array:19 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5283 +post_id: "29069" +post_author: 1 +"ListingKey": "KEY3529318" +"ListingId": "L3529318" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-08-03T04:24:23Z" +"RFModificationTimestamp": "2024-08-03T04:30:48Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.09 +"LivingArea": 1179.0 +"BuildingAreaTotal": 0 +"City": "Hewlett" +"PostalCode": "11557" +"UnparsedAddress": "391 Hewlett Parkway, Hewlett, NY 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6431591 +"Longitude": -73.6956865 +"YearBuilt": 1923 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Todd A Yovino" +"ListOfficeName": "Island Advantage Realty LLC" +"ListAgentMlsId": "48648" +"ListOfficeMlsId": "YOVI01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Move right in to this renovated Colonial style home w/ 3 bedrooms, full bath w/ new kitchen and baths. Refurbished wood floors, fresh paint, etc. Centrally located to all. Don't miss this opportunity!" +"ArchitecturalStyle": array:1 [ …1] +"AttachedGarageYN": true +"Basement": array:2 [ …2] +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "2" +"CommonWalls": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-02-02T21:31:24.544947+00:00" +"CrossStreet": "Webster St" +"Directions": "Peninsula Blvd to Mill Rd, right onto Webster St, right onto Hewlett Pkwy" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"Exclusions": "Video Cameras" +"ExpirationDate": "2024-08-02" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InteriorFeatures": array:1 [ …1] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseConsideredYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentEmail": "todd@iarny.com" +"ListAgentFirstName": "Todd" +"ListAgentKey": "48648" +"ListAgentLastName": "Yovino" +"ListAgentPreferredPhone": "631-351-6000" +"ListOfficeKey": "48648000" +"ListOfficePhone": "631-351-6000" +"ListPriceLow": 699900 +"ListingContractDate": "2024-02-02" +"LotSizeAcres": 0.09 +"LotSizeDimensions": "40x102" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 3920 +"MLSAreaMinor": "6" +"MajorChangeTimestamp": "2024-08-03T04:10:36Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "U" +"OffMarketDate": "2024-08-02" +"OnMarketDate": "2024-02-02" +"OriginalEntryTimestamp": "2024-02-02T21:15:55Z" +"OriginalListPrice": 799000 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3529318" +"OriginatingSystemModificationTimestamp": "2024-08-03T04:10:36Z" +"OwnerName": "Schochet" +"ParcelNumber": "2089-39-569-00-1003-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-02-02T21:27:25Z" +"PhotosCount": 24 +"PreviousListPrice": 729900 +"PriceChangeTimestamp": "2024-07-01T13:38:29Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "800-746-9464" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3529318" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Hewlett" +"StreetNumber": "391" +"StreetSuffix": "Parkway" +"SubAgencyCompensation": "0" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Move right in to this renovated Colonial style home w/ 3 bedrooms, full bath w/ new kitchen and baths. Refurbished wood floors, fresh paint, etc. Centrally located to all. Don't miss this opportunity!" +"TaxAnnualAmount": "13994.26" +"TaxBlock": "569" +"TaxLot": "1003" +"TaxMapNumber": "2089-39-569-00-1003-0" +"Township": "Hempstead" +"WaterSource": array:1 [ …1] +"KEY_HighPriceDollars": "699900" +"KEY_SquareFootageSource": "Other" +"KEY_HotWater": "Electric Stand Alone" +"KEY_OfferPresentation": "Cannot be Present" +"KEY_AttributionContact": "631-351-6000" +"KEY_FloodZoneReportYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_BrokerAgencyCompensation": "2" +"KEY_OriginatingSystemOfficeKey": "48648000" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "M3 IAW,M4 Commission Modification" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "YOVI01" +"KEY_MinorChangeTimestamp": "2024-08-03T00:00:00-04:00" +"KEY_AtticDescription": "Pull Stairs" +"KEY_SquareFootage": "1179.00" +"KEY_SourceSystemModificationTimestamp": "2024-08-03T00:23:01-04:00" +"KEY_AlternateMlsNumber": "3529318" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY3529318')" +"provider_name": "OneKey" +"Media": array:24 [ …24] +"DaysOnMarket": null +"ID": "29069" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5285 +post_id: "28961" +post_author: 1 +"ListingKey": "KEY3527280" +"ListingId": "L3527280" +"PropertyType": "Commercial Lease" +"PropertySubType": "Mixed Use" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-05-01T04:22:28Z" +"RFModificationTimestamp": "2024-05-01T05:13:38Z" +"ListPrice": 700.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.15 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hewlett" +"PostalCode": "11557" +"UnparsedAddress": "1226 West Broadway # 7A, Hewlett, NY 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6431591 +"Longitude": -73.6956865 +"YearBuilt": 1928 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jay Goldman" +"ListOfficeName": "Julia Stevens Realty" +"ListAgentMlsId": "87831" +"ListOfficeMlsId": "JLST01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Great space for any type of office. close to shops, parkways and the LIRR. Low rent includes all of the utilities." +"BuildingAreaUnits": "Square Feet" +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-01-24T00:05:12.638497+00:00" +"CrossStreet": "Hamilton" +"CurrentUse": array:1 [ …1] +"Directions": "Mill Road South To The End. Make A Right To The Hewlett Professional Center One Block Down On The Right" +"ExpirationDate": "2024-04-30" +"Heating": array:2 [ …2] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentEmail": "Jay@Juliastevensrealty.com" +"ListAgentFirstName": "Jay" +"ListAgentKey": "87831" +"ListAgentLastName": "Goldman" +"ListAgentPreferredPhone": "516-295-1454" +"ListOfficeKey": "87830000" +"ListOfficePhone": "516-295-1454" +"ListPriceLow": 700 +"ListingContractDate": "2024-01-23" +"LotSizeAcres": 0.15 +"LotSizeDimensions": "66X100" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 6700 +"MLSAreaMinor": "6" +"MajorChangeTimestamp": "2024-05-01T04:11:05Z" +"MajorChangeType": "Expired" +"MlsStatus": "U" +"OffMarketDate": "2024-04-30" +"OnMarketDate": "2024-01-23" +"OriginalEntryTimestamp": "2024-01-23T23:53:01Z" +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3527280" +"OriginatingSystemModificationTimestamp": "2024-05-01T04:11:05Z" +"OwnerName": "1226 West Broadway LLC" +"ParcelNumber": "2089-39-569-00-3441-0" +"PhotosChangeTimestamp": "2024-01-27T18:41:25Z" +"PhotosCount": 6 +"ShowingContactPhone": "516-295-1454" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3527280" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "West Broadway" +"StreetNumber": "1226" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Great space for any type of office. close to shops, parkways and the LIRR. Low rent includes all of the utilities." +"TaxBlock": "569" +"TaxLot": "3441" +"Township": "Hempstead" +"UnitNumber": "7A" +"ZoningDescription": "office" +"KEY_HighPriceDollars": "700" +"KEY_BuildingSize": "0" +"KEY_OverheadDoor": "0" +"KEY_AttributionContact": "516-295-1454" +"KEY_FloodZoneReportYN": "0" +"KEY_OccupancyDate": "2024-02-01" +"KEY_OriginatingSystemOfficeKey": "87830000" +"KEY_DPRYN": "0" +"KEY_CompensationOfferedOnLease": "50%" +"KEY_DisplayOnVOWYN": "1" +"KEY_OverheadDoorHeight": "0" +"KEY_ListMainOfficeMlsId": "JLST01" +"KEY_MinorChangeTimestamp": "2024-05-01T00:00:00-04:00" +"KEY_SourceSystemModificationTimestamp": "2024-05-01T00:21:48-04:00" +"KEY_AlternateMlsNumber": "3527280" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY3527280')" +"provider_name": "OneKey" +"Media": array:6 [ …6] +"DaysOnMarket": null +"ID": "28961" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5282 +post_id: "29045" +post_author: 1 +"ListingKey": "KEY3518846" +"ListingId": "L3518846" +"PropertyType": "Residential" +"PropertySubType": "Stock Cooperative" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-05-01T04:22:31Z" +"RFModificationTimestamp": "2024-05-01T05:13:32Z" +"ListPrice": 425000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1900.0 +"BuildingAreaTotal": 0 +"City": "Hewlett" +"PostalCode": "11557" +"UnparsedAddress": "1390 Broadway # 128, Hewlett, NY 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6431591 +"Longitude": -73.6956865 +"YearBuilt": 1963 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rachel Stackow" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "198428" +"ListOfficeMlsId": "DERE03" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Sought-After, Upscale Co-Op in Hewlett. Features full service 24/7 doorman, valet parking, updated in-ground pool, card room with kitchenette and more! This unit boasts sunny, spacious rooms with plenty of storage. Primary with en-suite and walk-in closet. Washer/Dryer in the Unit! The Monthly Maintenance Includes Taxes, Heat, Water, and Building Maintenance. Convenient location close to transportation, shopping, and more." +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Door Person" +"AssociationFee2": "2235.39" +"AssociationFee2Frequency": "Monthly" +"AssociationFeeIncludes": array:9 [ …9] +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuilderModel": "2 bedroom/2 bath" +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "2" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2023-12-06T15:44:25.130256+00:00" +"CrossStreet": "East Rockaway Rd" +"Directions": "Broadway in Hewlett between Erick and Everit." +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"EntryLevel": 1 +"ExpirationDate": "2024-04-30" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"Inclusions": "Curtains/Drapes,Dishwasher,Door Hardware,Dryer,Freezer,Refrigerator,Washer" +"InteriorFeatures": array:5 [ …5] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentEmail": "rachel.stackow@elliman.com" +"ListAgentFirstName": "Rachel" +"ListAgentKey": "198428" +"ListAgentLastName": "Stackow" +"ListAgentPreferredPhone": "631-896-8402" +"ListOfficeKey": "5305003" +"ListOfficePhone": "516-921-2262" +"ListPriceLow": 425000 +"ListingContractDate": "2023-11-30" +"LotFeatures": array:1 [ …1] +"MLSAreaMinor": "6" +"MajorChangeTimestamp": "2024-05-01T04:10:43Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "U" +"OffMarketDate": "2024-04-30" +"OnMarketDate": "2023-12-06" +"OpenParkingYN": true +"OriginalEntryTimestamp": "2023-11-30T15:32:37Z" +"OriginalListPrice": 445000 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3518846" +"OriginatingSystemModificationTimestamp": "2024-05-01T04:10:43Z" +"OwnerName": "Shapiro" +"Ownership": "Co-Op" +"ParkingFeatures": array:3 [ …3] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2023-12-07T01:13:24Z" +"PhotosCount": 19 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PreviousListPrice": 445000 +"PriceChangeTimestamp": "2024-01-29T14:24:40Z" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-896-8402" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3518846" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StoriesTotal": "2" +"StreetName": "Broadway" +"StreetNumber": "1390" +"SubAgencyCompensation": "*" +"SubdivisionName": "Hewlett Townhouse" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Sought-After, Upscale Co-Op in Hewlett. Features full service 24/7 doorman, valet parking, updated in-ground pool, card room with kitchenette and more! This unit boasts sunny, spacious rooms with plenty of storage. Primary with en-suite and walk-in closet. Washer/Dryer in the Unit! The Monthly Maintenance Includes Taxes, Heat, Water, and Building Maintenance. Convenient location close to transportation, shopping, and more." +"Township": "Hempstead" +"UnitNumber": "128" +"WaterSource": array:1 [ …1] +"KEY_HighPriceDollars": "425000" +"KEY_HotWater": "Gas Stand Alone" +"KEY_OfferPresentation": "Can be Present" +"KEY_ManagementPhone": "631-293-2997" +"KEY_FloodZoneReportYN": "0" +"KEY_MinimumPctDownPayment": "10" +"KEY_BrokerAgencyCompensation": "2" +"KEY_OriginatingSystemOfficeKey": "5305003" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "M3 IAW" +"KEY_ParkingAssignedSpaces": "1" +"KEY_MinorChangeTimestamp": "2024-05-01T00:00:00-04:00" +"KEY_SourceSystemModificationTimestamp": "2024-05-01T00:21:46-04:00" +"KEY_AlternateMlsNumber": "3518846" +"KEY_ApprovalRequiredYN": "1" +"KEY_DevelopmentName": "Hewlett Townhouse" +"KEY_HeatingNotes": "inc" +"KEY_SquareFootageSource": "Other" +"KEY_AttributionContact": "516-921-2262" +"KEY_LocationDescription": "Second Floor" +"KEY_GarbageRemoval": "Public" +"KEY_RentingAllowedYN": "0" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "DERE01" +"KEY_AtticDescription": "None" +"KEY_SquareFootage": "1900.00" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY3518846')" +"provider_name": "OneKey" +"Media": array:19 [ …19] +"DaysOnMarket": null +"ID": "29045" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5286 +post_id: "29041" +post_author: 1 +"ListingKey": "KEY3518810" +"ListingId": "L3518810" +"PropertyType": "Commercial Sale" +"PropertySubType": "Mixed Use" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-05-23T04:25:24Z" +"RFModificationTimestamp": "2024-05-23T04:31:49Z" +"ListPrice": 850000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.09 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hewlett" +"PostalCode": "11557" +"UnparsedAddress": "1265 Station Plaza, Hewlett, NY 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6431591 +"Longitude": -73.6956865 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Livia Unger-Bentolila" +"ListOfficeName": "Five Towns Miller Realty Inc" +"ListAgentMlsId": "223904" +"ListOfficeMlsId": "DOMI01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Office converted from a residence. 1st floor and basement finished. each level is 861sf, totaling 1,722sf. Lot is 40X92irr= 3,720sf." +"BuildingAreaUnits": "Square Feet" +"CoListAgentEmail": "raizie@ftmr.com" +"CoListAgentFullName": "Rhonda Schwerd" +"CoListAgentKey": "194048" +"CoListAgentMlsId": "194048" +"CoListAgentPreferredPhone": "917-903-1778" +"CoListOfficeKey": "125476000" +"CoListOfficeMlsId": "DOMI01" +"CoListOfficeName": "Five Towns Miller Realty Inc" +"CoListOfficePhone": "516-374-4100" +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2023-11-30T02:56:16.765884+00:00" +"CrossStreet": "West Broadway" +"CurrentUse": array:1 [ …1] +"Directions": "West Broadway to Station Plaza (next door to Hollywood Health Club)" +"ExpirationDate": "2024-05-22" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentEmail": "leah@ftmr.com" +"ListAgentFirstName": "Livia" +"ListAgentKey": "223904" +"ListAgentLastName": "Unger-Bentolila" +"ListAgentPreferredPhone": "516-306-8265" +"ListOfficeKey": "125476000" +"ListOfficePhone": "516-374-4100" +"ListPriceLow": 850000 +"ListingContractDate": "2023-11-29" +"LotSizeAcres": 0.09 +"LotSizeDimensions": "40x92" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 3720 +"MLSAreaMinor": "6" +"MajorChangeTimestamp": "2024-05-23T04:10:20Z" +"MajorChangeType": "Expired" +"MlsStatus": "U" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2024-05-22" +"OnMarketDate": "2023-11-29" +"OriginalEntryTimestamp": "2023-11-29T05:00:00Z" +"OriginalListPrice": 1075000 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3518810" +"OriginatingSystemModificationTimestamp": "2024-05-23T04:10:20Z" +"OwnerName": "Gitlin Realty Co Llc" +"ParcelNumber": "2089-39-207-00-0024-0" +"PhotosChangeTimestamp": "2023-12-05T23:18:24Z" +"PhotosCount": 10 +"PreviousListPrice": 925000 +"PriceChangeTimestamp": "2024-02-08T17:23:39Z" +"Sewer": array:1 [ …1] +"SourceSystemID": "M00000489" +"SourceSystemKey": "3518810" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StoriesTotal": "1" +"StreetName": "Hewlett" +"StreetNumber": "1265" +"StreetSuffix": "Plaza" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Office converted from a residence. 1st floor and basement finished. each level is 861sf, totaling 1,722sf. Lot is 40X92irr= 3,720sf." +"TaxAnnualAmount": "17338" +"TaxBlock": "207" +"TaxLot": "24" +"Township": "Hempstead" +"ZoningDescription": "483" +"KEY_HighPriceDollars": "850000" +"KEY_OverheadDoor": "0" +"KEY_AttributionContact": "516-374-4100" +"KEY_CoListMainOfficeMlsId": "DOMI01" +"KEY_FloodZoneReportYN": "0" +"KEY_OriginatingSystemOfficeKey": "125476000" +"KEY_DPRYN": "0" +"KEY_ModificationsExclusions": "None" +"KEY_DisplayOnVOWYN": "1" +"KEY_OverheadDoorHeight": "0" +"KEY_ListMainOfficeMlsId": "DOMI01" +"KEY_MinorChangeTimestamp": "2024-05-23T00:00:00-04:00" +"KEY_SourceSystemModificationTimestamp": "2024-05-23T00:23:43-04:00" +"KEY_RoadFrontageLength": "40x92irr" +"KEY_AlternateMlsNumber": "3518810" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY3518810')" +"provider_name": "OneKey" +"Media": array:10 [ …10] +"DaysOnMarket": null +"ID": "29041" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5284 +post_id: "29195" +post_author: 1 +"ListingKey": "KEY3513571" +"ListingId": "L3513571" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-04-01T04:29:28Z" +"RFModificationTimestamp": "2024-04-01T04:55:49Z" +"ListPrice": 1290000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.09 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hewlett" +"PostalCode": "11557" +"UnparsedAddress": "357 Hamilton Avenue, Hewlett, NY 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6431591 +"Longitude": -73.6956865 +"YearBuilt": 1921 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Efrat Azour" +"ListOfficeName": "Real Broker NY LLC" +"ListAgentMlsId": "211111" +"ListOfficeMlsId": "HOWO01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Step into this luxury custom-built 4-bedroom, 2.5-bathroom home in the Heart Of Hewlett! Spread across three levels and over 3300 square feet, this home is a showcase of attention to detail and opulent living. As you enter, you are greeted by an open-concept spacious living area, perfect for entertaining and family gatherings. The custom kitchen offers a contemporary design, with stunning Cambria quartz countertops, large waterfall island, two sinks, and top-of-the-line appliances, providing a sleek and modern look and an ideal setup for any home chef. Filled with natural light, high ceilings, and beautiful hardwood floors, creating a warm and inviting atmosphere. Brand new powder room on the 1st floor was added for your convenience. The custom-designed stairs with sleek railings will guide you to the second floor, where your master retreat awaits. The expansive master bedroom features a spacious walk-in closet, creating a haven of organization and ease. Immerse yourself in luxury as you step into the ensuite bath, featuring a spa tub and a soothing steam shower. Discover three additional bedrooms, each offering its own unique charm, and a second bathroom, completing this floor. Descend to the lower level, and the impressive features of this home unfold in a beautifully finished basement. Whether you envision a dedicated home office, a recreational retreat, or a comfortable guest quarter, this space is the perfect playroom for your imagination. This home was completely renovated from top to bottom! Additional features include driveway for 2 cars, New Roof, New Windows, New Insulation, New Doors, Central AC, EVERYTHING BRAND NEW!!! This home is conveniently located in a desirable neighborhood and zoned for School District #14, walking distance to everything you may need including gym, shopping, and dining. CLOSE TO ALL! Don't miss out on the opportunity to make this stunning house your new home!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "1.5" +"CancellationDate": "2023-12-18" +"CommonWalls": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CoolingYN": true +"CountyOrParish": "Nassau" +"CreationDate": "2024-02-15T23:49:17.702911+00:00" +"CrossStreet": "West Broadway" +"Directions": "GOOGLE" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"ExpirationDate": "2024-03-31" +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentEmail": "bibi4608@gmail.com" +"ListAgentFirstName": "Efrat" +"ListAgentKey": "211111" +"ListAgentLastName": "Azour" +"ListAgentPreferredPhone": "516-428-6945" +"ListOfficeKey": "86649000" +"ListOfficePhone": "518-730-4228" +"ListPriceLow": 1290000 +"ListingContractDate": "2023-10-30" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.09 +"LotSizeDimensions": "40x100" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 4000 +"MLSAreaMinor": "6" +"MajorChangeTimestamp": "2024-04-01T04:13:39Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "U" +"OffMarketDate": "2023-12-18" +"OnMarketDate": "2023-10-30" +"OriginalEntryTimestamp": "2023-10-30T18:02:00Z" +"OriginalListPrice": 1350000 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3513571" +"OriginatingSystemModificationTimestamp": "2024-04-01T04:13:39Z" +"OwnerName": "357 Hamilton Avenue Equities LLC" +"ParcelNumber": "2089-39-101-00-0035-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2023-12-07T15:10:26Z" +"PhotosCount": 32 +"PreviousListPrice": 1320000 +"PriceChangeTimestamp": "2024-02-25T22:50:20Z" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-428-6945" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3513571" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Hamilton" +"StreetNumber": "357" +"StreetSuffix": "Avenue" +"SubAgencyCompensation": "*" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Step into this luxury custom-built 4-bedroom, 2.5-bathroom home in the Heart Of Hewlett! Spread across three levels and over 3300 square feet, this home is a showcase of attention to detail and opulent living. As you enter, you are greeted by an open-concept spacious living area, perfect for entertaining and family gatherings. The custom kitchen offers a contemporary design, with stunning Cambria quartz countertops, large waterfall island, two sinks, and top-of-the-line appliances, providing a sleek and modern look and an ideal setup for any home chef. Filled with natural light, high ceilings, and beautiful hardwood floors, creating a warm and inviting atmosphere. Brand new powder room on the 1st floor was added for your convenience. The custom-designed stairs with sleek railings will guide you to the second floor, where your master retreat awaits. The expansive master bedroom features a spacious walk-in closet, creating a haven of organization and ease. Immerse yourself in luxury as you step into the ensuite bath, featuring a spa tub and a soothing steam shower. Discover three additional bedrooms, each offering its own unique charm, and a second bathroom, completing this floor. Descend to the lower level, and the impressive features of this home unfold in a beautifully finished basement. Whether you envision a dedicated home office, a recreational retreat, or a comfortable guest quarter, this space is the perfect playroom for your imagination. This home was completely renovated from top to bottom! Additional features include driveway for 2 cars, New Roof, New Windows, New Insulation, New Doors, Central AC, EVERYTHING BRAND NEW!!! This home is conveniently located in a desirable neighborhood and zoned for School District #14, walking distance to everything you may need including gym, shopping, and dining. CLOSE TO ALL! Don't miss out on the opportunity to make this stunning house your new home!" +"TaxAnnualAmount": "14809" +"TaxBlock": "101" +"TaxLot": "35" +"TaxMapNumber": "2089-39-101-00-0035-0" +"Township": "Hempstead" +"WaterSource": array:1 [ …1] +"KEY_HighPriceDollars": "1290000" +"KEY_OfferPresentation": "Can be Present" +"KEY_AttributionContact": "518-730-4228" +"KEY_HoldStartDate": "2024-01-28" +"KEY_FloodZoneReportYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_BrokerAgencyCompensation": "1.5" +"KEY_OriginatingSystemOfficeKey": "86649000" +"KEY_DPRYN": "0" +"KEY_MlsDistrictCode": "14" +"KEY_ModificationsExclusions": "None" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "HOWO01" +"KEY_MinorChangeTimestamp": "2024-04-01T00:00:00-04:00" +"KEY_AtticDescription": "None" +"KEY_SourceSystemModificationTimestamp": "2024-04-01T00:28:08-04:00" +"KEY_AlternateMlsNumber": "3513571" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY3513571')" +"provider_name": "OneKey" +"Media": array:32 [ …32] +"DaysOnMarket": null +"ID": "29195" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5281 +post_id: "29030" +post_author: 1 +"ListingKey": "KEY3512340" +"ListingId": "L3512340" +"PropertyType": "Business Opportunity" +"PropertySubType": "Retail" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-04-23T04:23:24Z" +"RFModificationTimestamp": "2024-04-23T04:40:09Z" +"ListPrice": 300000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hewlett" +"PostalCode": "11557" +"UnparsedAddress": "1196 Broadway, Hewlett, NY 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6431591 +"Longitude": -73.6956865 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Vincent Ponte" +"ListOfficeName": "RustyCap O Inc" +"ListAgentMlsId": "210890" +"ListOfficeMlsId": "NEG01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Busy Cafe for Sale. Plenty of table and bar seating. All equipment included in sale. Business has been running 10 plus years with one owner change most recently open for 4 years. Owner willing to help buyer get situated in business if needed. 4.9 rating on google. 4.6 rating on Yelp. THIS IS A SALE OF THE BUSINESS NOT BUILDING." +"BuildingAreaUnits": "Square Feet" +"BusinessName": "Across Broadway Cafe" +"BusinessType": "Restaurant" +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2023-10-23T23:20:06.274150+00:00" +"CrossStreet": "Franklin Avenue" +"CurrentUse": array:1 [ …1] +"ExpirationDate": "2024-04-22" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseExpiration": "2024-11-30" +"ListAOR": "LIBOR" +"ListAgentEmail": "vinponte@gmail.com" +"ListAgentFirstName": "Vincent" +"ListAgentKey": "210890" +"ListAgentLastName": "Ponte" +"ListAgentPreferredPhone": "631-649-5662" +"ListOfficeKey": "104242000" +"ListOfficePhone": "516-222-7888" +"ListPriceLow": 300000 +"ListingContractDate": "2023-10-23" +"MLSAreaMinor": "6" +"MajorChangeTimestamp": "2024-04-23T04:10:19Z" +"MajorChangeType": "Expired" +"MlsStatus": "U" +"NetOperatingIncome": 270000 +"OffMarketDate": "2024-04-22" +"OnMarketDate": "2023-10-23" +"OriginalEntryTimestamp": "2023-10-23T22:56:28Z" +"OriginalListPrice": 300000 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3512340" +"OriginatingSystemModificationTimestamp": "2024-04-23T04:10:19Z" +"OwnerName": "Torres" +"PhotosChangeTimestamp": "2024-04-17T02:02:46Z" +"PhotosCount": 3 +"SeatingCapacity": "54" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3512340" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Broadway" +"StreetNumber": "1196" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Busy Cafe for Sale. Plenty of table and bar seating. All equipment included in sale. Business has been running 10 plus years with one owner change most recently open for 4 years. Owner willing to help buyer get situated in business if needed. 4.9 rating on google. 4.6 rating on Yelp. THIS IS A SALE OF THE BUSINESS NOT BUILDING." +"Township": "Hempstead" +"KEY_HighPriceDollars": "300000" +"KEY_AttributionContact": "516-222-7888" +"KEY_BusinessAge": "4" +"KEY_FloodZoneReportYN": "0" +"KEY_PotentialRentalIncomeYN": "0" +"KEY_OriginatingSystemOfficeKey": "104242000" +"KEY_DPRYN": "0" +"KEY_CompensationOfferedOnBusiness": "2" +"KEY_DisplayOnVOWYN": "1" +"KEY_BusinessLocatedAt": "1196 Broadway hewlett, NY" +"KEY_ListMainOfficeMlsId": "NEG01" +"KEY_MinorChangeTimestamp": "2024-04-23T00:00:00-04:00" +"KEY_SquareFootage": "3200.00" +"KEY_SourceSystemModificationTimestamp": "2024-04-23T00:22:35-04:00" +"KEY_AlternateMlsNumber": "3512340" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY3512340')" +"provider_name": "OneKey" +"Media": array:3 [ …3] +"DaysOnMarket": null +"ID": "29030" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5280 +post_id: "29132" +post_author: 1 +"ListingKey": "KEY3496635" +"ListingId": "L3496635" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-08-09T04:21:26Z" +"RFModificationTimestamp": "2024-08-09T04:24:03Z" +"ListPrice": 600000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.09 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hewlett" +"PostalCode": "11557" +"UnparsedAddress": "365 Mill Road, Hewlett, NY 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6431591 +"Longitude": -73.6956865 +"YearBuilt": 1924 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Matthew Corriston" +"ListOfficeName": "World Prop Intl Sea to Sky" +"ListAgentMlsId": "220123" +"ListOfficeMlsId": "WOPR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Must See !! Recently Renovated 4 Bedroom with 2 Full Baths !! Amazing School district and Close to All transportation and shopping. Detached 1 Car garage , Eat In Kitchen and hardwood Flooring !! Make this home yours. Room For Pool and Great yard for entertaining !!" +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"CoListAgentEmail": "matthew@wpinewyork.com" +"CoListAgentFullName": "Matthew Hart" +"CoListAgentKey": "112688" +"CoListAgentMlsId": "112688" +"CoListAgentPreferredPhone": "631-961-4626" +"CoListOfficeKey": "112688000" +"CoListOfficeMlsId": "WOPR01" +"CoListOfficeName": "World Prop Intl Sea to Sky" +"CoListOfficePhone": "631-961-4626" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2023-08-08T20:56:21.491989+00:00" +"CrossStreet": "Wheatley" +"DirectionFaces": "Northeast" +"Directions": "Peninsula To Mill Rd" +"ElementarySchool": "Franklin Early Childhood Center" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"ExpirationDate": "2024-08-08" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"Inclusions": "Dryer,Refrigerator,Washer" +"InteriorFeatures": array:1 [ …1] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentEmail": "mattcorriston@gmail.com" +"ListAgentFirstName": "Matthew" +"ListAgentKey": "220123" +"ListAgentLastName": "Corriston" +"ListAgentPreferredPhone": "631-961-4626" +"ListOfficeKey": "112688000" +"ListOfficePhone": "631-961-4626" +"ListPriceLow": 600000 +"ListingContractDate": "2023-08-08" +"LotFeatures": array:2 [ …2] +"LotSizeAcres": 0.09 +"LotSizeDimensions": "40X100" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 4000 +"MLSAreaMinor": "6" +"MajorChangeTimestamp": "2024-08-09T04:10:33Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "U" +"OffMarketDate": "2024-08-08" +"OnMarketDate": "2023-08-08" +"OriginalEntryTimestamp": "2023-08-08T20:25:29Z" +"OriginalListPrice": 648888 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3496635" +"OriginatingSystemModificationTimestamp": "2024-08-09T04:10:33Z" +"OwnerName": "RIMBOS" +"ParcelNumber": "2089-39-094-00-0005-0" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2024-04-17T02:02:36Z" +"PhotosCount": 16 +"PreviousListPrice": 624888 +"PriceChangeTimestamp": "2024-06-04T21:47:28Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-713-2313" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3496635" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StreetName": "Mill" +"StreetNumber": "365" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Must See !! Recently Renovated 4 Bedroom with 2 Full Baths !! Amazing School district and Close to All transportation and shopping. Detached 1 Car garage , Eat In Kitchen and hardwood Flooring !! Make this home yours. Room For Pool and Great yard for entertaining !!" +"TaxAnnualAmount": "12550" +"TaxBlock": "94" +"TaxLot": "5" +"TaxMapNumber": "2089-39-094-00-0005-0" +"Township": "Hempstead" +"WaterSource": array:1 [ …1] +"YearBuiltEffective": 2015 +"KEY_HighPriceDollars": "600000" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_HotWater": "Gas Stand Alone" +"KEY_OfferPresentation": "Can be Present" +"KEY_AttributionContact": "631-961-4626" +"KEY_CoListMainOfficeMlsId": "WOPR01" +"KEY_FloodZoneReportYN": "1" +"KEY_NumberOfKitchens": "1" +"KEY_OriginatingSystemOfficeKey": "112688000" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "M2 Agent Exclusions" +"KEY_FloodZoneDate": "2023-08-09" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "WOPR01" +"KEY_MinorChangeTimestamp": "2024-08-09T00:00:00-04:00" +"KEY_AtticDescription": "None" +"KEY_SourceSystemModificationTimestamp": "2024-08-09T00:20:49-04:00" +"KEY_AlternateMlsNumber": "3496635" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY3496635')" +"provider_name": "OneKey" +"Media": array:16 [ …16] +"DaysOnMarket": null +"ID": "29132" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5287 +post_id: "24125" +post_author: 1 +"ListingKey": "KEY322438904" +"ListingId": "L3482203" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-09-19T02:00:36Z" +"RFModificationTimestamp": "2025-09-19T02:05:23Z" +"ListPrice": 2298000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.97 +"LivingArea": 5000.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "203 Albon Road, Hewlett Harbor, NY 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6362146 +"Longitude": -73.6815194 +"YearBuilt": 1926 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Alissa W. Lurie" +"ListOfficeName": "Howard Hanna Coach" +"ListAgentMlsId": "131044" +"ListOfficeMlsId": "CARE22" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "One Acre of Park-Like Grounds in Hewlett Harbor! This Elegant and Spacious 5000 sq ft Classic Colonial is Situated on One of the Most Desirable Streets in SD # 14. It Features 5+ Bedrooms, 4.5 Baths, All Oversized Rooms, A Huge Formal Dining Room, A XL Living Room with Outside Exit to Screened Porch, A Large Chefs Kitchen and Adjoining Great Room and Den, Hardwood Floors as Shown, a Huge Dry Unfinished Basement with High Ceilings, an In Ground Gunite Pool, a Koi Pond, a Two Car Garage and XL Driveway for Private Parking, In Ground Sprinklers, A Security System, and Fencing and Landscaping for Total Privacy. Huge Tax Reduction for 2023 Confirmed and in Place! New Tax Grievance Going Forward! Must See this Outstanding Property!, Additional information: Appearance:Excellent" +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-374-0100" +"Basement": array:3 [ …3] +"BathroomsFull": 4 +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2023-08-04T13:45:18.804612+00:00" +"CrossStreet": "Seawane Drive" +"CumulativeDaysOnMarket": 839 +"DaysOnMarket": 839 +"Directions": "Everit Ave to Albon Rd # 203" +"ElementarySchool": "Hewlett Elementary School" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"ExpirationDate": "2026-06-03" +"Fencing": array:2 [ …2] +"FireplacesTotal": "3" +"Flooring": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-967-8828" +"ListAgentEmail": "alurie@coachrealtors.com" +"ListAgentKey": "326145269" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110108" +"ListOfficePhone": "516-374-0100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2023-06-02" +"LotFeatures": array:4 [ …4] +"LotSizeDimensions": "1" +"LotSizeSquareFeet": 42114 +"MajorChangeTimestamp": "2025-09-19T01:59:16Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "Hold" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2025-09-18" +"OnMarketDate": "2023-06-02" +"OriginalEntryTimestamp": "2023-06-02T04:17:54Z" +"OriginalListPrice": 2298000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3482203" +"OriginatingSystemModificationTimestamp": "2025-09-19T01:59:16Z" +"OwnerName": "Janow" +"ParcelNumber": "2017-42-213-00-0014-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2024-11-02T01:51:11Z" +"PhotosCount": 36 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Hewlett Harbor" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "12" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-967-8828" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3482203" +"SourceSystemKey": "3482203" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-09-19T01:59:16Z" +"StreetName": "Albon" +"StreetNumber": "203" +"StreetNumberNumeric": "203" +"StreetSuffix": "Road" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "41491.28" +"TaxBlock": "213" +"TaxLot": "14" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial,Walkup" +"KEY_Village": "Hewlett Harbor" +"KEY_HoldDate": "2025-09-18" +"KEY_TaxSection": "42" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "2298000.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,Library/Den" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_OriginatingSystemTimestamp": "2024-10-15T21:32:32.000" +"KEY_RATIO_ListPrice_By_LivingArea": "459.60000" +"KEY_RATIO_CurrentPrice_By_LivingArea": "459.60000" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY322438904')" +"provider_name": "One Key" +"Media": array:36 [ …36] +"ID": "24125" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5288 +post_id: "24126" +post_author: 1 +"ListingKey": "KEY322411832" +"ListingId": "L3454487" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2026-02-02T23:19:36Z" +"RFModificationTimestamp": "2026-02-02T23:20:45Z" +"ListPrice": 2997000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0.43 +"LivingArea": 5131.0 +"BuildingAreaTotal": 5031.0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "290 Heather Lane, Hewlett Harbor, NY 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6362146 +"Longitude": -73.6815194 +"YearBuilt": 1951 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gil R. Shemtov" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "172225" +"ListOfficeMlsId": "DERE58" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Spectacular home in the heart of Hewlett Harbor. This elegant home has been renovated to the highest standard. No expense was spared during the renovation, from the radiant floors that run throughout the home to the top of the line appliances in the kitchen built for a five star chef. As you enter the home your greeted with a ballroom like space that can host tons of family and friends and your next event. The fact that you have seven bedrooms and five full bathrooms just means they can all stay over comfortably. In addition to the spacious interior we also have the backyard you would expect with plenty of grass, an outdoor kitchen and an inground pool. The perfect home is now available, come see for yourself., Additional information: Appearance:Mint,Separate Hotwater Heater:Yes" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-432-3400" +"Basement": array:2 [ …2] +"BathroomsFull": 5 +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2023-07-11T20:09:25.637373+00:00" +"CrossStreet": "Auerbach" +"CumulativeDaysOnMarket": 911 +"DaysOnMarket": 911 +"Directions": "East Rockaway Road To Auerbach To Heather Lane" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"ExpirationDate": "2027-01-25" +"FireplacesTotal": "1" +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-835-3333" +"ListAgentEmail": "Gil.Shemtov@elliman.com" +"ListAgentKey": "326183315" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110783" +"ListOfficePhone": "516-432-3400" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2023-01-25" +"LotFeatures": array:3 [ …3] +"LotSizeDimensions": "125X149" +"LotSizeSquareFeet": 18625 +"MajorChangeTimestamp": "2026-02-02T23:17:40Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "Hold" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2026-02-02" +"OnMarketDate": "2023-01-25" +"OriginalEntryTimestamp": "2023-01-25T05:00:00Z" +"OriginalListPrice": 2997000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3454487" +"OriginatingSystemModificationTimestamp": "2026-02-02T23:17:40Z" +"OwnerName": "Nikolayeva" +"ParcelNumber": "2017-42-257-00-0006-A" +"ParkingFeatures": array:2 [ …2] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-01-25T05:13:36Z" +"PhotosCount": 31 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Hewlett Harbor" +"RoomsTotal": "12" +"ShowingContactPhone": "516-835-3333" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3454487" +"SourceSystemKey": "3454487" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-02T23:17:40Z" +"StreetName": "Heather" +"StreetNumber": "290" +"StreetNumberNumeric": "290" +"StreetSuffix": "Lane" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "39287.71" +"TaxBlock": "257" +"TaxLot": "6" +"WaterSource": array:1 [ …1] +"Zoning": "Residental" +"KEY_Attic": "See Remarks" +"KEY_Village": "Hewlett Harbor" +"KEY_HoldDate": "2026-02-02" +"KEY_TaxSection": "42" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "2997000.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,Library/Den" +"KEY_IncludedInTaxes": "Sewer" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_NumberOfHeatingZones": "12" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_OriginatingSystemTimestamp": "2024-08-19T14:29:40.000" +"KEY_RATIO_ListPrice_By_LivingArea": "584.09667" +"KEY_RATIO_CurrentPrice_By_LivingArea": "584.09667" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "595.70662" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "595.70662" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY322411832')" +"provider_name": "One Key" +"Media": array:31 [ …31] +"ID": "24126" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5289 +post_id: "29112" +post_author: 1 +"ListingKey": "KEYH6298715" +"ListingId": "H6298715" +"PropertyType": "Residential" +"PropertySubType": "Stock Cooperative" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-09-10T17:23:23Z" +"RFModificationTimestamp": "2024-11-23T11:34:43Z" +"ListPrice": 259000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1015.0 +"BuildingAreaTotal": 0 +"City": "Hewlett" +"PostalCode": "11557" +"UnparsedAddress": "1209 E Broadway # D25, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6348209 +"Longitude": -73.7012313 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joselin Galvez" +"ListOfficeName": "Century 21 Galvez" +"ListAgentMlsId": "H49642" +"ListOfficeMlsId": "UNITRE" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Beautifully renovated 2-bedroom, 2 bath co-op. This spacious unit with a great layout features a brand-new kitchen and bathrooms, hardwood floors throughout, plenty of closets and a bonus sunny terrace/deck. Common laundry room available but owner can also add their own units. Cats allowed. Subleasing allowed after 1 year. Conveniently located near the LIRR (Hewlett Station), shopping and restaurants. Garden Town has 5 acres of beautifully manicured grounds. Convenient parking and garage spaces available at $50/mo. per car. Maintenance is truly $1,670 and includes heat and hot water. The additional $630 covers the property taxes." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Live In Super" +"AssociationFee2": "2299" +"AssociationFee2Frequency": "Monthly" +"AssociationFeeIncludes": array:2 [ …2] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentEmail": "Joselin@c21galvez.com" +"BuyerAgentFullName": "Joselin Galvez" +"BuyerAgentKey": "H26504286" +"BuyerAgentMlsId": "H49642" +"BuyerAgentPreferredPhone": "646-320-7539" +"BuyerOfficeKey": "H26365358" +"BuyerOfficeMlsId": "UNITRE" +"BuyerOfficeName": "Century 21 Galvez" +"BuyerOfficePhone": "718-409-6300" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-04-08T15:43:48.328966+00:00" +"DaysOnMarket": 59 +"Directions": "Sunrise Highway to Broadway to Franklin Ave (Mixology Clothing Company on corner) turn into municipal parking lot. Park close to hedges for easy entrance to unit." +"ElementarySchool": "Call Listing Agent" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"EntryLevel": 2 +"ExpirationDate": "2024-07-08" +"ExteriorFeatures": array:2 [ …2] +"Heating": array:3 [ …3] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"Inclusions": "Dishwasher,Microwave,Refrigerator" +"InteriorFeatures": array:1 [ …1] +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "HGAR" +"ListAgentEmail": "Joselin@c21galvez.com" +"ListAgentFirstName": "Joselin" +"ListAgentKey": "H26504286" +"ListAgentLastName": "Galvez" +"ListAgentPreferredPhone": "646-320-7539" +"ListOfficeKey": "H26365358" +"ListOfficePhone": "718-409-6300" +"ListPriceLow": 259000 +"ListingContractDate": "2024-04-08" +"LotFeatures": array:1 [ …1] +"MLSAreaMinor": "6" +"MajorChangeTimestamp": "2024-09-10T16:59:14Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "U" +"OffMarketDate": "2024-07-08" +"OnMarketDate": "2024-04-08" +"OriginalEntryTimestamp": "2024-04-08T15:32:10Z" +"OriginalListPrice": 259000 +"OriginatingSystemID": "M00000490" +"OriginatingSystemKey": "6298715" +"OriginatingSystemModificationTimestamp": "2024-09-10T16:59:14Z" +"OwnerName": "Torie Coleman" +"Ownership": "Co-Op" +"ParkingFeatures": array:4 [ …4] +"PatioAndPorchFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-04-08T15:53:23Z" +"PhotosCount": 13 +"PostalCity": "Hewlett" +"PropertyAttachedYN": true +"PurchaseContractDate": "2024-06-05" +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "646-320-7539" +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "M00000489" +"SourceSystemKey": "H6298715" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StoriesTotal": "2" +"StreetDirPrefix": "E" +"StreetName": "Broadway" +"StreetNumber": "1209" +"SubdivisionName": "Garden Town" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Beautifully renovated 2-bedroom, 2 bath co-op. This spacious unit with a great layout features a brand-new kitchen and bathrooms, hardwood floors throughout, plenty of closets and a bonus sunny terrace/deck. Common laundry room available but owner can also add their own units. Cats allowed. Subleasing allowed after 1 year. Conveniently located near the LIRR (Hewlett Station), shopping and restaurants. Garden Town has 5 acres of beautifully manicured grounds. Convenient parking and garage spaces available at $50/mo. per car. Maintenance is truly $1,670 and includes heat and hot water. The additional $630 covers the property taxes." +"Township": "Hempstead" +"UnitNumber": "D25" +"WaterSource": array:1 [ …1] +"KEY_HighPriceDollars": "259000" +"KEY_Village": "Call Listing Agent" +"KEY_HotWater": "On Demand" +"KEY_AdditionalFeeFrequency": "Monthly" +"KEY_ManagementPhone": "516-349-0540" +"KEY_AdditionalFeesYN": "1" +"KEY_MinimumPctDownPayment": "20" +"KEY_Management": "Garden Town" +"KEY_OriginatingSystemOfficeKey": "26365358" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "None" +"KEY_AdditionalFeeDescription": "Assessment" +"KEY_SourceSystemModificationTimestamp": "2024-09-10T13:22:03-04:00" +"KEY_AlternateMlsNumber": "153408108" +"KEY_ApprovalRequiredYN": "1" +"KEY_DevelopmentName": "Garden Town" +"KEY_SquareFootageSource": "Other" +"KEY_FlipTaxYN": "0" +"KEY_AttributionContact": "(646) 320-7539" +"KEY_LocationDescription": "Second Floor,See Remarks" +"KEY_GarbageRemoval": "Public" +"KEY_RentingAllowedYN": "1" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "UNITRE" +"KEY_BuyerMainOfficeMlsId": "UNITRE" +"KEY_SquareFootage": "1015.00" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEYH6298715')" +"provider_name": "OneKey" +"Media": array:13 [ …13] +"ID": "29112" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5290 +post_id: "29054" +post_author: 1 +"ListingKey": "KEYH6282021" +"ListingId": "H6282021" +"PropertyType": "Residential" +"PropertySubType": "Stock Cooperative" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-04-02T05:23:24Z" +"RFModificationTimestamp": "2024-04-02T05:23:50Z" +"ListPrice": 259000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1015.0 +"BuildingAreaTotal": 0 +"City": "Hewlett" +"PostalCode": "11557" +"UnparsedAddress": "1209 E Broadway # D25, Hewlett, NY 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6431591 +"Longitude": -73.6956865 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joselin Galvez" +"ListOfficeName": "Century 21 Galvez" +"ListAgentMlsId": "H49642" +"ListOfficeMlsId": "UNITRE" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Beautifully renovated 2-bedroom, 2 bath co-op. This spacious unit with a great layout features a brand-new kitchen and bathrooms, hardwood floors throughout, plenty of closets and a bonus terrace, with a laundry room on the premises. Conveniently located near the LIRR (Hewlett Station), shopping and restaurants. Garden Town has 5 acres of beautifully manicured grounds. Convenient parking, garage spaces available at $50/mo. per car. Maintenance includes heat, hot water, and property taxes." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee2": "2260" +"AssociationFee2Frequency": "Monthly" +"AssociationFeeIncludes": array:2 [ …2] +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "2%" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CoolingYN": true +"CountyOrParish": "Nassau" +"CreationDate": "2024-01-02T14:24:23.254352+00:00" +"DaysOnMarket": 91 +"Directions": "Sunrise Highway to Broadway to Franklin Ave (Mixology Clothing Company on corner) turn into municipal parking lot (Entrance) park close to hedges." +"ElementarySchool": "Call Listing Agent" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"EntryLevel": 2 +"ExpirationDate": "2024-04-01" +"ExteriorFeatures": array:2 [ …2] +"Heating": array:3 [ …3] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"Inclusions": "A/C Units,Dishwasher,Intercom,Microwave,Refrigerator" +"InteriorFeatures": array:2 [ …2] +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "HGAR" +"ListAgentEmail": "Joselin@c21galvez.com" +"ListAgentFirstName": "Joselin" +"ListAgentKey": "H26504286" +"ListAgentLastName": "Galvez" +"ListAgentPreferredPhone": "646-320-7539" +"ListOfficeKey": "H26365358" +"ListOfficePhone": "718-409-6300" +"ListPriceLow": 259000 +"ListingContractDate": "2024-01-02" +"LotFeatures": array:1 [ …1] +"MLSAreaMinor": "6" +"MajorChangeTimestamp": "2024-04-02T04:10:49Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "U" +"OffMarketDate": "2024-04-01" +"OnMarketDate": "2024-01-02" +"OriginalEntryTimestamp": "2024-01-02T14:10:58Z" +"OriginalListPrice": 259000 +"OriginatingSystemID": "M00000490" +"OriginatingSystemKey": "6282021" +"OriginatingSystemModificationTimestamp": "2024-04-02T04:10:49Z" +"OwnerName": "Torie Coleman" +"Ownership": "Co-Op" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-01-02T14:21:24Z" +"PhotosCount": 15 +"PostalCity": "Hewlett" +"PropertyAttachedYN": true +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "646-320-7539" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "M00000489" +"SourceSystemKey": "H6282021" +"SourceSystemName": "OneKey™ MLS" +"StateOrProvince": "NY" +"StoriesTotal": "2" +"StreetDirPrefix": "E" +"StreetName": "Broadway" +"StreetNumber": "1209" +"SubdivisionName": "Garden Town" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "Beautifully renovated 2-bedroom, 2 bath co-op. This spacious unit with a great layout features a brand-new kitchen and bathrooms, hardwood floors throughout, plenty of closets and a bonus terrace, with a laundry room on the premises. Conveniently located near the LIRR (Hewlett Station), shopping and restaurants. Garden Town has 5 acres of beautifully manicured grounds. Convenient parking, garage spaces available at $50/mo. per car. Maintenance includes heat, hot water, and property taxes." +"Township": "Hempstead" +"UnitNumber": "D25" +"WaterSource": array:1 [ …1] +"KEY_HighPriceDollars": "259000" +"KEY_Village": "Call Listing Agent" +"KEY_HotWater": "See Remarks" +"KEY_AdditionalFeeFrequency": "Monthly" +"KEY_ManagementPhone": "516-349-0540" +"KEY_AdditionalFeesYN": "1" +"KEY_MinimumPctDownPayment": "20" +"KEY_Management": "Garden Town" +"KEY_BrokerAgencyCompensation": "2%" +"KEY_OriginatingSystemOfficeKey": "26365358" +"KEY_DPRYN": "1" +"KEY_ModificationsExclusions": "None" +"KEY_AdditionalFeeDescription": "Assessment" +"KEY_SourceSystemModificationTimestamp": "2024-04-02T01:22:12-04:00" +"KEY_AlternateMlsNumber": "135621288" +"KEY_ApprovalRequiredYN": "1" +"KEY_DevelopmentName": "Garden Town" +"KEY_SquareFootageSource": "Municipality" +"KEY_FlipTaxYN": "0" +"KEY_AttributionContact": "(646) 320-7539" +"KEY_LocationDescription": "Second Floor,See Remarks" +"KEY_GarbageRemoval": "Other" +"KEY_RentingAllowedYN": "1" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "UNITRE" +"KEY_AtticDescription": "None" +"KEY_SquareFootage": "1015.00" +"KEY_MinimumIncomeRequiredYN": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEYH6282021')" +"provider_name": "OneKey" +"Media": array:15 [ …15] +"ID": "29054" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5291 +post_id: "31212" +post_author: 1 +"ListingKey": "KEY424752829" +"ListingId": "995307" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-12T09:01:37Z" +"RFModificationTimestamp": "2026-05-12T09:07:30Z" +"ListPrice": 2799999.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 4009.0 +"BuildingAreaTotal": 4009.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "3390 Hewlett Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6396993 +"Longitude": -73.5344021 +"YearBuilt": 1966 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lisa Pellegrino" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "163208" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to a rare and exceptional waterfront in the heart of Merrick—where privacy, scale, and true open-bay living come together in a way that is increasingly hard to find.\n Perfectly positioned on an expansive quarter-acre property, this over 4,000 sq. ft. residence offers an open floor plan with breathtaking views of the open Bay. Oversized primary Suite with large walk in closets. Spa like bathroom with soaking tub makeup area and oversized shower with magnificent views of the Bay. This Home also offers 4 large additional bedrooms and 3.5 additional baths. Custom gourmet kitchen offers 2 islands with granite counters, stainless steel appliances, offering Wolf and sub zero. Attention to detail with moldings and custom cabinetry throughout.\n An elegant in Home bar enhances the sophistic focal point for entertaining.\n The backyard is the true centerpiece with south west exposure : relax in a salt water inground pool for those summer days. This deep, private, sanctuary is designed for both relaxation and entertaining, the kind of space that separates and distinguishes it from typical Water Front property. Whether enjoying morning light over the bay or spectacular sunsets reflecting off the water, this home delivers a lifestyle that goes far beyond.\n Compelling and rare opportunity. \n Under 10 years old: Stucco,Roof, AC,Hesting System and hot water heater!\n Bulk head steel pilings made for a life time!\n SO MUCH TO LOVE AND SEE FEATURES THROUGHOUT! """ +"Appliances": array:12 [ …12] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-623-4500" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 4 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-11T13:00:56.547273+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 37 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-09-30" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplacesTotal": "1" +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:26 [ …26] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-241-7117" +"ListAgentEmail": "Lisa.Pellegrino@Elliman.com" +"ListAgentKey": "326175015" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-05-05" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.2399 +"LotSizeSquareFeet": 10449 +"MajorChangeTimestamp": "2026-05-11T12:56:24Z" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-05-11" +"OriginalEntryTimestamp": "2026-05-11T12:56:24Z" +"OriginalListPrice": 2799999 +"OriginatingSystemModificationTimestamp": "2026-05-12T09:00:36Z" +"OwnerName": "Helen Ruth Greenbaum" +"ParcelNumber": "2089-63-322-00-0032-0" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-05-11T19:37:36Z" +"PhotosCount": 45 +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "5532" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-11T12:56:24Z" +"StreetName": "Hewlett" +"StreetNumber": "3390" +"StreetNumberNumeric": "3390" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "44591.72" +"TaxAssessedValue": 1596 +"TaxYear": "2024" +"Utilities": array:7 [ …7] +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:4 [ …4] +"WaterfrontYN": true +"KEY_Attic": "Full" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "2799999.00" +"KEY_ShowingTimeFlagYN": "1" +"KEY_LivingAreaSearchSqFt": "4009.00" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "698.42829" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "11671525.6357" +"KEY_RATIO_CurrentPrice_By_LivingArea": "698.42829" +"KEY_SourceSystemModificationTimestamp": "2026-05-05T13:30:24.630" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "698.42829" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "698.42829" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424752829')" +"provider_name": "One Key" +"Media": array:45 [ …45] +"ID": "31212" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5292 +post_id: "30833" +post_author: 1 +"ListingKey": "KEY424391042" +"ListingId": "985483" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2026-05-28T07:10:38Z" +"RFModificationTimestamp": "2026-05-28T07:12:45Z" +"ListPrice": 4200.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1205.0 +"BuildingAreaTotal": 1205.0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "363 Hewlett Parkway, Hempstead, New York 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6411932 +"Longitude": -73.7048411 +"YearBuilt": 1923 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gil R. Shemtov" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "172225" +"ListOfficeMlsId": "DERE58" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Fully renovated and move-in ready, this 3-bedroom, 1.5-bath home offers the perfect blend of comfort and convenience. The bright living room is filled with natural light, creating a warm and inviting atmosphere, while the updated kitchen comes equipped with appliances for everyday ease. The home also features well-proportioned, good-sized bedrooms that provide comfortable living space.\n With a two-car garage and a beautifully fenced-in backyard, it’s ideal for both relaxing and entertaining. Nestled on a quiet, tree-lined street and located within School District 14, this home checks all the boxes. Don’t miss the opportunity to make it yours. """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-432-3400" +"AvailabilityDate": "2026-04-15" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "646-696-0309" +"CoListAgentEmail": "tamta.gigilashvili@elliman.com" +"CoListAgentFullName": "Tamta Gigilashvili" +"CoListAgentKey": "326227947" +"CoListAgentMlsId": "218939" +"CoListOfficeKey": "326110783" +"CoListOfficeMlsId": "DERE58" +"CoListOfficeName": "Douglas Elliman Real Estate" +"CoListOfficePhone": "516-432-3400" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-15T14:41:23.727506+00:00" +"CumulativeDaysOnMarket": 42 +"DaysOnMarket": 42 +"ElementarySchool": "Hewlett Elementary School" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"EntryLevel": 1 +"ExpirationDate": "2027-04-15" +"Furnished": "Unfurnished" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-835-3333" +"ListAgentEmail": "Gil.Shemtov@elliman.com" +"ListAgentKey": "326183315" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110783" +"ListOfficePhone": "516-432-3400" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2026-04-15" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.09 +"LotSizeSquareFeet": 3920 +"MajorChangeTimestamp": "2026-05-27T21:09:56Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlgCanUse": array:3 [ …3] +"MlsStatus": "Hold" +"OffMarketDate": "2026-05-27" +"OnMarketDate": "2026-04-15" +"OriginalEntryTimestamp": "2026-04-15T14:37:19Z" +"OriginalListPrice": 4200 +"OriginatingSystemModificationTimestamp": "2026-05-27T21:09:56Z" +"OwnerName": "Zinaida Khaimova" +"ParcelNumber": "2089-39-569-00-1012-0" +"ParkingFeatures": array:1 [ …1] +"PetsAllowed": array:7 [ …7] +"PhotosChangeTimestamp": "2026-05-11T15:52:37Z" +"PhotosCount": 21 +"PostalCity": "Hewlett" +"PostalCodePlus4": "1201" +"PriceChangeTimestamp": "2026-04-15T14:37:19Z" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "646-696-0309" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-27T21:09:56Z" +"StreetName": "Hewlett" +"StreetNumber": "363" +"StreetNumberNumeric": "363" +"StreetSuffix": "Parkway" +"SyndicateTo": array:2 [ …2] +"Utilities": array:6 [ …6] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_HoldDate": "2026-05-27" +"KEY_RentSpreeYN": "0" +"KEY_CurrentPrice": "4200.00" +"KEY_PreviousStatus": "Active" +"KEY_SecurityDeposits": "4200" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "1205.00" +"KEY_RATIO_ListPrice_By_LivingArea": "3.48548" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "46666.6667" +"KEY_RATIO_CurrentPrice_By_LivingArea": "3.48548" +"KEY_SourceSystemModificationTimestamp": "2026-04-15T10:37:19.117" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "3.48548" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "3.48548" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424391042')" +"provider_name": "One Key" +"Media": array:21 [ …21] +"ID": "30833" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5293 +post_id: "30723" +post_author: 1 +"ListingKey": "KEY424233081" +"ListingId": "981145" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-08T02:20:36Z" +"RFModificationTimestamp": "2026-05-08T02:21:47Z" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1393.0 +"BuildingAreaTotal": 1393.0 +"City": "Hempstead" +"PostalCode": "11518" +"UnparsedAddress": "47 Hewlett Point Avenue, Hempstead, New York 11518" +"Coordinates": array:2 [ …2] +"Latitude": 40.6323323 +"Longitude": -73.6709891 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Samantha Yagnisis" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "174907" +"ListOfficeMlsId": "SPH09" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to 47 Hewlett Point Ave with 4 generous size bedrooms , 1 full bathroom, Living room and Eat in Kitchen. This home also features a formal dining area and additional room used for Laundry or office with a large closet. \n There is a one and a half car garage , large backyard easily accessible from the dining room and laundry room. \n This home is NOT in a flood zone. Close to Hewlett Point park and pool, Bay park and schools. \n \n Interior sq footage is approximate. """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-546-6300" +"Basement": array:1 [ …1] +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-350-4670" +"BuyerAgentEmail": "syagnisis@signaturepremier.com" +"BuyerAgentFullName": "Samantha Yagnisis" +"BuyerAgentKey": "326185824" +"BuyerAgentMlsId": "174907" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115717" +"BuyerOfficeMlsId": "SPH09" +"BuyerOfficeName": "Signature Premier Properties" +"BuyerOfficePhone": "516-546-6300" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-04-08T16:22:14.223910+00:00" +"CrossStreet": "Everdell Rd" +"CumulativeDaysOnMarket": 15 +"DaysOnMarket": 15 +"Disclosures": array:1 [ …1] +"ElementarySchool": "Rhame Avenue Elementary School" +"ElementarySchoolDistrict": "East Rockaway" +"ExpirationDate": "2027-04-08" +"Flooring": array:4 [ …4] +"GarageSpaces": "1.5" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "East Rockaway Junior-Senior High Sch" +"HighSchoolDistrict": "East Rockaway" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-350-4670" +"ListAgentEmail": "syagnisis@signaturepremier.com" +"ListAgentKey": "326185824" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115717" +"ListOfficePhone": "516-546-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-04-08" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1148 +"LotSizeSquareFeet": 5000 +"MajorChangeTimestamp": "2026-05-08T02:19:08Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch" +"MiddleOrJuniorSchoolDistrict": "East Rockaway" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-04-23" +"OnMarketDate": "2026-04-08" +"OriginalEntryTimestamp": "2026-04-08T16:17:34Z" +"OriginalListPrice": 599000 +"OriginatingSystemModificationTimestamp": "2026-05-08T02:19:08Z" +"OwnerName": "Moya" +"ParcelNumber": "2089-42-059-00-0139-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-04-08T16:18:36Z" +"PhotosCount": 21 +"PostalCity": "East Rockaway" +"PostalCodePlus4": "2420" +"PurchaseContractDate": "2026-05-07" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-350-4670" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-05-08T02:19:08Z" +"StreetName": "Hewlett Point" +"StreetNumber": "47" +"StreetNumberNumeric": "47" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "10134.08" +"TaxAssessedValue": 435 +"TaxYear": "2024" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Scuttle" +"KEY_HoldDate": "2026-04-23" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "599000.00" +"KEY_ContractPrice": "640000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Hold" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1393.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "430.00718" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5217770.0348" +"KEY_RATIO_CurrentPrice_By_LivingArea": "430.00718" +"KEY_SourceSystemModificationTimestamp": "2026-04-06T13:02:32.057" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "430.00718" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "430.00718" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424233081')" +"provider_name": "One Key" +"Media": array:21 [ …21] +"ID": "30723" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5294 +post_id: "31493" +post_author: 1 +"ListingKey": "KEY423764023" +"ListingId": "967481" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-06T18:39:39Z" +"RFModificationTimestamp": "2026-06-06T18:44:41Z" +"ListPrice": 849000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1541.0 +"BuildingAreaTotal": 1541.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "2716 Hewlett Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6543365 +"Longitude": -73.5443506 +"YearBuilt": 1954 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "John Sinetos" +"ListOfficeName": "Voro LLC" +"ListAgentMlsId": "136631" +"ListOfficeMlsId": "VORO01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Charming and lovingly maintained wide-line Ranch nestled in desirable South Merrick within the sought-after Merrick/Belmore School District. Filled with natural light, this inviting home features an updated kitchen, a cozy wood-burning fireplace, and a versatile bonus room ideal as a bedroom, home office, playroom, or additional living space. Recent improvements include new roof, siding, gutters, landscaping with the furnace, water heater, central air updated over recent years. Also features 200-amp electric service. The full unfinished basement provides abundant storage and endless possibilities. A spacious circular driveway accommodates 6+ vehicles, completing this wonderful home that blends comfort, charm, and convenience!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "877-943-8676" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "631-767-2830" +"CoListAgentEmail": "mroger@coachrealtors.com" +"CoListAgentFullName": "Melissa Roger" +"CoListAgentKey": "326215666" +"CoListAgentMlsId": "206268" +"CoListOfficeKey": "326110104" +"CoListOfficeMlsId": "CARE18" +"CoListOfficeName": "Howard Hanna Coach" +"CoListOfficePhone": "631-587-1700" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:2 [ …2] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-06-01T15:38:31.800795+00:00" +"CumulativeDaysOnMarket": 5 +"DaysOnMarket": 16 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-11-30" +"ExteriorFeatures": array:2 [ …2] +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:11 [ …11] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "877-943-8676" +"ListAgentEmail": "jsinc21@gmail.com" +"ListAgentKey": "326150329" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326116380" +"ListOfficePhone": "877-943-8676" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-06-01" +"LivingAreaSource": "Measured" +"LotFeatures": array:9 [ …9] +"LotSizeAcres": 0.1607 +"LotSizeSquareFeet": 7000 +"MajorChangeTimestamp": "2026-06-01T15:32:25Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-06-01" +"OriginalEntryTimestamp": "2026-06-01T15:32:25Z" +"OriginalListPrice": 849000 +"OriginatingSystemModificationTimestamp": "2026-06-06T18:38:27Z" +"OwnerName": "Hw 27 Llc" +"ParcelNumber": "2089-63-146-00-0016-0" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-06-02T14:08:36Z" +"PhotosCount": 49 +"PostalCity": "Merrick" +"PostalCodePlus4": "5040" +"RoomsTotal": "7" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "631-767-2830" +"ShowingRequirements": array:4 [ …4] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-01T15:32:25Z" +"StreetName": "Hewlett" +"StreetNumber": "2716" +"StreetNumberNumeric": "2716" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "17453.02" +"TaxAssessedValue": 611 +"TaxYear": "2024" +"Utilities": array:2 [ …2] +"View": "Neighborhood" +"VirtualTourURLUnbranded": "https://visithome.ai/WFdd6P7R9s9hZXvC4sptvr?mu=ft&t=1780364123" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Unfinished" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "849000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "1" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "1541.00" +"KEY_NumberOfHeatingZones": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "550.94095" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5283136.2788" +"KEY_RATIO_CurrentPrice_By_LivingArea": "550.94095" +"KEY_SourceSystemModificationTimestamp": "2026-03-04T14:59:39.917" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "550.94095" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "550.94095" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY423764023')" +"provider_name": "One Key" +"Media": array:49 [ …49] +"ID": "31493" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5295 +post_id: "27907" +post_author: 1 +"ListingKey": "KEY421490927" +"ListingId": "902457" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-02-25T07:02:36Z" +"RFModificationTimestamp": "2026-02-25T07:06:11Z" +"ListPrice": 16500.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 4900.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11598" +"UnparsedAddress": "302 Hewlett Neck Road, Hempstead, New York 11598" +"Coordinates": array:2 [ …2] +"Latitude": 40.6270145 +"Longitude": -73.6939129 +"YearBuilt": 2013 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Bryna L. Flaum" +"ListOfficeName": "Five Towns Miller Realty Inc" +"ListAgentMlsId": "107396" +"ListOfficeMlsId": "DOMI01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Elegant custom colonial on nearly ¾ acre with pool and outdoor kitchen. Featuring 5 bedrooms, 5.5 baths, soaring ceilings, chef’s kitchen, grand primary suite with private balcony, and a finished lower level. Located in prestigious Hewlett Neck within the Hewlett-Woodmere School District" +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-374-4100" +"AvailabilityDate": "2025-08-24" +"Basement": array:1 [ …1] +"BathroomsFull": 5 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-19T00:15:32.187528+00:00" +"CrossStreet": "Dolphin Dr." +"CumulativeDaysOnMarket": 252 +"DaysOnMarket": 183 +"ElementarySchool": "Franklin Early Childhood Center" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"ExpirationDate": "2026-02-25" +"Fencing": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "12 Months" +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-322-4831" +"ListAgentEmail": "bryna@ftmr.com" +"ListAgentKey": "326123624" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110921" +"ListOfficePhone": "516-374-4100" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-08-18" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.7031 +"LotSizeDimensions": "125x245" +"LotSizeSquareFeet": 30627 +"MajorChangeTimestamp": "2026-02-25T05:10:42Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "Expired" +"OffMarketDate": "2026-02-25" +"OnMarketDate": "2025-08-18" +"OriginalEntryTimestamp": "2025-08-19T00:09:46Z" +"OriginalListPrice": 17500 +"OriginatingSystemModificationTimestamp": "2026-02-25T05:10:42Z" +"OwnerName": "Klein" +"ParcelNumber": "2019-41-109-00-0014-0" +"ParkingFeatures": array:2 [ …2] +"PatioAndPorchFeatures": array:2 [ …2] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-28T13:01:54Z" +"PhotosCount": 39 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Woodmere" +"PostalCodePlus4": "1407" +"PreviousListPrice": 17500 +"PriceChangeTimestamp": "2025-10-28T13:00:43Z" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-322-4831" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-25T05:10:42Z" +"StreetName": "Hewlett Neck" +"StreetNumber": "302" +"StreetNumberNumeric": "302" +"StreetSuffix": "Road" +"SyndicateTo": array:2 [ …2] +"Utilities": array:2 [ …2] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Unfinished" +"KEY_SmokingYN": "0" +"KEY_RentSpreeYN": "1" +"KEY_CurrentPrice": "16500.00" +"KEY_RentSpreeURL": "https://apply.link/MUrbnKE" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "4900.00" +"KEY_RATIO_ListPrice_By_LivingArea": "3.36735" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "23467.5011" +"KEY_RATIO_CurrentPrice_By_LivingArea": "3.36735" +"KEY_SourceSystemModificationTimestamp": "2025-08-18T10:41:39.323" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.94286" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY421490927')" +"provider_name": "One Key" +"Media": array:39 [ …39] +"ID": "27907" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5296 +post_id: "31628" +post_author: 1 +"ListingKey": "KEY425355314" +"ListingId": "1011221" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-14T18:10:41Z" +"RFModificationTimestamp": "2026-06-14T18:14:00Z" +"ListPrice": 1125000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2705.0 +"BuildingAreaTotal": 2990.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "3145 Hewlett Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6445375 +"Longitude": -73.5381891 +"YearBuilt": 1966 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lisa M. Adwar" +"ListOfficeName": "Daniel Gale Sothebys Intl Rlty" +"ListAgentMlsId": "105248" +"ListOfficeMlsId": "GALE12" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to the bright and sunny , Splanch House in South Merrick, offering a spacious open floor plan and effortless California style living. The sun drenched great room is filled with natural light and serves as the heart of the home, creating the perfect space for relaxing and entertaining.\n The updated eat in kitchen, combines style and functionality, while the beautifully landscape backyard provides, outdoor dining and gathering.\n A true gem you won't want to miss . """ +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-626-7600" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-06-09T19:07:16.242061+00:00" +"CrossStreet": "Merrick" +"CumulativeDaysOnMarket": 5 +"DaysOnMarket": 8 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2027-06-04" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-702-2100" +"ListAgentEmail": "lisaadwar@danielgale.com" +"ListAgentKey": "326121599" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111555" +"ListOfficePhone": "516-626-7600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-06-09" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2026-06-09T19:02:34Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-06-09" +"OriginalEntryTimestamp": "2026-06-09T19:02:34Z" +"OriginalListPrice": 1125000 +"OriginatingSystemModificationTimestamp": "2026-06-14T18:08:17Z" +"OtherEquipment": array:1 [ …1] +"OwnerName": "Name Withheld" +"ParcelNumber": "2089-63-295-00-0049-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-06-09T19:03:36Z" +"PhotosCount": 27 +"PostalCity": "Merrick" +"PostalCodePlus4": "5328" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-702-2100" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-09T19:02:34Z" +"StreetName": "Hewlett" +"StreetNumber": "3145" +"StreetNumberNumeric": "3145" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "19055" +"TaxAssessedValue": 704 +"TaxBlock": "295" +"TaxLot": "49" +"TaxYear": "2026" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://tours.kjwphotography.com/2390561?idx=1" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Crawl" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "63" +"KEY_CurrentPrice": "1125000.00" +"KEY_OpenHouseCount": "2" +"KEY_ElectricCompany": "PSEG" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "2705.00" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-626-7600" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "415.89649" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8169934.6405" +"KEY_RATIO_CurrentPrice_By_LivingArea": "415.89649" +"KEY_SourceSystemModificationTimestamp": "2026-06-09T14:28:59.727" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "376.25418" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "376.25418" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425355314')" +"provider_name": "One Key" +"Media": array:27 [ …27] +"ID": "31628" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5297 +post_id: "31506" +post_author: 1 +"ListingKey": "KEY425210600" +"ListingId": "1007398" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-13T20:09:43Z" +"RFModificationTimestamp": "2026-06-13T20:14:16Z" +"ListPrice": 1049999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1759.0 +"BuildingAreaTotal": 1759.0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "3075 Hewlett Avenue, Hempstead, New York 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6461733 +"Longitude": -73.5387787 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marguerite Karamoshos" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "184590" +"ListOfficeMlsId": "SPH18" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this spectacular custom-built home situated on an oversized 84 x 100 property, offering the perfect blend of luxury, comfort, and space for extended family living. This beautifully maintained residence features an open-concept layout highlighted by soaring vaulted ceilings, skylights, gleaming hardwood floors, and a stunning gas fireplace that serves as the centerpiece of the main living area. The designer kitchen boasts sleek white cabinetry, quartz countertops, a large center island with seating, and seamless flow into the dining and living spaces—ideal for everyday living and entertaining.The spacious layout provides tremendous flexibility with ample room for an extended family, guests, home office space, or multigenerational living arrangements. Step outside to your own private backyard oasis featuring a gorgeous in-ground pool surrounded by Cambridge pavers, a covered patio, and an impressive outdoor kitchen complete with granite countertops and bar seating. The beautifully landscaped yard offers the perfect setting for summer gatherings, outdoor dining, and relaxation. Additional highlights include: Grand two-story entry. Attached two-car garage Gas fireplace. Skylights and abundant natural ligh Hardwood flooring, Resort-style backyard. Covered entertaining area Outdoor kitchen In-ground pool Oversized 84 x 100 property. A rare opportunity to own a home that combines elegant indoor living with exceptional outdoor entertaining space. Move right in and enjoy all this remarkable property has to offer!" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-799-7100" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "917-816-3387" +"CoListAgentEmail": "skaramoshos@signaturepremier.com" +"CoListAgentFullName": "Stavros Karamoshos" +"CoListAgentKey": "326212123" +"CoListAgentMlsId": "202653" +"CoListOfficeKey": "326115726" +"CoListOfficeMlsId": "SPH18" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "516-799-7100" +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-06-01T20:33:11.918235+00:00" +"CumulativeDaysOnMarket": 12 +"DaysOnMarket": 16 +"ElementarySchool": "Norman J Levy Lakeside School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-12-31" +"FireplaceFeatures": array:1 [ …1] +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "John F Kennedy High School" +"HighSchoolDistrict": "Merrick" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "917-816-0239" +"ListAgentEmail": "mkaramoshos@signaturepremier.com" +"ListAgentKey": "326194806" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115726" +"ListOfficePhone": "516-799-7100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2026-06-01" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1882 +"LotSizeSquareFeet": 8200 +"MajorChangeTimestamp": "2026-06-01T20:24:09Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merrick Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2026-06-01" +"OriginalEntryTimestamp": "2026-06-01T20:24:09Z" +"OriginalListPrice": 1049999 +"OriginatingSystemModificationTimestamp": "2026-06-13T20:08:21Z" +"OwnerName": "Carbone/Avezzano" +"ParcelNumber": "2089-63-294-00-0021-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-06-01T20:25:36Z" +"PhotosCount": 42 +"PoolPrivateYN": true +"PostalCity": "Merrick" +"PostalCodePlus4": "5336" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "9178160239" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-06-01T20:24:09Z" +"StreetName": "Hewlett" +"StreetNumber": "3075" +"StreetNumberNumeric": "3075" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "16513.2" +"TaxAssessedValue": 586 +"TaxBlock": "294" +"TaxLot": "21" +"TaxYear": "2026" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Unfinished" +"KEY_TaxSource": "Other" +"KEY_TaxSection": "63" +"KEY_CurrentPrice": "1049999.00" +"KEY_OpenHouseCount": "1" +"KEY_IncludedInTaxes": "Sewer" +"KEY_MlsDistrictCode": "26" +"KEY_NumberOfKitchens": "2" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "1759.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "9178163387" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "596.92951" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5579165.7811" +"KEY_RATIO_CurrentPrice_By_LivingArea": "596.92951" +"KEY_SourceSystemModificationTimestamp": "2026-06-01T15:17:38.443" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "596.92951" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "596.92951" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425210600')" +"provider_name": "One Key" +"Media": array:42 [ …42] +"ID": "31506" } 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5298 +post_id: "31479" +post_author: 1 +"ListingKey": "KEY425175495" +"ListingId": "1006476" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2026-06-06T07:16:38Z" +"RFModificationTimestamp": "2026-06-06T07:18:49Z" +"ListPrice": 6700.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2662.0 +"BuildingAreaTotal": 2662.0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1463 Hewlett Avenue, Hempstead, New York 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6422306 +"Longitude": -73.6955055 +"YearBuilt": 1930 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gil R. Shemtov" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "172225" +"ListOfficeMlsId": "DERE58" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Exceptional Whole-House Rental in Prime Hewlett Location!\n Welcome to this spacious and beautifully maintained 4-bedroom, 2-bath home located in one of Hewlett's most desirable neighborhoods. Featuring two newly renovated bathrooms and an updated eat-in kitchen, this home offers the perfect blend of comfort, style, and functionality.\n Designed with entertaining in mind, the home boasts a large formal dining room with a charming fireplace, creating a warm and inviting atmosphere for gatherings. The expansive living room, also highlighted by a fireplace, provides an ideal space for relaxing or hosting guests. Step outside to the oversized deck, perfect for outdoor entertaining.\n With generous living spaces throughout, this home offers plenty of room for both everyday living and special occasions. This is a rare rental opportunity in the heart of Hewlett.\n A perfect place to call home for those who love space, comfort, and entertaining. """ +"Appliances": array:3 [ …3] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-432-3400" +"AvailabilityDate": "2026-06-01" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2026-05-29T22:01:20.668077+00:00" +"CumulativeDaysOnMarket": 7 +"DaysOnMarket": 7 +"ElementarySchool": "Hewlett Elementary School" +"ElementarySchoolDistrict": "Hewlett-Woodmere" …79 } ] +success: true +page_size: 32 +page_count: 2 +count: 51 +after_key: "" } "RF Response Time" => "0.12 seconds" ] ]