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

15684 Fishing River Road
Lawson, MO 64062
HHKC TEAM with EXP Realty LLC, original listing - (913) 782-8857

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,599,000
Beds: 7
Baths: Full: 6, ½: 1
Status: Active
SqFt: 6632 Square Feet
Agency: EXP Realty LLC
Agency Phone: (913) 782-8857

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 80 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Escape to tranquility just 30 minutes from the city with this sprawling 80-acre property. This 7-bedroom, 6½-bathroom, 6,000+ sq. ft. home offers luxurious living surrounded by nature. Wake up to rolling hills, deer, and turkey in a private, serene setting, perfect for relaxing or entertaining. The extensive grounds feature garden areas, a barn, and a greenhouse, blending nature with architecture. The Craftsman-style home boasts high-end finishes and a chef’s kitchen with granite counters, two ovens, two microwaves, and two range tops, plus a wine fridge. The open layout includes a sunken family room with tall ceilings and elegant trim, filled with natural light. The main level is designed for entertaining, featuring a marble foyer, hardwood floors, soaring ceilings, and a large dining room. The great room offers a warm wood stove and bar, while a spiral staircase leads to a library with built-in shelving and balcony access. The first-floor master suite is a private oasis with a wood stove, dual patio access, and a master bath with dual sinks and a huge shower. Upstairs, four more bedrooms await. The upstairs master suite includes a gas fireplace, private balcony, large bathroom with jacuzzi tub and glass shower, and a walk-in closet. Another bedroom features an ensuite bath and walk-in closet, while the third bedroom accesses the main balcony and uses the nearby hall bath. The fourth suite is a fully private in-law suite with its own entrance, kitchen, living/dining combo, bathroom, laundry, and two bedrooms. The partial walkout basement includes a rec room, bedroom, full bath, storm shelter, and workshop/storage area. The house is centrally located on the property, offering privacy from neighbors and passing cars. A 50’ x 60’ shed provides additional vehicle parking, equipment storage, a workshop with a 100amp electrical panel, a greenhouse, and a protected vegetable garden. Schedule your visit for this exceptional property today!
MlsNumber: --
ListingId: 2541449


Listing Provided By: EXP Realty LLC, original listing
Phone: (913) 782-8857
Office Phone: (913) 782-8857
Agent Name: HHKC TEAM
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App