4074 Celeste Ave, Clovis, CA 93619
OFF MARKET

4074 Celeste Ave
Clovis, CA 93619

  • 4 Beds
  • 2 Baths
  • 1,746 sqft

$497,900

Trulia Estimate
as of May 11, 2026
Est. Refi. Payment $2,986/mo*
Refinance Your Home

$497,900

Trulia Estimate
as of May 11, 2026
Est. Refi. Payment $2,986/mo*
Refinance Your Home
4 Beds
2 Baths
1,746 sqft

Homes for sale near 4074 Celeste Ave

Skip to last item
Skip to first item

Apartments for Rent

Skip to last item
Skip to first item

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

Description

Move-in Ready North Clovis Gem - Stunning Single-Level Home on a Corner Lot!Welcome to your dream home! This like-new beauty in North Clovis is ready for you to move in and make it your own. Freshly painted and meticulously clean, this single-level home is a rare find and offers the perfect combination of comfort and convenience.Located on a desirable corner lot with a large backyard, it's perfect for anyone with a green thumb or those looking to create their own outdoor oasis. Inside, you'll find a thoughtfully designed open floor plan where every space serves a purpose. The four-bedroom layout is ideal for modern living, offering both functionality and style. The heart of the home is the spacious kitchen, which features a gas stove, granite countertops, and ample storage space, making it perfect for cooking and entertaining.
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from January 05, 2025

Home Highlights

Parking
Attached Garage
Outdoor
Yes
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago

Home Details for 4074 Celeste Ave

Interior Features

Interior Details
Number of Rooms: 11Types of Rooms: Master Bedroom, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bathroom, Dining Room, Family Room, Kitchen, Living Room, Basement
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 2
Dimensions and Layout
Living Area: 1746 Square Feet
Appliances & Utilities
Utilities: Public UtilitiesAppliances: F/S Range/Oven, Disposal, Dishwasher, MicrowaveDishwasherDisposalLaundry: Inside,Utility RoomMicrowave
Heating & Cooling
Heating: Has Heating Unspecified TypeHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Has Heating Unspecified Type
Fireplace & Spa
Number of Fireplaces: 1Fireplace: Zero ClearanceHas a Fireplace
Windows, Doors, Floors & Walls
Window: Double Pane WindowsFlooring: Carpet, Tile
Levels, Entrance, & Accessibility
Stories: 1Levels: OneFloors: Carpet, Tile

Exterior Features

Exterior Home Features
Roof: TilePatio / Porch: Covered, ConcreteFoundation: ConcreteNo Private Pool
Parking & Garage
Has a GarageHas an Attached GarageParking: Garage Attached
Frontage
Not on Waterfront
Water & Sewer
Sewer: Public Sewer

Days on Market

Cumulative Days on Market: 10

Property Information

Year Built
Year Built: 2017
Property Type / Style
Property Type: ResidentialProperty Subtype: Residential, Single Family ResidenceArchitecture: Contemporary
Building
Construction Materials: Stucco
Property Information
Parcel Number: 55445021S

Price & Status

Price
List Price: $495,000

Active Status

MLS Status: Sold

Media

Location

Direction & Address
City: Clovis
School Information
Elementary School: CedarwoodJr High / Middle School: ClarkHigh School: ClovisHigh School District: Clovis Unified

Building

Building Area
Building Area: 1746 Square Feet

Community

Not Senior Community

HOA

Association for this Listing: Fresno MLS

Lot Information

Lot Area: 6943.464 sqft

Documents

Disclaimer: Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.

Offer

Listing Agreement Type: Exclusive Right To Sell

Miscellaneous

Mls Number: 620655
Last check for updates: about 16 hours ago
Listed by Jason Farris DRE #01734306, (559) 708-8768
Real Broker
Bought with: Rieber C. Hovde, III DRE #01351129, (559) 790-2370, London Properties, Ltd.
Originating MLS: Fresno MLS
Source: Fresno MLS, MLS#620655

Price History for 4074 Celeste Ave

DatePriceEventSource
04/11/2025$2,550ListingRemovedZillow Rentals
03/24/2025$2,550Listed For RentZillow Rentals
03/14/2025$2,550ListingRemovedZillow Rentals
01/14/2025$2,550PriceChange
Zillow Rentals
12/20/2024$2,650Listed For RentZillow Rentals
12/06/2024$496,000Sold
Fresno MLS #620655
11/06/2024$495,000PendingFresno MLS #620655
10/25/2024$495,000Listed For SaleFresno MLS #620655
08/11/2017$310,000Sold
N/A
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$6,508
Assessment$496,000
Home facts updated by county records

Comparable Sales for 4074 Celeste Ave

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
879 Hermosa Ave, Clovis, CA
0.13
Single-Family Home
$490,000
08/19/25
3
2
1,515
3923 Finchwood Ave, Clovis, CA
0.22
Single-Family Home
$505,000
12/30/25
3
2
1,900
1066 La Canada Ave, Clovis, CA
0.28
Single-Family Home
$481,000
01/06/26
3
2
1,515
3830 Leigh Ln, Clovis, CA
0.33
Single-Family Home
$510,000
03/20/26
3
2
1,855
3948 Portals Ave, Clovis, CA
0.42
Single-Family Home
$540,000
05/16/25
4
2
1,704
3821 Leigh Ln, Clovis, CA
0.33
Single-Family Home
$475,000
05/27/25
3
2
1,855
888 Descanso Ave, Clovis, CA
0.24
Single-Family Home
$505,000
03/05/26
3
3
1,553
3923 Morris Ave, Clovis, CA
0.19
Single-Family Home
$550,000
07/30/25
4
3
2,415
1043 La Jolla Ave, Clovis, CA
0.48
Single-Family Home
$550,000
04/24/26
4
2
1,900
3919 Mitchell Ave, Clovis, CA
0.50
Single-Family Home
$535,000
12/15/25
4
2
2,010

Assigned Schools

These are the assigned schools for 4074 Celeste Ave.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Clovis

At least 792 Trulia users voted on each feature.

  • 91 % Say it's dog friendly

  • 87 % Say car is needed

  • 86 % Say there are sidewalks

  • 86 % Say parking is easy

  • 81 % Say there's holiday spirit

  • 79 % Say yards are well-kept

  • 75 % Say streets are well-lit

  • 72 % Say people would walk alone at night

  • 69 % Say kids play outside

  • 68 % Say it's quiet

  • 57 % Say it's walkable to grocery stores

  • 57 % Say they plan to stay for at least 5 years

  • 54 % Say neighbors are friendly

  • 50 % Say it's walkable to restaurants

  • 29 % Say there are community events

  • 22 % Say there's wildlife

Learn more about our methodology.
  • Heff0408
    "Parks, quiet, friendly neighborhood and low crime rate. Lots of police and military live around here. "
    1
    Flag
  • Heff0408
    "Rodeo, soccer, blossom trail, and parks. Schools are great too. 2 hours and you can be at the beach, Yosemite, or Sequoia National Park."
    0
    Flag
  • Tracy.collier1016
    "There is no dog park. There are not a lot of walking trails on this side of Clovis. Most people seem to be very dog friendly and it’s nice when you’re out for a walk with your fur baby, that you will almost always meet someone who wants to say hello or has a dog that you want to say hello to and they will let you. "
    1
    Flag
  • Ldelatorre725
    "Been living here for 5 yrs and i love it. The neighborhood is so quiet and the neighbors are friendly. "
    0
    Flag
  • Ldelatorre725
    "Lived in this area close to 10 years and i love it. Super quiet at night, our neighbors are friendly and there are parks and shopping centers nearby. "
    0
    Flag
  • Ldelatorre725
    "Lived here 4 yrs and have no complaints, its very quiet and nice. Can go out for walks every day and the park in the neighborhood is walking distance. The schools are also walking distance. Neighbors are friendly. "
    0
    Flag
  • Chioma Friday
    "People are always walking their dogs on a leash. Dogs are always friendly. Owners always pickup after their dogs. "
    1
    Flag
  • Vincent Atilano
    "It is a quiet neighborhood and complex and don’t have much problems with neighbors or traffic. Your near food places, downtown Clovis , and grocery stores "
    1
    Flag
  • Nicole
    "Great parks in the area and nice well maintained walking paths, well lit and beautifully maintained trees and plants "
    0
    Flag
  • Kathy Ewers
    "There’s a school is right behind me and we go to church down the street. My neighbors and I watch each other’s homes when we’re gone. "
    0
    Flag
  • Ronaldcohen82
    "All the shopping and everything you need is really close. There’s lots of activities. There’s schools libraries whatever you possibly can think of. Is pretty close by I Costco right down the street."
    0
    Flag
  • Robert Barth
    "Plenty of walking trails and parks all over the place, and the city continues to build around the existing community. Also a giant new shopping plaza is about to open within the next year in the Loma Vista area. "
    0
    Flag
  • Jmulholland
    "Easy commute with minimal traffic and decent traffic. Either down Clovis Ave or 168 depending on the time of day "
    5
    Flag
  • Jmulholland
    "Clovis has an amazing school system and so much to offer. Friendly neighborhoods and lots of shopping opportunities "
    0
    Flag
  • Jmulholland
    "We are like family and look out for each other. Quite often are in contact with each other when people are in need "
    0
    Flag
  • Michellecampbell969
    "This neighborhood has a great elementary middle and high school . There is close shopping and a gas station for convenience "
    0
    Flag
  • Cindy Mejia
    "My neighborhood is a gated community. You must drive a car to commute. It is difficult to pick the best time to commute. "
    1
    Flag
  • Olsenkendra
    "Lots of kids, great walking paths, and parks. We love our neighbors! Everyone watches out for each other. "
    0
    Flag
  • Lmbruce77
    "Safe, close to shopping center, good school in neighborhood. Close & convenient for our jobs!! In middle of everything."
    0
    Flag
  • Isabelflores022418
    "They would like it. People are often out walking their dogs along with their kids. There’s dog parks, stores with training, and supplies that are really close to each other. This seems to be a dog friendly area. Only one neighbor whose dog is either crying or howling in terrible hours of the night at times and that is annoying for sure!"
    1
    Flag
  • Saifaudio
    "ther is special event in Halloween and 4th of July and Christmas day and holidays in our neighborhood "
    0
    Flag
  • Dkmedicalconsult
    "Everyone looks out for one another. Local and safe shopping and great schools. A very safe community. "
    0
    Flag
  • Babynrs51
    "We have parties at the park and the kids always have others to play with. Our neighbors are always looking out for each other. "
    0
    Flag
  • Charay J.
    "Short drive to parks, shops and downtown. Walking and bike trails in the neighborhoods. Everything else you need is within a 15-20 min drive."
    0
    Flag
  • Beth L.
    "Clovis is a very friendly neighborhood, that is safe, well maintained and clean, and has great schools for my kids. I love this community. Grocery and gas are conveniently close and the community is well designed. "
    0
    Flag
  • Jennie M. G.
    "I lived here for 1 week. But its been nice lived here 4 years Ago and it was great. We are out in the country so very quiet and peaceful "
    0
    Flag
  • Lmbruce77
    "It’s busy but I feel like I have a steady route home. There’s no delays so that’s good. I live in the country so it’s very fast paced going home!!"
    0
    Flag
  • Markjill0607
    "Yes did owners would love this neighborhood. It is a Dog friendly neighborhood. 99.9% on leashes. Walkers are friendly! I feel safe for my kids and myself."
    1
    Flag
  • Leroy G.
    "Dogs are usually on a leash or very well behaved in this area and the park has a water fountain for dogs"
    0
    Flag
  • Isabelflores022418
    "Neighbors always looking out for each other! Easy outdoors walking and biking. Great place to raise your children and great schools! Commute is easy in and out of Clovis. It’s in the heart of Fresno you can go up the mountain or down the 99. Shopping is very close by and delicious dining as well as fast food if that’s your preference. Easy access to freeways and entertainment is very family friendly during farmer markets in Old Town Clovis. Lots of local shopping and antique stores."
    0
    Flag
  • Danielle V.
    "There is tons of parks and places for dogs to run and play. People walk their dogs all of the time in every neighborhood. "
    1
    Flag
  • Sydnei A. M. F.
    "I have seen a local church put on neighborhood events occasionally. Halloween is the best for me, lots of trick-or-treaters"
    0
    Flag
  • Marcie M.
    "It’s not bad... some wide open country roads to get into town which is nice, but once in town traffic can get congested a lot of the times "
    0
    Flag
  • Daniel G.
    "I’ve lived here for 4 years and a half and I absolutely love it. This is a very safe area, great places for running and/or hiking, nice neighbors."
    0
    Flag
  • Hedley555
    "I love living right off the Clovis Trail. Been here 9 years and don’t plan on moving. I’m the onsite manager of Trailside Apts. Dewiit has sidewalks on one side and is well lit. I’ve walked after dark and feel pretty safe. Pollasky doesn’t have sidewalks and isn’t well lit but the streets are wide and good for walking. And there’s always the trail!"
    0
    Flag
  • BLL
    " It's a good place to raise kids, it has a small town feel. The community has many family events and activities. "
    0
    Flag
  • Csb1234
    "This is a nice and quite neighborhood. Most keep to themselves but are friendly and will keep an eye on your house when your not around, if needed."
    0
    Flag
  • Action T.
    "Clovis Unified, founded by Doc Buchanan, is the best school district in California. Choose Eastern or Northern part of Clovis if possible. "
    0
    Flag
  • Kate F.
    "Clovis is a good family place. They have awesome schools and it is well maintained. The police department is amazing. "
    0
    Flag
  • Esmeralda A.
    "The elementary school is within walking distance. Overall the neighborhood is great for young families. "
    0
    Flag

LGBTQ Local Legal Protections

Homes for rent near 4074 Celeste Ave

Skip to last item
  • Results are loading
Skip to first item

Off Market Homes Near 4074 Celeste Ave

Skip to last item
Skip to first item

Explore by feature

4074 Celeste Ave, Clovis, CA 93619 is a 4 bedroom, 2 bathroom, 1,746 sqft single-family home built in 2017. This property is not currently available for sale. 4074 Celeste Ave was last sold on Dec 6, 2024 for $496,000 (0% higher than the asking price of $495,000). The current Trulia Estimate for 4074 Celeste Ave is $497,900.