Struct
cached
booleantrue
created
stringJune, 10 2026 10:24:01 +0000
executiontime
number2
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
4113 W Canton Street, Broken Arrow, OK 74012 | MLS#: 2607676 | Broken Arrow 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
$2,250
 $12 est/mo Sourced by Back At You

4113 W Canton Street,Broken Arrow, OK 74012

Broken Arrow, OK 74012

Share:

Description

Discover this spacious and impressive home in the Union school district, located in Pembrooke Park addition. Boasting a brand-new interior paint and beautiful hardwood floors for effortless cleaning and well-designed layout. Enjoy 2 living areas, with the option to convert one into a flex room, an open kitchen and secluded laundry room. The master bedroom and bath are conveniently situated on the 1st floor, while 2 additional bedrooms, a gameroom, and full bathroom are upstairs. The tranquil backyard offers ample shade. Deposit is $2250

Details

MLS #2607676
Listing TypeFor Lease
StyleHouse
StatusActive
Year2001
Days On Site97
Listing Provided ByOffice Staging Realty | Mandy Jiles-Kidd

Features

Bed(s)3
Bath(s) 3 Total
SQ Feet2,985
Garage2
Story(s)2
Zoningres

Parking

Garage Yes / NoYes
Parking FeaturesGarage, Two Car Garage

Area Information

StateOK
CountyTulsa
CityBroken Arrow
Zip Code74012
Community NamePembrooke Park Blk 13 17
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
CityBroken Arrow
Zip Code74012
Community NamePembrooke Park Blk 13 17
Sourced by Back At You
Nearby Listings (Within 1/4 mile)
Price: $1K - $2K
sqft: 2,000 - 3,500
Listing Updated: June 8, 2026, 12:47:43 PM UTC