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` = 1701490 OR `props-main`.`id` = 1712155 OR `props-main`.`id` = 1701495 OR `props-main`.`id` = 1697546 OR `props-main`.`id` = 1697547 OR `props-main`.`id` = 1697657 OR `props-main`.`id` = 1704864 OR `props-main`.`id` = 1695310 OR `props-main`.`id` = 1690716 OR `props-main`.`id` = 1705710 OR `props-main`.`id` = 1706955 OR `props-main`.`id` = 1706090 OR `props-main`.`id` = 1689813 OR `props-main`.`id` = 1711310 OR `props-main`.`id` = 1697614 OR `props-main`.`id` = 1704413 OR `props-main`.`id` = 1706802 OR `props-main`.`id` = 1709937 OR `props-main`.`id` = 1711857 OR `props-main`.`id` = 1709497 OR `props-main`.`id` = 1702154 OR `props-main`.`id` = 1711088 OR `props-main`.`id` = 1710228 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` = 1701243 OR `props-main`.`id` = 1688058 OR `props-main`.`id` = 1690211 OR `props-main`.`id` = 1709928 OR `props-main`.`id` = 1684674 OR `props-main`.`id` = 1655083 OR `props-main`.`id` = 1711727 OR `props-main`.`id` = 1697356 OR `props-main`.`id` = 1701743 OR `props-main`.`id` = 1702272 OR `props-main`.`id` = 1709861 OR `props-main`.`id` = 1689349 OR `props-main`.`id` = 1708099 OR `props-main`.`id` = 1712333 OR `props-main`.`id` = 1707065 OR `props-main`.`id` = 1712190 OR `props-main`.`id` = 1674365 OR `props-main`.`id` = 1706662 OR `props-main`.`id` = 1700923 OR `props-main`.`id` = 1705573 OR `props-main`.`id` = 1712696 OR `props-main`.`id` = 1709988 OR `props-main`.`id` = 1712386 OR `props-main`.`id` = 1711776 OR `props-main`.`id` = 1691611 OR `props-main`.`id` = 1707220 OR `props-main`.`id` = 1712008 OR `props-main`.`id` = 1701860 OR `props-main`.`id` = 1711060 OR `props-main`.`id` = 1710031 OR `props-main`.`id` = 1705831 OR `props-main`.`id` = 1689348 OR `props-main`.`id` = 1688282 OR `props-main`.`id` = 1712119 OR `props-main`.`id` = 1701938 OR `props-main`.`id` = 1712036 OR `props-main`.`id` = 1679946 OR `props-main`.`id` = 1712192 OR `props-main`.`id` = 1711806 OR `props-main`.`id` = 1712272 OR `props-main`.`id` = 1711276 OR `props-main`.`id` = 1694823 OR `props-main`.`id` = 1709227 OR `props-main`.`id` = 1709752 OR `props-main`.`id` = 1704587 OR `props-main`.`id` = 1697654 OR `props-main`.`id` = 1705039 OR `props-main`.`id` = 1706854 OR `props-main`.`id` = 1712502 OR `props-main`.`id` = 1709827 OR `props-main`.`id` = 1667438 OR `props-main`.`id` = 1706824 OR `props-main`.`id` = 1707066 OR `props-main`.`id` = 1711753 OR `props-main`.`id` = 1706714 OR `props-main`.`id` = 1706808 OR `props-main`.`id` = 1712407 OR `props-main`.`id` = 1707903 OR `props-main`.`id` = 1603454 OR `props-main`.`id` = 1707865 OR `props-main`.`id` = 1689772)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226022881' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-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();
2
Similar Properties
$625,000
4
2
1,647
0.13
277 Fragrance St
Manteca, CA 95337
$593,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.
