Must see this beautiful home with a large pool & jacuzzi combo! Back of property adjoining a community public park simply open gate and you're at the park. This 3 bedrooms and 2-bathroom home is also conveniently located near shopping, gas, restaurants and freeway!
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1965
Year Built Source
Builder
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$369
Days On London
20
Cumulative Days On London
20
County Or Parish
San Joaquin
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Directions
Union
Room Type
All Bedrooms Down
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage
Main Level Bedrooms
1
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
1
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Dining Room
Pool Features
In Ground, Private, Heated
Pool Private Y/N
Yes
Water Source
None
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Park Nearby
Lot Size Area
6200.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Park/Greenbelt
Common Interest
None
Parcel Number
21910029
Additional Parcels Y/N
No
Community Features
Dog Park, Street Lights, Sidewalks, Park
Senior Community Y/N
No
Association Y/N
No
High School District
Manteca Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
None
Tax Lot
128
Tax Tract Number
650
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 460750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 509250 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) >= 1066 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1566 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` = 1727548 OR `props-main`.`id` = 1725576 OR `props-main`.`id` = 1727212 OR `props-main`.`id` = 1706802 OR `props-main`.`id` = 1730626 OR `props-main`.`id` = 1723480 OR `props-main`.`id` = 1731859 OR `props-main`.`id` = 1709497 OR `props-main`.`id` = 1720984 OR `props-main`.`id` = 1727908 OR `props-main`.`id` = 1725924 OR `props-main`.`id` = 1728759 OR `props-main`.`id` = 1736608 OR `props-main`.`id` = 1731935 OR `props-main`.`id` = 1730034 OR `props-main`.`id` = 1728060 OR `props-main`.`id` = 1729243 OR `props-main`.`id` = 1728059 OR `props-main`.`id` = 1724869 OR `props-main`.`id` = 1737119 OR `props-main`.`id` = 1736195 OR `props-main`.`id` = 1721458 OR `props-main`.`id` = 1728058 OR `props-main`.`id` = 1724868 OR `props-main`.`id` = 1728057 OR `props-main`.`id` = 1724870 OR `props-main`.`id` = 1728051 OR `props-main`.`id` = 1728049 OR `props-main`.`id` = 1726628 OR `props-main`.`id` = 1728544 OR `props-main`.`id` = 1719209 OR `props-main`.`id` = 1726764 OR `props-main`.`id` = 1726269 OR `props-main`.`id` = 1735919 OR `props-main`.`id` = 1734878 OR `props-main`.`id` = 1727641 OR `props-main`.`id` = 1734377 OR `props-main`.`id` = 1719271 OR `props-main`.`id` = 1728074 OR `props-main`.`id` = 1728578 OR `props-main`.`id` = 1736743 OR `props-main`.`id` = 1724763 OR `props-main`.`id` = 1723093 OR `props-main`.`id` = 1716386 OR `props-main`.`id` = 1735907 OR `props-main`.`id` = 1728774 OR `props-main`.`id` = 1700923 OR `props-main`.`id` = 1726455 OR `props-main`.`id` = 1717627 OR `props-main`.`id` = 1732655 OR `props-main`.`id` = 1730978 OR `props-main`.`id` = 1718046 OR `props-main`.`id` = 1737202 OR `props-main`.`id` = 1726911 OR `props-main`.`id` = 1732047 OR `props-main`.`id` = 1732926 OR `props-main`.`id` = 1730581 OR `props-main`.`id` = 1733144 OR `props-main`.`id` = 1731090 OR `props-main`.`id` = 1722499 OR `props-main`.`id` = 1730597 OR `props-main`.`id` = 1701860 OR `props-main`.`id` = 1726255 OR `props-main`.`id` = 1725848 OR `props-main`.`id` = 1729500 OR `props-main`.`id` = 1723550 OR `props-main`.`id` = 1728910 OR `props-main`.`id` = 1728871 OR `props-main`.`id` = 1732668 OR `props-main`.`id` = 1736830 OR `props-main`.`id` = 1722518 OR `props-main`.`id` = 1719616 OR `props-main`.`id` = 1714587 OR `props-main`.`id` = 1712798 OR `props-main`.`id` = 1724712 OR `props-main`.`id` = 1701938 OR `props-main`.`id` = 1727414 OR `props-main`.`id` = 1727413 OR `props-main`.`id` = 1723791 OR `props-main`.`id` = 1726065 OR `props-main`.`id` = 1723085 OR `props-main`.`id` = 1714501 OR `props-main`.`id` = 1723277 OR `props-main`.`id` = 1725270 OR `props-main`.`id` = 1719152 OR `props-main`.`id` = 1720665 OR `props-main`.`id` = 1714333 OR `props-main`.`id` = 1616278 OR `props-main`.`id` = 1714330 OR `props-main`.`id` = 1614564 OR `props-main`.`id` = 1721787 OR `props-main`.`id` = 1714236 OR `props-main`.`id` = 1737421 OR `props-main`.`id` = 1713456 OR `props-main`.`id` = 1731002 OR `props-main`.`id` = 1725709 OR `props-main`.`id` = 1736586 OR `props-main`.`id` = 1725868 OR `props-main`.`id` = 1716936 OR `props-main`.`id` = 1736996 OR `props-main`.`id` = 1713252 OR `props-main`.`id` = 1737801 OR `props-main`.`id` = 1706854 OR `props-main`.`id` = 1728192 OR `props-main`.`id` = 1737098 OR `props-main`.`id` = 1727275 OR `props-main`.`id` = 1715968 OR `props-main`.`id` = 1709827 OR `props-main`.`id` = 1722284 OR `props-main`.`id` = 1735304 OR `props-main`.`id` = 1727754 OR `props-main`.`id` = 1734539 OR `props-main`.`id` = 1721664 OR `props-main`.`id` = 1729196 OR `props-main`.`id` = 1737832 OR `props-main`.`id` = 1734024 OR `props-main`.`id` = 1711224 OR `props-main`.`id` = 1728432 OR `props-main`.`id` = 1728623 OR `props-main`.`id` = 1708320 OR `props-main`.`id` = 1737010 OR `props-main`.`id` = 1721079 OR `props-main`.`id` = 1723886 OR `props-main`.`id` = 1725532 OR `props-main`.`id` = 1736565 OR `props-main`.`id` = 1721119 OR `props-main`.`id` = 1732653 OR `props-main`.`id` = 1728125 OR `props-main`.`id` = 1728314 OR `props-main`.`id` = 1603454 OR `props-main`.`id` = 1737863 OR `props-main`.`id` = 1727635 OR `props-main`.`id` = 1726003 OR `props-main`.`id` = 1726229 OR `props-main`.`id` = 1722526 OR `props-main`.`id` = 1736056 OR `props-main`.`id` = 1720343 OR `props-main`.`id` = 1716687 OR `props-main`.`id` = 1721579 OR `props-main`.`id` = 1714488 OR `props-main`.`id` = 1713767 OR `props-main`.`id` = 1713166 OR `props-main`.`id` = 1717099 OR `props-main`.`id` = 1719133 OR `props-main`.`id` = 1722028 OR `props-main`.`id` = 1726678 OR `props-main`.`id` = 1715644 OR `props-main`.`id` = 1732659 OR `props-main`.`id` = 1700111 OR `props-main`.`id` = 1727115 OR `props-main`.`id` = 1727032)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26113997' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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
$509,000
3
3
1,341
0.07
1494 Hearthsong Dr
Manteca, CA 95337
$479,000
3
2
1,354
0.15
674 Privet Place
Manteca, CA 95336
$475,000
3
2
1,335
0.14
1048 Aspen Dr
Manteca, CA 95336
$474,900
3
3
1,366
0.16
1037 Tenaya Ct
Manteca, CA 95337
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.
