Struct
cached
booleantrue
created
stringJune, 10 2026 09:53:53 +0000
executiontime
number0
expires
stringJune, 10 2026 10:08:53 +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
1509 S Cypress Avenue, Broken Arrow, OK 74012 | MLS#: 2603243 | Broken Arrow Real Estate
Struct
cached
booleantrue
created
stringJune, 10 2026 09:53:53 +0000
executiontime
number0
expires
stringJune, 10 2026 10:08:53 +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
$269,000
 $1,444 est/mo Sourced by Back At You

1509 S Cypress Avenue,Broken Arrow, OK 74012

Broken Arrow, OK 74012

Share:

PreviousNext

Description

Full of potential and ready for your vision, this one-owner home has been well maintained and offers strong bones with an excellent layout for those looking to personalize their space. Two separate eating areas and a large walk-in pantry provide flexibility for everyday living and entertaining. Upstairs, you’ll find a versatile bonus areaperfect for a home office or hobby room. Thermal windows add efficiency, while the oversized primary suite is a true retreat with a walk-in closet, private bath, and plenty of room for a seating area. The roof was replaced in September 2024, adding extra peace of mind for the next owner.

Details

MLS #2603243
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusPending
Year1988
Days On Site126
Listing Provided ByOffice Staging Realty | Sarah Buelow

Features

Bed(s)3
Bath(s) 3 Total
SQ Feet2,140
Garage2
Story(s)2
Acreage0.18

Exterior

Lot FeaturesMature Trees

Parking

Garage Yes / NoYes
Parking FeaturesAttached, Garage

Taxes

Tax Annual Amount2037

Location

Community FeaturesGutters

Area Information

StateOK
CountyTulsa
CityBroken Arrow
Zip Code74012
Community NameFairfax West
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 NameFairfax West
Sourced by Back At You
Nearby Listings (Within 1/10 mile)
Price: $201K - $336K
sqft: 1,500 - 2,500
Nearby Listings Property ImageNearby Listings Details
1505 S Cypress Avenue Property Photo 1
$240,000
1505 S Cypress Avenue
Broken Arrow, OK 74012
Listing Updated: June 8, 2026, 12:45:49 PM UTC
Ravi P
Accredited Buyer Representative,Certified New Homes Specialist
(702) 606-2551
Elko Staging - 1234 Elko St.
Elko, NV 89158

Ravi Sites