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 Ocean VIEWS, 5 Minute Walk to Beach, High Floor, Remodeled, Furnished and Fully Appointed. No smoking room. Parking, Pool, Utilities, WIFI, BBQ, Gym, Security, Washer/Dryer Included. 1 Month Minimum / contact Agent.
Sweeping ...
Registration Number: GE-029-740-6464-01, TA-029-740-6464-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Waikiki
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
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> Waikiki
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
This condo is located on the 25th floor of Discovery Bay, Endeavor Tower. With a full kitchen & fully furnished, this unit is the perfect spot to be your new home in Waikiki!
KITCHEN
- Full Size Refrigerator
- ...
Registration Number: TA-175-339-5200-01, GE-175-339-5200-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
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
1 Bedroom Economy Ocean View on the 27th Floor!
This condo has two twin beds in the bedroom (can be pushed together for a larger bed size) and a sofa sleeper in the living area. Features FREE WIFI, cable tv, central AC and washer/dryer ...
Registration Number: TA-176-135-3728-01, GE-176-135-3728-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
1 Bedroom Ocean View on the 40th Floor!
This spacious 1-bedroom has a newly renovated kitchen and bathroom with new flooring and fresh paint. The condo also includes a new bed frame and queen mattress. Sofa sleeper in the living area. ...
Registration Number: GE-017-020-6720-01, 1260120100644, TA-017-020-6720-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
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
2 Bedroom Ocean View on the 23rd Floor!
This 2-bedroom, 2-bathroom condo is fully equipped and furnished, complete kitchen with dishwasher, microwave, central A/C, and washer/dryer. There is a king bed in the master bedroom, king bed in ...
Registration Number: GE-009-467-5968-01, TA-009-467-5968-01
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Honolulu
1 Bedroom Deluxe City View on the 22nd Floor!
This spacious condo of 852 sq ft offers a full kitchen and is fully furnished. There is a king bed in the bedroom and you'll have views of the Pacific Ocean from the condo. Condo includes ...
Registration Number: TA-210-168-4224-02, GE-210-168-4224-02
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
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 14th Floor!
This roomy 1-bedroom has a queen bed There is FREE WIFI, cable services, central A/C, washer/dryer and 1-assigned parking stall. Forgot the hotels, enjoy the comforts of home while on ...
Registration Number: GE-008-843-1104-01, TA-008-843-1104-01, 1260120100391
- 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
1 Bedroom City View on the 27nd Floor!
This newly renovated condo of 852 sq ft offers a full kitchen and is fully furnished. Condo includes central A/C, washer/dryer, cable TV, FREE WIFI, and one assigned parking stall. ...
Registration Number: 260120100518, GE-133-424-5888-01, TA-133-424-5888-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
1 Bedroom City View on the 10th Floor!
This condo features an enclosed lanai that is used as an office, leather furniture, and a comfortable king-size bed in the bedroom. Features FREE WIFI, cable tv, central AC and washer/dryer in the ...
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
Just a few minutes walk from the famous beaches of Waikiki, this spacious, ocean facing, 1 bedroom 1 bathroom unit in Discovery Bay gives you the perfect opportunity to live the Hawaii city life with tree top and ocean views. Just two floors ...
Registration Number: 260120100042, GE-028-829-9008-01, TA-028-829-9008-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu