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 = 'makaha' OR postalCode = 'makaha' OR region like '%|makaha|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
FREE AMENITIES INCLUDING ALL BEACH GEAR (chairs, umbrella, mat, cooler, snorkeling gear, boogie boards, beach towels)
FREE PARKING FREE WIFI
NO RESORT FEE NO HIDDEN FEES
We have other VRBO-listed BEACHFRONT condos--just ask us!
...
Registration Number: TA-058-874-4704-01, GE-05
1 bedroom
1 bathroom
Sleeps 4
HI> Makaha
NO WORRIES WHEN YOU RENT THIS BEACHFRONT CONDO!
HAWAII CERTIFICATE FOR LEGAL VACATION RENTAL (NUC): 90TVU-0098
NO RESORT FEE. NO PARKING FEE. NO WIFI FEE!
We also have several other VRBO-listed condos in SAME BEACHFRONT BUILDING available for...
Registration Number: TA-058-874-4704-01, GE-05
1 bedroom
1 bathroom
Sleeps 4
HI> Makaha
LEGAL VACATION RENTAL ON OAHU--has City/County permit!!!! NUC: 90/TVU-0084
NO RESORT FEE. NO PARKING FEE. NO WIFI FEE. NO HIDDEN FEES!
BEACHFRONT!!! LIGHT, BRIGHT, AIRY, AND SUPER CLEAN CONDO!
Lots of REVIEWS on our VRBO listing #41596 ...
Registration Number: TA-058-874-4704-01, GE-05
1 bedroom
1 bathroom
Sleeps 4
HI> Makaha
PLEASE ASK US ABOUT AVAILABILITY AND GUIDELINES.
NO RESORT FEE. NO PARKING FEE. NO WIFI FEE NO HIDDEN FEES
Enter your dates, number of adults/children w/ kids ages, and rates will show.
BEACHFRONT!!! Remodeled beautiful condo RIGHT ON...
Registration Number: TA-058-874-4704-01, GE-05
1 bedroom
1 bathroom
Sleeps 4
HI> Makaha
NO WORRIES WHEN YOU RENT THIS BEACHFRONT CONDO!
HAWAII CERTIFICATE FOR LEGAL VACATION RENTAL (NUC): 90TVU-0082
FREE PARKING! FREE IN-UNIT WiFi! NO RESORT FEE.
We also have several other VRBO-listed condos in SAME BEACHFRONT BUILDING ...
Registration Number: TA-058-874-4704-01, GE-05
1 bedroom
1 bathroom
Sleeps 4
HI> Makaha
Updated condo with all of the conveniences for a relaxing beach vacation (most importantly a beachfront spot on THE most under-rated beach on Oahu). I am from Hawaii and I was stunned when I first discovered this beach and loved it so much that ...
Registration Number: TA-041-636-0448-01, 84004
1 bedroom
1 bathroom
Sleeps 4
HI> Makaha