<% Set ListConn = Server.CreateObject("ADODB.Connection") ListConn.Open "remax" SQLQuery = "SELECT * FROM [Data Sheet] WHERE ID = "& request("ID") &"" Set list_query = ListConn.Execute(SQLQuery) response.write ("") %>
 
Beautiful, well-maintained home!

<%= list_query("Address") %>Address: 2297 N. Cottontail Drive

MLS# 44740

Price: $244,900
<%= list_query("school") %>

 

This is a classy home in Fiddlers Canyon built in 2003.  Main level is finished with tile flooring, neutral & tasteful color scheme, and beautiful knotty cherry cabinets and fireplace.  There are 3 bedrooms and 2 baths and appx. 1640 square feet on main floor.  Basement is appx. 1630 sq/ft and is framed for 2 bedrooms, 1 bath, and a family room.  Master bath has jetted tub with nice tile detail.  Exterior is finished in vinyl siding and brick; there is a covered porch plus a deck in back.  0.32-acre large corner lot is partially landscaped (landscaping has sprinkler system) and is partially fenced.  The 2-car garage is oversized and extra deep. A beautiful, well-maintained home in a nice neighborhood

Note to interested buyers:  Ask The Stauffer Team about use of additional property to the north of this great home.

**Square footage an estimate--buyer to verify.

Click here for printable brochure

Information deemed reliable but not guaranteed. 

Return to Listings

Quick Contact
Please contact me regarding this listing.

Your Name:
 Phone:
 Email:
Property:
 Other Comments: