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 '%ilikai marina%') AND sleeps>=1 order by rating desc LIMIT 0, 50
This condo at the Ilikai Marina is located on the 3rd floor. For those of you that don't like high floors and like to feel close to the ground overlooking the beautiful Pacific Ocean and marina. You'll be able to wake up to the beautiful and ...
Registration Number: TA-159-542-0672-01, GE-159-542-0672-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Aloha from Midway Vacations! Our team of local hospitality experts is dedicated to turning your Hawaiian getaway into a reality. When you stay at one of our properties, you can count on a professionally cleaned and meticulously maintained ...
Registration Number: STR-1955 Exp. date: 08/28/2025, 260100020134, GE-156-537-0368-01, TA-156-537-0368-01
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Welcome to our oceanfront home offering stunning ocean views and Hawaiian sunsets, all within walking distance to the beach. Whether you're seeking adventure, family fun, or relaxation, this is the perfect destination while visiting Oahu. On ...
Registration Number: GE-040-719-3088-01, TA-040-719-3088-01, 260100020114
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
A modern and spacious unit located in Ilikai Marina 6th floor with a panoramic and breathtaking view of the ocean. Unit has a California king-size bed, full size sofa-bed and fully-equipped kitchen.
Beach, shopping mall, dining, parks, ...
Registration Number: GE-125-401-6512-03, 1260100020042, TA-125-401-6512-03
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Welcome to my place here in Waikiki with a queen bed in the bedroom and a queen bed sofa couch. There is a solid sliding door between the bedroom and the living room area. (wood door)
The entrance to Ilikai Marina Condo is on Hobron Lane ...
Registration Number: GE-093-328-7936-01, TA-093-328-7936-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Hawaii tax ID#: TA-167-299-1232-01
TMK: 260100020032
STR Permit #: 2211-CCH-0297. Expires 11/16/24
EVERY LEGAL SHORT TERM RENTAL IN HAWAII MUST HAVE AN OFFICIAL STR PERMIT NUMBER. OURS IS LISTED ABOVE. YOU CAN BOOK AND STAY ...
Registration Number: GE-167-299-1232-01, TA-167-299-1232-01, 260100020032
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
ON THE RENTAL MARKET AFTER A COMPLETE DESIGNER RENOVATION!
BY FAR THE BEST LOOKING UNIT IN THE ENTIRE BUILDING!
We're accepting reservations on an on-going basis.
Superb Location next to the water!
Completely remodeled with no...
Registration Number: GE-049-737-5232-01, TA-049-737-5232-01, 260100020120
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Ilikai Marina Condo 790 is ideal for a Hawaiian getaway. Guests love its cleanliness, stunning marina and ocean views, and location near Ala Moana Mall, Waikiki Beach, and restaurants. The condo is well-equipped with beach gear, kitchen ...
Registration Number: GE-177-103-6672-01, 260100020051, TA-177-103-6672-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
Registration Number: 260100020136, GE-170-946-1504-01, TA-170-946-1504-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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: GE-177-103-6672-01, 260100020132, TA-177-103-6672-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
This condo recently had their kitchen and bathroom renovated with all brand new appliances! Looks and feels AMAZING! This condo is located in the Ilikai Marina on the 6th floor with a mesmerizing view of the ocean overlooking the yacht harbor....
Registration Number: GE-193-846-8864-01, TA-193-846-8864-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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 ...
Registration Number: GE-046-192-0768-01, TA-046-192-0768-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Ilikai Marina Condo 786 is a fantastic accommodation in a superb location, offering a stunning view of the marina. Guests praise the cleanliness, well-equipped kitchen, and convenient access to beaches, restaurants, and shopping. The condo comes...
Registration Number: TA-113-797-5296-01, GE-113-797-5296-01, 260100020049
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Ilikai Marina Condo 992 offers stunning marina and ocean views, a well-stocked kitchen, and a convenient location near Waikiki’s quieter end. Guests appreciated the cleanliness, comfortable accommodations, and proximity to Hilton Hawaiian ...
Registration Number: TA-111-177-5232-01, GE-111-177-5232-01, 260100020078
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Located within the Ilikai Marina, this condo is located on the 3nd floor. As you stand on the lanai of this condo, you look straight out to see the Ala Wai Yacht Harbor below and turquoise ocean waters beyond. If you love to surf, this is the ...
Registration Number: TA-048-703-0784-01, GE-048-703-0784-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
This condo underwent a kitchen and bathroom remodel in February 2024, enhancing its appeal as the perfect vacation or extended stay rental! With new cabinets, range and microwave, all complemented by stunning quartz countertops, the kitchen ...
Registration Number: TA-022-570-5984-01, GE-022-570-5984-01
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Firework! Great Ocean View! Ilikai Marina (IM92)
In the sun
Feel the sun
Walk barefoot on the sand
Feel the Ocean
Relax
Everyday sunny day
Soak up Nature While In Hawaii!!
This modern studio is bright thanks to the top to...
Registration Number: 260100020060, GE-073-540-2496-01, TA-073-540-2496-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> 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...
Registration Number: TA-127-123-0464-01, GE-127-123-0464-01, 260100020115
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Welcome to your serene coastal retreat! This condo is located on the 4th floor of the Ilikai Marina. This low-floor ocean view condo offers breathtaking views of the sparkling sea and golden sunsets, all from the comfort of your own private ...
Registration Number: TA-183-869-6448-01, 1260100020022, GE-183-869-6448-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Book with confidence! This property is professionally managed by Ali'i Beach Rentals.
NOTE: 7/31/24: The ground-floor restaurant is undergoing renovation; intermittent jackhammering noise will occur throughout the day. Work hours are ...
Registration Number: TA-067-365-4784-01, GE-067-365-4784-01, STR #1821, 260100020036
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Just installed new flooring and painted the whole unit!
Great property with amazing 180 degrees ocean view! Enjoy couple minute walk to the beach. Restaurants, bars, all the attractions are just within few minutes walk! Next to the bus ...
Registration Number: TA-102-471-0656-01, GE-102-471-0656-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Located within the Ilikai Marina, this condo is located on the 10th floor. You'll love the convenient location in Waikiki, close to the beach, Ala Moana Shopping Center & the Waikiki strip!
KITCHEN
- Refrigerator
- Electric ...
Registration Number: GE-206-695-6288-01, TA-206-695-6288-01
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Located within the Ilikai Marina, this condo is located on the 9th floor. The warmly styled and comfortable condominiums of Ilikai Marina are the perfect place for an unforgettable family vacation, where you can spend more time together not in ...
Registration Number: GE-060-722-3520-01, TA-060-722-3520-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Welcome to the family-friendly Ilikai Marina Hotel. This 17th-floor unit faces west, offering beautiful views of the ocean and harbors from both your bedroom and living room.
Situated just a few steps away from the inviting sands and ...
Registration Number: GE-156-537-0368-01, TA-156-537-0368-01, 260100020227
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Book with confidence! This property is professionally managed by Ali'i Beach Rentals.
ENHANCED PROTOCOLS : We have revised our protocols to include contactless check-in & check-out, professional EPA approved non-toxic undetectable ...
Registration Number: TA-009-074-4320-01, GE-009-074-4320-01, STR #1820, 260100020257
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
This spacious studio underwent a partial renovation in October 2022, featuring a new kitchen, vinyl flooring and a fresh coat of paint. Situated on the 10th floor of Ilikai Marina, this condo offers a prime location in Waikiki, just steps from ...
Registration Number: GE-035-535-2576-01, TA-035-535-2576-01
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Located within the Ilikai Marina, this condo is located on the 16th floor. This condo is recently had a full bathroom & kitchen renovation, along with new flooring! You'll love the convenient location in Waikiki, close to the beach, Ala Moana ...
Registration Number: TA-016-821-4528-01, GE-016-821-4528-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Newly full renovated condo at the Ilikai Marina, studio with queen bed, sofa bed, full kitchen & bath, City and mountain views! All brand new in this condo. Easy access to main Waikiki shopping area and Ala Moana shopping center. Walk to ...
Registration Number: 260100020215, GE-084-065-8944-01, TA-084-065-8944-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
The ocean front Ilikai Marina looks out over the Ala Wai Yacht Harbor and the beautiful turquoise sea. Conveniently located at the beginning of Waikiki, the Ilikai Marina is within easy walking distance of Waikiki Beach and Ala Moana Shopping ...
Registration Number: GE-007-788-9536-01,TA-007-788-9635-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Ilikai Marina is the best value in Waikiki for your vacation needs! It's situated directly on the water with a 180-degree ocean view. As you stand on the lanai of this condo, you look straight out to see the Ala Wai Yacht Harbor below and ...
Registration Number: TA-016-821-4528-01, GE-016-821-4528-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
This stylish and contemporary condo on the 6th floor is located with a beautiful view of the ocean overlooking the yacht harbor at the Ilikai Marina. You'll LOVE waking up to the beautiful and calming view of the ocean and relax as the sun sets ...
Registration Number: GE-049-506-8160-01, TA-049-506-8160-01, 1260100020044
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Summary:
Take a stroll along Waikiki beach and enjoy the warmth on your skin and the beach sand between your toes. This cute and upgraded 2nd-floor harbor/ocean view 1bedroom is located in the Ilikai Marina, an ocean front building located in...
Registration Number: GE-115-324-3136-01, TA-115-324-3136-01, 260100020007
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Beach, shopping mall, dining, parks, buses, rental cars & Waikiki night life all within walking distance. This non smoking room is centrally located with a breathtaking view of the ocean. Parking is available too. Also, enjoy Hawaiian Hilton ...
Registration Number: 260100020150, TA-180-212-6848-01, GE-180-212-6848-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Located within the Ilikai Marina, this condo is located on the 14th floor. You'll love the convenient location in Waikiki, close to the beach, Ala Moana Shopping Center & the Waikiki strip!
KITCHEN
- Refrigerator
- Electric ...
Registration Number: GE-163-841-2288-01, 1260100020184, TA-163-841-2288-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Located within the Ilikai Marina, this unit on the 7th floor has fabulous views! It's situated directly on the water with a 180-degree oceanview. As you stand on the lanai of this condo, you look straight out to see the Ala Wai Yacht Harbor ...
Registration Number: 260100020053, GE-069-046-4256-01, TA-069-046-4256-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Step into this thoughtfully remodeled condo and immerse yourself in the soothing sounds of the ocean right outside your door! The condo features a full kitchen with an industrial vibe, including retro-style appliances and custom concrete ...
Registration Number: TA-187-661-5680-01, 1260100020151, GE-187-661-5680-02
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
A truly one-of-a-kind condo in the Ilikai Marina! This condo has been completely renovated with an architecturally designed interior to maximize space and comfort, while providing luxury finishes. The open kitchen features rich, dark wood ...
Registration Number: TA-074-980-6080-01, 260100020152, GE-074-980-6080-01
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
*Exciting Updates in Progress!
We’re currently renovating to make your stay even better. In the meantime, please take a look at our beautifully updated Ilikai Marina listing to see the stunning upgrades you can expect ...
Registration Number: 260100020150, TA-167-251-7120-01, GE-167-251-7120-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
