 |
|
MLS Number: 606914
|
 Map
|
887 Blue Heron Ln, Fort Collins, CO 80524
|
|
General Information
|
| Price: |
$1,269,000 |
| Bedrooms: |
5 |
| Baths: |
5 |
| Style: |
2 Story |
| Garage: |
3 Car/Attached |
| Subdivision: |
Country Squire Estates |
| Elementary School: |
Cache La Poudre |
| Middle/Jr High: |
Cache La Poudre |
| High School: |
Poudre |
|
|
General Features
|
| Listing Type/Category: |
Residential |
| Land Size: |
5-10 Acres |
| Total Square Feet: |
4560 |
| Finished Square Feet: |
4560 |
| Total Square Feet (inc basement): |
4560 |
| Basement: |
0 |
| Year Built: |
2000 |
| Garage Spaces: |
3 |
| Heating: |
Radiant Heat |
| Taxes/Tax Year: |
6,487/2008 |
| Association Fees: |
$200 |
| New Construction: |
|
|
|
Room Information
|
| Master Bedroom: |
Tub+Shower Master,Luxury Features Master Bath,5 Piece Master Bath |
|
| Note: All room dimensions, including square footage data, are approximate and must be verified by the buyer. |
|
Additional Features
|
| Type: |
|
| Design Features: |
Eat-in Kitchen,Stain/Natural Trim,Separate Dining Room,Walk-in Closet,Pantry |
| Fireplace: |
Multi-sided Fireplace,Basement Fireplace,2+ Fireplaces,Family/Recreation Room Fireplace,Gas Logs Included,Master Bedroom Fireplace,Gas Fireplace,Great Room Fireplace |
| Zoning: |
open |
|
|
Comments
|
Do you love Water- Privacy-a Separate Studio for your hobbies/guests? Do you love the Santa Fe look and feel- sitting on your deck-patio-or balcony and enjoying the peace and quiet- views of the foothills and water? Then this lakefront hideaway is perfect for you! 3 miles to downtown. This one-of-a-kind home has it all; stainless steel appliances, cherry cabinets, tile floors, built-ins, art niches and personality! 10 Acres plus lake front! Check out our virtual tour! |
|
|
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 ('Meredith Mayer')
ORDER BY RAND() LIMIT 2
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/meredithmayer.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 2
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/meredithmayer.com/httpdocs/lib/db.class.php on line 75
 | Rare Southwest Style Home Right on Terry Lake with Spectacular Mountain Views
887 Blue Heron Ln
Fort Collins
$1,269,000
more info | |
Home |
About Me |
Search Properties |
Community Information |
Mortgage Calculator |
Tips & Hints |
Contact Me 
Home |
About Me |
Search Properties |
Community Information |
Tips & Hints |
Contact Me 