booleanfalse
Struct
cached
booleantrue
created
stringJune, 10 2026 09:20:34 +0000
executiontime
number0
expires
stringJune, 10 2026 09:35:34 +0000
key
stringEC6020B0FDFBF894A8AD56DD1D89C5A0
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
stringLuxury Expert
5
Struct (ordered)
maxlength
number0
list
booleanfalse
scale
number0
separator
string,
cfsqltype
stringcf_sql_bit
value
string1
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 ( SELECT Agents_Tags.PublicID from Agents_Tags where Agents_Tags.PublicID=Agents.publicid AND Agents_Tags.Tag IN ('Luxury Expert') AND Agents_Tags.isWebsiteTag=1 )
tags
Array
1
stringagents
2
stringoffices
3
stringagents_preferences
3803 Main Avenue, Fargo, ND 58102 | MLS#: 26-79 | Fargo Real Estate
booleanfalse
Struct
cached
booleantrue
created
stringJune, 10 2026 09:20:34 +0000
executiontime
number0
expires
stringJune, 10 2026 09:35:34 +0000
key
stringEC6020B0FDFBF894A8AD56DD1D89C5A0
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
stringLuxury Expert
5
Struct (ordered)
maxlength
number0
list
booleanfalse
scale
number0
separator
string,
cfsqltype
stringcf_sql_bit
value
string1
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 ( SELECT Agents_Tags.PublicID from Agents_Tags where Agents_Tags.PublicID=Agents.publicid AND Agents_Tags.Tag IN ('Luxury Expert') AND Agents_Tags.isWebsiteTag=1 )
tags
Array
1
stringagents
2
stringoffices
3
stringagents_preferences
$2,950,000
( )
 $15,836 est/mo Sourced by Back At You

3803 Main Avenue,Fargo, ND 58102

Fargo, ND 58102

Share:

Description

Strategically located at the high-exposure corner of Main Ave & I-29 (76k+ VPD combined), this Olaf Anderson-built steel-frame building and huge yard offers premium showroom/office space plus fully sprinkled, dock-accessible warehouse. Rare amenities include elevated deck & finished patio w fireplace/kitchen. 2.7+ acres w/ adjacent lot allows expansion, parking, or storage. Available summer 2026.

Details

MLS #26-79
Listing TypeFor Sale
Sub-TypeResale
StatusActive
Year2016
Days On Site136
Listing Provided ByGoldmark Commercial Real Estate, Inc | Andy Westby - DR

Features

Acreage2.71

Area Information

StateND
CountyCass
CityFargo
Zip Code58102
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.
StateND
CountyCass
CityFargo
Zip Code58102
Sourced by Back At You
Nearby Listings (Within 1/2 mile)
Price: $2.212M - $3.687M
sqft: 0 - 0
Listing Updated: June 8, 2026, 12:40:19 PM UTC