Your browser does not support the video tag.
Knowledge Center
Email Alerts
Mortgage/Credit Help
FAQ
Reviews
Professionals
Search
Refine Search
Beds:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Baths:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Property Type:
Any
Conventional
Foreclosure
Price Range:
to
Refine
DEBUG FN args: Array ( [0] => 551 [1] => MAUI [2] => HI [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 551 LocID: MAUI Region: HI State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 551 Igate: njhud LocID: 551 Region: MAUI State: HI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: 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 = 551 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 551 [1] => MAUI [2] => HI [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 551 LocID: MAUI Region: HI State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 551 Igate: njhud LocID: 551 Region: MAUI State: HI Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: 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 = 551 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 551 [1] => MAUI [2] => HI [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 551 LocID: MAUI Region: HI State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 551 Igate: njhud LocID: 551 Region: MAUI State: HI Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: 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 = 551 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Hawaii (HI) Foreclosure Listings
|
Maui
| Lanai City, Hawaii
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Lanai City, Maui, Hawaii
Displaying 1 to 10 of 10 Properties (0 foreclosures)
Okamoto Realty LLC
$950,000
3
bd /
2
ba /
1,423
sqft
351 Caldwell Ave
Lanai City
,
Hawaii
96763
Okamoto Realty LLC
$880,000
3
bd /
2
ba /
1,092
sqft
325 Thirteenth St
Lanai City
,
Hawaii
96763-0325
Okamoto Realty LLC
$798,000
3
bd /
2
ba /
1,144
sqft
1525 Pakali St
Lanai City
,
Hawaii
96763-1525
Okamoto Realty LLC
$789,000
3
bd /
2
ba /
976
sqft
325 Gay St
Lanai City
,
Hawaii
96763
Okamoto Realty LLC
$768,000
3
bd /
2
ba /
1,106
sqft
1320 Jasmine Dr
Lanai City
,
Hawaii
96763-1320
Okamoto Realty LLC
$725,000
3
bd /
1
ba /
846
sqft
1236 Jasmine Dr
Lanai City
,
Hawaii
96763-1236
Okamoto Realty LLC
$695,000
3
bd /
1
ba /
912
sqft
337 Ahakea St
Lanai City
,
Hawaii
96763
Okamoto Realty LLC
$648,000
3
bd /
1
ba /
800
sqft
444 Ilima Ave
Lanai City
,
Hawaii
96763-0444
Okamoto Realty LLC
$565,000
2
bd /
1
ba /
780
sqft
405 Lanai Ave
Lanai City
,
Hawaii
96763-4050
Okamoto Realty LLC
$440,000
1
bd /
1
ba /
495
sqft
615 Gay St
Lanai City
,
Hawaii
96763
Cities In MAUI, HI
Haiku
Hana
Hoolehua
Kahului
Kalaupapa
Kaunakakai
Kihei
Kualapuu
Kula
Lahaina
Lanai City
Makawao
Maunaloa
Paia
Pukalani
Puunene
Wailuku
lanai city
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => maui [3] => HI [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: maui State: HI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: maui State: HI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1
QUERY: 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 = 551 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Tyler MacArthur
ASCII
Hawaii Life - MacArthur Team Maui
work
Call Today!
:
(808) 283-6064
I'm interested in properties in MAUI, HI
1844867
1844867
0
Contact Me
USHUD.com on the Go!