Struct
cached
booleanfalse
created
Date Time (Etc/UTC)
{ts '2026-06-10 10:56:49'}
executiontime
number0
expires
Date Time (Etc/UTC)
{ts '2026-06-10 11:11:49'}
key
string836B9F5D38F89DFF65025AE3ACE54B83
queryParams
Array
1
Struct
cfsqltype
stringcf_sql_varchar
list
booleanfalse
maxlength
number0
scale
number0
separator
string,
value
stringA
2
Struct
cfsqltype
stringcf_sql_varchar
list
booleanfalse
maxlength
number0
scale
number0
separator
string,
value
stringA
3
Struct
cfsqltype
stringcf_sql_varchar
list
booleanfalse
maxlength
number0
scale
number0
separator
string,
value
stringA
4
Struct
cfsqltype
stringcf_sql_varchar
list
stringtrue
maxlength
number0
scale
number0
separator
string,
value
string626601
server
stringdev-lucee-9
sql
stringSELECT COUNT(*) as TotalRowCount FROM Agents WITH (NOLOCK) LEFT OUTER JOIN agents_preferences WITH (NOLOCK) ON agents_preferences.publicid=Agents.publicid LEFT OUTER JOIN Agents_Links WITH (NOLOCK) ON Agents_Links.publicid=Agents.publicid INNER JOIN Offices WITH (NOLOCK) ON Offices.OfficeID=Agents.OfficeID INNER JOIN companies WITH (NOLOCK) ON companies.companyNumber=Offices.companyNumber OUTER APPLY ( SELECT TOP 1 * FROM Agents_Teams_Members WITH (NOLOCK) WHERE Agents_Teams_Members.publicid=Agents.publicid and agentteamid in ( select agentteamid from agents_teams where status='A' ) ORDER BY Agents_Teams_Members.LastUpdateDateTime DESC ) Agents_Teams_Members OUTER APPLY ( SELECT TOP 1 * FROM Agents_Teams WITH (NOLOCK) WHERE Agents_Teams.AgentTeamID=Agents_Teams_Members.AgentTeamID AND Agents_Teams.Status='A' ) Agents_Teams WHERE (Agents.Status='A') AND ( Agents.publicid in ('626601') )
tags
Array
1
stringagents
2
stringoffices
3
stringagents_preferences
15495 Osage Hog Farm, Springdale, AR 72734 | MLS#: 2546451 | Springdale Real Estate
Struct
cached
booleantrue
created
stringJune, 10 2026 10:56:49 +0000
executiontime
number0
expires
stringJune, 10 2026 11:11:49 +0000
key
string836B9F5D38F89DFF65025AE3ACE54B83
queryParams
Array
1
Struct (ordered)
maxlength
number0
list
booleanfalse
scale
number0
separator
string,
cfsqltype
stringcf_sql_varchar
value
stringA
2
Struct (ordered)
maxlength
number0
list
booleanfalse
scale
number0
separator
string,
cfsqltype
stringcf_sql_varchar
value
stringA
3
Struct (ordered)
maxlength
number0
list
booleanfalse
scale
number0
separator
string,
cfsqltype
stringcf_sql_varchar
value
stringA
4
Struct (ordered)
maxlength
number0
list
stringtrue
scale
number0
separator
string,
cfsqltype
stringcf_sql_varchar
value
string626601
server
stringdev-lucee-9
sql
stringSELECT COUNT(*) as TotalRowCount FROM Agents WITH (NOLOCK) LEFT OUTER JOIN agents_preferences WITH (NOLOCK) ON agents_preferences.publicid=Agents.publicid LEFT OUTER JOIN Agents_Links WITH (NOLOCK) ON Agents_Links.publicid=Agents.publicid INNER JOIN Offices WITH (NOLOCK) ON Offices.OfficeID=Agents.OfficeID INNER JOIN companies WITH (NOLOCK) ON companies.companyNumber=Offices.companyNumber OUTER APPLY ( SELECT TOP 1 * FROM Agents_Teams_Members WITH (NOLOCK) WHERE Agents_Teams_Members.publicid=Agents.publicid and agentteamid in ( select agentteamid from agents_teams where status='A' ) ORDER BY Agents_Teams_Members.LastUpdateDateTime DESC ) Agents_Teams_Members OUTER APPLY ( SELECT TOP 1 * FROM Agents_Teams WITH (NOLOCK) WHERE Agents_Teams.AgentTeamID=Agents_Teams_Members.AgentTeamID AND Agents_Teams.Status='A' ) Agents_Teams WHERE (Agents.Status='A') AND ( Agents.publicid in ('626601') )
tags
Array
1
stringagents
2
stringoffices
3
stringagents_preferences
$685,000
 $3,677 est/mo Sourced by Back At You

15495 Osage Hog Farm,Springdale, AR 72734

Springdale, AR 72734

Share:

PreviousNext

Description

Up to $5000.00 preferred lender credit! Charming home with 4 bedrooms and 3 full baths on a fully fenced 1 acre lot. This stunning property features a private entrance gate and a spacious main home, complete with a shop and a small stable-ideal for a hobby farm. Additionally, there is a shed for convenient tool storage. The home's spacious layout boasts a beautiful kitchen with views of rolling pastures and a nearby river, visible from the kitchen table and covered back deck. The appliances in the kitchen were all replaced in 2023/2024. The basement of the home also features a large game room, a safe room, a full bedroom and bathroom with a separate living area, and two versatile flex rooms. The metal roof was added in 2020. If you are seeking country living with convenient access to I-49, this home is perfect for you, just 10 miles away. This home has a Gentry address but is in Springdale School District. Book your showing today! There is electricity to shop and shed. New well in 2015. Home is 4278 square feet source Appraisal.

Details

MLS #2546451
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusActive
Year2003
Days On Site213
Listing Provided ByOffice Staging Realty | Teresa Sanderson

Features

Bed(s)4
Bath(s) 3 Total
SQ Feet4,278
Garage2
BasementY
Story(s)2
Acreage0.86
Property ViewYes

Exterior

Lot FeaturesFarm, Mature Trees, Rolling Slope, Ranch

Parking

Garage Yes / NoYes
Parking FeaturesAttached, Garage, Storage, Workshop In Garage, Asphalt

Taxes

Tax Annual Amount2472

Area Information

StateAR
CountyWashington(AR)
CitySpringdale
Zip Code72734
Community NameWashington AR Co Unplatted
Sourced by Back At You

Request a showing

Request a showing

Loading Form
MLS Internet Data Exchange (IDX) information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the Back at You MLS.

Contact

Learn More About This Property

Ravi P

Ravi P

123 Realty & Co. - Dina Chen

Accredited Buyer Representative, Certified New Homes Specialist (702) 606-2551ravi.p@backatyou.com
StateAR
CountyWashington(AR)
CitySpringdale
Zip Code72734
Community NameWashington AR Co Unplatted
Sourced by Back At You
Listing Updated: June 8, 2026, 12:42:39 PM UTC
Ravi P
Accredited Buyer Representative,Certified New Homes Specialist
(702) 606-2551
Elko Staging - 1234 Elko St.
Elko, NV 89158

Ravi Sites