Struct
cached
booleantrue
created
stringJune, 10 2026 10:24:01 +0000
executiontime
number4
expires
stringJune, 10 2026 10:39:01 +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
16716 E 42nd Place S, Tulsa, OK 74134 | MLS#: 2604143 | Tulsa Real Estate
Struct
cached
booleantrue
created
stringJune, 10 2026 10:24:01 +0000
executiontime
number0
expires
stringJune, 10 2026 10:39:01 +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
$559,000
 $3,001 est/mo Sourced by Back At You

16716 E 42nd Place S,Tulsa, OK 74134

Tulsa, OK 74134

Share:

Description

Welcome to this stunning 5-bedroom, 3.5-bath home nestled in the heart of Sunset Hills Estates, one of the area's most sought-after, family-oriented neighborhoods. From the moment you step inside, you're greeted by a sense of space, style, and effortless comfort. The heart of the home is the show-stopping kitchen that is beautifully designed with generous counter space, quality finishes, and seamless flow into the spacious living area. Making it perfect for everyday life and unforgettable gatherings. Natural light pours in, highlighting the open layout and creating a warm, inviting atmosphere throughout. Designed with both function and luxury in mind, this home offers five generously sized bedrooms, three of those bedrooms being downstairs! Ideal for growing families, guests, or a flex space. The primary suite is a true retreat, featuring a spa inspired bath and ample closet space, while the additional bathrooms are thoughtfully appointed to serve busy households with ease. Whether you're hosting, relaxing, or making memories, this home delivers it all. Space to spread out, room to come together, and a neighborhood that truly feels like home. A rare opportunity to own a beautiful property in Sunset Hills Estates. Priced to sell at $559,000. This one is simply unforgettable!

Details

MLS #2604143
Listing TypeFor Sale
StyleHouse
HOA Dues$755
Sub-TypeResale
StatusPending
Year2021
Days On Site124
Listing Provided ByOffice Staging Realty | Jennifer M Robertson

Features

Bed(s)5
Bath(s) 4 Total
SQ Feet3,333
Garage3
Story(s)2
Acreage0.19

Exterior

Lot FeaturesNone

Parking

Garage Yes / NoYes
Parking FeaturesAttached, Garage

Taxes

Tax Annual Amount6859

Location

Community FeaturesGutters, Sidewalks

Area Information

StateOK
CountyTulsa
CityTulsa
Zip Code74134
Community NameSunset Hills Estates
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 Code74134
Community NameSunset Hills Estates
Sourced by Back At You
Nearby Listings (Within 1/4 mile)
Price: $419K - $698K
sqft: 2,500 - 4,000
Listing Updated: June 8, 2026, 12:43:39 PM UTC