");
$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/fmls/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_county/")) {$modifier=("Horse ");}
if (substr_count($mypath, "/horse_city/")) {$modifier=("Horse ");}
if (substr_count($mypath, "/county/")) {$ender=(" County");}
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/")) {
//if ($show[0]=='3'){
//$show=substr($show, 5, 100);
//}elseif ($show[0]=='1' or $show[0]=='9'){
$show=substr($show, 8, 100);
//}
}
if (substr_count($mypath, "/property/")) $show=substr($show, 7, 100);
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, "/county.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, "/primary.htm")) {$ender=' School'; $between=('by'); $list="yes";}
if (substr_count($mypath, "/intermediate.htm")) {$ender=' School'; $between=('by'); $list="yes";}
if (substr_count($mypath, "/senior.htm")) {$ender=' School'; $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 Georgia")) {$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_city.htm")) {$between=('by'); $ender=(' Property');}
//if (substr_count($mypath, "/horse_county.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');}
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='Atlanta';
//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");
//print ("$mypath");
?>
Atlanta Real Estate and Atlanta Properties - ".number_format($thiscount)." Listings");
}
elseif ($mypath=="/income property.htm") print ("Atlanta Income Property");
elseif (substr_count($mypath, "/newlistings")) print ("Today's New Listings");
elseif (substr_count($mypath, "/acres.htm")) print ("Atlanta Homes on 1 or more Acres");
elseif (substr_count($mypath, "/feedback.htm")) print ("We Value Your Feedback");
elseif (substr_count($mypath, "/followup.htm")) print ("Client Follow-Up");
elseif (substr_count($mypath, "/data/fmls/getdata.asp") or substr_count($mypath, "/data/fmls/paged_re_listings.asp")) {
print ("Atlanta Area Home Search Results");
}elseif ($mypath=="/data/armlsinc/getdata.asp" or $mypath=="/data/armlsinc/paged_re_listings.asp") {
print ("Atlanta Income Property Search Results");
}elseif ($mypath=="/data/armlslnd/getdata.asp" or $mypath=="/data/armlslnd/paged_re_listings.asp") {
print ("Atlanta Vacant Land Search Results");
}
elseif ($mypath=="/favorite_sites/index.php") print ("Recommended Sites");
//elseif ($mypath=="/data/fmls/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, "/saved/contact_form.htm")) print ("Welcome!");
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_city.htm") print ("Atlanta Horse Property by City");
elseif ($mypath=="/horse_county.htm") print ("Atlanta Horse Property by County");
//elseif ($mypath=="/golf.htm") print ("Golf Property in Atlanta");
elseif ($mypath=="/land.htm") {print ('Atlanta Vacant Land - Lots');}
elseif ($mypath=="/commercial property.htm") {print ('Atlanta Commercial Property');}
elseif ($mypath=="/data/fmls/sasearch.asp") {print ('Create Your own Atlanta Area Home Search');}
elseif ($mypath=="/data/armlslnd/sasearch.asp") {print ('Create Your own Atlanta Vacant Land Search');}
elseif ($mypath=="/data/armlsinc/sasearch.asp") {print ('Create Your own Atlanta Income Property Search');}
elseif ($mypath=="/data/armlscom/sasearch.asp") {print ('Create Your own Atlanta Commercial Property Search');}
elseif ($mypath=="/data/armlsrnt/sasearch.asp") {print ('Create Your own Atlanta Rental Home Search');}
//elseif ($show) print("Atlanta $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="Atlanta";
//print "$citytitle";
//put this one after the title so it's in metas only
if (substr_count($mypath, "school/district/")) {$show.=(" 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 Georgia') {$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';}
$thistitle=("$citytitle $modifier $firstpart $between $middler $show $ender");
//if ($pagenum) $thistitle.=" - Page $pagenum";
//}
//else $thistitle=("$middler $show $ender Atlanta $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;
//maybe too long - shortened below
//$desc=("$redundant $show_space Real Estate, $redundant $show_space homes, and $show_space $redundant properties from our $redundant $show_space Real Esatate Office in $kwd Georgia. For $kwd Georgia $show $modifier Real Estate and $redundant $show_space home information, visit our $redundant Georgia $show_space Real Esate Web Site at atlantarealestate-homes.com");
//don't seem to use - $desc=("$redundant $show_space Real Estate, $redundant $show_space homes, and $show_space $redundant properties from our $redundant $show_space Real Esatate Office in $kwd Georgia.");
//$desc=str_replace(' '.' ',' ', $desc);
//print $desc;
if ($pagenum) $pagenum="page $pagenum";
if ($mypath=="/index.htm" or $mypath=='/') {
$longdate=(date("F j"));
$desc="Continuously Updated Atlanta Real Estate Information.";
}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 Georgia.");
}
$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, Georgia, 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);
?>
">
">
*/?>
";
//setcookie('scrollpos', "0", false, '/', false);
}elseif (substr_count($mypath, "/sasearch.asp") or substr_count($mypath, "/getdata.asp")){
?>
";
//ONLY RUN SEARCHSCROLL IF SEARCH PAGES ARE THE REFERER
print "";
//}elseif (substr_count($mypath, "/homes/")){
//print "";
}else{
//print "";
print "";
}
//print "
*/
include "/sites/relocationusa_tp/header_footer_links.htm";
?>
*/?>
";
$result= mysqli_query($link, $query);
$num_rows = mysqli_num_rows($result);
//print $num_rows;
if ($num_rows) {
while ($Row=mysqli_fetch_array ($result)) {
if ($showing){
print("
Schedule a Showing - ");
}else{
print("<title>Request More Information - ");
}
$thiscity=$Row[city];
$showaddress="$Row[addrnum] $Row[nsew] $Row[addrname] $Row[street_suffix] $Row[streetdirsuffix]";
if ($Row[addrnum]!=0){print ("$Row[addrnum] ");}
print("$Row[nsew] $Row[addrname] ");
if ($Row[Street_Suffix]){print ("$Row[Street_Suffix] ");}
//if ($Row[streetdirsuffix]){print ("$Row[streetdirsuffix]");}
if ($Row[Unit]) {print (" #$Row[Unit] ");}
print("$Row[mun] $Row[State] $Row[zip]");
if ($showing){print("
I would like to see ");
}else{
print("
I would like more information about ");
}
if ("$Row[addrnum]"!=0) $thisaddress=$thisaddress."$Row[addrnum] ";
$thisaddress=$thisaddress."$Row[nsew] $Row[addrname] ";
if ("$Row[Street_Suffix]"){$thisaddress="$thisaddress"."$Row[Street_Suffix] ";}
if ("$Row[streetdirsuffix]"){$thisaddress.="$Row[streetdirsuffix]";}
if ("$Row[Unit]") {$thisaddress="$thisaddress"." #$Row[Unit] ";}
if ("$thiscity") $this_long_address="$thisaddress in $thiscity
";
print ("$this_long_address
");
$url="$Row[url]";
//$url=str_replace(".jpg", "-o.jpg", $url);
//$url=str_replace("photos", "resize", $url);
//$url=str_replace("az", "az/65x42/true", $url);
if ("$Row[url]")
{
print ("");}
else
{print ("");}
$rest = substr("$Row[mlsno]", -2);
$picfile=("/sites/default/data/tar/pics/$Row[mlsno].jpg");
$price="$Row[price]";
} // close while loop
mysqli_close ($link);
}else{
print("Request More Information");
print ("I would like information about finding a home in Arizona.");
} //end if
$send_file='check_fields_tp.asp';
print ("
*/
if (!substr_count($thispath, "/blog/") and !substr_count($thispath, "enter_commitment.htm") and !substr_count($thispath, ".js") and !substr_count($thispath, "getimages")) { //load rest of header file
?>
");}
$rest = substr("$Row[mlsno]", -2);
$picfile=("/sites/default/data/tar/pics/$Row[mlsno].jpg");
$price="$Row[price]";
} // close while loop
mysqli_close ($link);
}else{
print("
indentifies properties listed by real estate brokers other than Realty Center of Arizona