NOT LISTED FOR SALE

5057 Stern Ave Sherman Oaks, CA 91423

Estimated Value: $3,598,869 - $4,133,000

5 Beds
5.5 Baths
5,003 Sq Ft
$767/Sq Ft Est. Value

Last Sold November 28, 2017

Last sale price $2,450,000 $490 Per Sq Ft

Est. 57% increase in value since last sale

Current estimated payment $23,665/month

102 Days on Market

Highlights

  • Home Theater
  • Newly Remodeled
  • Primary Bedroom Suite
  • Chandler Elementary Rated A-
  • Heated Spa
  • Open Floorplan

About This Home

As of November 2017

Welcome to this Architectural masterpiece w/ dramatic curb appeal situated on an amazing tree-lined street in the “ Fashion Square” district of Sherman Oaks. Blending modern features w/ traditional & exuding true elegance, this spectacular home boasts 5 BR + 5 1/2 BA, + Office, approx. 5,000 sq. ft. of living area on an 8,450 sq. ft. lot. The explosive entry w/floating ceilings leads you to a wide open floor plan w/a seamless flow & sun drenched rooms thru- out. Incredible chef’s kitchen with top of the line SS appliances, large wine rack, quartz counters & center island opening to large family room w/ fireplace. Accordion doors open to entertainers paradise featuring a sparkling heated pool/spa, 2 diff seating areas w/ built- in barbecue covered by stylish gazebo, & lounge area, perfect for California living. Master suite w/ vaulted ceilings, walk-in closet, wrap around balcony & sleek spa like Bath featuring dual sink vanities, glass enclosed shower w/ floating tub. All secondary bedrooms are en-suite w/ 3 upstairs and 1 down. Other amenities include: Plush home theatre w/ state of the art sound system, upstairs laundry rm., large side yard, security cameras, alarm system, Crestron AV system & exterior lighting . Conveniently located near Westfield mall, 101 freeway, Trader Joes & Ventura Blvd. Truly one of kind home!!

Last Agent to Sell the Property

Stephen Pannesco

Coldwell Banker Realty License #01281276 Listed on: 06/29/2017

Coldwell Banker Realty

Co-Listed By

Nikki Joel

No Firm Affiliation License #01784589

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $33,236

Year Built

  • Built in 2017 | Newly Remodeled

Lot Details

  • 8,449 Sq Ft Lot
  • Wood Fence
  • Block Wall Fence
  • Rectangular Lot
  • Level Lot
  • Sprinkler System
  • Back and Front Yard
  • Property is zoned LAR1

Parking

  • 2 Car Garage
  • Parking Available
  • Single Garage Door

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Composition Roof
  • Pre-Cast Concrete Construction
  • Stucco

Interior Spaces

  • 5,003 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wired For Sound
  • Wired For Data
  • Beamed Ceilings
  • Suspended Ceiling
  • Cathedral Ceiling
  • Recessed Lighting
  • Double Pane Windows
  • Sliding Doors
  • Family Room with Fireplace
  • Living Room
  • Dining Room
  • Home Theater
  • Home Office
  • Tile Flooring

Kitchen

  • Breakfast Bar
  • Six Burner Stove
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms | 1 Main Level Bedroom
  • Fireplace in Primary Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet
  • Stone Bathroom Countertops
  • Dual Vanity Sinks in Primary Bathroom
  • Private Water Closet
  • Separate Shower

Laundry

  • Laundry Room
  • 220 Volts In Laundry

Pool

  • Heated Spa
  • In Ground Spa
  • Gas Heated Pool
  • Gunite Pool
  • Gunite Spa

Outdoor Features

  • Balcony
  • Patio
  • Outdoor Grill
  • Rain Gutters
  • Wrap Around Porch

Utilities

  • Central Heating and Cooling System
  • 220 Volts For Spa
  • 220 Volts in Garage
  • 220 Volts in Kitchen
  • Tankless Water Heater
  • Sewer Paid
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 2269005018

Home Details

Home Type

Single Family

Est. Annual Taxes

$33,236

Year Built

Built in 2017 | Newly Remodeled

Lot Details

0

Parking

2

Listing Details

  • Assessments: Yes
  • Property Attached: No
  • View: No
  • Zoning: LAR1
  • Architectural Style: Contemporary
  • New Construction: Yes
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Parcel Number: 2269005018
  • Year Built: 2017
  • Special Features: None

Interior Features

  • Fireplace: Yes
  • Living Area: 5003.00 Square Feet
  • Interior Amenities: Balcony, Beamed Ceilings, Cathedral Ceiling(s), High Ceilings, Open Floorplan, Recessed Lighting, Suspended Ceiling(s), Wired for Data, Wired for Sound
  • Stories: 2
  • Common Walls: No Common Walls
  • Flooring: Tile
  • Appliances: Yes
  • Full Bathrooms: 5
  • Full And Three Quarter Bathrooms: 5
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Door Features: Sliding Doors
  • Eating Area: Breakfast Counter / Bar, Dining Room
  • Fireplace Features: Family Room, Master Bedroom
  • Levels: Two
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 1
  • Price Per Square Foot: 489.71
  • Room Type: Family Room, Home Theatre, Laundry, Living Room, Master Suite, Office, Walk-In Closet
  • Spa Features: Gunite, Heated, In Ground
  • Window Features: Double Pane Windows
  • Bathroom Features: Double Sinks In Master Bath, Privacy Toilet Door, Separate Tub And Shower, Stone Counters

Exterior Features

  • Patio: Yes
  • Foundation: Slab
  • Exterior Features: Barbecue Private, Rain Gutters
  • Fence: Yes
  • Fencing: Block, Wood
  • Patio And Porch Features: Stone, Wrap Around
  • Pool Features: Private, Heated, Gas Heat, Gunite
  • Pool Private: Yes
  • Roof: Composition
  • Spa: Yes
  • Construction Materials: Concrete, Stucco

Garage/Parking

  • Garage Spaces: 2.00
  • Parking: Yes
  • Parking Features: Paved, Garage, Garage - Single Door
  • Total Parking Spaces: 2.00

Utilities

  • Utilities: Cable Available
  • Heating: Yes
  • Laundry: Yes
  • Appliances: 6 Burner Stove, Barbecue, Dishwasher, Disposal, Gas Range, Gas Cooktop, Microwave, Range Hood, Refrigerator, Tankless Water Heater
  • Electric: 220 Volts For Spa, 220 Volts in Garage, 220 Volts in Kitchen, 220 Volts in Laundry
  • Heating Type: Central
  • Laundry Features: Individual Room
  • Sewer: Sewer Paid
  • Water Source: Public
  • Cooling: Central Air
  • Cooling: Yes

Condo/Co-op/Association

  • Association: No
  • Senior Community: No
  • Community Features: Curbs, Gutters

Schools

  • School District: Los Angeles Unified

Lot Info

  • Additional Parcels: No
  • Land Lease: No
  • Lot Features: Back Yard, Front Yard, Level with Street, Lot 6500-9999, Rectangular Lot, Sprinkler System
  • Lot Size Sq Ft: 8449.00

Multi Family

  • Lease Considered: No
  • Number Of Units In Community: 1
  • Number Of Units Total: 1

Tax Info

  • Tax Census Tract: 1287.02

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Feb 15, 2021
Sold by
Hayslip Thomas and Tat Viet
Bought by
Hayslip Thomas and Tat Viet
Current Estimated Value
$3,834,967

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,938,000
Interest Rate
2.65%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jun 29, 2017
Closed on
Oct 11, 2017
Sold by
5057 Stern Llc
Bought by
Hayslip Thomas and Tat Viet
Seller's Agent
Stephen Pannesco
Coldwell Banker Realty
List Price
$2,699,000
Sold Price
$2,450,000
Premium/Discount to List
-$249,000
-9.23%

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.97%
Original Mortgage
$2,082,500
Interest Rate
3.91%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Oct 19, 2016
Sold by
Aichel Udi
Bought by
5057 Stern Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,400,000
Interest Rate
3.48%
Mortgage Type
Commercial

Purchase Details

Closed on
May 3, 2016
Sold by
Brasler Laurence Martin
Bought by
Aichel Udi and Aichel Shahar

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$647,500
Interest Rate
3.64%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
May 26, 2004
Sold by
Brasler Lee
Bought by
Brasler Lee and Brasler Family Survivors Trust A

Purchase Details

Closed on
May 4, 1999
Sold by
Brasler Lee
Bought by
The Brasler Banarer Family 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
Hayslip Thomas -- Chicago Title Company
Hayslip Thomas $2,450,000 Equity Title
5057 Stern Llc -- California Title Company
Aichel Udi $925,000 Equity Title
Brasler Lee -- --
Brasler Lee -- --
The Brasler Banarer Family Trust -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hayslip Thomas $1,920,200
Closed Hayslip Thomas $1,938,000
Closed Hayslip Thomas $2,000,000
Previous Owner Hayslip Thomas $2,082,500
Previous Owner 5057 Stern Llc $1,400,000
Previous Owner Aichel Udi $647,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/28/2017 11/28/17 Sold $2,450,000 -9.2% $490 / Sq Ft
10/09/2017 10/09/17 Pending -- -- --
06/29/2017 06/29/17 For Sale $2,699,000 -- $539 / 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 $33,236 $2,787,678 $877,265 $1,910,413
2024 $33,236 $2,733,018 $860,064 $1,872,954
2023 $32,585 $2,679,430 $843,200 $1,836,230
2022 $31,058 $2,626,893 $826,667 $1,800,226
2021 $30,671 $2,575,386 $810,458 $1,764,928
2020 $30,988 $2,548,979 $802,148 $1,746,831
2019 $29,744 $2,499,000 $786,420 $1,712,580
2018 $29,596 $2,450,000 $771,000 $1,679,000
2017 $0 $925,000 $685,500 $239,500
2016 $1,955 $154,595 $46,364 $108,231
2015 $1,928 $152,274 $45,668 $106,606
2014 $1,943 $149,292 $44,774 $104,518
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: California Regional Multiple Listing Service (CRMLS)

MLS Number: SR17147556

California Regional Multiple Listing Service (CRMLS)

APN: 2269-005-018