HOME || LOGIN

Help! I need an agent... Name: Email: Daytime Phone: Evening Phone: Where You Are Looking To Buy:

Home: Our Agents Buying Home | Search URC Listings | Search MLS    Below is a list of all of the United Realty Center agents. You may click the links above to see agents according to the office location they report to. You may also use the drop-down menu below to view a specific real estate agent you may already be working with. Choose a Real Estate Agente Here $last_name, $first_name"; } print ""; /* END PHP FOR REAL ESTATE AGENTS DROP DOWN LIST */ ?> 0) { $previous_ref = $start - 7; $page_links = "Previous"; $next_ref = $start + 7; if ($next_ref < $total_rows) { $page_links .= " || Next"; } } else { $next_ref = $start + 7; $page_links .= "Next"; } /***************************************** * run query according to previous results *****************************************/ /* PHP TO CREATE AGENT TABLES WITH LINKS, PICTURE, AND CONTACT INFORMATION FOR EACH */ $sql_agent = mysql_query("SELECT * FROM agents ORDER BY last_name LIMIT $start, 7"); print "$total_rows total agents | $page_links "; // START GATHERING THE AGENTS while ($row_agent = mysql_fetch_object($sql_agent)) { $agentid = $row_agent->agentid; $first_name = $row_agent->first_name; $last_name = $row_agent->last_name; $mobile_number = $row_agent->mobile_number; $fax_number = $row_agent->fax_number; $office_number = $row_agent->office_number; $agent_email_address = $row_agent->email_address; $pic_on_file = $row_agent->pic_on_file; print " $first_name $last_name "; if ($pic_on_file == "YES" ) { print ""; } else { print ""; } print " Real Estate Agent: $first_name $last_name $agent_email_address Mobile Phone: $mobile_number Office Phone: $office_number Fax Number: $fax_number :: View My Listings :: "; } /* END PHP FOR AGENT TABLES */ ?>

URC Home | Buying | Selling | Financing | Contact Us General Contact: Info@UnitedRealtyCenter.com United Realty Center, Inc. is an Equal Housing Lender