NOT LISTED FOR SALE

1243 Esplanade Dr Merced, CA 95348

Estimated Value: $497,000 - $546,000

5 Beds
3 Baths
2,663 Sq Ft
$192/Sq Ft Est. Value

Last Sold December 12, 2023

Last sale price $495,000 $186 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $3,089/month

27 Days on Market

Highlights

  • Primary Bedroom Suite
  • Open Floorplan
  • Property is near park and public transit
  • Updated Kitchen
  • Contemporary Architecture
  • Two Story Ceilings

About This Home

As of December 2023

Discover the epitome of modern living in the desirable Fahrens Park Subdivision in North Merced. Welcome to a spacious 2-story home that's sure to captivate your heart. Nestled in the middle of a modern neighborhood, this 4-bedroom, 3-bath residence boasts many features that make it the perfect family home. Recent renovations include fresh interior and exterior paint that breathe new life into this already inviting space. Step inside and feel the freshness of a newly installed carpet that invites you to explore every corner of this home. The family room, adorned with a gas log fireplace, is the ideal spot to create memories with loved ones during those cozy evenings. The downstairs living areas and kitchen feature easy-to-maintain ceramic tile floors, a kitchen and breakfast bar, that is a chef's delight, cherry cabinets, ceramic tile counters, and a convenient island. It's been upgraded with a new gas range and dishwasher, ensuring that cooking here is both a pleasure and a breeze. The primary suite upstairs is a sanctuary of space and tranquility. Relax in the soaking tub, rejuvenate in the separate shower, and enjoy the convenience of dual sinks. Plus, you'll love the oversized walk-in closet that caters to your every storage need. Outside, this fabulous home showcases an easy-maintenance yard with raised flower beds, a custom backyard shed, and a charming front courtyard. Keep your surroundings lush and green with the help of front and back sprinklers and a drip system. Embrace eco-conscious living with an owned solar system at over 9kw. It's even equipped with Tesla backup batteries for peace of mind. Additionally, your home security is a priority, thanks to an alarm system and surveillance cameras. This is your chance to make this wonderful house your home. Schedule a tour today and discover why this home is the perfect place for you and your family.

Last Agent to Sell the Property

Scott A Oliver

Concierge Real Estate Services License #01335699 Listed on: 11/02/2023

Last Buyer's Agent

Ethan Villanueva-Saechao

Realty Executives Of Northern California License #02187560

Realty Executives Of Northern California

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2003 | Remodeled

Lot Details

  • 6,300 Sq Ft Lot
  • Lot Dimensions are 60' x 105'
  • South Facing Home
  • Wood Fence
  • Block Wall Fence
  • Fence is in average condition
  • Drip System Landscaping
  • Rectangular Lot
  • Front and Back Yard Sprinklers
  • Lawn
  • Garden
  • Back and Front Yard
  • Property is zoned R-1-6

Parking

  • 2 Car Direct Access Garage
  • 2 Open Parking Spaces
  • Parking Storage or Cabinetry
  • Parking Available
  • Front Facing Garage
  • Single Garage Door
  • Garage Door Opener
  • Lot Sloped Down
  • Driveway Up Slope From Street

Property Views

  • Neighborhood
  • Courtyard

Home Design

  • Contemporary Architecture
  • Entry on the 1st floor
  • Turnkey
  • Slab Foundation
  • Frame Construction
  • Shingle Roof
  • Concrete Roof
  • Stone Siding
  • Stucco

Interior Spaces

  • 2,663 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wired For Data
  • Built-In Features
  • Two Story Ceilings
  • Ceiling Fan
  • Recessed Lighting
  • Zero Clearance Fireplace
  • Fireplace Features Blower Fan
  • Gas Fireplace
  • Double Pane Windows
  • Blinds
  • Window Screens
  • Double Door Entry
  • French Doors
  • Panel Doors
  • Family Room with Fireplace
  • Family Room Off Kitchen
  • Living Room
  • Formal Dining Room
  • Den
  • Bonus Room
  • Storage
  • Utility Room

Kitchen

  • Galley Kitchen
  • Updated Kitchen
  • Breakfast Area or Nook
  • Open to Family Room
  • Breakfast Bar
  • Gas Oven
  • Self-Cleaning Oven
  • Gas Range
  • Free-Standing Range
  • Range Hood
  • Microwave
  • Water Line To Refrigerator
  • Dishwasher
  • Kitchen Island
  • Ceramic Countertops
  • Disposal

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms | 1 Main Level Bedroom
  • Primary Bedroom Suite
  • Multi-Level Bedroom
  • Walk-In Closet
  • Dressing Area
  • Mirrored Closets Doors
  • Remodeled Bathroom
  • Bathroom on Main Level
  • 3 Full Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Private Water Closet
  • Soaking Tub
  • Bathtub with Shower
  • Separate Shower
  • Exhaust Fan In Bathroom
  • Closet In Bathroom

Laundry

  • Laundry Room
  • Dryer
  • Washer
  • 220 Volts In Laundry

Home Security

  • Home Security System
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Balcony
  • Covered Patio or Porch
  • Exterior Lighting
  • Shed
  • Rain Gutters

Location

  • Property is near park and public transit
  • Suburban Location

Schools

  • Merced City Elementary And Middle School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Vented Exhaust Fan
  • Underground Utilities
  • 220 Volts in Kitchen
  • Natural Gas Connected
  • Gas Water Heater
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 444
  • Assessor Parcel Number 058411011000
  • $661 per year additional tax assessments

Community Details

Overview

  • No Home Owners Association

Recreation

  • Park
  • Dog Park

Home Details

Home Type

Single Family

Year Built

Built in 2003 | Remodeled

Lot Details

0

Parking

2

Listing Details

  • Structure Type: House
  • Assessments: Yes
  • Property Attached: No
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Security: Carbon Monoxide Detector(s), Security System, Smoke Detector(s)
  • Subdivision Name Other: Fahrens Park
  • View: Yes
  • Zoning: R-1-6
  • Architectural Style: Contemporary
  • Property Condition: Turnkey, Updated/Remodeled
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Parcel Number: 058411011000
  • Year Built: 2003
  • Special Features: None

Interior Features

  • Fireplace: Yes
  • Living Area: 2663.00 Square Feet
  • Interior Amenities: Balcony, Built-in Features, Ceiling Fan(s), Ceramic Counters, High Ceilings, Open Floorplan, Recessed Lighting, Storage, Two Story Ceilings, Unfurnished, Wired for Data
  • Stories: 2
  • Common Walls: No Common Walls
  • Flooring: Carpet, Tile, Vinyl
  • Appliances: Yes
  • Full Bathrooms: 3
  • Total Bedrooms: 5
  • Door Features: Double Door Entry, French Doors, Mirror Closet Door(s), Panel Doors
  • Eating Area: Breakfast Counter / Bar, Breakfast Nook, Dining Room, Separated
  • Entry Level: 1
  • Fireplace Features: Family Room, Gas, Gas Starter, Blower Fan, Zero Clearance
  • Levels: Two
  • Main Level Bathrooms: 1
  • Main Level Bedrooms: 1
  • Price Per Square Foot: 185.88
  • Room Type: Bonus Room, Den, Dressing Area, Entry, Family Room, Galley Kitchen, Kitchen, Laundry, Living Room, Main Floor Bedroom, Primary Suite, Multi-Level Bedroom, Separate Family Room, Utility Room, Walk-In Closet
  • Window Features: Blinds, Double Pane Windows, Screens
  • Bathroom Features: Bathtub, Shower, Shower In Tub, Closet In Bathroom, Double Sinks In Primary Bath, Exhaust Fan(s), Main Floor Full Bath, Privacy Toilet Door, Remodeled, Separate Tub And Shower, Soaking Tub, Upgraded, Walk-In Shower
  • Room Kitchen Features: Kitchen Island, Kitchen Open To Family Room, Remodeled Kitchen, Tile Counters

Exterior Features

  • Patio: Yes
  • Direction Faces: South
  • Foundation: Slab
  • Other Structures: Shed(s)
  • Exterior Features: Lighting, Rain Gutters
  • View: Courtyard, Neighborhood
  • Fence: Yes
  • Fencing: Average Condition, Block, Wood
  • Patio And Porch Features: Concrete, Covered, Front Porch, Slab
  • Pool Private: No
  • Roof: Concrete, Shingle
  • Spa: No
  • Construction Materials: Frame, Stone, Stucco

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2.00
  • Parking: Yes
  • Parking Features: Built-In Storage, Direct Garage Access, Driveway, Concrete, Driveway Up Slope From Street, Garage, Garage Faces Front, Garage - Single Door, Garage Door Opener
  • Total Parking Spaces: 4.00
  • Uncovered Spaces: 2.00

Utilities

  • Utilities: Cable Available, Electricity Connected, Natural Gas Connected, Phone Available, Sewer Connected, Underground Utilities, Water Connected
  • Sprinklers: Yes
  • Heating: Yes
  • Laundry: Yes
  • Appliances: Dishwasher, Free-Standing Range, Disposal, Gas Oven, Gas Range, Gas Water Heater, Microwave, Range Hood, Refrigerator, Self Cleaning Oven, Vented Exhaust Fan, Water Line to Refrigerator
  • Electric: 220 Volts in Kitchen, 220 Volts in Laundry, Electricity - On Property, Standard
  • Heating Type: Central, Fireplace(s), Forced Air, Natural Gas
  • Laundry Features: Dryer Included, Gas & Electric Dryer Hookup, Individual Room, Inside, Washer Hookup, Washer Included
  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling: Central Air, Electric
  • Cooling: Yes

Condo/Co-op/Association

  • Association: No
  • Senior Community: No
  • Community Features: Curbs, Dog Park, Gutters, Park, Sidewalks, Storm Drains, Street Lights, Suburban

Schools

  • Elementary School: Merced City
  • Middle Or Junior School: Merced City
  • Elementary School #2: MERCIT

Lot Info

  • Elevation: 171 Feet
  • Additional Parcels: No
  • Land Lease: No
  • Lot Features: Back Yard, Sloped Down, Front Yard, Garden, Gentle Sloping, Landscaped, Lawn, Rectangular Lot, Near Public Transit, Park Nearby, Sprinkler System, Sprinklers Drip System, Sprinklers In Front, Sprinklers In Rear, Sprinklers Timer, Up Slope from Street
  • Lot Size: 60' x 105'
  • Lot Size Sq Ft: 6300.00
  • Lot Size Acres: 0.1446

Multi Family

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

Tax Info

  • Tax Census Tract: 10.08
  • Tax Lot: 444
  • TaxOtherAnnualAssessmentAmount: 661.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 2, 2023
Closed on
Dec 5, 2023
Sold by
Barbary Thomas
Bought by
Barbary Kandi
Seller's Agent
Scott A Oliver
Concierge Real Estate Services
Buyer's Agent
Ethan Villanueva-Saechao
Realty Executives Of Northern California
List Price
$525,000
Sold Price
$495,000
Premium/Discount to List
-$30,000
-5.71%
Views
218
Current Estimated Value
$505,038

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$10,038
Avg. Annual Appreciation
1.60%

Purchase Details

Closed on
Jul 14, 2003
Sold by
Park Fahrens
Bought by
Elms James W and Elms Sherry L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$315,800
Interest Rate
6%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Barbary Kandi -- Fidelity National Title
Barbary Kandi $513,181 Fidelity National Title
Elms James W $351,000 Transcounty Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Elms James W $315,800
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/12/2023 12/12/23 Sold $495,000 -2.9% $186 / Sq Ft
11/29/2023 11/29/23 Pending -- -- --
11/27/2023 11/27/23 Price Changed $510,000 -2.9% $192 / Sq Ft
11/02/2023 11/02/23 For Sale $525,000 -- $197 / 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,591 $504,900 $112,200 $392,700
2024 $5,591 $495,000 $110,000 $385,000
2023 $5,361 $479,516 $95,651 $383,865
2022 $5,293 $470,115 $93,776 $376,339
2021 $4,544 $388,000 $85,000 $303,000
2020 $4,982 $382,500 $80,000 $302,500
2019 $4,942 $375,500 $65,000 $310,500
2018 $4,530 $363,000 $55,000 $308,000
2017 $4,570 $347,000 $45,000 $302,000
2016 $4,331 $317,000 $45,000 $272,000
2015 $4,075 $294,000 $45,000 $249,000
2014 $4,107 $298,000 $30,000 $268,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: California Regional Multiple Listing Service (CRMLS)

MLS Number: MC23201654

California Regional Multiple Listing Service (CRMLS)

APN: 058-411-011