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 = 100 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 100 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 100 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;

2441 E Whitton Avenue
Phoenix, AZ 85016

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,599,000
Beds: 6
Baths: 5
Status: Pending
SqFt: 3603
Agency: Good Oak Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1953
Notes: Welcome to Tres Palmas! Located just 1.5 Miles from The Biltmore. This expertly renovated and gorgeously updated property is a total of 3,603 sq ft sitting on a HUGE 20K sq ft Lot. It features a very versatile Multi-Gen, split-living floor plan. The Main House is 2688 sq ft with 4 bedrooms 3 baths and the Guest House/Accessory Dwelling Unit is 915 sq ft with 2 bedrooms 1.5 Baths. No expense was spared in the reimagining of this property with over $625,000 in updates! The main living area has gone from a chopped up formal with 1950's galley kitchen to a Huge Open Great Room featuring a stunning Chef's Kitchen. Talk about a gathering space! The Premier Porcelain island is a whopping 5ft 4in by 8ft 4in AND you have an 11 ft long breakfast bar. The kitchen is equipped with an 8 burner gas range that has 2 ovens. The cabinetry drawers are dovetail construction and both the doors and drawers are all soft close. AND of course there's a beverage fridge and built-in Fridge/Freezer! Split from the rest of the house is a luxurious Primary Suite. You have a relaxing soaker tub, walk-in shower with multiple heads and a large, floating, double sink vanity. Yes it also has a very spacious walk-in closet and enclosed toilette area. On the opposite side of the home you'll find a 2nd Primary Suite and the secondary bedrooms. The 2nd primary suite has it's own very stylish full bath with double vanity, double head walk-in shower and a walk-in closet. The 3rd and 4th bedrooms are along the same hallway and share a lovely full bath. Through the main house laundry you enter the Guest House, Accessory Dwelling Unit. The ADU also has it's own separate entrance off of it's own driveway and covered parking. It has a full laundry, full kitchen, 2 bedrooms and 1.5 baths, all beautifully updated. This ADU can be locked off from the Main House to generate income as a rental or use it as a Guest Suite, for Multi-Generational Living or a home office. The possibilities are endless! The 20K sq ft lot gives you a ton of entertaining space and plenty of room to play in the backyard. Out here you'll find a 576 sq ft pool with a new Mini-Pebble Surface. There are also 2 Putting Greens and what use to be just a 9ft x 10ft storage building. It's now finished, wired and could be outfitted to be a pool cabana or the best playhouse ever. As you can tell, this property is quite unique! You'll be hard pressed to find a another one like it so close to The Biltmore. Make sure you put this one on your must see list.
MlsNumber: 6674185


Listing Provided By: Good Oak Real Estate, original listing
Name: Good Oak Real Estate
Phone: (480) 390-1444
Office Name: Good Oak Real Estate
Office Phone: (480) 539-4775
Agent Name: Dean Carver
Disclaimer: Copyright © 2024 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.


Local Real Estate Expert

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 = 100 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;
Real Estate Expert Photo for Christine Gioia
Christine Gioia
ASCIILaunch powered by Compass
Call Today!: (480) 234-2961

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App