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 = 3426 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 = 3426 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 = 3426 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;

3339 E Granite View Drive
Phoenix, AZ 85044

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $925,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 2925
Agency: Tempe Realty 1, LLC dba Keller Williams Realty Eas

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: Your Dream Home Awaits! This Move-In Ready, 2005 Custom Build boasts Luxurious Upgrades Galore! Savor the Breathtaking Mountain Views from the Primary Suite Balcony, Featuring Custom Wrought Iron Railing for Added Charm and Style. Your neighbors will have Garage Envy because of the Expansive 32' Wide, Extra Deep 3-Car Garage with an 18' x 10' Workshop Room Wired for Your Projects....and it's Air-Conditioned! <br /> Remodeled in 2022, this home features a Stunning Custom Kitchen with Soft-Closing Drawers and Cabinets, Large 2-Slab Granite Island, Newer Appliances, a Breakfast Area and Open to the Great Room with a Wood Burning Fireplace. Experience the Bright and Airy Ambiance of this Space, enhanced by 10' Ceilings and an Abundance of Surrounding Windows. Delight in the Ideal Setting with Your Morning Coffee, Bathed in Natural Light and Serenity.<br /> <br /> Relax and Unwind in the Newly Remodeled Bathrooms, Adorned with Elegant Tile Showers and Glass Hinged Doors.<br /> <br /> Indulge in Luxury with the Primary Suite Featuring a Relaxing Soaking Tub and Exquisite Chandelier, adding a Touch of Elegance to Your Retreat, plus Expansive His/Hers Walk-in Closets, Equipped with a Convenient Closet System and Ample Shoe Storage Drawers.<br /> <br /> Bask in the Morning Sunlight on the East Patio and Capture the Serenity of Sunset on the West Patio. Take a Dip in the Refreshing Pool as you Immerse Yourself in Majestic Mountain Views. Dive into Tranquility and Nature's Beauty Right from Your Own Backyard Oasis!<br /> <br /> Welcome Guests and Family Members to the Convenient Downstairs Bedroom and Full Bathroom. <br /> <br /> Additionally, the Extra Area off the Kitchen Offers Versatility, Ideal for a Workout Room, Office, or Kids' Play Area. Enjoy Privacy with the Property Backing Up to the Wash, Creating a Tranquil Retreat for All to Enjoy. <br /> <br /> This Impeccable Home Boasts Plantation Shutters, Newly Painted Epoxy Garage Floor, and Exquisite Saguaro Planted in the Front Yard in one of the Best Neighborhoods in Mountain Park Ranch!
MlsNumber: 6680270


Listing Provided By: Tempe Realty 1, LLC dba Keller Williams Realty Eas, original listing
Name: Tempe Realty 1, LLC dba Keller Williams Realty Eas
Phone: (480) 839-6600
Office Name: Keller Williams Realty East Valley
Office Phone: (480) 839-6600
Agent Name: Cynthia Worley
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App