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 = 879 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 879 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 879 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

601 Connell Street
Dysart, IA 52224

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,500
Beds: 4
Baths: 3
Status: Active
SqFt: 2864
Agency: Carl Luze Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1970
Notes: BEAUTIFUL RANCH REDUCED, JUST MOVE IN AND ENJOY! Recently remodeled Brick Mid-Century Modern Ranch 3 bedroom 2 ½ bath, turn-key ready located on a Main Street corner lot. Short walk to elementary school, middle school, public pool, park, library, post office, shopping and dining. Connected to the attached garage is a large breezeway to welcome family and friends with a place for shoes and coats. Updated features include south facing Pella casement windows, patterned porcelain tile floors, modern doors with 5 windows to allow ample light. Can also be used as a sitting area to enjoy your morning coffee or evening wine. The adjacent powder room is resplendent with full walls of vertical subway tile and finished with patterned porcelain tile floor. The kitchen features shaker style cabinets and pantry with dove-tail drawers, full-extension soft closing undermount runners for seamless operations. a pull-out spice organizer, and corner lazy susan double shelf. Walls are covered with matte white penny tile. The new appliances include a Kutch Professional Chef Series gas oven and Samsung refrigerator and dishwasher. All of this is connected together by quartz concrete finish countertops. Transitioning through the open space where walls were removed, you enter the large dining room with more Pella windows for the Fall and Spring breezes. Again, no walls separate you from the living room with its oversized Pella casement windows that flood the space with soft southern and eastern light and bring the view of mature maple trees right into the room. The northern side of the house features a flowing hallway with original mid-century Maple checkerboard paneling with entry to three large bedrooms. The First bedroom is a light filled large master with casement Pella windows to the East and a new ensuite bathroom with an arched entry, freestanding deep soaking black bathtub, towel warmer and open glass shower, with tiled floor and walls. The middle bedroom is large enough for a King size bed with original maple floors and closets with built-in drawers. The third large bedroom also has original maple floors and closets and is currently being used as a home office for remote work. The basement features new carpet, a kitchenette counter microwave and refrigerator with wiring for an oven. Large entertainment area with faux fireplace and 70” TV. There is also non-conforming bedroom. The utility side of the basement has been freshly painted and has a new HVAC installed December of 2021, wiring updated with new breaker, new Samsung Washer and Dryer with steam/moisture sensor features, plus a remodeled bathroom with a shower.
MlsNumber: 20241835


Listing Provided By: Carl Luze Real Estate, original listing
Name: Carl Luze Real Estate
Phone: (319) 269-7858
Office Name: Carl Luze Real Estate
Office Phone: (319) 476-4949
Agent Name: Julie Elliott
Disclaimer: Copyright © 2024 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

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 = 879 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App