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

17253 Nw County Road 1501 Road
Archie, MO 64725
Teresa Ford with Crown Realty, original listing - (816) 205-8085

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $503,250
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2742 Square Feet
Agency: Crown Realty
Agency Phone: (816) 205-8085

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: Here is the one you have been waiting for! This 2,742 sq ft home sits on a 1.25 acre lot and is in the sought-after Archie School District. With 4 bedrooms, 3 bathrooms, living room, family room, and a relaxing fire pit on the acreage, there is plenty of space for entertaining. This dream kitchen has it all: a nice island with seating for four, all stainless-steel appliances, reach in pantry with built in shelving, and a dining room/eat in kitchen-living room area. The spacious laundry room is just off of the front door/garage door entrance and includes built-in cabinets and access to the primary walk-in-closet. The main level also includes a luxurious main suite with a spa-like bathroom, showcasing a rock/tiled shower, walk-in closet, two additional bedrooms and one additional bathroom. A fourth bedroom, full bathroom, large family room and nice sized storage/utility room are in the basement and adds plenty of room for the family and friends to hang out and relax. Out back, enjoy the peaceful, treed yard backing up to a dry creek, a covered porch providing a serene setting for evenings and family cookouts or just enjoying a view of the sunrise. The lower covered patio offers you extra space for large gatherings or a nice place to add a porch swing. Don't miss the sweet gazebo over the fire pit to keep you cozy on the cooler evenings. This home offers lots of natural light, hardwood floors, spacious laundry room, a treed yard, landscaping, and most importantly a FANTASTIC floorplan! Extras include a humidifier and a whole house water filtration system. Located in a quiet cul-de-sac with the front of the home facing open pasture, this home offers both convenience and serenity. Don't miss this one!
MlsNumber: --
ListingId: 2538869


Listing Provided By: Crown Realty, original listing
Phone: (816) 589-3363
Office Phone: (816) 205-8085
Agent Name: Teresa Ford
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