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 (`headline` like '%Aina Nalu%') AND sleeps>=1 order by rating desc LIMIT 0, 15
***Please inquire before booking. Dates are not confirmed until Owner/ Manager sends confirmation. Calendars are not live or accurate due to multi agents and units.***
***The calendar is not perfect. We encourage guests to make an inquiry first...
- 4 bedroom
- 4 bathroom
- Sleeps 12
HI> Lahaina
Just upgraded with new mattresses, flooring, sofas and air cons.
This unit is Aina Nalu I-109. We own another unit too, vrbo 319429 (That one is Aina Nalu A-109.). Looking for more information about your units? Do a search for AinaNalui109
A...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
This second floor garden view studio at Aina Nalu Resort provides an excellent base for your vacation. The studio has a queen bed, dining area, efficiency kitchen, vaulted ceilings and a bathroom. The kitchen features: conduction cooktop (one ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
SUMMER SPECIAL!
no deposit required Free Wi-Fi
This is an exceptional 1br/1ba condominium which has been completely renovated with the finest furnishings it comfortably sleeps four people. The property offers 515 square feet of living space. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Welcome to paradise! This two-bedroom, two-bath condo is ideally situated on the top floor of Aina Nalu, a centrally-located boutique property in downtown Lahaina.
You'll find high ceilings, luxury finishes, and modern furnishings in D-207, and...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
This unit (D208) was handpicked by a veteran Maui lover and experienced travel agent for it’s private location, beautiful pools, and lush atmosphere. Beautifully decorated, the unit boasts two luxurious bedrooms with walk-in showers and slate ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Just upgraded with new mattresses, flooring, sofas and air cons.
This unit is Aina Nalu A-109. We own another unit too, Vrbo 400737. (That one is Aina Nalu I-109.) Looking for more information about our unit, do a search for AinaNaluA109.
A ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Aina Nalu Resort I-208
Enjoy the tranquility and charm of this air conditioned second floor 2 bedroom / 2 bath Aina Nalu condominium. You will be greeted to this 9 acre island oasis by the lushly landscaped and finely manicured grounds in the...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Come stay at the beautiful and newly renovated Aina Nalu. The rooms are gorgeous, decorated in Polynesian style. You will get the feel of Hawaii as you drive into the resort with an open air lobby, tiki torches, and beautiful Hawaiian landscape....
- 2 bedroom
- 1 bathroom
- Sleeps 6
HI> Lahaina
Get away from it all in our wonderful condo at Aina Nalu Resort- Lahaina's hidden gem! Take a short stroll to a lively historic downtown, or relax on some of Maui's most beautiful beaches just a short drive away. This unit (G209) has A split ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Ask about our Monthly Rate options.
Aina Nalu B-106 studio condo features a queen bed, a dining space for two, and a well-equipped kitchenette with gorgeous stone flooring and granite counter tops. Its full bath includes a large, spa-like stone...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Aina Nalu Resort G-207
Aina Nalu Resort, a small boutique resort, is in the heart of historic old Lahaina town on Maui’s west side. G-207 is an air conditioned one bedroom second floor condominium with two full bathrooms - the ideal layout!...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Ask about our Monthly Rate options.
Find the perfect balance of relaxation and adventure at this beautiful Aina Nalu studio condo in the heart of Maui’s Lahaina town. Air conditioning, ceiling fans, cable television and numerous other ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
"Aina Nalu Resort K -208 - Lahaina"
Enjoy the tranquility and charm of this air conditioned second floor 2 bedroom / 2 bath Aina Nalu condominium in the K building of Aina Nalu Resort. You will be greeted to this 9 acre island oasis by the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Aina Nalu Resort G - 206 . Enjoy the charm of this cozy air conditioned second floor 1 bedroom / 1 bath Aina Nalu condominium in the heart of Lahaina Town. Sleeps up to four people!
You will be greeted to this 9 acre island oasis by the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
