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 = 1532 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 = 1532 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 = 1532 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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;

2405 County Road 2710
Mountain View, MO 65548
Jeff Lovan with Hayden Outdoors Real Estate, original listing - (970) 674-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2100 Square Feet
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 56 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 1950
Notes: Double J's Farm is an incredible offering spanning 56+/- acres that includes a gorgeous ranch style home, indoor and outdoor riding arenas, and a 5-stall stable. The property is situated less than 10 minutes from Mountain View and is ideal for horse enthusiasts, livestock owners, and also has amazing recreational opportunities. The Double J's Farm is the perfect blend of open pasture and timber. The very well kept 56+/- acre property is perimeter fenced, cross fenced, and has an abundance of black pipe fencing! There is also woven wire and some 5 strand barbed wire fencing. The land has 40+/- acres of lush, well-maintained grass set up with water and split into 6 pastures that are ideal for rotational grazing. The balance consists of 16+/- acres of hardwood timber. Multiple trails wind through the wooded portion, and there is also an abundant population of deer and turkeys that frequent the property. There are 4 ponds, 2 of them stocked with fish, and also frost-free hydrants for watering.   This beautifully remodeled 4-bedroom, 2.5-bath ranch home was originally built in 1950 and updated in 2008 and offers approximately 2,100+/- sq ft of living space. Featuring an open plan kitchen, living, and dining room, the home has hardwood floors, stainless steel appliances, and a very spacious master suite. The suite includes a large walk in closet, abundant bathroom space and sliding doors that walk out onto the deck. Another bedroom has been converted into a large office ideal for remote work or study. The home boasts many updates and extras, including hardwood floors, stainless steel appliances, a basement garage with utility room, and a backup propane Generac generator for added peace of mind. Additionally, there is a Heatmor outdoor wood furnace. A new well pump was installed in 2020 and a new water heater in 2022. This home is perfect for both relaxation and entertaining guests on the full length front porch or the screened in back porch. The large 3/4 wrap porch is ideal for watchingsunrises and viewing wildlife. Outside there are fruit trees in the well maintained yard, as well as the fenced backyard. The property also boasts a 60 x 100'+/- indoor riding arena and also a 145 x 100'+/- outdoor arena. There are multiple barnes including one with 5 stalls and a tack room, another for hay/equipment storage with 220 power and a third that is currently used for storage and a chicken coop. There is a lean-to as well as an 8x8 storage building / dog kennel. Located between Willow Springs and Mountain View, the property sits only 45 minutes to Eminence which is well known for trail riding. Also nearby is thousands of acres of the Mark Twain National Forest. Call today for your private showing. Please contact the listing agent for more information on this property or to schedule a private showing. (**Financial verification may be required**)
MlsNumber: --
ListingId: 11342897


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (970) 674-1990
Office Phone: (970) 674-1990
Agent Name: Jeff Lovan
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 = 1532 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 Solomon Cornelius
Solomon Cornelius
ASCIIMonark Realty
Call Today!: (417) 252-0499

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App