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;

04-1176-a Kuhio Hwy
Kapaa, HI 96746
Michael Rodger with eXp Realty, original listing - (866) 549-8527

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,200,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 712 Square Feet
Agency: eXp Realty
Agency Phone: (866) 549-8527

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1938
Notes: Unit 2, The front building is a classic and quaint plantation style, 2 bedroom 1 bath home with a prime location In Kapaa's Commercial area with highway frontage and paved off street parking. Owner can apply for a commercial use permit to allow the existing single family residence to be converted into commercial use for various businesses. <br /> <br /> This property is unit # 2 CPR. Unit #1 is also for sale MLS #.? <br /> ?- Front CPR (unit 2) as a 2 bedroom 1 bath Potential Business Commercial use location. <br /> ?- Back CPR unit 1 is Main 3bdrm/2ba residential home.<br /> <br /> <br /> <br /> ?Information about unit 1 also for sale: 3 Bedroom 2 Bath home (unit 1) that has room for you & guests with privacy to spare. Views of the ocean & stream right from the lanai, make this a relaxing home for everyone. Its split-level design includes a vaulted ceiling upstairs and many windows on the lower level. The upstairs, is where you will find the kitchen, living area, master bedroom (king size bed), lanai with hot tub. The living area is upgraded with ceramic tile, large widows & sliding glass doors that lead to the large lanai. The large master suite is private, has a king size bed, & is tastefully decorated. The downstairs has two bedrooms, bathroom and laundry room. Both bedrooms are tastefully furnished and have sliding glass doors that lead out to the yard and beach which is just steps away. One bedroom has a king size bed, the other has two double beds.??<br /> ?Property has easy access.
MlsNumber: --
ListingId: 709740


Listing Provided By: eXp Realty, original listing
Phone: (808) 346-3094
Office Phone: (866) 549-8527
Agent Name: Michael Rodger
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