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 '%Kona Mansions%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Maximum occupancy strictly enforced in accordance with local ordinances.
With ocean views, 5-minute walking distance to Honl’s Beach, and onsite amenities including inground pool and outdoor grill, Kona Mansions #A303 offers all the ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kailua Kona
A GREAT location at a budget price!
Charming and freshly updated, Kona Mansions unit #C108 is within minutes of everything that Kailua Village “living" has to offer. With convenient proximity to Alii dr., experience a variety of ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Knutson & Associates is proud to be representing a spectacular condo!
Kona Mansions#229 is a wonderfully appointed property that has a phenomenal location.
Stunning ocean views, just steps from lively nightlife and the best of Island ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Knutson & Associates proudly welcomes you to this spectacular condo: Kona Mansions#301.
This beautiful top floor corner, 1 bedroom, 1 bath unit has incredible ocean views! Right when you walk in, it's got the WOW effect!
Being ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kailua Kona
Knutson & Associates proudly welcomes you to this beautiful new addition to our inventory as of November 2023, Kona Mansions#124.
You'll appreciate the details the home owner has put into the property for Vacation renters!
Interior newly ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Knutson & Associates proudly welcomes you to this gorgeous condo: Kona Mansions#302, Contemporary & Modern Aesthetic
This gorgeous top floor corner, 1 bedroom, 1 bath unit has incredible features. Right when you walk in, it's got the WOW ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua Kona
Knutson & Associates is proud to be representing a spectacular condo!
Kona Mansions#C105 is a wonderfully appointed property that has a phenomenal location.
Right in the heart of Kona town, just steps from lively nightlife and the best ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Knutson & Associates is proud to be representing a spectacular condo!
Kona MansionsC#211 is a wonderfully appointed property that has a phenomenal location.
Stunning ocean views, just steps from lively nightlife and the best of Island ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Maximum occupancy strictly enforced in accordance with local ordinances.
A complete Hawaiian experience can be found at Kona Mansions. This unit is a 1 bedroom, 1 bathroom ocean view condominium capable of accommodating up to 3 guests. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Welcome to Kona Mansions, Unit#C-309! Beautiful Top Floor Unit in Heart of Kona Town, Walk to everything!
Located in downtown Kailua, this front row, third-floor unit has spectacular ocean views in Kona Mansions condos.
Walk to Ali'i...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua Kona
Craving ocean views that whisk you away from the hustle and bustle of your day-to-day life? Longing to wake up with a cup of freshly brewed Kona coffee with sights of breaching humpback whales and jumping spinner dolphins in the distance? When ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Kona Mansions D-226
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This condo's convenient location right off Ali'i Drive leaves you within a...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Brand New Vacation Rental in 2024..This top floor, corner unit at Kona Mansions is a cozy and comfortable one-bedroom, one bathroom unit in the Best Building the development offers, Building A. You'll enjoy a captivating ocean view when walking ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
New on VRBO! This newly remodeled condo is in the heart of Kailua-Kona. Your home away from home comes complete with a full kitchen and washer and dryer! Inviting Dining Area, Living Room and a nice pool and BBQ for your use as well. About two ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua Kona
Knutson & Associates is proud to be newly representing a spectacular new addition to our Vacation Rental Inventory.
Kona Mansions#225 is a wonderfully appointed property that has a phenomenal location.
Stunning ocean views, just steps ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
