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

1208 W Desert Spoon Dr

Features:

  • Breakfast Bar, Dining in LR/GR Dining Area
  • 2 Master Baths, 3/4 Bath Master Bdrm, Double Sinks, Full Bth Master Bdrm, Private Toilet Room, Separate Shwr & Tub
  • Covered Patio(s), Gazebo/Ramada, Patio, Private Street(s)
  • 2 Master Bedrooms, Master Bedroom Walk-in Closet, Other Bedroom Split, Other Bedroom Walk-in Closet
  • Master Bedroom Not Split, Split
  • Gas Hot Wtr - Tnklss
  • Dual Pane Windows
  • Carpet, Tile Floors
  • Great Room
  • Frame - Wood Construction
  • Tile Roof
  • Above Ground, Heated
  • Dryer Included, Inside, Washer Included, Wshr/Dry HookUp Only
  • 9+ Flat Ceilings, Drink Wtr Filter Sys, No Interior Steps, Soft Water Loop, Water Softener Owned
  • Cable TV Avail, High Speed Internet Available
  • Dir Entry frm Garage, Electric Door Opener
  • Ranch Style
  • City Services
  • Ceiling Fan(s), Refrigeration Cooling
  • Block Fence
  • Auto Timer H2O Back, Auto Timer H2O Front, Desert Front, Gravel/Stone Back, Synthetic Grass Back Landscaping
  • Corner Lot, North/South Exposure
  • Biking/Walking Path, Clubhouse/Rec Room, Comm Tennis Court(s), Community Media Room, Community Pool, Community Pool Htd, Community Spa, Community Spa Htd, Gated Community, Pickleball Court(s)
  • Natural Gas

Remarks:

ASSUMABLE 3% VA LOAN!! LOWEST PRICE PER SQUARE FOOT IN OVATION AT $250 PER SQ. FT!! Better than new spacious move-in ready 2032 sq. ft home with 2 ensuite bedrooms w/walk-in closets, a den, and 2.5 baths, 2 car garage w/garage floor coating on highly desirable corner N/S lot!! $10K just spent on new ''Hollywood hedge'' trees for added privacy while you enjoy low maintenance backyard with a covered patio, pavers, artificial turf, spa and new pergola. This home is highly upgraded with wood-look tile throughout, carpet in the bedrooms, plantation shutters, security screen door, gourmet kitchen with quartz, cabinet pull outs, R/O, water softener, farmhouse sink, gas cooktop, SS appliances, backsplash, and a large island w/breakfast bar. Refrigerator, washer/dryer, spa are all included!!

Directions:

Head south on meridian road, turn left on via del jardin, turn right on maddox road, turn left on creosote drive, turn right on trajen place, turn left on desert spoon drive; house will be on the left.

      

1208 W Desert Spoon Dr

Bedrooms   2
Baths 3
Year Built 2021
Square Feet2032
Lot Size6174 Sqft
Levels 1
Garage 2.00 Car Garage
Tax$225
HOA Dues$225 Monthly
Listing StatusUnder Contract
Listed ByHomeSmart
Listing Price$499,900
MLS Number6595836
 
Schools:

 
 
Bedrooms   2
Baths 3
Year Built 2021
Square Feet2032
Lot Size6174 Sqft
Levels 1
Garage 2.00 Car Garage
Tax$225
HOA Dues$225 Monthly
Listing StatusUnder Contract
Listed ByHomeSmart
Listing Price$499,900
MLS Number6595836
 
Schools:

 
 

Features:

  • Breakfast Bar, Dining in LR/GR Dining Area
  • 2 Master Baths, 3/4 Bath Master Bdrm, Double Sinks, Full Bth Master Bdrm, Private Toilet Room, Separate Shwr & Tub
  • Covered Patio(s), Gazebo/Ramada, Patio, Private Street(s)
  • 2 Master Bedrooms, Master Bedroom Walk-in Closet, Other Bedroom Split, Other Bedroom Walk-in Closet
  • Master Bedroom Not Split, Split
  • Gas Hot Wtr - Tnklss
  • Dual Pane Windows
  • Carpet, Tile Floors
  • Great Room
  • Frame - Wood Construction
  • Tile Roof
  • Above Ground, Heated
  • Dryer Included, Inside, Washer Included, Wshr/Dry HookUp Only
  • 9+ Flat Ceilings, Drink Wtr Filter Sys, No Interior Steps, Soft Water Loop, Water Softener Owned
  • Cable TV Avail, High Speed Internet Available
  • Dir Entry frm Garage, Electric Door Opener
  • Ranch Style
  • City Services
  • Ceiling Fan(s), Refrigeration Cooling
  • Block Fence
  • Auto Timer H2O Back, Auto Timer H2O Front, Desert Front, Gravel/Stone Back, Synthetic Grass Back Landscaping
  • Corner Lot, North/South Exposure
  • Biking/Walking Path, Clubhouse/Rec Room, Comm Tennis Court(s), Community Media Room, Community Pool, Community Pool Htd, Community Spa, Community Spa Htd, Gated Community, Pickleball Court(s)
  • Natural Gas

Remarks:

ASSUMABLE 3% VA LOAN!! LOWEST PRICE PER SQUARE FOOT IN OVATION AT $250 PER SQ. FT!! Better than new spacious move-in ready 2032 sq. ft home with 2 ensuite bedrooms w/walk-in closets, a den, and 2.5 baths, 2 car garage w/garage floor coating on highly desirable corner N/S lot!! $10K just spent on new ''Hollywood hedge'' trees for added privacy while you enjoy low maintenance backyard with a covered patio, pavers, artificial turf, spa and new pergola. This home is highly upgraded with wood-look tile throughout, carpet in the bedrooms, plantation shutters, security screen door, gourmet kitchen with quartz, cabinet pull outs, R/O, water softener, farmhouse sink, gas cooktop, SS appliances, backsplash, and a large island w/breakfast bar. Refrigerator, washer/dryer, spa are all included!!

Directions:

Head south on meridian road, turn left on via del jardin, turn right on maddox road, turn left on creosote drive, turn right on trajen place, turn left on desert spoon drive; house will be on the left.

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"; ?>