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 = 'paia' OR postalCode = 'paia' OR region like '%|paia|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Walk to the beach and everything in Paia Town. Paia Family House is very spacious, well equipped, with a variety of comfortable indoor, and sweet outdoor living spaces for everyone! There's a yard where kids can play, and views out over the ...
4 bedroom
4 bathroom
Sleeps 8
HI> Paia
Clean, newly built 1 bedroom/1 bath with super fast internet and A/C. Situated in a quiet neighborhood in Kuau, away from the hustle and bustle of Paia but still just a short 1 mile car journey from the town. Kuau Beach and Mama’s Beach are ...
1 bedroom
1 bathroom
Sleeps 4
HI> Paia
Nalu House is the perfect home for a Maui vacation. This house, a beautiful designer remodeled home, combines old Hawaii's charm with all the modern amenities. Sit outside on a private covered lanai on relaxing lounge chairs to watch the ...
2 bedroom
3 bathroom
Sleeps 6
HI> Paia
Permitted Vacation Rental: BBPH\2015\0007
GE-085-716-5824-01 // TA-085-716-5824-01
This is 2bd/1 ba downstairs unit. The upstairs is occupied by owner but you will have your privacy.
Bedroom 1- Queen Size Bed, AC Unit, ceiling fan
Bedroom 2-...
2 bedroom
1 bathroom
Sleeps 4
HI> Paia
Maui Winds II Paia - permit # STPHT2013/0019 is perfect for family and friends or a couple. This breezy and charming home invites rest and relaxation and offers exciting activities for top-notch athletes ready to windsurf, surf or bike Maui's ...
2 bedroom
3 bathroom
Sleeps 4
HI> Paia
Maui County Rental permit - STPH 2018/0003 (this is a legal, permitted Maui vacation rental)
TA-066-523-9552-02 / GE-066-523-9552-02
TMK-260090240001
It's a Beach House! A place to relax, unwind, listen to the breeze through the palm trees, ...
4 bedroom
3 bathroom
Sleeps 8
HI> Paia
Starting July 8, vaccinated US visitors can avoid the negative Covid test taken <=72 hours prior to arrival. NAAT test from a CLIA certified laboratory. Note that there is no grace period for arriving without a negative Covid test by an ...
2 bedroom
1 bathroom
Sleeps 4
HI> Paia
Maui Country STPH permit # 20130018 GE/TAT 165-226-9056-01
4 bedroom, two bathroom, oceanfront cottage, sleeps 7, one rental group at a time. Relax in this charming 2 story house or under the palm trees. Enjoy the surf or nearby swimming beach....
4 bedroom
2 bathroom
Sleeps 7
HI> Paia
$320/night (+ 17.416%)(Permit # CP2001/0018 & HT ID TA-003-079-5776-01 & TMK 2-6-009-008).
Minimum stay 7 nights. Want to stay fewer days? At certain times of the year, or for last minute bookings, we might waive the minimum nights stay. Please...
1 bedroom
1 bathroom
Sleeps 2
HI> Paia
Gorgeous and elegant 3 Bedroom/3 Bath Beach Home, few steps from famous Baby Beach is waiting for your arrival. Perfect for couples. This beautiful and renovated Beach Home is your ticket to a perfect vacation. Nestled in a quiet upscale enclave...
3 bedroom
3 bathroom
Sleeps 5
HI> Paia
TA-059-556-6592-01 / GE-059-556-6592-01
TMK-380020030011
Within the gates of Sugar Cove, is a very special ocean front and beach front group of townhomes. This small, intimate property offers only three vacation homes for short term rental (the...
3 bedroom
4 bathroom
Sleeps 6
HI> Paia
STPH 2013/0004 Tax ID #TAT-080-639-5904-01
Nestled on Baldwin Avenue, our plantation style one bedroom cottage provides convenient and comfortable accommodations for 2 people, with the amenities of Historic Paia Town and Paia Bay just a few ...
1 bedroom
1 bathroom
Sleeps 2
HI> Paia
Grom's Hideaway is a charming cottage nestled in the heart of Kuau Point, the last little neighborhood 1 mile outside Paia(a 5 min drive), as you head out on Hana Highway.
Grom's has 3 bedrooms (king, queen and two twins) and 1 Bath with an ...
3 bedroom
2 bathroom
Sleeps 6
HI> Paia
Maui Country STPH permit # 20130018 GE/TAT 165-226-9056-01
2 bedroom oceanfront cottage, sleeps 4, one rental group at a time. Relax in this charming bungalow or under the palm trees. Enjoy the surf or the nearby swimming beach or watch the...
2 bedroom
1 bathroom
Sleeps 4
HI> Paia
**GUEST ARE REQUIRED TO REGISTER WITH THE STATE OF HAWAII SAFE TRAVELS WEBSITE PRIOR TO BOARDING THEIR FLIGHT**
Permit STPH 2015/0002 GET: 146669772802 TAT: 14666977280
Paia Ko is a quiet, lovely, 3 bedroom 2 and a half bath home with ...
3 bedroom
3 bathroom
Sleeps 6
HI> Paia