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 '%Wailua Bay View%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Wailua Bay View Unit 306 is a premium ocean front condo with stunning views from the lanai. WBV 306 has been renovated with luxurious amenities.
This is a top floor unit with incredible views of the ocean and Wailua Beach. The lanai has a ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaʻa
Picturesque Oceanfront Wailua Bay View Condo with an Coastline View
Scenic Oceanfront View from this attractive top floor condo at Wailua Bay View. Decorative upgrades with splashes of color with a tropical Hawaiian touch helps you to feel at ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
Wailua Bay View Unit 312 is a premium ocean front condo with stunning views from the lanai. WBV 312 has been completely remodeled with luxurious amenities.
This is a top floor unit with incredible views of the ocean and Wailua Beach. The ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
Spectacular Oceanfront View Top Floor Corner Condo at Wailua Bay View
Dazzling views of the Wailua Bay from this condo. Your gaze will get lost on the horizon of the Pacific Ocean. Comfy Oceanfront living is yours to enjoy from this top floor ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
This second floor unit offers a breathtaking view of Wailua Bay. You will find yourself right on the ocean and far from the highway! Sit and relax on your private lanai while watching the waves roll in to Wailua beach. The view is truly ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Stunning Oceanfront View Top Floor Condo at Wailua Bay View Awaits You
Picture Perfect Oceanfront View from this top floor condo at Wailua Bay View. Enjoy the coastal view at this tastefully furnished condo. The white sand shoreline, amazing ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
Astonishing Oceanfront Ground Floor Beauty Awaits You at Wailua Bay View!
Tropical Oceanview stylish decorated condo. The view of the ocean and swaying coconut trees will put right into vacation mode from the time you step in this condo. Sun, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Picture Perfect Oceanfront Beauty Top Floor at Wailua Bay View!
View of the Sea from this cozy condo! Sun, Surf, and white sand beaches are calling you to come and relax. Let the view take your breath away and the sound of the waves your soul. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
Wailua Bay View 103
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Wailua Bay View Kauai vacation condos are exactly what you have been looking for. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Charming Wailua Bay View Oceanfront Top Floor with an Amazing View!
Panoramic view from this snug restful welcoming condo. You can sit back in your home away from home here with a cozy couch to sink into as you gaze at the ocean. Step out to ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
Wailua Bay View 307
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Wailua Bay View Kauai vacation condos are exactly what you have been looking for. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
"Seas the Day" at Wailua Bay View 105
New to Our Management! New Pictures Coming Soon!
Mesmerizing views from this Wailua Bay condo. Your gaze will get lost on the horizon of the Pacific Ocean and swaying coconut trees. Comfy Oceanfront living...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
"Sea Breeze" at Wailua Bay View 107
New to Our Management Starting in March!
Come enjoy the "Sea Breeze" oceanfront view at this Hawaiian Style decorated ground floor condo. The view of the ocean and swaying coconut trees will put right into ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
strong>"Bliss on the Bay" at the Wailua Bay View
New to Our Management Starting on April 15th! New Pictures Coming Soon!
Ocean front views from this Wailua Bay condo. Your gaze will get lost on the horizon of the Pacific Ocean and swaying ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
strong>"Sea Haven" At the Wailua Bay View
New to Our Management Starting on April 18th! New Interior Pictures Coming Soon!
Heavenly Ocean views from this Wailua Bay condo. Your gaze will get lost on the horizon of the Pacific Ocean and swaying ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
