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

55409 N Madre Circle
Seligman, AZ 86337

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,900
Beds: 2
Baths: 3
Status: Active
SqFt: 1472
Agency: Keller Williams Arizona Living Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential
Year Built: 1979
Notes: "Nestled amidst almost 7 acres of picturesque landscape, this stunning mountain home offers unparalleled tranquility with breathtaking views of the Aubry Mountains and valley. With a split floor plan, this residence features 2 spacious bedrooms, 3 baths, and a spa room complete with a half bath for added convenience. The sunken living room with a flagstone-adorned wood-burning fireplace provides the perfect ambiance for cozy evenings, while the flagstone entryway welcomes you with rustic charm. No detail has been spared, from the generator and solar panels ensuring uninterrupted power to the 2-car attached garage providing ample storage space. The property also features a propane tank and LP lighting, offering convenience and energy efficiency. Additionally, there's 12v lighting with a solar charger for that late-night lighting, perfect for enjoying the serene mountain evenings. Step outside to your own private paradise featuring a refreshing pool, an Old Western saloon-style building, corral, and parking for your camper or off-roading toys, all backing up into miles of state land. For the nature enthusiast, an observation deck called the Owl's Nest offers stunning panoramic views of the surrounding trees and mountains. Adding to the charm, an Old West style water tower adds character and nostalgia to the property, creating a unique focal point against the backdrop of the scenic landscape. Whether you're seeking a permanent residence or a serene mountain escape, this property promises the ultimate retreat into nature's embrace. Schedule your showing today to experience mountain living at its finest!"
MlsNumber: 010478


Listing Provided By: Keller Williams Arizona Living Realty, original listing
Name: Keller Williams Arizona Living Realty
Phone: (928) 453-6111
Office Name: BH Keller Williams Arizona Living Realty
Office Phone: (928) 219-5482
Agent Name: Irminger Monroe Group
Disclaimer: Copyright © 2024 Western Arizona Realtors Data Exchange. 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