NOT LISTED FOR SALE

3843 Colma Ave Unit 1 Merced, CA 95348

Merced Area

Estimated Value: $524,967 - $587,000

5 Beds
3 Baths
3,102 Sq Ft
$177/Sq Ft Est. Value

Sale Details

Date Sold: October 28, 2025

Last sale price $540,000 $174 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $3,472 / mo

97 Days on Market

Highlights

  • Solar Power System
  • Cathedral Ceiling
  • Loft
  • Contemporary Architecture
  • Main Floor Bedroom
  • 4-minute walk to Merino Park

About This Home

As of October 2025

Exceptional Size, Endless Possibilities Step into over 3,100 sq ft versatile living space an impressive and rare find in North Merced. With 5 bedrooms, a loft, 3 full bathrooms, and multiple living and dining areas, this home offers unmatched flexibility for growing families, multigenerational living, or anyone needing room to spread out. Designed with function and flow in mind while providing distinct spaces to entertain, gather, or relax. A full bedroom and bathroom on the main floor is perfect for guests or in-laws, while the upstairs loft offers even more space for a media room, playroom, or home office. The heart of the home is the spacious kitchen, complete with granite countertops, an island, and tons of storageideal for daily living or hosting gatherings. Smart features like a smart thermostat, smart door locks, solar power, and a water softener system add comfort and efficiency. Outside, the low-maintenance, professionally designed, landscaping creates a peaceful backdrop, while the gazebo-covered patio and dedicated dog run make the backyard perfect for entertaining and everyday enjoyment. Located in a sought-after North Merced neighborhood near UC Merced, parks, schools, and shopping, this home blends size, style, and smart design in one incredible package.

Last Agent to Sell the Property

Blanca Soto Duran

Berkshire Hathaway HomeServices-Drysdale Properties License #02031934 Listed on: 06/02/2025

Berkshire Hathaway HomeServices-Drysdale Properties

Last Buyer's Agent

Lisa Smith

Fine Homes R.E. Inc. License #01482866

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

Year Built

  • Built in 2005

Lot Details

  • 6,094 Sq Ft Lot
  • Wood Fence
  • Back Yard Fenced
  • Landscaped
  • Front Yard Sprinklers
  • Property is zoned P-D

Parking

  • 3 Car Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Tile Roof
  • Stucco

Interior Spaces

  • 3,102 Sq Ft Home
  • 2-Story Property
  • Cathedral Ceiling
  • Gas Log Fireplace
  • Family Room
  • Combination Kitchen and Living
  • Formal Dining Room
  • Loft

Kitchen

  • Breakfast Area or Nook
  • Butlers Pantry
  • Free-Standing Gas Range
  • Range Hood
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • 3 Full Bathrooms
  • Secondary Bathroom Double Sinks
  • Soaking Tub
  • Bathtub with Shower
  • Separate Shower
  • Window or Skylight in Bathroom

Laundry

  • Laundry Room
  • Laundry on upper level
  • Laundry Cabinets

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Grid-tied solar system exports excess electricity
  • Energy-Efficient Thermostat
  • Solar Power System

Outdoor Features

  • Gazebo

Utilities

  • Central Heating and Cooling System
  • Refrigerated and Evaporative Cooling System
  • High Speed Internet

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 206-111-002-000

Home Details

Home Type

Single Family

Year Built

Built in 2005

Lot Details

6,094 Sq Ft Lot

Parking

3

Listing Details

  • Property Type: Residential
  • Subtype Description: Detached, Loft
  • Property Subtype 1: Single Family Residence
  • Remodeled Updated: No
  • Stories: 2
  • Year Built: 2005
  • Architectural Style: Contemporary
  • Levels: Two
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Free Standing Gas Range, Hood Over Range, Dishwasher, Disposal
  • Other Equipment: Water Cond Equipment Owned
  • Fireplace Features: Gas Log
  • Fireplaces: 1
  • Flooring: Carpet, Tile
  • Master Bathroom Features: Shower Stall(s), Double Sinks, Soaking Tub, Walk-In Closet 2+, Window
  • Total Bathrooms: 3
  • Bathroom Features: Tub w/Shower Over
  • Dining Room Features: Breakfast Nook, Formal Area
  • Kitchen Features: Breakfast Area, Butlers Pantry, Granite Counter, Island, Island w/Sink, Kitchen/Family Combo
  • Living Room Features: Cathedral/Vaulted
  • Room Type: Loft, Master Bathroom, Master Bedroom, Dining Room, Family Room, Kitchen, Laundry, Living Room
  • Main Level: Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen
  • Price Per Square Foot: 174.08
  • Square Footage: 3102.00

Exterior Features

  • Other Structures: Gazebo
  • Construction Materials: Stucco
  • Disclosures/Documents: Seller Property Questionnaire, TDS Available
  • Fencing: Back Yard, Wood
  • Foundation: Slab
  • Home Warranty: No
  • Horse Property: No
  • Listing Price: 539000.00
  • Lot Features: Auto Sprinkler Front, Curb(s)/Gutter(s), Landscape Back, Landscape Front
  • New Construction: No
  • Pool: No
  • Property Condition: Original
  • Road Surface Type: Asphalt
  • Roof: Tile
  • Spa: No

Garage/Parking

  • Garage Spaces: 3.00
  • Parking Features: Garage Door Opener, Garage Facing Front
  • Driveway/Sidewalks: Paved Driveway

Utilities

  • Security: Carbon Mon Detector, Smoke Detector
  • Utilities: Public, Solar, Internet Available, Sewer In & Connected
  • Cooling: Central
  • Electric: PV-On Grid
  • Heating: Central
  • Laundry Features: Cabinets, Upper Floor
  • Water Source: Public

Condo/Co-op/Association

  • Association: No
  • Pets Allowed: Yes
  • Senior Community: No

Fee Information

  • Land Lease: No

Schools

  • Senior High School District: Merced Union High

Lot Info

  • Zoning: P-D
  • Irrigation: None
  • Lot Size Acres: 0.1399
  • Lot Size Sq Ft: 6094.00

Green Features

  • Energy Efficient: Thermostat

Multi Family

Tax Info

  • Assessor Parcel Number: 206-111-002-000
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): Merced

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 2, 2025
Closed on
Oct 6, 2025
Sold by
Rogers Philip E and Rogers Family Trust
Bought by
Seller's Agent
Blanca Soto Duran
Berkshire Hathaway HomeServices-Drysdale Properties
Buyer's Agent
Lisa Smith
Fine Homes R.E. Inc.
List Price
$550,000
Sold Price
$540,000
Premium/Discount to List
-$10,000
-1.82%
Views
106
Current Estimated Value
$550,492

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$10,492
Avg. Annual Appreciation
2.32%
Original Mortgage
$530,219
Outstanding Balance
$525,683
Interest Rate
6.35%
Mortgage Type
FHA
Estimated Equity
$24,809

Purchase Details

Closed on
Nov 22, 2016
Sold by
Rogers Philip E and Rogers Monica
Bought by
Rogers Philip E and Rogers Monica

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 14, 2016
Sold by
Rogers Philip E
Bought by
Rogers Philip E and Rogers Monica

Purchase Details

Listed on
Mar 25, 2015
Closed on
May 4, 2015
Sold by
Nguyen Nha Cong and Tonnu Diane Hao
Bought by
Rogers Philip E
Seller's Agent
Jenna Rogers
Tinetti Realty Group
Buyer's Agent
Mario Zazueta
Century 21 Select Real Estate, Turlock
List Price
$319,900
Sold Price
$317,500
Premium/Discount to List
-$2,400
-0.75%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.99%
Original Mortgage
$273,249
Interest Rate
3.25%
Mortgage Type
FHA

Purchase Details

Closed on
Sep 28, 2011
Sold by
Federal National Mortgage Association
Bought by
Hua Chiwei and Ren Kaiyu

Purchase Details

Closed on
Aug 4, 2005
Sold by
Merced Shadow Creek Lp
Bought by
Nguyen Nha Cong and Tonnu Diane Hao

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$75,000
Interest Rate
5.56%
Mortgage Type
Credit Line Revolving
Source: Public Records

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
$540,000 First American Title
Rogers Philip E -- Tsi Title Company Of Ca Inc
Rogers Philip E -- Tsi Title Company Of Ca Inc
Rogers Philip E -- None Available
Rogers Philip E $317,500 First American Title Company
Rogers Philip E -- First American Title Company
Hua Chiwei $181 Servicelink
Nguyen Nha Cong $478,000 Old Republic Title Company
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 $530,219
Closed Rogers Philip E $272,000
Previous Owner Rogers Philip E $273,249
Previous Owner Nguyen Nha Cong $75,000
Previous Owner Nguyen Nha Cong $350,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
10/28/2025 10/28/25 Sold $540,000 +0.2% $174 / Sq Ft
09/07/2025 09/07/25 Pending -- -- --
07/31/2025 07/31/25 Price Changed $539,000 -1.8% $174 / Sq Ft
06/13/2025 06/13/25 Price Changed $549,000 -0.2% $177 / Sq Ft
06/02/2025 06/02/25 For Sale $550,000 -- $177 / Sq Ft
Source: MetroList

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
2026 $5,390 $540,000 $120,000 $420,000
2025 $5,129 $381,577 $54,078 $327,499
2024 $5,129 $374,096 $53,018 $321,078
2023 $5,040 $366,762 $51,979 $314,783
2022 $4,933 $359,571 $50,960 $308,611
2021 $4,853 $352,521 $49,961 $302,560
2020 $4,866 $348,907 $49,449 $299,458
2019 $4,787 $342,067 $48,480 $293,587
2018 $4,427 $335,361 $47,530 $287,831
2017 $4,534 $328,787 $46,599 $282,188
2016 $4,451 $322,341 $45,686 $276,655
2015 $4,251 $306,000 $45,000 $261,000
2014 $3,791 $266,000 $30,000 $236,000
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MetroList

MLS Number: 225071555

MetroList

APN: 206-111-002

Your Personal Tour Guide

Ask me questions while you tour the home.