Please stand by.
USDAProperties.com is preparing the eligibility details...

 

 

 

$3250000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
15440 Windmill Pointe Dr
Grosse Pointe Park, MI 48230
6 bed 7 bath 6200 SqFt ($524/SqFt)
1.84 acre lot. Built 1992
Listed 2023-11-13, Taxes $27483
Ⓧ USDA Ineligible
due to price & location

near Grosse Pointe Park

Breathtaking unobstructed views of Lake St.

Clair. This exceptional property is situated on almost 2 acres of prime real estate with 203 feet of water frontage including a boat ramp. The masterful custom created home was built by John Uznis in 1992 for the present owners. This ultimate entertainment destination has it ALL. The magnificent lower level walkout is a paradise for family and friends, which includes a fabulous bar area, sauna, home gym, activities room, kitchenette, sitting room with fireplace. In addition there is a four car garage to store all the toys. The spectacular marble foyer welcomes you into the Great Room and formal dining room combination with panoramic views of the lake where the freighters glide by daily.

The stunning white gourmet kitchen w breakfast area, gathering room, fireplace has access to a the large brick terrace. First floor also features a cozy paneld library with fireplace and built in bookcases, dramatic bar room, a powder room and half bath for family. Second floor features an exceptional, primary ensuite bedroom w two walk in closets and fireplace. The sizeable primary bathroom features a large soaking tub, dual sink and separate oversized shower. In addition there are 4 bedrooms and 3 baths and a convenient second floor laundry room. The attic also features additional storage. Relax in this private oasis of serenity. Luxury for a lifetime awaits you!


Presented by PATTY RILEY at
Coldwell Banker Realty, Michigan - Grosse Pointe.
Listing Agent Photo

Property MLS #20230086854 from Realcomp

Bedrooms: 6

Total Rooms: 21
Library (Study): 18.00 x 14.00
Library (Study) Level: First/Entry
Great Room: 42.00 x 29.00
Great Room Level: First/Entry
Bath - Lav: 4.00 x 6.00
Bath - Lav Level: First/Entry
Bedroom: 15.00 x 13.00
Bedroom Level: Second
Bedroom: 15.00 x 13.00
Bedroom Level: Second
Bedroom: 17.00 x 14.00
Bedroom Level: Second
Bedroom: 12.00 x 12.00
Bedroom Level: Second
Bath - Primary: 16.00 x 12.00
Bath - Primary Level: Second
Bedroom - Primary: 32.00 x 25.00
Bedroom - Primary Level: Second
Bath - Lav: 9.00 x 5.00
Bath - Lav Level: First/Entry
Kitchen: 30.00 x 12.00
Kitchen Level: First/Entry
Recreation Room: 29.00 x 28.00
Recreation Room Level: Basement
Other: 19.00 x 16.00
Other Level: First/Entry
Bath - Full: 7.00 x 6.00
Bath - Full Level: Second
Bath - Full: 9.00 x 6.00
Bath - Full Level: Second
Bath - Full: 7.00 x 8.00
Bath - Full Level: Second
Kitchen - 2nd: 10.00 x 6.00
Kitchen - 2nd Level: Basement
Bath - Full: 8.00 x 5.00
Bath - Full Level: Basement
Bedroom: 16.00 x 14.00
Bedroom Level: Basement
Basement Description: Finished, Walkout Access
Exercise Room: Yes

Total Bathrooms: 5.20
Full Bathrooms: 5
1/2 Bathrooms: 2

Jetted Tub
Furnished - No
Wet Bar

Wine Cooler
Built-In Gas Range
Built-In Refrigerator
Dishwasher
Disposal
Double Oven
Down Draft
Dryer
Exhaust Fan
Free-Standing Electric Range
Gas Cooktop
Ice Maker
Microwave
Washer
Bar Fridge

Cooling Features: Central Air
Fireplace Features: Basement, Great Room, Kitchen, Library, Primary Bedroom
Heating Features: Forced Air
Heating Fuel: Natural Gas
Water Heaters: Natural Gas

Water Body Name: Lake St. Clair
Water Features: Sea Wall
Direct Water Frontage
Lake Front
Water Front
Sea Wall

Tennis Court
Club House
Pool Community
Frontage Length: 202
Road Frontage Type: Paved
Porch Description: Patio, Terrace

Lot Size Acres: 1.84
Lot Size Dimensions: 200.00 x 400.00
Lot Size Square Feet: 80150

Garage Spaces: 4
Garage Description: 25 x 48
Garage Features: Attached

Association: No
Calculated Total Monthly Association Fees: 0

Fitness Center

School District: Grosse Pointe

Pierce Middle School is a public elementary and middle school located approximately 1.3 miles away.
directions icon Map directions

Grosse Pointe South High School is a public high school located approximately 2.1 miles away.
directions icon Map directions

St. Ambrose Academy is a private elementary and middle school located approximately 1.1 miles away.
directions icon Map directions

ActivationDate : 2023-11-13
Annual Tax Amount: 59802
Source Listing Status: Active
County: Wayne
Directions: Jefferson Ave, Bedford to Windmill Pointe
Source Property Type: Residential
Home Warranty: No
Area: Grosse Pointe Park
Source Neighborhood: WINDMILL POINTE SUB
Ownership Type: Short Sale - No, Private Owned
Parcel Number: 39009020023300
Postal Code Plus 4: 1746
Subdivision: WINDMILL POINTE SUB
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$unknown + $unknown
$2167300
$27483
2021$unknown + $unknown
$2104800
$54192
2020$unknown + $unknown
$2054000
$56908
2019$unknown + $unknown
$1706900
$55768
2018$unknown + $unknown
$1622700
$55094
2017$unknown + $unknown
$1548700
$53157
2016$unknown + $unknown
$1372000
$52777
2015$unknown + $unknown
$1325400
$50425
2014$unknown + $unknown
$1087400
$50313
2013$unknown + $unknown
$1047100
$47417
2012$unknown + $unknown
$947850
$47818
2011$unknown + $unknown
$1017000
$47373
2010$unknown + $unknown
$1000000
$55656
2009$unknown + $unknown
$1548200
$62099
2008$unknown + $unknown
$1700000
$33694
2007$unknown + $unknown
$2000000
$32662

Price Changed 2024-03-29
$3250000
Realcomp
Listed 2023-11-13
$3700000
Realcomp

Total Square Feet Living: 6200
Year Built: 1992
Construction Materials: Brick
Foundation Details: Basement
Levels: 3 Story
Property Age: 32
Roof: Asphalt
Levels or Stories: 3 Story
Total Area Lower: 2710
Total Area Sqft: 8910
Total Below Grade Area: 2710
Architectural Style: Colonial

Sewer: Sewer at Street
Water Source: Water at Street
Click Thumbnail Images To View Full Size
house_viewroad_viewunknownhouse_viewhouse_view
unknownunknowngaragefarm_landfarm_land
porchhouse_viewporchporchunknown
farm_landunknownunknownunknownhouse_view
house_viewunknownunknownunknownliving_room
kitchenunknownkitchenkitchendining_room
kitchendining_roombathroombathroombedroom
bedroombathroombedroombathroomunknown
laundry_roombedroombedroombathroombathroom
bathroomunknownbathroomunknownunknown
unknowndining_roomdining_roomliving_roomunknown
kitchenbathroomliving_roomliving_roomfloor_plan
floor_planfloor_plan

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.