";
if ($www_count==0){
$redirected_url=str_replace("http://", "http://www.", $existing_url);
//print "$redirected_url
";
header("Location: $redirected_url");
}
include ("/sites/relocationusa_tp/register_globals.htm");
include ("lastrecip.php");
include "header_variables.htm";
include "spam_lead_checks.htm";
//print "$cookie_refer
";
//$referer=$_SERVER["HTTP_REFERER"];
//print "$referer";
//$articlepath=$REQUEST_URI;
$articlepath=$_SERVER["REQUEST_URI"];
if ( !substr_count($articlepath, "/blog/") and !substr_count($articlepath, "enter_commitment.htm") and !substr_count($articlepath, ".css") and !substr_count($articlepath, ".js") ) { //load rest of header file
//print_r($_COOKIE);
//$mypath=($SCRIPT_NAME);
//print "$mypath
");
//print "$show ";
$underscorepos=strpos($show, "_");
//print "$underscorepos ";
if ($underscorepos) {
$pagenum=substr($show, $underscorepos+1);
//print "$pagenum";
$show=substr($show, 0, $underscorepos);
} //end if
//if ($mlsno and $show!="saproperty") header("location:/data/tar/saproperty.asp?mlsno=$mlsno");
//REFORMAT CASE AND CHANGE CERTAIN FILENAMES VALUES
$show=ucwords($show);
$show=str_replace(" Of ", " of ", $show);
$show=str_replace("Golfcity", "City", $show);
$show=str_replace("Golfcourse", "Golf Community", $show);
$show=str_replace("Listingtype", "Property Type", $show);
$show=str_replace("Golfcommunity", "Golf Community", $show);
//$show=str_replace("Horse", "City", $show);
$show=str_replace("Index", "", $show);
$show=str_replace("Popular", "Subdivision", $show);
//print $show;
//SET THE MODIFIER, MIDDLER, BETWEEN, ENDER AS APPROPRIATE
if (substr_count($mypath, "/golf/")) {$modifier=("Golf ");}
if (substr_count($mypath, "/gated/")) {$ender=(" Communities");}
if (substr_count($mypath, "/construction/")) {$ender=(" Construction");}
if (substr_count($mypath, "/levels/")) {$ender=(" Story");}
if (substr_count($mypath, "/style/")) {$ender=(" Style");}
if (substr_count($mypath, "/bedrooms/")) {$ender=(" Bedroom");}
if (substr_count($mypath, "/baths/")) {$ender=(" Bath");}
if (substr_count($mypath, "/horse/")) {$modifier=("Horse ");}
//if (substr_count($mypath, "/acres/")) {$ender=(" on 1 or more Acres of Land");}
if (substr_count($mypath, "/homes/") or substr_count($mypath, "/property/")){
$spacepos=strpos($show, " ");
$show=substr($show, $spacepos, 100);
}
/*
if (substr_count($mypath, "/levels/") or substr_count($mypath, "/zip/")) {} else
{
$digits = array("0", "1", "2", "3", "4", "5", "6", "7", "8", "9");
$show=str_replace($digits,"",$show);
}
*/
if (substr_count($mypath, "/levels/")) $show=$show{0}; //only show first digit & leave out the page #
if (substr_count($mypath, "/zip/")) $show=substr($show, 0, 5); //only show first digit & leave out the page #
$between='in';
if (substr_count($mypath, "/address.htm")) {$between=('by');}
if (substr_count($mypath, "/popular.htm")) {$between=('by');}
if (substr_count($mypath, "/high.htm")) {$show=('High School'); $between=('by'); $list="yes";}
if (substr_count($mypath, "/middle.htm")) {$show=('Middle School '); $between=('by'); $list="yes";}
if (substr_count($mypath, "/elementary.htm")) {$show=('Elementary School '); $between=('by'); $list="yes";}
if (substr_count($mypath, "/district.htm")) {$show='School District'; $between=('by'); $list="yes";}
if (substr_count($mypath, "/style.htm")) {$between=('by');}
if (substr_count($mypath, "/rent.htm")) {$between=('for');}
if (substr_count($mypath, "special/University")) {$show="University of Arizona Area";}
if (substr_count($mypath, "/Acres")) {$between=""; $show="with Land"; $list="yes";}
if (substr_count($mypath, "/bankowned.htm")) {$modifier="Bank Owned"; $between=''; $show='by Area';}
if (substr_count($mypath, "/bankowned/")) {$modifier="Bank Owned";}
if (substr_count($mypath, "/shortsale.htm")) {$modifier="Short Sale"; $between=''; $show='by Area';}
if (substr_count($mypath, "/shortsale/")) {$modifier="Short Sale";}
if (substr_count($mypath, "/leasepurchase.htm")) {$modifier="Lease Purchase"; $between=''; $show=' ';}
if (substr_count($mypath, "/leasepurchase/")) {$modifier="Lease Purchase";}
//if (substr_count($mypath, "/golf.htm")) {$between=('by'); $ender=" Community";}
if (substr_count($mypath, "/gated.htm")) {$between=('by'); $ender=" Community";}
if (substr_count($mypath, "/listingtype.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/subdivision.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/community.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/golf.htm")) {$between=('by'); $modifier=('Golf');}
if (substr_count($mypath, "/school.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/construction.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/zoning.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/levels.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/bedrooms.htm")) {$between=('by');}
if (substr_count($mypath, "/bathrooms.htm")) {$between=('by');}
if (substr_count($mypath, "/city.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/area.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/zip.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/builder.htm")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/retirement")) {$show=('Active Adult Communities');}
if (substr_count($mypath, "/golfcity.htm")) {$modifier='Golf Course '; $between=('by');}
if (substr_count($mypath, "/golfcourse.htm")) {$modifier='Golf Course '; $between=('by');}
if (substr_count($mypath, "/golfcommunity.htm")) {$between=('by');}
if (substr_count($mypath, "/horse.htm")) {$between=('by'); $ender=(' Property');}
if (substr_count($mypath, "/combination")) {$between=('by'); $list="yes";}
if (substr_count($mypath, "/income listingtype.htm")) {$show="Income Property Type"; $between=('by'); $list="yes";}
$firstpart="Real Estate";
if (substr_count($mypath, "/values")) {$firstpart=('Best Values');}
if (substr_count($mypath, "/favorite_sites/")) {$firstpart=('Recommended Sites');}
if (substr_count($mypath, "/land")) {$firstpart=('Vacant Land');}
if (substr_count($mypath, "/acres/")) {$firstpart=('Homes with Land');}
if (substr_count($mypath, "/income")) {$firstpart=('Income Properties');}
if (substr_count($mypath, "/commercial")) {$firstpart=('Commercial Properties');}
if (substr_count($mypath, "/Single Family/")) {$firstpart=('Single Family Homes');}
if (substr_count($mypath, "/Single Family (New)/")) {$firstpart=('Single Family (New) Homes');}
if (substr_count($mypath, "/Condominium/")) {$firstpart=('Condominiums');}
if (substr_count($mypath, "/Townhouse/")) {$firstpart=('Towhouses');}
//print ("|$mypath|
");
//$KWD IS THE START OF THE TITLE AND HEADING - IT IS 'TUCSON' or ANOTHER CITY
//$REDUNDANT is KWD but is set to nothing if it's in $SHOW
if (substr_count($mypath, 'armls')) {$kwd='Phoenix'; $propsearch='armls';} else {$kwd='Tucson'; $propsearch='tar';}
//echo $kwd;
//SET THE KWD TO THE OTHER CITY IF THERE IS ONE
//if (substr_count("$mypath", "/acres/")) {$kwd="$show";}
//if (substr_count("$mypath", "/horse/")) {$kwd="$show";}
//if (substr_count("$mypath", "/city/")) {$kwd="$show";}
$redundant=$kwd;
if (substr_count($show, $kwd)) $redundant='';
//print ("|$show| |$kwd| |$redundant| ");
//NOT USING
//SOME FINAL CHEATS FOR CASES WHERE LISTING BY CITY BUT WANT SHOW TO BE SOMETHING ELSE
//if (substr_count($mypath, "/golfcity.htm")) {$show_space=str_replace("City", "Golf", $show_space);}
//if (substr_count($mypath, "/horse.htm")) {$show_space=str_replace("City", "Horse Property", $show_space);}
//include("lastrecip.php");
//print ("$mypath");
//
?>
*/?>
AAArizona - Tucson Real Estate and Tucson Homes for Sale - ".number_format($thiscount)." Listings ");
print ("AAArizona - Tucson Real Estate");
}
//elseif ($mypath=="/maps.htm") {}
elseif ($mypath=="/income property.htm") print ("Tucson Income Property");
elseif (substr_count($mypath, "/homesofthemonth")) print ("Tucson's Best Values");
elseif (substr_count($mypath, "/newlistings")) { print ("Today's New Listings"); }
elseif (substr_count($mypath, "/preload.htm")) { print ("Fetching Photos"); }
elseif (substr_count($mypath, "/data/tar/getdata.asp") or substr_count($mypath, "/data/tar/paged_re_listings.asp")) { print ("Tucson Home Search Results"); }
elseif (substr_count($mypath, "/data/tarlnd/getdata.asp") or substr_count($mypath, "/data/tarlnd/paged_re_listings.asp")) { print ("Tucson Vacant Land Search Results"); }
elseif (substr_count($mypath, "/data/tarinc/getdata.asp") or substr_count($mypath, "/data/tarinc/paged_re_listings.asp")) { print ("Tucson Income Property Search Results"); }
elseif (substr_count($mypath, "/data/tarcom/getdata.asp") or substr_count($mypath, "/data/tarcom/paged_re_listings.asp")) { print ("Tucson Commercial Property Search Results"); }
elseif ($mypath=="/send.htm") print ("We will be in touch with you very soon");
elseif ($mypath=="/favorite_sites/index.php") print ("Favorite Sites");
elseif (substr_count($mypath, "/saved/contact_form.htm")) print ("Welcome!");
elseif (substr_count($mypath, "/data/tar/property_request.asp") or substr_count($mypath, "/data/tarlnd/property_request.asp") or substr_count($mypath, "/data/tarinc/property_request.asp")) {}
elseif ($mypath=="/data/tar/check_fields_tp.asp" or $mypath=="/data/tarlnd/check_fields_tp.asp" or $mypath=="/data/tarinc/check_fields_tp.asp") {}
elseif (substr_count($mypath, "/property/") or substr_count($mypath, "/homes/")) {print("$show");}
elseif (substr_count($mypath, "/saproperty.asp")) {} //don't show title and let the one on the page show
elseif (substr_count($mypath, "/favorite_sites/")) print ("Recommended Sites in $show ");
elseif (substr_count($mypath, "/search/")) print ("Search Results - $s");
elseif ($mypath=="/favorite_sites/add_link.htm") print ("Submit Your Site");
elseif ($mypath=="/favorite_sites/modify.htm") print ("Modify Your Site");
elseif ($mypath=="/horse.htm") print ("Tucson Horse Property");
elseif ($mypath=="/golf.htm") print ("Golf Property in Tucson");
elseif ($mypath=="/land.htm") {print ('Tucson Vacant Land - Lots');}
elseif ($mypath=="/commercial property.htm") {print ('Tucson Commercial Property');}
elseif ($mypath=="/data/tar/sasearch.asp") {print ('Create Your own Tucson Home Search');}
elseif ($mypath=="/linkwithus.htm") {print ('Link with Us!');}
elseif ($mypath=="/data/tarlnd/sasearch.asp") {print ('Create Your own Tucson Vacant Land Search');}
elseif ($mypath=="/data/tarinc/sasearch.asp") {print ('Create Your own Tucson Income Property Search');}
elseif ($mypath=="/data/tarcom/sasearch.asp") {print ('Create Your own Tucson Commercial Property Search');}
elseif ($mypath=="/data/tarrnt/sasearch.asp") {print ('Create Your own Tucson Rental Home Search');}
//elseif ($show) print("$kwd $modifier $firstpart $between $middler $show $ender");
elseif ($show) {
//put this one after the title so it's in metas only
//if (substr_count($mypath, "/subdivision/")) {$show.=(" Subdivision");}
//if (substr_count($mypath, "/community/")) {$show.=(" Community");}
//if (substr_count($mypath, "/district/")) {$show.=(" School District");}
//if (substr_count($mypath, "/elementary/")) {$show.=(" Elementary School");}
//if (substr_count($mypath, "/middle/")) {$show.=(" Middle School");}
//if (substr_count($mypath, "/high/")) {$show.=(" High School");}
//if (substr_count($mypath, "/area/") and $show<>'University of Arizona') {$show.=(" Area");}
//if (substr_count($mypath, "/zoning/")) { $show=str_replace("-", "with", $show)." Zoning"; }
//if (substr_count($mypath, "/builder/")) {$between='by'; $ender='Home Builder';}
//if ($list=="yes"){
//complete title
$thistitle=("$kwd $modifier $firstpart $between $middler $show $ender");
//minimal title may index better
//$thistitle=("$show $kwd");
//print "$thistitle
");
if ($ajax){
include("search_notification.htm");
}
if ($keyword or ($whereclause and $whereclause != " order by price")) { //only show homes if whereclause
if ($filename or ($host_name and $site_name and $host_name=="$site_name")){
include("navigation_greeting.asp");
}
include("navigation_data.asp");
print "";
//NEWLISTINGS AS A SAVED SEARCH
if ($keyword=="newlistings") {
$whereclause="newlistings";
}
if (substr_count($whereclause, "having ")) {
$show_this = str_replace("having address=" , "" , $whereclause);
$show_this = str_replace("'" , "" , $show_this);
}
if ($filename){
//print "";
print ("\n");
}elseif ($num_rows and $host_name and $site_name and $host_name=="$site_name"){
include("saved/banner.htm");
//print "";
}
}else{
if (!$ajax){
print "
";
}
} //end if whereclause
//End of Table & Statistical/Navigational Stuff
print ("
");
if ($keyword or ($whereclause and $whereclause != " order by price")) { //only show homes if whereclause
//IF RECORDS MATCH, GO TO START RECORD & PRINT
//ELSE SHOW ERRROR MESSAGES
$a=0; //finds start record
$b=0; //limits records printed to 20
while ($Row=mysqli_fetch_array ($data) and $b<40) {
$a++;
//use these vars to query for sold homes in same price range
$high_price="$Row[price]";
if (!$low_price) {$low_price="$Row[price]";}
$mlsno="$Row[mlsno]";
if ($a>=$start_record) {
//get vars to feed to map past page 1
if (substr_count($whereclause, "zip =")) {$zip=("$Row[zip]");}
if (substr_count($whereclause, "area =")) {$area=("$Row[area]");}
$address_string="/homes/$Row[mlsno] $Row[addrnum] $Row[nsew] $Row[addrname] $Row[street_suffix] $Row[unit] $Row[mun] $Row[state] $Row[zip]";
$address_string=trim($address_string);
$address_string=str_replace(" ", "%20", $address_string);
$address_string=str_replace("%20%20", "%20", $address_string);
$address_string=str_replace("%20%20", "%20", $address_string);
$address_string=str_replace("%20%20", "%20", $address_string);
$address_string=str_replace("%20%20", "%20", $address_string);
$newurl="$Row[url]";
//$newurl=str_replace(".jpg", "-o.jpg", $newurl);
$newurl=str_replace("photos", "resize", $newurl);
$newurl=str_replace("tar", "tar/65x42/true", $newurl);
if (!$newurl) {
$newurl='/p_nophoto.jpg';
}
//$bigger_url=str_replace('.jpg', '-o.jpg', $url);
$bigger_url=$url;
if (!$bigger_url) {$bigger_url="/p_nophoto.jpg";}
if ($filename or $site_name=='tucsonproperties.net') {
print ("
");
}
if ($filename or ($site_name and $site_name==$host_name)) {
print ("
");
$b++;
}
}
}else{
//no Criteria message was here
}
if ($filename or $site_name==$host_name) {
if ($whereclause and $whereclause != " order by price") { //only show homes if whereclause
include("/sites/default/data/tar/maps.htm");
}
}
//include navigation section?>
\n");
//print "";
}elseif ($num_rows and $site_name and $site_name==$host_name){
include("saved/banner.htm");
//print "";
}
if ($filename or ($host_name and $site_name and $host_name=="$site_name")){
//include("navigation_greeting.asp");
}
include("navigation_data.asp");
} //end if whereclause
?>
Brought to you by: relocationUSA $myphone";
//print "";
include "/sites/relocationusa_tp/footer_phone_number_display.htm";
//if ($mypath=='/' or $mypath=='index.htm') {
if ("THIS"=="THAT" and !substr_count($articlepath, "blog") and !substr_count($mypath, "sasearch.asp") and !substr_count($mypath, "getdata.asp") and !substr_count($mypath, "paged_re_listings.asp") ) { //load rest of header file
// href="http://www.tucsonproperties.net"
?>
");
//print ("
indentifies properties listed by real estate brokers other than Bob Reichard's Realty Center