HOME ABOUT ME SEARCH PROPERTIES MORTGAGE CALCULATOR COMMUNITY INFORMATION CONTACT ME
Database Error: Query invalid: SELECT featured_properties.mls_number, featured_properties.site_id, featured_properties.comment, listing_idx.street_number, listing_idx.street_direction, listing_idx.street_name, listing_idx.street_type, listing_idx.city, listing_idx.state, listing_idx.list_price, listing_idx.photos_multi FROM featured_properties, listing_idx where featured_properties.site_id = 84 and featured_properties.mls_number = listing_idx.mls_number ORDER BY RAND() LIMIT 3
mySQL Error: 145 (Table './realtor/listing_idx' is marked as crashed and should be repaired)Database Error: Next record called with no query pending
mySQL Error: 145 (Table './realtor/listing_idx' is marked as crashed and should be repaired)
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/budrazey.com/httpdocs/lib/db.class.php on line 75
Database Error: Query invalid: SELECT listing_idx.mls_number, listing_idx.street_number, listing_idx.street_direction, listing_idx.street_name, listing_idx.street_type, listing_idx.city, listing_idx.state, listing_idx.list_price, listing_idx.photos_multi FROM listing_idx where mls_number <> 0 /*and photos_multi <> 0*/ and owner = 'group' and agent_name IN ('Bud Razey') ORDER BY RAND() LIMIT 3
mySQL Error: 145 (Table './realtor/listing_idx' is marked as crashed and should be repaired)Database Error: Next record called with no query pending
mySQL Error: 145 (Table './realtor/listing_idx' is marked as crashed and should be repaired)
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/budrazey.com/httpdocs/lib/db.class.php on line 75
Database Error: Query invalid: SELECT listing_idx.mls_number, listing_idx.street_number, listing_idx.street_direction, listing_idx.street_name, listing_idx.street_type, listing_idx.city, listing_idx.state, listing_idx.list_price, listing_idx.photos_multi FROM listing_idx where mls_number <> 0 /*and photos_multi <> 0*/ and owner = 'group' ORDER BY RAND() LIMIT 3
mySQL Error: 145 (Table './realtor/listing_idx' is marked as crashed and should be repaired)Database Error: Next record called with no query pending
mySQL Error: 145 (Table './realtor/listing_idx' is marked as crashed and should be repaired)
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/budrazey.com/httpdocs/lib/db.class.php on line 75
 
 
 


MLS Number: 634018

Map  
652 Sundance Dr, Windsor, CO 80550

General Information
Price: $248,590
Bedrooms: 3
Baths: 3
Style: 2 Story
Garage: 2 Car/Attached
Subdivision: Peakview Estates
Elementary School: Tozer
Middle/Jr High: Windsor
High School: Windsor
General Features
Listing Type/Category: Residential
Land Size: <.25 Acre
Total Square Feet: 3284
Finished Square Feet: 1992
Total Square Feet (inc basement): 1992
Basement: 1332
Year Built: 2010
Garage Spaces: 2
Heating: Forced Air
Taxes/Tax Year: 0/2009
Association Fees: $0
New Construction: yes
Room Information
Master Bedroom: 5 Piece Master Bath
Note: All room dimensions, including square footage data, are approximate and must be verified by the buyer.
Additional Features
Type: Legal, Conforming,Contemporary/Modern
Design Features: Cathedral/Vaulted Ceilings,Separate Dining Room,Open Floor Plan,Pantry,Loft,Walk-in Closet,Washer/Dryer Hookups,Wood Floors,Stain/Natural Trim
Fireplace:
Zoning: Res
Comments


 
The Group Inc. Northern Colorado Real Estate
The Group Inc
Northern Colorado real estate agents, buy your new home from Northern Colorado Real Estate Professionals serving Fort Collins, Loveland, Greeley, Windsor and Northern Colorado