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','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 = 1575 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 = 1575 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;

43498 Walnut Lane
Richmond, MO 64085

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $675,000
Beds: 4
Baths: 4
Status: Pending
SqFt: 3279
Agency: Debbie Hahn Real Estate Inc dba Prudential Snook,

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 2006
Notes: Indulge in luxurious living at this exquisite estate set on 4.71 acres of serene park-like surroundings, complete with a pool. Boasting over 2179 sqft on the main level, this custom built home offers a seamless blend of elegance and functionality. Discover three spacious bedrooms, two and a half bathrooms, and a versatile office/library for remote work or relaxation. Entertain with ease in the kitchen dining combo and formal dining room, or unwind in the spacious but cozy great room by the fireplace. The living room's picturesque windows invite natural light to flood the space. Retreat to the splendid master suite, featuring a spa-like ensuite with a separate tub, walk-in shower, walk-in closet, and double sinks. The finished walkout basement offers endless possibilities with a vast family room featuring a mini-kitchen and pool table that’s perfect for gatherings, a sizable rec room, a dedicated workout space, and a 4th bedroom with a walk-in closet. With its refined design and abundance of amenities, this home exemplifies quality living at its finest. Let’s not forget the in-ground pool with concrete patio and the 40x30 detached 3-car insulated outbuilding featuring cement floor and electric. This property has elaborate professional landscaping, including fruit trees. The home sits on a park like setting at the end of a dead end. The location is simply prime. Shown by appointment only. Call now to schedule your private tour.
MlsNumber: 2482923


Listing Provided By: Debbie Hahn Real Estate Inc dba Prudential Snook,, original listing
Name: Debbie Hahn Real Estate Inc dba Prudential Snook,
Phone: (816) 632-2459 xx32
Office Name: Berkshire Hathaway HomeService
Office Phone: (816) 632-2459
Agent Name: Debbie Hahn
Disclaimer: Copyright © 2024 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