query
RESULTSET
query
  BLUE CLEAN DAMAGEFEE DBLBATHS DBLBEDS DBLRATE 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 2 2 [empty string] Coin Operated Laundry,Dishwasher,Elevator,Internet Access,Non-Smoking,Off Season Monthly,Shared Pool,TV 1588316975 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/15.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/16.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/17.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/18.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/19.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/20.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/21.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/22.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/23.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/24.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/25.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/26.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/27.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/28.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/30.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/31.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/32.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/33.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/34.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/SWALK343/35.jpg Surf Walk 343/344 111-16th Ave N Second Row [empty string] Surfside Beach [empty string] Surf Walk <h6> Location </h6> 111- 16th Ave N. Surfside Beach, SC 29575 <h6> Proeprty Features </h6> 3rd Floor Unit, Elevator, Non-Smoking, Unit Is Like a Hotel Lock Out Unit, 2 TVs, Telephone, Coin Operated Laundry On 3rd Floor, Dishwasher, Shared Pool, Private Balcony, Internet Access (ethernet cable required) <h6> Sleep Accommodations </h6> 2 Bedrooms- 4 Doubles Surfside Beach, SC [empty string] Surf Walk 343/344 (843)232-8791 [empty string] SWALK343 SC Saturday Condo [empty string] 29575 [empty string]
CACHED false
EXECUTIONTIME 0
SQL SELECT `pp_propertyinfo`.* FROM `pp_propertyinfo` WHERE `strCountry` = ? AND `strType` = 'Condo' ORDER BY `strName`
SQLPARAMETERS
array
1 Surf Walk

Surf Walk - Surfside Beach, SC - Second Row Complex

Surf Walk - 111-16th Ave N - Surfside Beach, SC

Surf Walk is a 2nd row complex with easy access to the ocean, swimming pool and elevator, accommodating 8-10 with 2 bedrooms and 2 baths. Each condo features central HVAC, all-electric kitchen, living-dining area, telephone, cable TV, washer/dryer, dishwasher, microwave and private balcony. Coin operated laundry on site. No pets are allowed. No Golf Carts are permitted. 

Prop ID Bed Bath Max Occupancy
Surf Walk 343/344 2 2
8