Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 552 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 552 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 552 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

9943 Kahakai Rd
Waimea, HI 96796
Moksha McClure with Oceanfront Sotheby's International Realty, original listing - (808) 826-7211

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 710 Square Feet
Agency: Oceanfront Sotheby's International Realty
Agency Phone: (808) 826-7211

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1939
Notes: This beautifully and thoroughly remodeled 2 bedroom, 2 bath home is in the heart of Waimea Town, just across the street from Waimea Beach. It’s close to popular local spots, giving you easy access to the beach and everything the historic town has to offer.<br /> <br /> The home’s new modern design features vaulted ceilings, new vinyl windows, new flooring, fresh paint inside and out, and new ceiling fans. The kitchen has been upgraded with new stainless steel appliances (Fridge, stove and dishwasher), new cabinets, butcher block countertops, and an oversized sink. The master bedroom has its own bathroom and a spacious walk-in closet. There is a street-facing covered lanai. <br /> <br /> The yard has a carport, covered lanai, laundry room and enclosed shower. The carport can fit 2 cars. The covered lanai provides a great spot for dining or relaxing. There’s an outdoor enclosed shower, ideal for rinsing off after a day at the beach. There is also a laundry room.<br /> <br /> This home is located in Waimea Town on Kahakai Road, just a short distance from the beach and the main street. You’ll be close to popular spots like Waimea Canyon and the historic Waimea Pier. Local favorites include JoJo’s Shave Ice, Wrangler’s Steakhouse and the historic Waimea Theater. If you're looking for a centrally located modern Westside beachy home, this one’s for you!<br /> <br /> Please note: this home is competitively priced for a quick sale to a cash buyer that will take this home through the permitting process.
MlsNumber: --
ListingId: 714407


Listing Provided By: Oceanfront Sotheby's International Realty, original listing
Phone: (808) 652-7387
Office Phone: (808) 826-7211
Agent Name: Moksha McClure
Disclaimer: Copyright © 2024 Hawaii Information Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App