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 = '96779' OR postalCode = '96779' OR region like '%|96779|%') 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
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
Walk to everything in Paia Town. Paia Family Cottage is well equipped, with comfortable indoor, and sweet outdoor living spaces for everyone. There is AC in all bedrooms and living room. And a yard where kids can play, with views out over the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Paia
