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/crmls/ML82037690/1490-Spanish-Oak-Ave/Manteca/https://www.londonproperties.com/images/props/crmls/full/ML82037690.jpgLondon Properties Manteca Real Estate | 1490 Spanish Oak Ave
Expansive 6 bedroom/ 4 bath Ashford Floorplan in the Master Planned Community of Oakwood Trails on a premium corner lot! You'll love preparing a meal in this large open kitchen flowing into the gathering room and cafe dining area. In addition to the large and open living room, you'll also find a den area that could serve as an office or a formal dining room. Upstairs is an open and spacious 13' x 11' Family Room area. All six bedrooms are generously sized and two of the bedrooms have walk in closets: the Primary Suite and the upstairs-corner bedroom. A large upstairs laundry room, generously sized pantry and 3-car tandem garage all provide loads of storage space in this 3732 SF home. This is a great value! New homes of this model are starting at $891,000 with a completion date of July. A great opportunity and timing!
Property Sub Type
Single Family Residence
Year Built
2024
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Price Per Square Foot
$228
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: Starburst Street
Architectural Style
Craftsman
Room Type
Walk-In Closet, Laundry, Office
Heating
Central
Cooling
Central Air
Roof
Concrete, Tile
Foundation Details
Slab
Bathrooms Full
4
Bathrooms Full And Three Quarter
4
Appliances Y/N
Yes
Appliances
Microwave, Refrigerator, Electric Oven, Dishwasher, Electric Cooktop
Common Walls
No Common Walls
Fireplace Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Size Area
7368.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
26827029
Zoning
res
Association Y/N
No
High School District
Manteca Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 807500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 892500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3482 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3982 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` = 1722104 OR `props-main`.`id` = 1714116 OR `props-main`.`id` = 1714032 OR `props-main`.`id` = 1714117 OR `props-main`.`id` = 1697618 OR `props-main`.`id` = 1722188 OR `props-main`.`id` = 1721043 OR `props-main`.`id` = 1693634 OR `props-main`.`id` = 1721228 OR `props-main`.`id` = 1696024 OR `props-main`.`id` = 1723618 OR `props-main`.`id` = 1723793 OR `props-main`.`id` = 1697646 OR `props-main`.`id` = 1704819 OR `props-main`.`id` = 1709829 OR `props-main`.`id` = 1720875 OR `props-main`.`id` = 1721458 OR `props-main`.`id` = 1705028 OR `props-main`.`id` = 1655083 OR `props-main`.`id` = 1714207 OR `props-main`.`id` = 1717853 OR `props-main`.`id` = 1716577 OR `props-main`.`id` = 1718956 OR `props-main`.`id` = 1719148 OR `props-main`.`id` = 1719379 OR `props-main`.`id` = 1720382 OR `props-main`.`id` = 1719583 OR `props-main`.`id` = 1721529 OR `props-main`.`id` = 1715646 OR `props-main`.`id` = 1706949 OR `props-main`.`id` = 1717712 OR `props-main`.`id` = 1715002 OR `props-main`.`id` = 1715003 OR `props-main`.`id` = 1690194 OR `props-main`.`id` = 1690205 OR `props-main`.`id` = 1723093 OR `props-main`.`id` = 1716386 OR `props-main`.`id` = 1723475 OR `props-main`.`id` = 1723892 OR `props-main`.`id` = 1701959 OR `props-main`.`id` = 1721107 OR `props-main`.`id` = 1722516 OR `props-main`.`id` = 1720594 OR `props-main`.`id` = 1708513 OR `props-main`.`id` = 1706662 OR `props-main`.`id` = 1718046 OR `props-main`.`id` = 1709988 OR `props-main`.`id` = 1714256 OR `props-main`.`id` = 1701938 OR `props-main`.`id` = 1719152 OR `props-main`.`id` = 1720665 OR `props-main`.`id` = 1714333 OR `props-main`.`id` = 1616278 OR `props-main`.`id` = 1714330 OR `props-main`.`id` = 1614564 OR `props-main`.`id` = 1714236 OR `props-main`.`id` = 1713456 OR `props-main`.`id` = 1709847 OR `props-main`.`id` = 1720991)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82037690' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-26' 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.
