Living Room, Primary Bedroom, Full Bath(s), Kitchen
Construction Materials
Stucco, Frame
Foundation
Slab
Roof
Tile
Heating
Central
Cooling
Central
Laundry Features
In Garage
Full Bathrooms
2
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Living Room, Gas Starter
Flooring
Carpet, Wood
Appliances
Dishwasher, Free Standing Electric Range
Kitchen Features
Granite Counter
Dining Room Features
Dining/Living Combo
Living Room Features
Cathedral/Vaulted
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Other
Electric
220 Volts
Irrigation
None
Water Source
Public
Sewer
Other
Parking Features
Other
Garage Spaces
3.00
Open Parking Spaces
3.00
Lot Features
Shape Regular
APN
053 057 035 000
Driveway/Sidewalks
Sidewalk/Curb/Gutter
Horse Property
No
Zoning Description
SFR
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
Census Tract
25.04
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 421800 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 466200 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1045 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1545 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` = 1773346 OR `props-main`.`id` = 1771779 OR `props-main`.`id` = 1774134 OR `props-main`.`id` = 1774301 OR `props-main`.`id` = 1774313 OR `props-main`.`id` = 1773722 OR `props-main`.`id` = 1778420 OR `props-main`.`id` = 1774082 OR `props-main`.`id` = 1772123 OR `props-main`.`id` = 1777118 OR `props-main`.`id` = 1776893 OR `props-main`.`id` = 1761086 OR `props-main`.`id` = 1774635 OR `props-main`.`id` = 1761571 OR `props-main`.`id` = 1736596 OR `props-main`.`id` = 1773626 OR `props-main`.`id` = 1764176 OR `props-main`.`id` = 1773005 OR `props-main`.`id` = 1771307 OR `props-main`.`id` = 1769016 OR `props-main`.`id` = 1766939 OR `props-main`.`id` = 1763601 OR `props-main`.`id` = 1772826 OR `props-main`.`id` = 1717238 OR `props-main`.`id` = 1774861 OR `props-main`.`id` = 1728779 OR `props-main`.`id` = 1754962 OR `props-main`.`id` = 1744264 OR `props-main`.`id` = 1746385 OR `props-main`.`id` = 1776026)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226117688' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-18' 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();
5
Similar Properties
$464,950
3
2
1,152
0.14
2725 Villa Ramon Dr
Ceres, CA 95307
$459,900
3
2
1,493
0.15
3808 Georgeann Pl
Ceres, CA 95307
$439,999
3
2
1,093
0.14
1313 Fannell Dr
Ceres, CA 95307
$435,000
3
2
1,472
0.12
954 Willow Lake Way
Ceres, CA 95307
Courtesy of Jorge Gonzalez, PMZ 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.
