select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `address`,round(price) as price,minimum_nights, `rating`, `review_count`,`latitude`, `longitude`,case when propertyName='' then trim(address) else CONCAT(CONCAT(propertyName,'(',trim(address)),'',')') end as addre,propertyName,
(6371 *
acos(
cos( radians( 21.2759167 ) ) *
cos( radians( `latitude` ) ) *
cos(
radians( `longitude` ) - radians( -157.8233677 )
) +
sin(radians(21.2759167)) *
sin(radians(`latitude`))
)
) as distance from `vacationrentalindex` a inner join vacationrentalindexfeed b on a.uniturl=b.unitUrl and a.headline!='' and a.thumbnailUrl!='' and b.enabled=1) as vw where 1 and round(price)>0 and bedrooms>=0 AND (city = 'kapalua' OR postalCode = 'kapalua' OR region like '%|kapalua|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Aloha and welcome to Kapalua located on the West side of Island of Maui. Our 1 bedroom 2 bath villa has been renovated with only top-of-the-line materials and furnishings. Full-size kitchen features granite counters and stainless-steel ...
1 bedroom
2 bathroom
Sleeps 4
HI> Kapalua
Kapalua translates to "arms embracing the sea" in Hawaiian. Enjoy one of the most special places on Maui at this 1-bedroom 1-bath Kapalua Bay Villa. Enjoy expansive views & the fresh island breeze from this second level unit with large bay ...
1 bedroom
1 bathroom
Sleeps 4
HI> Kapalua
THIS IS ONE OF THE GOOD ONES; NO DISAPPOINTMENTS HERE! ALL 5 STAR guest posted REVIEWS!
VERY COMPETITIVE PRICING; VERY WELL APPOINTED; VERY NICE VILLA!
Hawaii Tax ID# TA‐017‐672‐8064‐01
Aloha! Welcome to Hale 'Ikena Makai, pronounced ...
1 bedroom
2 bathroom
Sleeps 2
HI> Kapalua
Nestled in the luxurious KAPALUA BAY RESORT, you can vacation in the lap of luxury while enjoying an abundance of amenities. From one of the finest locations in paradise, you will enjoy world class sunsets from your bedroom or living area ...
4 bedroom
4 bathroom
Sleeps 8
HI> Kapalua
This nicely upgraded townhouse style 1 bedroom Kapalua Bay Villas vacation rental condo is on the bridge level with no stairs to the entry. Unit has central air conditioning, high definition LCD TV"s, wireless internet and unlimited long ...
2 bedroom
2 bathroom
Sleeps 4
HI> Kapalua
All new interior, very clean and tastefully decorated. On the Kapalua Bay Golf course with excellent ocean views. Central air conditioning, free high speed internet and free unlimited long distance calling to U.S. & Canada. Bedding is 1 King ...
1 bedroom
2 bathroom
Sleeps 4
HI> Kapalua
Nestled in the luxurious KAPALUA BAY RESORT, you can vacation in the lap of luxury while enjoying an abundance of amenities. From one of the finest locations in paradise, you will enjoy world class sunsets from your bedroom or living area ...
1 bedroom
2 bathroom
Sleeps 4
HI> Kapalua
Aloha – The Ridge, Kapalua.
Experience the Maui lifestyle by staying at our tropical, spacious and well-appointed contemporary remodeled townhouse style villa. Our romantic retreat is situated in a quiet and well appointed cul de sac on The ...
1 bedroom
2 bathroom
Sleeps 2
HI> Kapalua
Stay at your home away from home overlooking Kapalua Bay from your perch at Villa 1722. Start with breakfast in bed to take in the expansive water views. Plan you day with golf at one of the two Kapalua gold courses, tennis at the Kapalua ...
1 bedroom
2 bathroom
Sleeps 4
HI> Kapalua
Spectacular OCEANFRONT Kapalua Bay Villa, impeccably maintained and beautifully furnished. As you enter, you are welcomed by panoramic views of the glistening Pacific and Molokai. This lovely 1600+ sq. ft., ground floor unit has 2 spacious ...
2 bedroom
3 bathroom
Sleeps 4
HI> Kapalua
Welcome to Hale O Ho'okipa which translates in Hawaiian to 'House of Hospitality'.
Truly one of the nicest ocean front villas in the Kapalua Bay Villa Resort! Some make this claim without conviction, but we have provided quality photos and a ...
2 bedroom
3 bathroom
Sleeps 5
HI> Kapalua
Located at the Kapalua Bay Villas #11G2, "Kapalua Sunset" is a large, 1100 square foot, ground-floor single level, ocean view condominium spacious for 2 adults looking to stay in a comfortable home, not a "hotel condo". It is in walking ...
1 bedroom
1 bathroom
Sleeps 2
HI> Kapalua
State of Hawaii Transient Accommodations Tax License #TA-126-248-7552-01 and TA-017-586-7904-01. County of Maui Short-Term Rental License #Hotel-Zoned. Tax Map Key #420040280029
Aloha and welcome to Ocean Dreams Villa 2203, a Premier Ocean ...
4 bedroom
4 bathroom
Sleeps 8
HI> Kapalua
Complete renovations in this terrace-level (no stairs!) villa were completed late 2013. Walls were taken down to bare studs and everything was replaced. The owners had one thing in mind - make it their home away from home. In that quest they ...
1 bedroom
2 bathroom
Sleeps 4
HI> Kapalua
“Nana Kumole” in Kapalua Ridge Villas
Hawaii Life Vacations is proud to present Kapalua Ridge Villas #16 2/1. Nana Kumole which means spectacular view in Hawaian, is a two bd./ three bath residence sitting on the top row of villas ...
2 bedroom
3 bathroom
Sleeps 5
HI> Kapalua
