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;

44814 N 22nd Street
New River, AZ 85087
Shelly Baumer with DPR Realty LLC, original listing - (480) 994-0800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2943 Square Feet
Agency: DPR Realty LLC
Agency Phone: (480) 994-0800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2007
Notes: This Exquisite home is Highly Upgraded/Updated w/ Luxurious finishes & features thru-out. The Unique Architecture incorporates a linear design layout w/ dramatic radius walls for a distinctive touch vs the typical Santa Fe Territorial home. It still has an open feeling that makes for great entertaining and gatherings of friends & family. You'll love the Cozy Stacked Stone fireplace in the Great room along w/ the abundance of windows stretching across the back of the home to provide openness to back wrap around PAVERED Patio w/it's structured columns. The great room opens to Dining Area & the Well Planned & appointed GOURMET Kitchen offering GENEROUS storage & WORKSPACE including a separate Veggie/Prep sink in center ISLAND. Lots of natural light, GRANITE Counters, Custom (click blue link) Full Custom Travertine BACKSPLASH, Stainless Appliances, & Stainless /STACKED STONE Vent hood make it beautiful too!! You'll also have find ample recessed lighting for a working kitchen along with the Pendant lighting for style, & conveniently the kitchen has it's own separate door to access the patio for serving apart from the door that accesses the patio from the Great room/ Dining room. Guest bedrooms #1 & #2 are located off the the Kitchen hall and are setup with a Jack & Jill bathroom that provides a completely separate Vanity/Sink/personal Storage area for each bedroom. There is also lavatory and bath/shower room with its own door to offer privacy. <br /> Moving to the North Wing of the home you'll enter through Double doors opening to the Tranquil Master Suite. Designed with radius wall touch & abundance of windows to the back patio for that natural light & beauty here as well. The Huge Master bath area includes dual sinks, jetted soaking tub, Snail shower with Travertine Surround, SPACIOUS Closet and a Direct Access door to the patio to enjoy your coffee in the morning or to relax before bed while watching the Glorious SUNSETS or maybe getting in some Stargazing. <br /> You will also enjoy the convenience of a 3.5 car extended length garage. It has 3 separate electric lift/roll-up doors for convenience, Epoxy coated floors, plentiful lighting, ceiling fans, and an extra 1/2 garage bay for your ATVs, motorcycles, jet skis, or as it is now being used for, a personal gym. There is also the Separate closed space /workroom at the back of the garage that provides a workbench, pegboard tool storage, and built in 3 sided shelving as well as cabinets for storage and organization.<br /> <br /> The home is ideally located just south of the entrance to the Tonto National Forrest with it's unlimited trails for hiking/horseback riding or/ATV riding. You'll enjoy the Native American ruins, Forts, Petroglyphs and other bits of history and beauty of the surrounding area.<br /> The 1.25 acre lot, that this magnificent home is built on provides plenty of useable level land to work with for a casita, RV Garage/Workshop, Pool, or extensive horse setup. There is no floodway/floodplain on the lot. The lot is fully fenced with rich looking but low maintenance White Vinyl rail fencing and full double gates including at the end of the Driveway. The back half includes extra fencing professionally added to make it dog safe/secure. The owner also had 2 horse corrals and a horse shade added at the very back of the property but there has never been horses kept on this lot. He had both electric and water lines run back to them, underground as well, for future use of the corrals.<br /> <br /> Additional features/upgrades:<br /> *Wood Plantation Shutters throughout the home 3 yrs ago<br /> *Both Water heaters replaced 2 yrs ago<br /> *New Flooring Under 1 yr ago<br /> *New $9500 Upgrade to a Silicone Roof for much lower <br /> maintenance and lower ongoing costs Under 1 yr ago <br /> *New Security System with Cameras. Hard Wired and With <br /> Technology for you to monitor them from your phone APP<br /> *New Interior and Exterior Painting Under 1 yr ago<br /> *Lots of Mature landscaping/trees including a lemon tree at the <br /> side of the home.
MlsNumber: --
ListingId: 6733643


Listing Provided By: DPR Realty LLC, original listing
Phone: (480) 215-7657
Office Phone: (480) 994-0800
Agent Name: Shelly Baumer
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;
Kassie Beal
ASCIIRe/Max Fine Properties
Call Today!: (928) 600-0159

Local Mortgage Pro

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;
Real Estate Expert Photo for VIRGINIA NICKEL, NMLS#282750
VIRGINIA NICKEL, NMLS#282750
ASCIIA MORTGAGE CENTRAL LLC,
Call Today!: (480) 650-4230

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App