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&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst')) and ListPrice le 5000000) and contains(UnparsedAddress, 'Hewlett')/Property?$select=ALL&$orderby=ListingId DESC&$top=32&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst')) and ListPrice le 5000000) and contains(UnparsedAddress, 'Hewlett')&$expand=Media/Property?$select=ALL&$orderby=ListingId DESC&$top=32&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst')) and ListPrice le 5000000) and contains(UnparsedAddress, 'Hewlett')/Property?$select=ALL&$orderby=ListingId DESC&$top=32&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst')) and ListPrice le 5000000) and contains(UnparsedAddress, 'Hewlett')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4886 +items: array:32 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4940 +post_id: "17105" +post_author: 1 +"ListingKey": "KEY417958271" +"ListingId": "L3593014" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-07-28T20:58:37Z" +"RFModificationTimestamp": "2025-07-28T21:00:17Z" +"ListPrice": 2375000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 1.0 +"LivingArea": 4500.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1345 Harbor Road, Hewlett Harbor, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.63734375 +"Longitude": -73.685833974021 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gil R. Shemtov" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "172225" +"ListOfficeMlsId": "DERE58" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this exquisite 5-bedroom, 4.5-bath Colonial home, nestled on a sprawling acre of meticulously landscaped grounds in one of the most sought-after neighborhoods. This expansive residence seamlessly blends classic architectural elegance with modern amenities, offering the perfect balance of comfort, luxury, and functionality. Step inside to a grand two-story foyer that leads to expansive living and dining rooms, ideal for both intimate gatherings and large-scale entertaining. The chef-inspired kitchen boasts stainless steel appliances, stone countertops, custom cabinetry, and a spacious island perfect for meal prep and casual dining. The adjoining family room features a cozy fireplace, creating a welcoming atmosphere for relaxation. The private master suite is a true retreat, featuring a spa-like en-suite bath with a soaking tub, dual vanities, and a large walk-in closet. Four additional generously sized bedrooms offer ample space for family and guests, each with easy access to well-appointed bathrooms. The finished lower level provides even more living space, perfect for a media room, home gym, or playroom. Outside, the park-like grounds are an entertainer's dream, with a large deck, stone patio, and expansive lawn surrounded by mature trees, offering both privacy and tranquility. The home's impeccable curb appeal is enhanced by its charming colonial architecture and manicured landscaping. This residence is ideally located in a highly desirable Hewlett Harbor, offering convenient access to top-rated schools, parks, shopping, and major highways, while providing the serenity and privacy of a suburban retreat. With its combination of timeless beauty, sophisticated features, and exceptional location, this home is a rare find. Don't miss the opportunity to make it yours!, Additional information: Appearance:Excellent" +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-432-3400" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 4 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-11-25T19:18:27.244479+00:00" +"CrossStreet": "Everit" +"CumulativeDaysOnMarket": 245 +"DaysOnMarket": 245 +"Directions": "Everit to Harbor" +"ElementarySchool": "Hewlett Elementary School" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"ExpirationDate": "2025-11-24" +"FireplacesTotal": "1" +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"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" +"ListOfficeKey": "326110783" +"ListOfficePhone": "516-432-3400" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-11-25" +"LivingAreaSource": "Other" +"LotSizeDimensions": "1.00" +"LotSizeSquareFeet": 43560 +"MajorChangeTimestamp": "2025-07-28T20:56:44Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "Hold" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2025-07-28" +"OnMarketDate": "2024-11-25" +"OriginalEntryTimestamp": "2024-11-25T05:00:00Z" +"OriginalListPrice": 2495000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3593014" +"OriginatingSystemModificationTimestamp": "2025-07-28T20:56:44Z" +"OwnerName": "Kalter" +"ParcelNumber": "2017-42-219-00-0033-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2024-11-25T19:24:36Z" +"PhotosCount": 36 +"PostalCity": "Hewlett Harbor" +"PreviousListPrice": 2495000 +"PriceChangeTimestamp": "2025-04-08T14:44:40Z" +"RoomsTotal": "11" +"ShowingContactPhone": "516-835-3333" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3593014" +"SourceSystemKey": "3593014" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-07-28T20:56:44Z" +"StreetName": "Harbor" +"StreetNumber": "1345" +"StreetSuffix": "Road" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "47668.42" +"TaxBlock": "219" +"TaxLot": "33" +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_Village": "Hewlett Harbor" +"KEY_HoldDate": "2025-07-28" +"KEY_TaxSection": "42" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "2375000.00" +"KEY_AdditionalFees": "0.00" +"KEY_NumOf1BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf4BedRooms": "0" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "4500.00" +"KEY_OpenHousePublicCount": "0" +"KEY_OriginatingSystemTimestamp": "2024-11-25T14:08:36.000" +"KEY_RATIO_ListPrice_By_LivingArea": "527.77778" +"KEY_RATIO_CurrentPrice_By_LivingArea": "527.77778" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.95190" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY417958271')" +"provider_name": "One Key" +"Media": array:36 [ …36] +"ID": "17105" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4943 +post_id: "17555" +post_author: 1 +"ListingKey": "KEY417943136" +"ListingId": "L3592783" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-07-01T04:19:37Z" +"RFModificationTimestamp": "2025-07-01T04:23:02Z" +"ListPrice": 4950.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "356 Franklin Ave, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.82952126087 +"Longitude": -73.984121695652 +"YearBuilt": 1928 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Mark Lipner GRI" +"ListOfficeName": "BERKSHIRE HATHAWAY" +"ListAgentMlsId": "83128" +"ListOfficeMlsId": "BHHS04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Move-in Ready! This meticulously maintained home offers 3 spacious bedrooms, 2 full bathrooms, and a finished basement equipped with a washer and dryer. The bright, modern kitchen features stainless steel appliances, including dual sinks, a dishwasher, refrigerator, gas stove, and microwave. Enjoy the convenience of 2 side yards for outdoor space. Additional highlights include a finished attic for extra storage or living space, and a 2-car driveway for off-street parking. Located in the highly sought-after School District #14, this home is just minutes from schools, shopping, dining, public transportation, and places of worship.., Additional information: Appearance:Excellent,Interior Features:Efficiency Kitchen,Separate Thermostat" +"Appliances": array:6 [ …6] +"AttributionContact": "516-295-3000" +"AvailabilityDate": "2025-01-01" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 2 +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-11-23T00:08:01.366577+00:00" +"CrossStreet": "Centre St" +"CumulativeDaysOnMarket": 221 +"DaysOnMarket": 221 +"Directions": "West Broadway To Franklin Ave." +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"ExpirationDate": "2025-07-01" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseConsideredYN": true +"LeaseTerm": "6-12 Month" +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-298-8457" +"ListAgentEmail": "mlipner@bhhslaffey.com" +"ListAgentKey": "326244341" +"ListOfficeKey": "326109740" +"ListOfficePhone": "516-295-3000" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2024-11-22" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"MajorChangeTimestamp": "2025-07-01T04:18:29Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "Expired" +"OffMarketDate": "2025-07-01" +"OnMarketDate": "2024-11-22" +"OriginalEntryTimestamp": "2024-11-22T22:53:46Z" +"OriginalListPrice": 4950 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3592783" +"OriginatingSystemModificationTimestamp": "2025-07-01T04:18:29Z" +"OwnerName": "Milberg" +"ParcelNumber": "2089-39-101-00-0028-0" +"ParkingFeatures": array:2 [ …2] +"PetsAllowed": array:2 [ …2] +"PhotosChangeTimestamp": "2024-11-26T16:32:37Z" +"PhotosCount": 21 +"PostalCity": "Hewlett" +"RentIncludes": "Grounds Care,Trash Collection" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-295-3000" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3592783" +"SourceSystemKey": "3592783" +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-07-01T04:18:29Z" +"StoriesTotal": "4" +"StreetName": "Franklin Ave" +"StreetNumber": "356" +"SyndicateTo": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_OriginatingSystemTimestamp": "2024-12-02T00:31:27.000" +"KEY_PreviousStatus": "Active" +"KEY_SecurityDeposits": "1 month" +"KEY_AdditionalFeesYN": "0" +"KEY_CurrentPrice": "4950.00" +"KEY_AdditionalFees": "0.00" +"KEY_RoomDescription": "Finished, Playroom, Storage, Utilities, Washer/Dryer||Living Room, Dining Room, Kitchen, Full Bath||3 Bedrooms, Full Bath||(Attic) Storage" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_Attic": "Walkup" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_SmokingYN": "0" +"KEY_SeasonalYN": "0" +"KEY_RentSpreeYN": "1" +"KEY_RentSpreeURL": "https://apply.link/QkX14Oo" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY417943136')" +"provider_name": "One Key" +"Media": array:21 [ …21] +"ID": "17555" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4939 +post_id: "17111" +post_author: 1 +"ListingKey": "KEY417863570" +"ListingId": "L3591456" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-31T13:15:36Z" +"RFModificationTimestamp": "2025-07-31T13:20:30Z" +"ListPrice": 37.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 1000.0 +"BuildingAreaTotal": 1700.0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "22 Boradway Mews, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6369763 +"Longitude": -73.7020392 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Vanessa I. Ambrosecchia" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "131396" +"ListOfficeMlsId": "DERE71" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Calling all professional office users! Dentist / GYN / General Medical Practice Zoned for medical office. 1000sq. ft. of space in the Business district of Hewlett. This unique property is in prime and in the heart of Hewlett with front and rear entries. This building is surrounded by parking about. Close to the LIRR, JFK, Parkways" +"AttributionContact": "516-669-3700" +"BuildingAreaUnits": "Square Feet" +"CoBuyerAgentDirectPhone": "516-242-0036" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-242-0036" +"CoListAgentEmail": "darab.lawyer@elliman.com" +"CoListAgentFullName": "Darab K. Lawyer" +"CoListAgentKey": "326116972" +"CoListAgentMlsId": "100312" +"CoListOfficeKey": "326110792" +"CoListOfficeMlsId": "DERE71" +"CoListOfficeName": "Douglas Elliman Real Estate" +"CoListOfficePhone": "516-669-3700" +"CountyOrParish": "Nassau County" +"CreationDate": "2024-11-15T20:57:50.774428+00:00" +"CrossStreet": "Franklyn Avenue" +"CumulativeDaysOnMarket": 258 +"DaysOnMarket": 358 +"Directions": "https://maps.app.goo.gl/fm JCmj Ah9HDg FLZV8" +"Disclosures": array:1 [ …1] +"Electric": "Single Phase" +"ExpirationDate": "2025-11-30" +"Heating": array:2 [ …2] +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeasableArea": 1000 +"LeaseAmountFrequency": "Monthly" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-551-5276" +"ListAgentEmail": "vanessa.ambrosecchia@elliman.com" +"ListAgentKey": "326145584" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110792" +"ListOfficePhone": "516-669-3700" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2024-11-15" +"LivingAreaSource": "Public Records" +"MajorChangeTimestamp": "2025-05-09T16:26:29Z" +"MajorChangeType": "Price Change" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OnMarketDate": "2024-11-15" +"OriginalEntryTimestamp": "2024-11-15T16:40:42Z" +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3591456" +"OriginatingSystemModificationTimestamp": "2025-07-31T13:14:31Z" +"OwnerName": "1207HEW LLC" +"ParkingTotal": "2" +"PhotosChangeTimestamp": "2024-11-21T22:32:35Z" +"PhotosCount": 2 +"PostalCity": "Hewlett" +"PreviousListPrice": 3700 +"PriceChangeTimestamp": "2025-05-09T16:26:29Z" +"Sewer": array:1 [ …1] +"SourceSystemID": "3591456" +"SourceSystemKey": "3591456" +"StateOrProvince": "NY" +"StoriesTotal": "2" +"StreetName": "Broadway Mews" +"StreetNumber": "22" +"Zoning": "SP" +"KEY_Hamlet": "Hewlett" +"KEY_ElevatorYN": "0" +"KEY_SubleaseYN": "0" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "37.00" +"KEY_PermittedUses": "Business,Mixed,Office,Retail" +"KEY_AdditionalFees": "0.00" +"KEY_LeasePriceUnit": "Per SqFt" +"KEY_NumOf1BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf4BedRooms": "0" +"KEY_AdditionalFeesYN": "0" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_NumberOfTailBoards": "0" +"KEY_OverheadDoorHeight": "8" +"KEY_OriginatingSystemTimestamp": "2024-11-20T12:36:04.000" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "0.02176" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "0.02176" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY417863570')" +"provider_name": "One Key" +"Media": array:2 [ …2] +"ID": "17111" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4912 +post_id: "22626" +post_author: 1 +"ListingKey": "KEY417736118" +"ListingId": "L3589242" +"PropertyType": "Residential Income" +"PropertySubType": "Duplex" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-03-01T05:16:38Z" +"RFModificationTimestamp": "2025-03-01T05:18:48Z" +"ListPrice": 1040000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 2 +"BedroomsTotal": 0 +"LotSizeArea": 0.23 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1734 Hancock Street, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.70004955 +"Longitude": -73.903861002066 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Elana Magreli" +"ListOfficeName": "Real Broker NY LLC" +"ListAgentMlsId": "173422" +"ListOfficeMlsId": "HOWO01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This unusually large mother daughter set up feels like a three-family with its spacious, updated layout. It features a modern open design and includes a separate entrance to a sizable basement, offering additional living space, 2 car garage, oversized yard, fully updated and ready to enjoy. Located on a quiet, tree-lined street, this property combines comfort and privacy, making it an ideal choice for families or investors. Live in comfort and collect a monthly income or can be combined in multiple ways." +"AttributionContact": "516-295-1357" +"Basement": array:2 [ …2] +"BasementYN": true +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-11-04T20:48:50.124654+00:00" +"CrossStreet": "Prospect Ave" +"CumulativeDaysOnMarket": 117 +"DaysOnMarket": 117 +"ExpirationDate": "2025-03-01" +"FireplacesTotal": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "917-204-6255" +"ListAgentEmail": "elanamagreli@gmail.com" +"ListAgentKey": "326184433" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112133" +"ListOfficePhone": "855-450-0442" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-11-04" +"LotSizeDimensions": "50x200" +"LotSizeSquareFeet": 10000 +"MajorChangeTimestamp": "2025-03-01T05:15:13Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MlsStatus": "Expired" +"NumberOfSeparateElectricMeters": 1 +"NumberOfSeparateGasMeters": 1 +"NumberOfUnitsTotal": "2" +"OffMarketDate": "2025-03-01" +"OnMarketDate": "2024-11-04" +"OriginalEntryTimestamp": "2024-11-04T19:45:20Z" +"OriginalListPrice": 1200000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3589242" +"OriginatingSystemModificationTimestamp": "2025-03-01T05:15:13Z" +"OwnerName": "1734 Hancock St Corp" +"ParcelNumber": "2089-42-171-00-0075-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2024-11-05T17:58:56Z" +"PhotosCount": 15 +"PostalCity": "Hewlett" +"PreviousListPrice": 1079000 +"PriceChangeTimestamp": "2024-12-20T00:08:38Z" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "917-204-6255" +"SourceSystemID": "3589242" +"SourceSystemKey": "3589242" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-03-01T05:15:13Z" +"StreetName": "Hancock" +"StreetNumber": "1734" +"StreetNumberNumeric": "1734" +"StreetSuffix": "Street" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "23000" +"TaxBlock": "171" +"TaxLot": "75" +"WaterSource": array:1 [ …1] +"KEY_AdditionalParcelYN": "0" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.86667" +"KEY_OriginatingSystemTimestamp": "2024-11-04T15:01:01.000" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_CurrentPrice": "1040000.00" +"KEY_AdditionalFees": "0.00" +"KEY_NumberOfKitchens": "2" +"KEY_RoomDescription": "2 bedroom's - living room, dining room, kitchen||2 bedroom's - living room, dining room, kitchen||fully finished" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_Attic": "None" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_SeasonalYN": "0" +"KEY_RentSpreeYN": "0" +"KEY_TaxSection": "42" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY417736118')" +"provider_name": "One Key" +"Media": array:15 [ …15] +"ID": "22626" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4941 +post_id: "18227" +post_author: 1 +"ListingKey": "KEY417295906" +"ListingId": "L3588441" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-04-02T04:11:43Z" +"RFModificationTimestamp": "2025-04-02T04:17:51Z" +"ListPrice": 1650000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.17 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "395 Serena Road, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.64056605 +"Longitude": -73.70770615 +"YearBuilt": 1923 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jennifer Sanchez" +"ListOfficeName": "EXP Realty" +"ListAgentMlsId": "204208" +"ListOfficeMlsId": "EXP01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": ""Step into opportunity with this charming and spacious 5-bedroom, 2-bath Colonial in School District #14! Currently vacant, this home has two electric meters making it a fantastic investment. The main level features an enclosed porch, formal living and dining rooms, a newly updated eat-in kitchen, three bedrooms, and a renovated bath. The second floor offers two more bedrooms, a bath, a living room, and potential for a multi-generational setup. The basement is being extended to over 9 feet, opening up endless possibilities for future use-imagine the creative options! With its prime location near schools, medical offices, and shops, this incredible opportunity won't last. Act fast!" Pictures Coming Soon!!!, Additional information: Interior Features:Lr/Dr" +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "888-276-0630" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuyerOfficeAOR": "LIBOR" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-10-30T21:21:33.164519+00:00" +"CrossStreet": "William St" +"CumulativeDaysOnMarket": 154 +"DaysOnMarket": 154 +"ElementarySchool": "Franklin Early Childhood Center" +"ExpirationDate": "2025-04-02" +"Fencing": array:2 [ …2] +"Flooring": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "888-276-0630" +"ListAgentEmail": "jensanchez459@gmail.com" +"ListAgentKey": "326213655" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111281" +"ListOfficePhone": "888-276-0630" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-10-30" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeDimensions": "60x106" +"LotSizeSquareFeet": 7231 +"MajorChangeTimestamp": "2025-04-02T04:11:21Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MlsStatus": "Expired" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2025-04-02" +"OnMarketDate": "2024-10-30" +"OriginalEntryTimestamp": "2024-10-30T20:49:26Z" +"OriginalListPrice": 1650000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3588441" +"OriginatingSystemModificationTimestamp": "2025-04-02T04:11:21Z" +"OwnerName": "Khanimov" +"ParcelNumber": "2089-39-609-00-0118-0" +"ParkingFeatures": array:2 [ …2] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-11-06T07:16:37Z" +"PhotosCount": 8 +"PostalCity": "Hewlett" +"RoomsTotal": "9" +"ShowingContactPhone": "516-588-0544" +"SourceSystemID": "3588441" +"SourceSystemKey": "3588441" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-04-02T04:11:21Z" +"StreetName": "Serena" +"StreetNumber": "395" +"StreetNumberNumeric": "395" +"StreetSuffix": "Road" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "19338" +"TaxBlock": "609" +"TaxLot": "118" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_OriginatingSystemTimestamp": "2024-11-05T18:15:47.000" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_CurrentPrice": "1650000.00" +"KEY_AdditionalFees": "0.00" +"KEY_NumberOfKitchens": "2" +"KEY_RoomDescription": "LR,DR,EIK, BR,BR,BR Bth||LR,BR,BR,Bth||Unfinished Bsmt w/OSE," +"KEY_Hamlet": "Hewlett" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_Attic": "None" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_SeasonalYN": "0" +"KEY_RentSpreeYN": "0" +"KEY_ContractPrice": "750000.00" +"KEY_TaxSection": "39" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY417295906')" +"provider_name": "One Key" +"Media": array:8 [ …8] +"ID": "18227" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4938 +post_id: "18060" +post_author: 1 +"ListingKey": "KEY417294083" +"ListingId": "L3588384" +"PropertyType": "Residential" +"PropertySubType": "Stock Cooperative" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-05-01T04:14:40Z" +"RFModificationTimestamp": "2025-05-01T04:16:06Z" +"ListPrice": 249000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 886.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1395 Broadway # A-7, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.752700230769 +"Longitude": -73.987247076923 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lori Schlesinger" +"ListOfficeName": "Lori & Associates LI Realty" +"ListAgentMlsId": "87462" +"ListOfficeMlsId": "LORA01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Garden Style Apartment located in a well-maintained building in the desirable Hewlett Park Co-op. Second Floor unit, Renovated Kitchen, New bathroom, 2 window units but there are 3 AC wall sleeves. Garage Parking available at an additional Fee. Free Storage. Large Laundry Room in the Basement. Walk to all., Additional information: Appearance: Excellent, Interior Features: Efficiency Kitchen, separate Dinette, Lr/Dr, Bedroom w/good closets, New bathroom.....Júnior 4 unit." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AssociationFeeIncludes": array:6 [ …6] +"AssociationPhone": "212-340-9376" +"AttributionContact": "516-791-8300" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 1 +"BuilderModel": "2 Bedroom 1 Bath" +"BuildingName": "B" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-10-30T18:16:03.131980+00:00" +"CrossStreet": "E. Rockaway Rd" +"CumulativeDaysOnMarket": 183 +"DaysOnMarket": 183 +"Directions": "Peninsula Blvd to Broadway" +"ElementarySchool": "Ogden Elementary School" +"ExpirationDate": "2025-05-01" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"Inclusions": ", Dishwasher, Microwave, Oven/Range, Refrigerator" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentEmail": "loriandassociates@gmail.com" +"ListAgentKey": "326247724" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113285" +"ListOfficePhone": "516-791-8300" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2024-10-30" +"LotFeatures": array:3 [ …3] +"MaintenanceExpense": 1198 +"MajorChangeTimestamp": "2025-05-01T04:14:32Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MlsStatus": "Expired" +"OffMarketDate": "2025-05-01" +"OnMarketDate": "2024-10-30" +"OriginalEntryTimestamp": "2024-10-30T17:48:52Z" +"OriginalListPrice": 269000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3588384" +"OriginatingSystemModificationTimestamp": "2025-05-01T04:14:32Z" +"OwnerName": "Castor" +"ParkingFeatures": array:3 [ …3] +"ParkingTotal": "1" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-11-18T17:23:37Z" +"PhotosCount": 16 +"PostalCity": "Hewlett" +"PreviousListPrice": 265000 +"PriceChangeTimestamp": "2025-02-03T15:12:40Z" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-791-8300" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3588384" +"SourceSystemKey": "3588384" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-05-01T04:14:32Z" +"StoriesTotal": "2" +"StreetName": "Broadway" +"StreetNumber": "1395" +"StreetNumberNumeric": "1395" +"SubdivisionName": "Hewlett Park" +"SyndicateTo": array:1 [ …1] +"UnitNumber": "A-7" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeeFrequency": "Monthly" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_AdditionalFees": "0.00" +"KEY_RATIO_CurrentPrice_By_LivingArea": "281.03837" +"KEY_AdditionalFeeDescription": "Parking Charge" +"KEY_SmokingYN": "0" +"KEY_SeasonalYN": "0" +"KEY_ApprovalRequiredYN": "1" +"KEY_FlipTaxYN": "1" +"KEY_EstimatedMaintenance": "1235" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.92565" +"KEY_OriginatingSystemTimestamp": "2024-10-30T14:09:02.000" +"KEY_CurrentPrice": "249000.00" +"KEY_RoomDescription": "Foyer, Lr/Dr, 2 Br's, 1 New Bath" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_Attic": "None" +"KEY_NumOf3BedRooms": "0" +"KEY_EstimatedMMDeduction": "65" +"KEY_ParkingFee": "100" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_RentSpreeYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "281.03837" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY417294083')" +"provider_name": "One Key" +"Media": array:16 [ …16] +"ID": "18060" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4937 +post_id: "17546" +post_author: 1 +"ListingKey": "KEY416041434" +"ListingId": "L3584804" +"PropertyType": "Business Opportunity" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-23T00:55:36Z" +"RFModificationTimestamp": "2025-04-23T00:57:30Z" +"ListPrice": 165000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 3325.0 +"BuildingAreaTotal": 3325.0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1241 Broadway, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.636859 +"Longitude": -73.7024913 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kulaporn Sumanon" +"ListOfficeName": "One Realty Global Corp" +"ListAgentMlsId": "219900" +"ListOfficeMlsId": "ORGL01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Great Opportunity! Great Condition Restaurant for Sale in Long Island, NY with very big space 6,650 sq. ft. / Retail restaurant space size 3,325 sq. ft. and Basement size 3,325 sq ft./ 83 Seats / Great condition and clean / Active Beer & Wine License / Current Monthly Rent $9,400 / Key money $165,000 (Negotiable) / Close to LIRR, Additional information: Business Located at Broadway, Hewlett, NY 11557/ Dining seats:83 / Lease Deposit 3 months/ Contact for showing 929-924-5955" +"AttributionContact": "917-679-8288" +"BusinessName": "Thai Restaurant (dine-in and togo)" +"BusinessType": "Restaurant" +"CountyOrParish": "Nassau County" +"CreationDate": "2024-10-12T00:58:27.046257+00:00" +"CumulativeDaysOnMarket": 193 +"DaysOnMarket": 393 +"ExpirationDate": "2025-12-31" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseExpiration": "2026-01-01" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "929-924-5955" +"ListAgentEmail": "faiwork.space@gmail.com" +"ListAgentKey": "326228881" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114345" +"ListOfficePhone": "917-679-8288" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-10-11" +"LivingAreaSource": "Plans" +"MajorChangeTimestamp": "2025-04-23T00:54:15Z" +"MajorChangeType": "Price Change" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2024-10-11" +"OriginalEntryTimestamp": "2024-10-11T22:49:14Z" +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3584804" +"OriginatingSystemModificationTimestamp": "2025-04-23T00:54:15Z" +"OwnerName": "Sawangchit" +"PhotosChangeTimestamp": "2024-11-02T03:08:59Z" +"PhotosCount": 10 +"PostalCity": "Hewlett" +"PreviousListPrice": 150000 +"PriceChangeTimestamp": "2025-04-23T00:54:15Z" +"ShowingContactPhone": "929-924-5955" +"SourceSystemID": "3584804" +"SourceSystemKey": "3584804" +"StateOrProvince": "NY" +"StreetName": "Broadway" +"StreetNumber": "1241" +"StreetNumberNumeric": "1241" +"Zoning": "Hewlett" +"KEY_OpenHousePublicCount": "0" +"KEY_RealEstateIncludedYN": "1" +"KEY_OriginatingSystemTimestamp": "2024-10-11T20:34:03.000" +"KEY_AdditionalFeesYN": "0" +"KEY_CurrentPrice": "165000.00" +"KEY_AdditionalFees": "0.00" +"KEY_ConcessionInPrice": "150000.00" +"KEY_NumberOfTailBoards": "0" +"KEY_MlsMajorChangeType": "Price Increase" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "49.62406" +"KEY_NumOf4BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_OpenHouseCount": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "49.62406" +"KEY_ConcessionYN": "1" +"KEY_PermittedUses": "Food Services" +"KEY_NumOf1BedRooms": "0" +"KEY_SeasonalYN": "0" +"KEY_RentSpreeYN": "0" +"KEY_DescriptionOfBusiness": "Thai restaurant" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY416041434')" +"provider_name": "One Key" +"Media": array:10 [ …10] +"ID": "17546" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4911 +post_id: "18206" +post_author: 1 +"ListingKey": "KEY406706805" +"ListingId": "L3582076" +"PropertyType": "Residential" +"PropertySubType": "Stock Cooperative" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-06-01T04:16:38Z" +"RFModificationTimestamp": "2025-06-01T04:17:47Z" +"ListPrice": 269000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "9 Everit Avenue # A10,11, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.64005411809 +"Longitude": -73.699026967777 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nadav Kauderer CBR" +"ListOfficeName": "Century 21 KR Realty" +"ListAgentMlsId": "163016" +"ListOfficeMlsId": "NATN01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This sunny and spacious 2-bedroom, 2-bathroom co-op offers a bright and inviting living space. The open-concept design seamlessly blends a large living room and a formal dining room, perfect for entertaining or relaxing. Hardwood floors flow throughout, complemented by recessed hi-hat lighting and the comfort of four wall-mounted air conditioning units. The unit features the convenience of a private in-unit laundry, as well as a bonus private workshop for added flexibility. Enjoy the luxury of two assigned parking spaces-one outdoors and one in a garage-and take advantage of the extra-large storage unit, providing ample space for all your belongings., Additional information: Appearance:GOOD" +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Park,Trash" +"AssociationFeeIncludes": array:6 [ …6] +"AttributionContact": "516-837-7558" +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuilderModel": "2 Bedroom" +"CommonWalls": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-09-30T19:48:08.806132+00:00" +"CrossStreet": "Broadway" +"CumulativeDaysOnMarket": 236 +"DaysOnMarket": 236 +"Directions": "Take Broadway, Turn right on Everit Ave." +"ElementarySchool": "Franklin Early Childhood Center" +"ExpirationDate": "2025-06-01" +"Flooring": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"Inclusions": ",A/C Units,Dishwasher,Dryer,Oven/Range,Refrigerator,Screens" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-837-7558" +"ListAgentEmail": "nadav@c21kr.com" +"ListAgentKey": "326174840" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113995" +"ListOfficePhone": "516-837-7558" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-09-30" +"LivingAreaSource": "Other" +"LotFeatures": array:3 [ …3] +"MaintenanceExpense": 2601 +"MajorChangeTimestamp": "2025-06-01T04:14:49Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MlsStatus": "Expired" +"OffMarketDate": "2025-06-01" +"OnMarketDate": "2024-09-30" +"OriginalEntryTimestamp": "2024-09-30T18:55:10Z" +"OriginalListPrice": 269000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3582076" +"OriginatingSystemModificationTimestamp": "2025-06-01T04:14:49Z" +"OwnerName": "Fischer" +"ParkingFeatures": array:3 [ …3] +"ParkingTotal": "2" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-12-30T20:17:36Z" +"PhotosCount": 11 +"PostalCity": "Hewlett" +"PropertyAttachedYN": true +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-837-7558" +"SourceSystemID": "3582076" +"SourceSystemKey": "3582076" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-06-01T04:14:49Z" +"StoriesTotal": "2" +"StreetName": "Everit" +"StreetNumber": "9" +"StreetNumberNumeric": "9" +"StreetSuffix": "Avenue" +"SubdivisionName": "Hewlett House" +"SyndicateTo": array:1 [ …1] +"UnitNumber": "A10,11" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"KEY_OpenHousePublicCount": "0" +"KEY_EstimatedMaintenance": "2601" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_OriginatingSystemTimestamp": "2024-09-30T15:06:29.000" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_CurrentPrice": "269000.00" +"KEY_AdditionalFees": "0.00" +"KEY_RoomDescription": "2 BR, Living Room,Formal DR, Kitchen, 2 full Bathroom,Washer/Dryer, workshop, lots of closets" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_MlsDistrictCode": "Hewlett" +"KEY_Attic": "None" +"KEY_NumOf3BedRooms": "0" +"KEY_ParkingFee": "0" +"KEY_OpenHouseCount": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_SmokingYN": "0" +"KEY_SeasonalYN": "0" +"KEY_RentSpreeYN": "0" +"KEY_ApprovalRequiredYN": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY406706805')" +"provider_name": "One Key" +"Media": array:11 [ …11] +"ID": "18206" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4910 +post_id: "18259" +post_author: 1 +"ListingKey": "KEY406588837" +"ListingId": "L3579883" +"PropertyType": "Residential" +"PropertySubType": "Stock Cooperative" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-11T18:46:36Z" +"RFModificationTimestamp": "2025-10-11T18:51:10Z" +"ListPrice": 299000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1390 Broadway # 116, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6408794 +"Longitude": -73.6983536 +"YearBuilt": 1965 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ronnie B. Gerber" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "125107" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "MOTIVATED SELLER! Spacious Junior 4 Coop Garden Apt in Prestigious Hewlett Townhouse Offering Luxurious Lifestyle in the Five Towns with Welcoming Full Service 24/7 Doorman, Valet Parking & Elevator. This Lovely Unit Features an Entry Foyer, Large Living Room/Dining Room, Kitchen with a Breakfast Nook(Can also be Enclosed as an Office or BR), Bedroom with Updated Ensuite Bath as well as Second Renovated Full Bath. 2 Walk in Closets.Terrace With Courtyard View, W/D in Unit. Newly Redone Heated in Ground Community Pool & Patio Creates an Oasis to Sit & Relax. Card/Party Room is Perfect to Meet Friends & Private Spacious Storage Rm. Garage Pkg $85, Outdoor Pkg $45. Great Location Near Shops, LIRR, Transportation & Houses of Worship. Maintenance Includes Taxes, Heat & Water., Additional information: Appearance:Excellent,Interior Features:Efficiency Kitchen" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Door Person,Elevator(s),Park,Trash" +"AssociationFeeIncludes": array:8 [ …8] +"AssociationPhone": "631-293-2997" +"AttributionContact": "516-623-4500" +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuilderModel": "Junior 4" +"BuyerOfficeAOR": "LIBOR" +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-09-19T15:32:42.168141+00:00" +"CrossStreet": "E. Rockaway Rd" +"CumulativeDaysOnMarket": 298 +"DaysOnMarket": 326 +"Directions": "Broadway Near E. Rockaway Rd" +"ElementarySchool": "Hewlett Elementary School" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"ExpirationDate": "2025-12-30" +"ExteriorFeatures": array:1 [ …1] +"Flooring": array:1 [ …1] +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"Inclusions": ", Dishwasher, Dryer, Oven/Range, Refrigerator, Washer" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-238-4299" +"ListAgentEmail": "ronnie.gerber@elliman.com" +"ListAgentKey": "326139999" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-09-19" +"LivingAreaSource": "Other" +"LotFeatures": array:2 [ …2] +"MaintenanceExpense": 2093 +"MajorChangeTimestamp": "2025-10-11T18:45:25Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2024-09-19" +"OriginalEntryTimestamp": "2024-09-19T04:00:00Z" +"OriginalListPrice": 359000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3579883" +"OriginatingSystemModificationTimestamp": "2025-10-11T18:45:25Z" +"OwnerName": "Genkin" +"ParkingFeatures": array:2 [ …2] +"PatioAndPorchFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-11T18:46:36Z" +"PhotosCount": 16 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Hewlett" +"PreviousListPrice": 325000 +"PriceChangeTimestamp": "2025-10-11T18:45:25Z" +"RoomsTotal": "4" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-623-4500" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3579883" +"SourceSystemKey": "3579883" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-07-09T16:36:06Z" +"StoriesTotal": "2" +"StreetName": "Broadway" +"StreetNumber": "1390" +"StreetNumberNumeric": "1390" +"SubdivisionName": "Hewlett Townhouse" +"SyndicateTo": array:1 [ …1] +"TaxBlock": "78" +"TaxLot": "29" +"UnitNumber": "116" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"YearBuiltEffective": 2014 +"KEY_Attic": "None" +"KEY_Hamlet": "Hewlett" +"KEY_FlipTaxYN": "1" +"KEY_SmokingYN": "0" +"KEY_ParkingFee": "45" +"KEY_TaxSection": "39" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "299000.00" +"KEY_ContractPrice": "325000.00" +"KEY_FlipTaxAmount": "2% buyer/1% seller" +"KEY_AdditionalFees": "0.00" +"KEY_NumOf1BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf4BedRooms": "0" +"KEY_OpenHouseCount": "0" +"KEY_PreviousStatus": "Pending" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_RentingAllowedYN": "0" +"KEY_ApprovalRequiredYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_EstimatedMaintenance": "2093" +"KEY_OpenHousePublicCount": "0" +"KEY_MinimumPctDownPayment": "20" +"KEY_OriginatingSystemTimestamp": "2024-09-19T11:15:23.000" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.83287" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY406588837')" +"provider_name": "One Key" +"Media": array:16 [ …16] +"ID": "18259" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4909 +post_id: "22292" +post_author: 1 +"ListingKey": "KEY3578727" +"ListingId": "L3578727" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-12-01T05:26:27Z" +"RFModificationTimestamp": "2024-12-01T05:33:42Z" +"ListPrice": 4500.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.14 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hewlett" +"PostalCode": "11557" +"UnparsedAddress": "19 Geoffrey Lane, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.862281979592 +"Longitude": -73.612497061224 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Milagros H Billitzer" +"ListOfficeName": "Coldwell Banker American Homes" +"ListAgentMlsId": "193394" +"ListOfficeMlsId": "BRMN14" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "SHORT TERM HOUSE RENTAL- Available immediately. Rent now until April 30, 2025. Quiet, Cul de sac location. Over 2500 square feet of living space. Beautiful 4 bedroom 3 full bath house. School district 14. Freshly painted. Hardwood floors throughout, Central AC, lots of natural light with skylights, Eat in kitchen, HUGE Master en suite with two walk in closets. Large fenced in backyard. Quiet street in the heart of Hewlett." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AvailabilityDate": "2024-09-15" +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Nassau" +"CreationDate": "2024-10-12T16:11:19.629857+00:00" +"CrossStreet": "Newport" +"Directions": "off of Newport drive" +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"EntryLevel": 1 +"ExpirationDate": "2024-11-30" +"Fencing": array:1 [ …1] +"Flooring": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"Inclusions": "Dishwasher, Dryer, Refrigerator, Washer" +"InteriorFeatures": array:4 [ …4] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseConsideredYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentEmail": "millie@cbamhomes.com" +"ListAgentFirstName": "Milagros" +"ListAgentKey": "193394" +"ListAgentLastName": "Billitzer" +"ListAgentPreferredPhone": "516-665-2000" +"ListOfficeKey": "42452014" +"ListOfficePhone": "516-665-2000" +"ListPriceLow": 4500 +"ListingContractDate": "2024-09-13" +"LotFeatures": array:2 [ …2] +"LotSizeAcres": 0.14 +"LotSizeDimensions": "60x100" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 6060 +"MLSAreaMinor": "6" +"MajorChangeTimestamp": "2024-12-01T05:10:45Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlsStatus": "U" +"OffMarketDate": "2024-11-30" +"OnMarketDate": "2024-09-13" +"OriginalEntryTimestamp": "2024-09-13T20:32:35Z" +"OriginalListPrice": 4500 +"OriginatingSystemID": "M00000489" +"OriginatingSystemKey": "3578727" +"OriginatingSystemModificationTimestamp": "2024-12-01T05:10:45Z" +"OwnerName": "Mallik" +"ParcelNumber": "2089-39-576-00-0021-0" +"ParkingFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-09-13T21:23:24Z" +"PhotosCount": 12 +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "917-703-3902" +"SourceSystemID": "M00000489" +"SourceSystemKey": "3578727" +"SourceSystemName": "OneKey™ MLS" +"SpecialListingConditions": array:2 [ …2] +"StateOrProvince": "NY" +"StreetName": "Geoffrey" +"StreetNumber": "19" +"StreetSuffix": "Lane" +"SyndicateTo": array:2 [ …2] +"SyndicationRemarks": "SHORT TERM HOUSE RENTAL- Available immediately. Rent now until April 30, 2025. Quiet, Cul de sac location. Over 2500 square feet of living space. Beautiful 4 bedroom 3 full bath house. School district 14. Freshly painted. Hardwood floors throughout, Central AC, lots of natural light with skylights, Eat in kitchen, HUGE Master en suite with two walk in closets. Large fenced in backyard. Quiet street in the heart of Hewlett." +"Township": "Hempstead" +"WaterSource": array:1 [ …1] +"KEY_HighPriceDollars": "4500" +"KEY_HotWater": "Gas Stand Alone" +"KEY_OfferPresentation": "Can be Present" +"KEY_AttributionContact": "516-665-2000" +"KEY_HoldEndDate": "2024-11-30" +"KEY_HoldStartDate": "2024-09-26" +"KEY_WholeHouseRentalYN": "1" +"KEY_LegalRentalYN": "1" +"KEY_FloodZoneReportYN": "0" +"KEY_LeaseTerms": "6-12 Month" +"KEY_OriginatingSystemOfficeKey": "42452014" +"KEY_DPRYN": "0" +"KEY_ModificationsExclusions": "None" +"KEY_DisplayOnVOWYN": "1" +"KEY_ListMainOfficeMlsId": "BRMN01" +"KEY_MinorChangeTimestamp": "2024-12-01T00:00:00-05:00" +"KEY_SmokingYN": "0" +"KEY_RentSpreeYN": "1" +"KEY_RentSpreeURL": "https://apply.link/1JTNme0" +"KEY_SourceSystemModificationTimestamp": "2024-12-01T00:24:31-05:00" +"KEY_RentType1": "Flexible" +"KEY_AlternateMlsNumber": "3578727" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY3578727')" +"provider_name": "One Key" +"Media": array:12 [ …12] +"ID": "22292" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4908 +post_id: "17197" +post_author: 1 +"ListingKey": "KEY406407359" +"ListingId": "L3575314" +"PropertyType": "Commercial Sale" +"PropertySubType": "Retail" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-05-06T21:18:36Z" +"RFModificationTimestamp": "2025-05-06T21:19:01Z" +"ListPrice": 1650000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 11330.0 +"LivingArea": 0 +"BuildingAreaTotal": 3888.0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1483 Broadway, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.7554925 +"Longitude": -73.986384130435 +"YearBuilt": 1957 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Yinzhu Jin" +"ListOfficeName": "New Group Realty Inc" +"ListAgentMlsId": "174397" +"ListOfficeMlsId": "HUZH01" +"OriginatingSystemName": "OneKey" +"AttributionContact": "718-255-9100" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "718-909-9596" +"BuyerAgentEmail": "Yinzhu Jin@live.com" +"BuyerAgentFullName": "Yinzhu Jin" +"BuyerAgentKey": "326185351" +"BuyerAgentMlsId": "174397" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326112207" +"BuyerOfficeMlsId": "HUZH01" +"BuyerOfficeName": "New Group Realty Inc" +"BuyerOfficePhone": "718-255-9100" +"CountyOrParish": "Nassau County" +"CreationDate": "2024-08-29T17:59:05.913010+00:00" +"CrossStreet": "Broadway" +"CumulativeDaysOnMarket": 250 +"DaysOnMarket": 250 +"ExpirationDate": "2025-08-31" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "718-909-9596" +"ListAgentEmail": "Yinzhu Jin@live.com" +"ListAgentKey": "326185351" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326112207" +"ListOfficePhone": "718-255-9100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-08-29" +"LotSizeDimensions": "112x104" +"LotSizeSquareFeet": 11330 +"MajorChangeTimestamp": "2025-05-06T21:16:55Z" +"MajorChangeType": "Pending" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2025-05-06" +"OnMarketDate": "2024-08-29" +"OriginalEntryTimestamp": "2024-08-29T17:20:24Z" +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3575314" +"OriginatingSystemModificationTimestamp": "2025-05-06T21:16:55Z" +"OwnerName": "Power 1101 Realty Corp" +"ParcelNumber": "2089-42-080-00-0157-0" +"PhotosChangeTimestamp": "2024-11-27T04:34:36Z" +"PhotosCount": 9 +"PostalCity": "Hewlett" +"PreviousListPrice": 1800000 +"PriceChangeTimestamp": "2025-02-04T22:49:45Z" +"PropertyAttachedYN": true +"PurchaseContractDate": "2025-05-06" +"SourceSystemID": "3575314" +"SourceSystemKey": "3575314" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-05-06T21:16:55Z" +"StreetName": "Broadway" +"StreetNumber": "1483" +"StreetNumberNumeric": "1483" +"TaxAnnualAmount": "35193" +"TaxBlock": "80" +"TaxLot": "157" +"Zoning": "X" +"KEY_OpenHousePublicCount": "0" +"KEY_OriginatingSystemTimestamp": "2024-08-29T13:34:57.000" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_CurrentPrice": "1650000.00" +"KEY_AdditionalFees": "0.00" +"KEY_NumberOfTailBoards": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "424.38272" +"KEY_NumOf4BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_OpenHouseCount": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "424.38272" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_SeasonalYN": "0" +"KEY_RentSpreeYN": "0" +"KEY_ContractPrice": "1475000.00" +"KEY_TaxSection": "42" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY406407359')" +"provider_name": "One Key" +"Media": array:9 [ …9] +"ID": "17197" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4907 +post_id: "17366" +post_author: 1 +"ListingKey": "KEY406362317" +"ListingId": "L3574222" +"PropertyType": "Residential" +"PropertySubType": "Stock Cooperative" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-06-01T04:16:37Z" +"RFModificationTimestamp": "2025-06-01T04:17:48Z" +"ListPrice": 749000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1390 Broadway # 118, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.752605615385 +"Longitude": -73.987270538462 +"YearBuilt": 1965 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ronnie B. Gerber" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "125107" +"ListOfficeMlsId": "DERE28" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Rare Opportunity to Own a 3 Bedroom, 2.5 Bath Duplex Coop Apt in Prestigious Hewlett Townhouse. Easy Living with No Exterior Concerns! Entry Foyer Welcomes You Into This Large Corner Unit Featuring a Spacious Living Room, Formal Dining Room, Eat in Kitchen, Powder Rm & Enclosed Porch. Upper Level Boasts Primary Ste with Bathroom & Another Enclosed Terrace, 2 Additional Bedroom & Full Bath. W/D in Apt. Chairlift on Staircase. Hardwood Floors & Crown Moldings.This Elevator Building Has Full Service 24 Hr Doorman, Valet Parking,, A Newly Renovated Htd IG Pool & Patio That Creates a Beautiful Oasis to Sit & Relax, A Card/Party Rm to Meet Friends & Private Storage Area. Indoor Pkg $85, Outdoor Pkg $45. Great Location Near Shops, LIRR, Transportation & Houses of Worship.Maintenance Includes Taxes, Heat & Water., Additional information: Appearance:Excellent" +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Elevator(s),Park,Door Person,Trash" +"AssociationFeeIncludes": array:7 [ …7] +"AssociationPhone": "631-293-2997" +"AttributionContact": "516-623-4500" +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuilderModel": "3 Bedroom Duplex" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-08-23T14:26:01.713108+00:00" +"CrossStreet": "E. Rockaway Rd" +"CumulativeDaysOnMarket": 282 +"DaysOnMarket": 282 +"Directions": "On Broadway Near East Rockaway Rd" +"ElementarySchool": "Hewlett Elementary School" +"EntryLevel": 1 +"ExpirationDate": "2025-06-01" +"Flooring": array:1 [ …1] +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"Inclusions": ", Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer" +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-238-4299" +"ListAgentEmail": "ronnie.gerber@elliman.com" +"ListAgentKey": "326139999" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110766" +"ListOfficePhone": "516-623-4500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-08-23" +"LivingAreaSource": "Other" +"LotFeatures": array:5 [ …5] +"MaintenanceExpense": 3393 +"MajorChangeTimestamp": "2025-06-01T04:15:05Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MlsStatus": "Expired" +"OffMarketDate": "2025-06-01" +"OnMarketDate": "2024-08-23" +"OriginalEntryTimestamp": "2024-08-23T04:00:00Z" +"OriginalListPrice": 799000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3574222" +"OriginatingSystemModificationTimestamp": "2025-06-01T04:15:05Z" +"OwnerName": "Judith Weissman Living Trust" +"ParkingFeatures": array:2 [ …2] +"PatioAndPorchFeatures": array:2 [ …2] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-11-02T02:19:04Z" +"PhotosCount": 17 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Hewlett" +"PreviousListPrice": 799000 +"PriceChangeTimestamp": "2024-11-13T20:37:08Z" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-623-4500" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3574222" +"SourceSystemKey": "3574222" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-06-01T04:15:05Z" +"StoriesTotal": "2" +"StreetName": "Broadway" +"StreetNumber": "1390" +"StreetNumberNumeric": "1390" +"SubdivisionName": "Hewlett Townhouse" +"SyndicateTo": array:1 [ …1] +"TaxBlock": "78" +"TaxLot": "29" +"UnitNumber": "118" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_DownPaymentResourceYN": "1" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_MinimumPctDownPayment": "20" +"KEY_AdditionalFees": "0.00" +"KEY_SmokingYN": "0" +"KEY_SeasonalYN": "0" +"KEY_ApprovalRequiredYN": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_FlipTaxYN": "1" +"KEY_FlipTaxAmount": "2% Buyer/1% Seller" +"KEY_EstimatedMaintenance": "3393" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.93742" +"KEY_OriginatingSystemTimestamp": "2024-11-13T15:37:28.000" +"KEY_CurrentPrice": "749000.00" +"KEY_RoomDescription": "EF, Spacious Living Room, Formal Dining Rm, Eat in Kitchen, Powder Rm, Encl Terrace||Prmary Bedroom/Bath/Enclosed Terrace, Bedroom, Bedroom, Bath, W/D" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_Attic": "None" +"KEY_NumOf3BedRooms": "0" +"KEY_RentingAllowedYN": "0" +"KEY_ParkingFee": "45" +"KEY_OpenHouseCount": "1" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_RentSpreeYN": "0" +"KEY_TaxSection": "39" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY406362317')" +"provider_name": "One Key" +"Media": array:17 [ …17] +"ID": "17366" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4906 +post_id: "22470" +post_author: 1 +"ListingKey": "KEY326322113" +"ListingId": "L3573514" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-02-07T05:12:37Z" +"RFModificationTimestamp": "2025-02-07T05:16:49Z" +"ListPrice": 965000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.09 +"LivingArea": 1905.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1274 Webster Street, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6423432 +"Longitude": -73.70431805 +"YearBuilt": 1925 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Elia Ridi" +"ListOfficeName": "Douglas Elliman Real Estate" +"ListAgentMlsId": "500191" +"ListOfficeMlsId": "DERE23" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Total renovation and expansion only 5 years ago. Modern open concept on first level with private rear addition encompassing primary suite including bath, WIC and office with separate entrance. new floors, new cabinets, stone counter top. 3 bedrooms on 2nd floor, one with outdoor balcony. Great location with close proximity to shopping, transportation, and park., Additional information: Appearance:mint,Interior Features:Lr/Dr" +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-354-6500" +"Basement": array:2 [ …2] +"BathroomsFull": 2 +"CoListAgentAOR": "LIBOR" +"CoListAgentEmail": "cheryl.uram@elliman.com" +"CoListAgentFullName": "Cheryl Uram" +"CoListAgentKey": "326238252" +"CoListAgentMlsId": "25992" +"CoListOfficeKey": "326110763" +"CoListOfficeMlsId": "DERE23" +"CoListOfficeName": "Douglas Elliman Real Estate" +"CoListOfficePhone": "516-354-6500" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-08-26T15:53:55.261247+00:00" +"CrossStreet": "Hewlett Pkwy" +"CumulativeDaysOnMarket": 165 +"DaysOnMarket": 165 +"Directions": "Peninsula blvd to mill rd to webster" +"ExpirationDate": "2025-02-07" +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InteriorFeatures": array:4 [ …4] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-366-9726" +"ListAgentEmail": "elia.ridi@elliman.com" +"ListAgentKey": "326239434" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110763" +"ListOfficePhone": "516-354-6500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-08-19" +"LotSizeDimensions": "40x100" +"LotSizeSquareFeet": 4000 +"MajorChangeTimestamp": "2025-02-07T05:10:50Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MlsStatus": "Expired" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2025-02-07" +"OnMarketDate": "2024-08-26" +"OriginalEntryTimestamp": "2024-08-20T18:45:20Z" +"OriginalListPrice": 990000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3573514" +"OriginatingSystemModificationTimestamp": "2025-02-07T05:10:50Z" +"OwnerName": "Riskovich" +"ParcelNumber": "2089-39-093-00-0019-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2024-11-05T17:54:57Z" +"PhotosCount": 16 +"PostalCity": "Hewlett" +"PreviousListPrice": 990000 +"PriceChangeTimestamp": "2024-10-20T20:36:19Z" +"RoomsTotal": "8" +"ShowingContactPhone": "516-366-9726" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3573514" +"SourceSystemKey": "3573514" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-02-07T05:10:50Z" +"StreetName": "Webster" +"StreetNumber": "1274" +"StreetNumberNumeric": "1274" +"StreetSuffix": "Street" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "13047.31" +"TaxBlock": "93" +"TaxLot": "19" +"WaterSource": array:1 [ …1] +"KEY_AdditionalParcelYN": "0" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_DownPaymentResourceYN": "1" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_AdditionalFees": "0.00" +"KEY_NumberOfKitchens": "1" +"KEY_RATIO_CurrentPrice_By_LivingArea": "506.56168" +"KEY_SeasonalYN": "0" +"KEY_OpenHousePublicCount": "0" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97475" +"KEY_OriginatingSystemTimestamp": "2024-12-01T14:31:52.000" +"KEY_CurrentPrice": "965000.00" +"KEY_RoomDescription": "LR/DR EIK open concept half bath primary suite down two steps with WIC and bath||3 bedrooms full bath and patio||laundry room room plus storage room" +"KEY_Hamlet": "Hewlett" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_Attic": "Unfinished" +"KEY_NumOf3BedRooms": "0" +"KEY_OpenHouseCount": "4" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "1" +"KEY_NumOf1BedRooms": "0" +"KEY_RentSpreeYN": "0" +"KEY_NumberOfHeatingZones": "2" +"KEY_TaxSection": "39" +"KEY_RATIO_ListPrice_By_LivingArea": "506.56168" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY326322113')" +"provider_name": "One Key" +"Media": array:16 [ …16] +"ID": "22470" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4905 +post_id: "18256" +post_author: 1 +"ListingKey": "KEY326299951" +"ListingId": "L3572089" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-08-08T17:06:36Z" +"RFModificationTimestamp": "2025-08-08T17:08:32Z" +"ListPrice": 759990.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.25 +"LivingArea": 2198.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11566" +"UnparsedAddress": "138 Hewlett Avenue, Merrick, Ny 11566" +"Coordinates": array:2 [ …2] +"Latitude": 40.6691611 +"Longitude": -73.551522158163 +"YearBuilt": 1927 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "William L. Kutsch" +"ListOfficeName": "Daniel Gale Sothebys Intl Rlty" +"ListAgentMlsId": "202788" +"ListOfficeMlsId": "GALE06" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Step into this charming and cozy 3BR, 1 Bath expanded Cape Cod home located in prestigious Merrick Woods, where possibilities abound. The main level features a living room, a den with elegant French doors that let in plenty of sunlight, an adjoining formal dining room, and an eat-in kitchen that's perfect for hosting events. The first level also includes two bedrooms and a full bathroom. Upstairs, there's ample storage and alternative living spaces such as a third bedroom and bonus room. The full basement is unfinished. Outside, you'll find a huge fenced-in property perfect for outdoor gatherings. There's plenty of room for a pool, garden, gazebo, fire pit, or a lush lawn. Recent upgrades include the roof, HVAC, HW heater, dehumidifier, vinyl windows, 150A electric, and PVC piping. Plus, the home offers easy expansion opportunities. There's also a two-car detached garage. With its proximity to the LIRR (less than an hour to Penn or GCM) and major highways, commuting is a breeze. You'll also have easy access to the Merrick Mall, restaurants, shopping, and all the amenities that Merrick has to offer. Welcome to your new home!, Additional information: Cooling:SEER Rating 12+,Separate Hotwater Heater:Y" +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Park" +"AttributionContact": "631-689-6980" +"Basement": array:2 [ …2] +"BathroomsFull": 1 +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-729-4788" +"BuyerAgentEmail": "deanna@longislandlegacy.com" +"BuyerAgentFullName": "Deanna Arecco" +"BuyerAgentKey": "326235933" +"BuyerAgentMlsId": "227179" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326113763" +"BuyerOfficeMlsId": "MLSH01" +"BuyerOfficeName": "Exit Realty Everyday" +"BuyerOfficePhone": "631-343-8700" +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "516-633-1188" +"CoBuyerAgentEmail": "colleen@longislandlegacy.com" +"CoBuyerAgentFullName": "Colleen Chase" +"CoBuyerAgentKey": "326207702" +"CoBuyerAgentMlsId": "198109" +"CoBuyerOfficeKey": "326113763" +"CoBuyerOfficeMlsId": "MLSH01" +"CoBuyerOfficeName": "Exit Realty Everyday" +"CoBuyerOfficePhone": "631-343-8700" +"ConstructionMaterials": array:4 [ …4] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-10-02T15:26:07.657920+00:00" +"CrossStreet": "Loines Avenue" +"CumulativeDaysOnMarket": 455 +"DaysOnMarket": 455 +"DirectionFaces": "West" +"Directions": "Sunrise Highway, north on Hewlett Avenue, past Smith, before Loines." +"ElementarySchool": "Chatterton School" +"ElementarySchoolDistrict": "Merrick" +"ExpirationDate": "2026-08-08" +"Fencing": array:1 [ …1] +"Flooring": array:2 [ …2] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Sanford H Calhoun High School" +"HighSchoolDistrict": "Bellmore-Merrick" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-428-9866" +"ListAgentEmail": "williamkutsch@danielgale.com" +"ListAgentKey": "326212256" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111550" +"ListOfficePhone": "631-689-6980" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2023-08-07" +"LivingAreaSource": "Appraiser" +"LotFeatures": array:5 [ …5] +"LotSizeDimensions": ".25" +"LotSizeSquareFeet": 10800 +"MajorChangeTimestamp": "2024-12-06T22:04:28Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Grand Avenue Middle School" +"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2024-12-06" +"OnMarketDate": "2023-08-07" +"OriginalEntryTimestamp": "2024-08-13T19:14:26Z" +"OriginalListPrice": 819990 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3572089" +"OriginatingSystemModificationTimestamp": "2025-08-08T17:04:58Z" +"OwnerName": "Estate of Szabo" +"ParcelNumber": "2089-56-098-00-0007-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-11-02T02:18:28Z" +"PhotosCount": 35 +"PostalCity": "Merrick" +"PreviousListPrice": 779990 +"PriceChangeTimestamp": "2024-11-12T15:09:34Z" +"PurchaseContractDate": "2024-12-06" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "855-746-9901" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "3572089" +"SourceSystemKey": "3572089" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2024-12-06T22:04:28Z" +"StreetName": "Hewlett" +"StreetNumber": "138" +"StreetNumberNumeric": "138" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "17423.85" +"TaxBlock": "98" +"TaxLot": "7" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"Zoning": "210" +"KEY_Attic": "Full" +"KEY_Hamlet": "Merrick" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "56" +"KEY_RentSpreeYN": "0" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "759990.00" +"KEY_ContractPrice": "749000.00" +"KEY_WaterAccessYN": "0" +"KEY_AdditionalFees": "0.00" +"KEY_NumOf1BedRooms": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_NumOf3BedRooms": "0" +"KEY_NumOf4BedRooms": "0" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalRooms": "Library/Den" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Pending" +"KEY_NumberOfHeatingZones": "1" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_OriginatingSystemTimestamp": "2024-11-20T13:21:16.000" +"KEY_RATIO_ListPrice_By_LivingArea": "345.76433" +"KEY_RATIO_CurrentPrice_By_LivingArea": "345.76433" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.92683" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY326299951')" +"provider_name": "One Key" +"Media": array:35 [ …35] +"ID": "18256" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4904 +post_id: "22459" +post_author: 1 +"ListingKey": "KEY326293181" +"ListingId": "L3571522" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-12-11T05:12:38Z" +"RFModificationTimestamp": "2024-12-11T05:13:42Z" +"ListPrice": 1799000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 7.0 +"LotSizeArea": 0.21 +"LivingArea": 4694.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "325 Serena Road, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6385016 +"Longitude": -73.706810349467 +"YearBuilt": 2019 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sara Abikzer" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "105915" +"ListOfficeMlsId": "SPH11" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to 325 Serena Road, a stunning residence rebuilt in 2020 offering both comfort and luxury in the desirable community of Hewlett, NY. This exceptional home boasts 7 generously sized bedrooms and 4.5 well-appointed bathrooms, making it an ideal choice for families seeking ample space and versatility. Each room was custom designed to set on a beautifully landscaped 80x113 lot, this property offers a perfect blend of indoor and outdoor living. The expansive layout features multiple living and entertaining areas, including a spacious family room, a formal dining room, and a cozy living room, all designed to accommodate both everyday living and special gatherings. The kitchen is a chef's delight, equipped with modern appliances, abundant cabinetry, and a large center island that invites casual dining. The master suite is a private retreat, complete with a luxurious en-suite bathroom and ample closet space. Each of the additional bedrooms provides comfort and flexibility, ideal for a growing family or guests. Outside, the well-maintained yard offers a serene setting with plenty of space for outdoor activities and relaxation. The property also includes a driveway with ample parking and a two-car garage. Located in the charming town of Hewlett, this home is close to local amenities, schools, parks, and transportation options, making it a convenient and desirable place to live. Don't miss the opportunity to make this exceptional property your new home. Schedule a viewing today to experience all that 325 Serena Road has to offer!, Additional information: Appearance:MINT,Interior Features:Guest Quarters" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Park" +"AttributionContact": "516-741-4333" +"Basement": array:1 [ …1] +"BathroomsFull": 4 +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-08-09T22:43:14.038727+00:00" +"CrossStreet": "West Broadway" +"CumulativeDaysOnMarket": 124 +"DaysOnMarket": 124 +"Directions": "West Broadway to Serena Road" +"ElementarySchool": "Ogden Elementary School" +"ExpirationDate": "2024-12-11" +"ExteriorFeatures": array:2 [ …2] +"Fencing": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InteriorFeatures": array:8 [ …8] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-984-6798" +"ListAgentEmail": "info@saraabikzer.com" +"ListAgentKey": "326122232" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115719" +"ListOfficePhone": "516-741-4333" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-08-09" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeDimensions": "80x113" +"LotSizeSquareFeet": 9320 +"MajorChangeTimestamp": "2024-12-11T05:10:59Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MlsStatus": "Expired" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2024-12-11" +"OnMarketDate": "2024-08-09" +"OriginalEntryTimestamp": "2024-08-09T04:00:00Z" +"OriginalListPrice": 1950000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3571522" +"OriginatingSystemModificationTimestamp": "2024-12-11T05:10:59Z" +"OwnerName": "Lahey" +"ParcelNumber": "2089-39-609-00-0107-0" +"ParkingFeatures": array:4 [ …4] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-12-10T02:57:37Z" +"PhotosCount": 1 +"PostalCity": "Hewlett" +"PreviousListPrice": 1850000 +"PriceChangeTimestamp": "2024-09-17T20:22:59Z" +"RoadResponsibility": array:1 [ …1] +"RoomsTotal": "14" +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-984-6798" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3571522" +"SourceSystemKey": "3571522" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2024-12-11T05:10:59Z" +"StreetName": "Serena" +"StreetNumber": "325" +"StreetNumberNumeric": "325" +"StreetSuffix": "Road" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "22411.9" +"TaxBlock": "609" +"TaxLot": "107" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://tour.vht.com/434405437/325-serena-rd-hewlett-ny-11557/idxs" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"YearBuiltEffective": 2020 +"KEY_AdditionalParcelYN": "0" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_DownPaymentResourceYN": "0" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalRooms": "Home Office,Library/Den" +"KEY_AdditionalFeesYN": "0" +"KEY_AdditionalFees": "0.00" +"KEY_NumberOfKitchens": "1" +"KEY_RATIO_CurrentPrice_By_LivingArea": "383.25522" +"KEY_SeasonalYN": "0" +"KEY_OpenHousePublicCount": "0" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.92256" +"KEY_OriginatingSystemTimestamp": "2024-09-17T16:23:25.000" +"KEY_CurrentPrice": "1799000.00" +"KEY_RoomDescription": "Utilities, Storage, Playroom||Formal dining room ||Formal living room ||Sunlit w/Custom Wood Shelves||2nd Extra Large Family Room with sliding glass doors to the backyard. ||Beautiful Eat-In w/Granite Countertops, large Island and Entrance to Massive Backyard||Powder Room||Massive Mud Room w/Custom Cubbies and Shelves||Washer/Dryer, Pantry||Primary Ensuite #1||Full bathroom in Primary Bedroom||#2||#3||#4||#5||#6||Full||Full||2nd Primary Ensuite, Sitting Area and Closet w/Balcony #7 ||Full bathroom in 2nd Primary Bedroom||Walk-Up Attic" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_MlsDistrictCode": "14" +"KEY_Attic": "Full,Walkup" +"KEY_NumOf3BedRooms": "0" +"KEY_OpenHouseCount": "2" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_RentSpreeYN": "0" +"KEY_NumberOfHeatingZones": "2" +"KEY_TaxSection": "39" +"KEY_RATIO_ListPrice_By_LivingArea": "383.25522" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY326293181')" +"provider_name": "One Key" +"Media": array:1 [ …1] +"ID": "22459" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4903 +post_id: "22298" +post_author: 1 +"ListingKey": "KEY326275583" +"ListingId": "L3570299" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2024-12-06T05:12:37Z" +"RFModificationTimestamp": "2024-12-06T05:13:53Z" +"ListPrice": 4400.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.09 +"LivingArea": 1179.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "391 Hewlett Parkway, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.6420268 +"Longitude": -73.705467066636 +"YearBuilt": 1923 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Todd A. Yovino" +"ListOfficeName": "Island Advantage Realty LLC" +"ListAgentMlsId": "9048648" +"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!, Additional information: Appearance:Excellent" +"Appliances": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "631-351-6000" +"AvailabilityDate": "2024-08-05" +"Basement": array:2 [ …2] +"BathroomsFull": 1 +"ConstructionMaterials": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-08-05T13:02:44.136764+00:00" +"CrossStreet": "Webster Street" +"CumulativeDaysOnMarket": 130 +"DaysOnMarket": 130 +"Directions": "Peninsula Blvd to Mill Rd, right onto Webster St, right onto Hewlett Pkwy" +"EntryLevel": 1 +"ExpirationDate": "2024-12-06" +"Flooring": array:1 [ …1] +"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 +"LeaseTerm": "12 Months" +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "631-351-6000" +"ListAgentEmail": "todd@iarny.com" +"ListAgentKey": "326258880" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326116614" +"ListOfficePhone": "631-351-6000" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2024-07-29" +"LivingAreaSource": "Other" +"LotSizeDimensions": "40x102" +"LotSizeSquareFeet": 3920 +"MajorChangeTimestamp": "2024-12-06T05:11:00Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MlsStatus": "Expired" +"OffMarketDate": "2024-12-06" +"OnMarketDate": "2024-07-29" +"OriginalEntryTimestamp": "2024-08-05T12:46:06Z" +"OriginalListPrice": 4500 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3570299" +"OriginatingSystemModificationTimestamp": "2024-12-06T05:11:00Z" +"OwnerName": "Schochet" +"ParcelNumber": "2089-39-569-00-1003-0" +"ParkingFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-11-02T02:17:56Z" +"PhotosCount": 22 +"PostalCity": "Hewlett" +"PreviousListPrice": 4500 +"PriceChangeTimestamp": "2024-10-15T19:40:23Z" +"RentIncludes": "Sewer,Trash Collection" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "800-746-9464" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "3570299" +"SourceSystemKey": "3570299" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2024-12-06T05:11:00Z" +"StoriesTotal": "2" +"StreetName": "Hewlett" +"StreetNumber": "391" +"StreetNumberNumeric": "391" +"StreetSuffix": "Parkway" +"SyndicateTo": array:1 [ …1] +"TaxBlock": "569" +"TaxLot": "1003" +"WaterSource": array:1 [ …1] +"KEY_OpenHousePublicCount": "0" +"KEY_AdditionalParcelYN": "0" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97778" +"KEY_OriginatingSystemTimestamp": "2024-11-04T13:38:26.000" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_CurrentPrice": "4400.00" +"KEY_AdditionalFees": "0.00" +"KEY_RATIO_CurrentPrice_By_LivingArea": "3.73198" +"KEY_RoomDescription": "Lr, Eik, 1/2 Bath, Laundry Room||3 Br, Full Bath" +"KEY_Hamlet": "Hewlett" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_Attic": "Pull Stairs" +"KEY_NumOf3BedRooms": "0" +"KEY_OpenHouseCount": "0" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "0" +"KEY_NumOf1BedRooms": "0" +"KEY_SmokingYN": "0" +"KEY_SeasonalYN": "0" +"KEY_RentSpreeYN": "0" +"KEY_TaxSection": "39" +"KEY_RATIO_ListPrice_By_LivingArea": "3.73198" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY326275583')" +"provider_name": "One Key" +"Media": array:22 [ …22] +"ID": "22298" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4902 +post_id: "22452" +post_author: 1 +"ListingKey": "KEY326272432" +"ListingId": "L3570108" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2025-02-09T14:31:38Z" +"RFModificationTimestamp": "2025-02-09T14:31:52Z" +"ListPrice": 1299990.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.28 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1250 Harbor Road, Hewlett Harbor, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.63118195 +"Longitude": -73.682528409717 +"YearBuilt": 1938 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marlena C. Schein GRI" +"ListOfficeName": "Coldwell Banker American Homes" +"ListAgentMlsId": "9011045" +"ListOfficeMlsId": "BRMN04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This home is located in the highly sought-after Hewlett Harbor enclave with golf course views The property is surrounded by mature tress and shrubs for your privacy. The Charming Colonial boasts 4 bedrooms and 3 full bathrooms, Spacious living room with a fireplace, plus a study and a skylit family room that is open with the formal dining room. The updated eat in kitchen has sliders out to the yard with a large patio. the CAC compressor and gas heating system is approx. 1 year young. No flood insurance needed or required. Never had any flood damage!, Additional information: Appearance:excellent,Cooling:SEER Rating 12+" +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-302-8500" +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuyerOfficeAOR": "LIBOR" +"ConstructionMaterials": array:2 [ …2] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-08-03T15:15:07.119301+00:00" +"CrossStreet": "Lake Dr" +"CumulativeDaysOnMarket": 123 +"DaysOnMarket": 123 +"Directions": "E. Rockaway Id to Schenck Lane to Harbor Rd. IMPORTANT INSTRUCTIONS*** NO ACCESS ON HARBOR RD***THE FRONT OF THE HOUSE IS ON LAKE DRIVE . ITS THE FIRST HOUSE ON THE RIGHT COMING FROM HARBOR RD" +"ElementarySchool": "Hewlett Elementary School" +"Exclusions": "Chandelier(s)" +"ExpirationDate": "2025-02-09" +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"InteriorFeatures": array:5 [ …5] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentEmail": "MSchein@cbamhomes.com" +"ListAgentKey": "326251764" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109935" +"ListOfficePhone": "516-302-8500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-08-03" +"LivingAreaSource": "Public Records" +"LotFeatures": array:2 [ …2] +"LotSizeDimensions": ".27" +"LotSizeSquareFeet": 12031 +"MajorChangeTimestamp": "2025-02-09T14:30:55Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MlsStatus": "Expired" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2024-12-18" +"OnMarketDate": "2024-08-16" +"OriginalEntryTimestamp": "2024-08-03T13:54:16Z" +"OriginalListPrice": 1400000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3570108" +"OriginatingSystemModificationTimestamp": "2025-02-09T14:30:55Z" +"OwnerName": "Donskoy" +"ParcelNumber": "2017-42-215-00-0013-0" +"ParkingFeatures": array:3 [ …3] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-11-05T17:57:35Z" +"PhotosCount": 26 +"PostalCity": "Hewlett Harbor" +"PreviousListPrice": 1399990 +"PriceChangeTimestamp": "2024-10-28T21:09:35Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "9" +"ShowingContactPhone": "516-302-8500" +"SourceSystemID": "3570108" +"SourceSystemKey": "3570108" +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-02-09T14:30:55Z" +"StreetName": "Harbor" +"StreetNumber": "1250" +"StreetNumberNumeric": "1250" +"StreetSuffix": "Road" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "25540" +"TaxBlock": "215" +"TaxLot": "13" +"VirtualTourURLBranded": "https://tour.vht.com/434409640" +"VirtualTourURLUnbranded": "https://tour.vht.com/434409640/idx" +"WaterSource": array:1 [ …1] +"KEY_AdditionalParcelYN": "0" +"KEY_Village": "Hewlett Harbor" +"KEY_DownPaymentResourceYN": "0" +"KEY_PreviousStatus": "Pending" +"KEY_AdditionalRooms": "Library/Den" +"KEY_AdditionalFeesYN": "0" +"KEY_AdditionalFees": "0.00" +"KEY_NumberOfKitchens": "1" +"KEY_SeasonalYN": "0" +"KEY_ContractPrice": "1264000.00" +"KEY_OpenHousePublicCount": "0" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.92856" +"KEY_OriginatingSystemTimestamp": "2024-12-01T08:20:53.000" +"KEY_CurrentPrice": "1299990.00" +"KEY_RoomDescription": "Entry hall, formal living room with fire place, study, eat in kit, formal dining room, Large family room., full bathroom, primary bedroom/w full bathroom, laundry room, entrance to garage||another primary bedroom, 2 other bedrooms, full bathroom" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumOf4BedRooms": "0" +"KEY_Attic": "Unfinished" +"KEY_NumOf3BedRooms": "0" +"KEY_OpenHouseCount": "1" +"KEY_NumOf2BedRooms": "0" +"KEY_ConcessionYN": "1" +"KEY_NumOf1BedRooms": "0" +"KEY_RentSpreeYN": "0" +"KEY_TaxSection": "42" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY326272432')" +"provider_name": "One Key" +"Media": array:26 [ …26] +"ID": "22452" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4901 +post_id: "18041" +post_author: 1 +"ListingKey": "KEY323152539" +"ListingId": "L3568254" +"PropertyType": "Residential" +"PropertySubType": "Stock Cooperative" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-07-31T13:50:36Z" +"RFModificationTimestamp": "2025-07-31T13:57:00Z" +"ListPrice": 245000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11557" +"UnparsedAddress": "1213 E Broadway # B24, Hewlett, Ny 11557" +"Coordinates": array:2 [ …2] +"Latitude": 40.746339333333 +"Longitude": -73.988644666667 +"YearBuilt": 1955 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Stacey L. Simens" +"ListOfficeName": "BERKSHIRE HATHAWAY" +"ListAgentMlsId": "177067" +"ListOfficeMlsId": "BHHS04" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Spacious Open Floor Plan Two Bed Two Full Bath Unit. Enter This Bright & Sunny Top Floor Apartment Through Ample Foyer With Cedar Lined Large Closet. Ahead Is Galley Kitchen With Counter With Seating By Scenic Window. Substantially Sized Living Room/Dining Room Perfect For Entertaining. Elegant Crown Moldings Throughout. Hardwood Floors and New Baseboard Heating. Huge Master Bedroom With Renovated Bathroom, Two Closets, Private Terrace. Second Sizeable Bedroom, And Full Updated Bathroom Make For Easy Living. Stackable Washer/Dryer In Closet. Building Amenities Include Laundry Rm, Bike Rm. Extensive Beautifully Landscaped Parklike Grounds. Close To All." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-295-3000" +"Basement": array:1 [ …1] +"BathroomsFull": 2 +"BuilderModel": "2 Bedroom" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "516-766-7900" +"BuyerAgentEmail": "ovolfman@gmail.com" +"BuyerAgentFullName": "Oleg Volfman" +"BuyerAgentKey": "326174894" +"BuyerAgentMlsId": "163075" +"BuyerOfficeAOR": "LIBOR" +"BuyerOfficeKey": "326115723" +"BuyerOfficeMlsId": "SPH15" +"BuyerOfficeName": "Signature Premier Properties" +"BuyerOfficePhone": "516-766-7900" +"CoBuyerAgentAOR": "LIBOR" +"CoBuyerAgentDirectPhone": "917-913-2494" +"CoBuyerAgentEmail": "tdashevskaya@signaturepremier.com" +"CoBuyerAgentFullName": "Tatyana Dashevskaya" +"CoBuyerAgentKey": "326235681" +"CoBuyerAgentMlsId": "226926" +"CoBuyerOfficeKey": "326115723" +"CoBuyerOfficeMlsId": "SPH15" +"CoBuyerOfficeName": "Signature Premier Properties" +"CoBuyerOfficePhone": "516-766-7900" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-316-1030" +"CoListAgentEmail": "NRosenthal@bhhslaffey.com" +"CoListAgentFullName": "Nanci Sue Rosenthal" +"CoListAgentKey": "326120336" +"CoListAgentMlsId": "103887" +"CoListOfficeKey": "326109740" +"CoListOfficeMlsId": "BHHS04" +"CoListOfficeName": "BERKSHIRE HATHAWAY" +"CoListOfficePhone": "516-295-3000" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2024-07-25T22:23:55.697536+00:00" +"CrossStreet": "Franklin" +"CumulativeDaysOnMarket": 352 +"DaysOnMarket": 352 +"Directions": "Franklin To E. Broadway." +"ElementarySchoolDistrict": "Hewlett-Woodmere" +"EntryLevel": 2 +"ExpirationDate": "2025-10-30" +"Flooring": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "George W Hewlett High School" +"HighSchoolDistrict": "Hewlett-Woodmere" +"Inclusions": "Dryer, Oven/Range, Refrigerator, Washer" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-455-8152" +"ListAgentEmail": "staceylsimens@gmail.com" +"ListAgentKey": "326187787" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109740" +"ListOfficePhone": "516-295-3000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-07-25" +"LivingAreaSource": "Other" +"LotFeatures": array:2 [ …2] +"MaintenanceExpense": 2126 +"MajorChangeTimestamp": "2025-07-31T13:49:19Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "Woodmere Middle School" +"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2025-07-31" +"OnMarketDate": "2024-07-25" +"OriginalEntryTimestamp": "2024-07-25T04:00:00Z" +"OriginalListPrice": 254000 +"OriginatingSystemID": "LIBOR" +"OriginatingSystemKey": "3568254" +"OriginatingSystemModificationTimestamp": "2025-07-31T13:49:19Z" +"OwnerName": "Holguin" +"ParkingFeatures": array:4 [ …4] +"PatioAndPorchFeatures": array:1 [ …1] +"PetsAllowed": array:2 [ …2] +"PhotosChangeTimestamp": "2024-11-02T02:17:22Z" +"PhotosCount": 21 …50 } 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4900 …126} 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4899 …142} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4898 …145} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4897 …151} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4896 …150} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4895 …135} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4894 …146} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4893 …135} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4892 …119} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4891 …135} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4890 …118} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4889 …123} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4888 …101} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4887 …93} ] +success: true +page_size: 32 +page_count: 2 +count: 47 +after_key: "" } "RF Response Time" => "0.19 seconds" ] ]
