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 = 1559 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 = 1559 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 = 1559 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;

612 County Road 130
Diamond, MO 64840
Jonathan Leach Team with KELLER WILLIAMS REALTY ELEVATE, original listing - (417) 623-9900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4600 Square Feet
Agency: KELLER WILLIAMS REALTY ELEVATE
Agency Phone: (417) 623-9900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 44 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: 44 Acre piece of paradise welcomes ranching, farming, and possibilities in abundance. Step into the pinnacle of design and craftsmanship. From the moment you enter, the striking spiral staircase commands attention, expanding the grand foyer and setting the tone for the rest of the home. To your right, the formal dining room invites you into a chic cottage-style kitchen, complete with two walk-in pantries and a brand-new Frono 48 freestanding industrial gas range. The unique wrap-around layout flows effortlessly around the spiral staircase, connecting a formal seating area framed by stunning floor-to-ceiling windows, an entertainment space, and a versatile office area. Head downstairs to a spacious, multi-purpose basement perfect for entertaining, with endless potential for additional rooms or creative use. Back upstairs, step through the kitchen's egress door to find a charming screened veranda with access to the third-floor balcony, blending indoor and outdoor living. On the third floor, you'll find four beautifully designed bedrooms equipped with modern amenities. The master suite is a private retreat, featuring balcony access, a cozy fireplace, and 345 square feet of luxurious space. To tie in the beautiful architecture of the home, the property and grounds include 6,000 sq.ft. barn is fully equipped to house and provide sanctuary for many walks of animal life. With amenities including 10 dog kennels, 17 cat kennels, 13 pet suites, fully applianced laundry room, fully equipped kitchen, several window units for air conditioning, a wood burning furnace, and much more. Think about what you could use this carefully designed space for. Whether you wish to refurbish or revamp, or re-imagine the beauty the sellers dreamed of, the possibilities are endless with the amount of space you can utilize. The property boasts a pond for pets, fully fenced with cross fenced pasture; the main entrance is power gated for additional security and peace of mind. Beautiful by day or evening, sunset or morning light, this special property is the pinnacle for rural and country living!
MlsNumber: --
ListingId: 245351


Listing Provided By: KELLER WILLIAMS REALTY ELEVATE, original listing
Phone: (417) 850-5010
Office Phone: (417) 623-9900
Agent Name: Jonathan Leach Team
Disclaimer: Copyright © 2024 Ozark Gateway 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.


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 = 1559 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 Wren Vickers
Wren Vickers
ASCIICharles Burt Homefolks
Call Today!: (417) 388-1067

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App