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 = 'wailea' OR postalCode = 'wailea' OR region like '%|wailea|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
State of Hawaii Transient Accommodations Tax License #TA-071-739-0848-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910071
Castaway Cove C201 is located on Maui island, ranked #1 Best Luxury Destination in...
3 bedroom
4 bathroom
Sleeps 6
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-094-662-2464-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910063
Royal Ilima A201 is located on Maui island, ranked #1 Best Luxury Destination in ...
3 bedroom
4 bathroom
Sleeps 6
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-094-662-2464-03. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910057
Sandcastles Suite L509 is located on Maui island, ranked #1 Best Luxury ...
4 bedroom
3 bathroom
Sleeps 8
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-120-405-4016-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910056
Sandy Surf K508 is located on Maui island, ranked #1 Best Luxury Destination in ...
4 bedroom
3 bathroom
Sleeps 8
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-116-313-0880-02. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910076
Golden Mandarin Pool Villa D102 is located on Maui island, ranked #1 Best Luxury ...
3 bedroom
4 bathroom
Sleeps 6
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-122-323-9680-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910029
Aqua Lani J305 is located on Maui island, ranked #1 Best Luxury Destination in the...
3 bedroom
3 bathroom
Sleeps 6
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-102-149-9392-01. County of Maui Short-Term Rental License #Hotel-Zoned Resort. Tax Map Key #210080670011
SeaSpirit Villa 811 is located on Maui island, ranked #1 Best Luxury Destination ...
3 bedroom
4 bathroom
Sleeps 8
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-140-050-6368-02. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910075
Coco Palms Pool Villa D101 is located on Maui island, ranked #1 Best Luxury ...
3 bedroom
4 bathroom
Sleeps 6
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-131-414-5280-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910040
Modern Maui I404 is located on Maui island, ranked #1 Best Luxury Destination in ...
3 bedroom
2 bathroom
Sleeps 6
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-039-013-0176-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910080
Bella Luna D302 is located on Maui island, ranked #1 Best Luxury Destination in ...
3 bedroom
4 bathroom
Sleeps 6
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-126-119-1168-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910094
Floral Gardens Pool Villa G102 is located on Maui island, ranked #1 Best Luxury ...
3 bedroom
4 bathroom
Sleeps 6
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-182-491-7504-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910044
Mer Et Soleil K408 is located on Maui island, ranked #1 Best Luxury Destination in...
4 bedroom
3 bathroom
Sleeps 8
HI> Wailea
Located on the third tier on the south side of the Ho’olei Resort on Maui, our two-level villa has jaw-dropping Pacific Ocean views and is perfectly perched to capture the crystal blue sky during the day and breathtaking sunsets in the ...
3 bedroom
4 bathroom
Sleeps 8
HI> Wailea
Wailea Beach Villas F202 is where luxury, style and sophistication blend together in a stunning Maui location just above Wailea Beach. This immaculate villa showcasing gorgeous blue ocean views while encompassed by lush tropical trees is sure to...
2 bedroom
2 bathroom
Sleeps 6
HI> Wailea
Settle into your very own slice of Maui paradise with a stay in Wailea Beach Villas PH306. This exquisite two bedroom, two bath penthouse villa with exceptional ocean and island views are sure to inspire the luxury, comfort and serenity you ...
2 bedroom
2 bathroom
Sleeps 6
HI> Wailea