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 = 283 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 = 283 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 = 283 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;

402 N Washington Ave
Fleming, CO 80728

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $279,900
Beds: 4
Baths: 2
Status: Active
SqFt: 1806
Agency: CHOICE Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1918
Notes: Beautifully maintained home located in Fleming Colorado, wonderful community, nice neighbors, rural living at its finest with this 4-bedroom home, updated flooring, bathrooms, and Markley's 50-year shingle roof. Enjoy a wonderful evening walking through the community, visiting with new friends at the local restaurant and pub, or spend time with loved ones in your sunroom, rec room, or a fun get together barbecuing on the cement patio in your spacious fenced back yard! There's lots of spacious living inside, with a big kitchen and flex space throughout the main floor and basement, including a indoor cellar/pantry. Downstairs the bedrooms have beautiful custom barn doors, and custom doors throughout basement. Stay warm with central heating and cool with central air conditioning throughout, and all appliances are included as well as a upright freezer! Have toys? You have room waiting for you in this oversized 2 car garage, with workshop, attic and garage door openers, along with a large Quonset hut that can fit up to 4 cars with plenty of storage to spare, both have cement floors and a place to put wood burning stoves for those chilly nights but want to stay cozy while in your garages, not to mention outdoor parking for your RV/boat! This .32-acre corner lot is huge, with plenty of trees; you can add a dog run for your pets, enough room for an outdoor kitchen, beautiful garden and still have room for a playground, enjoy outdoor gatherings or your personal shed. Your imagination can come alive in this super cute bungalow home; with a population of around 424, check out USDA loans for this property for possible lower interest rates and down payments, don't let this gem go by, book your viewing today! Special Financing sellers contribute $3k to buy down interest rate
MlsNumber: 1004782


Listing Provided By: CHOICE Real Estate, original listing
Name: CHOICE Real Estate
Phone: (970) 521-2735
Office Name: Choice Real Estate
Office Phone: (970) 521-2735
Agent Name: Shawna Holveck
Disclaimer: Copyright © 2024 Information and Real Estate Services, LLC. 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