A
Seller's Agent in 2023
Angela Jones
Century 21 Curran & Oberski
165 S Opdyke Rd Auburn Hills, MI 48326
3
Beds
2
Baths
1,500
Sq Ft
1986
Built
Highlights
- Water Views
- Clubhouse
- Ranch Style House
- Outdoor Pool
- Deck
- No HOA
About This Home
As of December 2023Beautiful 3-Bedroom Mobile Home with Lake View in Sheffield Estates, Auburn Hills, MI
Welcome to your dream home! This stunning 3-bedroom, 2-bath mobile home in Sheffield Estates, Auburn Hills, MI, offers the perfect blend of comfort, style, and convenience. With its spacious 1,500 square feet of living space, updated features, and a breathtaking lake view, you'll fall in love with this serene retreat.
Key Features:
1. Spacious Living: This mobile home boasts a generous 1,500 square feet of living space, providing ample room for your family to spread out and relax.
2. Three Bedrooms: With three bedrooms, there's plenty of space for everyone. The master bedroom includes an en-suite bathroom for added privacy and convenience.
3. Updated Kitchen: The kitchen is a true highlight of this home, featuring modern appliances, stylish countertops, and ample cab
Last Agent to Sell the Property
Angela Jones
Century 21 Curran & Oberski License #6501453188 Listed on: 09/22/2023
Property Details
Home Type
- Mobile/Manufactured
Year Built
- Built in 1986 | Remodeled in 2022
Home Design
- Manufactured Home Without Land
- Ranch Style House
- Slab Foundation
- Asphalt Roof
- Vinyl Construction Material
Interior Spaces
- 1,500 Sq Ft Home
- Gas Fireplace
- Water Views
Kitchen
- Free-Standing Gas Range
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 3 Bedrooms
- 2 Full Bathrooms
Laundry
- Dryer
- Washer
Outdoor Features
- Outdoor Pool
- Deck
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Natural Gas Water Heater
- Cable TV Available
Additional Features
- Street terminates at a dead end
- Ground Level
Listing and Financial Details
- Assessor Parcel Number 1435176006
Community Details
Overview
- No Home Owners Association
Amenities
- Clubhouse
- Laundry Facilities
Recreation
- Community Pool
Pet Policy
- Pets Allowed
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Jan 12, 2006
Sold by
Sheffield Estates Mobile Home Park Limit
Bought by
Sheffield Mhp Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$4,500,000
Outstanding Balance
$2,623,361
Interest Rate
6.42%
Mortgage Type
Commercial
Purchase Details
Closed on
Jan 11, 2006
Sold by
Frankel Samuel and Frankel Jean
Bought by
Sheffield Estate Mobile Home Park Limite
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$4,500,000
Outstanding Balance
$2,623,361
Interest Rate
6.42%
Mortgage Type
Commercial
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Sheffield Mhp Llc | -- | Greco | |
| Sheffield Estate Mobile Home Park Limite | -- | Greco |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Sheffield Mhp Llc | $4,500,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 12/27/2023 12/27/23 | Sold | $40,000 | -11.1% | $27 / Sq Ft |
| 12/27/2023 12/27/23 | Pending | -- | -- | -- |
| 10/29/2023 10/29/23 | Price Changed | $45,000 | -10.0% | $30 / Sq Ft |
| 10/19/2023 10/19/23 | Price Changed | $50,000 | -9.1% | $33 / Sq Ft |
| 09/22/2023 09/22/23 | For Sale | $55,000 | -- | $37 / Sq Ft |
Source: Realcomp
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2024 | $100,172 | $5,559,030 | $0 | $0 |
| 2023 | $95,512 | $5,559,030 | $0 | $0 |
| 2022 | $182,790 | $5,559,030 | $0 | $0 |
| 2021 | $177,352 | $5,272,480 | $0 | $0 |
| 2020 | $87,291 | $4,443,190 | $0 | $0 |
| 2019 | $166,184 | $3,699,900 | $0 | $0 |
| 2017 | $159,197 | $3,200,540 | $0 | $0 |
| 2015 | -- | $2,882,320 | $0 | $0 |
| 2014 | -- | $2,836,380 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
-
Buyer's Agent in 2023
Edward Hewlett
KW Metro
(313) 715-5241
1 in this area
3 Total Sales
Map
Source: Realcomp
MLS Number: 20230080888
APN: 14-35-176-006
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial 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.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 0 Oaknoll St
- 421 S Opdyke Rd
- 607 Ashburnham St
- 125 Hillfield Rd
- 2574 Binghamton Dr
- 2667 Williamsburg Cir Unit 31
- 2701 Williamsburg Cir Unit 22
- 34 Cross St
- 3075 Waukegan St
- 833 Bloomfield Village Blvd Unit B
- 3061 Auburn Rd
- 536 Fox River Dr
- 3071 Churchill Rd
- 3143 Henrydale St
- 392 S Squirrel Rd
- 3173 Henrydale St
- 173 Clifford St
- 1696 S Hill Blvd Unit 46
- 3317 Parkways Blvd
- 3315 Parkways Blvd
- 165 S Opdyke Rd Unit 226
- 165 S Opdyke Rd Unit 143
- 165 S Opdyke Rd Unit 63
- 165 S Opdyke Rd Unit 98
- 165 S Opdyke Rd Unit 134
- 165 S Opdyke Rd Unit 62
- 2339 Oaknoll St
- 2359 Oaknoll St
- 2385 Oaknoll St
- 2325 Oaknoll St
- 2405 Oaknoll St
- 2415 Oaknoll St
- 2285 Oaknoll St
- 2320 Oaknoll St
- 2360 Oaknoll St
- 2340 Oaknoll St
- 2380 Oaknoll St
- 2259 Oaknoll St
- 2195 Knollwood St Unit Bldg-Unit
- 2195 Knollwood St