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 (`headline` like '%Kona Makai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Lovely top floor unit with great ocean view from both lanais. Well equipped with free WiFi and air conditioning.
OUR RESPONSE TIME is less than one hour on inquiries!!
King bed in master bedroom and the Loft bedroom has a queen bed.
Kona Makai ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
f you want to be close to the ocean you will love this condo.
OUR RESPONSE TIME is less than one hour on inquiries!!
Air-conditioned- 2 bedrooms and 2 baths, fully equipped kitchen, flat screen televisions in living room and master bedroom. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua-Kona
Stunning ocean views from the lanai, ocean front from the bedroom, the sounds of the surf on the rocks, and the spirit of Aloha welcomes you to our home in Hawaii. Kona Makai is a beautiful oceanfront complex with well maintained gardens, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua-Kona
This 2 bedroom 2 bath condo has everything you need to relax in paradise! Enjoy ocean views and gorgeous kona sunsets from your private lanai.
The well appointed kitchen is fully equipped to comfortably prepare meals/drinks and the spacious ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona
Enjoy the comfort and efficiency of Kona Makai 6301, a newly remodeled oceanfront condominium offering stunning coastline views and free Wifi. Located one mile from the heart of Kailua-Kona town, you'll have access to all the fun and excitement ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona
Come and enjoy our little Piece of Paradise in one the most beautiful complexes in Kona. Located just one mile south of the town of Kailua-Kona on Alii Drive. The unit, 1204, is on the second floor of building 1, the best building in the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua-Kona
Welcome to Kona Makai 6201, a two-bedroom, two-bathroom oceanfront unit, where the wrap-around lanai offers some of the best views on the island. In addition to tropically-inspired decor throughout, Kona Makai 6201 features free Wifi, highspeed ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
Kona Makai is an ocean front complex with a saltwater pool, hot tub, tennis courts, ocean front BBQ'S, a cabana room with tables, exercise room with aerobic machines, ping pong table, plenty of parking with a security gate at night. The complex ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kailua-Kona
**COVID 19 Restrictions: The State of Hawaii has updated their Safe Travels program. Please refer to https://hawaiicovid19.com/travel/faqs/ for the latest information about traveling to Hawaii and how to bypass the mandatory 10 day quarantine ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua-Kona
Kona Makai #1-301 is arguably the BEST condo in the entire complex! Being the top floor corner in building 1, the location is undeniably too perfect. Private & upgraded, this is direct oceanfront condo living at its finest. You can't get a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona
Kona Makai#2-201 is a fantastic option for your Hawaiian Vacation. The new owners have extensively updated the property with beautiful new furnishings, installed tile throughout the entire condo & have upgraded the property with everything any ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona
Kona Makai#2-102 is an excellent option for your Hawaiian Vacation. The owners have put BRAND NEW CARPET in the Property as of June 2018!
This spectacular ground floor unit is a true gem at the Kona Makai. Queen Sized Bed in Bedroom & Queen ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua-Kona
Bask in the beauty of Kona Makai 6305, a fully-remodeled, one-bedroom, one-bathroom oceanfront condominium. This stunning top-floor unit also features free Wifi, ocean views from the master suite and a wonderful loft with two twin beds. Located ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
HI> Kailua Kona
This gorgeous, newly-remodeled condominium gives you an authentic flavor of Hawaii. You'll love waking up to panoramic views of the Pacific Ocean in this tropical vacation paradise.
Fresh and updated, this beautiful condominium features air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona
Kona Makai 2304 is a beautifully remodeled two-bedroom, two-bathroom oceanfront condominium featuring miles of coastline views, free Wifi, and beach access just outside the property. Located on Ali'i Drive, Kona Makai is only one mile from the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
