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 '%Townhouse%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Military & DOD, We support our service members and have special rates for active military & DOD utilizing TLA. If you are coming to Oahu for work in the Navy, Army, Marines, Air Force, Space Force, Coast Guard, National Guard or Department of ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapolei
Perfect location for vacationers. The condo is located on the first row of condos right on the 10th hole of the Blue Golf Course, next door to the Club House and the new Wailea Village Shopping Center. It's in the heart of the resort community...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
Welcome to Wailea Elua Village #1305
Special Offer: Stay Longer!
Book your stay now through March 15, 2025, and enjoy the 6th night free for every 5 nights booked. This offer is valid for new bookings only, so don’t miss your ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Wailea-Makena
Welcome to Happy Everything!
10 Wailea Ekolu Complex!
A premier, fully re-modeled, well appointed and comfortable 2-story townhouse situated on hole 10 of the famous Wailea Blue Golf Course at beautiful Wailea, Maui. Comfortably ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
Ke Alaula Villa 217B at Hualalai Resort
Experience unparalleled luxury and tranquility at Ke Alaula Villa 217B, located within the prestigious Hualalai Resort. This exceptional property is situated within one of Hawaii’s most renowned ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Beautiful BEACH FRONT townhouse on Sugar Beach. 'Maalaea Surf is one of Maui's best kept secrets.' Spaciously spread over 5 acres of tropical gardens, Maalaea Surf sits directly on a beautiful white sandy beach which stretches for 5 miles. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
The Villages at Mauna Lani is a private gated community that offers the ultimate in comfort and convenience. This is our family’s dream vacation home and we think you will agree. This is a fantastic home for a family getaway. This is a two ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Kamuela
OUR MAUI BEACH HOUSE... (Please read our Guest Comments to see how great this place is!) This is the perfect place for a family vacation and retreat!! And it is right on the beach! Many of our guests enjoy staying right on our property or on ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to Paradise! We hope to host your stay!
B2 is located within the Mauna Lani Resort at The Islands at a private, gated community situated along the famed fairways of Mauna Lani golf course. Handsome townhomes set within gardens of...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
You can hear the waves crash against the shore from your lanai or perhaps you would prefer to enjoy it from your own private balcony. This unit is adorned with trinkets and decor from all over Japan providing the feeling of appreciation for its ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
Imagine stepping into your luxurious Hawaiian home away from home at Ekolu Villa. Nestled within the Aloha Villas beachfront complex in South Maui, this spacious two-story townhouse offers the perfect blend of relaxation and resort-style ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
Imagine this: stepping off the plane and into paradise at Aloha Villas, a beachfront complex in South Maui. Eha Villa, your home away from home, offers a luxurious two-story townhouse experience, perfect for families or groups.
Unwind in ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
End unit townhouse with 2 bedrooms/ 2 bathrooms located in the gated community of Keauhou Kona Surf and Racquet club. Downstairs you will find full size kitchen with granite countertops, living room with large 55 inch Samsung TV with 200 MBPS ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
WELCOME TO OUR HAWAIIAN RETREAT in Wailea!
We purchased our second property in Wailea - November 2019. Enjoy your getaway at our new home-away from home! We spent the 2019 holiday season buying new furniture for EVERY room, decorating, ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
At a generous 1,825 square feet of interior space, your 3 bedroom/3 bath home-away-from-home offers the popular split-level floor plan where each bedroom is on its own separate level. Upon entering Hale O’ Na Wailele you’ll find the first ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Beautiful 2 bedroom private villa with tranquil golf course views is the perfect place for a relaxing vacation! Due to covid-19, the property is disinfected and cleaned in preparation for every stay.
The Waikoloa Colony Villas is a gated...
- 2 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Waikoloa Village
Welcome to West Maui's best-kept secret - The Residences at Napili Bay! Get ready to experience an unforgettable vacation in this hidden gem, just steps away from one of Maui's favorite beaches - Napili Bay.
Behind a private gate, you'll ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Napili
Located just 10 min from the West Side Resorts & Ko'olina Lagoons, you will have easy beach access while still enjoying the privacy offered by this quiet neighborhood home.
Wake up and sip coffee on our garden-facing lanai & spend your ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kapolei
Welcome to Paradise
Hidden away in the outer rim of The Fairways community in the coveted Mauna Lani resort area sits this spacious and modern 2 bedroom, 2.5 bathroom, 2-story townhome. This area along the south Kohala Coast of the Big ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waimea
In addition this resort is a golfer's paradise being that the unit is situated near the Waikoloa Beach Golf Course. Enjoy all the conveniences of our townhome, right at your fingertips. On the bright side the vaulted ceiling in this condo allows...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa
”Aloha and Welcome Home" message me on availability as it can only be rented once in a 30 day period. The county of Honolulu mandates a 30 day minimum. Ordinance 19-18 does not require a renter to physically occupy a rental property for any ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kailua
The Islands K3 is a lovely spacious townhouse in Mauna Lani Resort.
Enjoy a newly available town home in Mauna Lani Resort with lush gardens, private courtyard, and sun-filled living room. It features high-end furniture, smart TVs, and ...
- 2 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Kamuela
New rental listing starting September 2023
Welcome to our relaxing, freshly updated Villa at the Waikoloa Colony Villas. Unit 106.
New furniture, and beds throughout the home!
Waikoloa Colony Villas is a private gated community ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
Welcome to Villas on the Prince #28 a modern Princeville 3 bedroom, 3 bathroom condo situated in a private gated community that has AIR CONDITIONING in all bedrooms and main living areas. Recently updated. Sleeps up to 6 guests comfortably and ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Please be aware due to ongoing pressure washing, painting, and lanai deck coating inspections through May 2025, guests may experience some minimal noise and/or limited access to lanais from these activities.
Please reach out to our guest ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapolei
Book with us and come to Maui to explore everything we have to offer!
Brand NEW remodel and new vacation rental! Come stay with us!
Escape to paradise in this beautifully remodeled 1-bedroom unit featuring a ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Introducing Nihilani at Princeville 34C, now available through Makana Kauai Properties.
Nihilani offers luxurious accommodations on the north shore of Kauai. These Princeville condos showcase a plantation-style architecture with ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Create unforgettable memories and experience resort-style community living at this newly-remodeled home in KoOlina. Located just 1 mile from the jewel-like lagoons and steps from world-class resort accommodations. Make yourself at home in this ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kapolei
* New Rental Property*
Welcome to Hawaii Magic! This luxurious two-bedroom townhouse in Kulalani offers a perfect blend of comfort and style. With spacious living areas, modern finishes, it’s an ideal retreat for relaxation. Enjoy the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
Affordable 2-Bedroom, 2-Bath + Loft at Kuilima Estates (next to The Ritz-Carlton O'ahu, Turtle Bay)
Enjoy more space without the luxury price tag! This comfortable and spacious 2-bedroom, 2-bath loft is the largest floor plan in Kuilima ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kahuku
Enjoy the peaceful resort life in this beautiful townhouse with upgraded furnishings in the luxurious Kulalani at Mauna Lani community. With access to both the Beach Club and the acclaimed Kamilo amenity center, this stylish property is perfect ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
Aloha, we would love to have you as our guests. The oceanfront townhomes are the closest units to the ocean in all of Kona! Enjoy fresh ocean breezes and be lulled to sleep by the sound of the waves. Sip coffee on your lanai in the morning ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Brand new remodel!
Experience the beauty of Kauai's North Shore through this luxuriously appointed townhouse situated right on Makai Golf Course with mesmerizing ocean and mountain views. This brand new remodeled 2 bedrooms, 2 bathrooms ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Aloha my friend! We invite you to come and experience your tropical paradise...your new home away from home at Turtle Bay Kuilima Estates!
Located on the North Shore of Oahu at Turtle Bay, this townhome sits on the Championship Fazio ...
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kahuku
Vacation in this spacious, absolutely oceanfront 2 bedroom, two story townhouse! It’s located on Hawaii's BigIsland, 5 miles from the town of Kailua-Kona at the Keauhou Kona Surf & Racquet Club. This gated 17 acre oceanfront complex has ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
1300 ft2, very spacious townhouse, two bedrooms with a king size bed in the open loft-style master bedroom and queen size in the downstairs bedroom.
Immerse yourself in the magic of Kauai through this conveniently located townhouse in the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
This 3 bedroom 3 bath multi level condominium apartment is like a private home! From the entry you can step up to the open living area with a ocean view lanai. The spacious living area can easily accommodate a family get together with the ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Wailea
Spacious 1600sq ft,2 king beds,2+ baths ,beautifully furnished. ALSO THE PROPERTY WILL BE FULLY AIR CONDITIONED STARTING NOVEMBER 23, 2024.
Located among the lush acreage of the Poipu Kai Resort and within a 5 minute walk of Brenneke's ...
- 2 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Poipu
*Please note that the Kapalua Resort and this property were not affected by the Lahaina fires, nor were our surrounding areas or Napili, Kahana and Kā‘anapali. West Maui communities of Kā‘anapali, Nāpili, Honokōwai, and Kapalua are ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Maalaea Surf, Unit A5 is a 2 bedroom beachfront townhouse on the second floor which offers our guest total privacy. It is located directly on the beach. This condo features everything including central AC, Wifi, TV, fully furnished kitchen, 2 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Enjoy reduced rates of $825 until January 24, 2025!
*Please note that the Kapalua Resort and this property were not affected by the Lahaina fires, nor were our surrounding areas or Napili, Kahana and Kā‘anapali. West Maui ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Wailea Ekolu Village 410
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Welcome home to this light and airy end-unit two-story townhouse ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Wailea
Premium Ocean Views, Cooling Tradewinds & the Morning Sunrise welcome you to this relaxing Upper Level 2 Story Condo! Private Entry Lanai with Pool View, Ocean Views from the Full Kitchen, Dining for 6, Living room with Desk & Rear Lanai. First ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lihue
The Islands is a luxury townhouse community located in the Mauna Lani Resort. With mature tropical landscaping & the low density in this community, The Islands is a quiet tropical oasis. D4 is an end townhouse with only one shared wall with an ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waimea
Makani Sands #305 is a freshly renovated & beautifully decorated 3 Bedroom, 2 1/2 Bath townhouse on the 3rd & 4th floor. With two lanais boasting incredible views of the ocean & neighboring islands of Molokai and Lanai you will have a front row ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Aloha Hale is a one of a kind, 2 bedroom, 2 1/2 bath, fully appointed town house style condominium that is located near the calm, protected harbor and beach of Keauhou Bay. The downtown Kailua-Kona area, on Alii Drive, is a short 10 minute drive...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Explore our airy and roomy Royal Palm unit, which is situated in the midst of verdant tropical landscaping and measures 1550 square feet in size. The pure white sands of Poipu Beach are within a five-minute stroll. Luxurious deep tub in the ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Koloa
Experience your dream vacation for a romantic getaway or for the whole family.
5 Minutes walk to the beach through lush landscaping. 4 pools, beautiful beach, great for swimming, snorkeling, boogie boarding and relaxing. Walk to Shops in...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
New, New, New. Major upgrades! New floors, lighting, furniture, beds, appliances, paint, lanai furniture and artwork. Check out the new photos.
This is the one, the best location at Elua. Beachfront 3 BD+3 BA private townhouse with a ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea
Ekahi Village 27C is a beautifully-decorated, updated and meticulously-maintained one bedroom, one-and-a-half bathroom condo in South Maui's prestigious Wailea resorts. Fully air conditioned for your comfort, the condo features a very spacious ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
