Looking for a spacious home on a generous lot in Ceres ? Welcome to 1809 Blueridge Ct. Tucked away at the end of a quiet cul-de-sac, this beautiful 4-bedroom home features an additional loft, a massive built-in pool, and a custom enclosed patio with storage. The main floor includes multiple living and dining areas, a bedroom and full bathroom, ideal for a growing family, multi-generational living, or hosting guests. Conveniently located within walking distance to Atkinson Elementary School and just a short drive to Highway 99 and numerous new shopping centers, this home offers both comfort and convenience in one desirable package.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1990
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Other-Rmks 0-5YR
Stories
2
Levels
Two
Home Warranty
No
Directions to Property
Coming from Hwy99 Hatch exit: - Straight down Hatch road through Richland ave. - Left onto Stonumn - Through 2 stop signs - Next court on the left Blueridge - Big blue house on the far inside of the court.
Cross Street
Stonum
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco, Wood Siding
Foundation
Concrete
Roof
Other
Heating
Central, Fireplace Insert, Fireplace(s), Wood Stove, MultiUnits, Natural Gas
Boat Storage, RV Access, Covered, Garage Facing Front
Garage Spaces
3.00
Carport Spaces
6.00
Open Parking Spaces
4.00
Lot Features
Court, Cul-De-Sac, Curb(s)/Gutter(s)
APN
039 058 050 000
Land Use
Residential
Topography
Level
Driveway/Sidewalks
Paved Driveway, Sidewalk/Curb/Gutter
Fencing
Back Yard, Wood
Horse Property
No
Road Surface Type
Asphalt, Paved
Road Responsibility
Public Maintained Road
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Ceres Unified
Middle or Junior School District
Ceres Unified
Senior High School District
Ceres Unified
Distance to Public Transportation
3 Blocks
Census Tract
27.02
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 546250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 603750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1787 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2287 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1711598 OR `props-main`.`id` = 1704359 OR `props-main`.`id` = 1711620 OR `props-main`.`id` = 1674469 OR `props-main`.`id` = 1713082 OR `props-main`.`id` = 1703583 OR `props-main`.`id` = 1711376 OR `props-main`.`id` = 1706037 OR `props-main`.`id` = 1712170 OR `props-main`.`id` = 1708278 OR `props-main`.`id` = 1712169 OR `props-main`.`id` = 1711491 OR `props-main`.`id` = 1711960 OR `props-main`.`id` = 1695208 OR `props-main`.`id` = 1709948 OR `props-main`.`id` = 1703456 OR `props-main`.`id` = 1712141 OR `props-main`.`id` = 1712345 OR `props-main`.`id` = 1712140 OR `props-main`.`id` = 1712142 OR `props-main`.`id` = 1702785 OR `props-main`.`id` = 1712678 OR `props-main`.`id` = 1691126 OR `props-main`.`id` = 1712830 OR `props-main`.`id` = 1711911 OR `props-main`.`id` = 1646283 OR `props-main`.`id` = 1711689 OR `props-main`.`id` = 1712019 OR `props-main`.`id` = 1712168 OR `props-main`.`id` = 1712247 OR `props-main`.`id` = 1713136 OR `props-main`.`id` = 1708168 OR `props-main`.`id` = 1713055 OR `props-main`.`id` = 1711332 OR `props-main`.`id` = 1709867 OR `props-main`.`id` = 1711878 OR `props-main`.`id` = 1712220 OR `props-main`.`id` = 1699060 OR `props-main`.`id` = 1700083 OR `props-main`.`id` = 1704117 OR `props-main`.`id` = 1712062 OR `props-main`.`id` = 1712128 OR `props-main`.`id` = 1711735 OR `props-main`.`id` = 1711715 OR `props-main`.`id` = 1712116 OR `props-main`.`id` = 1698115 OR `props-main`.`id` = 1692292 OR `props-main`.`id` = 1681376 OR `props-main`.`id` = 1710210 OR `props-main`.`id` = 1711845 OR `props-main`.`id` = 1703426 OR `props-main`.`id` = 1688054 OR `props-main`.`id` = 1709973 OR `props-main`.`id` = 1709972 OR `props-main`.`id` = 1709971 OR `props-main`.`id` = 1704154)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225145058' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-03' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
2
Similar Properties
$574,999
4
3
1,892
0.14
2816 Canyon Dr
Modesto, CA 95351
$569,000
5
3
2,060
0.22
204 N Santa Ana Ave
Modesto, CA 95354
Courtesy of Jesica Harold, Just Real Estate IDX provided by Reliance Marketing
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
