var realtor = ""; var mls_loc = "E"; var sql = "SELECT * FROM PZ_Listings WHERE priority=1 AND udf_photo0!='' AND list_price>349999 AND category != 9 ORDER BY rand() LIMIT 1;"; var mls_acct = "508872"; var fp_image_url = "http://ecarmls.com/emeraldreports/media/508872_0280000.jpg"; var fp_address = "178 BEACH BIKE WAY"; var fp_url = "http://www.pelicanproperty.com/cgi-bin/webdata_pro.pl?_cgifunction=form&_layout=listings&keyval=PZ_Listings.unique_id=E508872"; var fp_price = "$995,000"; var fp_loc = "SEACREST";