Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 293 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 293 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 293 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

610 S Coleman Ave
Holyoke, CO 80734
Shannon Schlachter with National Land Realty, Holyoke, CO, original listing - (855) 384-5263

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $445,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2882 Square Feet
Agency: National Land Realty, Holyoke, CO
Agency Phone: (855) 384-5263

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Beautiful 4 bedroom, 3 bath home on a corner lot, in an excellent location! This stunning brick home is truly one of a kind. The 13,960 sq. ft. lot has been immaculately maintained and features a sprinkler system, mature trees, and perennial flowerbeds. This home has excellent outdoor living space with a covered front porch and a back patio with a pergola. The front door opens to a foyer with a beautiful staircase going to the second story. To your right you will find the office with east facing windows, and to your left the formal living room with charming window seat. The dining room is large and has a west facing bay window. The kitchen provides a large amount of counter space and cabinetry with double ovens, and an electric range. You will enjoy the  handy breakfast bar for entertaining. The family room is cozy and private with a fireplace that has a gas insert. There are sliding doors opening the room up to the back patio. Down the hall you will find a guest bathroom with a shower, a large laundry room/mud room, and the master suite. This large bedroom features charming west facing windows, large double closets, and an on-suite bathroom with soaking tub. Upstairs you will find two bedrooms, one with an attached bath. There is also a large bonus room with a closet and private deck that could easily serve as a fourth bedroom. The home features an attached two-car garage and has a one-year-old roof. There is an unfinished, partial basement accessed via a garage stairwell that is perfect for additional storage, or it would make a nice workshop. One of a kind and in a great location, this lovingly cared for home is truly special. Contact the listing agent to schedule your private showing today. 
MlsNumber: --
ListingId: 11392608


Listing Provided By: National Land Realty, Holyoke, CO, original listing
Phone: (970) 580-8111
Office Phone: (855) 384-5263
Agent Name: Shannon Schlachter
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App