Listing Agent: Ronald Scanlon, Century 21 Select Real Estate
Very Nice 3 bedroom 1 bathroom home with alot of nice features and pool.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1922
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
front
Price Per Square Foot
$301
Days On London
0
Cumulative Days On London
0
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
S on McHenry R on Modesto Ave
Room Type
Laundry, Basement, Kitchen, Living Room, Main Floor Bedroom, Family Room
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside
Main Level Bedrooms
1
Bathrooms Full
1
Bathrooms Full And Three Quarter
1
Bathrooms Half
1
Main Level Bathrooms
1
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Pool Features
In Ground, Fenced, Private
Pool Private Y/N
Yes
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
No
Garage Spaces
2.00
Number Remotes
0
Lot Features
0-1 Unit/Acre
Lot Size Area
6100.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Common Interest
None
Parcel Number
111005023000
Additional Parcels Y/N
No
Community Features
Gutters, Sidewalks
Senior Community Y/N
No
Association Y/N
No
High School District
Modesto City
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
11
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 475000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 525000 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) >= 1413 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1913 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` = 1781426 OR `props-main`.`id` = 1786460 OR `props-main`.`id` = 1788722 OR `props-main`.`id` = 1778552 OR `props-main`.`id` = 1723143 OR `props-main`.`id` = 1781766 OR `props-main`.`id` = 1775809 OR `props-main`.`id` = 1760650 OR `props-main`.`id` = 1704117 OR `props-main`.`id` = 1786648 OR `props-main`.`id` = 1761876 OR `props-main`.`id` = 1786899 OR `props-main`.`id` = 1790401 OR `props-main`.`id` = 1758492 OR `props-main`.`id` = 1790238 OR `props-main`.`id` = 1790233 OR `props-main`.`id` = 1790223 OR `props-main`.`id` = 1788661 OR `props-main`.`id` = 1781924 OR `props-main`.`id` = 1771840 OR `props-main`.`id` = 1771587 OR `props-main`.`id` = 1790887 OR `props-main`.`id` = 1781909 OR `props-main`.`id` = 1681376 OR `props-main`.`id` = 1779612 OR `props-main`.`id` = 1786386 OR `props-main`.`id` = 1746711 OR `props-main`.`id` = 1763023 OR `props-main`.`id` = 1773925 OR `props-main`.`id` = 1786690 OR `props-main`.`id` = 1774774 OR `props-main`.`id` = 1723705 OR `props-main`.`id` = 1782650 OR `props-main`.`id` = 1738013 OR `props-main`.`id` = 1784091 OR `props-main`.`id` = 1781949 OR `props-main`.`id` = 1771661 OR `props-main`.`id` = 1771618 OR `props-main`.`id` = 1785275 OR `props-main`.`id` = 1771662 OR `props-main`.`id` = 1771772 OR `props-main`.`id` = 1757801 OR `props-main`.`id` = 1771567 OR `props-main`.`id` = 1771781 OR `props-main`.`id` = 1774049 OR `props-main`.`id` = 1788758 OR `props-main`.`id` = 1793547 OR `props-main`.`id` = 1786736 OR `props-main`.`id` = 1775858 OR `props-main`.`id` = 1763967 OR `props-main`.`id` = 1787457 OR `props-main`.`id` = 1778744 OR `props-main`.`id` = 1753018 OR `props-main`.`id` = 1741452 OR `props-main`.`id` = 1782790 OR `props-main`.`id` = 1751310 OR `props-main`.`id` = 1791884 OR `props-main`.`id` = 1734251 OR `props-main`.`id` = 1788903 OR `props-main`.`id` = 1794088 OR `props-main`.`id` = 1764105 OR `props-main`.`id` = 1773082 OR `props-main`.`id` = 1780366 OR `props-main`.`id` = 1757595 OR `props-main`.`id` = 1792094 OR `props-main`.`id` = 1790965 OR `props-main`.`id` = 1789759 OR `props-main`.`id` = 1789777 OR `props-main`.`id` = 1774065 OR `props-main`.`id` = 1768944 OR `props-main`.`id` = 1781393 OR `props-main`.`id` = 1791086 OR `props-main`.`id` = 1755687 OR `props-main`.`id` = 1755686 OR `props-main`.`id` = 1728820 OR `props-main`.`id` = 1781940 OR `props-main`.`id` = 1766491 OR `props-main`.`id` = 1793257 OR `props-main`.`id` = 1781945 OR `props-main`.`id` = 1776746 OR `props-main`.`id` = 1793612 OR `props-main`.`id` = 1790858 OR `props-main`.`id` = 1761311 OR `props-main`.`id` = 1771609 OR `props-main`.`id` = 1793911 OR `props-main`.`id` = 1774211 OR `props-main`.`id` = 1787474 OR `props-main`.`id` = 1788162 OR `props-main`.`id` = 1791564 OR `props-main`.`id` = 1723305 OR `props-main`.`id` = 1786037 OR `props-main`.`id` = 1739199 OR `props-main`.`id` = 1781364 OR `props-main`.`id` = 1771588 OR `props-main`.`id` = 1789854 OR `props-main`.`id` = 1788787 OR `props-main`.`id` = 1785018 OR `props-main`.`id` = 1783871 OR `props-main`.`id` = 1778478 OR `props-main`.`id` = 1781420 OR `props-main`.`id` = 1781942 OR `props-main`.`id` = 1781943 OR `props-main`.`id` = 1781944 OR `props-main`.`id` = 1788980 OR `props-main`.`id` = 1791015 OR `props-main`.`id` = 1778080 OR `props-main`.`id` = 1781937 OR `props-main`.`id` = 1763588 OR `props-main`.`id` = 1788732 OR `props-main`.`id` = 1786282 OR `props-main`.`id` = 1786741 OR `props-main`.`id` = 1774326 OR `props-main`.`id` = 1789106 OR `props-main`.`id` = 1786742 OR `props-main`.`id` = 1726019 OR `props-main`.`id` = 1785273 OR `props-main`.`id` = 1790986 OR `props-main`.`id` = 1754583 OR `props-main`.`id` = 1766365 OR `props-main`.`id` = 1754913 OR `props-main`.`id` = 1768901 OR `props-main`.`id` = 1793910 OR `props-main`.`id` = 1771908 OR `props-main`.`id` = 1775669 OR `props-main`.`id` = 1776041 OR `props-main`.`id` = 1788684 OR `props-main`.`id` = 1766271 OR `props-main`.`id` = 1772220 OR `props-main`.`id` = 1780923 OR `props-main`.`id` = 1776138 OR `props-main`.`id` = 1775357 OR `props-main`.`id` = 1750106 OR `props-main`.`id` = 1787698 OR `props-main`.`id` = 1783675 OR `props-main`.`id` = 1785274 OR `props-main`.`id` = 1788856 OR `props-main`.`id` = 1793585 OR `props-main`.`id` = 1792996 OR `props-main`.`id` = 1792766 OR `props-main`.`id` = 1787458 OR `props-main`.`id` = 1752883 OR `props-main`.`id` = 1763008)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26227943' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-21' 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();
8
Similar Properties
$525,000
3
2
1,543
0.19
316 Las Palmas Ave
Modesto, CA 95354
$515,000
3
2
1,678
0.14
1410 Maplewood Dr
Modesto, CA 95350
$479,999
3
3
1,900
0.14
1310 Del Vale Ave
Modesto, CA 95350
$479,900
3
2
1,538
113 Walden St
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.
