RENTED MAR 16, 2026

Estimated Value: $730,000 - $1,128,000

4 Beds
3.5 Baths
5,185 Sq Ft
$189/Sq Ft Est. Value

Sale Details

Date Sold: June 17, 2014

Last sale price $550,000 $106 Per Sq Ft

Est. 78% increase in value since last sale

Current estimated payment $6,728 / mo

Highlights

  • 77 Feet of Waterfront
  • Air Purifier
  • Forced Air Heating and Cooling System
  • Fireplace in Primary Bedroom
  • Programmable Thermostat
  • Garage

About This Home

As of March 2026

Experience refined lakefront living on all-sports Upper Long Lake, with direct access to Forest Lake and Lower Long Lake. Offering 4,285 total square feet including a walkout lower level, this beautifully positioned home captures sweeping water views and exceptional natural light throughout.
The light-drenched interior features expansive open living and entertaining spaces designed for both relaxed everyday living and unforgettable gatherings. Walls of windows frame the sparkling lake, seamlessly blending indoor comfort with the beauty of the outdoors. The home features a desirable first-floor primary suite, offering privacy and convenience, along with three additional bedrooms upstairs to comfortably accommodate family and guests. Step outside to embrace everything lake life has to offer — from boating and swimming to peaceful sunset evenings overlooking the water. Tenant may dock a boat for an additional fee; boat must be properly insured and registered. Credit report & employment verification are to be submitted with the lease application. 1.5-month security deposit, first month’s rent, and a $450 non-refundable cleaning fee due at signing. This exceptional lakefront retreat offers a rare opportunity to enjoy private waterfront living at its finest.

Last Agent to Rent the Property

Cindy Obron Kahn

The Agency Hall & Hunter License #6501316961 Listed on: 02/20/2026

The Agency Hall & Hunter

Co-Listed By

Emily Kahn

The Agency Hall & Hunter License #6501433986

Last Renter's Agent

Kathleen Remski

@properties Christie's Int'l R.E. Birmingham License #6501428937

@properties Christie's Int'l R.E. Birmingham

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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 Details

Home Type

  • Single Family

Year Built

  • Built in 1979 | Remodeled in 2000

Lot Details

  • 23,522 Sq Ft Lot
  • Lot Dimensions are 131x249x77x252
  • 77 Feet of Waterfront
  • Lake Front
  • Home fronts a canal

Parking

  • Garage

Home Design

  • Brick Exterior Construction
  • Block Foundation
  • Slab Foundation
  • Asphalt Roof

Interior Spaces

  • Great Room with Fireplace
  • Water Views
  • Basement

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Programmable Thermostat
  • Natural Gas Water Heater
  • Septic Tank
  • Cable TV Available

Additional Features

  • Air Purifier
  • Exterior Lighting
  • Ground Level

Listing and Financial Details

  • Security Deposit $9,000
  • 12 Month Lease Term
  • Assessor Parcel Number 1907176008

Community Details

Overview

  • Upper Long Lake Estates Subdivision

Recreation

  • Water Sports

Home Details

Home Type

Single Family

Year Built

Built in 1979 | Remodeled in 2000

Lot Details

0.54 Acres

Parking

2

Rental Info

  • Lease Type: SingleFamilyHouse
  • Rent Includes: AssociationFee
  • Security Deposit: 9000.00

Listing Details

  • Property Type: ResidentialLease
  • Year Built: 1979
  • Year Renovated: 2000
  • Entry Location: GroundLevelwSteps
  • Pets Allowed: No
  • Property Sub Type: SingleFamilyResidence
  • LotSizeAcres: 0.54
  • Water Body Name: Upper Long Lake
  • Co List Office Mls Id: 188713
  • Co List Office Phone: 2486443500
  • Co List Office Mls Id: 188713
  • Above Grade Finished Sq Ft: 4285.00
  • Living Area: 5185.00
  • ClassName: ResidentialLease
  • LeaseTermsAvailable: Months12
  • ThirdPartyApprovalRequiredYN: No
  • Special Features: None

Interior Features

  • Interior Amenities: ProgrammableThermostat
  • Fireplace: Yes
  • Basement: Yes
  • Other Equipment: AirPurifier
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 900.00
  • Fireplace Features: GreatRoom, MasterBedroom

Exterior Features

  • Waterfront: Yes
  • Foundation Details: Basement, Block, Slab
  • Construction Materials: Brick
  • Exterior Features: Lighting
  • Road Frontage Type: Paved
  • Water Frontage Feet: 77.00
  • Disclosures: NoSmokingAllowed
  • Roof: Asphalt

Garage/Parking

  • Garage: Yes

Utilities

  • Cooling: CentralAir
  • Heating: ForcedAir, NaturalGas
  • Sewer: SepticTank
  • Water Heater Fuel: NaturalGas
  • Water Source: Public
  • Utilities: CableAvailable

Fee Information

  • Additional Fee: 450.00

Schools

  • Junior High Dist: Pontiac

Lot Info

  • Lot Features: WaterView
  • Lot Dimensions: 131x249x77x252
  • Parcel Number: 1907176008

Multi Family

  • Waterfront Features: AllSportsLake, CanalFront, LakeFront
  • Above Grade Finished Area Units: SquareFeet

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 19, 2014
Closed on
Jun 10, 2014
Sold by
Roy Manjula N
Bought by
Seller's Agent
Susan Lozano
@properties Christie's Int'l R.E. Birmingham
Buyer's Agent
Susan Lozano
@properties Christie's Int'l R.E. Birmingham
Sold Price
$2,700
Current Estimated Value
$980,021

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$977,321
Avg. Annual Appreciation
4.84%

Purchase Details

Closed on
Feb 9, 1998
Sold by
Roy Asou K
Bought by
Roy Manjula An
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Bloomfield Hills, MI

See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
-- Interstate Title Inc
Roy Manjula An -- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Previous Owner $220,700
Previous Owner Roy Manjulan $125,000
Previous Owner Roy Md Asok K $250,000
Previous Owner Roy Asok $200,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/16/2026 03/16/26 Rented $6,000 0.0% --
02/20/2026 02/20/26 For Rent $6,000 +27.7% --
08/01/2023 08/01/23 Rented $4,700 -4.1% --
07/06/2023 07/06/23 Under Contract -- -- --
05/31/2023 05/31/23 For Rent $4,900 -16.9% --
01/18/2023 01/18/23 Rented $5,900 0.0% --
11/21/2022 11/21/22 For Rent $5,900 +73.5% --
05/18/2019 05/18/19 Rented $3,400 -2.9% --
05/18/2019 05/18/19 Under Contract -- -- --
02/04/2019 02/04/19 For Rent $3,500 +6.1% --
01/15/2018 01/15/18 Rented $3,300 -5.7% --
08/10/2017 08/10/17 For Rent $3,500 +20.7% --
02/18/2016 02/18/16 Rented $2,900 -21.6% --
02/08/2016 02/08/16 Under Contract -- -- --
07/27/2015 07/27/15 For Rent $3,700 +37.0% --
07/16/2014 07/16/14 Rented $2,700 -22.9% --
07/14/2014 07/14/14 Under Contract -- -- --
06/19/2014 06/19/14 For Rent $3,500 0.0% --
06/17/2014 06/17/14 Sold $550,000 -7.7% $213 / Sq Ft View Prior Sale
05/30/2014 05/30/14 Pending -- -- --
05/01/2014 05/01/14 For Sale $595,900 0.0% $231 / Sq Ft
01/13/2012 01/13/12 Rented $3,000 -6.3% --
01/09/2012 01/09/12 Under Contract -- -- --
12/06/2011 12/06/11 For Rent $3,200 -- --
Source: Realcomp

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2025 $15,855 $465,730 $208,030 $257,700
2024 $15,400 $465,730 $0 $0
2023 $14,680 $429,920 $0 $0
2022 $19,430 $414,580 $0 $0
2021 $18,919 $410,460 $0 $0
2020 $13,430 $402,010 $0 $0
2019 $18,672 $390,780 $0 $0
2018 $18,199 $382,470 $0 $0
2017 $17,791 $373,050 $0 $0
2016 $17,730 $356,880 $0 $0
2015 -- $345,830 $0 $0
2014 -- $311,050 $0 $0
2011 -- $255,410 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20261010098

Realcomp

APN: 19-07-176-008

Your Personal Tour Guide

Ask me questions while you tour the home.