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;

23408 Elm
Dollar Bay, MI 49922

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $175,000
Beds: 4
Baths: 2
Status: Active
SqFt: 2152
Agency: Douglass Real Estate, Inc DBA RE/MAX Douglass Real

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1920
Notes: BIG HOUSE, BIG LOT, BIG POTENTIAL. This home has many unique features. Enter into the large living room with picture window and laminate flooring. The dining room or family room with closet and storage drawers, also has laminate flooring and a sliding door that leads to a side deck. The eat-in kitchen has plenty of cabinets and seating bench for a table. A large L shaped bedroom with double closets and a 3/4 bath are off the kitchen along with an enclosed back porch. There is also a main floor laundry room. The second-floor features 3 nice size bedrooms with closets, a full bath with huge closet behind the bath and a small room in front which could be a playroom or office. A full attic is accessed off the first bedroom. The basement is high and appears dry. The large home is situated on a great corner lot with mature trees, a storage shed which needs some tlc, and an oversized 2 car garage. This home has been a rental for many years but with a bit of sweat equity could make a fabulous family home. Located in the quaint town of Dollar Bay just minutes to Houghton and Michigan Tech. All information believed accurate but not warranted. Buyer recommended to inspect all aspects of the property & bears all risks for any inaccuracies. Buyer to verify all information including but not limited to the estimated acreage, lot size, square footage, utilities (availability & costs associated). Taxes may change upon sale. 72 hour response time on all offers. Pre-qualification letter or proof of funds to accompany all offers. Seller reserves the right to change response time with or without notification.
MlsNumber: 50144801


Listing Provided By: Douglass Real Estate, Inc DBA RE/MAX Douglass Real, original listing
Name: Douglass Real Estate, Inc DBA RE/MAX Douglass Real
Phone: (906) 482-1000
Office Name: RE/MAX DOUGLASS R.E.-H
Office Phone: (906) 482-1000
Agent Name: GINGER STROUBE
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