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

1296 Main
Melvin, MI 48454
Robert Kean with Coldwell Banker Professionals, original listing - (586) 727-2741

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $265,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1885 Square Feet
Agency: Coldwell Banker Professionals
Agency Phone: (586) 727-2741

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential Multi Family
Year Built: 1900
Notes: This unique property is in the heart of Melvin. Own your own post office building with newly negotiated lease. The lower front unit, which currently is leased to the US Post office for $581, will increase to $849.75 on Oct 1 with a five year lease. USPS has been a tenant since 1930....94 years of continuous service! In addition, There are two residential apartments, an upper leased at $625 and lower unit at $700. Both are leased below current market rates due to long term tenants. Apartments are on a month to month contract. Both apartments are 2 bedroom and in well maintained condition. There is a common area that has washer-dryer. Attached garage stores the lawn implements that go with sale. There is a nice storage shed in the spacious back yard that overlooks farm fields. The current owner has put in over 40k in improvements since purchase. Just in the last three years including: New roof for back apartment and Garage, Upgraded/Modernized Main Electric Panel, Installed new Well pump and piping, Installed new double windows in lower apartment unit, New Refrigerator in upstairs apartment, Tuck Pointing - Re-Grouting brickwork of Post Office exterior, Installed New 50 gal Water Heater, New toilet & new commercial grade flooring for Post Office, Installed new 30 foot Commercial Flag Pole, Installed new Modern "Closed System" Gas Boiler unit. See photo gallery for list of improvements. This building has been well maintained and is one of the original buildings in town. It is located across from the Melvin "hogtown" Tavern. Great opportunity for the investor in a small town community.
MlsNumber: --
ListingId: 50149159


Listing Provided By: Coldwell Banker Professionals, original listing
Phone: (810) 650-5850
Office Phone: (586) 727-2741
Agent Name: Robert Kean
Disclaimer: Copyright © 2024 Multiple Listing Service MiRealSource. 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