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 '%Wailua Bay View%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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 unit is limited to a maximum of 2 adults. No children or pets are ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapa?a
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 unit is limited to a maximum of 2 adults. No children or pets are ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Fully stocked condo, steps to the beach, walk to shops and restaurants. Great location on the east side of the island, close to everything quiet complex, short walk to coconut market. The condo has everything you need.
Everything you need ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Located on a small bluff overlooking the expansive white sand beaches of Wailua Bay, this 1-bedroom, 1-bathroom Wailua Bay view condo rental is truly a haven tucked along the sea. Strolls on the beach, colorful sunrises and romantic moon rises ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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, ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Wailua Bay View 206
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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
"Seas the Day" at Wailua Bay View 105
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 is yours to enjoy from this ground floor ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa