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

38938 Az-373
Greer, AZ 85927
Courtney Lawrence with My Home Group Real Estate - Tempe, original listing - (480) 685-2760

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $720,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2800 Square Feet
Agency: My Home Group Real Estate - Tempe
Agency Phone: (480) 685-2760

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Other
Year Built: 2002
Notes: Embrace the magic of all four seasons in the charming mountain town of Greer! Soak in the brilliant fall colors of October, wander through serene, snow-covered mountains in winter, and enjoy crisp spring and summer days beneath the pines—perfect for escaping the heat. Whether you're a full-time or part-time resident, there is always something to do no matter the time of year. Spring and summer are great for fishing, hiking, bike riding, exploring and campfires. Skiing enthusiasts will love being just 30 minutes from Sunrise Park Resort, where you can hit the slopes for a day of fun before heading home to relax in your own private sauna. In the summer the resort offers mountain biking, tubing, rock climbing, and more! This remarkable 3 bed/2 bath cabin, with 2800 sq feet of total living space is conveniently located right off State Route 373, and a rare opportunity to own a slice of Greer's history. Built/owned by James Emerson of Emerson Construction, who left his mark across Greer with structures like the fire stations, post office, and countless cabins, this property radiates warmth, and craftsmanship. Beautiful woodwork throughout the cabin and a cozy wood stove complete the inviting atmosphere. Panoramic views, fresh mountain air, and clear and vivid night skies, make this a true mountain retreat. Zoned as both residential and commercial, this property has endless possibilities as a private escape or for additional revenue. Horseback riding for tourists, or adding a guest house for an Airbnb, are just a couple of ideas for this fantastic location.
MlsNumber: --
ListingId: 253298


Listing Provided By: My Home Group Real Estate - Tempe, original listing
Phone: (928) 240-2961
Office Phone: (480) 685-2760
Agent Name: Courtney Lawrence
Disclaimer: Copyright © 2024 White Mountain Association of Realtors. 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