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 '%Pacific Shores%') AND sleeps>=1 order by rating desc LIMIT 0, 20
This VRBO listing is a fully renovated and very well furnished and equipped condo located in the Pacific Shores complex in the heart of South Kihei, Maui. It is just steps away from wonderful beaches, restaurants, and shopping.
The unit ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Start your mornings on the third-floor lanai for sunrise and end the day at Charley Young beach for spectacular sunsets. Watch turtles cruising the waves and spot whales offshore during the winter season.
Two bedrooms and two ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
The scenery cannot be beaten at Pacific Shores A-209! This beautiful second-floor condo features two spacious bedrooms, two bathrooms and sleeps six. Enjoy the beautiful view of the lush garden from the amazing balcony, WiFi, washer and dryer, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Central Air Condition, 2 bedroom/2 bath, fully equipped kitchen, with a tropical theme, Queen beds, FREE WiFi, 47 inch HDTV, DVR & DVD. Across from BEAUTIFUL sandy Charley Young Beach. Short walk to restaurants, shops, watch surfers at nearby...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Conveniently located in S Kihei across from popular Charles Young and Kamaole 1 beach and park, this 2-bedroom unit is colorfully decorated and well appointed for vacation enjoyment. Includes central A/C in all rooms of the condo, remodeled ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to our Bright & Sunny 2 bedroom, 2 bathroom Condo located in the heart of Kihei, this is what you call a Beach town!
Perfectly situated across the street from Kamaole 1 Beach, a fantastic beach for swimming, snorkeling and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Pacific Shores #A-101 is a 1 bedroom, 1 bath condo. This ground floor unit is conveniently located towards the front of the complex for quick access to nearby amenities. Enjoy the contemporary island feel with tile flooring throughout, granite ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
This unit is a 2 bedroom, 2 bath unit on the 3rd floor. It is fully air conditioned (split system), has a well stocked kitchen, washer and dryer, a flat-screen TV, a Blu-ray player, telephone service with long distance calling to the continental...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Your Maui Getaway!
Condo Overview:
• Location: South of central Kihei, just north of Wailea
• Size: 2 Bedrooms + Convertible Sofa in Living Room, 2 Baths
• Sleeps: 4-5 Guests
• Accessibility: Only 35 minutes ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kihei
Stunning remodel and an ideal Kihei location create beachy perfection for your island getaway.
Relax on your own private lanai. Feel the wonderful trade winds and take in the island scents from the beautiful Plumeria trees and Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Pacific Shores #B-109 is a 2 bedroom, 1 bath unit on the ground floor. It features a fully-equipped kitchen, washer and dryer in the condo, TV, and free WIFI. There are 2 queen beds, a NEW queen sofa bed (2024), and a walk-in shower (no tub). ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Kihei
Pacific Shores B205! This 2 bedroom/ 2 bath condo offers the perfect location overlooking the pool with peaks of the ocean. There is beach access across the street and several restaurant options within minutes.
You will be welcomed by the...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
E Komo Mai to our unit at the Pacific Shores located in South Kihei. This unit is situated directly across from Charley Young Beach and in walking distance to shopping, restaurants, surfboard rentals and a short drive away to Wailea and Kamaole ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
The best location on South Maui! Pacific Shores is all about convenience and location. Who needs a car when you are across the street from favorite Charley Young Beach, 1 block from popular surf spot ''The Cove'' and half a mile from many ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
This cozy little piece of paradise is the perfect place to stay while you enjoy the beauty of Maui. Pacific Shores A111 is a 2 bedroom, 2 bath ground floor condo ideal for family getaways. The living room is air conditioned, and each bedroom is...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
