Welcome to 15940 Warfield Rd! This home is centrally located in the city of Lathrop near plenty of shopping, schools, freeway access and a short convenient drive to the Bay Area. This home has been well maintained and cared for, showing true pride of ownership in its condition and all of its updates including flooring, counters, lighting, fixtures and much more. Separate living and family room along with a formal dining room and spacious bedrooms. Make your appointment to view this one today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1972
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$312
Price Per Acre
$3,846,147
Days On London
10
Cumulative Days On London
10
County
San Joaquin
REO / Bank Owned
No
Cross Street Address
Orlando Ln
Directions
From Louise Ave - North on Bizzibe St, East on Orlando Ln, North on Warfield Rd, house is on the right.
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven
Dining Room Features
Formal
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Extra Rooms
Family Room
Flooring
Laminate, Tile
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Owned with Balance
APN
196 290 440 000
School District
Manteca Unified
School Type 1
High School
School Name 1
Manteca High
School Type 2
Junior High School
School Name 2
Lincoln
School Type 3
Grade School
School Name 3
Lincoln
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 508249.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 561748.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1463 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1963 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` = 1616278 OR `props-main`.`id` = 1710564 OR `props-main`.`id` = 1614564 OR `props-main`.`id` = 1710466 OR `props-main`.`id` = 1701207 OR `props-main`.`id` = 1689362 OR `props-main`.`id` = 1685915 OR `props-main`.`id` = 1709847 OR `props-main`.`id` = 1706011 OR `props-main`.`id` = 1703859 OR `props-main`.`id` = 1707855 OR `props-main`.`id` = 1695914 OR `props-main`.`id` = 1699031 OR `props-main`.`id` = 1711224 OR `props-main`.`id` = 1708320 OR `props-main`.`id` = 1708211 OR `props-main`.`id` = 1707198 OR `props-main`.`id` = 1710391)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643638' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-25' 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
Courtesy of Miguel Gonzalez, Park Place Real Estate - [email protected] Last modified 4 days ago Fresno MLS last checked for updates 24 minutes ago
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.
