         
 |
 |
You'll find a relaxed quality of life in the
mountains in and around Mars Hill and the Wolf Laurel area. We offer
a full service real estate agency that features residential, lots
and acreage, and condominium sales in the Wolf Laurel area.
|
<%
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "DSN=my_wolflaurel"
' SQLStmt = "SELECT * FROM Residential order by RAND() limit 1"
SQLStmt = "SELECT * FROM residential WHERE featured = 1"
set r1 = connection.execute(SQLStmt)
if r1.eof = FALSE then
%>
">![](images/<%= r1("THUMBNAIL") %>) |
| MLS: <%= r1("Property_ID") %> | <%= makeCurr(r1("price")) %> |
">
 |
<%
else
' Show Random
SQLStmt = "SELECT * FROM Residential order by RAND() limit 1"
set r1 = connection.execute(SQLStmt)
if r1.eof = FALSE then
if r1("featured") <> 0 then
%>
| "> |
| MLS: <%= r1("Property_ID") %> | <%= makeCurr(r1("price")) %> |
| ">
|
<%
end if
end if
end if
Connection.Close %>
|
We believe in the concept of listening to our client's wishes and
taking the time to understand just what your real estate needs and
desires are. Whether you are looking for a new home or
condominium, wooded privacy or high elevations, we have the
experience and knowledge of the area to make those wishes and
desires a reality. That's why we like to say that we offer
"real estate services on a higher level." |
 We
invite you to look around our website for more information about the
area, our location and of course to view our featured listings.
If you don't see just what you're looking for, don't fret.
Contact us by phone at 828-680-9777 or toll free at 1-800-221-0409, email or use our convenient
ONLINE
REQUEST FORM and let us know what you're looking for and we'll do
our best to assist you.
Our area is also a wonderful vacation destination and we offer many
great log cabin rentals, condominiums and more...all close to
skiing, golf, hiking, biking and more. Wolf Laurel Resort is
the best place to spend quality time with family and friends. Please
click here
to visit our rental website.
 |
sitemap
Copyright © 2007
Wolf Mountain Realty.
North Carolina Web Designers
by AppNet.com
|