Title Page Background
DEBUG FN args: Array ( [0] => 93 [1] => [2] => [3] => agent ) BEFORE: Site: 93 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 93 Igate: njhud LocID: 93 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('azhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 93 [1] => [2] => [3] => lender ) BEFORE: Site: 93 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 93 Igate: njhud LocID: 93 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('azhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 93 [1] => [2] => [3] => other ) BEFORE: Site: 93 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 93 Igate: njhud LocID: 93 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('azhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

30 County Road
Greer, AZ 85927

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $719,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2440 Square Feet
Agency: West USA Realty - Eagar
Agency Phone: (928) 551-3961

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1993
Notes: A RARE FIND IN GREER! THIS STUNNING CONTEMPORARY 2440 SF CABIN OFFERS A PERFECT BLEND OF COMFORT, LUXURY & A LOCATION FAR FROM THE HUSTLE BUSTLE. EXPANSIVE VIEWS OF THE GREER VALLEY, ESPECIALLY FROM THE WRAP AROUND DECKS WHICH OFFER SPACES TO ENJOY OUR COOL SUMMERS. THE 4 CAR GARAGE IN THE BASEMENT OF THE MAIN HOME IS A RARITY HERE & ALLOWS PLENTY OF STORAGE FOR ALL YOUR TOYS! ALSO INCLUDES A SEPARATE SINGLE 2 STORY GARAGE NOW BEING USED AS A HORSE BARN. A BEAUTIFUL 1.4 ACRE LOT W/ MANY ASPEN, BLUE SPRUCE & JUNIPER THAT DOT THE LOT. STEPPING INSIDE THE EFFICIENT MUDROOM ENTRY, THE CABIN OPENS UP TO THE CUSTOM & GORGEOUS WOOD BEAMS THROUGHOUT ALL 3 LEVELS. STUNNING BEAMS W/ MANY WINDOWS & DIFERENT LEVELS FOR SPACIOUS LIVING. COME SEE THE COMFORT & FUNCTIONALITY OF THIS RARE GREER CABIN! ENJOY THE COMFORT OF THE OSBURN WOODSTOVE IN THE GREAT ROOM LIVING AREA AS WELL AS CENTRAL PROPANE FURNACE HEAT WITH AN OWNED 500 GAL PROPANE TANK. <br /> ON THE MAIN LEVEL, YOU WILL HAVE THE KITCHEN WITH NEW DOUBLE OVEN AND NEW DISHWASHER AND THE LIVING ROOM/ DINING AREA BIG ENOUGH FOR ALL THE THANKSGIVINGS GATHERINGS. 2 BEDROOMS AND HALL BATH ON THIS LEVEL.<br /> <br /> ON THE NEXT LEVEL UP IS THE ELEGANT AND AIRY GUEST BEDROOM OPEN LOFT ABOVE THE KITCHEN/LIVING ROOM WITH PRIVACY CURTAIN AND INCREDIBLE VIEWS.<br /> BACK DOWN THAT HALL WAY IS THE NEWLY REMODELED PRIMARY BEDROOM WITH PRIVACY AND ENSUITE BATHROOM AND HAS A SWEET SMALL LOFT ABOVE, FOR YOUR DRUMS OR ART STUDIO...<br /> <br /> THE LARGE FINISHED BASEMENT HAS THE LAUNDRY AREA, THE PRESSURE TANK FOR THE WELL, A UTILITY SINK AND OFFERS THE FOUR GARAGES - ONE IS SET UP AS A SEPARATE WORKSHOP. <br /> <br /> ON THE NORTH SIDE OF THE PROPERTY IS A 2 STORY OPEN GARAGE ( WHERE THE HORSE NOW RESIDES) AND ABOVE THAT IS A CARPETED OPEN AREA WITH POWER, NO WATER- POSSIBLE BUNKHOUSE USES! THE GARAGE CONTAINS A 5200 GAL WATER STORAGE TANK THAT OFFERS OUTSTANDING FIRE PROTECTION.<br /> THE HOME HAS A PRIVATE WELL ALSO.<br /> CALL FOR AN APPOINTMENT TODAY TO SEE THIS CONTEMPORARY LOG SIDED CABIN NESTLED IN THE TALL PINES OF GREER!
MlsNumber: --
ListingId: 252951


Listing Provided By: West USA Realty - Eagar, original listing
Phone: (928) 551-3961
Office Phone: (928) 551-3961
Agent Name: Skye Snyder
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