sql=SELECT * from mlslistings where active='Y' and waterfront = 'YES' order by price desc

Top Lakefront Homes - South Central Michigan

Selection Criteria: Waterfront Only
Sort Value: price (descending)

260  SHORE DR,  Whitmore Lake, Mi  48189 9442 MICHIGAN PROPERTY $1,200,000
EXCELLENT DEVELOPMENT OPPORTUNITY!!! 17+/- ACRES WITH FRONTAGE ON WHITMORE LAKE! SEWRER AT ROAD. HOME ON 15 ACRES, FEATURES OVER 42OO SQ FT OF LIVING
Price: $1,200,000  Lake: Whitmore Lk  

8161  IRISH MIST,  Onsted, Mi  49265 CAMBRIDGE MICHIGAN PROPERTY $1,100,000
HTTPS://WWW.YOUTUBE.COM/WATCH?V=CGR2XOIFTU4&FEATURE=EM-UPLOAD_OWNER BREATHTAKING VIEWS OF LOCH ERIN FROM VIRTUALLY EVERY ROOM IN THIS STUNNING-CUSTOM
Price: $1,100,000  Lake:   

56  WASHINGTON,  Brooklyn, Mi  49230 6 BEDROOM HOUSE IN MICHIGAN, MLS - 5548302
TRANQUILITY AWAITS YOU HERE! 5100 SF WITH 6 BEDRMS AND BATHS AND AN IN-LAW SUITE SITUATED IN PICTURESQUE IRISH HILLS ON (ALL SPORTS, PRIVATE) WASHINGT
Price: $790,000  Lake:   

8500  DALTON COU,  Onsted, Mi  49265 LOCH ERIN HOME FOR SALE IN , SOUTHERN MICHIGAN, MLS:5
LAKEFRONT HOME WHICH HAS BEEN COMPLETELY REMODELED TO THE POINT WHERE IT'S HARD TO DISTINGUISH FROM A NEW HOME. SITUATED ON 4+ ACRES OF LAND, OVER 35
Price: $648,000  Lake: Loch Erin  

6475  HALLENBECK,  Manitou Beach, Mi  49253 2 BEDROOM HOUSE IN MICHIGAN, MLS - 5672422
TWO HOMES FOR ONE PRICE! FULLY FURNISHED! 5 BR, 3 BATHS TOTAL. MAIN HOUSE HAS MASTER BEDROOM W/PRIVATE BATH, PLUS ANOTHER BEDROOM AND BATH. SPACIO
Price: $539,000  Lake: Round  

6620  NYE RD,  Hudson, Mi  49247 HOME FOR SALE IN , SOUTHERN MICHIGAN, MLS:5670467
37 WOODED ACRES, 1165 FEET OF PRIVATE, ALL-SPORTS LAKE FRONTAGE....EXQUISITE PIECE OF PROPERTY! 4,000 SF CONTEMPORARY STYLE HOME, 3 BEDROOM, 2 FULL BA
Price: $529,900  Lake:   

3012  MARSH DR.,  Brooklyn, Mi  49230 MICHIGAN REAL ESTATE FOR $499,000
AMAZING PROPERTY ON IRISH HILLS' MOST REQUESTED LAKE! THIS SAND LAKE HOME OFFERS A QUIET, SECLUDED, PRIVATE SETTING RARELY FOUND. ALMOST 1 ACRE! GR
Price: $499,000  Lake:   

7540  NAPOLEON R,  Jackson, Mi  49201 PRICE HOUSE FOR SALE IN LEONI MICHIGAN - 495,000
OPPORTUNITY HERE!! 14 ACRES OF POTENTIAL DEVELOPMENT PROPERTY,WHICH IS SINGLE FAMILY ZONES AS SITE CONDO FOR FUTURE DEVELOPMENT. GORGEOUS SUNSET VIE
Price: $495,000  Lake: Price  

1695  STEAMBURG ,  Hillsdale, Mi  49242 REAL ESTATE IN , MICHIGAN FOR SALE - 479,000
CAN YOU CALL ANYWHERE HOME? THEN CHOOSE THIS EXPANSIVE ESTATE IN TRANQUIL HILLSDALE MICHIGAN. BOASTING ALMOST 8500SQFT OF FINISHED SPACE ON 3 LEVELS,
Price: $479,000  Lake:   

1983  CADMUS,  Adrian, Mi  49221 REAL ESTATE IN , MICHIGAN FOR SALE - 450,000
DREAM FRONTAGE ON LAKE MADISON. BEAUTIFULFINISHED WALKOUT BASEMENT INCLUDES FAMILY ROOM, REC ROOM, 4TH BEDROM AND BATH WITH 3 ROOMS FOR STORAGE. LAK
Price: $450,000  Lake:   

1331  US 12,  Tipton, Mi  49287 , LENAWEE COUNTY, MICHIGAN REAL ESTATE FOR SALE
OPPORTUNITY KNOCKS! OVER 1000' OF LAKE FRONTAGE ON ALL SPORTS (PRIVATE) EVANS LAKE. THIS 200 ACRE LAKE BOAST 2 ISLANDS WITH SOME OF SOUTHERN MICHIGAN'
Price: $444,900  Lake: Evans  

13960  GRANDPOINT,  Cement City, Mi  49233 , HILLSDALE COUNTY, MICHIGAN REAL ESTATE FOR SALE
THIS CUSTOM DESIGNED LAKEFRONT HOME IS SITUATED ON 73 FOOT OF PRIME, MAIN LAKE FRONTAGE ON ALL-SPORTS, PRIVATE LAKE SOMERSET. NEWLY REMODELED IN 2002
Price: $439,000  Lake: Somerset  

3520  ROUND LAKE,  Manitou Beach, Mi  49253 DEVILS PROPERTY FOR SALE IN LENAWEE COUNTY, MLS-56415
LAKE FRONT HOME THAT HAS BEEN TOTALLY REMODELED ON DEVILS LAKE! 3 BEDROOMS, 2 FULL BATH HOME WITH OVER 1,200 SQ. FT. OF LIVING SPACE, CENTRAL A/C, GAS
Price: $399,900  Lake: Devils  

6501  HALLENBECK,  Manitou Beach, Mi  49253 2 BEDROOM HOUSE FOR SALE IN SOUTH CENTRAL MICHIGAN - 56
ENJOY THIS WELL MAINTAINED ONE STORY COTTAGE WITH FAMILY AND FRIENDS. HOME COMPLETELY UPDATED IN 2014 FEATURING LVT FLOORING THROUGHOUT, NEW FURNACE
Price: $399,000  Lake: Round  

42  WINCHESTER,  Addison, Mi  49220 3 BEDROOM HOUSE IN MICHIGAN, MLS - 5715251
WOW SECLUDED LAKEFRONT PROPERTY! OVER 100 FEET SANDY BEACH ON GORGEOUS, PRIVATE, ALL-SPORTS SILVER LAKE. ALMOST NEW CUSTOM HOME SITS ON A LEVEL LOT WI
Price: $399,000  Lake: Silver  




w w w . r e m e r i c a s o m e r s e t r e a l t y . c o m
Remerica Somerset Realty Incorporated. Since 1974
Your Somerset Michigan Area Real Estate Service Provider
Including Hillsdale, Lenawee, and Jackson Counties

AWS