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

2405 Bittersweet Place
Burlington, IA 52601

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,500
Beds: 4
Baths: 3
Status: Active
SqFt: 3139
Agency: Ruhl & Ruhl Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: This gorgeous 1923 home has been meticulously upkept and renovated. The property sits on two parcels giving ample space for outside entertainment. Natural wood foyer with original light fixtures and coat closet leads to beautiful stairway, formal dining room with built-in bar on the right and family room with woodburning fireplace, built-in entertainment center and shelf on the left. Crown molding throughout the house depicts the grander of its origin and the contemporary updates allow you enjoy the modern. Inviting sunroom gives you place to relax. Marvelous kitchen offers new cabinets with etched glass doors and lights, granite countertops, soft close drawers, roll-out shelves, and spice cabinets in lower cabinets. Laundry room is on the main floor for your convenience, featuring pocket doors, etched glass, roll out storage racks and ironing board, built-in hall tree. You can step out into the screened-in porch with plenty of storage and an amazing space to relax. The second floor has new carpet and vinyl windows. The owner’s suite offers a sitting room, and a spacious bathroom with jetted tub, walk-in shower, and dual pedestal sinks. The 2nd and 3rd bedrooms have built-in desks and pull-out computer shelf and a stationary. The upper floor with beautiful dormers can host a nice bedroom as it has plenty of storage behind the panels and a pocket door. The basement is heated with beautiful epoxy floors and ample storage. And if you are an avid golfer – that’s the perfect l
MlsNumber: 6314879


Listing Provided By: Ruhl & Ruhl Real Estate, original listing
Name: Ruhl & Ruhl Real Estate
Phone: (319) 752-9933
Office Name: Ruhl & Ruhl Real Estate
Office Phone: (319) 752-9933
Agent Name: Larisa Conner
Disclaimer: Copyright © 2024 Southeast Iowa Regional 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