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 3 [empty string] Dishwasher,DVD,First Floor,Internet Access,Non-Smoking,Shared Pool,TV,Washer/Dryer 2096181539 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/1.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/2.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/3.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/4.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/5.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/6.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/7.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/8.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/9.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/10.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/11.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVB5/12.jpg Floral Villas B5 416 N. Ocean Blvd Second Row [empty string] Surfside Beach [empty string] Floral Villas <h6> Location </h6> 416 North Ocean Blvd. <br> Surfside Beach, SC 29575 <h6>Property Features</h6> 1st Floor Unit, 3 TVs, 3 DVD's, WIFI, Shared Pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Non-Smoking, Private extended patio, NO Elevator <h6> Sleep Accommodations </h6> 3 Bedrooms - 1 King, 1 Queen, 1 Queen br> Living Room - 1 Queen Sofa Bed Surfside Beach, SC [empty string] Floral Villas B5 843-238-1523 [empty string] FVB5 SC Any Condo [empty string] 29575 [empty string]
2 0 0 0 2 3 [empty string] Dishwasher,Non-Smoking,Off Season Monthly,Shared Pool,TV,Washer/Dryer -572662322 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/1.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/2.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/3.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/4.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/5.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/6.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/7.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/8.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/9.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/10.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/11.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/12.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/13.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/14.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/15.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/16.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/17.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC11/18.jpg Floral Villas C11 415 N. Ocean Blvd Second Row [empty string] Surfside Beach [empty string] Floral Villas <h6> Location </h6> 416 North Ocean Blvd. <br> Surfside Beach, SC 29575 <h6>Property Features</h6> 1st Floor Unit, 3 TVs, Shared Pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Non-Smoking, Private extended patio, NO Elevator <h6> Sleep Accommodations </h6> 3 Bedrooms - 1 King, 1 Queen, 1 Queen br> Living Room - 1 Queen Sofa Bed Surfside Beach, SC [empty string] Floral Villas C11 [empty string] [empty string] FVC11 SC Saturday Condo [empty string] 29575 [empty string]
3 0 0 0 2 3 [empty string] Dishwasher,DVD,Internet Access,Non-Smoking,Off Season Monthly,Shared Pool,TV,VCR,Washer/Dryer 411624938 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/36.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/37.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/38.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/39.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/40.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/41.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/42.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/43.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/44.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/45.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/46.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/47.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/48.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/49.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/50.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/51.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/52.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVC9/53.jpg Floral Villas C9 416 N Ocean Blvd Second Row [empty string] Surfside Beach [empty string] Floral Villas <h6>Location</h6> 416 North Ocean Blvd. <br> Surfside Beach, SC 29575 <h6>Property Features</h6> 1st Floor Unit, Wireless internet, 2 TVs, 1 VCR, 1 DVD, WIFI, Stereo, Shared Pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Telephone, Non-Smoking <h6>Sleep Accommodations</h6> 3 Bedrooms - 1 Queen, 1 Double, 2 Single <br> Living Room - 1 Double Sofa Bed Surfside Beach, SC [empty string] Floral Villas C9 8432382089 [empty string] FVC9 SC Saturday Condo [empty string] 29575 [empty string]
4 0 0 0 2 3 [empty string] Dishwasher,DVD,First Floor,Internet Access,Non-Smoking,Off Season Monthly,Shared Pool,TV,VCR,Washer/Dryer -1865085359 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/1.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/35.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/36.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/37.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/38.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/39.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/40.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/41.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/42.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/43.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/44.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/45.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/46.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/47.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/48.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/49.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/50.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/51.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/52.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD13/53.jpg Floral Villas D13 416 N Ocean Blvd Second Row [empty string] Surfside Beach [empty string] Floral Villas <h6>Location</h6> 416 North Ocean Blvd. <br> Surfside Beach, SC 29575 <h6>Property Features</h6> 1st Floor Unit, 2 TVs, 1 VCR, 1 DVD, Stereo, Wireless internet, Shared Pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Telephone, Non-smoking, Patio Overlooking Pool, Wireless internet access <h6>Sleep Accommodations</h6> 3 Bedrooms - 1 King, 1 Queen, 2 Single <br> Living Room - 1 Queen Sofa Bed Surfside Beach, SC [empty string] Floral Villas D13 (843)238-5992 [empty string] FVD13 SC Saturday Condo [empty string] 29575 [empty string]
5 0 0 0 2 3 [empty string] Dishwasher,DVD,Internet Access,Non-Smoking,Off Season Monthly,Second Floor,Shared Pool,TV,VCR,Washer/Dryer 40964889 0 9 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/1.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/2.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/4.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/6.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/8.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/9.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/10.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/11.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/12.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/13.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/14.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/16.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/17.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/18.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/20.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/21.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/22.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/23.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/24.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/25.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/26.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVD14/27.jpg Floral Villas D14 416 N. Ocean Blvd Second Row [empty string] Surfside Beach [empty string] Floral Villas <h6> Location </h6> 416 North Ocean Blvd. <br> Surfside Beach, SC 29575 <h6>Property Features</h6> Fabulous ocean and pool views, festive professional decor, and completely updated spring 2012. This second floor unit has everything you need for a great vacation! Across the street from the beach access and within walking distance to pier, shops, and eateries! Relax on the courtyard deck and enjoy pool and ocean views in the bar height deck furniture. Relax on the front deck and enjoy the wildlife on Lake Elizabeth. Complete with central heat/air, 4.1 cu ft High Efficiency Front Loader washer, 7.4 cu ft Electric Dryer, dishwasher, new refridgerator with ice maker, and two updated tile floored bathrooms. Lots of new furniture and new kitchen furnishings make this extremlely well maintained, completely NON-SMOKING property your top choice! Sorry, NO Pets allowed. Free beach chairs and beach cart for your conveience! Many extra amenities include: 4 Flat Screen TV's, 2 DVDs, 1 VCR, WIFI, 3 Ceiling Fans, New Mattresses/Bedding, WIFI, Books & Games. * 4:00PM CHECK-IN ALWAYS NO EXCEPTIONS FOR THIS PROPERTY* <h6> Sleep Accommodations </h6> 3 Bedrooms - 1 Queen, 1 Queen & 1 Single, 1 Bunk & 1 Double Surfside Beach, SC [empty string] Floral Villas D14 843-712-1790 [empty string] FVD14 SC Any Condo [empty string] 29575 [empty string]
6 0 0 0 2 3 [empty string] Dishwasher,DVD,Internet Access,Non-Smoking,Second Floor,Shared Pool,TV,VCR,Washer/Dryer -1116174193 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/17.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/18.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/19.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/20.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/21.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/22.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/23.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/24.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/25.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/26.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/27.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/28.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/29.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/30.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/31.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/32.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/33.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/34.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/35.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/36.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE18/37.jpg Floral Villas E18 416 N Ocean Blvd Second Row [empty string] Surfside Beach [empty string] Floral Villas <h6> Location </h6> 416 North Ocean Blvd. <br> Surfside Beach, SC 29575 <h6>Property Features</h6> 2nd Floor Unit, 4 TVs, 1 VCR, 1 DVD, Shared Pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, 2 Telephones (Long Distance Service), Wireless internet, Access, Non-Smoking, Private Balcony, NO Elevator <h6> Sleep Accommodations </h6> 3 Bedrooms - 1 King, 1 Queen, 2 Single <br> Living Room - 1 Queen Sofa Bed Surfside Beach, SC [empty string] Floral Villas E18 (843)238-4226 [empty string] FVE18 SC Saturday Condo [empty string] 29575 [empty string]
7 0 0 0 2 3 [empty string] Dishwasher,DVD,First Floor,Internet Access,Non-Smoking,Off Season Monthly,Shared Pool,TV,VCR,Washer/Dryer 1746894919 0 8 http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/17.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/18.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/19.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/20.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/21.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/22.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/23.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/24.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/25.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/26.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/27.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/28.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/29.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/30.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/31.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/32.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/33.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/34.jpg,http://secure.instantsoftwareonline.com/StayUSA/PropertyImages/0260/FVE19/35.jpg Floral Villas E19 416 N Ocean Blvd Second Row [empty string] Surfside Beach [empty string] Floral Villas <h6>Location</h6> 416 North Ocean Blvd. <br> Surfside Beach, SC 29575 <h6>Property Features</h6> 1st Floor Unit, 4 TVs, 2 VCRs, 1 DVD, Wireless internet, Shared Pool, Central Heat/Air, Washer/Dryer, Dishwasher, Microwave, Non-Smoking, Private Balcony <h6>Sleep Accommodations</h6> 3 Bedrooms - 1 King, 1 Queen, 2 Single & 2 Roll Away beds <h6>From Our Happy Guests...</h6> <p>"Excellent service...very courteous staff, and very nice unit!" -</i>The Reeves from Martinsville, VA </p> Surfside Beach, SC [empty string] Floral Villas E19 [empty string] [empty string] FVE19 SC Saturday Condo [empty string] 29575 [empty string]
CACHED false
EXECUTIONTIME 2
SQL SELECT `pp_propertyinfo`.* FROM `pp_propertyinfo` WHERE `strCountry` = ? AND `strType` = 'Condo' ORDER BY `strName`
SQLPARAMETERS
array
1 Floral Villas

Floral Villas - Surfside Beach, SC - Second Row Complex

Floral Villas - 416 N Ocean Blvd - Surfside Beach, SC

Floral Villas is located second row in North Surfside Beach and offers guests a large pool surrounded by beautifully landscaped grounds. Each spacious condo has sun decks, private porches, wireless internet, and a fully equipped kitchen. All first floor units are ground level. No pets are allowed in any of the condos. 2 parking spaces per reservation. Golf Carts are not permitted.