J
Seller's Agent in 2025
Jeremy Jennings
Atella Properties
(559) 392-9042
1 in this area
75 Total Sales
3754 E Kerckhoff Ave Fresno, CA 93702
Huntington Neighborhood
5
Beds
3.5
Baths
2,208
Sq Ft
0.37
Acres
Highlights
- In Ground Pool
- 0.37 Acre Lot
- Granite Countertops
- RV Access or Parking
- Corner Lot
- No HOA
About This Home
As of July 2025Welcome to this rare gem in the heart of the historic Huntington Boulevard neighborhood! The beautifully updated 4 bedroom, 2.5 bathroom home sits proudly on two full lots, totaling an impressive 16,000 sqft. Combining timeless character with modern upgrades, this residence offers the best of both worlds. Inside, you'll find a bright and airy interior with abundant natural light throughout. The home has been extensively updated with dual pane windows, newer kitchen cabinets, granite countertops, stainless steel appliances, and recessed lighting. There are versatile living spaces, allowing for any style of living to thrive. The charm of its historic roots remains, complemented by fresh and functional improvements. The bedrooms are upstairs, with the primary featuring a spacious bathroom ensuite that has an impressive amount of storage. A functional basement provides the perfect place for storage, a private wine cellar, or hobby space. Step outside to your private backyard retreat with a huge sparkling blue pool (redone in 2018), mature landscaping, and plenty of space for entertaining or relaxing. The property also includes a fully equipped ADU with its own bedroom, bathroom, kitchenette, and AC - ideal for guests, rental income, or multi-generational living. The garage is conveniently attached to the ADU. This is more than a home, it's a unique opportunity to own a piece of Fresno history with modern comfort, versatility, and unmatched outdoor space.
Last Agent to Sell the Property
Atella Properties License #01911737 Listed on: 06/05/2025
Last Buyer's Agent
Non-Member Non-Member
Non-Member Office License #99999999
Home Details
Home Type
- Single Family
Year Built
- Built in 1937 | Remodeled
Lot Details
- 0.37 Acre Lot
- North Facing Home
- Corner Lot
- Front and Back Yard Sprinklers
- Back Yard
- Zoning described as R5
Parking
- 1 Car Detached Garage
- RV Access or Parking
Home Design
- Raised Foundation
- Slab Foundation
- Composition Roof
Interior Spaces
- 2-Story Property
- Recessed Lighting
- Family Room with Fireplace
- Laundry in unit
Kitchen
- Gas Range
- Dishwasher
- Granite Countertops
Flooring
- Carpet
- Laminate
- Ceramic Tile
Bedrooms and Bathrooms
- 5 Bedrooms
Outdoor Features
- In Ground Pool
- Porch
Additional Homes
- ADU includes parking
Utilities
- Multiple cooling system units
- Central Heating and Cooling System
- Natural Gas Connected
- Cable TV Available
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 46112407
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jun 5, 2025
Closed on
Jun 23, 2025
Sold by
Smith Kelly Dean and Smith Rebecca Lynn
Bought by
Colmenares Ismael Adan
Seller's Agent
Jeremy Jennings
Atella Properties
Buyer's Agent
Non-Member Non-Member
Non-Member Office
List Price
$515,000
Sold Price
$530,000
Premium/Discount to List
$15,000
2.91%
Views
46
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
-$8,203
Avg. Annual Appreciation
-2.48%
Original Mortgage
$450,500
Outstanding Balance
$449,355
Interest Rate
6.86%
Mortgage Type
New Conventional
Estimated Equity
$72,442
Purchase Details
Listed on
Apr 21, 2018
Closed on
May 17, 2018
Sold by
Yuyama Fred
Bought by
Smith Kelly Dean and Smith Rebecca Lynn Noel
Seller's Agent
Fred Yuyama
Pacific Real Estate
Buyer's Agent
Bradley Rutledge
Atella Properties, Inc.
List Price
$370,000
Sold Price
$370,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
5.20%
Original Mortgage
$296,000
Interest Rate
4.4%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 20, 2017
Sold by
Yuyama Fred and Yuyama Fred
Bought by
Yuyama Fred
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$132,175
Interest Rate
4.17%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Jan 6, 2017
Sold by
Stigum Heidi
Bought by
Yuyama Fred
Purchase Details
Closed on
Jun 20, 2001
Sold by
Esqueda David P and Esqueda Della R
Bought by
Stigum Heidi
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$147,000
Interest Rate
7.5%
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
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Grant Deed | $530,000 | Orange Coast Title Company | |
| Grant Deed | $370,000 | Orange Coast Title Company O | |
| Interfamily Deed Transfer | -- | Fidelity National Title Fres | |
| Trustee Deed | $105,500 | None Available | |
| Grant Deed | $155,000 | Chicago Title Co |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $450,500 | New Conventional | |
| Previous Owner | $296,000 | New Conventional | |
| Previous Owner | $132,175 | Purchase Money Mortgage | |
| Previous Owner | $147,000 | No Value Available |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 07/03/2025 07/03/25 | Sold | $530,000 | +2.9% | $240 / Sq Ft | |
| 06/11/2025 06/11/25 | Pending | -- | -- | -- | |
| 06/05/2025 06/05/25 | For Sale | $515,000 | +39.2% | $233 / Sq Ft | |
| 06/01/2018 06/01/18 | Sold | $370,000 | 0.0% | $143 / Sq Ft | View Prior Sale |
| 05/11/2018 05/11/18 | Pending | -- | -- | -- | |
| 04/21/2018 04/21/18 | For Sale | $370,000 | -- | $143 / Sq Ft |
Source: Tulare County MLS
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,380 | $420,992 | $51,200 | $369,792 |
| 2023 | $5,173 | $404,647 | $49,213 | $355,434 |
| 2022 | $5,002 | $396,714 | $48,249 | $348,465 |
| 2021 | $4,863 | $388,936 | $47,303 | $341,633 |
| 2020 | $4,841 | $384,948 | $46,818 | $338,130 |
| 2019 | $4,653 | $377,400 | $45,900 | $331,500 |
| 2018 | $1,309 | $102,510 | $40,800 | $61,710 |
| 2017 | $7,677 | $197,284 | $44,543 | $152,741 |
| 2016 | $10,966 | $193,417 | $43,670 | $149,747 |
| 2015 | $6,190 | $190,513 | $43,015 | $147,498 |
| 2014 | $2,243 | $186,782 | $42,173 | $144,609 |
Source: Public Records
Agents Affiliated with this Home
-
Jeremy Jennings
-
N
Buyer's Agent in 2025
Non-Member Non-Member
Non-Member Office
-
Fred Yuyama
F
Seller's Agent in 2018
Fred Yuyama
Pacific Real Estate
(559) 222-4200
-
Bradley Rutledge
Buyer's Agent in 2018
Bradley Rutledge
Atella Properties, Inc.
(559) 706-9903
1 in this area
54 Total Sales
Map
Source: Tulare County MLS
MLS Number: 235649
APN: 461-124-07
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.
Based on information from the Tulare County Association of REALTORS®. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
Nearby Homes
- 3804 E Kerckhoff Ave
- 3844 E Balch Ave
- 523 S 8th St
- 3764 E Iowa Ave
- 622 S 11th St
- 4169 E Platt Ave
- 3769 E Mckenzie Ave
- 3801 E Mckenzie Ave
- 907 S 7th St
- 4313 E Tulare Ave
- 3539 E Mckenzie Ave
- 4323 E Iowa Ave
- 3533 E Alta Ave
- 832 S 4th St
- 3348 E Mckenzie Ave
- 3924 E Grant Ave
- 3321 E Montecito Ave
- 0 E Illinois Ave
- 4444 E Iowa Ave
- 3459 E Lowe Ave
Your Personal Tour Guide
Ask me questions while you tour the home.