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: 633808 Map   1500 Glenmere Rd, Greeley, CO 80631 General Information Price: $299,000 Bedrooms: 4 Baths: 3 Style: 2 Story Garage: 2 Car/Attached Subdivision: Glenmere Heights Elementary School: Jackson Middle/Jr High: Heath High School: Greeley Central General Features Listing Type/Category: Residential Land Size: <.25 Acre Total Square Feet: 3595 Finished Square Feet: 3595 Total Square Feet (inc basement): 3595 Basement: 703 Year Built: 1938 Garage Spaces: 2 Heating: Forced Air,Baseboard Heat Taxes/Tax Year: 1,701/2009 Association Fees: $0 New Construction: Room Information Master Bedroom: Luxury Features Master Bath,Tub+Shower Master,5 Piece Master Bath Note: All room dimensions, including square footage data, are approximate and must be verified by the buyer. Additional Features Type: Tudor,Victorian Design Features: Cathedral/Vaulted Ceilings,Bay or Bow Window,Eat-in Kitchen,Open Floor Plan,Pantry,Skylights,Separate Dining Room,Stain/Natural Trim,Walk-in Closet,Washer/Dryer Hookups,Wet Bar,Jack & Jill Bathroom,Kitchen Island,Media Room,Wood Floors Fireplace: Gas Fireplace Zoning: Res Comments Unique, classic Tudor home in the heart of prestigous Glenmere area. Original special features + lots of updating. Mstr ste is complete 2nd flr & incl huge bd w/skylights, separate library & luxury claw ft tub which completes Swiss Chalet feeling! Gour kit w/2 islands & tons of custom cabinets, gas range & access to sunrm & form din rm. Corner lot w/mature trees, private backyard & alley access. Liv rm boasts original wood beams, gas frplc & wood flrs. Bsmt has wetbar, game rm & bd w/private ba.
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