NOT LISTED FOR SALE

4728 Littlegate Bloomfield Hills, MI 48302

Estimated Value: $1,387,000 - $1,755,000

5 Beds
5.5 Baths
6,407 Sq Ft
$236/Sq Ft Est. Value

Last Sold February 01, 2018

Last sale price $1,215,000 $190 Per Sq Ft

Est. 25% increase in value since last sale

Current estimated payment $10,846/month

111 Days on Market

Highlights

  • 100 Feet of Waterfront
  • Outdoor Pool
  • Contemporary Architecture
  • South Hills Middle School Rated A
  • Deck
  • Jetted Tub in Primary Bathroom

About This Home

As of February 2018

A magnificent five bedroom, five full bath & one half bath Lakefront Estate located on the best homesite in the Hills of Lone Pine. This exquisite residence incls over 6400 sq ft of dramatic living space & is an entertainers delight. The sensational 2 story foyer leads to a vaulted wood ceiling great rm w/amazing views of Minnow Lake, a two sided fireplace w/wet bar, built-ins & large flr to ceiling windows, the open kitchen is bright w/great cabinet space, large center island & large walk-in pantry. This lovely estate also boast two lake view master suites w/large walk-in closets, luxurious master bath & exercise rm, 2 offices, dining rm w/built-in buffets, upper level apartment includes living rm, kitchenette, bedrm & full bath, a private screened-in porch overlooking a brick paver patio, surrounded by nature & water, three add'l suites, central vac, whole house generator, 2 cedar closets, 4 car garage & a spectacular brick paver driveway. A community pool & tennis crt. Exclusions.

Last Agent to Sell the Property

Maryclare Pulte

@properties Christie's Int'l R.E. Birmingham License #6501390704 Listed on: 09/27/2017

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

Co-Listed By

John Apap

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

Last Buyer's Agent

Nicole Rosin Perlman

Cedarwood Realty LLC, a Michigan LLC License #6501382736

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1993

Lot Details

  • 100 Feet of Waterfront
  • Lake Front
  • Gated Home

HOA Fees

  • $577 Monthly HOA Fees

Home Design

  • Contemporary Architecture
  • 1.5-Story Property
  • Brick Exterior Construction
  • Poured Concrete
  • Wood Shingle Roof

Interior Spaces

  • 6,407 Sq Ft Home
  • Wet Bar
  • Central Vacuum
  • Sound System
  • Gas Fireplace
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Water Views
  • Unfinished Basement
  • Walk-Out Basement
  • Security System Owned

Kitchen

  • Microwave
  • Dishwasher
  • Trash Compactor
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Parking

  • 4 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Outdoor Pool
  • Deck
  • Enclosed patio or porch
  • Terrace
  • Exterior Lighting

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • Sewer in Street
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 1920226128

Community Details

Overview

  • The Hills Of Lone Pine Occpn 409 Subdivision

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$28,275

Year Built

Built in 1993

Lot Details

0

HOA Fees

$577 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Contemporary, Ranch
  • Architecture Level: 1 1/2 Story
  • Warranty: Yes
  • Year Built: 1993
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Cable Available, Central Vacuum, High Spd Internet Avail, Jetted Tub, Security Alarm (owned), Sound System, Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Family Room, Great Room, Living Room
  • Room Count: 17
  • Total Bedrooms: 5
  • Total Bathrooms: 5.10
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Unfinished, Walkout Access
  • Kitchen Appliances: Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Range/Stove, Trash Compactor, Washer
  • Sq Ft Combined: 6407
  • Total Sq Ft: 6407
  • Sq Ft Total Bsmt: 5189

Exterior Features

  • Roof Material: Wood (Cedar)
  • Waterfront Name: Minnow Lake
  • Pool: Yes
  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick
  • Exclusions: Yes
  • Exterior Features: Gate House, Lighting, Pool – Community
  • Foundation Materials: Poured
  • Frontage Feet: 100
  • Porch Type: Deck, Porch - Enclosed, Terrace
  • Road Frontage Type: Paved
  • Water Frontage Feet: 100.00
  • Waterfront Description: Lake Front

Garage/Parking

  • Garage Size: 4 Car
  • Garage Features: Attached, Door Opener, Electricity
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Forced Air, Zoned
  • Sewer: Sewer at Street
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee Frequency: Quarterly
  • Association Fee: 1730
  • Association Fee: Yes

Schools

  • School District: Bloomfield Hills

Lot Info

  • Lot Features: Water View
  • Lot Dimensions: irregular
  • Parcel Number: 1920226128

Tax Info

  • Tax Amount Summer: 14195.0000
  • Tax Amount Winter: 14080.0000
  • Total Tax: 28275.0000

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 27, 2017
Closed on
Jan 25, 2018
Sold by
Fruman Dale and Fruman Lee
Bought by
Freed Larry S and Freed Helaine
Seller's Agent
Maryclare Pulte
@properties Christie's Int'l R.E. Birmingham
Buyer's Agent
Nicole Rosin Perlman
Cedarwood Realty LLC, a Michigan LLC
List Price
$1,375,000
Sold Price
$1,215,000
Premium/Discount to List
-$160,000
-11.64%
Current Estimated Value
$1,514,051

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$299,051
Avg. Annual Appreciation
3.01%

Purchase Details

Closed on
Mar 11, 2003
Sold by
Fruman Dorothy V and Fruman Albert
Bought by
Fruman Dorothy and Dorothy V Fruman Trust
Source: Public Records

Similar Homes in Bloomfield Hills, MI

  • 1265 Water Cliff Dr, Bloomfield Hills, MI 48302

    $1,599,000

    • 5 Beds
    • 6 Baths
    • 6,988 Sq Ft
    • 1265 Water Cliff Dr
    • Bloomfield Hills, MI

    Nestled on a quiet cul-de-sac, this stunning 5BR/6BA estate sits on nearly an acre with ~7,000 sqft of luxurious living space. A stately brick exterior, circular driveway, and manicured landscaping set the stage for sophistication. Inside, enjoy soaring ceilings, marble and hardwood floors, a custom office, and a gourmet kitchen with stainless steel appliances and granite counters.Relax on the

    Heather Zhou Crown Properties International

    Section Image
  • 3870 Glen Falls Dr, Bloomfield Hills, MI 48302

    $1,324,888

    • 5 Beds
    • 6 Baths
    • 5,693 Sq Ft
    • 3870 Glen Falls Dr
    • Bloomfield Hills, MI

    EXCEPTIONAL CUSTOM LUXURY HOME IN WABEEK RIDGE ON PARK LIKE LOT, APPROX 8,500 SQ FT OF TOTAL LIVING SPACE INCLUDES FULL FINISHED LOWER LEVEL, ENTER THRU LARGE FOYER WITH EQUISITE STAIRCASE, BEAUTIFUL HARDWOOD FLOORS THROUGHOUT ENTRY LEVEL, 9' CEILINGS, DELUXE CUSTOM GRANITE ISLAND KITCHEN WITH LARGE BUILT-IN FRIDGE/FREEZER, DELUXE APPLIANCES, LARGE FAMILY ROOM WITH STONE SURROUND GAS FIREPLACE &

    Mark Warren Berkshire Hathaway HomeServices Kee Realty Bham

    Section Image
  • 596 Rudgate Rd, Bloomfield Hills, MI 48304

    $1,599,000

    • 5 Beds
    • 5 Baths
    • 2,975 Sq Ft
    • 596 Rudgate Rd
    • Bloomfield Hills, MI

    This mid-century modern home presents a wonderful opportunity to renovate or build new in the Cranbrook community! Nestled on almost 2.5 acres of gradual rolling grounds, the sprawling ranch boasts a panoramic view with Cranbrook Educational Community in the background and an in-ground pool with mature trees. This 5-bedroom home is graced with character, featuring exposed brick, vaulted

    Katherine Broock Max Broock, REALTORS®-Birmingham

    Section Image
  • 1772 Heron Ridge Dr, Bloomfield Hills, MI 48302

    $1,675,000

    • 4 Beds
    • 6 Baths
    • 4,800 Sq Ft
    • 1772 Heron Ridge Dr
    • Bloomfield Hills, MI

    Professionally Designed and updated superb home in Bloomfield Hills. The location itself is magnificent, nestled in an exclusive andsought after area surrounded by tranquil natural views. Spacious and comfortable, this 4 bedroom, 6 bath, 4800 square foot home has everything you need. As you tour this home, you will quickly fall in love with the large rooms and exceptional attention to detail

    Tushar Vakhariya KW Domain

    Section Image
  • 457 N Cranbrook Rd, Bloomfield Hills, MI 48301

    $1,475,000

    • 5 Beds
    • 5.5 Baths
    • 3,685 Sq Ft
    • 457 N Cranbrook Rd
    • Bloomfield Hills, MI

    Perfectly situated in the heart of desirable Bloomfield Village, this beautifully maintained 5 bedroom, 5.1 bath Colonial is framed by lush landscaping, offering an elegant first impression. From the classic aggregate circular driveway, a gracious marble foyer welcomes you inside where a sweeping staircase with brass-capped wrought iron railings set a refined tone. Rich hardwood floors, extensive

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

    Section Image
  • 320 N Berkshire Rd, Bloomfield Hills, MI 48302

    $1,300,000

    • 4 Beds
    • 5 Baths
    • 3,441 Sq Ft
    • 320 N Berkshire Rd
    • Bloomfield Hills, MI

    Nestled on 1.5 acres of serene, wooded landscape, this exquisite estate offers the ultimate in privacy, elegance, and comfort. Meticulously maintained and masterfully designed, the home features over 3,400 square feet of open-concept living, complemented by a fully finished walkout lower level tailored for refined relaxation and grand scale entertaining. Four spacious bedrooms are accompanied

    Midge Moran KW Showcase Realty

    Section Image
  • 130 Endicott Rd, Bloomfield Hills, MI 48304

    $1,375,000

    • 4 Beds
    • 6 Baths
    • 3,803 Sq Ft
    • 130 Endicott Rd
    • Bloomfield Hills, MI

    Location, Location, Location Says it All... This spacious ranch rests on 1.15 acres in one of the best locations in the City of Bloomfield Hills with Birmingham Schools. An amazing lot featuring the entire backyard with the Rouge River running through it, which that in itself makes this a very rare find. Enjoy over 4000 sqft of living space, 4-bedrooms, 4.2 baths, 4-car, in-ground pool,

    Michael Sbrocca Max Broock, REALTORS®-Birmingham

    Section Image
  • 1968 Maplewood Ave, Bloomfield Hills, MI 48302

    $1,349,000

    • 4 Beds
    • 5.5 Baths
    • 3,342 Sq Ft
    • 1968 Maplewood Ave
    • Bloomfield Hills, MI

    Prepare to be amazed! No expense was spared with this gorgeous 3-year-old custom-built home with 5,000 sq ft of newly finished living space indoors and tons more outside, including a stunning heated in-ground pool, multiple patios, and professional landscaping. This spacious home has 5 bedrooms (all with walk-in closets) and 5.5 baths, including 2 true main suites (one on each level). The soaring

    Michael Hami Powell Real Estate

    Section Image

Range of Values:

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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Freed Larry S -- None Available
Fruman Dorothy -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Freed Larry S $1,425,000
Closed Tee Larry S Freed Trust $1,425,000
Closed Freed Larry S $972,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/01/2018 02/01/18 Sold $1,215,000 -11.6% $190 / Sq Ft
01/16/2018 01/16/18 Pending -- -- --
09/27/2017 09/27/17 For Sale $1,375,000 -- $215 / Sq Ft
Source: Realcomp

Tax History Compared to Growth

Source: Public Records

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 $22,407 $1,265,780 $0 $0
2023 $21,684 $1,220,490 $0 $0
2022 $40,749 $1,185,590 $0 $0
2021 $40,456 $1,151,240 $0 $0
2020 $19,831 $1,093,540 $0 $0
2019 $30,594 $822,210 $0 $0
2018 $22,581 $951,740 $0 $0
2017 $28,364 $928,940 $0 $0
2016 $28,274 $889,630 $0 $0
2015 -- $745,350 $0 $0
2014 -- $646,980 $0 $0
2011 -- $525,960 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Realcomp

MLS Number: 217086965

Realcomp

APN: 19-20-226-128