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,
(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
1 Bedroom City View on the 26th Floor!
This updated condo has a King bed, comes with central AC, washer/dryer in the condo, FREE WIFI, local telephone service and 1-assigned parking stall.
Discovery Bay is located at the gateway...
Registration Number: GE-118-700-0320-01, TA-118-700-0320-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
This condo is located on the 37th floor of Discovery Bay with beautiful views of the ocean from your living room or lanai! Forgot the hotels, you'll enjoy the comforts of home while on vacation or an extended trip when staying at this condo. ...
Registration Number: TA-025-277-6448-01, GE-025-277-6448-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
This studio is located on the 37th floor of Discovery Bay. You'll love this high floor, spacious studio with a beautiful view of the ocean. This may be a studio, but you will enjoy full size appliances and have the comforts of home while on ...
Registration Number: GE-174-047-2320-01, TA-174-047-2320-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
This condo is located on the 24th floor of Discovery Bay.
This spacious condo of 852 sq ft offers a full kitchen and is fully furnished and was significantly renovated in 2021. You'll love the fantastic location of Discovery Bay and the ...
Registration Number: 1260120100488, GE-010-502-7584-01, TA-010-502-7584-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
1 Bedroom Deluxe Ocean View on the 35th Floor!
This spacious condo of 769 sq ft offers a full kitchen and is fully furnished. There is a king bed in the bedroom and a queen sofa sleeper in the living room and you'll have views of 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
2 Bedroom Condo Suite City View on the 9th Floor!
This updated condo is fully furnished with a full kitchen. Spacious 2 bedroom and 2 bathroom makes this condo ideal for families, friends traveling together, co-workers on assignment, or ...
Registration Number: GE-196-233-6256-01, TA-196-233-6256-01, 260120100012
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Honolulu
