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 = 'laie' OR postalCode = 'laie' OR region like '%|laie|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Aloha!
My name is Lindsey and I'm happy to be your host in beautiful Laie, located on the world-famous North Shore of Oahu. Like the hibiscus in our yard, I grew up here and love this town so much that I'm raising my own children in this side of...
Registration Number: TA-171-005-3376-01, 55016
2 bedroom
1 bathroom
Sleeps 5
HI> Laie
Aloha!
My name is Lindsey and I was born and raised right here in beautiful Laie, HI located on the world famous North Shore of Oahu. This is our personal family home and we will go going on vacation for the month of July. I love this town so ...
Registration Number: TA-171-005-3376-01, 00005
4 bedroom
2 bathroom
Sleeps 10
HI> Laie
WE ALREADY HAVE A VERY HIGH CLEANING STANDARD FOR OUR HOME AND DUE TO COVID-19, WE HAVE ADDED INCREASED SANITATION WITH APPROVED ANTI-BACTERIAL CLEANERS THROUGHOUT AND TO HIGH TOUCH AREAS.
This beautiful 3 bedroom home is steps away from ...
Registration Number: TA-018-462-4128-01, 55016
3 bedroom
2 bathroom
Sleeps 7
HI> Laie
Welcome to Waipuna Cottage, a charming oceanfront property located on a private secluded estate with panoramic coastline views. This beautiful cottage features an open living space with sliding, glass doors that open the home to panoramic ocean...
Registration Number: TA-047-284-4288-01, GE-04
2 bedroom
2 bathroom
Sleeps 6
HI> Laie
Laie, Oahu, North Shore Hawaii, 2 bedroom 1 bath apartment on the side of our newly constructed home. Queen bed in one room and the second bedroom has two twin beds, or it can be set up as a bunk bed, or even pushed together for a couple. Sofa ...
Registration Number: TA-096-782-1312-01, GE-09
2 bedroom
1 bathroom
Sleeps 6
HI> Laie
30 day rental
Description
Welcome to old Hawaii at Laie Ohana Escape - located in a quaint, low key, legitimate seaside neighborhood within walking distance to everything. If you want to see what living in Hawaii is truly like, this is it!
...
Registration Number: TA-103-273-1136-01
5 bedroom
2 bathroom
Sleeps 13
HI> Laie
The PAPAYA 1 located on the Ocean Side with garden views of Tiki Moon Villas Located across from the Polynesian Cultural Center and is has its own private patio leading to the full garden areas on the beach. This 1 bedroom vacation rental in ...
Registration Number: TA-064-440-0128-01, GE-06
1 bedroom
1 bathroom
Sleeps 3
HI> Laie