From 120 take Union Road South. First left on West Atherton Road. First right on Pagola Avenue. First right on Collins Street. Second right on Bermuda Lane. House on right. Cross Street: Collins Street
Architectural Style
Ranch
Room Type
Walk-In Closet
Cooling
Central Air
Roof
Tile
Foundation Details
Slab
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Room Kitchen Features
Granite Counters
Eating Area
Breakfast Counter / Bar
Appliances Y/N
Yes
Appliances
Gas Cooktop, Refrigerator, Vented Exhaust Fan, Electric Oven, Dishwasher
Flooring
Wood
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Level
Lot Size Area
5878.0000
Lot Size Units
Square Feet
View Y/N
No
Fencing
Wood
Parcel Number
22439052
Zoning
R1
Association Y/N
No
High School District
Manteca Unified
Elementary School
Other
High School
Sierra
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 644936 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 712824 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1690 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2190 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` = 1777161 OR `props-main`.`id` = 1776877 OR `props-main`.`id` = 1741140 OR `props-main`.`id` = 1783913 OR `props-main`.`id` = 1727613 OR `props-main`.`id` = 1775595 OR `props-main`.`id` = 1748945 OR `props-main`.`id` = 1786082 OR `props-main`.`id` = 1775599 OR `props-main`.`id` = 1766177 OR `props-main`.`id` = 1760973 OR `props-main`.`id` = 1786083 OR `props-main`.`id` = 1771600 OR `props-main`.`id` = 1788942 OR `props-main`.`id` = 1789095 OR `props-main`.`id` = 1788941 OR `props-main`.`id` = 1789112 OR `props-main`.`id` = 1766238 OR `props-main`.`id` = 1766242 OR `props-main`.`id` = 1783971 OR `props-main`.`id` = 1776480 OR `props-main`.`id` = 1766159 OR `props-main`.`id` = 1779253 OR `props-main`.`id` = 1789333 OR `props-main`.`id` = 1751631 OR `props-main`.`id` = 1779342 OR `props-main`.`id` = 1790020 OR `props-main`.`id` = 1767071 OR `props-main`.`id` = 1774117 OR `props-main`.`id` = 1727212 OR `props-main`.`id` = 1757058 OR `props-main`.`id` = 1788163 OR `props-main`.`id` = 1770629 OR `props-main`.`id` = 1737907 OR `props-main`.`id` = 1774279 OR `props-main`.`id` = 1778743 OR `props-main`.`id` = 1763565 OR `props-main`.`id` = 1781443 OR `props-main`.`id` = 1725924 OR `props-main`.`id` = 1770847 OR `props-main`.`id` = 1770571 OR `props-main`.`id` = 1792688 OR `props-main`.`id` = 1756552 OR `props-main`.`id` = 1739110 OR `props-main`.`id` = 1787914 OR `props-main`.`id` = 1779426 OR `props-main`.`id` = 1761476 OR `props-main`.`id` = 1786025 OR `props-main`.`id` = 1783470 OR `props-main`.`id` = 1791312 OR `props-main`.`id` = 1785029 OR `props-main`.`id` = 1779960 OR `props-main`.`id` = 1772162 OR `props-main`.`id` = 1774145 OR `props-main`.`id` = 1754866 OR `props-main`.`id` = 1776747 OR `props-main`.`id` = 1786924 OR `props-main`.`id` = 1786781 OR `props-main`.`id` = 1786780 OR `props-main`.`id` = 1786848 OR `props-main`.`id` = 1785188 OR `props-main`.`id` = 1736195 OR `props-main`.`id` = 1721458 OR `props-main`.`id` = 1786847 OR `props-main`.`id` = 1775336 OR `props-main`.`id` = 1786846 OR `props-main`.`id` = 1786845 OR `props-main`.`id` = 1786844 OR `props-main`.`id` = 1786023 OR `props-main`.`id` = 1761454 OR `props-main`.`id` = 1761506 OR `props-main`.`id` = 1747607 OR `props-main`.`id` = 1751262 OR `props-main`.`id` = 1791773 OR `props-main`.`id` = 1791314 OR `props-main`.`id` = 1793323 OR `props-main`.`id` = 1781957 OR `props-main`.`id` = 1782427 OR `props-main`.`id` = 1776789 OR `props-main`.`id` = 1761710 OR `props-main`.`id` = 1784259 OR `props-main`.`id` = 1748462 OR `props-main`.`id` = 1791896 OR `props-main`.`id` = 1754500 OR `props-main`.`id` = 1734377 OR `props-main`.`id` = 1786021 OR `props-main`.`id` = 1789708 OR `props-main`.`id` = 1776374 OR `props-main`.`id` = 1765461 OR `props-main`.`id` = 1775692 OR `props-main`.`id` = 1774389 OR `props-main`.`id` = 1761952 OR `props-main`.`id` = 1788872 OR `props-main`.`id` = 1788889 OR `props-main`.`id` = 1716386 OR `props-main`.`id` = 1790186 OR `props-main`.`id` = 1784095 OR `props-main`.`id` = 1740556 OR `props-main`.`id` = 1746659 OR `props-main`.`id` = 1753831 OR `props-main`.`id` = 1754460 OR `props-main`.`id` = 1784916 OR `props-main`.`id` = 1789306 OR `props-main`.`id` = 1776690 OR `props-main`.`id` = 1780141 OR `props-main`.`id` = 1770559 OR `props-main`.`id` = 1786745 OR `props-main`.`id` = 1750954 OR `props-main`.`id` = 1790187 OR `props-main`.`id` = 1778509 OR `props-main`.`id` = 1750636 OR `props-main`.`id` = 1768942 OR `props-main`.`id` = 1786614 OR `props-main`.`id` = 1785058 OR `props-main`.`id` = 1782832 OR `props-main`.`id` = 1779982 OR `props-main`.`id` = 1786795 OR `props-main`.`id` = 1765270 OR `props-main`.`id` = 1779425 OR `props-main`.`id` = 1744370 OR `props-main`.`id` = 1764747 OR `props-main`.`id` = 1764147 OR `props-main`.`id` = 1771597 OR `props-main`.`id` = 1784012 OR `props-main`.`id` = 1787824 OR `props-main`.`id` = 1786575 OR `props-main`.`id` = 1749107 OR `props-main`.`id` = 1791982 OR `props-main`.`id` = 1771675 OR `props-main`.`id` = 1780567 OR `props-main`.`id` = 1756332 OR `props-main`.`id` = 1788074 OR `props-main`.`id` = 1790888 OR `props-main`.`id` = 1779980 OR `props-main`.`id` = 1760215 OR `props-main`.`id` = 1753630 OR `props-main`.`id` = 1777751 OR `props-main`.`id` = 1764052)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82063518' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-19' 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();
0
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.
