a0E2S00000mpkIhUAI
NULL
array(39) {
["a0EUJ000000usFR2AY"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000000usFR2AY"
["post_id"]=>
string(6) "289982"
["office_id"]=>
string(5) "10932"
}
}
["a0E4U00001ELSCaUAP"]=>
array(2) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0E4U00001ELSCaUAP"
["post_id"]=>
string(6) "276968"
["office_id"]=>
string(4) "8052"
}
[1]=>
array(5) {
["start"]=>
string(28) "2024-04-21T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-22T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0E4U00001ELSCaUAP"
["post_id"]=>
string(6) "276968"
["office_id"]=>
string(4) "8052"
}
}
["a0EUJ000001JOcL2AW"]=>
array(2) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001JOcL2AW"
["post_id"]=>
string(6) "290685"
["office_id"]=>
string(4) "8052"
}
[1]=>
array(5) {
["start"]=>
string(28) "2024-04-21T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-22T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001JOcL2AW"
["post_id"]=>
string(6) "290685"
["office_id"]=>
string(4) "8052"
}
}
["a0EUJ000002CWKj2AO"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-21T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T23:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002CWKj2AO"
["post_id"]=>
string(6) "292120"
["office_id"]=>
string(4) "2340"
}
}
["a0EUJ000002Hefp2AC"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-21T22:00:00.000+0000"
["end"]=>
string(28) "2024-04-22T01:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002Hefp2AC"
["post_id"]=>
string(6) "292245"
["office_id"]=>
string(4) "2985"
}
}
["a0EUJ000001i0VB2AY"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001i0VB2AY"
["post_id"]=>
string(6) "291359"
["office_id"]=>
string(5) "23261"
}
}
["a0E4U00001ELkkjUAD"]=>
array(4) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-22T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-23T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0E4U00001ELkkjUAD"
["post_id"]=>
string(6) "279766"
["office_id"]=>
string(5) "22343"
}
[1]=>
array(5) {
["start"]=>
string(28) "2024-04-23T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-24T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0E4U00001ELkkjUAD"
["post_id"]=>
string(6) "279766"
["office_id"]=>
string(5) "22343"
}
[2]=>
array(5) {
["start"]=>
string(28) "2024-04-24T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-25T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0E4U00001ELkkjUAD"
["post_id"]=>
string(6) "279766"
["office_id"]=>
string(5) "22343"
}
[3]=>
array(5) {
["start"]=>
string(28) "2024-04-25T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-26T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0E4U00001ELkkjUAD"
["post_id"]=>
string(6) "279766"
["office_id"]=>
string(5) "22343"
}
}
["a0EUJ000002Es4E2AS"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-21T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-22T01:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002Es4E2AS"
["post_id"]=>
string(6) "292187"
["office_id"]=>
string(6) "168224"
}
}
["a0EUJ0000010yJl2AI"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-20T23:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ0000010yJl2AI"
["post_id"]=>
string(6) "290162"
["office_id"]=>
string(6) "168224"
}
}
["a0EUJ000002IV5p2AG"]=>
array(2) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002IV5p2AG"
["post_id"]=>
string(6) "292259"
["office_id"]=>
string(4) "2985"
}
[1]=>
array(5) {
["start"]=>
string(28) "2024-04-21T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-22T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002IV5p2AG"
["post_id"]=>
string(6) "292259"
["office_id"]=>
string(4) "2985"
}
}
["a0EUJ00000219jF2AQ"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-21T22:30:00.000+0000"
["end"]=>
string(28) "2024-04-22T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ00000219jF2AQ"
["post_id"]=>
string(6) "291830"
["office_id"]=>
string(5) "16822"
}
}
["a0EUJ0000025tsa2AA"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T22:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T03:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ0000025tsa2AA"
["post_id"]=>
string(6) "291940"
["office_id"]=>
string(5) "16822"
}
}
["a0EUJ0000027uE22AI"]=>
array(2) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-23T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-24T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ0000027uE22AI"
["post_id"]=>
string(6) "292012"
["office_id"]=>
string(5) "22343"
}
[1]=>
array(5) {
["start"]=>
string(28) "2024-04-24T23:30:00.000+0000"
["end"]=>
string(28) "2024-04-25T03:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ0000027uE22AI"
["post_id"]=>
string(6) "292012"
["office_id"]=>
string(5) "22343"
}
}
["a0EUJ0000013gAD2AY"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ0000013gAD2AY"
["post_id"]=>
string(6) "290244"
["office_id"]=>
string(4) "2985"
}
}
["a0EUJ000002JTA12AO"]=>
array(2) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002JTA12AO"
["post_id"]=>
string(6) "292275"
["office_id"]=>
string(4) "4035"
}
[1]=>
array(5) {
["start"]=>
string(28) "2024-04-21T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-22T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002JTA12AO"
["post_id"]=>
string(6) "292275"
["office_id"]=>
string(4) "4035"
}
}
["a0EUJ000001x5JG2AY"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-22T19:00:00.000+0000"
["end"]=>
string(28) "2024-04-23T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001x5JG2AY"
["post_id"]=>
string(6) "291708"
["office_id"]=>
string(4) "2985"
}
}
["a0EUJ000000QNAf2AO"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-21T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T13:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000000QNAf2AO"
["post_id"]=>
string(6) "289244"
["office_id"]=>
string(5) "24223"
}
}
["a0EUJ00000244bl2AA"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T22:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T01:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ00000244bl2AA"
["post_id"]=>
string(6) "291895"
["office_id"]=>
string(5) "23793"
}
}
["a0EUJ000002Ewz32AC"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T23:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T03:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002Ewz32AC"
["post_id"]=>
string(6) "292191"
["office_id"]=>
string(4) "2985"
}
}
["a0EUJ000002AULR2A4"]=>
array(2) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-21T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-22T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002AULR2A4"
["post_id"]=>
string(6) "292058"
["office_id"]=>
string(4) "4226"
}
[1]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002AULR2A4"
["post_id"]=>
string(6) "292058"
["office_id"]=>
string(4) "4226"
}
}
["a0EUJ000002ELrR2AW"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-21T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-22T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002ELrR2AW"
["post_id"]=>
string(6) "292170"
["office_id"]=>
string(5) "10995"
}
}
["a0EUJ000001GqWj2AK"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001GqWj2AK"
["post_id"]=>
string(6) "290616"
["office_id"]=>
string(4) "1267"
}
}
["a0EUJ000001h8OL2AY"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-20T23:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001h8OL2AY"
["post_id"]=>
string(6) "291326"
["office_id"]=>
string(4) "2452"
}
}
["a0EUJ0000020win2AA"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ0000020win2AA"
["post_id"]=>
string(6) "291817"
["office_id"]=>
string(4) "1267"
}
}
["a0E4U00001WbrzYUAR"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-20T23:00:00.000+0000"
["listing_id"]=>
string(18) "a0E4U00001WbrzYUAR"
["post_id"]=>
string(6) "287244"
["office_id"]=>
string(4) "3128"
}
}
["a0EUJ000001Vvz72AC"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001Vvz72AC"
["post_id"]=>
string(6) "291005"
["office_id"]=>
string(5) "20811"
}
}
["a0EUJ000001VswP2AS"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001VswP2AS"
["post_id"]=>
string(6) "291003"
["office_id"]=>
string(5) "23206"
}
}
["a0EUJ000002HcZB2A0"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-23T19:00:00.000+0000"
["end"]=>
string(28) "2024-04-23T21:30:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002HcZB2A0"
["post_id"]=>
string(6) "292242"
["office_id"]=>
string(5) "24223"
}
}
["a0EUJ000002JQVV2A4"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T01:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002JQVV2A4"
["post_id"]=>
string(6) "292271"
["office_id"]=>
string(4) "2340"
}
}
["a0EUJ000001d7CL2AY"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-21T19:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T22:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001d7CL2AY"
["post_id"]=>
string(6) "291191"
["office_id"]=>
string(4) "2985"
}
}
["a0EUJ000002KUFK2A4"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-25T19:00:00.000+0000"
["end"]=>
string(28) "2024-04-25T23:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002KUFK2A4"
["post_id"]=>
string(6) "292323"
["office_id"]=>
string(5) "23421"
}
}
["a0E4U00001Wbt1zUAB"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-25T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-25T23:00:00.000+0000"
["listing_id"]=>
string(18) "a0E4U00001Wbt1zUAB"
["post_id"]=>
string(6) "287587"
["office_id"]=>
string(4) "2985"
}
}
["a0EUJ000001jjlB2AQ"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:30:00.000+0000"
["end"]=>
string(28) "2024-04-20T22:30:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001jjlB2AQ"
["post_id"]=>
string(6) "291387"
["office_id"]=>
string(4) "3123"
}
}
["a0EUJ0000020rWD2AY"]=>
array(2) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-21T23:00:00.000+0000"
["end"]=>
string(28) "2024-04-22T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ0000020rWD2AY"
["post_id"]=>
string(6) "291811"
["office_id"]=>
string(5) "23337"
}
[1]=>
array(5) {
["start"]=>
string(28) "2024-04-20T23:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T02:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ0000020rWD2AY"
["post_id"]=>
string(6) "291811"
["office_id"]=>
string(5) "23337"
}
}
["a0EUJ000000c7V72AI"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000000c7V72AI"
["post_id"]=>
string(6) "289524"
["office_id"]=>
string(5) "23337"
}
}
["a0EUJ000002EzQi2AK"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T19:00:00.000+0000"
["end"]=>
string(28) "2024-04-20T23:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000002EzQi2AK"
["post_id"]=>
string(6) "292197"
["office_id"]=>
string(4) "2985"
}
}
["a0EUJ000001xqbV2AQ"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T20:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ000001xqbV2AQ"
["post_id"]=>
string(6) "291720"
["office_id"]=>
string(5) "23206"
}
}
["a0EUJ0000027D7f2AE"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-21T00:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ0000027D7f2AE"
["post_id"]=>
string(6) "292008"
["office_id"]=>
string(5) "23793"
}
}
["a0EUJ0000019RbV2AU"]=>
array(1) {
[0]=>
array(5) {
["start"]=>
string(28) "2024-04-20T21:00:00.000+0000"
["end"]=>
string(28) "2024-04-20T23:00:00.000+0000"
["listing_id"]=>
string(18) "a0EUJ0000019RbV2AU"
["post_id"]=>
string(6) "290412"
["office_id"]=>
string(6) "168224"
}
}
}
This type of mixed-use listing doesn’t come available often. This is a great opportunity to own your own store front, apartment and house. Approximately 4,000 square feet commercial and residential space. Main commercial space (currently used as a gallery) includes a loft and an apartment. Also included is a separate 2 bedroom, 1.5 bath house. The commercial property currently leases approximately 200 square feet to the US Post Office and the Waipio Valley Wagon tour company. The remaining commercial space is used as a gallery with commercial loading dock off the back of the property. Waipio Valley Lookout is still open and just a few miles away offering some of the most breathtaking views! People who live and work in Kukuihaele say it has the best weather on the island.
We are well known along the Kohala Coast for informed and experienced guidance—not only to buyers and sellers but to the development and investor communities as well.
CONTACT US808.657.4292
[email protected]
68-1330 Mauna Lani Drive, Suite 104,
Kohala Coast, HI 96743
Monday - Saturday 9am to 5pm
English, French & Japanese Spoken Here
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Listed By: Coldwell Banker Island Properties - Kamuela
$ Property price
% Down payment
30 Year Fixed, 4.00% Interest
MLS listing information is deemed reliable but is not guaranteed by the service.
07/31/2023
We are well known along the Kohala Coast for informed and experienced guidance—not only to buyers and sellers but to the development and investor communities as well.
CONTACT US808.657.4292
[email protected]
68-1330 Mauna Lani Drive, Suite 104,
Kohala Coast, HI 96743
Monday - Saturday 9am to 5pm
English, French & Japanese Spoken Here
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website, and helping our team to understand which sections of the website you find most interesting and useful. Learn more about how we use this information in our Privacy Policy.
You can adjust all of your cookie settings by navigating the tabs on the left hand side.
Strictly Necessary Cookie should be enabled at all times so that we may save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
