Listing Agent: Niem Nguyen, Tuscany Real Estate Services, Inc.
Welcome to 1901 Lauriston Lane!! Spacious, Light, Bright and Airy! 4 Bedrooms And 2.5 Bathrooms With 2226SF Of Living Space! Located is Highly Sought After Chadwick Square Sub-Division! Conveniently located, Walking Distance To Schools, Parks And Shopping! Kitchen Features Island, Stainless Steel Appliances And Granite Counter Tops, modern bathrooms remodeled, vinyl flooring! Check out Built-In Pool, 3 Car Garage And RV Access! Huge Lot With fruit Trees! It is hard to find both pool and RV parking in one lot.
Property Sub Type
Single Family Residence
Year Built
1997
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Price Per Square Foot
$310
Days On London
0
County Or Parish
San Joaquin
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: London Ave
Disclosures
Home Warranty
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Gas Dryer Hookup
Roof
Tile
Construction Materials
Concrete, Stucco
Foundation Details
Slab
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Eating Area
Breakfast Nook
Appliances Y/N
Yes
Room Bathroom Features
Double sinks in bath(s)
Flooring
Laminate
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Wood Burning
Water Source
Public
Sewer
Public Sewer
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Size Area
9207.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
20232007
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) >= 655405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 724395 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) >= 1976 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2476 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` = 1744370 OR `props-main`.`id` = 1724712 OR `props-main`.`id` = 1701938 OR `props-main`.`id` = 1757410 OR `props-main`.`id` = 1719152 OR `props-main`.`id` = 1720665 OR `props-main`.`id` = 1744423 OR `props-main`.`id` = 1725709 OR `props-main`.`id` = 1736586 OR `props-main`.`id` = 1756332 OR `props-main`.`id` = 1764792 OR `props-main`.`id` = 1760701 OR `props-main`.`id` = 1748987 OR `props-main`.`id` = 1749928 OR `props-main`.`id` = 1760215 OR `props-main`.`id` = 1756253 OR `props-main`.`id` = 1753630 OR `props-main`.`id` = 1764052 OR `props-main`.`id` = 1743458 OR `props-main`.`id` = 1743459 OR `props-main`.`id` = 1756252 OR `props-main`.`id` = 1764214 OR `props-main`.`id` = 1742195 OR `props-main`.`id` = 1763564 OR `props-main`.`id` = 1727754 OR `props-main`.`id` = 1763847 OR `props-main`.`id` = 1763538 OR `props-main`.`id` = 1757645 OR `props-main`.`id` = 1762637 OR `props-main`.`id` = 1741199 OR `props-main`.`id` = 1738176 OR `props-main`.`id` = 1760700 OR `props-main`.`id` = 1728623 OR `props-main`.`id` = 1748460 OR `props-main`.`id` = 1764787 OR `props-main`.`id` = 1763812 OR `props-main`.`id` = 1758289 OR `props-main`.`id` = 1765384 OR `props-main`.`id` = 1749836 OR `props-main`.`id` = 1749625 OR `props-main`.`id` = 1761731 OR `props-main`.`id` = 1742480 OR `props-main`.`id` = 1732653 OR `props-main`.`id` = 1752180 OR `props-main`.`id` = 1728314 OR `props-main`.`id` = 1746053 OR `props-main`.`id` = 1603454 OR `props-main`.`id` = 1737863 OR `props-main`.`id` = 1763662 OR `props-main`.`id` = 1752568 OR `props-main`.`id` = 1758956 OR `props-main`.`id` = 1751574 OR `props-main`.`id` = 1757383 OR `props-main`.`id` = 1757594 OR `props-main`.`id` = 1754688 OR `props-main`.`id` = 1748746 OR `props-main`.`id` = 1745191 OR `props-main`.`id` = 1757369 OR `props-main`.`id` = 1713767 OR `props-main`.`id` = 1757220 OR `props-main`.`id` = 1717099 OR `props-main`.`id` = 1755884 OR `props-main`.`id` = 1747993 OR `props-main`.`id` = 1700111 OR `props-main`.`id` = 1748784 OR `props-main`.`id` = 1761042 OR `props-main`.`id` = 1756417 OR `props-main`.`id` = 1760916 OR `props-main`.`id` = 1745646 OR `props-main`.`id` = 1725438 OR `props-main`.`id` = 1752579 OR `props-main`.`id` = 1721528 OR `props-main`.`id` = 1765406 OR `props-main`.`id` = 1762293 OR `props-main`.`id` = 1719106 OR `props-main`.`id` = 1730608 OR `props-main`.`id` = 1759477 OR `props-main`.`id` = 1750356 OR `props-main`.`id` = 1718324 OR `props-main`.`id` = 1721821 OR `props-main`.`id` = 1749653 OR `props-main`.`id` = 1737016 OR `props-main`.`id` = 1761742 OR `props-main`.`id` = 1761729 OR `props-main`.`id` = 1727245 OR `props-main`.`id` = 1727527 OR `props-main`.`id` = 1759037 OR `props-main`.`id` = 1746489 OR `props-main`.`id` = 1726539 OR `props-main`.`id` = 1731091 OR `props-main`.`id` = 1760185 OR `props-main`.`id` = 1754376 OR `props-main`.`id` = 1752128 OR `props-main`.`id` = 1764520 OR `props-main`.`id` = 1761894 OR `props-main`.`id` = 1762302 OR `props-main`.`id` = 1757018 OR `props-main`.`id` = 1753881 OR `props-main`.`id` = 1730697 OR `props-main`.`id` = 1746775 OR `props-main`.`id` = 1755126 OR `props-main`.`id` = 1755146 OR `props-main`.`id` = 1758171 OR `props-main`.`id` = 1685406 OR `props-main`.`id` = 1722330 OR `props-main`.`id` = 1749517 OR `props-main`.`id` = 1728118 OR `props-main`.`id` = 1753847 OR `props-main`.`id` = 1750015 OR `props-main`.`id` = 1739523)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82058539' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-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();
4
Similar Properties
$714,990
4
3
1,985
0.15
717 Villa Ticino Dr
Manteca, CA 95337
$689,990
4
3
2,277
0.14
1850 Bedrock St
Manteca, CA 95336
$685,990
4
3
2,277
0.14
1826 Bedrock St
Manteca, CA 95336
$668,990
5
4
2,378
0.15
728 Villa Ticino Dr
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.
