Title Page Background
DEBUG FN args: Array ( [0] => 3319 [1] => [2] => [3] => agent ) BEFORE: Site: 3319 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3319 Igate: njhud LocID: 3319 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3319 [1] => [2] => [3] => lender ) BEFORE: Site: 3319 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3319 Igate: njhud LocID: 3319 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3319 [1] => [2] => [3] => other ) BEFORE: Site: 3319 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3319 Igate: njhud LocID: 3319 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2211 Yellowstone Dr
Barling, AR 72923

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2561 Square Feet
Agency: Chuck Fawcett Realty FSM

Map Details Show Map | Show StreetView




House Features

Appliances: Microwave, Refrigerator
Architectural Style: Other
Construction Materials: Brick
Flooring: Carpet, Tile, Wood, Tile - Ceramic
Heating: Central Furnace, Fireplace
Interior Features: Ceiling Fans, Pantry, Blinds, Eat-in-kitchen, Granite Counters, Attic Storage, Cathedral Ceiling
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3

Window Features

Exterior Features: Fence, Vinyl Siding
Fencing: Fenced
Parking Features: Garage
Roof: Shingle

Neighborhood/Schools

Elementary School/District: Barling
Middle/Junior High School/District:
High School/District: Northside
Subvidision Name: Ebbing 82-Phase1

Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
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. <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: --


Listing Provided By: Chuck Fawcett Realty FSM, original listing
Phone: (479) 484-5588
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