| |
North Carolina
Mountain Real Estate for Sale
Ashe
County, North Carolina - Imagine living in the heart
of the Blue Ridge Country, viewing the magnificence
of the sparkling New River and brilliant blue skies of
the Western North Carolina Mountains. Located in the
heart of “The High Country”, Ashe County offers
something for everyone.
The Blue Ridge Mountains have long been home to some
of the friendliest people around and some of the
best Mountain Real Estate available. From vacation
cabins and farms to raw land, Ashe County Real Estate
will be an investment with many happy returns.
Century 21 Heritage Realty has 11 Realtors who love
Ashe County and their North Carolina Mountain
communities. These professionals offer a variety of
Real Estate services, all designed to accommodate
YOU, the customer. We are also licensed in Virginia
and Tennessee and can assist you in surrounding
counties other than Ashe, such as Watauga, Wilkes,
and Alleghany.
|
 |
<%
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "DSN=greattrainrealestate"
' SQLStmt = "SELECT * FROM Residential order by RAND() limit 1"
SQLStmt = "SELECT * FROM residential WHERE featured = 1"
set r1 = connection.execute(SQLStmt)
if r1.eof = true then
SQLStmt = "SELECT * FROM Residential order by RAND() limit 1"
set r1 = connection.execute(SQLStmt)
end if
if r1.eof = FALSE then
%>
">![](images/<%= r1("THUMBNAIL") %>)
ID: <%= r1("Property_ID") %> <%= makeCurr(r1("price")) %>
<% Else %>
<% End If
Connection.Close %>
|
 |
|
|
| |
We are located in West Jefferson, NC in a
wonderfully remodeled log cabin office in an
excellent location of Ashe County. Call or come by
our office and let us tell you how owning Real
Estate in Ashe County, North Carolina could make
your Blue Ridge Mountain dreams come true!
If you have any questions or would like more
information, please contact us toll free at
800.865.4221 or 336.246.2664,
email us,
or use our
online request
form. |
|
