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, 50
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.
Oceanfront Oasis – Wraparound Lanai, Chef's Kitchen & Resort Pools
Hoʻokipa (hospitality) welcomes you to a luxurious ...
- 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
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
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. Offering breathtaking ocean views and an exceptional direct oceanfront location, this condominium provides the ultimate Hawaiian getaway. The lush green ...
- 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
