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

714 Bond Street
North Manchester, IN 46962
Andrea Greer Markham with Manchester Realty, original listing - (260) 982-6168

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,500
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 2861 Square Feet
Agency: Manchester Realty
Agency Phone: (260) 982-6168

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential Multi Family-Other
Year Built: --
Notes: Discover a profitable opportunity with this historical home, thriving business, and all of the furnishings. This home was transformed into a stunning bed and breakfast, ideally located in the heart of North Manchester and near Manchester University. Rooted in the University's rich heritage as the former president's home, thus named the Campus Inn, this property offers a unique blend of comfort, convenience, and income potential with 4 bedroom suites in seamlessly blended classic architecture and modern luxury. Each color coordinated bedroom offers a cozy retreat for guests, complete with a private bathroom, a mini refrigerator, and a closet. The heart of the Inn features a charming wood burning fireplace, perfect for relaxing evenings, and a gourmet kitchen with custom cabinetry, an expansive island, ceramic tile backsplash, stainless steel appliances plus a pot filler, a wine chiller, a walk in pantry, and eat in or outdoor dining space. Surrounded in windows, find additional seating for dining or an afternoon board game. The main level laundry and 1/2 bath add convenience. The partially finished basement offers extra gathering space or a game room. A two car garage and concrete driveway provide off street parking, with street parking also available. All HVAC, electrical, flooring, bath fixtures, plumbing, some windows and doors, appliances, new in 2022. The Campus Inn Bed and Breakfast comes with a first class reputation and many future bookings are in place, offering immediate income potential for a new Innkeeper.
MlsNumber: --
ListingId: 202429950


Listing Provided By: Manchester Realty, original listing
Phone: (260) 571-3778
Office Phone: (260) 982-6168
Agent Name: Andrea Greer Markham
Disclaimer: Copyright © 2024 REALTORS Association of Central Indiana. 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