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, rewritten_description,
(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 (registration_number like '%TA-%' or registration_number like '%TA %') AND (`headline` like '%Discovery Bay%') AND sleeps>=1 order by rating desc LIMIT 0, 50
PANORAMIC MOUNTAIN VIEWS, 5 Minute Walk to Beach, High Floor, Remodeled, Furnished and Fully Appointed. No smoking condo. Parking, Pool, Utilities, WIFI, BBQ, Gym, Sauna, Security, Washer/Dryer Included. Monthly.
Sweeping Views from High
Registration Number: GE-029-740-6464-01, TA-029-740-6464-01
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Honolulu
WAIKIKI / OCEAN VIEWS, 5 Minute Walk to Beach, Remodeled, Furnished and Fully Appointed. No smoking condo. Parking, Pool, Utilities, WIFI, BBQ, Gym, Sauna, Security, Washer/Dryer Included. Monthly.
Excellent Views from Breezy Lanai,
Registration Number: GE-029-740-6464-01, TA-029-740-6464-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
PANORAMIC HIGH RISE VIEWS, 5 Minute Walk to Beach, High Floor, Remodeled, Furnished. No smoking condo. Parking, Pool, Utilities, WIFI, BBQ, Gym, Sauna, Security, Washer/Dryer Included. Monthly.
Sweeping Views from High Rise, Tasteful and
Registration Number: GE-194-404-4544-01, TA-194-404-4544-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
PANORAMIC OCEAN VIEWS, 5 Minute Walk to Beach, High Floor, Furnished and Fully Appointed. No smoking room. Parking, Pool, Utilities, WIFI, BBQ, Gym, Security, Washer/Dryer Included. 1 MO Min.
Sweeping Ocean Views from High Rise, 2
Registration Number: GE-007-807-7952-01, TA-007-807-7952-01
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikiki
PANORAMIC OCEAN VIEWS, 5 Minute Walk to Beach, 1 Bed Room, Remodeled, Furnished and Fully Appointed. No smoking condo. Parking, Pool, Utilities, WIFI, BBQ, Gym, Security, Washer/Dryer Included. 1 Month Minimum / contact Agent.
Ocean Views
Registration Number: GE-078-011-1872-01, TA-078-011-1872-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
PANORAMIC OCEAN VIEWS, 5 Minute Walk to Beach, High Floor, Remodeled, Furnished and Fully Appointed including Bidets. Adjustable Beds. No smoking condo. Parking, Pool, Utilities, WIFI, BBQ, Gym, Sauna, Security, Washer/Dryer Included.
Registration Number: TA-014-569-5744-01, GE-014-569-5744-01
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Honolulu
Enjoy the vibrant energy of Honolulu from this stylish 1-bedroom condo perched on the 26th floor of Discovery Bay, offering sweeping views of the city skyline. Thoughtfully updated for comfort and convenience, this unit features a plush king
Registration Number: GE-118-700-0320-01, TA-118-700-0320-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Experience island living with comfort and style in this 37th-floor ocean-view condo at Discovery Bay! This inviting 1-bedroom unit features a queen bed, sleek vinyl flooring, refreshed furnishings, and a modern design perfect for a relaxing
Registration Number: TA-025-277-6448-01, GE-025-277-6448-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Enjoy the best of city living with scenic ocean views in this inviting studio on the 37th floor of Discovery Bay. Just steps from the beach, this spacious studio offers both comfort and convenience in the heart of Honolulu.
Large windows
Registration Number: GE-174-047-2320-01, TA-174-047-2320-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Welcome to your island escape in the sky! Located on the 24th floor of Discovery Bay, this beautifully renovated 1-bedroom, 1-bathroom condo offers 852 sq ft of comfortable living space and stunning views of Diamond Head, the city, and the lush
Registration Number: 1260120100488, GE-010-502-7584-01, TA-010-502-7584-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Soak in stunning views of the Pacific Ocean from this spacious 1-bedroom, 1-bath condo located on the 35th floor of Discovery Bay! With 769 sq ft of comfortable living space, this fully furnished unit features a full kitchen, king bed in the
Registration Number: 1260120100595, GE-010-502-7584-01, TA-010-502-7584-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Step into comfort and style with this beautifully furnished condo offering breathtaking city views. The enclosed lanai doubles as a cozy office space, perfect for those who need to work or just enjoy the view in peace. Relax in the luxurious
Registration Number: TA-044-683-4688-01, GE-044-683-4688-01, 260120100352
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Enjoy comfort and convenience in this updated, fully furnished 2-bedroom, 2-bathroom condo with city views from the 9th floor of Discovery Bay. The full kitchen and spacious layout make it perfect for families, friends, business travelers, or
Registration Number: GE-196-233-6256-01, TA-196-233-6256-01, 260120100012
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Honolulu
