Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/metrolist/226005356/401-Church-St/Modesto/https://www.londonproperties.com/images/props/metrolist/full/226005356.jpgLondon Properties Modesto Real Estate | 401 Church St
Welcome home to 401 Church street a 3 bedroom 2 bathroom home completely remodeled. New kitchen cabinets, countertops and appliances. New vanities and showers in both bathrooms. New doors and casing throughout. New recessed lighting and fans.Potential for ADU with huge backyard. Tons of side yard for RV or trailer access.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1974
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Kitchen 0-5YR, Bed 0-5YR
Stories
1
Home Warranty
No
Directions to Property
East on briggsmore ave thru clause turns into Parker. Right on church at the stop sign.Continue on church for a mile house on the right.
Cross Street
Circuit Dr.
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco, Frame
Foundation
Raised
Roof
Composition
Heating
Central, Fireplace(s), Wood Stove
Cooling
Ceiling Fan(s), Central
Laundry Features
In Garage
Other Structures
Shed(s), Storage
Full Bathrooms
2
Bath Features
Shower Stall(s), Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Living Room, Raised Hearth, Stone, Wood Burning
Flooring
Vinyl
Appliances
Hood Over Range, Dishwasher, Electric Cook Top
Kitchen Features
Quartz Counter, Stone Counter
Dining Room Features
Dining Bar, Dining/Family Combo
Living Room Features
Other
Patio And Porch Features
Front Porch
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Electric, Natural Gas Connected
Electric
220 Volts,220 Volts in Kitchen,220 Volts in Laundry
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, RV Access, RV Possible, RV Storage
Garage Spaces
2.00
Lot Features
Private
APN
133 004 007 000
Horse Property
No
Zoning Description
R-1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Empire Union
Middle or Junior School District
Empire Union
Senior High School District
Modesto City
Census Tract
20.02
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 394250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 435750 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) >= 1026 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1526 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` = 1700871 OR `props-main`.`id` = 1700669 OR `props-main`.`id` = 1698929 OR `props-main`.`id` = 1694438 OR `props-main`.`id` = 1702786 OR `props-main`.`id` = 1693388 OR `props-main`.`id` = 1700879 OR `props-main`.`id` = 1698922 OR `props-main`.`id` = 1690093 OR `props-main`.`id` = 1703013 OR `props-main`.`id` = 1697442 OR `props-main`.`id` = 1694063 OR `props-main`.`id` = 1701128 OR `props-main`.`id` = 1702465 OR `props-main`.`id` = 1702553 OR `props-main`.`id` = 1703036 OR `props-main`.`id` = 1700011 OR `props-main`.`id` = 1700630 OR `props-main`.`id` = 1690746 OR `props-main`.`id` = 1691535 OR `props-main`.`id` = 1700223 OR `props-main`.`id` = 1684962 OR `props-main`.`id` = 1700595 OR `props-main`.`id` = 1698707 OR `props-main`.`id` = 1697604 OR `props-main`.`id` = 1689722 OR `props-main`.`id` = 1694538 OR `props-main`.`id` = 1698444 OR `props-main`.`id` = 1680573 OR `props-main`.`id` = 1702989 OR `props-main`.`id` = 1689340 OR `props-main`.`id` = 1695919 OR `props-main`.`id` = 1695920 OR `props-main`.`id` = 1697549 OR `props-main`.`id` = 1697744 OR `props-main`.`id` = 1697754 OR `props-main`.`id` = 1701496 OR `props-main`.`id` = 1702456 OR `props-main`.`id` = 1699946)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226005356' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-16' 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();
3
Similar Properties
$430,000
3
2
1,511
0.11
417 Mid Pines Way
Modesto, CA 95354
$419,999
3
2
1,120
0.14
3540 Hallsboro Ct
Modesto, CA 95357
$410,000
4
2
1,440
0.12
405 Melbourne Dr
Modesto, CA 95357
Courtesy of Cameron Sparks, Sparks Real Estate, Inc. 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.
