Craftstar Green / About Us / Careers / Land / Relocation

Craftstar SuperstarsCommunitiesHome PlansQuick Delivery HomesPhoto GalleryFinancingContact Us
User Warning: 
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 SELECT * FROM models WHERE model_id=  
Query Time: 0.0001
Database: craftstar
in /var/www/vhosts/www.willetts.com/wsf/WSF2/database.inc.php on line 41
Communities
You have 1 recently viewed communities.
Models
You have 0 recently viewed models.

Model Description

Model Details

Bedrooms:
Bathrooms:

Elevations

User Warning:
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY caption ASC' at line 1

SELECT * FROM model_floorplans WHERE model_id= ORDER BY caption ASC 
Query Time: 0.0001
Database: craftstar
in /var/www/vhosts/www.willetts.com/wsf/WSF2/database.inc.php on line 41

User Warning: 
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY title' at line 4


                SELECT n.title, n.n_id
                FROM model_neigh_map mnm
                LEFT JOIN neighborhoods n ON mnm.n_id = n.n_id
                WHERE mnm.model_id =  ORDER BY title
         
Query Time: 0.0001
Database: craftstar
in /var/www/vhosts/www.willetts.com/wsf/WSF2/database.inc.php on line 41
AVAILABLE AT...
Search For Your New Home
Register For Updates
Copyright 2010 Craftstar Homes. All Rights Reserved. Brokers Welcome.

CRAFTSTAR HOMES has built an outstanding reputation by offering homes with distinctive designs in superior locations throughout Maryland and Virginia. Recognized for their signature stone front facades and spacious interiors, Craftstar Homes and its companion company, Craftmark Homes, have received numerous awards for design and customer service and is consistently ranked in the top 50 of the largest privately held companies in the Washington Metro area. Craftmark Homes & Craftstar Homes are members of The Craftmark Group.

Elevations shown are artistic concepts. Floorplans may vary by elevation. Room sizes are approximate. Due to our policy of constant improvement, Craftstar Homes reserves the right to change price, plans, specifications or availability of selections without notice or obligation. This website content is not to be used as a basis of contract. Please see your on-site sales representative for the most current pricing, plans and specifications in the community of your choice. The Sales Representative works for the Homebuilder, which means that he or she may assist the Buyer in purchasing the property, but his or her duty of loyalty is only to the Homebuilder.