Listing Agent: Olufemi Oyenuga, Intero Real Estate Services
Property Sub Type
Single Family Residence
Year Built
2006
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Price Per Square Foot
$131
Days On London
0
County Or Parish
San Joaquin
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Collins
Architectural Style
Mediterranean
Room Type
Walk-In Closet, Retreat
Heating
Forced Air
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage
Roof
Tile
Construction Materials
Stucco
Foundation Details
Slab
Property Condition
Fixer
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Eating Area
Dining Ell
Appliances Y/N
Yes
Room Bathroom Features
Double sinks in bath(s)
Accessibility Features
None
Flooring
Carpet
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Wood Burning
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Level
Lot Size Area
5212.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Fencing
Wood
Parcel Number
22436012
Zoning
R1
Association Y/N
No
High School District
Manteca Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 299250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 330750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2147 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2647 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` = 1773751 OR `props-main`.`id` = 1776877 OR `props-main`.`id` = 1741140 OR `props-main`.`id` = 1727613 OR `props-main`.`id` = 1775595 OR `props-main`.`id` = 1748945 OR `props-main`.`id` = 1775599 OR `props-main`.`id` = 1773768 OR `props-main`.`id` = 1766177 OR `props-main`.`id` = 1760973 OR `props-main`.`id` = 1771600 OR `props-main`.`id` = 1770063 OR `props-main`.`id` = 1766238 OR `props-main`.`id` = 1766242 OR `props-main`.`id` = 1766320 OR `props-main`.`id` = 1776480 OR `props-main`.`id` = 1766159 OR `props-main`.`id` = 1779253 OR `props-main`.`id` = 1751631 OR `props-main`.`id` = 1779342 OR `props-main`.`id` = 1763212 OR `props-main`.`id` = 1752637 OR `props-main`.`id` = 1767071 OR `props-main`.`id` = 1774117 OR `props-main`.`id` = 1725576 OR `props-main`.`id` = 1727212 OR `props-main`.`id` = 1757058 OR `props-main`.`id` = 1770629 OR `props-main`.`id` = 1737907 OR `props-main`.`id` = 1774279 OR `props-main`.`id` = 1744574 OR `props-main`.`id` = 1778743 OR `props-main`.`id` = 1773513 OR `props-main`.`id` = 1763565 OR `props-main`.`id` = 1781443 OR `props-main`.`id` = 1725924 OR `props-main`.`id` = 1779666 OR `props-main`.`id` = 1770571 OR `props-main`.`id` = 1756552 OR `props-main`.`id` = 1779426 OR `props-main`.`id` = 1761476 OR `props-main`.`id` = 1746793 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` = 1773636 OR `props-main`.`id` = 1773635 OR `props-main`.`id` = 1773691 OR `props-main`.`id` = 1775781 OR `props-main`.`id` = 1736195 OR `props-main`.`id` = 1721458 OR `props-main`.`id` = 1773690 OR `props-main`.`id` = 1775336 OR `props-main`.`id` = 1773689 OR `props-main`.`id` = 1770866 OR `props-main`.`id` = 1773688 OR `props-main`.`id` = 1773687 OR `props-main`.`id` = 1761454 OR `props-main`.`id` = 1771078 OR `props-main`.`id` = 1761506 OR `props-main`.`id` = 1747607 OR `props-main`.`id` = 1726764 OR `props-main`.`id` = 1751262 OR `props-main`.`id` = 1782742 OR `props-main`.`id` = 1781957 OR `props-main`.`id` = 1782427 OR `props-main`.`id` = 1776789 OR `props-main`.`id` = 1761710 OR `props-main`.`id` = 1754500 OR `props-main`.`id` = 1734377 OR `props-main`.`id` = 1759787 OR `props-main`.`id` = 1745899 OR `props-main`.`id` = 1757064 OR `props-main`.`id` = 1776374 OR `props-main`.`id` = 1765461 OR `props-main`.`id` = 1775692 OR `props-main`.`id` = 1774389 OR `props-main`.`id` = 1727988 OR `props-main`.`id` = 1761952 OR `props-main`.`id` = 1780762 OR `props-main`.`id` = 1716386 OR `props-main`.`id` = 1769909 OR `props-main`.`id` = 1740556 OR `props-main`.`id` = 1746659 OR `props-main`.`id` = 1753831 OR `props-main`.`id` = 1754460 OR `props-main`.`id` = 1726455 OR `props-main`.`id` = 1776690 OR `props-main`.`id` = 1780141 OR `props-main`.`id` = 1770559 OR `props-main`.`id` = 1773606 OR `props-main`.`id` = 1744619 OR `props-main`.`id` = 1750954 OR `props-main`.`id` = 1754765 OR `props-main`.`id` = 1778509 OR `props-main`.`id` = 1750636 OR `props-main`.`id` = 1768942 OR `props-main`.`id` = 1773505 OR `props-main`.`id` = 1779982 OR `props-main`.`id` = 1728910 OR `props-main`.`id` = 1773652 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` = 1724712 OR `props-main`.`id` = 1701938 OR `props-main`.`id` = 1773479 OR `props-main`.`id` = 1738347 OR `props-main`.`id` = 1745333 OR `props-main`.`id` = 1749085 OR `props-main`.`id` = 1749107 OR `props-main`.`id` = 1771675 OR `props-main`.`id` = 1780567 OR `props-main`.`id` = 1756332 OR `props-main`.`id` = 1778795 OR `props-main`.`id` = 1779980 OR `props-main`.`id` = 1760215 OR `props-main`.`id` = 1774252 OR `props-main`.`id` = 1753630 OR `props-main`.`id` = 1777751 OR `props-main`.`id` = 1764052 OR `props-main`.`id` = 1763847)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82062924' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-28' 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.
