var realtor = ""; var sql = "select * from PX_Listings where (priority = '1' and udf_photo1 IS NOT NULL) order by rand() limit 1;"; var mls_acct = "468354"; var fp_image_url = "http://ecarmls.com/emeraldreports/media/468354_161632.jpg"; var fp_address = "LOT 23 LARKSPUR AVE"; var fp_url = "http://www.rulnickrealty.com/cgi-bin/webdata_pro.pl?_cgifunction=form&_layout=listings&keyval=PX_Listings.mls_acct=468354"; var fp_price = "$10,700"; var fp_loc = "DEFUNIAK SPRINGS";