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
2252 S Troost Avenue, Tulsa, OK 74114 | MLS#: 2604883 | Tulsa 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
$849,900
 $4,562 est/mo Sourced by Back At You

2252 S Troost Avenue,Tulsa, OK 74114

Tulsa, OK 74114

Share:

Description

Nestled in the heart of Midtown, this beautifully restored five-bedroom, four-bath residence blends timeless character with upscale amenities. Originally crafted with enduring charm, the home underwent a thoughtful remodel in 2016, preserving its historic integrity while introducing refined updates throughout. Designed for both comfort and entertainment, the home offers versatile living spaces including a private office, formal dining room, game room, and a cozy breakfast nook. The gourmet kitchen opens seamlessly to two inviting outdoor living areas, complete with a covered deck, built-in outdoor kitchen, and a heated "spool" (spa/pool) for year-round enjoyment. Additional conveniences include laundry rooms on both the main and upper levels. Whether you're hosting guests or seeking an investment, this property has served as a successful Airbnb, offering exceptional flexibility. Furnishings are negotiable for a turnkey experience. Located just a 5-minute walk from St. John and Utica Square, and a 10-minute stroll to Cascia Hall and Woodward Park, this home offers a rare opportunity to own a piece of Tulsa history in one of its most desirable neighborhoods.

Details

MLS #2604883
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusActive
Year1929
Days On Site118
Listing Provided ByOffice Staging Realty | Kimberly Brewer

Features

Bed(s)4
Bath(s) 4 Total
SQ Feet3,340
BasementY
PoolYes
Story(s)2
Acreage0.15

Exterior

Lot FeaturesMature Trees

Parking

Garage Yes / NoNo

Taxes

Tax Annual Amount12788

Location

Community FeaturesGutters

Area Information

StateOK
CountyTulsa
CityTulsa
Zip Code74114
Community NameTerwilleger Heights
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
CountyTulsa
CityTulsa
Zip Code74114
Community NameTerwilleger Heights
Sourced by Back At You
Nearby Listings (Within 1/10 mile)
Price: $637K - $1.62M
sqft: 2,500 - 4,000
Nearby Listings Property ImageNearby Listings Details
2251 S Saint Louis Avenue Property Photo 1
$649,900
2251 S Saint Louis Avenue
Tulsa, OK 74114
Listing Updated: June 8, 2026, 12:47:38 PM UTC