Struct
cached
booleantrue
created
stringJune, 10 2026 12:10:37 +0000
executiontime
number0
expires
stringJune, 10 2026 12:25:37 +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
3027 Frontage Road, Moorhead, MN 56560 | MLS#: 25-591 | Moorhead Real Estate
Struct
cached
booleantrue
created
stringJune, 10 2026 12:10:37 +0000
executiontime
number16
expires
stringJune, 10 2026 12:25:37 +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
$3,195,000
( )
 $17,151 est/mo Sourced by Back At You

3027 Frontage Road,Moorhead, MN 56560

Moorhead, MN 56560

Share:

PreviousNext

Description

Unique opportunity to purchase a single-tenant investment property in Moorhead, MN. Located along Hwy 10, this former hotel property has had upgrades as recently as 2022 and a lease in place thru March of 2029. Large signage, 64 rooms, swimming pool, commercial kitchen with new appliances, security system, updated AC/heating units. Neighbors include Target, Walmart, Starbucks, McDonalds & more!

Details

MLS #25-591
Listing TypeFor Sale
Sub-TypeResale
StatusActive
Year1998
Days On Site317
Listing Provided ByGoldmark Commercial Real Estate, Inc | Paul Campbell

Features

Acreage1.69

Area Information

StateMN
CountyClay
CityMoorhead
Zip Code56560
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
StateMN
CountyClay
CityMoorhead
Zip Code56560
Sourced by Back At You
Nearby Listings (Within 1/4 mile)
Price: $2.396M - $3.993M
sqft: 0 - 0
Nearby Listings Property ImageNearby Listings Details
215 30th Street N Property Photo 1
$14
215 30th Street N
Moorhead, MN 56560
2810 2nd Avenue N Property Photo 1
$443,000
2810 2nd Avenue N
Moorhead, MN 56560
2810 2nd Avenue N Property Photo 1
$3,208,000
2810 2nd Avenue N
Moorhead, MN 56560
Listing Updated: June 8, 2026, 12:40:23 PM UTC
Ravi P
Accredited Buyer Representative,Certified New Homes Specialist
(702) 606-2551
Elko Staging - 1234 Elko St.
Elko, NV 89158

Ravi Sites