$spacecount";
if ($spacecount>=5 and $htmcount and $homescount) {
//print "Homes Page";
$homespage='yes';
//set header ok after www. url redirect
if ($www_count==1){
//header("HTTP/1.1 200 OK");
}
}
//print "$thispath
";
if (!substr_count($thispath, "/blog/") and !substr_count($thispath, "enter_commitment.htm") and !substr_count($thispath, ".js") ) { //load rest of header file
//print "$thispath";
//print ("--$whichsection--");
//print_r($_COOKIE);
$key=date("F j, Y");
//$key=date('l jS \of F Y \h\i\h\o');
$mypath=str_replace("%20", " ", $thispath);
$today=date("Y-m-d H:i:s");
//print ("$mypath
");
$underscorepos=strpos($show, "_");
if ($underscorepos) {
$pagenum=substr($show, $underscorepos+1);
//print $pagenum;
$show=substr($show, 0, $underscorepos);
}
//if ($mlsno and $show!="saproperty") header("location:/data/armls/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, "/Apartment Style/")) {$modifier=("Apartment Style ");}
if (substr_count($mypath, "/Single Family/")) {$modifier=("Single Family ");}
if (substr_count($mypath, "/Single Family (New)/")) {$modifier=("Single Family (New) ");}
if (substr_count($mypath, "/Townhouse/")) {$modifier=("Townhouse ");}
if (substr_count($mypath, "/Townhouse (New)/")) {$modifier=("Townhouse (New) ");}
if (substr_count($mypath, "/Patio Home/")) {$modifier=("Patio Home ");}
if (substr_count($mypath, "/Loft Style/")) {$modifier=("Loft Style ");}
if (substr_count($mypath, "/Gemini Twin/")) {$modifier=("Gemini Twin ");}
if (substr_count($mypath, "/Modular Home/")) {$modifier=("Modular Home ");}
if (substr_count($mypath, "/bankowned.htm")) {$modifier="Bank Owned"; $between=''; $show='by City';}
if (substr_count($mypath, "/bankowned/")) {$modifier="Bank Owned";}
if (substr_count($mypath, "/shortsale.htm")) {$modifier="Short Sale"; $between=''; $show='by City';}
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, "/district/")) {$middler=("District");}
if (substr_count($mypath, "/area/")) {$middler=("Area");}
//if (substr_count($mypath, "/acres/")) {$ender=(" on 1 or more Acres of Land");}
if (substr_count($mypath, "/homes/")) $show=substr($show, 7, 100);
if (substr_count($mypath, "/property/")) $show=substr($show, 7, 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=('Junior High School '); $between=('by'); $list="yes";}
if (substr_count($mypath, "/elementary.htm")) {$show=('Elementary School '); $between=('by'); $list="yes";}
if (substr_count($mypath, "/districthigh.htm")) {$show='High School District'; $between=('by'); $list="yes";}
if (substr_count($mypath, "/districtelem.htm")) {$show='Elementary 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, "/University of Arizona")) {$between=('near');}
if (substr_count($mypath, "/Acres")) {$between=""; $show="with Land"; $list="yes";}
//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.htm")) {$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, "/favorite_sites/")) {$firstpart=('Recommended Sites');}
elseif (substr_count($mypath, "/saved/contact_form.htm")) print ("
Welcome!");
if (substr_count($mypath, "/land")) {$firstpart=('Vacant Land');}
if (substr_count($mypath, "/acres/")) {$firstpart=('Homes with Land');}
if (substr_count($mypath, "/income")) {$firstpart=('Income Property');}
if (substr_count($mypath, "/commercial")) {$firstpart=('Commercial Property');}
//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
$kwd='Phoenix';
//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| ");
//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");
//include("top_content.php");
?>
?>
Phoenix Real Estate and Phoenix Homes for Sale - ". number_format($thiscount)." Listings");
}elseif ($mypath=="/income property.htm") print ("Phoenix Income Property");
elseif (substr_count($mypath, "/newlistings")) print ("Today's New Listings");
elseif (substr_count($mypath, "/acres.htm")) print ("Phoenix Homes on 1 or more Acres");
//print ("$mypath");
elseif (substr_count($mypath, "/data/armls/getdata.asp") or substr_count($mypath, "/data/armls/paged_re_listings.asp")) {
print ("Phoenix Home Search Results");
}elseif ($mypath=="/data/armlsinc/getdata.asp" or $mypath=="/data/armlsinc/paged_re_listings.asp") {
print ("Phoenix Income Property Search Results");
}elseif ($mypath=="/data/armlslnd/getdata.asp" or $mypath=="/data/armlslnd/paged_re_listings.asp") {
print ("Phoenix Vacant Land Search Results");
}
elseif ($mypath=="/favorite_sites/index.php") print ("Recommended Sites");
//elseif ($mypath=="/data/armls/property_request.asp" or $mypath=="/data_tar/check_fields.asp" ) {}
elseif (substr_count($mypath, "check_fields_tp.asp") or substr_count($mypath, "/property_request.asp")) {} //don't show title and let the one on the page show
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 ("Phoenix Horse Property by City");
elseif ($mypath=="/golf.htm") print ("Golf Property in Phoenix");
elseif ($mypath=="/land.htm") {print ('Phoenix Vacant Land - Lots');}
elseif ($mypath=="/commercial property.htm") {print ('Phoenix Commercial Property');}
elseif ($mypath=="/data/armls/sasearch.asp") {print ('Create Your own Phoenix Home Search');}
elseif ($mypath=="/data/armlslnd/sasearch.asp") {print ('Create Your own Phoenix Vacant Land Search');}
elseif ($mypath=="/data/armlsinc/sasearch.asp") {print ('Create Your own Phoenix Income Property Search');}
elseif ($mypath=="/data/armlscom/sasearch.asp") {print ('Create Your own Phoenix Commercial Property Search');}
elseif ($mypath=="/data/armlsrnt/sasearch.asp") {print ('Create Your own Phoenix Rental Home Search');}
//elseif ($show) print("Phoenix $modifier $firstpart $between $middler $show $ender");
elseif ($show) {
//if ($list=="yes"){
$citypos=strpos($mypath, " Subdivisions");
if ($citypos) $citytitle=substr($mypath, 0, $citypos);
$bldrpos=strpos($mypath, " Homes By Builder");
if ($bldrpos) $citytitle=substr($mypath, 0, $bldrpos);
$citytitle=str_replace("/", "", $citytitle);
if (!$citytitle) $citytitle="Phoenix";
//print "$citytitle";
//put this one after the title so it's in metas only
if (substr_count($mypath, "school/district/high/")) {$show.=(" High School District");}
if (substr_count($mypath, "school/district/elementary/")) {$show.=(" Elementary School District");}
if (substr_count($mypath, "school/elementary/")) {$show.=(" Elementary School");}
if (substr_count($mypath, "school/middle/")) {$show.=(" Middle School");}
if (substr_count($mypath, "school/high/")) {$show.=(" High School");}
//if (substr_count($mypath, " Subdivisions/")) {$show.=(" Subdivision");}
//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, "Homes By Builder/")) {$between='by'; $ender='Home Builders';}
//complete title
$thistitle=("$citytitle $modifier $firstpart $between $middler $show $ender");
//minimal title might index better
//$thistitle=("$show $citytitle");
//if ($pagenum) $thistitle.=" - Page $pagenum";
//}
//else $thistitle=("$middler $show $ender Phoenix $modifier $firstpart");
$thistitle=str_replace(" ", " ", $thistitle);
$thistitle=str_replace(" ", " ", $thistitle);
$thistitle=str_replace(" ", " ", $thistitle);
$thistitle=str_replace(" ", " ", $thistitle);
$thistitle=trim($thistitle);
$thistitle="".$thistitle."";
print ("$thistitle");
}
//if ($show=="City") $show="Horse";
$show_space="$show $modifier";
if ($redundant) $redundant.=' ';
//print $show_space;
if ($pagenum) $pagenum="page $pagenum";
if ($mypath=="/index.htm" or $mypath=='/') {
$longdate=(date("F j"));
$desc="Phoenix Real Estate and Phoenix Homes for Sale. Listings Updated Daily.";
}else{
$desc=("$redundant $mlsno $show_space $pagenum $start_record real estate and $show_space $mlsno $redundant $pagenum $start_record homes from our $redundant $mlsno $show_space Real Estate Office in $kwd Arizona.");
}
$desc=str_replace(" ", " ", $desc);
$desc=str_replace(" ", " ", $desc);
$desc=str_replace(" ", " ", $desc);
$desc=str_replace(" ,", ",", $desc);
$desc=trim($desc, ",");
$desc=trim($desc);
$keywords=("$show_space, $redundant, $mlsno, real estate, Arizona, property, homes for sale");
if ($pagenum) $keywords.=", $pagenum";
$keywords=str_replace(" ", " ", $keywords);
$keywords=str_replace(" ", " ", $keywords);
$keywords=str_replace(" ", " ", $keywords);
$keywords=str_replace(" ,", ",", $keywords);
$keywords=str_replace(",,", ",", $keywords);
$keywords=trim($keywords, ",");
$keywords=trim($keywords);
//include("middle_content.php");
?>
">
">
*/?>
*/?>
*/?>
*/?>
*/?>
";
//setcookie('scrollpos', "0", time()+60*60*24*365, '/', false);
}elseif (substr_count($mypath, "/sasearch.asp") or substr_count($mypath, "/getdata.asp")){
//print "";
//ONLY RUN SEARCHSCROLL IF SEARCH PAGES ARE THE REFERER
print "";
}elseif (substr_count($thispath, "/no_homes/")){
//dont print body - put in individual property pages or thankyou page
}else{
//print "";
print "";
}
if (!substr_count($thispath, "/no_homes/")){
include "/sites/relocationusa_tp/header_footer_links.htm";
}
?>
";
}
//print "$theirip
";
//ignore pest client user
if ($theirip!='45.155.204.82') {
//include("/sites/default/data/getheader.php");
if ($filename){ //IF PAGE PREGENERATED
print ("\n");
}
//print("$whereclause
");
//print("$num_args");
//decode whereclause
//$whereclause=urldecode($whereclause);
$whereclause = str_replace("\\" , "" , $whereclause);
$url_subdivision=(urlencode($subdivision));
//print ("$url_subdivision");
//SET START RECORD BASED ON PAGING MOVE
$count=0;
if (!$start_record) {$start_record=1;}
if ($paging_move=="previous") {$start_record = $start_record - 40;}
elseif ($paging_move=="next") {$start_record = $start_record + 40;}
if ($start_record<1) {$start_record=1;}
//print("$whereclause");
$thisday= (date("d")-1); $thismonth=date("m"); $thisyear=date("y");
$thishour= date("H"); $thisminute=date("i"); $thissecond=date("s");
$yesterday=date("Y-m-d H:i:s", mktime($thishour, $thisminute, $thissecond, $thismonth, $thisday, $thisyear));
//SET UP TABLE QUERY FOR MATCHING RECORDS
$host="localhost";
$user="getdata";
$password="getdata";
$dbname="armls";
$tablename="armls_homes";
$link=mysqli_connect ($host, $user, $password, $dbname);
if ($keyword=='newlistings') {
if ($city) $thiscity="and city='$city'";
$today=date("Ymd");
$query="select cross_streets, latitude, longitude, url, propsubtype, subdivision, mls_number, sqft, sellertype, mlsno, bedrooms, baths, street_suffix, zip, city, price, addrnum, unit, state, addrname, nsew from armls_homes left join armls_images on (armls_homes.mlsno=armls_images.mls_no and armls_images.photonum='1') left join newlistings on mlsno=mls_number where listing_date>='$yesterday' and listing_count='1' $thiscity order by price, internal_listing_id";
}else{
$query="select concat_ws(' ', NULLIF(addrnum, ''), NULLIF(nsew, ''), NULLIF(addrname, ''), NULLIF(street_suffix, ''), NULLIF(unit, ''), NULLIF(city, ''), NULLIF(state, '')) as address, cross_streets, sellertype, sqft, latitude, longitude, url, propsubtype, subdivision, mlsno, bedrooms, baths, street_suffix, zip, city, price, addrnum, unit, addrname, nsew, state from armls_homes left join armls_images on (armls_homes.mlsno=armls_images.mls_no and armls_images.photonum='1')".$whereclause;}
//echo ("$query");
$data=mysqli_query ($link, $query);
$num_rows = mysqli_num_rows($data);
//print $num_rows;
if (substr_count($mypath, "/sasearch.asp") or substr_count($mypath, "/getdata.asp") or substr_count($mypath, "/paged_re_listings.asp")){
$thiswidth="width=975";
}
//CREATE TABLE AND PRINT NAVIGATIONAL & STATISTICAL STUFF
print "
";
print ("
\n");
if ($keyword or ($whereclause and $whereclause!=" order by price")) { //only show if whereclause
//include navigation section
include("navigation_greeting.asp");
include("navigation_data.asp");
print "";
if ($filename){
print ("\n");
//print "";
}elseif ($num_rows){
include("saved/banner.htm");
//print "";
}
//End of Table & Statistical/Navigational Stuff
print ("
");
} //end if whereclause
if ($keyword or ($whereclause and $whereclause!=" order by price")) { //only show if whereclause
//print "--------$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++;
if ($a>=$start_record) {
$address_string="/homes/$Row[mlsno] $Row[addrnum] $Row[nsew] $Row[addrname] $Row[street_suffix] $Row[unit] $Row[city] Arizona $Row[zip]";
$address_string=trim($address_string);
$address_string=str_replace(" 0 ", " ", $address_string);
$address_string=str_replace(" ", " ", $address_string);
$address_string=str_replace(" ", " ", $address_string);
$address_string=str_replace(" ", " ", $address_string);
$address_string=str_replace(" ", " ", $address_string);
$address_string=str_replace(" ", "%20", $address_string);
$newurl="$Row[url]";
//$newurl=str_replace(".jpg", "-o.jpg", $newurl);
$newurl=str_replace("photos", "resize", $newurl);
$newurl=str_replace("az", "az/65x42/true", $newurl);
$rest = substr("$Row[mlsno]", -2);
//$url=str_replace("-o", "", $Row[url]);
$url="$Row[url]";
if (substr_count($mypath, "/sasearch.asp") or substr_count($mypath, "/getdata.asp")) {
$thissrc='this-src';
}else{
$thissrc='src';
}
if (!$newurl) $newurl='/p_nophoto.jpg';
print ("
";
print("\$");
print number_format("$Row[price]"); //print(" ");
$propsubtype_link = "/$Row[propsubtype]/$Row[city].htm";
$propsubtype_link = str_replace(" ", "%20", $propsubtype_link);
$hm='';
if ("$Row[propsubtype]"=='Single Family' or "$Row[propsubtype]"=='Single Family (New)' or "$Row[propsubtype]"=='Gemini Twin' or "$Row[propsubtype]"=='Loft Style' or "$Row[propsubtype]"=='Apartment Style') $hm='Homes ';
$plural_propsubtype = str_replace("Home", "Homes", "$Row[propsubtype]");
$plural_propsubtype = str_replace("house", "houses", $plural_propsubtype);
if (substr_count($plural_propsubtype, "houses")) {
$link_text="$Row[city] $plural_propsubtype";
}else{
$link_text="$plural_propsubtype $hm$Row[city]";
}
print ("
$Row[propsubtype]");
print("
");
if ("$Row[sqft]") {print (number_format("$Row[sqft]")." Sqft");}
if (($minlotsqft or $maxlotsqft) and $Row[lotsqft]){
if ($Row[lotsqft]>=43560) {
$page_acres=floor($Row[lotsqft]/43560);
//$page_acres=($Row[lotsqft]/43560);
if ($page_acres=='1') $plural="Acre"; elseif ($page_acres>1) $plural="Acres";
print("
Please Try Again";
}
if ($keyword or ($whereclause and $whereclause!=" order by price")) { //only show if whereclause
include("maps.htm");
//include navigation section?>
\n");
//print "";
}elseif ($num_rows){
include("saved/banner.htm");
//print "";
}
//include navigation section
//include("navigation_greeting.asp");
include("navigation_data.asp");
}//end if whereclause
}// end if pest user
?>
Brought to you by: relocationUSA $myphone";
//print "
";
include "/sites/relocationusa_tp/footer_phone_number_display.htm";
?>
";}
//if ($newonmarket) print "