//SELECT PrimaryListings.RecordId, PrimaryListings.BusinessName, PrimaryListings.FullAddress, PrimaryListings.CityName, PrimaryListings.StateCode, PrimaryListings.Zip, PrimaryListings.Phone, PrimaryListings.thumbnail, BDC_Codes.mp_level1name, BDC_Codes.mp_level2name FROM BDC_Codes RIGHT OUTER JOIN PrimaryListings ON (BDC_Codes.bdc_id = PrimaryListings.BDC1) WHERE (tier >= 1  ) AND ListingType >= '1' AND thumbnail <> '' ORDER BY RAND() LIMIT 1;  //lowcountrymarketplace.com
document.write("<link rel='stylesheet' type='text/css' href='http://assets.lowcountrymarketplace.com/styles/widgets/greatfinds_widget.css' />");

function writeWidget(){
    
    document.write("<div id='greatfindsoutbox'>");
    document.write("<div class='greatfindsheader'>");
    document.write("<h4>");
    document.write("<a href='http://www.lowcountrymarketplace.com' title='Lowcountry Marketplace' target='_blank'>Lowcountry Marketplace</a>&nbsp;");
    document.write("</h4>");
    document.write("</div>");
    
    document.write("<div id='marketplace_greatfindsbox'>");
    
                document.write("<div class='marketplace_greatfinds_image'>");
            document.write("<a href='http://northcharleston.lowcountrymarketplace.com/SC/beauty-salons-spas-and-barbers/great-clips-for-hair--0115431152/' target='_blank'><img src='http://assets.lowcountrymarketplace.com/thumbnails/greatclipsnorthrivers_thumb.jpg' width='90' alt='Great Clips for Hair' border='0' /></a>");
            document.write("</div>");
            document.write("<a href='http://northcharleston.lowcountrymarketplace.com/SC/beauty-salons-spas-and-barbers/great-clips-for-hair--0115431152/' target='_blank'>Great Clips for Hair</a><br />");
                    document.write("7250 Rivers Ave Unit 500-1 <br />");
                document.write("North Charleston, SC<br />");
            document.write("(843) 797-5885<br />");
            	
        document.write("<div class='spacer5px'>&nbsp;</div>");
        
    document.write("<div id='homepagepromo_moreonshop'>Find more businesses on <a href='http://www.lowcountrymarketplace.com' title='Lowcountry Marketplace' TARGET='_blank'>Lowcountry Marketplace</a></div>");
    document.write("<div id='homepagepromo_sbcats'>");
    document.write("<a href='http://www.lowcountrymarketplace.com/SC/food-and-dining/' TARGET='_blank'>Restaurants</a> &middot; <a href='http://www.lowcountrymarketplace.com/SC/arts-and-entertainment/' TARGET='_blank'>Entertainment</a> &middot; <a href='http://www.lowcountrymarketplace.com/SC/beauty-salons-spas/' TARGET='_blank'>Health</a> &middot; <a href='http://www.lowcountrymarketplace.com/SC/real-estate/' TARGET='_blank'>Real Estate</a> &middot; <a href='http://www.lowcountrymarketplace.com/SC/home-and-garden/' TARGET='_blank'>Home &amp; Garden</a> &middot; <a href='http://www.lowcountrymarketplace.com/coupons/' TARGET='_blank'>Coupons</a>");
    document.write("</div>");
    document.write("</div>");
    document.write("</div>");
}

window.setTimeout(writeWidget(),300);