select * from (Select a.`postalCode`,a.`uniturl`, `region`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `source`, `property_type`, `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 and b.blocked=0 ) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%Kahana Villa%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Summary:
Enjoy your stay in Maui worry-free! Our short-term rental property is unaffected by any proposed legislation that may impact other accommodations. Book with confidence and experience the beauty of our island without any risk of ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to our slice of heaven located near Kahana Beach, a calm sandy beach great for swimming and relaxing. Our family friendly condo is affordably priced so guests can experience the beauty of the island in a lovely space.
Kahana Villa...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
This is a legally permitted vacation rental and hotel zone according to the County of Maui ordinances.
The Kahana Villas is a true gem of West Maui. With unobstructed ocean views of some of the most beautiful turquoise water in the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Kahana Village 3 bedroom, 2 bath condo
Oceanview
Washer and Dryer in Unit
Sleeps up to 8 people
Located near restaurants, bars, etc.
Pool, jacuzzi and BBQ areas
Spend your vacation at this highly sought after and new to the...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> lahaina
Kahana Villa 1 bedroom, 1 bath across from S-Turns Beach Park
Walk to restaurants and stores
Swimming Pool with BBQ Area
Tennis Courts
AC
Free parking and NO Resort Fees!
Welcome to paradise at the Kahana Villas and our ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
3 bedroom, 2 bath with walk-in shower in master bath and tub-shower combination in 2nd bath. Separate lighted vanity in master bath. Granite countertops, recessed lighting on dimmers and side by side refrigerator with ice and water on the door ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Discover the perfect retreat in our cozy one-bedroom condo, ideally situated just steps from the sandy shores of Kahana Beach. Drift off to sleep with the soothing sound of ocean waves in this beautifully appointed unit, which features elegant ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Kahana Village 2 bedroom, 2 bath condo
Oceanview
Sleeps up to 6 people
Washer and Dryer in Unit
Located near restaurants, bars, etc.
Pool, jacuzzi and BBQ areas
Spend your vacation at this highly sought after and newly ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> lahaina
Located in Napili-Honokowai, Kahana Villa is near the airport and near the beach. The area's natural beauty can be seen at Napili Bay and Kaanapali Beach. West Maui Parasail and Hawaii Nature Center of Iao Valley are also worth visiting. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
KAHANA VILLA RESORT
Maui, Hawaii
Enjoy elegant luxury in one and two bedroom units right across from Kahana Beach. Amenities include pool, tennis courts, and air conditioning.
Test the waters of nearby beaches famed for ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Enjoy returning each day to your luxurious suite with views of the ocean worthy of a postcard! Kahana Villa offers one-bedroom and 2-bedroom suites featuring a fully equipped kitchen, in-room washer/dryer and private lanai. All two-bedroom units...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Welcome to Kahana Villas E408 by Gather, a spacious two-bedroom, two-bathroom condo in the heart of Lahaina, HI. Located directly across the street from the beach, this condo offers a prime location and plenty of amenities to make your Hawaiian ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Welcome to Kahana Village Residence 37, a stunning 3-bedroom, 2-bath unit in West Maui. It offers breathtaking ocean views and an exceptional direct oceanfront location. The lush green space in front of the unit adds to the serene and inviting ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Let the ocean waves gently lull you into restful afternoon relaxation in this extra-spacious, beachfront 2 bedroom vacation condo.
Kahana Village #39 is nestled at the edge of the condo resort and overlooks the sandy shores along with the...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina