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: 634019

Map  
662 Yukon Ct, Windsor, CO 80550

General Information
Price: $294,393
Bedrooms: 3
Baths: 3
Style: 2 Story
Garage: 3 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: 3439
Finished Square Feet: 2134
Total Square Feet (inc basement): 2134
Basement: 1305
Year Built: 2009
Garage Spaces: 3
Heating: Forced Air
Taxes/Tax Year: 0/2009
Association Fees: $0
New Construction: yes
Room Information
Master Bedroom: Full 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,Open Floor Plan,Pantry,Walk-in Closet,Washer/Dryer Hookups,Wood Floors,Stain/Natural Trim,Separate Dining Room
Fireplace:
Zoning: Res
Comments


Pre-sale with upgrades
 
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