$700,000
SOLD JAN 27, 2026

174 N Lind Ave Clovis, CA 93612

4 Beds
3 Baths
2,499 Sq Ft
0.33 Acres

Recently Sold

$280 Per Sq Ft

13 Days on Market

Highlights

  • In Ground Pool
  • Covered Patio or Porch
  • Central Heating and Cooling System
  • Cole Elementary School Rated A-
  • 1-Story Property

About This Home

As of January 2026

Welcome to the kind of Clovis home that doesn't just check boxes, it side-eyes lesser listings.
This is a 4 bedroom, 3 bath home with a flex room that refuses to be minimized. Office? Fifth bedroom? Peloton shrine? You decide. There's also a true formal dining room, built for tables with leaves and chairs that don't scrape walls. The three car garage means you can park cars and still have room for Costco overflow, tools, bikes, or that hobby you swear you're getting back in to. The lot is over 14,000 sq. ft. and tucked into a practically private cul-de-sac with limited neighboring homes.
Step outside to a backyard designed for actual living: a pool for summer survival, a covered patio for year-round lounging, and lawn space that exists without demanding your weekends. Big enough to feel indulgent, manageable enough to keep your Saturdays. The northern corner of the parcel has been fenced separately with access to the street. Perfect for hiding your trash cans, but big enough to park a car.
The upgrades speak for themselves: remodeled kitchen, LVP flooring, newer HVAC, and solar with a low monthly payment. Practical and done right.
The location is fantastic. Close to freeway access when you need to move, and walking distance to Old Town Clovis when you want coffee, dinner, or to casually remind yourself why you chose this neighborhood in the first place.
Now let's talk about the sellers - because this part matters.The husband was handy. he did the projects, and fixed the things. She, however, handled the records.And by records, we mean meticulous, and organized. She still has the original flyer from when the home was purchased, along with detailed documentation of maintenance, upgrades, and repairs. He remembers doing the work, she remembers when, why, how, and how many times she had to ask him.
If you're wondering whether she changed the AC filters on time, the answer is yes, probably early, and she kept the receipt. Twice.
This is one of those homes where you walk in and immediately think, Oh, this was owned by adults who had a system - and she ran it.Fair warning:Owning this home comes with a challenge. Maintaining it to the seller's standards is now your responsibility. No pressure. But they set the bar, and it's high.

Last Agent to Sell the Property

Laura Corey

Realty Concepts, Ltd. - Fresno License #01303203 Listed on: 12/18/2025

Realty Concepts, Ltd. - Fresno

Last Buyer's Agent

Tami Murakoshi

Realty Concepts, Ltd. - Fresno License #01893559

Realty Concepts, Ltd. - Fresno

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2005

Lot Details

  • 0.33 Acre Lot
  • Lot Dimensions are 123x116
  • Sprinkler System
  • Property is zoned R1

Home Design

  • Concrete Foundation
  • Composition Roof
  • Stucco

Interior Spaces

  • 2,499 Sq Ft Home
  • 1-Story Property
  • Self Contained Fireplace Unit Or Insert
  • Laminate Flooring
  • Laundry in unit

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 3 Bathrooms

Pool

  • In Ground Pool
  • Gunite Pool

Additional Features

  • Covered Patio or Porch
  • Central Heating and Cooling System

Home Details

Home Type

Single Family

Year Built

Built in 2005

Lot Details

0

Listing Details

  • Type: Residential
  • Property Sub Type: Single Family Residence
  • Price Per Square Foot: 280.11
  • Year Built Exception: 0
  • Number Of Stories: Single Story
  • Special Features: None
  • Stories: 1
  • Year Built: 2005

Interior Features

  • Fireplace Type: Gas Insert
  • Number Of Fireplaces: 1
  • Flooring: Laminate
  • Bathrooms: 3.00
  • Bedrooms: 4
  • Laundry: Inside
  • Square Footage: 2499.00

Exterior Features

  • Yard: Sprinklers Auto
  • Roofing: Composition
  • Pool Type: In Ground
  • Exterior: Stucco
  • Foundation: Concrete
  • Patio: Covered
  • Pool: Yes
  • Pool Features: Gunite

Utilities

  • Heating And Cooling: Central Heat & Cool
  • Gas And Electric: Public Utilities
  • Sewer/Water: Public Water, Public Sewer

Condo/Co-op/Association

  • Association: Fresno MLS

Lot Info

  • Acres: 0.3275
  • Lot Dimensions: 123X116
  • Lot Measurement: Square Feet
  • Lot Size Sq Ft: 14268.00
  • Price Per Acre: 2137404.58

Building Info

  • Year Built: 2005

MLS Schools

  • School District 2: Clovis Unified
  • School Type: High School
  • School Name: Buchanan
  • School Type: Junior High School
  • School Name: Alta Sierra
  • School Type: Grade School
  • School Name: Cole

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 18, 2025
Closed on
Jan 20, 2026
Sold by
Halterman Lee Allen and Halterman Shonna Anne
Bought by
Warnert Steven and Warnert Hannah
Seller's Agent
Laura Corey
Realty Concepts, Ltd. - Fresno
Buyer's Agent
Tami Murakoshi
Realty Concepts, Ltd. - Fresno
List Price
$699,000
Sold Price
$700,000
Premium/Discount to List
$1,000
0.14%
Views
64

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-97.96%
Original Mortgage
$560,000
Outstanding Balance
$560,000
Interest Rate
6.22%
Mortgage Type
New Conventional
Estimated Equity
$87,552

Purchase Details

Closed on
Dec 8, 2013
Sold by
Halterman Lee Allen and Halterman Shonna Anne
Bought by
Halterman Lee Allen and Halterman Shonna Anne

Purchase Details

Closed on
Dec 13, 2004
Sold by
Century Developers Llc
Bought by
Halterman Lee Allen and Halterman Shonna Anne

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$284,990
Interest Rate
5.73%
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

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Interfamily Deed Transfer -- None Available
Grant Deed $356,500 First American Title Ins Co
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $284,990 Purchase Money Mortgage
Closed $35,620 No Value Available
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/27/2026 01/27/26 Sold $700,000 +0.1% $280 / Sq Ft
12/31/2025 12/31/25 Pending -- -- --
12/18/2025 12/18/25 For Sale $699,000 -- $280 / Sq Ft
Source: Fresno 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 $6,199 $530,976 $139,378 $391,598
2023 $5,961 $510,360 $133,967 $376,393
2022 $5,881 $500,354 $131,341 $369,013
2021 $5,552 $476,700 $125,400 $351,300
2020 $5,076 $433,400 $114,000 $319,400
2019 $4,857 $414,800 $109,100 $305,700
2018 $4,704 $402,800 $106,000 $296,800
2017 $4,447 $380,000 $100,000 $280,000
2016 $3,974 $345,000 $95,000 $250,000
2015 $3,471 $301,900 $79,200 $222,700
2014 $3,252 $282,800 $74,200 $208,600
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Fresno MLS

MLS Number: 640932

Fresno MLS

APN: 491-340-04