NOT LISTED FOR SALE

24157 Lupin Hill Rd Hidden Hills, CA 91302

Estimated Value: $5,181,361 - $7,042,000

4 Beds
4.5 Baths
4,221 Sq Ft
$1,407/Sq Ft Est. Value

Last Sold December 08, 2016

Last sale price $3,677,360 $871 Per Sq Ft

Est. 62% increase in value since last sale

Current estimated payment $36,634/month

20 Days on Market

Highlights

  • Barn
  • 24-Hour Security
  • Panoramic View
  • Round Meadow Elementary School Rated A
  • Heated Infinity Pool
  • Updated Kitchen

About This Home

As of December 2016

Absolute perfection! Completely rebuilt Hidden Hills single story with explosive, unobstructed city light views! Unparalleled quality and professionally designed with no expense spared. Truly magnificent modern traditional with a perfect open floor plan. Interior features include wide plank wood floors, custom cathedral ceilings, specialty doors and windows, and so much more. 4 bedrooms plus an office/den. Striking showplace kitchen seamlessly opens to the family room with fireplace. The grounds are awesome! All new infinity pool and spa, stone patios and decks, barbecue center, two fire pits, gardens and professional landscape. In addition, there are lower level horse facilities all with complete total privacy! Other amenities include a circular driveway, all new systems, and so much more. This is an absolute perfect estate and a very rare offering!

Last Agent to Sell the Property

Jordan Cohen

RE/MAX One License #01103362 Listed on: 10/04/2016

RE/MAX One

Last Buyer's Agent

Jordan Cohen

RE/MAX One License #01103362 Listed on: 10/04/2016

RE/MAX One

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $47,191

Year Built

  • Built in 1960 | Remodeled

Lot Details

  • 1.01 Acre Lot
  • Cul-De-Sac
  • Wrought Iron Fence
  • Vinyl Fence
  • Wood Fence
  • Sprinkler System
  • Property is zoned HHRAS1*

HOA Fees

  • $2 Monthly HOA Fees

Parking

  • 2 Car Direct Access Garage
  • Parking Available
  • Side Facing Garage
  • Circular Driveway

Property Views

  • Panoramic
  • City Lights
  • Mountain

Home Design

  • Traditional Architecture
  • Modern Architecture
  • Turnkey
  • Tile Roof

Interior Spaces

  • 4,221 Sq Ft Home
  • 1-Story Property
  • Wired For Sound
  • Built-In Features
  • Beamed Ceilings
  • Cathedral Ceiling
  • Recessed Lighting
  • Family Room with Fireplace
  • Family Room Off Kitchen
  • Living Room with Fireplace
  • Dining Room
  • Home Office
  • Wood Flooring

Kitchen

  • Updated Kitchen
  • Open to Family Room
  • Eat-In Kitchen
  • Six Burner Stove
  • Gas Range
  • Range Hood
  • Microwave
  • Freezer
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 4 Main Level Bedrooms
  • Fireplace in Primary Bedroom
  • Walk-In Closet

Pool

  • Heated Infinity Pool
  • In Ground Spa

Outdoor Features

  • Stone Porch or Patio
  • Fire Pit
  • Outdoor Grill

Additional Features

  • Barn
  • Horse Property Improved
  • Central Heating and Cooling System

Listing and Financial Details

  • Tax Lot 17
  • Assessor Parcel Number 2049012012

Community Details

Overview

  • Hidden Hills HOA

Amenities

  • Community Barbecue Grill
  • Picnic Area
  • Recreation Room

Recreation

  • Tennis Courts
  • Sport Court
  • Community Playground
  • Community Pool
  • Community Spa
  • Horse Trails

Security

  • 24-Hour Security
  • Controlled Access

Home Details

Home Type

Single Family

Est. Annual Taxes

$47,191

Year Built

Built in 1960 | Remodeled

Lot Details

0

HOA Fees

$2 per month

Parking

2

Listing Details

  • Assessments: Yes
  • Property Attached: No
  • Security: 24 Hour Security, Gated Community, Gated with Guard
  • View: Yes
  • Zoning: HHRAS1*
  • Architectural Style: Modern, Traditional
  • Property Condition: Turnkey, Updated/Remodeled
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Parcel Number: 2049012012
  • Year Built: 1960
  • Special Features: None

Interior Features

  • Fireplace: Yes
  • Living Area: 4221.00 Square Feet
  • Interior Amenities: Beamed Ceilings, Built-in Features, Cathedral Ceiling(s), Pantry, Recessed Lighting, Wired for Sound
  • Stories: 1
  • Common Walls: No Common Walls
  • Flooring: Wood
  • Accessibility Features: See Remarks
  • Appliances: Yes
  • Full Bathrooms: 4
  • Full And Three Quarter Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Eating Area: Area, Dining Room
  • Fireplace Features: Family Room, Living Room, Master Bedroom, Fire Pit
  • Levels: One
  • Main Level Bathrooms: 4
  • Main Level Bedrooms: 4
  • Price Per Square Foot: 871.21
  • Room Type: All Bedrooms Down, Family Room, Living Room, Main Floor Bedroom, Main Floor Master Bedroom, Office, Walk-In Closet
  • Spa Features: In Ground
  • Room Kitchen Features: Kitchen Island, Kitchen Open To Family Room, Remodeled Kitchen

Exterior Features

  • Patio: Yes
  • Other Structures: Barn(s)
  • Exterior Features: Barbecue Private
  • View: City Lights, Mountain(s), Panoramic
  • Fence: Yes
  • Fencing: Vinyl, Wood, Wrought Iron
  • Patio And Porch Features: Patio, Stone
  • Pool Features: Private, In Ground, Infinity, Heated
  • Pool Private: Yes
  • Roof: Tile
  • Spa: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2.00
  • Parking: Yes
  • Parking Features: Circular Driveway, Direct Garage Access, Garage Faces Side
  • Total Parking Spaces: 2.00

Utilities

  • Heating: Yes
  • Appliances: 6 Burner Stove, Barbecue, Dishwasher, Freezer, Disposal, Gas Range, Microwave, Range Hood, Refrigerator
  • Heating Type: Central
  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling: Central Air
  • Cooling: Yes

Condo/Co-op/Association

  • Association: Yes
  • Amenities: Pool, Spa/Hot Tub, Barbecue, Picnic Area, Playground, Tennis Court(s), Sport Court, Horse Trails, Recreation Room, Dues Paid Annually, Guard, Controlled Access
  • Association Fee: 26.00
  • Association Fee Frequency: Annually
  • Association Name: Hidden Hills HOA
  • Senior Community: No
  • Community Features: Horse Trails

Schools

  • School District: Las Virgenes

Lot Info

  • Additional Parcels: No
  • Lot Features: Cul-De-Sac, Horse Property Improved, Lot Over 40000 Sqft, Sprinkler System
  • Lot Size Sq Ft: 44074.00

Multi Family

  • Lease Considered: No

Tax Info

  • Tax Census Tract: 8002.03
  • Tax Lot: 17
  • Tax Tract Number: 0000

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jul 8, 2020
Sold by
Anderson Gerald and Anderson Christi
Bought by
Anderson Gerald E and Anderson Christi
Current Estimated Value
$5,972,307

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,023,000
Outstanding Balance
$912,797
Interest Rate
3.2%
Mortgage Type
New Conventional
Estimated Equity
$5,024,793

Purchase Details

Listed on
Oct 4, 2016
Closed on
Oct 26, 2016
Sold by
Milgard Lori and The Lori Milgard Living Trust
Bought by
Anderson Gerald and Anderson Christi
Seller's Agent
Jordan Cohen
RE/MAX One
Buyer's Agent
Jordan Cohen
RE/MAX One
List Price
$3,999,950
Sold Price
$3,677,360
Premium/Discount to List
-$322,590
-8.06%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.67%
Original Mortgage
$2,574,150
Outstanding Balance
$2,075,364
Interest Rate
3.47%
Mortgage Type
New Conventional
Estimated Equity
$3,862,226

Purchase Details

Closed on
Mar 6, 2015
Sold by
Gleicher Bert
Bought by
Milgard Lori and The Lori Milgard Living Trust

Purchase Details

Listed on
Aug 19, 2014
Closed on
Sep 11, 2014
Sold by
Gleicher Bonnie
Bought by
Gleicher Bert
Seller's Agent
Peter Radd
Compass
Buyer's Agent
Laura Shaw
Sothebys International Realty
List Price
$1,769,000
Sold Price
$1,725,000
Premium/Discount to List
-$44,000
-2.49%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
12.01%
Original Mortgage
$1,035,000
Interest Rate
5.12%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Listed on
Aug 19, 2014
Closed on
Sep 10, 2014
Sold by
Csfr Colfin American Investors Trs Llc
Bought by
Gleicher Bert
Seller's Agent
Peter Radd
Compass
Buyer's Agent
Laura Shaw
Sothebys International Realty
List Price
$1,769,000
Sold Price
$1,725,000
Premium/Discount to List
-$44,000
-2.49%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,035,000
Interest Rate
5.12%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Listed on
Feb 26, 2013
Closed on
Aug 21, 2013
Sold by
Lelah Tova and 24157 Lupin Hill Road Trust
Bought by
Csfr Colfin American Investors Trs Llc
Seller's Agent
Barbara Lipkin
Sothebys International Realty
Buyer's Agent
Peter Radd
Compass
List Price
$1,695,000
Sold Price
$1,365,000
Premium/Discount to List
-$330,000
-19.47%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
27.94%

Purchase Details

Closed on
Dec 20, 2010
Sold by
Albert Albert Family Trust
Bought by
24157 Lupin Hill Road Trust
Source: Public Records

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
Anderson Gerald E -- Chicago Title Company
Anderson Gerald $3,677,500 Fidelity National Title Co
Milgard Lori $2,700,000 Fidelity Title
Gleicher Bert -- Fidelity National Title Co
Gleicher Bert $1,725,000 Fidelity National Title Co
Csfr Colfin American Investors Trs Llc $1,365,000 Fidelity National Title Co
24157 Lupin Hill Road Trust -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Anderson Gerald E $1,023,000
Open Anderson Gerald $2,574,150
Previous Owner Gleicher Bert $750,000
Previous Owner Gleicher Bert $1,035,000
Previous Owner Albert Mordecai $85,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/08/2016 12/08/16 Sold $3,677,360 -8.1% $871 / Sq Ft
10/24/2016 10/24/16 Pending -- -- --
10/04/2016 10/04/16 For Sale $3,999,950 +131.9% $948 / Sq Ft
09/18/2014 09/18/14 Sold $1,725,000 -2.5% $626 / Sq Ft
08/19/2014 08/19/14 Pending -- -- --
08/19/2014 08/19/14 For Sale $1,769,000 +29.6% $642 / Sq Ft
10/07/2013 10/07/13 Sold $1,365,000 -19.5% $495 / Sq Ft
08/19/2013 08/19/13 Pending -- -- --
02/26/2013 02/26/13 For Sale $1,695,000 -- $615 / Sq Ft
Source: California Regional Multiple Listing Service (CRMLS)

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
2025 $47,191 $4,267,466 $1,972,992 $2,294,474
2024 $47,191 $4,183,791 $1,934,306 $2,249,485
2023 $46,367 $4,101,757 $1,896,379 $2,205,378
2022 $44,868 $4,021,332 $1,859,196 $2,162,136
2021 $44,843 $3,942,484 $1,822,742 $2,119,742
2019 $43,230 $3,825,550 $1,768,680 $2,056,870
2018 $42,671 $3,750,540 $1,734,000 $2,016,540
2016 $32,542 $2,888,174 $1,370,587 $1,517,587
2015 $19,564 $1,725,000 $1,380,000 $345,000
2014 $15,660 $1,365,000 $1,092,000 $273,000
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: California Regional Multiple Listing Service (CRMLS)

MLS Number: SR16717384

California Regional Multiple Listing Service (CRMLS)

APN: 2049-012-012