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 All Communities Berthoud Eaton Evans Fort Collins Greeley Johnstown LaSalle Loveland Milliken Severance Wellington Windsor   Any Residential Attached Dwelling Income Property Commercial for Lease Commercial for Sale Vacant Land/Lots Farm and Ranch Mobile/Manufactured   Select One 50,000- 175,000 176,000-250,000 251,000- 350,000 351,000 - 500,000 501,000 and above				MLS Number: 558419 Map   3953 Taliesin Way, Fort Collins, CO 80524 General Information Price: $1,250,000 Bedrooms: 4 Baths: 5 Style: 1 Story/Ranch Garage: 3 Car/Attached Subdivision: The Hill at Cobb Lake Elementary School: Eyestone Middle/Jr High: Wellington High School: Poudre General Features Listing Type/Category: Residential Land Size: 1-5 Acres Total Square Feet: 6488 Finished Square Feet: 3161 Total Square Feet (inc basement): 6011 Basement: 3327 Year Built: 2003 Garage Spaces: 3 Heating: Electric Air Filter,Forced Air,Humidifier,Radiant Heat Taxes/Tax Year: 9,990/2008 Association Fees: $2,500 New Construction: Room Information Master Bedroom: 5 Piece Master Bath,Luxury Features Master Bath Note: All room dimensions, including square footage data, are approximate and must be verified by the buyer. Additional Features Type: Design Features: Cathedral/Vaulted Ceilings,Eat-in Kitchen,Open Floor Plan,Separate Dining Room,Stain/Natural Trim,Walk-in Closet,Washer/Dryer Hookups,Wet Bar,Wood Floors,Wood Windows,Kitchen Island,Jack & Jill Bathroom Fireplace: 2+ Fireplaces,Family/Recreation Room Fireplace,Living Room Fireplace Zoning: Res Comments Motivated sellers, bring offer! Wonderful custom home with captivating mtn & water views from every window & 2 acres of rolling prairie create a private retreat just mins from downtown FTC. This exquisite John Dengler designed home has all features for sophisticated living w/casual comfort. Great rm design w/formal din, main flr office/retreat, fully fin bsmt w/wine cellar, wet bar & state of the art home theatre. Not a short sale but priced like one.
Home | About Me | Search Properties | Mortgage Calculator | Community Info | Contact Me Copyright © 2010 The Group, Inc. All rights reserved.
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