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

67 2nd
South Range, MI 49963
VERN HARLOCK with NORTHERN MICHIGAN LAND BROKERS - H, original listing - (906) 523-5575

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $80,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1501 Square Feet
Agency: NORTHERN MICHIGAN LAND BROKERS - H
Agency Phone: (906) 523-5575

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Duplex
Year Built: 1900
Notes: Opportunity Awaits in South Range: Single-Family Home in the Process of Conversion This South Range property, originally a single-family home, is currently being converted back from a duplex, offering a unique opportunity for the right buyer. The downstairs is brimming with potential, featuring a spacious kitchen, a utility room where laundry could be conveniently relocated from the basement, a comfortable living room, and a study (utilized as a bedroom) that opens via a patio door to a charming three-season room with direct access to the front walkway. The dry basement houses the laundry and all utilities, providing additional storage and functionality. The upstairs portion of the home requires attention, including new drywall, ceilings, and flooring, as well as reconfiguring the space into a 2 or 3-bedroom floor plan. This offers a blank canvas to design the upstairs to suit your needs and preferences. Outside, the backyard holds promise for outdoor entertaining and enjoying your morning coffee, especially with a deck that, while in need of some TLC, could become a fantastic extension of your living space. The property also includes a two-car garage with an electric garage door opener, adding convenience and value. This project house is priced accordingly and is full of potential for those with a vision. The seller is offering quotes for the replacement of windows, doors, drywall, and other potential contractor needs to help you explore the possibilities. Schedule your showing today to discover the opportunities this property holds!
MlsNumber: --
ListingId: 50152732


Listing Provided By: NORTHERN MICHIGAN LAND BROKERS - H, original listing
Phone: (906) 370-1670
Office Phone: (906) 523-5575
Agent Name: VERN HARLOCK
Disclaimer: Copyright © 2024 Upper Peninsula 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App