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 (`headline` like '%ala moana%') AND sleeps>=1 order by rating desc LIMIT 0, 50
This luxury corner unit has an epic panorama ocean view with floor-to-ceiling windows on 2 sides of the unit for a spacious feel. ONE Ala Moana is the pinnacle of world-class living. This unit has 2 bedrooms, 2 baths, and 2 parking stalls ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Honolulu
One of the most luxury condominium in Hawaii. You can experience the best vacation ever in One Ala Moana!!
The minute you go inside, you will be astonished the amount of light coming through huge ceiling to floor windows overviewing the city ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Fantastic Location! 2 bed, 2 bath, 1 parking stall in a secured bldg on the 44th floor with fabulous amenities. Across the street from Ala Moana Shopping Ctr & Ala Moana Beach Park, offering breathtaking views of Waikiki, Ala Moana Beach Park, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Honolulu
Location: Come experience the very best of island living at One Ala Moana, steps away from Ala Moana Shopping Center. Minutes to Waikiki, downtown.
Interior: Features Philpotts designed deep-smoked walnut wide plank flooring. Magnificent ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Welcome to Park Lane, an exquisite residential resort community conveniently located in the heart of Honolulu (direct elevator access to the world-class Ala Moana Shopping Center and across the street from Ala Moana Beach Park). The elegantly ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Honolulu
2 Guests
comes with 1 free parking inside the Airbnb
$30 Additional cost per person after 2 guest.
500 SQFT, 120 SQFT large balcony, has ocean, lagoon and beach view, located on 6th floor.
CDC standard Sanitized, easy self-check ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Honolulu
This luxury unit has an epic panorama ocean view with floor-to-ceiling windows. ONE Ala Moana is the pinnacle of world-class living. This unit has 2 bedrooms plus a den, 2.5 baths, and 1 parking. One Ala Moana has a long list of luxury amenities...
- 2 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Honolulu
Welcome to the exquisite Park Lane at Ala Moana residential resort community. Park Lane’s luxury residences offer resort-like amenities and are ideally located in the heart of Honolulu, just across the street from Ala Moana Beach Park. Built ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Honolulu
Ala Moana hotel is the place to stay. Your 35th floor 1 bedroom PENTHOUSE suite has dramatic ocean, Diamond head crater mountain and city views. W/ Kitchenette and laundry.
Walk across the attached bridge to the world famous Ala Moana ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
This stunning 2BR/2BA condo is located in the brand-new Sky Ala Moana building, offering breathtaking ocean views and luxurious amenities. The unit features a spacious living room, a fully equipped kitchen with modern appliances, and two elegant...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Honolulu
A stunning 1BR/1BA condo is now open in the brand-new Sky Ala Moana building, where contemporary design meets classic luxury. The unit features a polished living space adorned with tasteful accents, creating an inviting atmosphere for relaxation...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
【Basic Info】
This is a 1BR room in Waikiki!!
You can stay with you friends, partner, family.
You can spend your time with a reasonable price.
This condominium is located west area in Waikiki.
You can walk to Hilton ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Honolulu
This is a newly built and hottest condominium in Honolulu, HI, with Hawaiianized furniture!!!
You may enjoy the city, the ocean, and the mountain from this unit, Sky Ala Moana 4108.
This unit has 1 King-sized bed and 2 Twin-sized ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Honolulu
-Luxurious Penthouse Retreat in the Heart of Honolulu
Indulge in the ultimate urban oasis with our luxurious 43rd-floor penthouse condo, perfectly situated in the vibrant Ala Moana Center area between Waikiki and Kaka'ako. This prime ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Cannot beat this location. Modern hotel room with amazing views. Adjacent to Ala Moana Mall and across from the Ala Moana Beach Park. Two full beds that can accommodate 4 people. Functional kitchenette with mini fridge, microwave, coffee maker ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Discover the core of vibrant Waikiki and enjoy a genuine Hawaiian vacation in our cozy one-bedroom flat. Nestled just a short 11-minute walk from the renowned Ala Moana Center and 13 minutes from the vibrant Waikiki Beach Walk, you'll be ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Maximum occupancy strictly enforced in accordance with local ordinances.
Are you ready for white-sand beaches and turquoise waters? Join us on island time at the Ala Moana Hotel, Honolulu’s landmark hotel within walking distance to the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
!!IMPORTANT!! The exterior works project of Ala Moana Hotel Condo began. The working time is from 8:30 AM to 5:00 PM, Monday through Frida, except holidays.
The exterior workings are: 1)Concrete Repair, 2)Re-painting the Building, ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
*********IMPORTANT NOTICE**********
SPALL REPAIRS:
Spall repair work on the building will start in January 2025. Access to lanais will not be available while work is being done on your unit.
The following is a tentative time frame: ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
19th Floor Ocean View! Hotel Type Ala Moana! A917. Beach are Very Close! The Great Ocean View with Great Price.
Compare the price with hotels. You will save big money. Spend more for the activities and shopping.
The room faces the east and...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Here in our 34th floor 2 bedroom/3 bath Regal Suite at the Ala Moana Hotel condo, you will experience island-style comfort in one of Hawaii's most convenient locations. This unit is located very close to the beaches and the state's largest ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Honolulu
Find yourself right in vibrant Waikiki for your dream Hawaiian vacation in our beautiful two-bedroom condo. Nestled in the vibrant neighborhood, you'll be just a short walk away from the iconic Ala Moana Center, the lively Waikiki Beach Walk, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Honolulu
This condo is located on the 18th floor of the Ilikai Hotel.
Most sought after and in a SPECTACULAR location with views of the Pacific Ocean overlooking the Ala Wai Yacht Harbor! Imagine waking up to the beautiful and calming view of the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Park Lane Ala Moana is a luxurious condominium with various entertainments for you. Park Lane presents the opportunity to experience the beauty of nature and cosmopolitan city life at its finest and most vibrant. Representing a first-of-its-kind...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Honolulu
This condo is near beach, across from ocean in Waikiki. The home itself is a cozy two bedroom ( Queen size beds) home and one bathroom with two balconies. This condo is perfectly situated walking distance to everything in Waikiki. We are one ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Look no further, welcome to your dream vacation spot! This great condo is located within the OCEANFRONT Ilikai Hotel on the 12th floor and offers exquisite views of the ocean overlooking the Ala Wai Yacht harbor and Pacific Ocean. You'll be ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Poipu Ala Moana Hale is a 2-minute walk to Grand Hyatt's lovely three-bedroom, two-bath home surrounded by a beautifully landscaped garden oasis. Set in a quiet resort neighborhood, Poipu Ala Moana Hale offers a peaceful and serene atmosphere ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Koloa
Summary:
Welcome to Honolulu's Landmark Hotel, the Ala Moana. Enjoy a desirable location next to Ala Moana Center, the world's largest open-air shopping mall. Stay just steps from Hawaii's most prestigious shopping venue showcasing fashion ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Simple living in this cozy studio with Mountain View Patio facing Manoa Valley and breezes! Great location, near beaches including the beginning of Waikiki Beach, Ala Moana Beach Park with its great beachfront, jogging, surfing , paddle ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Hotel Type Best Price Ocean View Ala Moana! 13th floor ADA studio with a queen bed, AC, small kitchenette is at the doorstep of Ala Moana Shopping Center, close by the beach. Thanks to panoramic windows and lanai, you can enjoy ocean ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Diamond Head and Ocean View! Ala Moana! (AH117). A small kitchenette with all the essentials, big bathroom with bathtub to relax after a tiring yet enjoyable day at the beach is all you can dream of. But there is much more, flat screen TV to ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Maximum occupancy strictly enforced in accordance with local ordinances.
Ilima Suite is a cozy condominium at The Ilikai featuring an ocean view. Located in the Ala Moana and Waikiki area, vacationers will find themselves for an ideal ...
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Honolulu
This cozy ADA studio will become your favorite place away from home with all the things to make your vacation unforgettable.
A queen size bed, close proximity to the beach, shopping centers at your doorstep, floor to ceiling windows and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Enjoy all the conveniences and pleasures of a world-class hotel at the Ala Moana Hotel Condos with amenities that include a Olympic size swimmingpool, sauna, state-of-the-art exercise room, three restaurants, the famous Rumours Night Club and ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Enjoy the many luxurious perks of this 1BR/1BA Penthouse unit at One Ala Moana. This fully furnished and well appointed unit features glorious mountain views from the top floor, high end finishes and top of the line appliances, automatic ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
29th Floor Hotel Type Ocean View Ala Moana! (AH02). This cozy studio is designed with a quirky simplicity, to provide a comfortable feel to your Hawaii vacation. With floor to ceiling windows, close proximity to the Hawaii Convention center and ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Ocean breeze studio on Ala Moana blvd with lovely balcony, on 9th floor with nice view of mountains and Ala Wai canal with kayaking activities daily. The building has beautiful ocean view and harbor view from the elevator area. Only a few minute...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
This property is a 30 day minimum rental at One Ala Moana. One of the most LUXURIOUS condo in Ala Moana! Located on Kapiolani Blvd and very convenient to the famous Ala Moana Shopping Center. Featuring a fully equipped High End Kitchen ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
This stunning 1BR/1B condo is located in the luxury brand-new building: Sky Ala Moana, showcasing mesmerizing ocean views and top-notch amenities. The unit boasts a generously sized living room filled with natural light with a luxury full-size ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
High floor unit with balcony . Partial ocean views and city views. Low resort fee
Amazing location Located a 10-minute walk from Ala Moana Beach, Ala Moana Resort 25th floor with balcony offers 4-star accommodations in Honolulu and features ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Take in gorgeous mountain to ocean views from the private lanai of this resort style one-bedroom home. Located in the newly remodeled Ala Moana Hotel, this beautiful home includes complimentary wifi, cable, central ac, indoor dining area, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Summary:
Beautiful and peaceful Studio at the Ala Moana Condo Hotel is a very centrally-located place. Walking distance to beach access.
***PLEASE READ OTHER THINGS TO NOTE BEFORE BOOKING***
The Space:
From your balcony ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
1 Bedroom Deluxe Yacht Harbor View on the 13th Floor!
Look no further, welcome to your dream vacation spot! This great condo is located within the OCEANFRONT Ilikai Hotel and offers exquisite views of the ocean overlooking the Ala Wai ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Summary:
Great room in a modern hotel at an incredible location and breathtaking ocean views. Spacious bedroom with a large balcony for you to enjoy the ocean view and fireworks on Fridays. Clean studio includes a mini fridge, microwave, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
27th floor AC studio with 2 full beds, small kitchenette and at the doorstep of Ala Moana Shopping Center, close by the beach. Thanks to panoramic windows and lanai, you can enjoy magnificent city and ocean views.
Feel just like at home, ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Hotel Type 21th Floor Ocean View! Ala Moana(AH10) Best View and Best Price available in Ala Moana Hotel Condominium!
This room is less than one half of those of hotel rooms!! You never have this much of discount ever!
Imagine you stay ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Summary:
Enjoy a great studio at the Ala Moana Hotel. Best location adjacent to Ala Moana Shopping Center and across from Ala Moana Beach Park. Enjoy the amenities of this resort: pool, lounge areas, gym, spa, salon, restaurant, bar, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Paradise awaits at this 1-bedroom, 1-bathroom vacation rental in Honolulu! Located at Executive Centre, this cozy apartment has resort amenities like a swimming pool, hot tub, and coin laundry machines. This prime location is within walking ...
- 2 bedroom
- 1 bathroom
- Sleeps 2
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 ...
- 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu