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

4254 S 94th Road
Bolivar, MO 65613
Jacquetta R Hensley with Missouri Home, Farm & Land Realty, LLC, original listing - (417) 327-6483

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $997,500
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3533 Square Feet
Agency: Missouri Home, Farm & Land Realty, LLC
Agency Phone: (417) 327-6483

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: Let us Welcome you to Oak Springs! This Custom Built, Millstone Homes design was crafted in 2020 & is nestled quaintly inside a Gated Community just North of Bolivar. The Home features 3,533 sq feet of living space w/ 3 Beds, 2.5 Bath, 3 Car Garage & scenes straight from a magazine cover! The Home was well built w/2x6 walls & offers Zoned Dual Fuel Heat for Energy Efficiency! The Brick & Stone Exterior w/ Black accents set the stage for this Parklike Beauty! The home is situated so that it offers some of the most Beautiful Sunrise views you'll ever see. Upon entering the home, the Wow Factor will instantly take your breath away starting w/ the Large Livingroom w/unique ceiling, Stone accented Gas Fireplace & Manufactured Hardwood flooring. The Kitchen offers chic White Cabinetry, Quartz Counter Tops w/ stainless GE Cafe appliances, (Including- Double Oven w/ French doors, Dishwasher, Microwave & Refrigerator. The Large Island also offers Quartz counter tops & more storage, add Formal Dining Room and Breakfast Nook which adds plenty of room for entertaining. The large laundry room provides an additional sink & cabinetry. The spacious Master Bedroom also contains another Stone accented Gas Fireplace & amazing views. The Master Bath comes complete w/ a soaker tub, oversized walk-in tile shower w/ deco band & a Vanity we all know she'll Love! The master closet comes complete w/ an abundance of closet features including her very own built-in shoe/handbag carousel! The house also offers an Office with beverage center, French doors, gated patio & views of the Community Pond w/ Fountain! Another favorite is the Large Media room w/ 85'' TV & tiered Theatre seating as well as surround sound (all tv's, media equipment & the top tier of seating remain w/ the home).
MlsNumber: --
ListingId: 60274002


Listing Provided By: Missouri Home, Farm & Land Realty, LLC, original listing
Phone: (417) 327-6483
Office Phone: (417) 327-6483
Agent Name: Jacquetta R Hensley
Disclaimer: Copyright © 2024 Southern Missouri Regional MLS, LLC (SOMO). 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