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;

Tbd Campwood Road
Prescott, AZ 86305
Andy Groseta with HEADQUARTERS WEST, LTD., original listing - (406) 250-2109

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $8,950,000
Beds: 13
Baths: --
Status: Active
SqFt: --
Agency: HEADQUARTERS WEST, LTD.
Agency Phone: (406) 250-2109

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 51 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: Simply stunning Terra Estate Farm and Ranch built off the dreams and determination of the 1800s homesteaders and improved in recent years by tasteful and thoughtful modern amenities. This off grid estate northwest of Prescott can be used as a family retreat/compound or for multiple other uses. You will not find another property like this in all of Arizona! 51+ acre inholding in Prescott USFS. The Farm-Manor is a very highly improved property. The improvements consist of the following: Residences (4): Main Residence: Approximately 9,000 sq. ft. 8 bedrooms, 8.5 baths. Constructed in 2003 Construction consists of Blackstone - red color concrete floors, wood frame walls, timber framed roof and stone. No central heating or A/C. Heat is provided by Blue Flame Propane Heat. Guest House: Approximately 629 sq .ft. 1 Bedroom, 1 bath Constructed in 1894. Heat is provided by a fireplace and blue flame propane. Hill House: Approximately 1,450 sq. ft. 2 bedrooms, 2 baths; Second Floor; 2 bedroom, 2 baths downstairs are used for guests who use the 2nd floor. Constructed in 2003 Construction Interior consists of wood frame, red concrete floor, tongue and groove; Exterior: stone and batten board. Heavy duty corrugated metal roof. Heat is provided by blue flame propane Entry House: Approximately 1,200 sq. ft. 2 bedrooms, 2 baths. Constructed in 2003 Construction Exterior: consists of wood frame, red concrete, tongue and groove; Interior: wood frame, tongue and groove, wainscoting, stone and batten board 1/3 up the wall. Heat: blue flame propane Constructed in 2003 Barn: Approximately 6,039 sq. ft., 1 bath. Event center on ground floor 9 horse stalls (Painted masonry/stone/wrought iron, with gravel / 3/4 inch rubber mats. Approximately 1,600 sq. ft. 2nd story consisting of two (2) apartments with a patio; Common kitchenette upstairs, bathroom on the ground floor. Heat: blue flame propane Construction consists of block and stone masonry/concrete floor/heavy wood timbers and tongue and groove wood ceiling. Second floor: wood frame, tongue and groove interiors in both bedrooms. Constructed in 2003. Shop/Storage/Cooler: Approximately 2,400 sq. ft. There is a new 'walk in' cooler (8' wide x 28' long) in the building. Constructed in 2003. Construction consists of metal building/concrete floor Hay Barn: Approximately 1200 sq. ft. (30' x 40') Constructed in 2003 Construction consists of two metal storage containers and metal building, dirt floor Greenhouses (3): Approximately 3,500 sq. ft. each Greenhouses Constructed in 2020 All of the vegetables, flowers and greens used at Farm/Manor are grown in the greenhouses.
MlsNumber: --
ListingId: 11389868


Listing Provided By: HEADQUARTERS WEST, LTD., original listing
Phone: (928) 634-8110
Office Phone: (406) 250-2109
Agent Name: Andy Groseta
Disclaimer: Copyright © 2024 My State MLS. 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 = 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;
Real Estate Expert Photo for Shelley Baker
Shelley Baker
ASCIIBetter Homes and Gardens Real Estate Bloomtree Realty
Call Today!: (928) 778-5790

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App