Description
- Listed by Sahar N Fakhouri • Brokerage DRE #6505333163 • Mondrian Properties R E, LLCP: (248)-680-9074 C: (248)-229-2104 sfakhouri@mondrianproperties.com
Property Details for 1040 Lamb Road, Unit # 5
Property Details for 1040 Lamb Road, Unit # 5
| Status | Closed |
|---|---|
| MLS # | 20261016558 |
| Days on Market | 28 |
| Pet Policy | Allowed |
| Rental Incentives | - |
| Costs & Fees | - |
| Available Date | - |
| Lease Term | Lease Length: Months 25 to 36, Months 37 to 48, Months 49 to 60 |
| Furnished | - |
| Property Type | Rental |
| MLS Type | Residential Lease / Condominium |
| Year Built | 2018 |
| Lot Size | - |
| County | Oakland County |
Location
Building Information for 1040 Lamb Road, Unit # 5
Property Information for 1040 Lamb Road, Unit # 5
- Directions: North of Wattles and East off Rochester Rd onto Lamb
- Latitude: 42.58138
- Longitude: -83.1275
- Cross Street: Rochester Rd and Wattles
- MLS Area Major: Area02203Troy
- Parcel Number: 2014354005
- Tax Legal Description: T2N, R11E, SEC 14 OAKLAND COUNTY CONDOMINIUM PLAN NO 2173 BELLECLAIRE CONDOMINIUMS UNIT 5 L50273 P428 1/12/17 FR 351-098
- Association: No
- High School District: Troy
- Garage Spaces: 2.0
- Attached Garage: Yes
- Garage: Yes
- Parking Features: Two Car Garage, Attached
- Lot Size Units: Acres
- Road Frontage Type: Paved
- Living Area: 1847.0
- Above Grade Finished Area: 1847.0
- Above Grade Finished Area Units: Square Feet
- Below Grade Total Area: 850.0
- Class Name: Residential Lease
- Living Area Source: Estimated
- New Construction: No
- Year Built: 2018
- Construction Materials: Brick, Wood Siding
- Entry Location: Ground Levelw Steps
- Foundation Details: Basement, Poured
- Levels: Two
- Sewer: Public Sewer
- Water Source: Public
- Bathrooms Total Notational: 2.1
- Basement: Full, Unfinished
- Has Basement: Yes
- Bathrooms Full: 2
- Bathrooms Half: 1
- Bathrooms Total Integer: 3
- Bedrooms Total: 3
- Has Cooling: No
- Fireplace: No
- Heating: Forced Air, Natural Gas
- Has Heating: Yes
- Rooms Total: 6
- Exterior Features: Private Entrance
- Patio And Porch Features: Porch
- Room Dimensions: 19 X 13
- Room Length: 19.0
- Room Width: 13.0
- Room Level: Second
- Room Type: Primary Bedroom
- Room Dimensions: 11 X 11
- Room Length: 11.0
- Room Width: 11.0
- Room Level: Second
- Room Type: Bedroom
- Room Dimensions: 14 X 14
- Room Length: 14.0
- Room Width: 14.0
- Room Level: Second
- Room Type: Bedroom
- Room Dimensions: 15 X 10
- Room Length: 15.0
- Room Width: 10.0
- Room Level: Entry
- Room Type: Dining Room
- Room Dimensions: 7 X 13
- Room Length: 7.0
- Room Width: 13.0
- Room Level: Entry
- Room Type: Kitchen
- Room Dimensions: 14 X 18
- Room Length: 14.0
- Room Width: 18.0
- Room Level: Entry
- Room Type: Living Room
- Room Level: Second
- Room Type: Primary Bathroom
- Room Level: Second
- Room Type: Bath Full
- Room Level: Entry
- Room Type: Bath Lav
- Public GLR Website: Yes
- Application Fee: $195.00
- Security Deposit: $4,800.00
- Existing Lease: No
- Lease Terms Available: Months25to36, Months37to48, Months49to60
- Lease Type: Condominium
- Pets Allowed: Number Limit, Size Limit, Yes
- Rent Spree: No
Property History for 1040 Lamb Road, Unit # 5
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Apr 29, 2026 | Rented Realcomp #20261016558 | $3,200 | — |
| Apr 29, 2026 | Application Pending Realcomp #20261016558 | — | |
| Mar 31, 2026 | Listed (Active) Realcomp #20261016558 | $3,200 | — |
| Mar 4, 2024 | Rented Realcomp #20240009853 | $2,750 | — |
| Mar 1, 2024 | Application Pending Realcomp #20240009853 | — | |
| Feb 18, 2024 | Listed (Active) Realcomp #20240009853 | $2,895 | — |
| Jul 6, 2019 | Rented Realcomp #219012331 | $2,250 | — |
| Jun 15, 2019 | Application Pending Realcomp #219012331 | — | |
| Feb 11, 2019 | Listed (Active) Realcomp #219012331 | $2,100 | — |
| Date | Event & Source | Price |
|---|---|---|
| 04/29/2026 | Rented Realcomp #20261016558 | $3,200 |
| 04/29/2026 | Application Pending Realcomp #20261016558 | — |
| 03/31/2026 | Listed (Active) Realcomp #20261016558 | $3,200 |
| 03/04/2024 | Rented Realcomp #20240009853 | $2,750 |
| 03/01/2024 | Application Pending Realcomp #20240009853 | — |
| 02/18/2024 | Listed (Active) Realcomp #20240009853 | $2,895 |
| 07/06/2019 | Rented Realcomp #219012331 | $2,250 |
| 06/15/2019 | Application Pending Realcomp #219012331 | — |
| 02/11/2019 | Listed (Active) Realcomp #219012331 | $2,100 |
For completeness, we often displays two records for one sale: the MLS record and the public record.
Schools near 1040 Lamb Road, Unit # 5
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | PK to 5 | |||
| Public - | 6 to 8 | |||
| Public - | 9 to 12 | |||
| Public - | 6 to 12 |
Rating | School | Distance |
|---|---|---|
Costello Elementary School PublicPK to 5 | ||
Larson Middle School Public6 to 8 | ||
Athens High School Public9 to 12 | ||
Troy College and Career High School Public6 to 12 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the owner's discretion. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of Mondrian Properties R E, LLC
IDX provided courtesy of Realcomp II Ltd. via Compass and its related brokerages. Copyright 2026 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. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. The data relating to real estate properties on this website was last updated on 07/07/2026 03:45 AM PST
