Listing Agent: Martin Chavez, Intero Real Estate Services
Beautiful home just hit the market. Recently remodeled. New garage door, updated kitchen with new cabinets and countertops, freshly painted, updated bathrooms. Large lot for possible ADU and parking for trailer.
Property Sub Type
Single Family Residence
Year Built
1981
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Price Per Square Foot
$323
Days On London
4
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
FROM 99 EXIT E HATCH, RIGHT ON CENTRAL, LEFT ON GLASGOW DR, RIGHT ON MYRTLEWOOD DR, LEFT ON LAVON LANE Cross Street: E HATCH AND CENTRAL
Heating
Central
Cooling
Central Air
Roof
Shingle
Foundation Details
Slab
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Appliances Y/N
No
Flooring
Laminate, Tile
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Size Area
8099.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
040080001000
Zoning
SFR
Association Y/N
No
High School District
Ceres Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 470250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 519750 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) >= 1282 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1782 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` = 1710449 OR `props-main`.`id` = 1710919 OR `props-main`.`id` = 1704913 OR `props-main`.`id` = 1709826 OR `props-main`.`id` = 1688578 OR `props-main`.`id` = 1707205 OR `props-main`.`id` = 1706152 OR `props-main`.`id` = 1710540 OR `props-main`.`id` = 1710836 OR `props-main`.`id` = 1668573 OR `props-main`.`id` = 1709970 OR `props-main`.`id` = 1710307 OR `props-main`.`id` = 1711228 OR `props-main`.`id` = 1704359 OR `props-main`.`id` = 1662513 OR `props-main`.`id` = 1709991 OR `props-main`.`id` = 1674469 OR `props-main`.`id` = 1705172 OR `props-main`.`id` = 1703583 OR `props-main`.`id` = 1702216 OR `props-main`.`id` = 1706037 OR `props-main`.`id` = 1710133 OR `props-main`.`id` = 1710914 OR `props-main`.`id` = 1708278 OR `props-main`.`id` = 1710913 OR `props-main`.`id` = 1710120 OR `props-main`.`id` = 1711050 OR `props-main`.`id` = 1695208 OR `props-main`.`id` = 1709948 OR `props-main`.`id` = 1703456 OR `props-main`.`id` = 1710880 OR `props-main`.`id` = 1710879 OR `props-main`.`id` = 1710881 OR `props-main`.`id` = 1702785 OR `props-main`.`id` = 1691126 OR `props-main`.`id` = 1710627 OR `props-main`.`id` = 1646283 OR `props-main`.`id` = 1710399 OR `props-main`.`id` = 1698941 OR `props-main`.`id` = 1707866 OR `props-main`.`id` = 1710912 OR `props-main`.`id` = 1710994 OR `props-main`.`id` = 1708168 OR `props-main`.`id` = 1711332 OR `props-main`.`id` = 1699060 OR `props-main`.`id` = 1700083 OR `props-main`.`id` = 1704117 OR `props-main`.`id` = 1710794)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82035730' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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
$495,000
4
2
1,566
0.14
1617 Charlottesville Ln
Ceres, CA 95307
$474,000
4
2
1,614
0.13
940 Allacante Dr
Ceres, CA 95307
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.
