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 '%Pacific Shores%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This VRBO listing is a fully renovated/upgraded and very well furnished/equipped condo located in the Pacific Shores complex in the heart of South Kihei, Maui, just steps away from wonderful beaches, restaurants, and shopping. The unit includes ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
The scenery cannot be beaten at Pacific Shores A-209! This beautifully renovated 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, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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
HI> Kihei
Our gorgeous Pacific Shores TOP FLOOR Corner Condo in desirable "A" building A-404, closest to the ocean, invites you to Paradise with tropical decor throughout. Let our condo be your Home away from Home with all the comforts, including your ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Kihei
We want you and your family to enjoy our two master bedroom, two full bathroom, completely remodeled, fully air-conditioned, top floor condo with beautiful diagonally placed tile throughout...No condo above us or to one side which means quiet ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Pacific Shores #A-303 is a 2 bedroom, 2 bath unit on the 3rd floor. It it 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...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> 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
HI> Kihei
Condo, 2 Bedrooms + Convertible Sofa in Living room, 2 Baths (Sleeps 4-6)
South of central Kihei, just north of Wailea makes the location of this Maui condo easily accessible and with Kahului airport only thirty-five minutes away you won’t ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> 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 queen sofa bed, and a walk-in shower (no tub). Window air ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
HI> 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
HI> 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
HI> Kihei
Two couples or a family with small children will find ideal accommodations at Pacific Shores A-105. Located across from the Charley Young access to Kamaole Beach I, you can be snorkeling, swimming, or basking in the sun within minutes of leaving...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
When you spend your Maui vacation at Pacific Shores A-217 you can walk to the beach, restaurants, and the grocery store right from your condo. You can rent this affordable, welcoming condo and still have funds left over for whale-watching tours,...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei