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.5 3 [empty string] Covered Parking/Garage,Dishwasher,DVD,Internet Access,Non-Smoking,Shared Pool,TV,VCR,Washer/Dryer -1765296610 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/99.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/100.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/101.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/103.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/104.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/105.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/106.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/107.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/108.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/109.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/110.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/111.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/112.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/113.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/114.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/115.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/116.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/117.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR12/118.jpg Admiral's Quarters II 12 1217 S Ocean Blvd Oceanfront [empty string] Surfside Beach [empty string] Admiral's Quarters <h6> Location </h6> 1217 South Ocean Blvd.<br> Surfside Beach, SC 29575 <h6> Property Features </h6> Townhome style, 3 TVs, 1 VCR, 1 DVD, Shared pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Telephone, Non-Smoking, WiFi Internet Access <h6> Sleep Accommodations </h6> 3 Bedrooms Up - 1 Queen, 1 Queen, 2 Single <br> Living Room - 1 Queen Sofa Bed Surfside Beach, SC [empty string] Admiral's Quarters II 12 (843)238-8725 [empty string] AQTR12 SC Saturday Condo [empty string] 29575 org.apache.axis.description.TypeDesc@3252befd
2 0 0 0 2.5 3 [empty string] Covered Parking/Garage,Dishwasher,DVD,First Floor,Internet Access,Non-Smoking,Shared Pool,TV,VCR,Washer/Dryer -843249707 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/35.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/36.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/37.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/38.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/40.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/41.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/42.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/43.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/44.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/45.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/46.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/47.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/48.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/49.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/50.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/51.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR13/52.jpg Admiral's Quarters II 13 1217 S Ocean Blvd Oceanfront [empty string] Surfside Beach [empty string] Admiral's Quarters <h6> Location </h6> 1217 South Ocean Blvd. <br>Surfside Beach, SC 29575 <h6> Property Features </h6> Townhome style, 2 TVs, 1 VCR, 2 DVD, Shared pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Telephone, Non-Smoking <h6> Sleep Accommodations </h6> 3 Bedrooms Up - 1 Queen, 1 Queen, 2 Single <br> Living Room - 1 Double Sofa Bed Surfside Beach, SC [empty string] Admiral's Quarters II 13 (843)238-3852 [empty string] AQTR13 SC Saturday Condo [empty string] 29575 org.apache.axis.description.TypeDesc@3252befd
3 0 0 0 2.5 3 [empty string] Covered Parking/Garage,Dishwasher,DVD,First Floor,Non-Smoking,Shared Pool,TV,VCR,Washer/Dryer -1698806562 0 9 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/1.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/30.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/31.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/32.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/33.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/34.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/35.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/36.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/37.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/38.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/39.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/40.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/41.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/42.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/43.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/44.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/45.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/46.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/47.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/48.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/49.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR14/50.jpg Admiral's Quarters II 14 1217 S Ocean Blvd Oceanfront [empty string] Surfside Beach [empty string] Admiral's Quarters <h6> Location </h6> 1217 South Ocean Blvd. <br>Surfside Beach, SC 29575 <h6> Property Features </h6> One level, 3 TVs, 2 VCR, 1 DVD, Shared pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Telephone, Non-Smoking <h6> Sleep Accommodations </h6> 3 Bedrooms - 1 Queen, 1 Queen and 1 Single, 2 Single <br> Living Room - 1Queen Sofa Bed Surfside Beach, SC [empty string] Admiral's Quarters II 14 (843)238-1405 [empty string] AQTR14 SC Saturday Condo [empty string] 29575 org.apache.axis.description.TypeDesc@3252befd
4 0 0 0 2.5 3 [empty string] Covered Parking/Garage,Dishwasher,DVD,Non-Smoking,Shared Pool,TV,VCR,Washer/Dryer 1107538634 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/34.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/36.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/37.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/38.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/39.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/40.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/41.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/42.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/43.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/44.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/45.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/46.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/47.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/48.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/49.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/50.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/51.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/52.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/53.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/54.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR2/55.jpg Admiral's Quarters II 2 1217 S Ocean Blvd Oceanfront [empty string] Surfside Beach [empty string] Admiral's Quarters <h6> Location </h6> 1217 South Ocean Blvd. <br> Surfside Beach, SC 29575 <h6> Property Features </h6> Townhome style, 2 TVs, 1 VCR, 1 DVD, Stereo, Shared pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Telephone <h6> Sleep Accommodations </h6> 3 Bedrooms Up - 1 Queen, 1 Queen, 2 Single <br> Living Room - 1 Queen Sofa Bed Surfside Beach, SC [empty string] Admiral's Quarters II 2 (843)238-9306 [empty string] AQTR2 SC Saturday Condo [empty string] 29575 org.apache.axis.description.TypeDesc@3252befd
5 0 0 0 2.5 3 [empty string] Covered Parking/Garage,Dishwasher,DVD,First Floor,Internet Access,Non-Smoking,Off Season Monthly,Shared Pool,TV,VCR,Washer/Dryer -1566365344 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/16.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/17.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/18.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/19.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/20.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/21.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/22.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/23.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/24.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/25.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/26.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/27.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/28.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/29.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/30.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/31.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/32.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/33.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/34.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/35.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR8/36.jpg Admiral's Quarters II 8 1217 S Ocean Blvd Oceanfront [empty string] Surfside Beach [empty string] Admiral's Quarters <h6> Location </h6> 1217 South Ocean Blvd.<br> Surfside Beach, SC 29575 <h6> Property Features </h6> Townhome style, 4 TVs, 2 VCR, 1 DVD, Stereo, Shared pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Telephone, Non-Smoking <h6> Sleep Accommodations </h6> 3 Bedrooms Up - 1 Queen, 1 Queen, 2 Single <br> Living Room - 1 Queen Sofa Bed Surfside Beach, SC [empty string] Admiral's Quarters II 8 (843)238-2693 [empty string] AQTR8 SC Saturday Condo [empty string] 29575 org.apache.axis.description.TypeDesc@3252befd
6 0 0 0 2.5 3 [empty string] Covered Parking/Garage,Dishwasher,First Floor,Non-Smoking,Off Season Monthly,Shared Pool,TV,VCR,Washer/Dryer 1997144593 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/15.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/16.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/17.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/18.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/19.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/20.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/21.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/22.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/23.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/24.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/25.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/26.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/27.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/28.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/29.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/30.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/31.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/32.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/33.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/34.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/AQTR9/35.jpg Admiral's Quarters II 9 1217 S Ocean Blvd Oceanfront [empty string] Surfside Beach [empty string] Admiral's Quarters <h6> Location </h6> 1217 South Ocean Blvd.<br> Surfside Beach, SC 29575 <h6> Property Features </h6> Townhome style, 4 TVs, 2 VCRs, Shared pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Telephone, Non-Smoking <h6> Sleep Accommodations </h6> 3 Bedrooms Up - 1 Queen, 1 Double, 2 Single <br> Living Room - 1 Queen Sofa Bed Surfside Beach, SC [empty string] Admiral's Quarters II 9 (843)477-1592 [empty string] AQTR9 SC Saturday Condo [empty string] 29575 org.apache.axis.description.TypeDesc@3252befd
CACHED false
EXECUTIONTIME 0
SQL SELECT `pp_propertyinfo`.* FROM `pp_propertyinfo` WHERE `strCountry` = ? AND `strType` = 'Condo' ORDER BY `strName`
SQLPARAMETERS
array
1 Admiral's Quarters

Admiral's Quarters - Surfside Beach, SC - Oceanfront Complex

Admiral's Quarters - 1217 S Ocean Blvd - Surfside Beach, SC

Townhomes & flats with a spacious oceanfront courtyard and swimming pool. Private enclosed parking garage. Each condo features central HVAC, all-electric kitchen, living-dining area, telephone, cable TV, washer/dryer, dishwasher, microwave and private balcony. No pets are allowed on premises or in any of the condos.
Prop ID Bed Bath Max Occupancy
Admiral's Quarters II 12 3 2.5
8
More Info Add to Favorites
Admiral's Quarters II 13 3 2.5
8
More Info Add to Favorites
Admiral's Quarters II 14 3 2.5
9
More Info Add to Favorites
Admiral's Quarters II 2 3 2.5
8
More Info Add to Favorites
Admiral's Quarters II 8 3 2.5
8
More Info Add to Favorites
Admiral's Quarters II 9 3 2.5
8
More Info Add to Favorites