Struct
cached
booleantrue
created
stringJune, 10 2026 10:26:48 +0000
executiontime
number10
expires
stringJune, 10 2026 10:41:48 +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
Struct
cached
booleantrue
created
stringJune, 10 2026 10:26:48 +0000
executiontime
number0
expires
stringJune, 10 2026 10:41:48 +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
1423 S Delaware Avenue, Tulsa, OK 74104 | MLS#: 2546995 | Tulsa Real Estate
Struct
cached
booleantrue
created
stringJune, 10 2026 10:26:48 +0000
executiontime
number15
expires
stringJune, 10 2026 10:41:48 +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
$249,900
 $1,342 est/mo Sourced by Back At You

1423 S Delaware Avenue,Tulsa, OK 74104

Tulsa, OK 74104

Share:

PreviousNext

Description

You have found a complete gem! Look at this adorable bungalow home that has been completely updated with stylish and timeless finishes. It is located minutes from TU Campus, Utica Square and Mother Road Market for shopping and restaurants, and the Tulsa Fair grounds for year-round events and fun! This home is in the desirable neighborhood Rosemont Heights and features 2 spacious bedrooms, 1 bathroom with a beautifully tiled shower, two dining areas, and a large laundry room. The backyard features a new deck and fire pit area, great for having friends or family over. This property is an active and very successful short-term rental and would make a great investment (even a long-term rental due to proximity to TU), or a primary residence. Schedule your showing today and you could be home for the holidays!

Details

MLS #2546995
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusPending
Year1935
Days On Site208
Listing Provided ByOffice Staging Realty | Baylee Williamson

Features

Bed(s)2
Bath(s) 1 Total
SQ Feet1,205
Story(s)1
Acreage0.16

Exterior

Lot FeaturesMature Trees

Parking

Garage Yes / NoNo
Parking FeaturesDriveway, Parking Pad

Taxes

Tax Annual Amount2310

Area Information

StateOK
CountyTulsa
CityTulsa
Zip Code74104
Community NameRosemont 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.

Contact

Learn More About This Property

Ravi P

Ravi P

Accredited Buyer Representative, Certified New Homes Specialist (702) 606-2551ravi.p@backatyou.com
StateOK
CountyTulsa
CityTulsa
Zip Code74104
Community NameRosemont Heights
Sourced by Back At You
Nearby Listings (Within 1/4 mile)
Price: $187K - $312K
sqft: 904 - 1,500
Nearby Listings Property ImageNearby Listings Details
1325 S Delaware Avenue Property Photo 1
$197,000
1325 S Delaware Avenue
Tulsa, OK 74104
1315 S Evanston Avenue Property Photo 1
$275,000
1315 S Evanston Avenue
Tulsa, OK 74104
Listing Updated: June 8, 2026, 12:47:24 PM UTC

logos here

Ravi P -

Real Estate Links Our Domains