NOT LISTED FOR SALE

18663 Warwick St Beverly Hills, MI 48025

Beverly Hills Area

Estimated Value: $769,000 - $1,107,000

3 Beds
2.5 Baths
2,129 Sq Ft
$441/Sq Ft Est. Value

Sale Details

Date Sold: August 28, 2012

Last sale price $340,000 $160 Per Sq Ft

Est. 176% increase in value since last sale

Current estimated payment $6,021 / mo

10 Days on Market

Highlights

  • Ranch Style House
  • Corner Lot
  • Porch
  • Beverly Elementary School Rated A
  • No HOA
  • 2-minute walk to Beverly Hills Village Park

About This Home

As of August 2012

IMMACULATE! QUALITY CUSTOM BUILT HOUSE W/ MAGNIFICENT '06 MASTER SUITE ADDITION, BAY WINDOWS, FRENCH DOORS, STEAM SHOWER & WALK-IN CLOSET. 3 BDRMS, 2 RENOVATED BATHS. BRIGHT, OPEN FLR PLAN INCLUDING LR W/ FIREPLACE & 4 SEASON SUNROOM / FR LEADS OUT TO LOVELY BACK YARD. COVED CEILING W/ CROWN MOLDING. HARDWOOD FLRS. NEW ROOF & INSULATION IN '06. FULL BASEMENT W/ LAV. 2 CAR GARAGE. GORGEOUS LOT, BEAUTIFUL PERENNIAL GARDENS.

Last Agent to Sell the Property

Linda Novak

Max Broock, REALTORS®-Birmingham License #6505307912 Listed on: 06/12/2012

Max Broock, REALTORS®-Birmingham

Last Buyer's Agent

Gayle Hannett

Temporary Inactive Users License #RCO-6501260102

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

Est. Annual Taxes

Year Built

  • Built in 1951

Lot Details

  • 14,810 Sq Ft Lot
  • Lot Dimensions are 103x141
  • Corner Lot

Home Design

  • Ranch Style House
  • Brick Exterior Construction

Interior Spaces

  • 2,129 Sq Ft Home
  • Living Room with Fireplace
  • Partially Finished Basement
  • Fireplace in Basement

Kitchen

  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Patio
  • Exterior Lighting
  • Shed
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Beverly Hills Sub No 4 Subdivision

Listing and Financial Details

  • Assessor Parcel Number 2402279001

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,565

Year Built

Built in 1951

Lot Details

0.34 Acres

Listing Details

  • Property Type: Residential
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Year Built: 1951
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Cable Available
  • Fireplace: Yes
  • Fireplace Locations: Basement, Living Room
  • Total Bedrooms: 3
  • Total Bathrooms: 2.10
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Partially Finished
  • Kitchen Appliances: Dishwasher, Disposal, Refrigerator, Range/Stove
  • Total Sq Ft: 2129

Exterior Features

  • Foundation Details: Basement
  • Construction Materials: Brick
  • Exterior Features: Lighting, Shed
  • Porch Type: Patio, Porch
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached, Door Opener, Side Entrance
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee: No

Lot Info

  • Homestead: Yes
  • List Price per Acre: 997059.0000
  • Lot Features: Corner Lot
  • Lot Size Area: 0.34
  • Lot Dimensions: 103X141
  • Parcel Number: 2402279001

Tax Info

  • Tax Amount Summer: 4711.0000
  • Tax Amount Winter: 854.0000
  • Total Tax: 5565.0000

MLS Schools

  • School District: Birmingham

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 12, 2012
Closed on
Aug 28, 2012
Sold by
The Ronald S Herman Trust
Bought by
Seller's Agent
Linda Novak
Max Broock, REALTORS®-Birmingham
Buyer's Agent
Gayle Hannett
Temporary Inactive Users
List Price
$339,000
Sold Price
$340,000
Premium/Discount to List
$1,000
0.29%
Current Estimated Value
$938,583

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$598,583
Avg. Annual Appreciation
7.50%
Original Mortgage
$272,000
Interest Rate
3.56%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 21, 2007
Sold by
Herman Ronald S and Herman Sharon
Bought by
The Ronald S Herman Trust

Purchase Details

Closed on
Aug 15, 2003
Sold by
Nelson Tillie A and C Claire Mittendorf Revocable
Bought by
Herman Ronald S and Herman Sharon

Purchase Details

Closed on
Jul 10, 2000
Sold by
Mitendorf C C
Bought by
C Claire Mittendorf Tr
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Beverly Hills, MI

  • Denise Bellore Real Estate Agent - Keller Williams Paint Creek

    Denise Bellore

    Keller Williams Paint Creek

    (989) 368-2944

    65 Total Sales

    1 in Beverly Hills

    $295,000 Price

    Denise Bellore
     Section Image
  • Mark Gibeau Real Estate Agent - EXP Realty Rochester

    Mark Gibeau

    EXP Realty Rochester

    (248) 927-1113

    105 Total Sales

    1 in Beverly Hills

    $600,000 Price

    Mark Gibeau
     Section Image
  • Debbie Corey Real Estate Agent - Berkshire Hathaway HomeServices Kee Realty

    Debbie Corey

    Berkshire Hathaway HomeServices Kee Realty

    (947) 218-7861

    107 Total Sales

    1 in Beverly Hills

    $530,000 Price

    Debbie Corey
     Section Image
  • James Wolfe Real Estate Agent - Century 21 Curran & Oberski

    James Wolfe

    Century 21 Curran & Oberski

    (947) 886-8334

    246 Total Sales

    1 in Beverly Hills

    $455,000 Price

    James Wolfe
     Section Image
  • Caroline Chen Real Estate Agent - Crown Properties International

    Caroline Chen

    Responds Quickly

    Crown Properties International

    (947) 221-4285

    80 Total Sales

    1 in Beverly Hills

    $740,000 Price

    Caroline Chen
     Section Image
  • Melissa Michels Real Estate Agent - Berkshire Hathaway HomeServices Kee Realty Bham

    Melissa Michels

    Berkshire Hathaway HomeServices Kee Realty Bham

    (586) 666-1775

    38 Total Sales

    1 in Beverly Hills

    $420,000 Price

    Melissa Michels
     Section Image
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
-- None Available
Drummond Andrew M $340,000 None Available
The Ronald S Herman Trust -- None Available
Herman Ronald S $343,900 Philip R Seaver Title Co Inc
C Claire Mittendorf Tr -- --
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
Open $461,250
Closed Drummond Andrew M $417,000
Closed Drummond Andrew M $93,000
Previous Owner Drummond Andrew M $272,000
Previous Owner Herman Sharon $50,000
Previous Owner Herman Ronald S $30,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
08/28/2012 08/28/12 Sold $340,000 +0.3% $160 / Sq Ft
06/22/2012 06/22/12 Pending -- -- --
06/12/2012 06/12/12 For Sale $339,000 -- $159 / Sq Ft
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 $10,104 $424,580 $0 $0
2024 $9,848 $402,650 $0 $0
2023 $9,448 $386,490 $0 $0
2022 $10,248 $368,010 $0 $0
2021 $10,332 $356,190 $0 $0
2020 $8,655 $347,900 $0 $0
2019 $6,838 $328,290 $0 $0
2018 $9,767 $300,690 $0 $0
2017 $9,648 $300,690 $0 $0
2016 $6,940 $208,190 $0 $0
2015 -- $196,860 $0 $0
2014 -- $167,720 $0 $0
2011 -- $126,750 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Linda Novak Real Estate Agent - Max Broock, REALTORS®-Birmingham

    Seller's Agent in 2012

    Linda Novak

    Max Broock, REALTORS®-Birmingham

    (248) 408-7811

    73 Total Sales

    Linda Novak
    Section Image

  • GH

    Buyer's Agent in 2012

    Gayle Hannett

    Temporary Inactive Users

  • JH

    Buyer's Agent in 2012

    John Hannett

    Temporary Inactive Users

    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 212060359

Realcomp

APN: 24-02-279-001

Michigan Oakland County Beverly Hills 48025

18663 Warwick St, Beverly Hills, MI

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.

Realcomp IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
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.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.