1788 Celeste Ave, Clovis, CA 93611
OFF MARKET

1788 Celeste Ave
Clovis, CA 93611

  • 4 Beds
  • 2 Baths
  • 2,144 sqft

$556,500

Trulia Estimate
as of Aug 9, 2026
Est. Refi. Payment $3,435/mo*
Refinance Your Home

$556,500

Trulia Estimate
as of Aug 9, 2026
Est. Refi. Payment $3,435/mo*
Refinance Your Home
4 Beds
2 Baths
2,144 sqft

Local Information

  • Map ViewExplore the area around 1788 Celeste Ave.
  • Schools1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Property Type
Single-Family Home
Year Built
1983
Living Area
2,144 sqft
Price/Sqft
$260
Parking
Attached Garage
HOA
None

About this House

Beautifully updated four bedroom home in the Clovis High School Attendance Area. The home has been upgraded with: new flooring, new paint, new appliances, new cabinets, new counter tops, new window coverings, new shower stalls and enclosures. All of this and it sits on a nearly ten thousand square foot lot. The home is in close proximity to schools (Clovis Elementary and Clovis High School) Vons grocery store, Sierra Vista Mall, Freeway 168 and Old Town Clovis. Call today to schedule a private showing.
1788 Celeste Ave, Clovis, CA 93611 is a 4 bedroom, 2 bathroom, 2,144 sqft single-family home built in 1983. It last sold for $565,000 on May 10, 2024 (3% above the $550,000 asking price). It is currently off market. The Trulia Estimate is $556,500, with a rent estimate of $2,807/month.

Home Details for 1788 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: 2144 Square Feet
Appliances & Utilities
Utilities: Public UtilitiesAppliances: Built In Range/Oven, Electric Appliances, 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: MasonryHas a Fireplace
Windows, Doors, Floors & Walls
Flooring: Vinyl
Levels, Entrance, & Accessibility
Stories: 1Levels: OneFloors: Vinyl

Exterior Features

Exterior Home Features
Roof: CompositionFoundation: 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: 3

Property Information

Year Built
Year Built: 1983
Property Type / Style
Property Type: ResidentialProperty Subtype: Residential, Single Family ResidenceArchitecture: Contemporary
Building
Construction Materials: Stucco, Wood Siding
Property Information
Parcel Number: 49826502

Price & Status

Price
List Price: $550,000

Active Status

MLS Status: Sold

Media

Location

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

Building

Building Area
Building Area: 2144 Square Feet

Community

Not Senior Community

HOA

Association for this Listing: Fresno MLS

Lot Information

Lot Area: 9661.608 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: 610755
Last check for updates: about 7 hours ago
Listed by Jared Martin DRE #01319553, (559) 779-1504
Strong Holdings Inc
Bought with: Joanne Oh DRE #00830539, (559) 213-3702, Century 21 Jordan-Link & Compa
Originating MLS: Fresno MLS
Source: Fresno MLS, MLS#610755

Price History for 1788 Celeste Ave

DatePriceEventSource
05/10/2024$565,000Sold
Fresno MLS #610755
04/16/2024$550,000PendingFresno MLS #610755
04/12/2024$550,000Listed For SaleFresno MLS #610755
01/20/2005$280,000Sold
N/A

Market trends in Clovis

Last updated June 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$473K
$1.83KMoM
Sale-to-List Price
100.0%
Price per sq ft
$281
$2MoM
Available listings
334
14MoM
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$6,712
Assessment$576,300
Home facts updated by county records

Comparable Sales for 1788 Celeste Ave

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
701 McArthur Ave, Clovis, CA
0.15
Single-Family Home
$560,000
07/10/26
5
2
2,206
860 McArthur Ave, Clovis, CA
0.06
Single-Family Home
$480,000
07/29/26
3
2
1,780
983 Ezie Ave, Clovis, CA
0.22
Single-Family Home
$490,000
11/10/25
3
2
1,804
1741 Robinwood Ave, Clovis, CA
0.17
Single-Family Home
$465,000
06/18/26
3
2
1,545
435 Bliss Ave, Clovis, CA
0.35
Single-Family Home
$525,000
06/25/26
4
2
1,874
860 Burgan Ave, Clovis, CA
0.27
Single-Family Home
$490,000
07/24/26
3
2
1,780
680 Fordham Ave, Clovis, CA
0.32
Single-Family Home
$461,150
10/06/25
4
2
1,702
1978 Gibson Ave, Clovis, CA
0.43
Single-Family Home
$700,000
07/15/26
4
2
2,522
1524 Burl Ave, Clovis, CA
0.60
Single-Family Home
$567,500
04/30/26
4
2
2,014

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 1788 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 793 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

Sourced by Trulia users. Learn more about our methodology.
  • Vincent ward
    "The is surrounded by two major streets easy access to the freeway and near the GYI airport."
    0
    Flag
  • 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
  • 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

Apartments for Rent

Skip to last item
Skip to first item

Explore by feature - Pet Friendly

77 pet-friendly rentals in Clovis, CA

Explore by feature - Garage

125 rentals with a garage in Clovis, CA

Explore by feature - Air Conditioning

138 rentals with air conditioning in Clovis, CA

Explore by feature - Pool

83 rentals with a pool in Clovis, CA

Explore by feature - Washer/dryer

120 rentals with a washer/dryer in Clovis, CA

Explore by feature - Outdoor Space

74 rentals with an outdoor space in Clovis, CA

Homes for sale near 1788 Celeste Ave

Skip to last item
Skip to first item

Off Market Homes Near 1788 Celeste Ave

Skip to last item
Skip to first item

Frequently asked questions about 1788 Celeste Ave

  • What is 1788 Celeste Ave estimated to be worth?
    Trulia's estimated value for 1788 Celeste Ave in Clovis, CA is $556,500.
  • What is the price history for 1788 Celeste Ave?
    1788 Celeste Ave in Clovis, CA last sold for $565,000 in May 2024.
  • Is Clovis a buyer's or seller's market?
    Clovis is currently a seller's market, based on recent for-sale activity.
  • What's the median sale price in Clovis?
    The median sale price in Clovis is $473K. That is up $1.83K from the prior month.
  • Does 1788 Celeste Ave have air conditioning?
    Yes, 1788 Celeste Ave in Clovis, CA has air conditioning.
  • Does 1788 Celeste Ave have laundry facilities?
    Yes, 1788 Celeste Ave in Clovis, CA has laundry facilities.