Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3421 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3421 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3421 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

4421 S Terrace Road
Tempe, AZ 85282
Joseph Hoxie with HomeSmart, original listing - (602) 230-7600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $775,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 1875 Square Feet
Agency: HomeSmart
Agency Phone: (602) 230-7600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1971
Notes: This turnkey home is an entertainers dream with NO HOA. Newer LED heated sparkling pool and spa, firepit, bbq with a counterspace and seating, TV hookup, water hookup, front and back grass, and an extended slab for extra parking, and garage PRx gym. Kitchen has a gas range (electric hookup possible), 10 ft quartz island, quartz countertops, white shaker soft closing cabinets, stainless steel appliances, and pantry. There are two (yes two) master suites. The main master has a newer Closet Factory, custom his and her closet and entertainment storage. The other, in-law master has a walk-in closet and private bathroom. The other two larger rooms also have walk-in closets. The home also has a newer water softener, attic storage, and overhead storage. Newer roof, HVAC, water heater, insulation, nest, and much more (see below) - over $175,000 in updates! Home is centrally located to nearby restaurants, entertainment, parks, and others like Crust Tempe, Porch, Scramble, US Egg, Postinos, Majestic theater, AMF bowling, Kiwanis, Arredondo, and tons more.<br /> <br /> Upgrades:<br /> 2018<br /> - January, new 5 ton 14 Seer HVAC and ducting (including removal of furnace and convert to combo roof unit);<br /> - January, new 40gal water heater;<br /> - January, upgraded to R38 insulation;<br /> - January, convert kitchen range from electric to gas;<br /> - January, added salt water treatment system;<br /> - January, master bedroom and den roof repaired and whole house roof sealed;<br /> - January, all new stainless steel appliances in kitchen;<br /> - January, clean and sealed tile grout lines;<br /> - January, re-wire/cap electrical panel and outlets;<br /> - May, overhead storage added in garage;<br /> <br /> 2019<br /> - April, City of Tempe added a streetlight in front of the home after our Petition was approved; and,<br /> - September, install closet shelving and wall unit/dresser in master.<br /> <br /> 2020<br /> - ~$90,000.00 front and backyard complete remodel/redesign, including decking, driveway extension, grass, pool, spa, firepit, BBQ grill, and more.<br /> <br /> 2021<br /> - ~$10,000.00 full roof replaced.<br /> <br /> 2025<br /> - tile and grout resealed<br /> - painted inside and out<br /> - carpets cleaned<br /> - windows washed<br /> - Bbq tuned up with new knobs<br /> - wooden pergola placed in backyard<br /> - power washed driveway
MlsNumber: --
ListingId: 6848116


Listing Provided By: HomeSmart, original listing
Phone: (480) 334-9879
Office Phone: (602) 230-7600
Agent Name: Joseph Hoxie
Disclaimer: Copyright © 2025 Arizona Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App