query
RESULTSET
query
  BLUE CLEAN DAMAGEFEE DBLBATHS DBLBEDS DBLRATE DBLRATEACTUAL FEATURELIST HASHCODE IHOLDING INTOCCU PICLIST STRADDRESS1 STRADDRESS2 STRAREA STRCHANGELOGFLAG STRCITY STRCOMPLEX STRCOUNTRY STRDESC STRLOCATION STRMAPREF STRNAME STRPHONE STRPICURL STRPROPID STRSTATE STRTURNDAY STRTYPE STRUNITTYPE STRZIP TYPEDESC
1 0 0 0 3 3 [empty string] 970 Coin Operated Laundry,Dishwasher,Elevator,Internet Access,Non-Smoking,Shared Pool,TV,VCR -1552737321 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/32.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/33.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/34.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/35.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/36.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/37.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/38.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/39.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/40.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/41.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/42.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/43.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/44.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/45.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/46.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/47.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/48.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/49.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/51.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/52.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/53.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/54.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/55.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SEAMAST311/56.jpg Sea Master 311 1310 N Waccamaw Dr Oceanfront [empty string] Garden City Beach [empty string] Sea Master <h6>Location</h6> 1310 North Waccamaw Drive <br> Garden City Beach, SC 29576 <h6>Property Features</h6> 3rd Floor Unit, Flat Screen TV in Living Area and television in Master Bedroom, Shared pool, Central Heat/Air, Coin Operated laundry facilities on each floor, Dishwasher, Microwave, Telephone, Non-Smoking, Private balcony, Internet access <h6>Sleep Accommodations</h6> 3 Bedrooms - 1 King, 1 Queen, 1 Queen <br> Living Room - 1 Sofa Bed Garden City Beach, SC [empty string] Sea Master 311 (843)357-0214 [empty string] SEAMAST311 SC Saturday Condo [empty string] 29576 [empty string]
CACHED false
EXECUTIONTIME 5
SQL SELECT `pp_propertyinfo`.*, `pp_season_rates`.`dblRate` AS dblRateActual FROM `pp_propertyinfo` JOIN `pp_season_rates` ON `pp_propertyinfo`.`strPropId` = `pp_season_rates`.`strPropID` WHERE `strCountry` = ? AND `strType` = 'Condo' AND `pp_propertyinfo`.`strPropId` NOT IN ( SELECT DISTINCT `strPropId` FROM `pp_property_non_available_dates` WHERE 0=1 OR ? BETWEEN `dtFromDate` AND `dtToDate` OR ? BETWEEN `dtFromDate` AND `dtToDate` OR ? BETWEEN `dtFromDate` AND `dtToDate` OR ? BETWEEN `dtFromDate` AND `dtToDate` OR ? BETWEEN `dtFromDate` AND `dtToDate` OR ? BETWEEN `dtFromDate` AND `dtToDate` ORDER BY `strPropId` ) AND `pp_season_rates`.`strChargeBasis` = 'Weekly' AND ? BETWEEN `dtBeginDate` AND `dtEndDate` GROUP BY `pp_propertyinfo`.`strPropId` ORDER BY `strName`
SQLPARAMETERS
array
1 Sea Master
2 {ts '2013-04-21 00:00:00'}
3 {ts '2013-04-22 00:00:00'}
4 {ts '2013-04-23 00:00:00'}
5 {ts '2013-04-24 00:00:00'}
6 {ts '2013-04-25 00:00:00'}
7 {ts '2013-04-26 00:00:00'}
8 {ts '2013-04-21 00:00:00'}

Sea Master - Garden City Beach, SC - Oceanfront Complex

Sea Master - 1310 N Waccamaw Dr - Garden City Beach, SC
priced from $970.00/week

Sea Master is an oceanfront complex offering oceanfront and oceanview condos, an oceanside swimming pool, elevator and accommodating 6-8 with 2-3 bedrooms and 2-3 bathrooms. Each condo features central HVAC, all-electric kitchen, living-dining area, telephone, cable TV, dishwasher, microwave and private balcony. Coin operated laundry on premises. Some condos have a washer/dryer. No pets are allowed. No Golf Carts are permitted.

Prop ID Bed Bath Max Occupancy
Sea Master 311 3 3
8
VOTE NOW