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

211 E Main Street
Lisbon, IA 52253

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $474,950
Beds: 4
Baths: 3
Status: Active
SqFt: 2932
Agency: Pinnacle Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1891
Notes: YOUR CHANCE TO OWN A PIECE OF HISTORY THAT HAS BEEN TOTALLY REMODELED AND LOOKS LIKE YOU STEPPED INTO A MAGAZINE! THIS BEAUTIFUL HOME HAS SO MANY THINGS TO MENTION AND YOU WILL NOTICE WHEN YOU APPROACH THE PROPERTY. LARGE YARD THAT LEADS UP TO THE GORGEOUS FRONT PORCH INTO YOUR ORIGINAL DOUBLE FRONT DOORS TO YOUR AMAZING FRONT ENTRY ROOM <br /> WITH WIDE WOODWORK, HIGH VOLUME CEILINGS THROUGHOUT, STAINED GLASS WINDOW, AND HAND CARVED FRONT STAIRCASE. POCKET DOORS BETWEEN THE AMAZING ROOMS. FRONT ROOM WITH DETAILED WALLS AND TILED FIREPLACE. THE LARGE WINDOWS FLOOD THE HOME WITH LIGHT AND FEATURE THE DETAILS. THE LIVING ROOM IS STUNNING WITH VIEWS OF THE CHEFS KITHEN AND DINING ROOM WITH WINE ROOM. HOLIDAY TIMES WILL NEVER BE THE SAME! THE KICHEN BOASTS A LARGE SQUARE WATERFALL ISLAND, CUSTOM CABINETS WITH BRUSHED GOLD HARDWARE, CUSTOM HOOD, HIGH END APPLIANCES, ALL ENTIRELY NEW!. TURN THE CORNER INTO THE HALL THAT LEADS TO THE COFFEE BAR, ANOTHER OVEN AND BACK STAIRWAY. THERE IS A HALF BATH AND DESIGNED LAUNDRY ROOM WITH BACK ENTRY PORCH. UPSTAIRS YOU WILL FIND 4 BEDROOMS, ONE THAT LEADS TO THE SECOND PORCH! HAMMOCK ANYONE? THE BEDROOMS ARE BIG AND BEAUTIFULLY DESIGNED. THE MASTER IS INCREDIBLE WITH A CUSTOM DESIGNED BATHROOM WITH TILED WALK IN SHOWER, BUILT INS CUSTOM WALK IN CLOSET WITH VANITY AREA FOR HER! STAND ALONE SOAKING TUB AND SEPARATED TOILET ROOM! ITS A DREAM BATH AND ALL NEWLY REMODELED. THE HALL BATHROOM IS RESTORED WITH A DRY SINK VANITY, WALK IN SHOWER AND ALL NEWLY REMODELED. OUT BACK YOU WILL FIND A BEAUTIFUL SHE SHED THAT HAS BEEN CUSTOMIZED AS A BEAUTIFUL ENTERTAINMENT SPACE, HOME OFFICE WITH LOFT, HEAT AND AIR CONDITIONED. FLAGSTONE PATIOS, FOR WOWING EVERYONE. NEW 2.5 STALL GARAGE WITH INCREDIBLE SPACE. THIS HOME HAS BEEN DONE WITH HIGH END FINISHES, NEW FLOORING, LIGHTING, PLUMBING, ELECTRICAL, HVAC, PAINT, QUARTZ AND TILE, JUST NEW EVERYTHING! THIS HOME HAS A LARGE WALK OUT BASEMENT FOR STORAGE, HUGE YARD, PRIVACY FENCING, NEWLY PAINTED EXTERIOR, ALL NEW SIDEWALKS, PATHWAYS, RADON MITIGATED, AND FULL ATTIC! WHAT HAS NOT BEEN DONE? WILL NOT DISAPPOINT, CALL THE LISTING AGENT FOR DETAILS AND FOR A PRIVATE SHOWING TODAY!
MlsNumber: 2402676


Listing Provided By: Pinnacle Realty LLC, original listing
Name: Pinnacle Realty LLC
Phone: (319) 350-9476
Office Name: Pinnacle Realty LLC
Office Phone: (319) 393-0900
Agent Name: Meridith Hoffman
Disclaimer: Copyright © 2024 Cedar Rapids Area Association 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 = 850 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;
Real Estate Expert Photo for Hannah Bachelder
Hannah Bachelder
ASCIIPinnacle Realty LLC
Call Today!: (319) 975-8541

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App