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 = "528386";
var fp_image_url = "http://ecarmls.com/emeraldreports/media/528386_0568750.jpg";
var fp_address = "LOT 6 COUNTRY CLUB DR";
var fp_url = "http://www.rulnickrealty.com/cgi-bin/webdata_pro.pl?_cgifunction=form&_layout=listings&keyval=PX_Listings.mls_acct=528386";
var fp_price = "$59,900";
var fp_loc = "SANTA ROSA BEACH";