Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/metrolist/226022881/1142-Mammoth-Dr/Manteca/https://www.londonproperties.com/images/props/metrolist/full/226022881.jpgLondon Properties Manteca Real Estate | 1142 Mammoth Dr
Beautifully crafted by Raymus homes, this stunning home has been completely updated and is truly move-in ready. Fresh interior paint and brand-new flooring create a bright, modern feel throughout. Step outside to your own backyard oasis featuring a sparkling salt water pool and spacious decking perfect for relaxing or entertaining. The property also offers a two-car garage and convenient RV access. Inside, you'll find four generously sized bedrooms and a separate family room with a cozy fireplace along with a inside laundry room, This home provides plenty of space for both everyday living and special gatherings. Ideally located close to shopping, schools, and everyday amenities, this home truly has it all.
Built-In, On Lot, Fenced, Salt Water, Solar Heat, See Remarks
Spa
No
ADU/2nd Unit
No
Utilities
Cable Available, Internet Available, See Remarks
Electric
220 Volts,See Remarks
Irrigation
Public District, Meter on Site
Water Source
Public, Meter on Site
Sewer
Public Sewer
Parking Features
Attached, RV Access, Garage Door Opener, Garage Facing Front
Garage Spaces
2.00
Open Parking Spaces
3.00
Lot Features
Auto Sprinkler Front, Manual Sprinkler Rear, Curb(s)/Gutter(s), Shape Regular, Street Lights, Landscape Back, Landscape Front, See Remarks
APN
219 510 06
Lot Size Dimensions
64X109X84X125
Land Use
Residential
Topography
Level
View Description
Other
Driveway/Sidewalks
Paved Driveway, Sidewalk/Curb/Gutter
Fencing
Back Yard, See Remarks
Horse Property
No
Road Responsibility
Public Maintained Road
Zoning Description
Res
Subdivision
Vintage Estates
Subdivision Developer
Raymus
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
San Joaquin
Elementary School District
Manteca Unified
Middle or Junior School District
Manteca Unified
Senior High School District
Manteca Unified
Distance To Shopping
4+ Blocks
Distance to Public Transportation
4+ Blocks
Census Tract
1868.00
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 579452.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 640447.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1638 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2138 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` = 1712983 OR `props-main`.`id` = 1701490 OR `props-main`.`id` = 1712977 OR `props-main`.`id` = 1714623 OR `props-main`.`id` = 1716836 OR `props-main`.`id` = 1716838 OR `props-main`.`id` = 1701495 OR `props-main`.`id` = 1697547 OR `props-main`.`id` = 1697657 OR `props-main`.`id` = 1716545 OR `props-main`.`id` = 1704864 OR `props-main`.`id` = 1695310 OR `props-main`.`id` = 1716897 OR `props-main`.`id` = 1713717 OR `props-main`.`id` = 1690716 OR `props-main`.`id` = 1705710 OR `props-main`.`id` = 1706955 OR `props-main`.`id` = 1706090 OR `props-main`.`id` = 1713677 OR `props-main`.`id` = 1715830 OR `props-main`.`id` = 1715679 OR `props-main`.`id` = 1715658 OR `props-main`.`id` = 1711310 OR `props-main`.`id` = 1697614 OR `props-main`.`id` = 1717029 OR `props-main`.`id` = 1717017 OR `props-main`.`id` = 1706802 OR `props-main`.`id` = 1709497 OR `props-main`.`id` = 1702154 OR `props-main`.`id` = 1711088 OR `props-main`.`id` = 1710228 OR `props-main`.`id` = 1713286 OR `props-main`.`id` = 1713639 OR `props-main`.`id` = 1701362 OR `props-main`.`id` = 1701363 OR `props-main`.`id` = 1701309 OR `props-main`.`id` = 1701308 OR `props-main`.`id` = 1701310 OR `props-main`.`id` = 1701244 OR `props-main`.`id` = 1712846 OR `props-main`.`id` = 1701243 OR `props-main`.`id` = 1690211 OR `props-main`.`id` = 1709928 OR `props-main`.`id` = 1684674 OR `props-main`.`id` = 1655083 OR `props-main`.`id` = 1714207 OR `props-main`.`id` = 1716372 OR `props-main`.`id` = 1716577 OR `props-main`.`id` = 1701743 OR `props-main`.`id` = 1689349 OR `props-main`.`id` = 1708099 OR `props-main`.`id` = 1715775 OR `props-main`.`id` = 1713421 OR `props-main`.`id` = 1714660 OR `props-main`.`id` = 1674365 OR `props-main`.`id` = 1706662 OR `props-main`.`id` = 1700923 OR `props-main`.`id` = 1713032 OR `props-main`.`id` = 1712696 OR `props-main`.`id` = 1713650 OR `props-main`.`id` = 1717150 OR `props-main`.`id` = 1709988 OR `props-main`.`id` = 1714256 OR `props-main`.`id` = 1707220 OR `props-main`.`id` = 1714472 OR `props-main`.`id` = 1716132 OR `props-main`.`id` = 1701860 OR `props-main`.`id` = 1710031 OR `props-main`.`id` = 1715858 OR `props-main`.`id` = 1705831 OR `props-main`.`id` = 1689348 OR `props-main`.`id` = 1714587 OR `props-main`.`id` = 1712798 OR `props-main`.`id` = 1716517 OR `props-main`.`id` = 1701938 OR `props-main`.`id` = 1714501 OR `props-main`.`id` = 1679946 OR `props-main`.`id` = 1714662 OR `props-main`.`id` = 1714746 OR `props-main`.`id` = 1709227 OR `props-main`.`id` = 1713456 OR `props-main`.`id` = 1713774 OR `props-main`.`id` = 1714484 OR `props-main`.`id` = 1709752 OR `props-main`.`id` = 1716995 OR `props-main`.`id` = 1712998 OR `props-main`.`id` = 1716936 OR `props-main`.`id` = 1713252 OR `props-main`.`id` = 1697654 OR `props-main`.`id` = 1706854 OR `props-main`.`id` = 1717131 OR `props-main`.`id` = 1716343 OR `props-main`.`id` = 1715968 OR `props-main`.`id` = 1709827 OR `props-main`.`id` = 1667438 OR `props-main`.`id` = 1716272 OR `props-main`.`id` = 1706808 OR `props-main`.`id` = 1715488 OR `props-main`.`id` = 1707903 OR `props-main`.`id` = 1603454)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226022881' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-20' 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();
2
Similar Properties
$609,950
4
2
1,647
0.13
277 Fragrance St
Manteca, CA 95337
$598,990
4
2
1,865
0.15
2716 Blairsville Ln
Manteca, CA 95337
Courtesy of Jessie Barrett, HomeSmart PV and Associates IDX provided by Reliance Marketing
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.
