Seller's Agent in 2025
Jared Amaral
Stephens & Borrelli, Inc.
(209) 495-1792
60 Total Sales
2863 Ahlem Ave Turlock, CA 95382
4
Beds
2.5
Baths
2,532
Sq Ft
7,841
Sq Ft Lot
Highlights
- Contemporary Architecture
- Marble Countertops
- Formal Dining Room
- Cathedral Ceiling
- No HOA
- 5-minute walk to Markley Park
About This Home
As of October 2025Exquisite sophistication awaits at 2863 Ahlem Avenue, nestled in the prestigious Legends Six neighborhood of Turlock. From the moment you enter, you are greeted by a breathtaking family room adorned with a custom built-in library, a maple mantle, and a unique vintage fireplace screen sourced from a historic San Francisco residence creating an ambiance that is both inviting and timeless. Motorized custom shades bathe the space in gentle morning light, offering the perfect setting to savor your first cup of coffee. The heart of the home is a chef's dream kitchen, where no detail has been overlooked. Featuring a stunning white oak island, a harmonious blend of marble and granite countertops, and top-of-the-line Caf 48'' gas/electric range, this culinary haven is complemented by seamlessly integrated paneled appliances, ensuring a sleek and sophisticated aesthetic. The adjacent dining room, masterfully re-imagined by a professional designer, provides an elegant backdrop for memorable gatherings and holiday celebrations. With over $200,000 in thoughtful upgrades, this move-in ready residence is a rare opportunity to own a truly distinguished home. Don't miss your chance to experience refined living at its finestschedule your private tour today!
Last Agent to Sell the Property
Stephens & Borrelli, Inc. License #01436249 Listed on: 09/05/2025
Home Details
Home Type
- Single Family
Year Built
- Built in 2003 | Remodeled
Lot Details
- 7,841 Sq Ft Lot
- Back Yard Fenced
- Sprinklers on Timer
Parking
- 3 Car Attached Garage
- Garage Door Opener
Home Design
- Contemporary Architecture
- Slab Foundation
- Tile Roof
- Stucco
Interior Spaces
- 2,532 Sq Ft Home
- 2-Story Property
- Cathedral Ceiling
- Ceiling Fan
- Fireplace
- Family Room Downstairs
- Formal Dining Room
- Vinyl Flooring
Kitchen
- Gas Cooktop
- Range Hood
- Dishwasher
- Kitchen Island
- Marble Countertops
- Granite Countertops
- Compactor
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
- Tile Bathroom Countertop
- Secondary Bathroom Double Sinks
- Bathtub with Shower
- Separate Shower
Laundry
- Laundry in unit
- Sink Near Laundry
Home Security
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Outdoor Features
- Pergola
Utilities
- Central Heating and Cooling System
- 220 Volts
- Water Heater
- Septic System
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 073-042-048-000
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Sep 5, 2025
Closed on
Sep 24, 2025
Sold by
Scott And Alison Kuykendall Living Trust and Kuykendall Scott Douglas
Bought by
Pritchett Kenneth Kyle and Shams Sharokina
Seller's Agent
Jared Amaral
Stephens & Borrelli, Inc.
Buyer's Agent
Nellie Lazar
Century 21 Select Real Estate
List Price
$799,500
Sold Price
$799,500
Views
30
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$10,326
Avg. Annual Appreciation
-4.54%
Original Mortgage
$349,500
Outstanding Balance
$348,562
Interest Rate
6.58%
Mortgage Type
New Conventional
Estimated Equity
$440,612
Purchase Details
Closed on
Jun 2, 2023
Sold by
Kuykendall Scott Douglas and Kuykendall Alison Marie
Bought by
Scott And Alison Kuykendall Living Trust and Kuykendall
Purchase Details
Listed on
Feb 28, 2022
Closed on
May 2, 2022
Sold by
Brierly Kurt W and Brierly Jonell E
Bought by
Kuykendall Scott D and Kuykendall Alison M
Seller's Agent
Clarence Oliveira
Century 21 Select Real Estate
Buyer's Agent
Lance Kuykendall
HomeSmart PV & Associates
List Price
$719,900
Sold Price
$670,000
Premium/Discount to List
-$49,900
-6.93%
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.55%
Original Mortgage
$225,000
Interest Rate
3.83%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 6, 2015
Sold by
Brierly Kurt W and Brierly Jonell E
Bought by
Brierly Kurt W and Brierly Jonell E
Purchase Details
Closed on
Dec 3, 2012
Sold by
Brierly Kurt W and Brierly Jonell E
Bought by
Brierly Kurt W and Brierly Jonell E
Purchase Details
Closed on
Jul 15, 2003
Sold by
Jkb Homes Norcal Inc
Bought by
Brierly Kurt W and Brierly Jonell E
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$202,800
Interest Rate
6.06%
Mortgage Type
Purchase Money Mortgage
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Grant Deed | $799,500 | First American Title | |
| Quit Claim Deed | -- | None Listed On Document | |
| Grant Deed | $670,000 | Chicago Title | |
| Interfamily Deed Transfer | -- | First American Title Company | |
| Interfamily Deed Transfer | -- | None Available | |
| Grant Deed | $338,000 | Fidelity National Title |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $349,500 | New Conventional | |
| Previous Owner | $225,000 | New Conventional | |
| Previous Owner | $202,800 | Purchase Money Mortgage |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 10/03/2025 10/03/25 | Sold | $799,500 | 0.0% | $316 / Sq Ft | |
| 09/13/2025 09/13/25 | Pending | -- | -- | -- | |
| 09/05/2025 09/05/25 | For Sale | $799,500 | +19.3% | $316 / Sq Ft | |
| 05/12/2022 05/12/22 | Sold | $670,000 | -0.7% | $265 / Sq Ft | View Prior Sale |
| 04/12/2022 04/12/22 | Pending | -- | -- | -- | |
| 04/12/2022 04/12/22 | Price Changed | $675,000 | -3.6% | $267 / Sq Ft | |
| 03/29/2022 03/29/22 | Price Changed | $699,900 | -2.8% | $276 / Sq Ft | |
| 02/28/2022 02/28/22 | For Sale | $719,900 | -- | $284 / Sq Ft |
Source: MetroList
Tax History Compared to Growth
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 | $8,290 | $711,008 | $318,362 | $392,646 |
| 2024 | $8,261 | $697,068 | $312,120 | $384,948 |
| 2023 | $5,729 | $461,891 | $150,317 | $311,574 |
| 2022 | $5,609 | $452,835 | $147,370 | $305,465 |
| 2021 | $5,520 | $443,957 | $144,481 | $299,476 |
| 2020 | $5,462 | $439,406 | $143,000 | $296,406 |
| 2019 | $5,172 | $430,792 | $140,197 | $290,595 |
| 2018 | $5,200 | $422,347 | $137,449 | $284,898 |
| 2017 | $5,026 | $414,066 | $134,754 | $279,312 |
| 2016 | $4,992 | $405,948 | $132,112 | $273,836 |
| 2015 | $4,761 | $399,851 | $130,128 | $269,723 |
| 2014 | $4,198 | $344,500 | $100,000 | $244,500 |
Source: Public Records
Agents Affiliated with this Home
-
Jared Amaral
-
Nellie Lazar
Buyer's Agent in 2025
Nellie Lazar
Century 21 Select Real Estate
(209) 602-7070
100 Total Sales
-
Clarence Oliveira
Seller's Agent in 2022
Clarence Oliveira
Century 21 Select Real Estate
(209) 633-1821
296 Total Sales
-
Lance Kuykendall
Buyer's Agent in 2022
Lance Kuykendall
HomeSmart PV & Associates
(209) 380-3058
13 Total Sales
Map
Source: MetroList
MLS Number: 225116562
APN: 073-42-48
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Nearby Homes
- 3221 Amethyst Way
- 0 Hogin Rd Unit MC25187945
- 0 Hogin Rd Unit 225067168
- 2575 Kensington Ct
- 1345 Alex Cir
- 2545 Nicklaus Dr
- 1940 Erin Way
- 2880 N Quincy Rd
- 2293 E Tuolumne Rd
- 2200 E Tuolumne Rd
- 3703 Brookstone Dr
- 3161 Bridgeport Ct
- 1940 N Berkeley Ave
- 1850 Hammond Dr
- 1921 Carleton Dr
- 1820 N Berkeley Ave
- 3926 Dedication Dr
- 1383 Kinship Dr
- 834 Cedar Ridge Dr
- 3360 Stanley Ave