Listing Agent: Silvia Urbina, Re/Max Synergy Group
Beautiful 3 bedroom and 2 bath home in a quiet neighborhood in Modesto CA. House located in a dead end street so very private. This is a great starter home with few more touches you can make it your own! It has solar system that is been leased. Kitchen was updated when seller moved in and has been kept very nicely with pride of ownership! Granite counters and sterling silver appliances. Nice and spacious back yard! Don't miss the opportunity to own this house! Recently painted, new back yard shed, New Bathroom tub.
Property Sub Type
Single Family Residence
Year Built
1972
Levels
One
Price Per Square Foot
$384
Days On London
28
Cumulative Days On London
30
County Or Parish
Stanislaus
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Yosemite to Church Cross Street: CHURCH.
Architectural Style
Contemporary
Cooling
Central Air
Roof
Shingle
Construction Materials
Wood Siding
Foundation Details
Raised
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Room Kitchen Features
Remodeled Kitchen
Appliances Y/N
Yes
Accessibility Features
None
Flooring
Wood
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Front Yard, Back Yard
Lot Size Area
6029.0000
Lot Size Units
Square Feet
Parcel Number
009003048000
Subdivision Name
None
Subdivision Name Other
None
Association Y/N
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 384750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 425250 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) >= 806 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1306 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` = 1708149 OR `props-main`.`id` = 1700871 OR `props-main`.`id` = 1714418 OR `props-main`.`id` = 1698929 OR `props-main`.`id` = 1706147 OR `props-main`.`id` = 1694438 OR `props-main`.`id` = 1693388 OR `props-main`.`id` = 1715758 OR `props-main`.`id` = 1711529 OR `props-main`.`id` = 1704294 OR `props-main`.`id` = 1712327 OR `props-main`.`id` = 1714684 OR `props-main`.`id` = 1709720 OR `props-main`.`id` = 1708338 OR `props-main`.`id` = 1690746 OR `props-main`.`id` = 1691535 OR `props-main`.`id` = 1714385 OR `props-main`.`id` = 1714077 OR `props-main`.`id` = 1711309 OR `props-main`.`id` = 1697604 OR `props-main`.`id` = 1689722 OR `props-main`.`id` = 1713425 OR `props-main`.`id` = 1704457 OR `props-main`.`id` = 1698444 OR `props-main`.`id` = 1713241 OR `props-main`.`id` = 1712762 OR `props-main`.`id` = 1689340 OR `props-main`.`id` = 1708424 OR `props-main`.`id` = 1709273 OR `props-main`.`id` = 1697549 OR `props-main`.`id` = 1697744 OR `props-main`.`id` = 1712323 OR `props-main`.`id` = 1712833 OR `props-main`.`id` = 1714780 OR `props-main`.`id` = 1716152 OR `props-main`.`id` = 1708497 OR `props-main`.`id` = 1709921 OR `props-main`.`id` = 1713476 OR `props-main`.`id` = 1691865)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41123879' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-15' 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
$424,000
3
2
1,120
0.11
3520 HALLSBORO Ct
Modesto, CA 95357
$424,000
3
2
1,152
0.19
601 Summit Ct
Modesto, CA 95357
$419,999
3
2
1,120
0.14
3540 Hallsboro Ct
Modesto, CA 95357
$410,000
3
2
1,101
0.12
3424 Penny Ln
Modesto, CA 95354
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.
