"; $ip= $REMOTE_ADDR; $existing_url="http://". $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; //print "$existing_url

"; $www_count=substr_count($existing_url, "http://www."); //print "$www_count

"; 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 "header_variables.htm"; include "/sites/relocationusa_tp/spam_lead_checks.htm"; $thisbrokerage='relocationUSA'; $theirip=$_SERVER['REMOTE_ADDR']; $myphone='(602)562-8416'; $mydir="armls"; $site_name=('phoenixrealestate-homes.com'); $partner='barb'; $lastrecip='lastrecip_phx'; $recip_page='recip_page_phx'; $entry_date='entry_date_phx'; //$table='partners'; $thispath=$_SERVER["REQUEST_URI"]; //$thispath=str_replace("%20", " ", $thispath); $htmcount=substr_count($thispath, ".htm"); $homescount=substr_count($thispath, "/homes/"); $spacecount=substr_count($thispath, "%20"); //print "

$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

"); $rev=strrev($mypath); //print ("$rev

"); $pos=strpos($rev, "/"); //print ("$pos

"); $show=substr($rev, 0, $pos); //print ("$show

"); $show=strrev($show); //print ("$show

"); $show=substr($show, 0, strlen($show)-4 ); //print ("$show

"); $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"; } ?>

802 E State Ave

Features:

  • Breakfast Bar, Dining in LR/GR, Eat-in Kitchen Dining Area
  • Double Sinks, Full Bth Master Bdrm, Separate Shwr & Tub
  • Covered Patio(s), Patio
  • Master Bedroom Walk-in Closet, Separate Bedroom Exit
  • Gas Hot Wtr - Tnklss, Tankless Ht Wtr Heat
  • Dual Pane, Low-E, Vinyl Frame Windows
  • Tile Floors
  • Great Room
  • Block, Frame - Wood Construction
  • Comp Shingle Roof
  • Dryer Included, Inside, Washer Included
  • No Interior Steps
  • Cable TV Avail, High Speed Internet Available, Ntwrk Wrng Multi Rms
  • Ranch Style
  • City Services
  • Ceiling Fan(s), Programmable Thmstat, Refrigeration Cooling
  • Block Fence
  • Desert Back, Grass Front, Gravel/Stone Back, Synthetic Grass Back Landscaping
  • Alley, Mountain View(s), North/South Exposure
  • Natural Gas

Remarks:

Gorgeous and fully rebuilt contemporary-style home. In 2017, only the exterior walls remained while the whole home was redesigned, extended and made anew. From the plumbing to the electrical, from the walls to the roof, it's all updated with energy efficiency and sleek designs. With a HERS rating of 59, this air tight home provides long term cost savings for electricity, gas and water. You'll fall in love with the open floor plan, the mountain views that peek through the high windows and the North Central location with its close proximity to Piestewa Peak, Madison Simis Elemetary School, Creative Bridges Coop Preschool, as well as an expansive variety of shopping and fine dining. Two covered patios in the backyard and a front porch provide space to relax and unwind.

Directions:

North on seventh street from glendale to state avenue; east on state avenue to property on the left hand side of the street.

      

802 E State Ave

Bedrooms   3
Baths 2
Year Built 1952
Square Feet2060
Lot Size8102 Sqft
Levels 1
Tax$3379
Listing StatusActive
Listed ByRE/MAX Professionals
Listing Price$680,000
MLS Number6610503
 
Schools:

 
 
Bedrooms   3
Baths 2
Year Built 1952
Square Feet2060
Lot Size8102 Sqft
Levels 1
Tax$3379
Listing StatusActive
Listed ByRE/MAX Professionals
Listing Price$680,000
MLS Number6610503
 
Schools:

 
 

Features:

  • Breakfast Bar, Dining in LR/GR, Eat-in Kitchen Dining Area
  • Double Sinks, Full Bth Master Bdrm, Separate Shwr & Tub
  • Covered Patio(s), Patio
  • Master Bedroom Walk-in Closet, Separate Bedroom Exit
  • Gas Hot Wtr - Tnklss, Tankless Ht Wtr Heat
  • Dual Pane, Low-E, Vinyl Frame Windows
  • Tile Floors
  • Great Room
  • Block, Frame - Wood Construction
  • Comp Shingle Roof
  • Dryer Included, Inside, Washer Included
  • No Interior Steps
  • Cable TV Avail, High Speed Internet Available, Ntwrk Wrng Multi Rms
  • Ranch Style
  • City Services
  • Ceiling Fan(s), Programmable Thmstat, Refrigeration Cooling
  • Block Fence
  • Desert Back, Grass Front, Gravel/Stone Back, Synthetic Grass Back Landscaping
  • Alley, Mountain View(s), North/South Exposure
  • Natural Gas

Remarks:

Gorgeous and fully rebuilt contemporary-style home. In 2017, only the exterior walls remained while the whole home was redesigned, extended and made anew. From the plumbing to the electrical, from the walls to the roof, it's all updated with energy efficiency and sleek designs. With a HERS rating of 59, this air tight home provides long term cost savings for electricity, gas and water. You'll fall in love with the open floor plan, the mountain views that peek through the high windows and the North Central location with its close proximity to Piestewa Peak, Madison Simis Elemetary School, Creative Bridges Coop Preschool, as well as an expansive variety of shopping and fine dining. Two covered patios in the backyard and a front porch provide space to relax and unwind.

Directions:

North on seventh street from glendale to state avenue; east on state avenue to property on the left hand side of the street.

Additional Photos:
        
 
           

All information should be verified by the recipient and none is guaranteed accurate by ARMLS.
Property data is copyright 2023 Arizona Regional MLS. All Rights Reserved.

Brought to you by: relocationUSA
$myphone"; //print "

"; include "/sites/relocationusa_tp/footer_phone_number_display.htm"; ?>