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
A Tropical Paradise...
The unique neighborhood of Puamana will take you back in time. The quiet streets are perfectly landscaped. Banyan trees sprawl around the clubhouse and plumeria trees shower the streets with their flowers. Depending on ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
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
Full Renovation completed in November 2021.
A Note from the Owner: No attention to detail was spared in the stunning remodel of Wailea Elua Village #1305. Boasts 3 bedrooms, all with en suite bathrooms. King bed in the second-floor ...
- 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
**THANKSGIVING SPECIAL ** Book 6 nights or more and enjoy a complimentary housekeeping service**
Ke Alaula Villa 217B is located in the Award Winning Resort Community of Hualalai Four Seasons.
3 Bedrooms / 3 Baths
Living Area: ...
- 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
*** Low season fall 2024 discount. 15% off nightly rate on all travel dates from September 10 - December 15, 2024.
Imagine stepping into your luxurious Hawaiian home away from home at Ekolu Villa. Nestled within the Aloha Villas ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
*** Low season fall 2024 discount. 15% off nightly rate on all travel dates from September 10 - December 15, 2024.
Imagine this: stepping off the plane and into paradise at Aloha Villas, a beachfront complex in South Maui. Eha Villa, your...
- 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
Our 2 bedroom condo, Poipu Crater #27 is located in one of the 15 townhouses on 7 acre as of luxurious tropical gardens..
With only one common wall there is no one located above or below and only having one shared wall your privacy is ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
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
**New Listing!** 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 ...
- 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
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 $895 a night from now until December 15, 2024.
*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 ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
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> Kamuela
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
Maximum occupancy strictly enforced in accordance with local ordinances.
This is a very nice 2 bedroom 2 bath townhouse close to Kahaluu Beach Park. This property includes a very private lanai, remodeled kitchen with granite ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
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
Major upgrades! and more coming - new floors, lighting and paint. Furniture and artwork next. Photos to be added after completion in October.
Dear Guest of Wailea Vacation Rentals,
This is the one, the best location at Elua. ...
- 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
A true home-away-from-home with room for the whole family. A townhouse style condominium with room for the whole family to enjoy.
Wailea Ekolu Village features deluxe one- and two-bedroom ocean view and garden view condos. The resort ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea
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
Alii Cove F-1 has reduced its nightly rates for the summer and fall! Come check out this roomy 3/3 townhome at the best prices since before COVID! perfect size for families and entertaining!
Alii Cove F-1 is a beautifully appointed ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
