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

1960 Highway V
Owensville, MO 65066
Diane Thomas with RE/MAX Exclusive Properties, original listing - (573) 437-8500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,900,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: --
Agency: RE/MAX Exclusive Properties
Agency Phone: (573) 437-8500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 377 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 1990
Notes: TURN KEY EXECUTIVE RETREAT!!! THE ASPHALT DRIVEWAY LEADS YOU BACK TO A BREATH-TAKING 5-BEDROOM, 5-BATH, FULL BRICK HOME SITUATED ON 378 ACRES. MANY AMENITIES THROUGH OUT THIS BEAUTY INCLUDE: 2-DEEP WELLS, HARDWOOD, GRANITE, CROWN MOLDING, 2 GEO-THERMAL HVAC SYSTEMS, 3-SPRAWLING BEDROOM SUITES, THEATER ROOM, 2-WELL EQUIPPED KITCHENS, MULTI DINING AREAS, FAMILY ROOM W/WOOD BURNING FIREPLACE, GATHERING ROOM/SUNROOM, (GREAT PLACE TO WATCH THE SUNRISE & SUNSET) SPRAWLING PATIO W/OUTDOOR KITCHEN & FIREPLACE, (PREFECT FOR HOSTING & ENTERTAINING. THE 378 ACRES IS A WELL BALANCE FOR YOUR RANCH OPERATION. PIPE FENCING & SOME CROSS FENCING, WATERERS, MULTI OUTBUILDINGS, SHOW BARN, 8 STALL, WASHING STALL, EQUINE QUARANTINE AREA, 2 OFFICES, 1/2 BATH. ABUNDANCE OF WILDLIFE SURE TO SPARK ANY HUNTER'S INTEREST. THE HUNTING CABIN, IS A PERFECT PLACE FOR HUNTERS TO SHARE THERE STORIES & MAKE MEMORIES. IN ADDITION, RED OAK CREEK RUNS THROUGH PROPERTY, IN ADDITION, THERE ARE 5-PONDS.
MlsNumber: --
ListingId: 24043957


Listing Provided By: RE/MAX Exclusive Properties, original listing
Phone: (573) 368-8025
Office Phone: (573) 437-8500
Agent Name: Diane Thomas
Disclaimer: Copyright © 2024 MARIS. 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