Struct
cached
booleantrue
created
stringJune, 10 2026 10:08:54 +0000
executiontime
number0
expires
stringJune, 10 2026 10:23:54 +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
825 N Summer Tree Drive, Ada, OK 74820 | MLS#: 2526974 | Ada Real Estate
Struct
cached
booleantrue
created
stringJune, 10 2026 10:08:54 +0000
executiontime
number0
expires
stringJune, 10 2026 10:23:54 +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
$120,000
 $644 est/mo Sourced by Back At You

825 N Summer Tree Drive,Ada, OK 74820

Ada, OK 74820

Share:

Description

FULLY UPDATED & MOVE-IN READY IN COUNTRY PLACE ADDITION! Welcome home to this beautifully refreshed 2-bedroom, 1-bathroom gem located in the quiet and conveniently located Country Place Addition on Ada’s east side. Built in 1984 and thoughtfully updated from top to bottom, this home is packed with style, comfort, and functionality. Step inside to find fresh interior paint, updated vinyl and tile flooring throughout the main areas, and cozy carpet in the bedrooms. The charming galley kitchen features freshly painted naval blue cabinets, modern hardware, and stainless steel appliancesall of which stay with the home! The adjacent dining space includes a discreet laundry closet for added convenience. The fully remodeled bathroom boasts a custom-tiled tub/shower combo and stylish finishes. Every detail has been thoughtfully designed to offer a fresh, modern feel while maintaining warmth and comfort. Outside, enjoy a spacious backyard with a new privacy fence and a brand-new concrete patio, perfect for relaxing or entertaining. Plus, the roof and central heat and air will be replaced prior to closing, offering peace of mind for years to come. A one-car attached garage adds extra storage or parking. Tucked into a quiet neighborhood just minutes from Walmart, McDonald’s, and other east side amenities, this home checks all the boxeswhether you’re a first-time buyer, downsizing, or adding to your investment portfolio. This one is turn-key, updated, and priced to moveschedule your tour today!

Details

MLS #2526974
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusPending
Year1984
Days On Site338
Listing Provided ByOffice Staging Realty | Christina Franklin

Features

Bed(s)2
Bath(s) 1 Total
SQ Feet832
Garage1
Story(s)1
Acreage0.31

Exterior

Lot FeaturesMature Trees

Parking

Garage Yes / NoYes
Parking FeaturesAttached, Garage, Shelves

Taxes

Tax Annual Amount645

Location

Community FeaturesGutters

Area Information

StateOK
CountyPontotoc
CityAda
Zip Code74820
Community NameCountry Place
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.
StateOK
CountyPontotoc
CityAda
Zip Code74820
Community NameCountry Place
Sourced by Back At You
Listing Updated: June 8, 2026, 12:41:52 PM UTC