1874 Celeste Ave, Clovis, CA 93611
OFF MARKET
Listed by Michele Stephens, Homesmart PV & Associates, (559) 473-2555 . Bought with NONMEMBER MRML

1874 Celeste Ave
Clovis, CA 93611

  • 4 Beds
  • 3 Baths
  • 2,521 sqft

$547,700

Trulia Estimate
as of May 10, 2026
Est. Refi. Payment $3,260/mo*
Refinance Your Home

$547,700

Trulia Estimate
as of May 10, 2026
Est. Refi. Payment $3,260/mo*
Refinance Your Home
4 Beds
3 Baths
2,521 sqft

Homes for sale near 1874 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

PRICE IMPROVEMENT!!! Tucked in a quiet neighborhood by Clovis High, you will find this wonderful, move in ready home! With 4 bedrooms, 3 baths, close to 2600sf on an almost 10,000 sf lot, this light, bright home checks the boxes. High ceilings open up the thoughtful floor plan. Entertain, work or create spaces that fit your lifestyle. Built in cabinets and closets highlight the hall as you make your way to the bedrooms. The primary suite is large with an additional sitting area and door to the backyard. A separate bedroom and bath could be used for multi-gen living or as a potential income source. In the heart of Clovis, this well cared for home is ready for you! Call today for your private showing!
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 December 12, 2024

Home Highlights

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

Home Details for 1874 Celeste Ave

Interior Features

Interior Details
Number of Rooms: 11Types of Rooms: Master Bedroom, Bedroom, Bathroom, Entry Foyer, Family Room, Kitchen, Laundry, Living Room
Beds & Baths
Number of Bedrooms: 4Main Level Bedrooms: 4Number of Bathrooms: 3Number of Bathrooms (full): 3Number of Bathrooms (main level): 3
Dimensions and Layout
Living Area: 2521 Square Feet
Appliances & Utilities
Utilities: Cable Connected, Electricity Connected, Natural Gas Connected, Phone Available, Sewer Connected, Water ConnectedAppliances: Dishwasher, Range Hood, Self Cleaning OvenDishwasherLaundry: Inside,Laundry Room
Heating & Cooling
Heating: Central,Fireplace(s)Has CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Central
Fireplace & Spa
Fireplace: Living Room, MasonrySpa: NoneHas a FireplaceNo Spa
Windows, Doors, Floors & Walls
Window: Double Pane WindowsDoor: Double Door EntryFlooring: Laminate, TileCommon Walls: No Common Walls
Levels, Entrance, & Accessibility
Stories: 1Number of Stories: 1Levels: OneEntry Location: NorthFloors: Laminate, Tile
View
No ViewView: None
Security
Security: Carbon Monoxide Detector(s), Smoke Detector(s)

Exterior Features

Exterior Home Features
Roof: TilePatio / Porch: Concrete, CoveredFencing: Excellent Condition, WoodOther Structures: Shed(s)Foundation: SlabNo Private Pool
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2Has a GarageHas an Attached GarageParking Spaces: 2Parking: Concrete,Direct Access,Driveway Level,Door-Single,Driveway,Garage Faces Front,Garage,RV Potential,On Street
Pool
Pool: None
Frontage
Road Frontage: City StreetRoad Surface Type: PavedNot on Waterfront
Water & Sewer
Sewer: Public Sewer
Surface & Elevation
Elevation Units: Feet

Days on Market

Cumulative Days on Market: 64

Property Information

Year Built
Year Built: 1989
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceStructure Type: HouseArchitecture: Mediterranean
Building
Not a New ConstructionNot Attached PropertyNo Additional Parcels
Property Information
Parcel Number: 55102607

Price & Status

Price
List Price: $564,900
Status Change & Dates
Off Market Date: Fri Nov 08 2024

Active Status

MLS Status: Closed

Location

Direction & Address
City: Clovis
School Information
High School District: Clovis Unified

Community

Community Features: Biking, Curbs, Gutter(s), Storm Drain(s), Street Lights, SidewalksNot Senior Community

HOA

Association for this Listing: California Regional MLS

Lot Information

Lot Area: 9900 sqft

Listing Info

Special Conditions: Standard

Offer

Listing Terms: Cash, Conventional, FHA, Government Loan, VA Loan

Miscellaneous

Mls Number: FR24158310Living Area Range Units: Square FeetAttribution Contact: 559-284-7709Common Interest: NoneUniversal Property Id: US-06019-N-55102607-R-N

Additional Information

BikingCurbsGutter(s)Storm Drain(s)Street LightsSidewalks
Last check for updates: about 16 hours ago
Listed by Michele Stephens DRE #01267937, (559) 284-7709
Homesmart PV & Associates
Bought with: Nguyen Viet Nguyen DRE #02195672, NONMEMBER MRML
Originating MLS: California Regional MLS
Source: CRMLS, MLS#FR24158310

Price History for 1874 Celeste Ave

DatePriceEventSource
11/08/2024$545,000Sold
CRMLS #FR24158310
10/06/2024$564,900PendingHomeSmart #616239
10/06/2024$564,900ContingentCRMLS #FR24158310
09/26/2024$564,900PriceChange
Fresno MLS #616239
09/06/2024$569,900PriceChange
Fresno MLS #616239
09/02/2024$579,900PriceChange
Fresno MLS #616239
08/23/2024$589,900PriceChange
Fresno MLS #616239
08/09/2024$599,000PriceChange
Fresno MLS #616239
08/01/2024$610,000Listed For SaleFresno MLS #616239
08/04/2021$482,000Sold
N/A
07/14/2021$475,000PendingFresno MLS #562184
07/12/2021$475,000PriceChange
Fresno MLS #562184
07/01/2021$495,000Listed For SaleFresno MLS #562184
07/27/2019$2,200ListingRemovedAgent Provided
07/10/2019$2,200Listed For RentAgent Provided
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$6,434
Assessment$545,000
Home facts updated by county records

Comparable Sales for 1874 Celeste Ave

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
837 Cypress Ave, Clovis, CA
0.27
Single-Family Home
$650,000
09/19/25
4
3
2,800
847 Amber Ave, Clovis, CA
0.16
Single-Family Home
$490,000
08/11/25
3
3
1,848
841 Whittier Ave, Clovis, CA
0.06
Single-Family Home
$475,000
07/18/25
3
2
1,780
2123 Wrenwood Ave, Clovis, CA
0.29
Single-Family Home
$625,000
07/10/25
5
3
3,468
2035 Mesa Ave, Clovis, CA
0.30
Single-Family Home
$705,000
05/30/25
5
3
3,468
2077 Gibson Ave, Clovis, CA
0.37
Single-Family Home
$580,000
09/30/25
4
2
2,563
1852 Escalon Ave, Clovis, CA
0.36
Single-Family Home
$480,000
06/26/25
4
2
1,778
2012 Beverly Ave, Clovis, CA
0.62
Single-Family Home
$475,000
12/19/25
4
3
2,400
1580 Armstrong Ave, Clovis, CA
0.66
Single-Family Home
$505,000
09/04/25
4
3
2,600

Assigned Schools

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

The multiple listing data appearing on this website, or contained in reports produced therefrom, is owned and copyrighted by California Regional Multiple Listing Service, Inc. ("CRMLS") and is protected by all applicable copyright laws. Information provided is for viewer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the viewer may be interested in purchasing. All listing data, including but not limited to square footage and lot size is believed to be accurate, but the listing Agent, listing Broker and CRMLS and its affiliates do not warrant or guarantee such accuracy. The viewer should independently verify the listed data prior to making any decisions based on such information by personal inspection and/or contacting a real estate professional.
Based on information from California Regional Multiple Listing Service, Inc. as of 2026-02-09 09:51:42 PST and /or other sources. 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

Homes for rent near 1874 Celeste Ave

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

Off Market Homes Near 1874 Celeste Ave

Skip to last item
Skip to first item

Explore by feature

1874 Celeste Ave, Clovis, CA 93611 is a 4 bedroom, 3 bathroom, 2,521 sqft single-family home built in 1989. This property is not currently available for sale. 1874 Celeste Ave was last sold on Nov 8, 2024 for $545,000 (4% lower than the asking price of $564,900). The current Trulia Estimate for 1874 Celeste Ave is $547,700.