Title Page Background
DEBUG FN args: Array ( [0] => 859 [1] => [2] => [3] => agent ) BEFORE: Site: 859 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 859 Igate: njhud LocID: 859 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 859 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 859 [1] => [2] => [3] => lender ) BEFORE: Site: 859 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 859 Igate: njhud LocID: 859 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 859 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 859 [1] => [2] => [3] => other ) BEFORE: Site: 859 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 859 Igate: njhud LocID: 859 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 859 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

3984 Foothill Avenue
St. Ansgar, IA 50472
Philip Kolbet with Kolbet Realtors, original listing - (641) 732-3337

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 5
Baths: Full: 2, ½: 1, ¾: 1
Status: Active
SqFt: 5968 Square Feet
Agency: Kolbet Realtors
Agency Phone: (641) 732-3337

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: DO NOT miss this once in a lifetime opportunity to own this Masterpiece on the premiere stretch of the Cedar River. This custom built one owner property is located on 4.40 acres on hard surfaced Foothill Ave. The property is Not part of an Association and it has it's own private well and a compliant septic system. All seasons are beautiful in this location so use this property as your primary residence or as a lovely second home to entertain. Just under 6,000 sq. ft. offers 4-5 bedrooms and 3.5 baths. The construction and quality of this home are unmatched with beautiful natural wood supports, trim work, and flooring. Your first experience as you walk in the front door is the center Great Room with its stunning 30 ft. vault. A full wall of windows to the East looks out over the deck to the river. The real brick gas fireplace is magnificent and takes up the whole North wall. Just off of the living room is the huge kitchen/dining area. This area would be any cooks dream. All cabinets are custom Woodharbor with all of the extra features. All counters are quartz including a large sit-up peninsula and a huge center work island. There is also a complete set of modern appliances including a large Viking gas range and a SubZero refrigerator. The dining area is perfectly located in front of a full set of windows with perfect views both up and down the river and out onto the deck. Speaking of the deck, that was just updated this Spring to a composite decking and a drinking rail. Working from home or desire a home office? Just off of the kitchen is a deluxe 10'x13'5" office with a complete set of built-in cabinets and countertops. Just bring your laptop! Also on the main floor is a one of a kind Master Suite complete with a morning Sun Room, private bath, and walk-in closet. The sun room is to the East and is all windows so you can watch the sun rise over this perfect spot on the Cedar River. The master bath has a double sink vanity, a large air soaker tub, and a custom ceramic walk-in shower. The large walk-in closet has a complete organizer system in addition to a center storage/folding island. The second floor features a beautiful loft view of the great room below which you can also enjoy from the sitting area/library space. Also on the second floor are three large bedrooms and a full bathroom. And now for the fun part of the home which is the whole lower level which is all finished except for the mechanical room. This area has floor heat and features an incredible family room highlighted by a natural brick gas fireplace, a lovely full kitchenette, huge game room, a large workout room (or possible 5th bedroom), incredible huge laundry room with a full set of built-in cabinets, counters, and work island, and a full bathroom. Going out the French doors to the East will take you to the paver patio and ultimately to the river and your private docks. If you just want to sit by the river, you can enjoy another paver patio complete with a fire pit right at the river's edge. The matching boat house is complete with electricity, an automatic boat lift and accent lighting. The jet ski dock is also included. And finally, what every acreage needs, some wonderful outbuildings. The 38x46 shop building is designed to match the main home. It is fully cemented with floor heat, fully insulated and lined, compressor with air lines, vacuum lines, and a half bathroom. In addition, there is a full height walk-up attic for incredible storage which is fully wired. The attractive 30x38 Red Barn was built in 2018. It is fully cemented and wired and is currently just used for storage. Starting with the location, being on a hard surfaced road, and this location on the river, this property, realistically. cannot be repeated. The timing is perfect since you would still be able to get a lot of outside Summer enjoyment yet this year. CHECK IT OUT!!
MlsNumber: --
ListingId: 20252264


Listing Provided By: Kolbet Realtors, original listing
Phone: (641) 732-3337
Office Phone: (641) 732-3337
Agent Name: Philip Kolbet
Disclaimer: Copyright © 2025 Northeast Iowa Regional Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => mitchell [3] => IA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: mitchell State: IA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: mitchell State: IA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 859 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Mobile: (241) 555-1812
Beware of the Bear - Look I am a Hooman

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App