COME DOWN THE DRIVEWAY AND CREATE YOUR OWN BEAUTIFUL GARDEN SPACE FULL OF VEGETABLES, FLOWERS, AND GREENERY. PRIVATE LOCATION AWAY FROM THE STREET. WELL MAINTAINED 3/1.5 W/ AN ADDITIONAL LARGE LIVING SPACE. SOLAR WATER HEATER AND STORAGE. NEW SCREENS. WOODEN FLOORS AND WALLS IN GOOD CONDITION. EXTERIOR NEWLY PAINTED. RECENTLY TENTED AS A PREVENTIVE MEASURE. GREAT LOCATION PUTTING YOU CLOSE TO CONVENIENCES-STORES, EATERIES, SCHOOLS, RECREATION, SERVICE PROVIDERS. GOOD TRANSPORTATION ACCESS. PROPERTY SOLD 'AS IS.'
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Niau' AND MLSAreaMajor = 'Waipahu' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)