Title Page Background
DEBUG FN args: Array ( [0] => 95 [1] => [2] => [3] => agent ) BEFORE: Site: 95 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 95 Igate: njhud LocID: 95 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 = 95 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] => 95 [1] => [2] => [3] => lender ) BEFORE: Site: 95 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 95 Igate: njhud LocID: 95 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 = 95 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] => 95 [1] => [2] => [3] => other ) BEFORE: Site: 95 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 95 Igate: njhud LocID: 95 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 = 95 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;

1074 Altus Ln
Fredonia, AZ 86022

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 2
Baths:
Status: Active
SqFt: 1288 Square Feet
Agency: Rankin Realty at Lake Powell

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential-Other
Year Built: 1999
Notes: Located down a sleepy lane in the southern part of Fredonia surrounded by iconic views and easy wilderness access this property is just shy of 10 acres and offers a life style opportunity not found in many places. The home features new paint, flooring, 2 bedrooms, a large dining area and open floor plan. There is a 14' x 41' framed in unfinished home on the property for great storage, 20' x 20' covered parking, round pen, goat pen, 5 other horse pens and the pasture complete with shelters and 12 frost free water supplies. The main barn is metal, 49.5 feet long and just under 42 feet wide with 12 foot deep stalls. 8 acres is zoned agricultural while the home site of 1.75 acres is zone residential for a total of 9.75 acres of rural farm living or investment opportunity. Fredonia is centrally located to several national parks including Zion, Bryce, the North Rim of the Grand Canyon, Lake Powell and the Grand Staircase Monument just to name a few. A quick 7 miles has you in downtown Kanab with great food and local color.
MlsNumber: --


Listing Provided By: Rankin Realty at Lake Powell, original listing
Phone: (928) 691-6444
Office Phone: (928) 691-6444
Agent Name: Heather Rankin
Disclaimer: Copyright © 2024 Fredonia MLS. 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