Struct
cached
booleantrue
created
stringJune, 10 2026 10:41:48 +0000
executiontime
number0
expires
stringJune, 10 2026 10:56: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
1501 E Fairview Avenue, Sapulpa, OK 74066 | MLS#: 2608163 | Sapulpa Real Estate
Struct
cached
booleantrue
created
stringJune, 10 2026 10:41:48 +0000
executiontime
number0
expires
stringJune, 10 2026 10:56: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
$625,000
 $3,355 est/mo Sourced by Back At You

1501 E Fairview Avenue,Sapulpa, OK 74066

Sapulpa, OK 74066

Share:

Description

Custom built home in a desirable location with a stunning view. This home has it all. 3 bedrooms, 3.5 baths, spacious open living with plenty of natural light. Large 3 car garage, and tons of storage throughout. Located on a quiet more than 1/2-acre lot the views from every room are amazing. From your breakfast room to your Florida room, you can see forever. Full walkout basement that has a perfect second living area for relatives. Court House Records show the house has 3800 sq ft of luxury for you and your family. Roof installed 2019. Come see today!

Details

MLS #2608163
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusActive
Year2003
Days On Site88
Listing Provided ByOffice Staging Realty | Bradd Bingman

Features

Bed(s)3
Bath(s) 4 Total
SQ Feet3,800
Garage3
BasementY
Story(s)2
Acreage0.60
Property ViewYes

Exterior

Lot FeaturesCul De Sac

Parking

Garage Yes / NoYes
Parking FeaturesAttached, Garage, Shelves, Storage

Taxes

Tax Annual Amount5384

Location

Community FeaturesGutters

Area Information

StateOK
CountyCreek
CitySapulpa
Zip Code74066
Community NameCreek Co Unplatted
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
CountyCreek
CitySapulpa
Zip Code74066
Community NameCreek Co Unplatted
Sourced by Back At You
Listing Updated: June 8, 2026, 12:51:06 PM UTC