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-%' or registration_number like '%TA %') AND (`address` like '%444 Niu St%' ) order by rating desc LIMIT 0, 15
The condo is centrally located within walking distance to the beach, shopping and restaurants. Walk to the beach, convention center, mall, ...
Registration Number: GE and TA-177-814-3232-01
-
2
bedroom
-
2
bathroom
-
Sleeps 5
HI>
Honolulu
Newly renovated, this fresh, clean beach studio offers all you need for a Waikiki getaway. A California size mattress ensures you a the best ...
Registration Number: GE-026-678-1696-01, TA-02
-
0
bedroom
-
1
bathroom
-
Sleeps 2
HI>
Honolulu
Unit Description:
Walk to Waikiki beach, Ala Moana mall, convention center, restaurants, shops and many other Waikiki attractions in this newly...
Registration Number: GE and TA-177-814-3232-01
-
1
bedroom
-
1
bathroom
-
Sleeps 5
HI>
Honolulu
Unit Description:
Walk to Waikiki beach, Ala Moana mall, convention center, restaurants, shops and many other Waikiki attractions in this newly ...
Registration Number: GE and TA-177-814-3232-01
-
2
bedroom
-
2
bathroom
-
Sleeps 7
HI>
Honolulu
Newly renovated, clean and spacious studio in Waikiki. Unit is on 38th floor of the Hawaiian Monarch Hotel/Condo building and comes with queen ...
Registration Number: GE and TA-177-814-3232-01
-
1
bedroom
-
1
bathroom
-
Sleeps 3
HI>
Honolulu
Walk to Waikiki beach, convention center, Ala Moana mall, restaurants, shops and many other Waikiki attractions in this newly renovated unit with...
Registration Number: GE and TA-177-814-3232-01
-
1
bedroom
-
1
bathroom
-
Sleeps 2
HI>
Honolulu
Unit Description:
Walk to Waikiki beach, Ala Moana mall, convention center, restaurants, shops and many other Waikiki attractions in this newly ...
Registration Number: GE-177-814-3232-01, TA-17
-
1
bedroom
-
1
bathroom
-
Sleeps 2
HI>
Honolulu
A brand new apartment,Newly renovated, clean beach studio offers all you need for a Waikiki getaway. A Queen size mattress ensures you a the best...
Registration Number: GE-026-678-1696-01, TA-02
-
1
bedroom
-
1
bathroom
-
Sleeps 2
HI>
Honolulu
Fabulous, Modern Waikiki Studio privately owned Condo with an Awesome View! The unit is newly remodeled and upgraded with granite countertops, ...
Registration Number: GE-123-248-8448-01, TA-12
-
1
bedroom
-
1
bathroom
-
Sleeps 3
HI>
Honolulu
Relax in comfort on your vacation in Waikiki! The view is incredible, the furnishings and design are modern and comfortable with a new queen bed,...
Registration Number: GE-123-248-8448-01, TA-12
-
0
bedroom
-
1
bathroom
-
Sleeps 2
HI>
Honolulu
Relax in paradise in your luxury suite on the 29th floor of the Hawaiian Monarch Hotel in fabulous Waikiki Beach! This apartment is designed for ...
Registration Number: GE-123-248-8448-01, TA-12
-
1
bedroom
-
1
bathroom
-
Sleeps 3
HI>
Honolulu
You'll be sitting on top of the world at this spacious 2-bedroom, 2-bath Penthouse with open living room and fully-equipped kitchen.
The ...
Registration Number: TA-182-936-1664-01
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Honolulu
You will love the location, within walking distance to all the attractions of Waikiki! This privately owned cozy 212 sqft studio at the Hawaiian ...
Registration Number: GE-123-248-8448-01, TA-12
-
1
bedroom
-
1
bathroom
-
Sleeps 2
HI>
Honolulu
This just remodeled modern studio is the perfect getaway spot to enjoy your Waikiki vacation! On the 36th Floor, you have incredible views of the...
Registration Number: GE-123-248-8448-01, TA-12
-
1
bedroom
-
1
bathroom
-
Sleeps 2
HI>
Honolulu
You will feel at home in paradise in this wonderful, spacious studio condo in the heart of Waikiki! The view is awesome from this newly ...
Registration Number: GE-123-248-8448-01, TA-12
-
0
bedroom
-
1
bathroom
-
Sleeps 3
HI>
Honolulu
