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

604 N Buckner Tarsney Road
Buckner, MO 64016
David Wiesemann with RE/MAX Heritage, original listing - (816) 224-8484

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 3124 Square Feet
Agency: RE/MAX Heritage
Agency Phone: (816) 224-8484

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 28 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1893
Notes: Discover the serene beauty of rural living with this stunning 3-bedroom, 2-bathroom home nestled on 28 picturesque acres with a secondary residence, and multiple barns. This meticulously maintained property offers the perfect blend of classic charm and modern amenities, making it an ideal haven for nature lovers and those seeking tranquility. Would have the potential for a great business opportunity with a fruit or vegetable stand. <br /> <br /> Interior Features: Spacious Bedrooms - Three generous bedrooms provide ample space for relaxation and rest. Luxurious Bathrooms: Enjoy the elegance of a classic claw foot tub in one of the two well-appointed bathrooms. <br /> Gourmet Kitchen: The kitchen boasts beautiful granite countertops, perfect for preparing meals and entertaining guests. <br /> Hardwood Flooring: Rich hardwood flooring flows throughout the home, adding warmth and character to every room. Control the temperature with zoned cooling and heating.<br /> <br /> Exterior Features: Expansive Acreage - Explore and enjoy 28 acres of pristine land, offering endless possibilities for outdoor activities and adventures. <br /> Barns: Turn of the century barn, all barns are equipped with power. Active well on the property for use in the barns & outbuildings. Cattle Waterer & corral for cattle or horses. <br /> Scenic Pond: A tranquil pond enhances the natural beauty of the property, providing a serene spot for relaxation and reflection. <br /> Black Top Driveway: The well-maintained black top driveway ensures easy access to your rural retreat. <br /> <br /> Whether you're seeking a peaceful weekend escape or a full-time residence surrounded by nature, this home offers an unparalleled lifestyle opportunity. Don't miss the chance to make this charming property your own. There is also the opportunity to purchase an additional 50 acres.
MlsNumber: --
ListingId: 2526149


Listing Provided By: RE/MAX Heritage, original listing
Phone: (816) 309-9445
Office Phone: (816) 224-8484
Agent Name: David Wiesemann
Disclaimer: Copyright © 2025 Heartland Multiple Listing Service. 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 = 1534 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 Josefina Campos
Josefina Campos
ASCIIPlatinum Realty
Call Today!: (816) 679-1240

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App