INVESTORS DREAM!!! Don't miss this rare opportunity to own a well maintained fourplex located in a quiet cul-de-sac, in a desirable Modesto neighborhood. Each of the four units offers spacious 2 bedroom 1 bathroom layouts with open living areas, ample natural light and private outdoor spaces. This property provides immediate cash-flow and strong rental upside. Features include on-site covered parking with storage, low maintenance landscape and easy access to schools, shopping, and major commuter routes. Ideal for both seasoned investors and first time multifamily buyers. FHA financing possible qualifies under 4 unit limit!!!
Multi-familyProperty Type
1968Year Built
0.3 acresLot Size
$298Est. Price/Sq.Ft.
5 spacesParking
Listed by Tyler Uecker•DRE #01994273• Real Broker Technologies
Bought with Tyler Uecker•DRE #01994273• Real Broker Technologies
bridgeMLS, Bay East AOR, or Contra Costa AOR #40890993
Jan 2, 2020
Contingent
—
Public Records
Apr 17, 2019
Sold
$545,000
$180/sq ft
Year
Property tax
Land + Additions
Assessment*
2026
$9,093 (+21.4%)
$265,200 + $561,000
$826,200
2025
$7,493 (+1.8%)
$265,200 + $561,000
$826,200
2024
$7,358 (+1.9%)
$142,171 + $535,884
$678,055
2023
$7,218 (+4.2%)
$139,384 + $525,377
$664,761
2022
$6,925 (+1.8%)
$136,651 + $515,076
$651,727
2021
$6,805 (+13.2%)
$133,972 + $504,977
$638,949
2020
$6,013 (+22.0%)
$131,346 + $495,076
$626,422
2019
$4,928
$107,610 + $448,290
$555,900
2018
$4,928 (+10.5%)
$76,000 + $379,000
$455,000
2017
$4,459 (+8.5%)
$69,000 + $344,500
$413,500
2016
$4,111 (+19.7%)
$69,000 + $344,500
$413,500
2015
$3,435 (+10.4%)
$62,500 + $313,500
$376,000
2014
$3,112 (+24.6%)
$62,500 + $217,500
$280,000
2013
$2,498 (+6.7%)
$62,500 + $217,500
$280,000
2012
$2,341 (+9.2%)
$50,000 + $174,000
$224,000
2011
$2,145 (+0.2%)
$56,000 + $156,000
$212,000
2010
$2,140 (−9.2%)
$56,000 + $136,000
$192,000
2009
$2,357 (−58.3%)
$56,000 + $136,000
$192,000
2008
$5,654
$55,000 + $159,500
$214,500
2007
$5,654
$107,159 + $412,405
$519,564
Tax history for 1906 Celeste Ct
Year
Property tax
Land + Additions
Assessment*
2026
$9,093 (+21.4%)
$265,200 + $561,000
$826,200
2025
$7,493 (+1.8%)
$265,200 + $561,000
$826,200
2024
$7,358 (+1.9%)
$142,171 + $535,884
$678,055
2023
$7,218 (+4.2%)
$139,384 + $525,377
$664,761
2022
$6,925 (+1.8%)
$136,651 + $515,076
$651,727
2021
$6,805 (+13.2%)
$133,972 + $504,977
$638,949
2020
$6,013 (+22.0%)
$131,346 + $495,076
$626,422
2019
$4,928
$107,610 + $448,290
$555,900
2018
$4,928 (+10.5%)
$76,000 + $379,000
$455,000
2017
$4,459 (+8.5%)
$69,000 + $344,500
$413,500
2016
$4,111 (+19.7%)
$69,000 + $344,500
$413,500
2015
$3,435 (+10.4%)
$62,500 + $313,500
$376,000
2014
$3,112 (+24.6%)
$62,500 + $217,500
$280,000
2013
$2,498 (+6.7%)
$62,500 + $217,500
$280,000
2012
$2,341 (+9.2%)
$50,000 + $174,000
$224,000
2011
$2,145 (+0.2%)
$56,000 + $156,000
$212,000
2010
$2,140 (−9.2%)
$56,000 + $136,000
$192,000
2009
$2,357 (−58.3%)
$56,000 + $136,000
$192,000
2008
$5,654
$55,000 + $159,500
$214,500
2007
$5,654
$107,159 + $412,405
$519,564
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
2
Baths
1
Stories
1
Lot width
—
Lot depth
—
Lot size
0.3 Acres
Year renovated
—
Sq. Ft.
3,024
Year built
1968
Style
Multi-Family (5+ Unit)
County
Stanislaus County
APN
066019029000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 15, 2026.
R-2
Medium-Density Residential Zone
The R-2 (Medium-Density Residential) zoning district is intended to accommodate medium-density residential development, including accessory uses and structures.
Permitted uses
Include but are not limited to:
Garden center
Housing-Single unit
Housing-Multiple units
Housing-Senior
Housing-Other
Lodging & hospitality
Bed & breakfast
Public service
Housing-Mobile home park
Park & open space
Jul 14, 2006 • Final
Res reroof
Roofing
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking & Garage Information
Parking Total: 5
Parking Features: Carport, Covered
Interior
Heating & Cooling
Cooling: Wall Unit(s)
Heating: Wall Furnace
Interior Features
Flooring: Carpet, Vinyl
Laundry Features: In Each Unit
# of Stories: 1
# of Stories (Total): 1
Multi-Unit Information
# of Units (Total): 4
Unit 1
# of Bedrooms (Total): 2
# of Bathrooms (Full): 1
Unit 2
# of Bedrooms (Total): 2
# of Bathrooms (Full): 1
Unit 3
# of Bedrooms (Total): 2
# of Bathrooms (Full): 1
Unit 4
# of Bedrooms (Total): 2
# of Bathrooms (Full): 1
Exterior
Exterior Features
Roof: Composition
Property Information
Property Type: Residential Income
Property Sub Type: Quadruplex
Subtype Description: Apartments
Year Built: 1,968
Lot Information
Lot Features: Court, Sidewalk
Lot Size Square Feet: 13,199
Lot Size Acres: 0.303
Utilities
Utility Information
Utilities: Natural Gas Connected
Sewer: Sewer Connected, In & Connected
Irrigation Source: None
Water Source: Meter on Site
Location
HOA Information
Association YN: No
School Information
School District County: Stanislaus
Elementary School District: Modesto City
Middle Or Junior School District: Modesto City
High School District: Modesto City
Location Information
Postal Code Plus 4: 2962
Postal Code: 95355
County Or Parish: Stanislaus
CrossStreet: celeste dr
Directions: Briggsmore Ave to rose ave, head north on rose make a right on celeste dr then a right into celeste ct
State Or Province: CA
Street Number Numeric: 1906
Unparsed Address: 1906 Celeste Ct, Modesto, CA 95355-2962
Street Address Filtered: 1906 Celeste Ct
Public facts
Beds: 2
Baths: 1.0
Sq. Ft.: 3,024
Stories: 1.0
Lot Size: 0.3 acres
Style: Multi-Family (5+ Unit)
Year Built: 1968
Year Renovated: —
County: Stanislaus County
APN: 066019029000
Home facts updated by county records on Oct 15, 2026
Other
Selling Agent
Buyer Agent Full Name: Tyler J Uecker
Around this home
Schools
K - 12
Preschool & daycare
Coleman F. Brown Elementary School
Public K-5 • Assigned • 0.6mi
4/10
Somerset Middle School
Public 6-8 • Assigned • 1.2mi
7/10
Fred C. Beyer High School
Public 9-12 • Assigned • 1.4mi
6/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
4/10 Flood Factor
Estimated 18-26% chance of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
7/10 Heat Factor
7 days above 102° expected this year, 15 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
28 unhealthy days expected this year, 32 days in 30 years
Provided by First Street
Historical weather
Modesto, CA • 95355
Average low and high temperatures (°F)
60
40
65
45
74
49
75
50
84
56
92
60
94
62
94
64
88
64
75
54
64
47
56
45
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 13.2 hours in
June and 4.6 hours in December, placing it above the
U.S. average for solar exposure.