var realtor = ""; var mls_loc = ""; var sql = "SELECT * FROM PX_Listings WHERE priority=1 AND udf_photo0!='' AND list_price>349999 ORDER BY rand() LIMIT 1;"; var mls_acct = "519320"; var fp_image_url = "http://ecarmls.com/emeraldreports/media/519320_0187500.jpg"; var fp_address = "179 PELICAN CIR"; var fp_url = "http://www.beachpropertiesofflorida.com/cgi-bin/webdata_pro.pl?_cgifunction=form&_layout=featured&keyval=PX_Listings.mls_acct=519320"; var fp_price = "$5,995,000"; var fp_loc = "CAMP CREEK LAKE";