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

402 Frederick Drive
Gower, MO 64454
Tina Cotton with Keller Williams KC North, original listing - (816) 452-4200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $329,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2456 Square Feet
Agency: Keller Williams KC North
Agency Phone: (816) 452-4200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: Welcome to this beautifully remodeled ranch-style home in the desirable small community of Gower, Missouri. Nestled on a spacious corner lot at the entrance to a lovely neighborhood, this brick, one-level home offers both comfort and convenience, with a wealth of desirable features inside and out. <br /> <br /> Two Fireplaces: The main living room boasts a high-end pellet stove insert, controllable like a furnace, providing efficient and cozy warmth. The basement features a traditional wood-burning fireplace, perfect for adding ambiance to the spacious family room or bedroom.<br /> <br /> Enjoy ample space in the partially finished basement family room, which walks out to a covered patio and large backyard. Ideal for entertaining or relaxing with family and friends. Basement includes an additional bathroom. <br /> <br /> The main floor features waterproof, scratch-proof high-end ceramic wood tile throughout, while the bedrooms and family room are accented with plush, soft carpet. Rich ceiling beams add character and charm to the main floor family room.<br /> <br /> The spacious kitchen offers painted cabinets with abundant storage for the family chef.<br /> <br /> Deck with Scenic Views: Step outside onto the deck to enjoy views of the expansive yard, which spans two lots and includes a view of a neighboring tranquil pond.<br /> <br /> Large, Fenced Yard: The property boasts a beautiful, fully fenced yard (6-foot chain-link fence) with meticulous landscaping and plenty of space for outdoor activities.<br /> <br /> The home's exterior requires minimal upkeep and the newer fold out windows are easily cleaned from the inside.<br /> <br /> Location: Located on a city-maintained street, the home offers easy access to Gower’s charming small-town atmosphere, yet is just a short drive from larger nearby cities.<br /> <br /> This home offers the perfect blend of country charm and modern updates, making it an ideal place to settle down. Don't miss the chance to make this Gower gem your own—schedule a showing today!
MlsNumber: --
ListingId: 2525616


Listing Provided By: Keller Williams KC North, original listing
Phone: (816) 294-6969
Office Phone: (816) 452-4200
Agent Name: Tina Cotton
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