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, 30
Summary:
Stunning views that turn into beautiful sunsets await you at Kahana Villa Resort E705. Soak in luxury in this fully updated top floor 2 bed/2 bath condo!
Location, Luxury & VIEWS VIEWS VIEWS! Welcome to Kahana Villa E705 where...
- 2 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 4
Hawaii> Lahaina
Our condo in Maui is a great location to everything! This is great for a romantic get away , family vacation. Whatever the occasion maybe we welcome you to stay at our condo. The condo has a lot of room to spread out and get comfortable.. Our ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
"The area of this condo was unaffected by the recent Lahaina Fires. Your visit will help Maui heal and rebuild after the fires. West Maui, has come back to life. Restaurants and shops are opening. Our Beaches, waterfalls and hikes are ...
- 2 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 ...
- 1 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
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
Enjoy this cozy unit and be lulled to sleep at night by the sounds of the ocean waves just across the street from Kahana Villa resort. This charming one-bedroom condo features beautifully appointed island Mango wood cabinetry throughout. You ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
* Special Offer - Book any KBM Resorts villa in Hawaii for 6 nights or more with a checkin date on or before December 15, 2023 and booked after May 11, 2023 and receive a 4-door rental car from one of our major rental car agency partners. The ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Admire a gorgeous view of the turquoise ocean, rustling palms, and the islands of Molokai and Lanai from your 4th-floor studio condo in Maui's beautiful Kahana Villas. Complete w/ AC & your own private lanai, enjoy a fully remodeled kitchen, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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
