SEARCH LISTINGS
Next open house › Apr 26th from 1pm to 3pm
Rate this listing
Print Facebook X Email SMS
Active
Residential
Virtual Tour
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo
Property Photo

37740 Siesta Street

Harrison Twp, MI 48045
Beds
3
Baths
3
Square Ft.
2,484
$775,000
This spectacular modern waterfront home with partial lake views delivers an extraordinary lifestyle, perfectly situated on a deep, extra-wide canal just steps from Lake St. Clair, home to some of the country's best fishing. Boasting impressive 10-foot ceilings and abundant natural light, the inviting open-concept main floor offers an ideal… Read MoreRead Less
Market LogoProvided through IDX through Realcomp II Ltd. Courtesy of Berkshire Hathaway HomeServices Kee Realty NB Lori Chattinger (586) 315-5700.
Listing Snapshot
Days Online
11
Last Updated
Property Type
Residential
Beds
3
Full Baths
2
Partial Baths
1
Square Ft.
2,484
Lot Size
0.17 Acres
Year Built
2000
MLS Number
58050171410
Property Location Map
Additional Details
Property Access
Private
Appliances & Equipment
Dishwasher, Dryer, Microwave, Oven, Range/Stove, Refrigerator, Washer
Basement
Basement?: 0
Building
2,484 total square feet, 2,484 combined square feet, 0 lower floor square feet, 0 total basement square feet, Built in 2000, Architectural style: Colonial, 2 Story, Brick
Cooling
Central Air
Fireplaces
Great Room, Fireplace?: 1
Foundation
Crawl
Garage
Attached, 2 Car, Garage?: 1
Water Features
Public (Municipal)
Heating
Forced Air, Natural Gas
Lot
Water View, Sprinkler(s), Lot size area: 0.17, Lot size dimensions: 40x188
Property
Property type: Residential, Canal Front, Lake Privileges, Water Front, All Sports Lake, Dock Facilities
Taxes
Tax amount (summer): $6,158, Tax amount (winter): $2,888
Sewer
Public Sewer (Sewer-Sanitary)
Find The Perfect Home

'VIP' Listing Search

Whenever a listing hits the market that matches your criteria you will be immediately notified.

Join The List
Mortgage Calculator
Monthly Payment
$0
MIKE MELDRUM
REAL ESTATE BROKER | OWNER
Agent profile image

Schools In The Area

Check out nearby schools with ratings and contact info.
Emma V Lobbestael Elementary School 586-783-6450 Public PK-5
Lanse Creuse Middle School South 586-493-5620 Public 6-8
Lanse Creuse High School 586-783-6400 Public 9-12
Emma V Lobbestael Elementary School 586-783-6450 Public PK-5
Emma V Lobbestael Elementary School 586-783-6450 Public PK-5
Lanse Creuse Middle School South 586-493-5620 Public 6-8
Lanse Creuse High School 586-783-6400 Public 9-12

Similar Listings

View More Listings
$639,900
37952 Circle Drive
Harrison Twp, MI
Provided through IDX through Realcomp II Ltd. Courtesy of Realty Executives Home Towne Shelby Michael Donelson (586) 726-4600.
3 Beds 3 Baths 2,479 Sqft
$635,000
26141 N harbour pointe dr n Drive
Harrison Twp, MI
Provided through IDX through Realcomp II Ltd. Courtesy of Coldwell Banker Professionals Debra Reid (586) 727-2741.
2 Beds 3 Baths 3,432 Sqft
$699,999
41525 Windmill Street
Harrison Twp, MI
Provided through IDX through Realcomp II Ltd. Courtesy of RE/MAX First Lucy A Burby (586) 781-2900.
4 Beds 3 Baths 2,650 Sqft
$699,000
38168 MAST Street
Harrison Twp, MI
Provided through IDX through Realcomp II Ltd. Courtesy of Realty Executives Home Towne Jennifer Stanczak (586) 726-4600.
4 Beds 3 Baths 2,540 Sqft
$899,000
32633 N RIVER Road
Harrison Twp, MI
Provided through IDX through Realcomp II Ltd. Courtesy of KW Metro Alina Valentine (248) 288-3500.
4 Beds 3 Baths 3,000 Sqft
$899,900
38008 SEAWAY Court
Harrison Twp, MI
Provided through IDX through Realcomp II Ltd. Courtesy of @properties Christie's Int'l RE Grosse Pointe Steven Edward (313) 228-2221.
3 Beds 3 Baths 3,466 Sqft
$699,999
49 Sea Ray Boulevard
Harrison Twp, MI
Provided through IDX through Realcomp II Ltd. Courtesy of Century 21 Professionals Clinton Mary B. Naeyaert (586) 286-6000.
1 Beds 2 Baths 1,550 Sqft
$724,900
38044 Seaway Court
Harrison Twp, MI
Provided through IDX through Realcomp II Ltd. Courtesy of Keller Williams Realty Lakeside Denise L Trotto (586) 532-0500.
3 Beds 3 Baths 1,894 Sqft
$649,900
41610 Belvidere Street
Harrison Twp, MI
Provided through IDX through Realcomp II Ltd. Courtesy of Michigan Homes Group Inc Jeff Papsdorf (586) 381-9989.
3 Beds 2 Baths 2,453 Sqft
$680,000
29338 S Seaway Court
Harrison Twp, MI
Provided through IDX through Realcomp II Ltd. Courtesy of RE/MAX First James Kaschalk (586) 781-2900.
3 Beds 3 Baths 2,307 Sqft

IDX provided courtesy of Realcomp II Ltd., via RE/MAX Eclipse and Mike Meldrum, Listing Information © Realcomp II Ltd. Shareholders. All Rights Reserved.

IDX provided courtesy of Realcomp II Ltd., via RE/MAX Eclipse and Mike Meldrum, Listing Information © Realcomp II Ltd. Shareholders. All Rights Reserved.

IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.