Get started with Oceanside real estate listings tailored for serious buyers. This page offers a curated selection of houses for sale, complete with the latest market data, photos, and property insights. Whether you’re relocating or investing, explore homes in Oceanside, NY, that match your criteria. We simplify the homebuying process with detailed listings and local expertise. Use this platform to start your search, compare options, and request information—all in one place. Oceanside real estate opportunities are just a step away.
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 Oceanside NY street by street — not just by ZIP code. From districts to commute routes, we help you buy smarter based on real neighborhood insight.
You won’t find any sales pressure here. We focus on what works best for you, offering honest input so you can make confident, informed choices.
You won’t be left waiting on answers. We stay connected through every step of the process, so your questions get real replies — not delays.
We tap into local networks to get early access to listings — giving you a head start in a competitive market.
From inspections to paperwork, we manage the chaos so you can focus on the fun part — finding a place you’ll love.
Tight schedule? Need to tour after hours or on weekends? We’re flexible. We work how and when it’s convenient for you.
It’s not just about buying now — we’ll help you choose a home that fits future needs too, like family growth or property value trends.
We’re not here to just close a deal. We look out for your best interest like we would for our own family. Every decision is made with care.
Read what our clients have to say about their experience with us
I highly recommend Kaya Homes if you are looking to buy or sell your home. My home was sold for over ask within 1 week! The process was so simple and easy. Avi had a professional photographer photograph our home and has excellent marketing strategies which led to a speedy transaction. Thank you !!!
Bad Services.
KAYA Homes, and specifically Kamy, is a real estate business with a heart. Before I signed a contract Kamy gave me months of her time, business acumen and understanding. I have bought/sold my homes over many decades. Never have I known a realtor to be so incredibly kind. Everything about how KAYA Homes conduct their business is above reproach.
I had the absolute pleasure of working with Kamy when leasing my new apartment, and I couldn't be happier with the experience! She was fantastic to work with, simplifying the rental process and providing thorough explanations every step of the way. Highly recommend!
This is the third year im using Kaya Homes for my rental, they are very professional. They walk you through everything from start to finish. The owner Kami is awesome!! She is very responsive A+ I highly recommend kaya homes!!
We started our journey with Kaya homes a while back when my husband met Kamy. He knew instantly that we found the right ones to help us with purchasing a new home. Kamy is highly responsive, thoughtful, considerate and very professional on her approach with finding you the right home. We wanted to stay in the area and with such a crazy market, I didn't think it would be possible for us to find our home, but we did. Kamy's reassured us and said we will find your home and we did. Thank you Kamy and also meeting Izzy was a bonus, great family owned business, truly you will not be disappointed. If you are looking to rent, own or sell give them a call.
Absolutely wonderful to work with! I highly suggest if you are looking or selling she is definitely your go to!
Amazing experience with Kaya Homes. She was very helpful and found us our dream home as fast as anyone could wish for!
WOW! Kamy went above and beyond to find us an apartment, my lease was over and I needed to move ASAP and couldn’t find any rentals but when I got in contact with Kamy at Kaya Homes she casted all my worries and stress away. I’ve worked with other realtors in the past which was ok but Kaya Homes over exceeded all of my expectations. Kamy was able to find us a beautiful contemporary apartment in the neighborhood that I appointed and that fit right in our price range within a month we moved in. Kamy is extremely kind, friendly, transparent professional, communicative and easy to reach to answer any of our questions at all times. In addition, since we’ve moved the landlord continues to maintain the apartment beautifully: they provide a cleaning service who comes in to clean inside and outside the complex, landscaper comes weekly, the garbage is pick up 2-3x a week, if there’s ever any issue or something needs fixing they send someone the next day which is a plus because you know they CARE AND APPRECIATE THEIR TENANTS. I recommend Kaya Homes to all my friends & family and to anyone who needs a realtor because they are simply the VERY BEST IN THE BUSINESS. Thank you again Kamy.
I had the pleasure of working on my home selling with Kaya homes and specialty with Kamy Roditi who is a very professional and reliable person. Kamy worked very on my transaction with a fair and quick way and honestly without her my home would not have been sold as fast and for the best possible price as it was. I would highly recomand Kaya homes and Kamy for any Real Estate and business venture, selling and buying Real Estate .
If you are in the market for a new home, I highly recommend going to see Kamy Roditi @ Kaya Homes. She is one of the most knowledgeable realtors I've ever met in the industry hands down. She's honest, trustworthy, responsive and an all around pleasure to work with. She worked diligently to help find the perfect house for my family and smoothly guided me through the process by answering all of my questions thoroughly. Buying a new home can be stressful, but it doesn't have to be if your lucky enough to work with Kamy Roditi. You'll be in good hands, I promise!
I thought about selling my house myself and I’m so glad I didn’t. Kaya Homes was a total blessing for me, the buyers of my home were beyond difficult and they handled every step for me beyond my expectations. They took the stress off of me entirely. I’d highly recommend them to anyone. Thank you again Kaya Homes!!
Highly recommend the team at Kaya Homes. The team is not only knowledgeable but also provides great advice for all real estate needs. Weather your looking to buy, sell, rent or get advice, Kaya homes should be your first call.
array:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=32&$skip=160&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (City eq 'Oceanside' or PostalCity eq 'Oceanside')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5108 +items: array:32 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5122 +post_id: "28242" +post_author: 1 +"ListingKey": "KEY421655806" +"ListingId": "907145" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-02T23:58:36Z" +"RFModificationTimestamp": "2025-10-03T00:04:39Z" +"ListPrice": 550000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1075.0 +"BuildingAreaTotal": 1075.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "3354 Murdock Avenue, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6286613 +"Longitude": -73.6555053 +"YearBuilt": 1960 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Maria C. Pagiazitis" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "122669" +"ListOfficeMlsId": "SPH23" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Calling all contractors, investors and flippers!! Don't miss this incredible waterfront opportunity on a huge irregular lot at the end of a canal. 3 bedroom, 1.5 bath ranch, basement, living room with fireplace, dining room, eat-in-kitchen. This charming ranch offers approximately 1,100 sq. ft. of living space with a full partly finished basement. \n \n Features include: hardwood floors throughout, 2 heating zone -gas conversion 2013, roof redone 2018. \n \n Outdoor enthusiasts will love the walkout pier, two floating docks, and new bulkhead redone in 2025, perfect for boating and water activities! \n \n Additional notes: Garage has been removed. Located in an AE Flood Zone, with an extremely low annual premium of $509.81. 2 deeded lots: Lot 124 - is approximately 20x100 (.0551 acres taxed at $358.99 included in taxes above)\n \n With unbeatable waterfront access and endless potential, this is truly the best deal in Oceanside. Bring your vision and make this your next project! """ +"AdditionalParcelsYN": true +"Appliances": array:9 [ …9] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-785-0100" +"Basement": array:3 [ …3] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-09-15T23:52:01.437269+00:00" +"CrossStreet": "Royal Avenue" +"CumulativeDaysOnMarket": 17 +"DaysOnMarket": 212 +"Directions": "North on Long Beach Road, slight right on Lower Lincoln Avenue, right on Weidner Avenue, left on Royal Avenue, and right on Murdock Avenue, house is the last one on the right." +"ElementarySchool": "School 8" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-09-15" +"ExteriorFeatures": array:2 [ …2] +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": array:2 [ …2] +"FoundationDetails": array:1 [ …1] +"Heating": array:2 [ …2] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-835-2209" +"ListAgentEmail": "mpagiazitis@signaturepremier.com" +"ListAgentKey": "326137822" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115731" +"ListOfficePhone": "516-785-0100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-09-15" +"ListingTerms": "Cash" +"LivingAreaSource": "Public Records" +"LotFeatures": array:8 [ …8] +"LotSizeAcres": 0.1377 +"LotSizeDimensions": "irregular" +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2025-09-15T23:47:30Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-09-15" +"OriginalEntryTimestamp": "2025-09-15T23:47:30Z" +"OriginalListPrice": 550000 +"OriginatingSystemModificationTimestamp": "2025-10-02T23:56:56Z" +"OwnerName": "Estate of Carole J Stroh" +"ParcelNumber": "2089-43-213-00-0063-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-09-25T07:08:44Z" +"PhotosCount": 15 +"PostalCity": "Oceanside" +"PostalCodePlus4": "3626" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-835-2209" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-09-15T23:47:30Z" +"StreetName": "Murdock" +"StreetNumber": "3354" +"StreetNumberNumeric": "3354" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "14237.1" +"TaxBlock": "213" +"TaxLot": "63-54, 124" +"TaxYear": "2025" +"Utilities": array:5 [ …5] +"View": "Water" +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:3 [ …3] +"WaterfrontYN": true +"KEY_Attic": "Scuttle" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "43" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "550000.00" +"KEY_WaterAccessYN": "0" +"KEY_ElectricCompany": "NYSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LivingAreaSearchSqFt": "1075.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "511.62791" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "3994190.2687" +"KEY_RATIO_CurrentPrice_By_LivingArea": "511.62791" +"KEY_SourceSystemModificationTimestamp": "2025-08-30T18:47:20.180" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "511.62791" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "511.62791" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421655806')" +"provider_name": "One Key" +"Media": array:15 [ …15] +"ID": "28242" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5124 +post_id: "28024" +post_author: 1 +"ListingKey": "KEY421649238" +"ListingId": "906950" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-01-01T07:11:39Z" +"RFModificationTimestamp": "2026-01-01T07:16:58Z" +"ListPrice": 1450000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3010.0 +"BuildingAreaTotal": 3010.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "189 Philips Place, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6266695 +"Longitude": -73.631557 +"YearBuilt": 2001 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Peng Gao" +"ListOfficeName": "E Realty International Corp" +"ListAgentMlsId": "211519" +"ListOfficeMlsId": "ERLT01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "." +"Appliances": array:5 [ …5] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": "Boat Dock" +"AttributionContact": "718-886-8110" +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-29T20:56:38.838088+00:00" +"CumulativeDaysOnMarket": 307 +"DaysOnMarket": 125 +"ElementarySchool": "School 9E-Boardman Elem School" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-01-01" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"Heating": array:1 [ …1] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "929-341-6322" +"ListAgentEmail": "gp421520@gmail.com" +"ListAgentKey": "326220762" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111212" +"ListOfficePhone": "718-886-8110" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-29" +"LivingAreaSource": "Other" +"LotFeatures": array:1 [ …1] +"LotSizeAcres": 0.2381 +"LotSizeDimensions": "49 x 144" +"LotSizeSquareFeet": 10372 +"MajorChangeTimestamp": "2026-01-01T05:17:10Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlsStatus": "Expired" +"OffMarketDate": "2026-01-01" +"OnMarketDate": "2025-08-29" +"OriginalEntryTimestamp": "2025-08-29T20:55:29Z" +"OriginalListPrice": 1480000 +"OriginatingSystemModificationTimestamp": "2026-01-01T05:17:10Z" +"OwnerName": "Xiangfei Zeng" +"ParcelNumber": "2089-54-322-00-0027-0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-11-01T15:25:36Z" +"PhotosCount": 1 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PostalCity": "Oceanside" +"PostalCodePlus4": "5517" +"PreviousListPrice": 1480000 +"PriceChangeTimestamp": "2025-12-18T19:30:32Z" +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "929-341-6322" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-01T05:17:10Z" +"StreetName": "Philips" +"StreetNumber": "189" +"StreetNumberNumeric": "189" +"StreetSuffix": "Place" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "21290.43" +"TaxYear": "2025" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:1 [ …1] +"WaterfrontYN": true +"KEY_Attic": "None" +"KEY_TaxSource": "Other" +"KEY_CurrentPrice": "1450000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_IncludedInTaxes": "Sewer,Water" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "3010.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "481.72757" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "6089878.2024" +"KEY_RATIO_CurrentPrice_By_LivingArea": "481.72757" +"KEY_SourceSystemModificationTimestamp": "2025-08-29T16:55:29.627" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "481.72757" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97973" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "481.72757" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421649238')" +"provider_name": "One Key" +"Media": array:1 [ …1] +"ID": "28024" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5121 +post_id: "28008" +post_author: 1 +"ListingKey": "KEY421612649" +"ListingId": "905949" +"PropertyType": "Commercial Lease" +"PropertySubType": "Retail" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-02-21T07:02:38Z" +"RFModificationTimestamp": "2026-02-21T07:04:26Z" +"ListPrice": 2000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 500.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "9 Davison W Unit 9b, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6419435 +"Longitude": -73.6511959 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Damian Andraka SFR" +"ListOfficeName": "Stonegate Real Estate" +"ListAgentMlsId": "175238" +"ListOfficeMlsId": "STNE01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Corner retail unit shell space located in the heart of Oceanside business district. Space located near the busy intersection of Long beach Rd and Davison Ave. Unit features a private bathroom, backroom storage with separate entrance and in wall split unit for AC/Heat. Adjacent to free municipal parking lot with plenty of parking. Available Immediately." +"AttributionContact": "516-740-2777" +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"BuildingName": "9" +"BusinessType": "Retail" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-27T15:26:33.474237+00:00" +"CrossStreet": "Long Beach Rd" +"CumulativeDaysOnMarket": 178 +"DaysOnMarket": 178 +"EntryLevel": 1 +"ExpirationDate": "2026-02-21" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseAmountFrequency": "Monthly" +"LeaseTerm": "Over 12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-852-0368" +"ListAgentEmail": "dandraka@stonegatere.com" +"ListAgentKey": "326186117" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115823" +"ListOfficePhone": "516-740-2777" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-08-27" +"MajorChangeTimestamp": "2026-02-21T05:11:11Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"NumberOfUnitsTotal": "6" +"OffMarketDate": "2026-02-21" +"OnMarketDate": "2025-08-27" +"OriginalEntryTimestamp": "2025-08-27T15:24:27Z" +"OriginalListPrice": 2000 +"OriginatingSystemModificationTimestamp": "2026-02-21T05:11:11Z" +"OwnerName": "Archi-Bec Properties LLC" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-12-02T19:24:36Z" +"PhotosCount": 11 +"PostalCity": "Oceanside" +"PriceChangeTimestamp": "2025-08-27T15:24:27Z" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-852-0368" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-21T05:11:11Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirSuffix": "W" +"StreetName": "Davison" +"StreetNumber": "9" +"StreetNumberNumeric": "9" +"StreetSuffix": "Avenue" +"SyndicateTo": array:3 [ …3] +"TaxAnnualAmount": "59696" +"TaxYear": "2025" +"UnitNumber": "B" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"KEY_ElevatorYN": "0" +"KEY_SubleaseYN": "0" +"KEY_UsableArea": "500.00" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "2000.00" +"KEY_BuildToSuitYN": "0" +"KEY_LeasePriceUnit": "Total" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_SecurityDeposits": "1 Month" +"KEY_ShowingTimeFlagYN": "0" +"KEY_SprinklerSystemYN": "1" +"KEY_MlsMajorChangeType": "Expired" +"KEY_InvestmentPropertyYN": "0" +"KEY_NumberOfHeatingZones": "1" +"KEY_NumberOfResidentialUnits": "0" +"KEY_SourceSystemModificationTimestamp": "2025-08-27T11:24:27.133" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "4.00000" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "4.00000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421612649')" +"provider_name": "One Key" +"Media": array:11 [ …11] +"ID": "28008" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5125 +post_id: "28027" +post_author: 1 +"ListingKey": "KEY421607638" +"ListingId": "905826" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-03-02T07:03:37Z" +"RFModificationTimestamp": "2026-03-02T07:07:11Z" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1007.0 +"BuildingAreaTotal": 1103.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "404 Silver Lane, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6423766 +"Longitude": -73.6489469 +"YearBuilt": 1913 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Chris J. Boylan" +"ListOfficeName": "EXIT Realty Premier" +"ListAgentMlsId": "178073" +"ListOfficeMlsId": "EREA02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Why Rent, When You Can Own. Welcome To This Cozy & Charming 2 Bedroom Colonial on an Over-Sized property in the Terrell Section of Oceanside. This home is not in a flood zone. Large Living Room with Separate Formal Dining Room and Eat in Kitchen. Three Season Screened in Porch overlooking Huge Back Yard. King size Primary Bedroom and Extra Large Second Bedroom. Full bath has also been Updated. Three Ductless Air Conditioning Units in home. House has been well maintained and in beautiful condition. Extra-Large 1.75 garage in rear of property. An Absolute Must See." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-790-0721" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-30T14:48:45.493613+00:00" +"CumulativeDaysOnMarket": 184 +"DaysOnMarket": 184 +"ElementarySchool": "School 2" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-03-02" +"GarageSpaces": "1.75" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-790-0721" +"ListAgentEmail": "Boylansells@gmail.com" +"ListAgentKey": "326188717" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326111209" +"ListOfficePhone": "516-795-1000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-30" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1582 +"LotSizeSquareFeet": 6891 +"MajorChangeTimestamp": "2026-03-02T05:11:58Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlsStatus": "Expired" +"OffMarketDate": "2026-03-02" +"OnMarketDate": "2025-08-30" +"OriginalEntryTimestamp": "2025-08-30T14:43:33Z" +"OriginalListPrice": 599000 +"OriginatingSystemModificationTimestamp": "2026-03-02T05:11:58Z" +"OwnerName": "Sutton" +"ParcelNumber": "2089-38-535-00-0062-0" +"PhotosChangeTimestamp": "2026-03-02T05:13:38Z" +"PhotosCount": 21 +"PostalCity": "Oceanside" +"PostalCodePlus4": "1946" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-790-0721" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-03-02T05:11:58Z" +"StreetName": "Silver" +"StreetNumber": "404" +"StreetNumberNumeric": "404" +"StreetSuffix": "Lane" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "9329.95" +"TaxYear": "2025" +"Utilities": array:7 [ …7] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Scuttle" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "599000.00" +"KEY_WaterAccessYN": "0" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "1007.00" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "594.83615" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "3786346.3970" +"KEY_RATIO_CurrentPrice_By_LivingArea": "594.83615" +"KEY_SourceSystemModificationTimestamp": "2025-08-26T23:40:08.850" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "543.06437" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "543.06437" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421607638')" +"provider_name": "One Key" +"Media": array:21 [ …21] +"ID": "28027" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5123 +post_id: "28001" +post_author: 1 +"ListingKey": "KEY421602612" +"ListingId": "905640" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-03-12T13:07:36Z" +"RFModificationTimestamp": "2026-03-12T13:08:20Z" +"ListPrice": 749000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1538.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "29 W Henrietta Avenue, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6287106 +"Longitude": -73.6396443 +"YearBuilt": 1934 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lourdes Marsans" +"ListOfficeName": "Century 21 Amiable Rlty Grp II" +"ListAgentMlsId": "192256" +"ListOfficeMlsId": "ANCH01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Charm meets convenience in this gorgeous corner single family home. Step into this fully upgraded house where no detail went unnoticed. This home features 3 bedrooms and 2 baths. The owners suite is located upstairs with a convenient deck to unwind. Embrace the tranquility of the landscaped backyard oasis great for relaxing or entertaining. Located closed to the restaurants, shops and public transportation. Don't miss out on this great opportunity." +"Appliances": array:12 [ …12] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "718-835-4700" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"BuyerAgentAOR": "LIBOR" +"BuyerAgentDirectPhone": "917-685-0489" +"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" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-26T19:41:11.711283+00:00" +"CrossStreet": "Henrietta" +"CumulativeDaysOnMarket": 64 +"DaysOnMarket": 64 +"Directions": "Waze" +"ElementarySchool": "School 8" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-04-17" +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:11 [ …11] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "786-873-9603" +"ListAgentEmail": "lulym77@gmail.com" +"ListAgentKey": "326202096" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109368" +"ListOfficePhone": "718-835-4700" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-26" +"LivingAreaSource": "Public Records" +"LotFeatures": array:7 [ …7] +"LotSizeDimensions": "40x103" +"LotSizeSquareFeet": 4120 +"MajorChangeTimestamp": "2026-02-27T14:25:30Z" +"MajorChangeType": "Pending" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Pending" +"OffMarketDate": "2026-02-27" +"OnMarketDate": "2025-08-26" +"OriginalEntryTimestamp": "2025-08-26T19:39:02Z" +"OriginalListPrice": 799000 +"OriginatingSystemModificationTimestamp": "2026-03-12T13:06:05Z" +"OwnerName": "Salce" +"ParcelNumber": "2089-43-344-00-0041-0" +"ParkingFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-01-06T14:23:36Z" +"PhotosCount": 50 +"PostalCity": "Oceanside" +"PreviousListPrice": 779000 +"PriceChangeTimestamp": "2026-02-04T16:47:53Z" +"PurchaseContractDate": "2026-02-27" +"RoomsTotal": "6" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "3053330741" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-27T14:25:30Z" +"StreetDirPrefix": "W" +"StreetName": "Henrietta" +"StreetNumber": "29" +"StreetNumberNumeric": "29" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "11325" +"TaxBlock": "344" +"TaxLot": "41" +"TaxYear": "2025" +"Utilities": array:4 [ …4] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_Hamlet": "Oceanside" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "43" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "749000.00" +"KEY_ContractPrice": "751000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Pending" +"KEY_LivingAreaSearchSqFt": "1538.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "486.99610" +"KEY_RATIO_CurrentPrice_By_LivingArea": "486.99610" +"KEY_SourceSystemModificationTimestamp": "2025-08-26T15:37:11.473" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.93742" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421602612')" +"provider_name": "One Key" +"Media": array:50 [ …50] +"ID": "28001" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5120 +post_id: "27966" +post_author: 1 +"ListingKey": "KEY421572179" +"ListingId": "904729" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-12T20:09:37Z" +"RFModificationTimestamp": "2026-04-12T20:14:03Z" +"ListPrice": 850000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2596.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "3357 Lawrence Avenue, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.629143 +"Longitude": -73.6417269 +"YearBuilt": 1960 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jovanny Rodriguez CBR" +"ListOfficeName": "Coldwell Banker American Homes" +"ListAgentMlsId": "192334" +"ListOfficeMlsId": "BRMN05" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Limitless Possibilities Awaits at 3357 Lawrence Avenue. Welcome to this beautifully spacious, maintained home in the desirable Ocean Lea area. This 2600 sq ft, 5-bedroom, 2-bathroom Lanai Hi Ranch offers a spacious and comfortable living experience. The main level features three bedrooms and one full bathroom, along with a classic layout with a formal living room, formal dining room, and a large eat-in kitchen, offering plenty of room to create your own dream space. On the lower level with a separate entrance, you will find two bedrooms, one full bath, a laundry room with a washer and dryer, and a cozy family room with a fireplace. The house also includes a one car garage with plenty of space for a vehicle and storage. Its close proximity to local amenities, including the LIRR, makes it an ideal location. This move-in-ready home offers the potential for a mother-daughter setup with the proper permits. Energy-efficient solar panels are financed and transferable to the new owner, providing long-term savings and an eco-friendly benefit. Experience exceptional comfort and efficiency with the home’s high-efficiency Navien combi-boiler, which offers instant, endless hot water and cost-effective heating from a single, space-saving unit." +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:2 [ …2] +"AttributionContact": "516-223-2525" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-23T21:05:29.524188+00:00" +"CrossStreet": "W Henrietta Ave" +"CumulativeDaysOnMarket": 225 +"DaysOnMarket": 228 +"Disclosures": array:2 [ …2] +"DoorFeatures": array:1 [ …1] +"ElementarySchool": "School 8" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-08-24" +"ExteriorFeatures": array:3 [ …3] +"Fencing": array:3 [ …3] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:2 [ …2] +"FoundationDetails": array:2 [ …2] +"GarageSpaces": "1" +"GarageYN": true +"GreenEnergyGeneration": array:1 [ …1] +"Heating": array:4 [ …4] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-428-3246" +"ListAgentEmail": "jrodriguez@cbamhomes.com" +"ListAgentKey": "326202170" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109936" +"ListOfficePhone": "516-223-2525" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-23" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1492 +"LotSizeDimensions": "65 X 100" +"LotSizeSquareFeet": 6500 +"MajorChangeTimestamp": "2025-12-16T14:14:15Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-08-30" +"OriginalEntryTimestamp": "2025-08-23T20:58:28Z" +"OriginalListPrice": 899999 +"OriginatingSystemModificationTimestamp": "2026-04-12T20:08:17Z" +"OwnerName": "Mejia" +"ParcelNumber": "2089-43-343-00-0048-0" +"ParkingFeatures": array:5 [ …5] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-11-02T16:54:36Z" +"PhotosCount": 44 +"PostalCity": "Oceanside" +"PostalCodePlus4": "5014" +"PreviousListPrice": 879999 +"PriceChangeTimestamp": "2025-12-16T14:14:15Z" +"PropertyCondition": array:2 [ …2] +"RoomsTotal": "12" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-223-2525" +"ShowingRequirements": array:6 [ …6] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-08-30T04:30:09Z" +"StreetName": "Lawrence" +"StreetNumber": "3357" +"StreetNumberNumeric": "3357" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "12202.9" +"TaxYear": "2026" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"KEY_Attic": "None" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "850000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Coming Soon" +"KEY_SolarOwnership": "Leased" +"KEY_ElectricCompany": "PSEG" +"KEY_IncludedInTaxes": "Sewer,Trash" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "2596.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "327.42681" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5697050.9383" +"KEY_RATIO_CurrentPrice_By_LivingArea": "327.42681" +"KEY_SourceSystemModificationTimestamp": "2025-08-23T13:59:09.487" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.94445" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421572179')" +"provider_name": "One Key" +"Media": array:44 [ …44] +"ID": "27966" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5119 +post_id: "27958" +post_author: 1 +"ListingKey": "KEY421503284" +"ListingId": "902862" +"PropertyType": "Business Opportunity" +"PropertySubType": "Mixed Use" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-11T04:54:36Z" +"RFModificationTimestamp": "2026-02-11T04:55:38Z" +"ListPrice": 290000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 4294.0 +"LivingArea": 0 +"BuildingAreaTotal": 1287.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "2757 Long Beach Road, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6442937 +"Longitude": -73.6390592 +"YearBuilt": 1926 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nicholas Evangelista" +"ListOfficeName": "NY Space Finders Inc" +"ListAgentMlsId": "225727" +"ListOfficeMlsId": "NYSP02" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "A turnkey, state-of-the-art restaurant business is now for sale at 2757 Long Beach Road, Oceanside, NY. Featuring superb layout flow across a 40-seat dining room, a 12-seat bar (liquor license included), plus outdoor seating, this venue impresses. The open-concept kitchen is well-equipped with two 6-burner gas stovetops, a convection oven, and a regular oven, alongside direct access to a spacious 1,200 sq ft basement housing a walk-in box and abundant storage. Comfort is ensured with central HVAC throughout, and the current lease runs through 2039, offering long-term stability. Nestled on a corner lot with adjacent free municipal parking, this site enjoys excellent visibility on the busy Long Beach Road, which sees up to 36,000 vehicles per day!" +"AccessibilityFeatures": array:4 [ …4] +"Appliances": array:9 [ …9] +"AttributionContact": "516-801-6181" +"Basement": array:3 [ …3] +"BasementYN": true +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"BuildingFeatures": array:3 [ …3] +"BusinessName": "Tutti Noi" +"BusinessType": "Restaurant" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-840-8029" +"CoListAgentEmail": "giuseppe@nyspacefinders.com" +"CoListAgentFullName": "Giuseppe Gregorio" +"CoListAgentKey": "326198558" +"CoListAgentMlsId": "188529" +"CoListOfficeKey": "326114260" +"CoListOfficeMlsId": "NYSP02" +"CoListOfficeName": "NY Space Finders Inc" +"CoListOfficePhone": "516-801-6181" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-22T17:13:22.877450+00:00" +"CrossStreet": "Homecrest Ct" +"CumulativeDaysOnMarket": 172 +"DaysOnMarket": 235 +"Directions": "GPS: Corner of Long Beach Road and Homecrest Ct." +"ExpirationDate": "2026-05-20" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-385-7725" +"ListAgentEmail": "nick@nyspacefinders.com" +"ListAgentKey": "326234502" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114260" +"ListOfficePhone": "516-801-6181" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-20" +"ListingTerms": "Lease Purchase" +"LotFeatures": array:2 [ …2] +"LotSizeAcres": 0.0986 +"LotSizeSquareFeet": 4294 +"MajorChangeTimestamp": "2025-08-22T17:06:25Z" +"MajorChangeType": "New Listing" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfBuildings": 1 +"OnMarketDate": "2025-08-22" +"OriginalEntryTimestamp": "2025-08-22T17:06:25Z" +"OriginalListPrice": 290000 +"OriginatingSystemModificationTimestamp": "2026-02-11T04:53:26Z" +"OwnerName": "Aaa Property Assoc LLC" +"ParcelNumber": "2089-38-360-00-0284-0" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "6" +"PhotosChangeTimestamp": "2026-02-11T04:54:36Z" +"PhotosCount": 15 +"PostalCity": "Oceanside" +"PostalCodePlus4": "2257" +"PropertyCondition": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-385-7725" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-08-22T17:06:25Z" +"Stories": "1" +"StoriesTotal": "2" +"StreetName": "Long Beach" +"StreetNumber": "2757" +"StreetNumberNumeric": "2757" +"StreetSuffix": "Road" +"SyndicateTo": array:3 [ …3] +"TaxBlock": "360" +"TaxLot": "284" +"TaxYear": "2025" +"Utilities": array:9 [ …9] +"WaterSource": array:1 [ …1] +"YearBuiltEffective": 2018 +"Zoning": "Commerc" +"KEY_ElevatorYN": "0" +"KEY_TaxSection": "38" +"KEY_CurrentPrice": "290000.00" +"KEY_PermittedUses": "Business,Food Services,Retail" +"KEY_WaterAccessYN": "0" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "New Listing" +"KEY_LocationDescription": "Ground Floor" +"KEY_RealEstateIncludedYN": "0" +"KEY_DescriptionOfBusiness": "Fine Dining Restaurant" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "2941176.4706" +"KEY_SourceSystemModificationTimestamp": "2025-08-18T23:10:08.947" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "225.33023" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "225.33023" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421503284')" +"provider_name": "One Key" +"Media": array:15 [ …15] +"ID": "27958" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5126 +post_id: "27871" +post_author: 1 +"ListingKey": "KEY421449927" +"ListingId": "901349" +"PropertyType": "Commercial Lease" +"PropertySubType": "Business" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-01-01T07:10:39Z" +"RFModificationTimestamp": "2026-01-01T07:11:54Z" +"ListPrice": 3900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2000.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "2929 Long Beach Road, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6398091 +"Longitude": -73.6395459 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Edna Edelman" +"ListOfficeName": "Bella Mia Realty LLC" +"ListAgentMlsId": "128657" +"ListOfficeMlsId": "BLLM01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Prime Corner Commercial Property on Long Beach Road – Oceanside, NY\n \n Exceptional opportunity to own or lease a high-visibility corner property in one of Oceanside's busiest commercial corridors. Located directly on Long Beach Road, this light-filled, highly visible retail space offers maximum exposure with constant vehicle and foot traffic.\n \n Key Features:\n \n Prominent corner location with excellent signage potential\n \n Bright, open layout ideal for retail, office, or service-based businesses\n \n Heavy daily traffic ensures consistent visibility\n \n Located in a thriving commercial district surrounded by national and local businesses\n \n Easy access to public transportation and major roadways """ +"AttributionContact": "516-984-0169" +"BuildingAreaSource": "Other" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Other" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-14T14:44:05.668575+00:00" +"CumulativeDaysOnMarket": 140 +"DaysOnMarket": 140 +"ExpirationDate": "2026-01-01" +"Heating": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseAmountFrequency": "Monthly" +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-984-0169" +"ListAgentEmail": "edna@bellamiarealty.com" +"ListAgentKey": "326143178" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109848" +"ListOfficePhone": "516-984-0169" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2025-08-13" +"MajorChangeTimestamp": "2026-01-01T05:18:28Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"OffMarketDate": "2026-01-01" +"OnMarketDate": "2025-08-14" +"OriginalEntryTimestamp": "2025-08-14T14:38:28Z" +"OriginalListPrice": 4250 +"OriginatingSystemModificationTimestamp": "2026-01-01T05:18:28Z" +"OwnerName": "Mike" +"PhotosChangeTimestamp": "2026-01-01T05:19:36Z" +"PhotosCount": 6 +"PostalCity": "Oceanside" +"PreviousListPrice": 4250 +"PriceChangeTimestamp": "2025-09-16T22:07:13Z" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-01T05:18:28Z" +"StreetName": "Long Beach Road" +"StreetNumber": "2929" +"StreetNumberNumeric": "2929" +"SyndicateTo": array:3 [ …3] +"TaxYear": "2025" +"Utilities": array:5 [ …5] +"WaterSource": array:1 [ …1] +"KEY_CurrentPrice": "3900.00" +"KEY_LeasePriceUnit": "Total" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_SourceSystemModificationTimestamp": "2025-08-14T10:38:28.237" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.95000" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.91765" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.95000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421449927')" +"provider_name": "One Key" +"Media": array:6 [ …6] +"ID": "27871" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5127 +post_id: "27850" +post_author: 1 +"ListingKey": "KEY421435226" +"ListingId": "900959" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-08-26T07:11:40Z" +"RFModificationTimestamp": "2025-08-26T07:19:06Z" +"ListPrice": 4500.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1323.0 +"BuildingAreaTotal": 1323.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "520 Farrington Road, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6461678 +"Longitude": -73.6507498 +"YearBuilt": 1926 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sheahan Sewgobind" +"ListOfficeName": "New York 1 Homes Network Inc" +"ListAgentMlsId": "200707" +"ListOfficeMlsId": "NNWK01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Newly renovated June 2025! Full house for rent with a basement, garage, and yard." +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "718-322-5100" +"AvailabilityDate": "2025-09-01" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-13T16:54:01.131809+00:00" +"CumulativeDaysOnMarket": 12 +"DaysOnMarket": 12 +"Directions": "Long Beach Rd To Rockaway Ave. To Farrington Rd." +"ElementarySchool": "School 2" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2025-12-15" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "Castleton Academy Hs Of Oceanside" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "347-581-3088" +"ListAgentEmail": "soldbysheahan1@gmail.com" +"ListAgentKey": "326210230" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114110" +"ListOfficePhone": "718-322-5100" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2025-08-13" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.2359 +"LotSizeSquareFeet": 10275 +"MajorChangeTimestamp": "2025-08-25T18:09:49Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlsStatus": "Hold" +"OffMarketDate": "2025-08-25" +"OnMarketDate": "2025-08-13" +"OriginalEntryTimestamp": "2025-08-13T16:50:28Z" +"OriginalListPrice": 4500 +"OriginatingSystemModificationTimestamp": "2025-08-25T18:09:49Z" +"OwnerName": "Wilkinson Street LLC" +"ParcelNumber": "2089-38-411-00-0003-0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-08-13T16:51:52Z" +"PhotosCount": 37 +"PostalCity": "Oceanside" +"PostalCodePlus4": "1119" +"PriceChangeTimestamp": "2025-08-13T16:50:28Z" +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-08-25T18:09:49Z" +"StreetName": "Farrington" +"StreetNumber": "520" +"StreetNumberNumeric": "520" +"StreetSuffix": "Road" +"SyndicateTo": array:1 [ …1] +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Crawl" +"KEY_HoldDate": "2025-08-25" +"KEY_RentSpreeYN": "1" +"KEY_CurrentPrice": "4500.00" +"KEY_RentSpreeURL": "https://apply.link/PJ9P4_Q" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "1323.00" +"KEY_RATIO_ListPrice_By_LivingArea": "3.40136" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "19075.8796" +"KEY_RATIO_CurrentPrice_By_LivingArea": "3.40136" +"KEY_SourceSystemModificationTimestamp": "2025-08-13T12:50:28.897" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "3.40136" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "3.40136" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421435226')" +"provider_name": "One Key" +"Media": array:37 [ …37] +"ID": "27850" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5128 +post_id: "27816" +post_author: 1 +"ListingKey": "KEY421401017" +"ListingId": "899980" +"PropertyType": "Residential Lease" +"PropertySubType": "Apartment" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-08-14T07:13:37Z" +"RFModificationTimestamp": "2025-08-14T07:18:40Z" +"ListPrice": 3750.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1000.0 +"BuildingAreaTotal": 1943.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": null +"Coordinates": array:2 [ …2] +"Latitude": null +"Longitude": null +"YearBuilt": 1972 +"InternetAddressDisplayYN": false +"FeedTypes": "IDX" +"ListAgentFullName": "Christopher Guardado" +"ListOfficeName": "New Vision Group Realty Inc" +"ListAgentMlsId": "188848" +"ListOfficeMlsId": "MJ01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This charming and fully renovated 3-bedroom, 1-bathroom apartment offers generous living spaces. The large living room and dining area are complemented by beautiful hardwood floors throughout, adding warmth and character to every room. The layout provides plenty of natural light, creating a bright and inviting atmosphere. Located in a convenient neighborhood close to shops, dining, and public transportation, this home is ideal for those seeking comfort and accessibility." +"Appliances": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "917-913-7116" +"AvailabilityDate": "2025-08-11" +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-11T17:29:32.301145+00:00" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 2 +"ElementarySchool": "School 2" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2025-09-30" +"Flooring": array:1 [ …1] +"Heating": array:1 [ …1] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "12 Months" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-532-2260" +"ListAgentEmail": "chrisguardado5@gmail.com" +"ListAgentKey": "326198863" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326113400" +"ListOfficePhone": "917-913-7116" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-08-11" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.0918 +"LotSizeSquareFeet": 4000 +"MajorChangeTimestamp": "2025-08-13T16:08:05Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlsStatus": "Hold" +"OffMarketDate": "2025-08-13" +"OnMarketDate": "2025-08-11" +"OriginalEntryTimestamp": "2025-08-11T17:26:24Z" +"OriginalListPrice": 3750 +"OriginatingSystemModificationTimestamp": "2025-08-13T16:08:05Z" +"OwnerName": "Guardado" +"ParcelNumber": "2089-43-350-00-0053-0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-08-11T17:27:37Z" +"PhotosCount": 9 +"PostalCity": "Oceanside" +"PostalCodePlus4": "2715" +"PriceChangeTimestamp": "2025-08-11T17:26:24Z" +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-532-2260" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-08-13T16:08:05Z" +"StreetName": "Morrow" +"StreetNumber": "3068" +"StreetNumberNumeric": "3068" +"StreetSuffix": "Road" +"SyndicateTo": array:1 [ …1] +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Pull Stairs" +"KEY_HoldDate": "2025-08-13" +"KEY_RentSpreeYN": "1" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "3750.00" +"KEY_RentSpreeURL": "https://apply.link/NUQx5hw" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "1000.00" +"KEY_RATIO_ListPrice_By_LivingArea": "3.75000" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "40849.6732" +"KEY_RATIO_CurrentPrice_By_LivingArea": "3.75000" +"KEY_SourceSystemModificationTimestamp": "2025-08-11T13:26:24.130" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "1.93001" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "1.93001" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421401017')" +"provider_name": "One Key" +"Media": array:9 [ …9] +"ID": "27816" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5129 +post_id: "27772" +post_author: 1 +"ListingKey": "KEY421350844" +"ListingId": "898597" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-08-11T22:55:55Z" +"RFModificationTimestamp": "2025-08-11T22:57:49Z" +"ListPrice": 1500000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2898.0 +"BuildingAreaTotal": 3265.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "2546 Harvey Avenue, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6478043 +"Longitude": -73.6275777 +"YearBuilt": 2015 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Patricia A. Murphy CBR" +"ListOfficeName": "Village Plaza Realty" +"ListAgentMlsId": "93410" +"ListOfficeMlsId": "VILL01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This one-of-a-kind impressive custom built in 2015 center hall colonial features the best construction and finishes available. The details in this home are the top of the line and amazing. The exterior is all stucco and features the best available custom windows. As you walk up to this home you will walk up the paver walkway to the portico and in front of the custom double door entrance. As you enter the home, you will be in the wide entry hallway with a coat closet, half bath and wide solid wood staircase. To the left is the large living room and then into the even larger family room with a fireplace. Off of the entry foyer to the right is the large banquet formal dining room and then also accessed from the center hall is the very large custom eat-in-kitchen with high end appliances, custom wood cabinets, island and granite counters. There is also a large dining area in the kitchen. Off of the kitchen is the entrance to the oversized one-car electric eye opener garage with a double wide paver driveway. As you ascend the wide staircase, you will be on the second floor and to the left is a huge primary bedroom retreat with two large walk-in closets and office or nursery, an amazing large top of the line full bath with a separate soaking tub, large steam shower, toilet and double sinks. There is a large private terrace off of the primary bedroom. There are three additional very large bedrooms all with large closets and a beautiful hall bath. There is a huge unfinished attic space. The full basement is also finished with high ceilings. The private, fully PVC fenced back yard is like an outstanding island oasis. The private yard features tall mature plantings, a large salt water in-ground heated pool, a hot tub for five or six people, an outdoor kitchen and a covered sitting area. There is 2,898 square feet of living space excluding the finished basement and the property is 8,000 square feet or 80X100. There are in-ground sprinklers, central air, hardwood floors throughout, all gas cooking and heating, the best available central station alarm burglar and fire security system with cameras around the house and so much more! This is a totally custom home with the best available materials in and out. There is nothing like this home on the market. This house is a must see!!!" +"Appliances": array:8 [ …8] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-680-6346" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaSource": "Plans" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-07T13:28:52.426687+00:00" +"CrossStreet": "Allen Street/Nassau Parkway" +"CumulativeDaysOnMarket": 4 +"DaysOnMarket": 4 +"DirectionFaces": "East" +"Directions": "Foxhurst Road to Harvey Avenue to #2546" +"Disclosures": array:2 [ …2] +"ElementarySchool": "School 3" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-05-31" +"ExteriorFeatures": array:5 [ …5] +"Fencing": array:3 [ …3] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:3 [ …3] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:3 [ …3] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:15 [ …15] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-680-6346" +"ListAgentEmail": "info@villageplaza.com" +"ListAgentKey": "326265261" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326116330" +"ListOfficePhone": "516-593-5455" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-07" +"ListingTerms": "1031 Exchange,Cash,Conventional" +"LivingAreaSource": "Public Records" +"LotFeatures": array:8 [ …8] +"LotSizeAcres": 0.1837 +"LotSizeDimensions": "80X100" +"LotSizeSquareFeet": 8000 +"MajorChangeTimestamp": "2025-08-11T22:54:59Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlsStatus": "Hold" +"OffMarketDate": "2025-08-11" +"OnMarketDate": "2025-08-07" +"OriginalEntryTimestamp": "2025-08-07T13:22:34Z" +"OriginalListPrice": 1500000 +"OriginatingSystemModificationTimestamp": "2025-08-11T22:54:59Z" +"OwnerName": "Brennan" +"ParcelNumber": "2089-54-159-00-0011-0" +"ParkingFeatures": array:8 [ …8] +"ParkingTotal": "5" +"PhotosChangeTimestamp": "2025-08-07T13:33:36Z" +"PhotosCount": 49 +"PoolFeatures": array:6 [ …6] +"PoolPrivateYN": true +"PostalCity": "Oceanside" +"PostalCodePlus4": "2418" +"PriceChangeTimestamp": "2025-08-07T13:22:34Z" +"PropertyCondition": array:1 [ …1] +"RoadFrontageType": array:1 [ …1] +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-680-6346" +"ShowingRequirements": array:5 [ …5] +"SpaFeatures": array:1 [ …1] +"SpaYN": true +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-08-11T22:54:59Z" +"StreetName": "Harvey" +"StreetNumber": "2546" +"StreetNumberNumeric": "2546" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "16761.73" +"TaxAssessedValue": 744 +"TaxBlock": "159" +"TaxLot": "11" +"TaxYear": "2024" +"Utilities": array:7 [ …7] +"View": "Neighborhood" +"VirtualTourURLBranded": "https://tours.longislandvirtual.com/288667" +"VirtualTourURLUnbranded": "https://tours.longislandvirtual.com/idx/288667" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:4 [ …4] +"YearBuiltEffective": 2015 +"KEY_Attic": "Full,Storage,Unfinished" +"KEY_HoldDate": "2025-08-11" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "54" +"KEY_ConcessionYN": "0" +"KEY_CurrentPrice": "1500000.00" +"KEY_WaterAccessYN": "0" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "2898.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "517.59834" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "8165487.2074" +"KEY_RATIO_CurrentPrice_By_LivingArea": "517.59834" +"KEY_SourceSystemModificationTimestamp": "2025-08-07T09:22:34.027" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "459.41807" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "459.41807" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421350844')" +"provider_name": "One Key" +"Media": array:49 [ …49] +"ID": "27772" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5130 +post_id: "27869" +post_author: 1 +"ListingKey": "KEY421338913" +"ListingId": "898289" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-02-07T05:12:36Z" +"RFModificationTimestamp": "2026-02-07T05:15:23Z" +"ListPrice": 1350000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3000.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "254 Elizabeth Avenue, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6432295 +"Longitude": -73.6306238 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rhea Cory Knopf" +"ListOfficeName": "Compass Greater NY LLC" +"ListAgentMlsId": "91890" +"ListOfficeMlsId": "CMPA07" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to 254 Elizabeth Avenue, Oceanside – Brand New Construction!\n \n Set on an oversized 80 x 100 property, this stunning new home offers the ultimate open layout designed for today’s lifestyle. The main level features a formal living room, spacious dining area, and a custom eat-in kitchen with a walk-in pantry. A versatile den, plus a first-floor bedroom and full bath, provide flexible living options for guests or extended family.\n \n Upstairs, you’ll find four generously sized bedrooms, including a luxurious primary suite with a private bath. Three additional bedrooms share a full bathroom, creating the perfect layout. Additional highlights include a one-car attached garage, partial basement for storage, and a prime residential location bordering Rockville Centre.\n \n This is your chance to own a brand-new home in one of Oceanside’s most desirable neighborhoods! Central air, gas heating system, top of the line everything! """ +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-375-7727" +"Basement": array:1 [ …1] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-08-14T13:23:19.650883+00:00" +"CrossStreet": "Oceanside Rd" +"CumulativeDaysOnMarket": 175 +"DaysOnMarket": 175 +"ElementarySchool": "School 3" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-02-07" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-375-7727" +"ListAgentEmail": "cory.knopf@compass.com" +"ListAgentKey": "326263979" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110404" +"ListOfficePhone": "516-764-6060" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-08-06" +"LivingAreaSource": "Plans" +"LotSizeAcres": 0.0459 +"LotSizeSquareFeet": 8000 +"MajorChangeTimestamp": "2026-02-07T05:11:36Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlsStatus": "Expired" +"OffMarketDate": "2026-02-05" +"OnMarketDate": "2025-08-14" +"OriginalEntryTimestamp": "2025-08-12T14:08:37Z" +"OriginalListPrice": 1350000 +"OriginatingSystemModificationTimestamp": "2026-02-07T05:11:36Z" +"OwnerName": "East End Builders" +"ParcelNumber": "2089-54-239-00-0015-0" +"PhotosChangeTimestamp": "2025-10-03T17:47:52Z" +"PhotosCount": 3 +"PostalCity": "Oceanside" +"PostalCodePlus4": "2311" +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-02-07T05:11:36Z" +"StreetName": "Elizabeth" +"StreetNumber": "254" +"StreetNumberNumeric": "254" +"StreetSuffix": "Avenue" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "18000" +"TaxAssessedValue": 12 +"TaxYear": "2024" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Full" +"KEY_TaxSource": "Other" +"KEY_ConcessionYN": "1" +"KEY_CurrentPrice": "1350000.00" +"KEY_PreviousStatus": "Withdrawn" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "3000.00" +"KEY_DownPaymentResourceYN": "0" +"KEY_RATIO_ListPrice_By_LivingArea": "450.00000" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "29411764.7059" +"KEY_RATIO_CurrentPrice_By_LivingArea": "450.00000" +"KEY_SourceSystemModificationTimestamp": "2025-08-06T14:03:24.610" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421338913')" +"provider_name": "One Key" +"Media": array:3 [ …3] +"ID": "27869" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5131 +post_id: "26612" +post_author: 1 +"ListingKey": "KEY421163104" +"ListingId": "893362" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-11-19T15:32:37Z" +"RFModificationTimestamp": "2025-11-19T15:35:49Z" +"ListPrice": 479900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1160.0 +"BuildingAreaTotal": 0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "25 Alhambra, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6254473 +"Longitude": -73.641469 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Hilary Becker" +"ListOfficeName": "Becker Realty Services Inc" +"ListAgentMlsId": "9022302" +"ListOfficeMlsId": "BCKR01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Welcome to this updated duplex townhouse featuring a private front patio and located in the sought after Alhambra Condominium. The first floor offers a spacious living room, a half bath as well as an oversized kitchen and dining area. The second floor offers two oversized bedrooms with large closets, full bath and a washer/dryer area. The unit also includes central air, new wall to wall carpet on the upper level and new appliances. Amenities include in ground pool, fitness center, sauna, clubhouse, party room and storage. Common charges cover the fee for heat, water and parking. This pet friendly community is in a prime location close to shopping, beaches, and restaurants. Can be delivered vacant or with current paying tenants in place (lease expires August 2025). Property is currently occupied, so please respect privacy - no showings or disturbances to current residents." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "645" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:3 [ …3] +"AttributionContact": "516-887-0677" +"BathroomsFull": 1 +"BuildingAreaUnits": "Square Feet" +"BuyerOfficeAOR": "LIBOR" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-07-24T19:04:19.557130+00:00" +"CumulativeDaysOnMarket": 69 +"DaysOnMarket": 69 +"ElementarySchool": "School 4" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-01-24" +"Heating": array:1 [ …1] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-887-0677" +"ListAgentEmail": "hilarybecker7@gmail.com" +"ListAgentKey": "326253941" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109659" +"ListOfficePhone": "516-887-0677" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-07-24" +"LivingAreaSource": "Other" +"MajorChangeTimestamp": "2025-11-19T15:30:59Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlsStatus": "Hold" +"OffMarketDate": "2025-10-01" +"OnMarketDate": "2025-07-24" +"OriginalEntryTimestamp": "2025-07-24T18:56:23Z" +"OriginalListPrice": 479900 +"OriginatingSystemModificationTimestamp": "2025-11-19T15:30:59Z" +"OwnerName": "Peter Fitzgerald" +"ParkingTotal": "100" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-01T19:46:36Z" +"PhotosCount": 10 +"PostalCity": "Oceanside" +"PriceChangeTimestamp": "2025-07-24T18:56:23Z" +"RoomsTotal": "5" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516 359-4489" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-11-19T15:30:59Z" +"StreetName": "Alhambra" +"StreetNumber": "25" +"StreetNumberNumeric": "25" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "8832" +"TaxYear": "2025" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "None" +"KEY_HoldDate": "2025-11-19" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "479900.00" +"KEY_PreviousStatus": "Pending" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "1160.00" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "413.70690" +"KEY_RATIO_CurrentPrice_By_LivingArea": "413.70690" +"KEY_SourceSystemModificationTimestamp": "2025-07-24T14:56:23.153" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421163104')" +"provider_name": "One Key" +"Media": array:10 [ …10] +"ID": "26612" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5132 +post_id: "26638" +post_author: 1 +"ListingKey": "KEY421121129" +"ListingId": "892198" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-01-01T07:09:39Z" +"RFModificationTimestamp": "2026-01-01T07:12:01Z" +"ListPrice": 949000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2388.0 +"BuildingAreaTotal": 2457.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "33 Nassau Parkway, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6499842 +"Longitude": -73.631106 +"YearBuilt": 1922 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Alexander Clanton SRS" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "190292" +"ListOfficeMlsId": "SPH05" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Welcome to 33 Nassau Parkway in Oceanside—a rare opportunity that combines long-term investment potential with the comfort of a classic Colonial home. Perfectly positioned adjacent to Mount Sinai South Nassau Hospital, one of the busiest and most respected hospitals on Long Island, this property offers both immediate and future upside that’s hard to match.\n This 4-bedroom, 2-bathroom Colonial sits proudly on an oversized 50x218 lot, surrounded by hospital-owned properties. For the savvy investor, that means two powerful advantages: the chance to generate steady rental income today and the strong possibility of a premium buyout tomorrow. With doctors, nurses, and staff constantly seeking nearby housing, the demand for rentals in this location is consistently high.\n Inside, the home balances charm and function. The main level features a formal living room with a cozy fireplace, a renovated kitchen with sleek granite countertops, a premium 36-inch Wolf range, and easy-to-maintain tile flooring throughout. Upstairs, four generously sized bedrooms provide ample flexibility—ideal for multi-tenant rental setup, or simply extra space to grow into.\n Beyond the home itself, the lot is a standout feature. The long private driveway leads to a detached two-car garage, while the expansive backyard opens the door to endless possibilities—whether it’s entertaining, gardening, or exploring future expansion.\n Whether you’re an investor searching for cash flow and appreciation or an end user looking for a spacious home in a dynamic location, 33 Nassau Parkway delivers. It’s rare to find a property that checks so many boxes: location, size, immediate utility, and long-term value.\n Don’t miss the chance to own in one of Oceanside’s most strategic and high-demand areas. This is more than just a house—it’s an opportunity. """ +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-461-5221" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "631-337-8319" +"CoListAgentEmail": "JD@thelenardteam.com" +"CoListAgentFullName": "Jon David Lenard" +"CoListAgentKey": "326164806" +"CoListAgentMlsId": "152157" +"CoListOfficeKey": "326115713" +"CoListOfficeMlsId": "SPH05" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "631-360-2800" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-07-28T20:39:23.834108+00:00" +"CrossStreet": "Oceanside Road" +"CumulativeDaysOnMarket": 120 +"DaysOnMarket": 120 +"Disclosures": array:1 [ …1] +"ElementarySchool": "School 5" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-01-01" +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-461-5221" +"ListAgentEmail": "aclanton@thelenardteam.com" +"ListAgentKey": "326200235" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115713" +"ListOfficePhone": "631-360-2800" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-07-28" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.2491 +"LotSizeSquareFeet": 10850 +"MajorChangeTimestamp": "2026-01-01T05:21:15Z" +"MajorChangeType": "Expired" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlsStatus": "Expired" +"OffMarketDate": "2026-01-01" +"OnMarketDate": "2025-08-11" +"OriginalEntryTimestamp": "2025-07-28T20:32:37Z" +"OriginalListPrice": 949000 +"OriginatingSystemModificationTimestamp": "2026-01-01T05:21:15Z" +"OwnerName": "33 Nassau Pkwy LLC" +"ParcelNumber": "2089-54-142-00-0049-0" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "2" +"PhotosChangeTimestamp": "2025-10-20T20:45:36Z" +"PhotosCount": 29 +"PostalCity": "Oceanside" +"PostalCodePlus4": "1547" +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "855-917-1600" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-01T05:21:15Z" +"StreetName": "Nassau" +"StreetNumber": "33" +"StreetNumberNumeric": "33" +"StreetSuffix": "Parkway" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15822.85" +"TaxAssessedValue": 624 +"TaxBlock": "142" +"TaxLot": "49" +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"KEY_Attic": "See Remarks" +"KEY_HoldDate": "2025-08-11" +"KEY_TaxSource": "Municipality" +"KEY_TaxSection": "54-142" +"KEY_CurrentPrice": "949000.00" +"KEY_OpenHouseCount": "1" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_LivingAreaSearchSqFt": "2388.00" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "397.40369" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "3809714.9739" +"KEY_RATIO_CurrentPrice_By_LivingArea": "397.40369" +"KEY_SourceSystemModificationTimestamp": "2025-07-22T11:43:16.613" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "386.24339" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "386.24339" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421121129')" +"provider_name": "One Key" +"Media": array:29 [ …29] +"ID": "26638" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5133 +post_id: "26517" +post_author: 1 +"ListingKey": "KEY421035029" +"ListingId": "889867" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T13:11:36Z" +"RFModificationTimestamp": "2026-03-29T13:13:28Z" +"ListPrice": 975000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2412.0 +"BuildingAreaTotal": 2412.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "163 Mott Street, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6266523 +"Longitude": -73.6334776 +"YearBuilt": 1967 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "John C. Gandolfo" +"ListOfficeName": "Coldwell Banker American Homes" +"ListAgentMlsId": "105241" +"ListOfficeMlsId": "BRMN05" +"OriginatingSystemName": "OneKey" +"PublicRemarks": """ Introducing 163 Mott St: The pinnacle of waterfront living in Oceanside. Experience this masterfully renovated 4-bedroom, 3-bathroom ranch, where luxury meets a boater’s paradise. From the elegant double-door entry, the home opens into a seamless layout featuring a spacious living room and formal dining area. The heart of the home is the massive eat-in kitchen and den, where an 8-foot slider leads to your private outdoor oasis.\n \n Boasting 100 feet of bulkhead, a private dock, and 3 floating docks, this property is truly a rare find. Retreat to the primary suite featuring a walk-in closet and private bath. Premium highlights include:\n \n New Hardwood Floors & Gas Fireplace\n Large Finished Walk-Up Attic (Perfect for a home office or bonus room)\n Brand-New Central Air, 200 Amp Electric, & Gas Heat/Cooking\n Expansive Deck & Yard for premier entertaining.\n \n Your waterfront lifestyle awaits at 163 Mott Street. """ +"Appliances": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-223-2525" +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-644-8097" +"CoListAgentEmail": "realtorgandolfo@aol.com" +"CoListAgentFullName": "Barbara L. Gandolfo" +"CoListAgentKey": "326249090" +"CoListAgentMlsId": "89085" +"CoListOfficeKey": "326109936" +"CoListOfficeMlsId": "BRMN05" +"CoListOfficeName": "Coldwell Banker American Homes" +"CoListOfficePhone": "516-223-2525" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "Nassau County" +"CreationDate": "2025-07-16T22:57:43.405578+00:00" +"CrossStreet": "Oceanside Rd." +"CumulativeDaysOnMarket": 256 +"DaysOnMarket": 273 +"Directions": "Oceanside Rd to Mott St." +"ElementarySchool": "School 9E-Boardman Elem School" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-05-18" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ …1] +"FrontageLength": "100" +"GarageSpaces": "1.5" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-779-8423" +"ListAgentEmail": "johngandolfosells@gmail.com" +"ListAgentKey": "326121593" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326109936" +"ListOfficePhone": "516-223-2525" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-07-15" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1849 +"LotSizeSquareFeet": 8056 +"MajorChangeTimestamp": "2025-12-07T22:57:23Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-16" +"OriginalEntryTimestamp": "2025-07-16T22:55:36Z" +"OriginalListPrice": 1250000 +"OriginatingSystemModificationTimestamp": "2026-03-29T13:10:09Z" +"OwnerName": "Tripp" +"ParcelNumber": "2089-54-349-00-0293-0" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "5" +"PhotosChangeTimestamp": "2026-03-29T13:11:36Z" +"PhotosCount": 46 +"PostalCity": "Oceanside" +"PostalCodePlus4": "5522" +"PreviousListPrice": 999000 +"PriceChangeTimestamp": "2025-12-07T22:57:23Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "516-223-2525" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-07-16T22:55:36Z" +"StreetName": "Mott" +"StreetNumber": "163" +"StreetNumberNumeric": "163" +"StreetSuffix": "Street" +"SyndicateTo": array:2 [ …2] +"TaxAnnualAmount": "15456.95" +"TaxAssessedValue": 651 +"TaxYear": "2024" +"Utilities": array:7 [ …7] +"View": "Water" +"VirtualTourURLBranded": "https://youtu.be/CC-5DVeOLdM" +"WaterSource": array:1 [ …1] +"WaterfrontFeatures": array:3 [ …3] +"WaterfrontYN": true +"KEY_Attic": "Walkup" +"KEY_TaxSource": "Municipality" +"KEY_CurrentPrice": "975000.00" +"KEY_OpenHouseCount": "1" +"KEY_ElectricCompany": "PSEG" +"KEY_AdditionalFeesYN": "0" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "1" +"KEY_MlsMajorChangeType": "Price Decrease" +"KEY_LivingAreaSearchSqFt": "2412.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_ShowingContactPhone2": "516-779-8423" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "404.22886" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "5273120.6057" +"KEY_RATIO_CurrentPrice_By_LivingArea": "404.22886" +"KEY_SourceSystemModificationTimestamp": "2025-07-16T07:04:05.527" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "404.22886" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.78000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "404.22886" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY421035029')" +"provider_name": "One Key" +"Media": array:46 [ …46] +"ID": "26517" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5134 +post_id: "28266" +post_author: 1 +"ListingKey": "KEY420979240" +"ListingId": "888262" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-11-05T19:06:00Z" +"RFModificationTimestamp": "2025-11-05T19:08:08Z" +"ListPrice": 685000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1666.0 +"BuildingAreaTotal": 1666.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "285 W Waukena Avenue, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.630941 +"Longitude": -73.630656 +"YearBuilt": 1954 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rhea Cory Knopf" +"ListOfficeName": "Compass Greater NY LLC" +"ListAgentMlsId": "91890" +"ListOfficeMlsId": "CMPA07" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "This is an Ocean Lea split with all newer windows, roof and siding just waiting for the new owner to do those cosmetic upgrades to turn it into their forever home. Amazing location, low taxes and great yard." +"Appliances": array:4 [ …4] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "516-375-7727" +"BathroomsFull": 2 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-09-17T15:21:51.123187+00:00" +"CumulativeDaysOnMarket": 49 +"DaysOnMarket": 49 +"ElementarySchool": "School 8" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-07-07" +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ …2] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-375-7727" +"ListAgentEmail": "cory.knopf@compass.com" +"ListAgentKey": "326263979" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326110404" +"ListOfficePhone": "516-764-6060" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-07-11" +"LivingAreaSource": "Public Records" +"LotSizeAcres": 0.1377 +"LotSizeSquareFeet": 6000 +"MajorChangeTimestamp": "2025-11-05T19:04:39Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlsStatus": "Hold" +"OffMarketDate": "2025-11-05" +"OnMarketDate": "2025-09-17" +"OriginalEntryTimestamp": "2025-07-12T12:24:57Z" +"OriginalListPrice": 699000 +"OriginatingSystemModificationTimestamp": "2025-11-05T19:04:39Z" +"OwnerName": "Gloria Bernstein" +"ParcelNumber": "2089-43-294-00-0034-0" +"PhotosChangeTimestamp": "2025-10-03T18:22:36Z" +"PhotosCount": 13 +"PostalCity": "Oceanside" +"PostalCodePlus4": "5058" +"PreviousListPrice": 699000 +"PriceChangeTimestamp": "2025-10-03T18:21:18Z" +"RoomsTotal": "8" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-11-05T19:04:39Z" +"StreetDirPrefix": "W" +"StreetName": "Waukena" +"StreetNumber": "285" +"StreetNumberNumeric": "285" +"StreetSuffix": "Avenue" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "13172" +"TaxAssessedValue": 487 +"TaxYear": "2024" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_Attic": "Partial" +"KEY_HoldDate": "2025-11-05" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "1" +"KEY_CurrentPrice": "685000.00" +"KEY_OpenHouseCount": "2" +"KEY_PreviousStatus": "Active" +"KEY_ElectricCompany": "PSEG" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "1666.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "411.16447" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4974582.4256" +"KEY_RATIO_CurrentPrice_By_LivingArea": "411.16447" +"KEY_SourceSystemModificationTimestamp": "2025-07-11T13:56:41.747" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "411.16447" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97997" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "411.16447" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420979240')" +"provider_name": "One Key" +"Media": array:13 [ …13] +"ID": "28266" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5135 +post_id: "26416" +post_author: 1 +"ListingKey": "KEY420942961" +"ListingId": "887356" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Hold" +"ModificationTimestamp": "2025-08-26T07:07:41Z" +"RFModificationTimestamp": "2025-08-26T07:13:06Z" +"ListPrice": 920000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1323.0 +"BuildingAreaTotal": 1323.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "520 Farrington Road, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.6461678 +"Longitude": -73.6507498 +"YearBuilt": 1926 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sheahan Sewgobind" +"ListOfficeName": "New York 1 Homes Network Inc" +"ListAgentMlsId": "200707" +"ListOfficeMlsId": "NNWK01" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Newly Renovated June 2025 - Location, Location, plus over 10K Sq Ft LOT ! This beautiful, updated 4-bedroom, 3-full-bath house features old-style charm with a touch of modern updates. The full, finished basement offers additional living or storage space, while the one-car attached garage provides convenient access directly into the house. Enjoy outdoor living on a large deck with an awning, overlooking an expansive backyard with ample space for a pool. Indoors, you'll find a large living room, a formal dining room, and an eat-in kitchen filled with natural light. Situated on a lovely street, this home combines classic charm with functional living spaces. Don't miss out on this very unique opportunity! ! Must see" +"Appliances": array:6 [ …6] +"ArchitecturalStyle": array:1 [ …1] +"AttributionContact": "718-322-5100" +"Basement": array:2 [ …2] +"BasementYN": true +"BathroomsFull": 3 +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:3 [ …3] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-07-09T20:38:35.279568+00:00" +"CumulativeDaysOnMarket": 47 +"DaysOnMarket": 47 +"Directions": "Long Beach Rd To Rockaway Ave. To Farmington Rd." +"ElementarySchool": "School 2" +"ElementarySchoolDistrict": "Oceanside" +"ExpirationDate": "2026-01-09" +"Fencing": array:6 [ …6] +"Flooring": array:1 [ …1] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ …1] +"HighSchool": "School 7-Oceanside Senior Hs" +"HighSchoolDistrict": "Oceanside" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "347-581-3088" +"ListAgentEmail": "soldbysheahan1@gmail.com" +"ListAgentKey": "326210230" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326114110" +"ListOfficePhone": "718-322-5100" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2025-07-09" +"LivingAreaSource": "Public Records" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.2359 +"LotSizeDimensions": "75x146" +"LotSizeSquareFeet": 10275 +"MajorChangeTimestamp": "2025-08-25T18:10:04Z" +"MajorChangeType": "Hold" +"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School" +"MiddleOrJuniorSchoolDistrict": "Oceanside" +"MlsStatus": "Hold" +"OffMarketDate": "2025-08-25" +"OnMarketDate": "2025-07-09" +"OriginalEntryTimestamp": "2025-07-09T20:35:57Z" +"OriginalListPrice": 940000 +"OriginatingSystemModificationTimestamp": "2025-08-25T18:10:04Z" +"OwnerName": "Wilkinson Street LLC" +"ParcelNumber": "2089-38-411-00-0003-0" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-07-09T20:37:36Z" +"PhotosCount": 33 +"PostalCity": "Oceanside" +"PostalCodePlus4": "1119" +"PreviousListPrice": 940000 +"PriceChangeTimestamp": "2025-08-05T17:20:46Z" +"PropertyCondition": array:1 [ …1] +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingContactPhone": "347-581-3088" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2025-08-25T18:10:04Z" +"StreetName": "Farrington" +"StreetNumber": "520" +"StreetNumberNumeric": "520" +"StreetSuffix": "Road" +"SyndicateTo": array:1 [ …1] +"TaxAnnualAmount": "11763" +"TaxAssessedValue": 454 +"TaxYear": "2024" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"YearBuiltEffective": 2025 +"KEY_Attic": "Crawl" +"KEY_Hamlet": "Oceanside" +"KEY_Village": "Hempstead" +"KEY_HoldDate": "2025-08-25" +"KEY_TaxSource": "Municipality" +"KEY_ConcessionYN": "1" +"KEY_CurrentPrice": "920000.00" +"KEY_OpenHouseCount": "0" +"KEY_PreviousStatus": "Active" +"KEY_NumberOfKitchens": "1" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Temp Off Market" +"KEY_LivingAreaSearchSqFt": "1323.00" +"KEY_NumberOfHeatingZones": "2" +"KEY_OpenHousePublicCount": "0" +"KEY_DownPaymentResourceYN": "1" +"KEY_RATIO_ListPrice_By_LivingArea": "695.38927" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "3899957.6092" +"KEY_RATIO_CurrentPrice_By_LivingArea": "695.38927" +"KEY_SourceSystemModificationTimestamp": "2025-07-09T16:35:57.120" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "695.38927" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97872" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "695.38927" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420942961')" +"provider_name": "One Key" +"Media": array:33 [ …33] +"ID": "26416" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5136 +post_id: "26359" +post_author: 1 +"ListingKey": "KEY420855384" +"ListingId": "884949" +"PropertyType": "Commercial Sale" +"PropertySubType": "Mixed Use" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-02-01T07:02:41Z" +"RFModificationTimestamp": "2026-02-01T07:07:53Z" +"ListPrice": 1200000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 12001.0 +"LivingArea": 0 +"BuildingAreaTotal": 2662.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "3233-3235 Long Beach Road Unit 3233, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Carl H. Isaacson" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "219790" +"ListOfficeMlsId": "SPH15" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Mixed use property site consisting of commercial, residential, all with Additional free parking in the adjacent 25-car Municipal lot. This site has it all! Ground floor retail, and detached residential house, all situated on 1/4 acre of land. If you've been searching for the right opportunity, then stop right here. This property offers a clean canvas for your imagination to create your perfect workspace. With a newly renovated 3 bed 1 bath residential unit, you won't find a better bargain. Feel confident making the investment, as your neighbors include: Trader Joes, Costco, GAP, Nathans Famous, Wild By Nature, CVS and more. With a traffic count of 40,000 VPD, you'll be sure to have a steady flow of potential customers visiting your new location. If you're an investor or an "end user" looking for a home for your business, you'll appreciate the 2 income streams available to you from the ground floor 1331 SF retail, detached 3 bedroom residential unit, and 1/4 acre of land for you to utilize. Use the property for your business while collecting rent to offset your costs with the lease income. The possibilities are endless." +"AttributionContact": "516-766-7900" +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Variety" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-458-4847" +"CoListAgentEmail": "rmanel@Signature Premier.com" +"CoListAgentFullName": "Robert D. Manel" +"CoListAgentKey": "326132189" +"CoListAgentMlsId": "116555" +"CoListOfficeKey": "326115723" +"CoListOfficeMlsId": "SPH15" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "516-766-7900" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-07-02T23:32:34.728518+00:00" +"CumulativeDaysOnMarket": 213 +"DaysOnMarket": 213 +"Directions": "Long Beach Road to 3233-3235" +"ExpirationDate": "2026-01-31" +"Heating": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-220-7415" +"ListAgentEmail": "cisaacson@signaturepremier.com" +"ListAgentKey": "326228775" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115723" +"ListOfficePhone": "516-766-7900" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-07-01" +"LotSizeAcres": 0.2755 +"LotSizeSquareFeet": 12001 +"MajorChangeTimestamp": "2026-01-31T16:17:28Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"NumberOfUnitsTotal": "2" +"OffMarketDate": "2026-01-31" +"OnMarketDate": "2025-07-02" +"OriginalEntryTimestamp": "2025-07-02T23:29:00Z" +"OriginalListPrice": 1200000 +"OriginatingSystemModificationTimestamp": "2026-01-31T16:17:28Z" +"OwnerName": "Birkat Hashem LLC" +"ParcelNumber": "2089-43-368-00-0039-0" +"PhotosChangeTimestamp": "2026-01-31T16:18:36Z" +"PhotosCount": 6 +"PostalCity": "Oceanside" +"PostalCodePlus4": "3600" +"PriceChangeTimestamp": "2025-07-02T23:29:00Z" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "NY" +"StatusChangeTimestamp": "2026-01-31T16:17:28Z" +"StreetName": "Long Beach" +"StreetNumber": "3233-3235" +"StreetNumberNumeric": "3233" +"StreetSuffix": "Road" +"SyndicateTo": array:3 [ …3] +"TaxAnnualAmount": "20827.45" +"TaxAssessedValue": 2833 +"TaxYear": "2024" +"UnitNumber": "3233" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"KEY_CurrentPrice": "1200000.00" +"KEY_PreviousStatus": "Active" +"KEY_ShowingTimeFlagYN": "0" +"KEY_MlsMajorChangeType": "Expired" +"KEY_NumberOfResidentialUnits": "1" +"KEY_RATIO_ListPrice_By_LotSizeAcres": "4355716.8784" +"KEY_SourceSystemModificationTimestamp": "2025-07-02T19:29:00.543" +"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "450.78888" +"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000" +"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "450.78888" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY420855384')" +"provider_name": "One Key" +"Media": array:6 [ …6] +"ID": "26359" } 18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5137 +post_id: "26358" +post_author: 1 +"ListingKey": "KEY420855018" +"ListingId": "884942" +"PropertyType": "Commercial Lease" +"PropertySubType": "Mixed Use" +"StandardStatus": "Expired" +"ModificationTimestamp": "2026-02-01T07:02:41Z" +"RFModificationTimestamp": "2026-02-01T07:07:53Z" +"ListPrice": 3600.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 12001.0 +"LivingArea": 0 +"BuildingAreaTotal": 1331.0 +"City": "Hempstead" +"PostalCode": "11572" +"UnparsedAddress": "3235 Long Beach Road Unit 3233, Hempstead, New York 11572" +"Coordinates": array:2 [ …2] +"Latitude": 40.7092836 +"Longitude": -73.6230362 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Carl H. Isaacson" +"ListOfficeName": "Signature Premier Properties" +"ListAgentMlsId": "219790" +"ListOfficeMlsId": "SPH15" +"OriginatingSystemName": "OneKey" +"PublicRemarks": "Retail space available for lease on Long Beach Road in Oceanside. Approximately 1331 SF, with previous food preparation usage. Long Beach road is the main conduit that connects Oceanside to Rockville Centre, Island Park, and Long Beach. Oceanside is home to many national and local brands, including Costco, Advanced Auto, TJ Max, McDonald's, and the newly expanded Mount Sinai Hospital. With an approximate 40,000 VPD volume, you can expect a steady flow of potential customer traffic. On-street parking is available, and a 25-car municipal parking lot is adjacent to the building." +"AttributionContact": "516-766-7900" +"BuildingAreaSource": "Public Records" +"BuildingAreaUnits": "Square Feet" +"BusinessType": "Variety" +"CoListAgentAOR": "LIBOR" +"CoListAgentDirectPhone": "516-458-4847" +"CoListAgentEmail": "rmanel@Signature Premier.com" +"CoListAgentFullName": "Robert D. Manel" +"CoListAgentKey": "326132189" +"CoListAgentMlsId": "116555" +"CoListOfficeKey": "326115723" +"CoListOfficeMlsId": "SPH15" +"CoListOfficeName": "Signature Premier Properties" +"CoListOfficePhone": "516-766-7900" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Nassau County" +"CreationDate": "2025-07-02T23:17:10.408554+00:00" +"CumulativeDaysOnMarket": 213 +"DaysOnMarket": 213 +"Directions": "Long Beach Road to 3233-3235" +"ExpirationDate": "2026-01-31" +"Heating": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseAmountFrequency": "Monthly" +"LeaseTerm": "Negotiable" +"ListAOR": "LIBOR" +"ListAgentAOR": "LIBOR" +"ListAgentDirectPhone": "516-220-7415" +"ListAgentEmail": "cisaacson@signaturepremier.com" +"ListAgentKey": "326228775" +"ListOfficeAOR": "LIBOR" +"ListOfficeKey": "326115723" +"ListOfficePhone": "516-766-7900" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-07-01" +"LotSizeAcres": 0.2755 +"LotSizeSquareFeet": 12001 +"MajorChangeTimestamp": "2026-01-31T16:18:01Z" +"MajorChangeType": "Expired" +"MlsStatus": "Expired" +"NumberOfUnitsTotal": "1" +"OffMarketDate": "2026-01-31" +"OnMarketDate": "2025-07-02" +"OriginalEntryTimestamp": "2025-07-02T23:15:24Z" +"OriginalListPrice": 3700 +"OriginatingSystemModificationTimestamp": "2026-01-31T16:18:01Z" +"OwnerName": "Birkat" …40 } 19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5138 …162} 20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5139 …143} 21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5140 …130} 22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5141 …110} 23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5142 …152} 24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5143 …135} 25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5145 …114} 26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5114 …97} 27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5113 …128} 28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5112 …134} 29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5111 …162} 30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5110 …142} 31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5109 …123} ] +success: true +page_size: 32 +page_count: 7 +count: 204 +after_key: "" } "RF Response Time" => "0.26 seconds" ] ]