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
510 E Fredericksburg Court, Broken Arrow, OK 74011 | MLS#: 2607449 | Broken Arrow Real Estate
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
$1,225,000
 $6,576 est/mo Sourced by Back At You

510 E Fredericksburg Court,Broken Arrow, OK 74011

Broken Arrow, OK 74011

Share:

PreviousNext

Description

Whether you need space for parents, adult children, extended family, or dedicated staff such as a nanny or caregiver, this exceptional property delivers flexibility, functionality, and refined livingall under one connected roof. The thoughtful design seamlessly links the main home and private secondary residence, offering comfort, independence, and sophisticated style for all. The MAIN HOME features a vaulted, open-concept family room and kitchen accented with striking wood beams, Quartzite counters, an island, ice maker, and a separate pantry with prep area and wine fridge. Entertain in the formal dining room, or unwind by the new cast stone fireplace with paneled feature wall and custom built-ins. The downstairs primary suite is a luxurious retreat, with a heated air-jet tub and heated flooring. A second bedroom and bath currently serve as a convenient office. Upstairs, two additional bedrooms share bath access, complemented by a versatile flex space or game room. The SECONDARY RESIDENCE mirrors the same high level of craftsmanship, with a vaulted family room, kitchen, and dining area featuring wood beams and ceiling detail. Two bedrooms and two full baths create a private, elegant living space. EACH RESIDENCE INCLUDES its own three-car garage, covered patio, plantation shutters, motorized blinds, and custom built-ins. The main home also offers a brand-new outdoor kitchen, and the shared gunite pool and hot tub are perfectly positioned for relaxation and entertaining. SET ON TWO LOTS (legally combined to one parcel for tax/Homestead purposes) in the prestigious gated Lakes community near Indian Springs Country Club and golf course, this custom-built, recently updated home backs to a private stocked fishing pond with serene views. Residents enjoy walking trails, a park, and pet-friendly amenities, perfectly balancing luxury living with lifestyle.

Details

MLS #2607449
Listing TypeFor Sale
StyleHouse
HOA Dues$3,000
Sub-TypeResale
StatusActive
Year2009
Days On Site97
Listing Provided ByOffice Staging Realty | Corrie Egge

Features

Bed(s)5
Bath(s) 6 Total
SQ Feet5,283
Garage6
PoolYes
Story(s)2
Acreage0.87

Exterior

Lot FeaturesCul De Sac, Mature Trees

Parking

Garage Yes / NoYes
Parking FeaturesAttached, Garage, Garage Faces Side, Storage

Taxes

Tax Annual Amount12866

Location

Community FeaturesGutters, Sidewalks

Area Information

StateOK
CountyTulsa
CityBroken Arrow
Zip Code74011
Community NameThe Lakes at Indian Springs III
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 Code74011
Community NameThe Lakes at Indian Springs III
Sourced by Back At You
Nearby Listings (Within 1/4 mile)
Price: $918K - $1.531M
sqft: 3,500 - 6,500
Nearby Listings Property ImageNearby Listings Details
305 E Decatur Street Property Photo 1
$699,000
305 E Decatur Street
Broken Arrow, OK 74011
301 E Glendale Street S Property Photo 1
$789,000
301 E Glendale Street S
Broken Arrow, OK 74011
Listing Updated: June 8, 2026, 12:50:37 PM UTC
Ravi P
Accredited Buyer Representative,Certified New Homes Specialist
(702) 606-2551
Elko Staging - 1234 Elko St.
Elko, NV 89158

Ravi Sites