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
2429 S Umbrella Avenue, Broken Arrow, OK 74012 | MLS#: 2544971 | Broken Arrow Real Estate
Struct
cached
booleantrue
created
stringJune, 10 2026 10:24:01 +0000
executiontime
number15
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
$424,000
 $2,276 est/mo Sourced by Back At You

2429 S Umbrella Avenue,Broken Arrow, OK 74012

Broken Arrow, OK 74012

Share:

PreviousNext

Description

PRICE REDUCED and UPDATES THIS WEEK: ***New Roof 12/9/25, new paint in master suite and 2 bedrooms, and carpet allowance with strong offer. *** This two-story beauty in Pembrook Park checks all the boxes! It features 4 bedrooms, 3 full baths, a study, a 3-car garage, and a 5th room that can double as a game room. The downstairs centers around the newly updated kitchen (2024) which includes an eat in breakfast nook open to the living room, a formal dining room, and a dedicated office space. The downstairs master suite includes an oversized room that can accommodate large furniture, a large master closet, and newly remodeled bathroom (2024) with modern shower and new oversized bathtub. It also includes a highly sought after additional 2 bedrooms on first floor with additional full bath. The upstairs space includes a bedroom and full bath, a substantial sized 5th room that can function as a game room/media room or bedroom, and walk-in attic space. Other upgrades include new windows throughout home in 2022, exterior paint in 2022, new interior paint in hallway/ kitchen/master bath in 2025, and surround sound system. New HVAC systems installed in 2025. The lot has been professionally landscaped for low maintenance with backyard patio featuring sufficient space for patio furniture/entertaining, a shed for extra storage, full fence, and French drains. The neighborhood is quiet and established, offers a park and pond, and is conveniently located near the Creek Turnpike

Details

MLS #2544971
Listing TypeFor Sale
StyleHouse
HOA Dues$225
Sub-TypeResale
StatusPending
Year2000
Days On Site224
Listing Provided ByOffice Staging Realty | Kimberly Hoffman

Features

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

Exterior

Lot FeaturesNone

Parking

Garage Yes / NoYes
Parking FeaturesAttached, Garage, Shelves

Taxes

Tax Annual Amount3842

Location

Community FeaturesGutters

Area Information

StateOK
CountyTulsa
CityBroken Arrow
Zip Code74012
Community NamePembrooke Park
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

123 Realty & Co. - Dina Chen

Accredited Buyer Representative, Certified New Homes Specialist (702) 606-2551ravi.p@backatyou.com
StateOK
CountyTulsa
CityBroken Arrow
Zip Code74012
Community NamePembrooke Park
Sourced by Back At You
Nearby Listings (Within 1/4 mile)
Price: $318K - $530K
sqft: 2,000 - 4,000
Nearby Listings Property ImageNearby Listings Details
2405 S Willow Avenue Property Photo 1
$338,000
2405 S Willow Avenue
Broken Arrow, OK 74012
2449 S Tamarack Avenue Property Photo 1
$418,000
2449 S Tamarack Avenue
Broken Arrow, OK 74012
4113 W Canton Street Property Photo 1
$2,250
4113 W Canton Street
Broken Arrow, OK 74012
Listing Updated: June 8, 2026, 12:45:24 PM UTC
Ravi P
Accredited Buyer Representative,Certified New Homes Specialist
(702) 606-2551
Elko Staging - 1234 Elko St.
Elko, NV 89158

Ravi Sites