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 '%Kuleana%') AND sleeps>=1 order by rating desc LIMIT 0, 20
This most sought after location in the complex is a ground floor corner unit offering privacy and just 10 paces away from one of the two almost private beaches, where you may find yourself alone.(Be aware that the beaches are subject to ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
The Kuleana Resort is located between the West Maui mountains and the ocean on the gold coast of Maui. Unit 411 is a one-bedroom, second-floor oceanfront unit amidst lush gardens. It is newly remodeled with granite counter tops and travertine ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Kuleana #303! Oceanfront Community! Prime location for island adventurers.
This ground floor condo has all the comforts of home with a bright, beachy vibe. Cozy open living space features large tile floors that help keep your space nice and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honokowai
Aloha and welcome to Kuleana Green Cottage!
If you're looking for a serene getaway in the heart of Hawaii, our newly renovated cottage is the perfect destination for you. With a refreshing private pool and lush greenery surrounding the ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Hilo
SEE OUR VIRTUAL TOUR BELOW! THIS UNIT SITS RIGHT ON THE WATER. Its a Corner second floor end unit OUT ON A POINT. The six foot picture window to your left views open ocean and the beach 50 feet away.
The lanai straight ahead views the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
The views from this recently remodeled and continuously upgraded third/top floor direct OCEANFRONT unit are spectacular, with the clear blue-green ocean vista and radiant sunsets over the islands of Lana'i and Moloka'i. From the lanai, you are ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Whether you are looking for a "private" beach, a swim in a heated pool or just want to take a few steps out to a lanai that almost reaches the beach, you will find it in our condo. You can sit on the lanai and watch the whales frolick (during ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Beautiful - Oceanfront - Ground Floor - Walk Out
Fabulous updated oceanfront condo location: Kuleana 605 is right on the ocean on Maui's pristine West Coast with gorgeous panoramic views of the Pacific Ocean and the lovely off-shore islands ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
The Kuleana Resort, the most beautiful property location in the world . Two ground floor side-by-side condominiums. Rent one or rent both to take advantage of the adjoining passage door . See Listing 77031 and 77036 for adjoining ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
The Kuleana Resort, the most beautiful property location in the world . Two ground floor side-by-side condominiums. Rent one or rent both to take advantage of the adjoining passage door . See Listing 77031 and 77036 for adjoining ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
The views from this remodeled and upgraded (April, 2013- Present) ground floor direct OCEANFRONT unit are spectacular, with the clear blue-green ocean vista and radiant sunsets over the islands of Lana'i and Moloka'i. Step off your lanai and you...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Off grid luxury. Powered by state of the art photovoltics solar hot water. Surrounded by thousands of acres of DNLR land. Super quiet and private. Complete with granite counters, open beam celings, tiled shower, mountain and ocean views. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Naalehu
New on the rental market - Perfect gem!! oceanfront.
Whether you are looking for a "private" beach, a swim in a heated pool or just want to take a few steps out to a lanai that almost reaches the beach, you will find it in our condo. You ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Summary:
Building 5. Unit 516. 3rd floor. Kuleana provides the perfect combination of relaxation and recreation within a 4 acre oceanfront and garden setting. Pool, BBQ's, and putt putt green. There is no elevators in the Kuleana community. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Beautiful - Oceanfront - Ground Floor - Walk Out
Fabulous updated oceanfront condo location: Kuleana 607 is right on the ocean on Maui's pristine West Coast with gorgeous panoramic views of the Pacific Ocean and the lovely off-shore ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kahana
Kuleana is perfectly located between Kaanapali and Kapalua.
Ocean Front, 1 bedroom, 1 bath condo.
Private lanai
Swimming Pool
Tennis
BBQ Area
Air conditioning
Free parking and NO Resort Fees!
Take a breath of fresh ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
When you arrive at our condo, you will know that you have reached paradise! Kuleana is a low rise condominium complex built around serenity. As an OCEAN FRONT property, this unit is on the ocean front side. The property is located near Kahana, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Beautifully remodeled 1 bedroom 1 bath oceanfront condo. Sit on your private Lanai and watch the whales and turtles by day, listen to the waves crashing and tiki torches glowing by night.
Incredibly lush, tropical grounds of Kuleana ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Disclaimer: The calendar is not perfect and we encourage clients to make an inquiry first to check the availability before booking.
Please inquire before booking. Dates are not confirmed until Owner/Manager sends confirmation.
TRIP...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
This listing is a combination of 2 separate units within walking distance from each other.
Disclaimer: The calendar is not perfect and we encourage clients to make an inquiry first to check the availability before booking.
Please ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina