var realtor = "B0138"; var sql = "SELECT list_price,city,udf_photo1,mls_acct,CONCAT(street_num, ' ', street_name) AS address FROM PC_Listings INNER JOIN agents ON la_code=mlsagentid WHERE la_code= ? order by rand() limit 1"; var mls_acct = "0"; var fp_image_url = "http://www.panamacityrealestate.com/images/nopic.gif"; var fp_address = "00 HWY 79"; var fp_url = "http://www.panamacityrealestate.com/cgi-bin/webdata_pro.pl?_cgifunction=form&_layout=mlsAgentGen&keyval=PC_Listings.mls_acct=389302"; var fp_price = "$1,500,000"; var fp_loc = "EBRO";