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 = 3319 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 3319 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 3319 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

2211 Yellowstone Dr
Barling, AR 72923

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2561
Agency: Chuck Fawcett Realty INC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1998
Notes: Nestled in Ebbing 82 at The Ranch, this inviting home offers a blend of modern upgrades and spacious living. Situated on right over 1.5 acres of land, this property boasts three bedrooms and three bathrooms, ideal for comfortable living. In addition the home is equipped with solar panels that offers a low electric bill. <br /> Upon entering, you'll notice a cozy fireplace with a fresh ambiance created by new paint and flooring throughout the home. The kitchen has been tastefully updated with refreshed cabinets, new granite countertops, and modern appliances including a new oven, refrigerator, microwave, and dishwasher, making meal preparation a joy. The living spaces are enhanced with new ceiling fans, receptacles, and switches, adding both style and functionality. The primary suite is generously sized, featuring a newly tiled walk-in shower in the ensuite bathroom, and a whirlpool tub providing a luxurious retreat. For convenience and storage, the home includes a large two-car garage along with two additional covered parking spaces. An added bonus is the partially floored attic, offering ample room for storing belongings and seasonal items.<br /> Outside, the property offers a beautiful front porch made for sitting and sipping sweet tea! The yard offers plenty of space for outdoor activities and potential landscaping projects. Whether relaxing indoors or enjoying the spacious outdoors, this updated home in The Ranch offers a delightful combination of modern amenities and tranquil living, perfect for those seeking comfort and convenience in a beautiful setting.
MlsNumber: 1071968


Listing Provided By: Chuck Fawcett Realty INC, original listing
Name: Chuck Fawcett Realty INC
Phone: (479) 484-5588
Office Name: Chuck Fawcett Realty FSM
Office Phone: (479) 484-5588
Agent Name: Jeannie Wester
Disclaimer: Copyright © 2024 Fort Smith Board of Realtors. 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