NOT LISTED FOR SALE

1520 Esplanade Dr Merced, CA 95348

Estimated Value: $468,000 - $524,000

4 Beds
2.5 Baths
2,374 Sq Ft
$208/Sq Ft Est. Value

Last Sold August 15, 2024

Last sale price $500,000 $211 Per Sq Ft

Est. 1% decrease in value since last sale

Current estimated payment $3,041/month

11 Days on Market

Highlights

  • No HOA
  • Walk-In Closet
  • Living Room
  • 2 Car Attached Garage
  • Tile Countertops
  • Laundry Room

About This Home

As of August 2024

Gorgeous two-story house in desirable El Redondo neighborhood in North Merced. High ceiling in living room, open concept kitchen connects to spacious family room with built-in cabinets and lots of windows. Upgraded floor throughout, no carpet, very clean and easy to maintain. Two-zone central heating and cooling with two smart thermostats Nest. Two-tone interior painting. Pantry and luxurious microwave, 5 burner gas stove in the kitchen. Upstairs have master suite room and 3 hallway bedrooms. Walk-in closet in the master suite. Each bedroom has ceiling light/fan. Washer and dryer in the laundry room will stay. Beautifully landscaped. Tile roof, double paned windows, attached two car garage with automatic garage opener. Don't miss this awesome opportunity to own such a big and well-maintained house in North Merced.

Last Agent to Sell the Property

Yue Ma

Horizon Journey Inc Brokerage Phone: 408-655-4138 License #01899365 Listed on: 07/18/2024

Last Buyer's Agent

Debra Cowden

London Properties Ltd - Merced License #00947451

London Properties Ltd - Merced

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,416

Year Built

  • Built in 2006

Lot Details

  • 5,710 Sq Ft Lot
  • Front Yard Sprinklers
  • Property is zoned R-1-5

Parking

  • 2 Car Attached Garage

Home Design

  • Entry on the 1st floor

Interior Spaces

  • 2,374 Sq Ft Home
  • 2-Story Property
  • Gas Fireplace
  • Family Room with Fireplace
  • Living Room

Kitchen

  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Tile Countertops

Bedrooms and Bathrooms

  • 4 Bedrooms
  • All Upper Level Bedrooms
  • Walk-In Closet

Laundry

  • Laundry Room
  • Laundry on upper level
  • Dryer
  • Washer

Utilities

  • Central Heating and Cooling System
  • Water Heater

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Tax Lot 398
  • Assessor Parcel Number 058467004000
  • $633 per year additional tax assessments

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,416

Year Built

Built in 2006

Lot Details

0

Parking

2

Listing Details

  • Structure Type: House
  • Assessments: Yes
  • Inclusions: Refrigerator, washer and dryer
  • Property Attached: No
  • View: No
  • Zoning: R-1-5
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Parcel Number: 058467004000
  • Year Built: 2006
  • Special Features: None

Interior Features

  • Fireplace: Yes
  • Living Area: 2374.00 Square Feet
  • Stories: 2
  • Common Walls: No Common Walls
  • Appliances: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Entry Level: 1
  • Fireplace Features: Family Room, Gas
  • Levels: Two
  • Main Level Bathrooms: 1
  • Price Per Square Foot: 210.61
  • Room Type: All Bedrooms Up, Laundry, Living Room, Walk-In Closet
  • Room Kitchen Features: Kitchen Island, Tile Counters

Exterior Features

  • Pool Private: No

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2.00
  • Total Parking Spaces: 2.00

Utilities

  • Sprinklers: Yes
  • Heating: Yes
  • Laundry: Yes
  • Appliances: Dishwasher, Gas Range, Microwave, Refrigerator, Water Heater
  • Heating Type: Central
  • Laundry Features: Dryer Included, Inside, Upper Level, Washer Included
  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling: Central Air
  • Cooling: Yes

Condo/Co-op/Association

  • Association: No
  • Senior Community: No
  • Community Features: Sidewalks

Lot Info

  • Additional Parcels: No
  • Land Lease: No
  • Lot Features: Sprinklers In Front
  • Lot Size Sq Ft: 5710.00
  • Lot Size Acres: 0.1311
  • Latitude Manual: 37.33116400

Multi Family

  • Lease Considered: No
  • Lot Size Area: 5710.0000 Square Feet
  • Number Of Units Total: 1

Tax Info

  • Tax Census Tract: 10.08
  • Tax Lot: 398
  • TaxOtherAnnualAssessmentAmount: 633.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 18, 2024
Closed on
Aug 14, 2024
Sold by
Leung Edmond Yiuman and Leun Ada
Bought by
Huang Minxuan and Zhao Jingyuan
Seller's Agent
Yue Ma
Horizon Journey Inc
Buyer's Agent
Debra Cowden
London Properties Ltd - Merced
List Price
$510,000
Sold Price
$500,000
Premium/Discount to List
-$10,000
-1.96%
Views
57
Current Estimated Value
$494,833

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$5,167
Avg. Annual Appreciation
-0.86%
Original Mortgage
$300,000
Outstanding Balance
$296,657
Interest Rate
6.95%
Mortgage Type
New Conventional
Estimated Equity
$198,176

Purchase Details

Listed on
Jan 4, 2022
Closed on
Jan 12, 2022
Sold by
Tucker and Yesenia
Bought by
Edmond Yiuman Leung And Ada Pui-Yee Leung Rev and Pu Ada
Seller's Agent
Ty Ataei
Realty One Group Infinity
Buyer's Agent
Yue Ma
Horizon Journey Inc.
List Price
$438,000
Sold Price
$460,000
Premium/Discount to List
$22,000
5.02%

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 6, 2020
Sold by
Tucker Ernest Lee
Bought by
Tucker Ernest and Cervantes Tucker Yesenia

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$262,500
Interest Rate
2.9%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jul 27, 2018
Closed on
Sep 7, 2018
Sold by
Cervantes-Tucker Yesenia
Bought by
Tucker Ernest Lee
Seller's Agent
Kelly Perry
Epique Realty
Buyer's Agent
Armando Diaz
Soldavi Inc.
List Price
$299,000
Sold Price
$299,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.33%
Original Mortgage
$239,200
Interest Rate
4.6%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jul 27, 2018
Closed on
Aug 30, 2018
Sold by
Cervantes Tucker Yesenia
Bought by
Tucker Ernest Lee
Seller's Agent
Kelly Perry
Epique Realty
Buyer's Agent
Armando Diaz
Soldavi Inc.
List Price
$299,000
Sold Price
$299,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$239,200
Interest Rate
4.6%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jul 27, 2018
Closed on
Aug 28, 2018
Sold by
Johnson Garett and Johnson Laura G
Bought by
Tucker Ernest Lee
Seller's Agent
Kelly Perry
Epique Realty
Buyer's Agent
Armando Diaz
Soldavi Inc.
List Price
$299,000
Sold Price
$299,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$239,200
Interest Rate
4.6%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 28, 2009
Sold by
Guaranty Plus Properties Llc 2
Bought by
Johnson Garrett and Johnson Laura G

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$186,548
Interest Rate
4.8%
Mortgage Type
FHA

Purchase Details

Closed on
May 14, 2008
Sold by
Park Fahrens
Bought by
Guaranty Plus Properties Llc-2
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
Huang Minxuan $500,000 First American Title
Edmond Yiuman Leung And Ada Pui-Yee Leung Rev $460,000 First American Title
Tucker Ernest -- Placer Title Company
Tucker Ernest Lee -- Trans County Title
Tucker Ernest Lee $299,000 Trans County Title
Tucker Ernest Lee -- Transcounty Title Company
Tucker Ernest Lee $299,000 Transcounty Title Company
Johnson Garrett $190,000 First American Title Company
Guaranty Plus Properties Llc-2 $1,744,000 First American Title Ins Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Huang Minxuan $300,000
Previous Owner Tucker Ernest $262,500
Previous Owner Tucker Ernest Lee $239,200
Previous Owner Tucker Ernest Lee $239,200
Previous Owner Johnson Garrett $186,548
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/15/2024 08/15/24 Sold $500,000 -2.0% $211 / Sq Ft
07/29/2024 07/29/24 Pending -- -- --
07/18/2024 07/18/24 For Sale $510,000 +10.9% $215 / Sq Ft
01/18/2022 01/18/22 Sold $460,000 +5.0% $194 / Sq Ft View Prior Sale
01/04/2022 01/04/22 Pending -- -- --
01/04/2022 01/04/22 For Sale $438,000 +46.5% $184 / Sq Ft
09/14/2018 09/14/18 Sold $299,000 0.0% $128 / Sq Ft View Prior Sale
08/11/2018 08/11/18 Pending -- -- --
07/27/2018 07/27/18 For Sale $299,000 -- $128 / 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 $5,416 $500,000 $120,000 $380,000
2024 $5,416 $478,584 $88,434 $390,150
2023 $5,325 $469,200 $86,700 $382,500
2022 $3,683 $314,300 $68,325 $245,975
2021 $3,742 $308,138 $66,986 $241,152
2020 $4,191 $304,980 $66,300 $238,680
2019 $4,159 $299,000 $65,000 $234,000
2018 $3,050 $215,029 $39,608 $175,421
2017 $3,135 $210,814 $38,832 $171,982
2016 $3,178 $206,681 $38,071 $168,610
2015 $3,145 $203,578 $37,500 $166,078
2014 $3,090 $199,591 $36,766 $162,825
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: California Regional Multiple Listing Service (CRMLS)

MLS Number: MC24147880

California Regional Multiple Listing Service (CRMLS)

APN: 058-467-004