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] Dishwasher,DVD,Non-Smoking,Off Season Monthly,Second Floor,Shared Pool,TV,VCR,Washer/Dryer -2134689850 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/16.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/17.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/18.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/19.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/20.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/22.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/23.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/24.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/25.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/26.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/27.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/28.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/29.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/30.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/31.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/32.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/33.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/34.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK204/35.jpg Beach Walk 204 1212 S Ocean Blvd Second Row [empty string] Surfside Beach [empty string] Beach Walk <h6> Location </h6> 1212 South Ocean Blvd.<br> Surfside Beach, SC 29575 <h6> Property Features </h6> 2nd Floor, 2 TVs, 2 VCRs, 1 DVD, Shared pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Telephone, Non-Smoking, Private balcony, Shared charcoal grill <h6> Sleep Accommodations </h6> 2 Bedrooms - 1 Queen, 1 Queen & 1 Bunk bed <br> Living Room - 1 Queen sofa bed Surfside Beach, SC [empty string] Beach Walk 204 (843)477-5688 [empty string] BWALK204 SC Saturday Condo [empty string] 29575 org.apache.axis.description.TypeDesc@3252befd
2 0 0 0 2 2 [empty string] Dishwasher,DVD,Non-Smoking,Off Season Monthly,Shared Pool,TV,VCR,Washer/Dryer -1968335908 0 6 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/1.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/2.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/3.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/4.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/5.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/6.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/7.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/8.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/9.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/10.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/11.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/12.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/13.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/14.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/15.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/16.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/17.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/18.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/BWALK301/19.jpg Beach Walk 301 1212 S Ocean Blvd Second Row [empty string] Surfside Beach [empty string] Beach Walk <h6> Location </h6> 1212 South Ocean Blvd.<br> Surfside Beach, SC 29575 <h6> Property Features </h6> 3rd Floor, 2 TVs, 1 VCR, 2 DVD players, Shared pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Private balcony, Shared charcoal grill. This is a non-smoking property and pets are not allowed. <h6> Sleep Accommodations </h6> 2 Bedrooms - 1 King, 1 Queen <br> Living Room - 1 Sofa Bed Surfside Beach, SC [empty string] Beach Walk 301 843-839-5377 [empty string] BWALK301 SC Saturday Condo [empty string] 29575 org.apache.axis.description.TypeDesc@3252befd
CACHED false
EXECUTIONTIME 16
SQL SELECT `pp_propertyinfo`.* FROM `pp_propertyinfo` WHERE `strCountry` = ? AND `strType` = 'Condo' ORDER BY `strName`
SQLPARAMETERS
array
1 Beach Walk

Beach Walk - Surfside Beach, SC - Second Row Complex

Beach Walk - 1212 S Ocean Blvd - Surfside Beach, SC

Beach Walk is a 2nd row complex offering a limited view of the ocean from most balconies and accommodating 6-7 with 2 bedrooms and 2 baths. Large swimming pool for guests to enjoy. All condos feature central HVAC, all-electric kitchen, living-dining area, telephone, cable TV, washer-dryer, dishwasher, microwave and private balcony. No pets are allowed.
Prop ID Bed Bath Max Occupancy
Beach Walk 204 2 2
8
More Info Add to Favorites
Beach Walk 301 2 2
6
More Info Add to Favorites