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 (`headline` like '%ilikai marina%') AND sleeps>=1 order by rating desc LIMIT 0, 15
UNOBSTRUCTED SUNSET/OCEAN VIEWS! STEPS TO WAIKIKI BEACH. Walk to parks, shopping mall, restaurants, shops, buses, rental cars & Waikiki night life. Parking available. No smoking room. Clean and fresh high floor.
UNOBSTRUCTED SUNSET/OCEAN VIEWS!...
Registration Number: TA-046-192-0768-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Completely redesigned and renovated unit, our large 1BR suite, kind bed, sofa bed in the living room, w spectacular Ocean views from balcony, new kitchen, located at The Ilikai Marina Condo. The best views in Honolulu w/ Ala Moana harbor ...
Registration Number: TA-032-035-4304-01, 26010
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
*AVAILABILITY CALENDAR IS ALWAYS CURRENT*
Hawaii Tax ID# 112-788-8896-01
This sixteenth-floor condominium, at the Ilikai Marina, has expansive views of the Pacific ocean, harbor, Waikiki Beach and Ala Moana Beach Park.
The expansive views at ...
Registration Number: TA-112-788-8896-01, GE-11
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Honolulu
** New to Website - July 2017 **
Great value for a superb oceanfront view condo in Waikiki. Close to beaches, Hilton Lagoon, surfing, restaurants and a short walk to Ala Moana Shopping Center. • Waikiki Oceanfront Location• Golfing, ...
Registration Number: TA-177-103-6672-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Great value for a superb oceanfront view condo in Waikiki. Close to beaches, Hilton Lagoon, surfing, restaurants and a short walk to Ala Moana Shopping Center. • Waikiki Oceanfront Location• Golfing, Tennis, Swimming, Snorkeling & Surfing ...
Registration Number: TA-177-103-6672-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
UNOBSTRUCTED SUNSET/OCEAN VIEWS! STEPS TO WAIKIKI BEACH. Walk to parks, shopping mall, restaurants, shops, buses, rental cars & Waikiki night life. Parking available. No smoking room. Clean and fresh high floor.
UNOBSTRUCTED SUNSET/OCEAN VIEWS!...
Registration Number: TA-021-620-5312-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Honolulu
STUNNING OCEAN & SUNSET VIEWS! STEPS TO WAIKIKI BEACH. Walking distance to parks, shopping mall, restaurants, shops, buses, rental cars, parks & Waikiki night life. Parking available. No smoking room.
The Ilikai Marina is loctated at the ...
Registration Number: TA-194-253-8240-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Waikiki
180 Ocean Degree Views
NEWLY REMODELED KITCHEN - BEAUTIFUL WOOD CABINETS, NEW LIGHTING, GRANITE
Ceramic Tile and Hardwood Floors
Small Oceanview Lanai with Sliding Door
Beautiful Rattan Furniture
King Size Bed with 800 Thread Count Sheets
...
Registration Number: TA-098-476-2368-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
180 Ocean Degree Views from this Beautiful End Unit
Small Oceanview Lanai with Sliding Door
Beautiful New Travertine Floors Throughout
Beautiful Koa Furniture, Window Coverings, & Linens
Foldout Queen Sofa with Koa Frame
Generous Storage Space
...
Registration Number: TA-170-946-1504-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Great value for a superb oceanfront view condo in Waikiki. Close to beaches, Hilton Lagoon, surfing, restaurants and a short walk to Ala Moana Shopping Center. • Waikiki Oceanfront Location• Golfing, Tennis, Swimming, Snorkeling & Surfing ...
Registration Number: TA-177-103-6672-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Location and Amenities, that's what this studio is about. Directly next to the Prince Waikiki Hotel and a 15-20minute walk to the Convention Center - you are located at the gateway to Waikiki.
You won't need anything but your swimsuit and ...
Registration Number: TA-156-762-3168-01, GE-15
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu
STUNNING OCEAN & SUNSET VIEWS! STEPS TO WAIKIKI BEACH. Walking distance to parks, shopping mall, restaurants, shops, buses, rental cars, parks & Waikiki night life. Parking available. No smoking room. Clean and fresh remodel.
The Ilikai Marina...
Registration Number: TA-025-362-0224-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
STUNNING OCEAN & SUNSET VIEWS! STEPS TO WAIKIKI BEACH. Walking distance to parks, shopping mall, restaurants, shops, buses, rental cars, parks & Waikiki night life. Parking available. Non smoking room.
The Ilikai Marina is loctated at the ...
Registration Number: TA-121-208-4224-01, TA-12
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
One of the best values for an oceanfront condo in Waikiki. Close to great Honolulu activities and a short walk across the Ala Wai Canal for quick access to Ala Moana Beach Park and Shopping Center.
Faces directly west for sunset views year ...
Registration Number: TA-113-797-5296-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Panoramic, 180 degree Ocean, Harbor and Sunset View
Spacious 1 Bedroom, 1 Bath Condo
Fully Equipped Gourmet Kitchen
Beautiful Rattan Upholstered Furniture
Very Comfortable Full King Size Bed
Foldout Queen Size Sleeper Sofa
Free Wireless ...
Registration Number: TA-127-123-0464-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
