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;

126 S Raum Street
Lawson, MO 64062
Steven Mock with Platinum Realty, original listing - (816) 452-4200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $254,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1540 Square Feet
Agency: Platinum Realty
Agency Phone: (888) 220-0988

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Duplex
Year Built: 2025
Notes: Welcome to a masterpiece of modern living! This breathtaking brand-new half duplex embodies the pinnacle of contemporary design, offering you the perfect blend of style, comfort, and convenience. With its sleek modern lines and expansive interiors, this home is a luxurious canvas waiting for you to create your dream lifestyle.<br /> <br /> Step into the heart of the home - a stylish, gourmet kitchen that is a chef’s delight. Featuring elegant quartz countertops, a full suite of high-end stainless steel appliances, and an island complete with a breakfast counter, this kitchen is both functional and beautiful. Custom cabinetry provides ample storage, ensuring everything you need is within reach.<br /> <br /> The home's open floor plan seamlessly connects the kitchen to the main-level owner’s suite, an oasis of tranquility. Enjoy the expansive walk-in closet and the convenience of a full laundry room on the same level, ensuring your daily routine is efficient and effortless. <br /> <br /> Upstairs, you'll discover generously sized bedrooms that offer privacy and comfort, each room designed to be a personal retreat. The plush carpets in these rooms add a cozy touch, while the waterproof wood-look laminate flooring throughout the rest of the home offers both durability and sophistication.<br /> <br /> Venture outdoors to find a covered back patio, perfect for alfresco dining, morning coffees, or evening relaxation. This exterior space enhances the home's charm, providing a seamless indoor-outdoor living experience you'll love.<br /> <br /> Situated just blocks away from top-rated schools and vibrant town amenities, this home offers not only luxury but also a coveted location. It's an ideal setting for those seeking both community and convenience.<br /> <br /> Don’t miss the chance to experience this stunning home for yourself. Schedule a visit today and envision your future in a place where luxury meets everyday convenience.
MlsNumber: --
ListingId: 2534361


Listing Provided By: Platinum Realty, original listing
Phone: (816) 379-9878
Office Phone: (816) 452-4200
Agent Name: Steven Mock
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