CONTRACTORS’ SPECIAL! GREAT OPPORTUNITY TO CREATE YOUR OWN DREAM HOME in the highly desirable St. Louis Heights neighborhood! Conveniently located just minutes from restaurants, Ala Moana shopping center, Waikiki, Downtown and more! This existing 2 bedroom/1 bathroom home needs TLC, but does capture great ocean and city views. Bring your contractor to explore the opportunities.
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Alencastre' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)