BREATH TAKING GOLF COURSE VIEW / CLASSICS AT WAIKELE / PROPERTY AND YARD GROOMED / TWO STORY HOUSE (3) BEDROOMS & (3) BATHROOMS & (2) ENCLOSED GARAGE PARKING & FAMILY ROOM / COVERED PATIO OVER LOOKING THE GOLF COURSE AND SUNSET / PRIVATE DRIVEWAY / LOCATED IN A CUL-DE-SAC / VERY WELL MAINTAINED / ORIGINAL OWNER AND FAMILY RESIDENCE / ALL APPLIANCES / NEAR SHOPPING MALL, RESTAURANTS & GROCERY STORES / MUST SEE
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Waho' AND MLSAreaMajor = 'Waipahu' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)