Fully remodeled front 2 beds and 1 bath in 2022 and built 3 beds and 2 baths addition in 2023. This brand new 3 beds/2 baths is connected to the 2 beds and 1 bath in the front, so a total of 5 beds/baths single family. Perfect for a multi-generational family. Convenient location near shopping center, beaches, parks, and schools.
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Water' AND MLSAreaMajor = 'Leeward' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)