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 (registration_number like 'TA-%') AND (city = 'Ewa Beach' OR postalCode = 'Ewa Beach' OR region like '%|Ewa Beach|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Aloha! Beach themed home in west Oahu! Located next to many golf courses (7 courses within 4 mile radius), including the prestigious, Ernie Els designed, Hoakalei Country Club.
This 3Br, 2.5Bath 2-story townhome features 1200sq ft of living ...
Registration Number: TA-020-099-9424-01, GE-02
3 bedroom
3 bathroom
Sleeps 6
HI> Ewa Beach
Welcome to the BeachFront House!
On the beach!!
Relax with all family at this peaceful place to stay, when the waves from the Ocean break right onto the property walls. Enjoy cup of coffee in the morning with Honolulu and Diamond Head views!...
Registration Number: TA-128-779-7248-01, 91025
2 bedroom
1 bathroom
Sleeps 5
HI> Ewa Beach
🏖️🏄 Lodging right on the beach, perfectly situated for your dream vacation ! 🌴😎
Looking for the most relaxing and authentic Hawaii experience ? Nothing will compare with having access to your own private place right on the shore ...
Registration Number: TA-128-779-7248-01, GE-12
2 bedroom
1 bathroom
Sleeps 5
HI> Ewa Beach
🏖️🌴 Beautiful property right on the beach !
Perfectly peaceful and relaxing lodging for your dream vacation.
Experience the clean sandy beach, with the gentle ocean waves almost touching the property's perimeter wall.
Enjoy a ...
Registration Number: TA-128-779-7248-01, GE-12
1 bedroom
1 bathroom
Sleeps 2
HI> Ewa Beach
Notes
• Comfortable accommodations for a maximum of 6 guests. (adults and children). Only registered guests allowed on property.
• No visitors. No sub-leasing of the home and property. Maximum 2 vehicles on property.
• Absolutely no ...
Registration Number: TA-207-438-4384-01, 91024
2 bedroom
2 bathroom
Sleeps 6
HI> Ewa Beach
30-day minimum stay by required by law (*with some legal exceptions).
Roomy Guest House on beachfront lot
100Mbps up/down (measured) fiber-optic wifi
Well-appointed, large 1 bdm Guest house on private, gated beachfront lot, just steps from ...
Registration Number: TA-146-161-6640-01, 19102
1 bedroom
2 bathroom
Sleeps 4
HI> Ewa Beach
Enjoy the island lifestyle in this beautiful beach house that sits on the Pacific Ocean. Relax on the lanai and look out at the waves as the sea turtles pop their heads up for air. As you swing on the lanai with a cup of coffee, take a breath ...
Registration Number: TA-035-252-4288-02, GE-03
5 bedroom
3 bathroom
Sleeps 10
HI> Ewa Beach
At last you've arrived at your Hawaiian Vacation Getaway. You've been planning and looking forward to this moment for way too long! As you drive in through the gated entry the first thing you'll notice is the tropical landscaping…citrus fruit...
Registration Number: TA-178-175-1808-01
3 bedroom
2 bathroom
Sleeps 6
HI> Ewa Beach