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/fresno/640173/14334-E-Prospect-Pl/Lockeford/https://www.londonproperties.com/images/props/fresno/full/640173.jpgLondon Properties Lockeford Real Estate | 14334 E Prospect Pl
Nestled in the quaint and peaceful town of Lockeford, CA, this 3-bedroom, 1-bath home offers great bones and endless potential for those looking to make it their own. The spacious kitchen is the heart of the home, featuring abundant storage and an open flow to both the dining area and large living room. Just off the kitchen, you'll find a large pantry with barn door,enclosed laundry room with storage, and French doors that lead to the oversized covered patio and backyard. Here you will find a large shed, enclosed dog kennel, and plenty of yard space to play or create your dream retreat. Additional highlights include dual-pane windows and ceiling fans in every room for energy efficiency, as well as laminate flooring throughout the main living areas pairing nicely with cozy carpet in the bedrooms. The garage also offers a flexible space that could be converted into an extra bedroom, bathroom, or both. Conveniently located near local amenities and within the Lodi Unified School District, this home provides both community and comfort. Being sold AS-IS, this home lends the perfect opportunity to add your personal TLC to a home with so much potential.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1979
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$328
Price Per Acre
$2,591,606
Days On Market
103
Cumulative Days On Market
103
County
San Joaquin
REO / Bank Owned
No
Cross Street Address
Coquille
Directions
From CA-99 N, exit 255 for CA-88 E/Waterloo Rd toward Jackson. Right on CA-88 E/Waterloo Rd (signs for Jackson). Right on N Tully Rd. Left on E Parkdale Dr. Left on Coquille Dr. Right on E Prospect Pl. 3rd house on right.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, Electric Hook Up
Roofing
Composition
Foundation
Concrete
Detached Structures
Kennel, Shed
Kitchen
Gas Appliances, Disposal
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Flooring
Carpet, Laminate, Tile
Exterior
Wood
Pool
No
Pool
No
Patio Features
Covered, Uncovered
Yard
Fenced
Gas & Electric
Public Utilities
Sewer / Water
Public Water
Energy Efficiency
Dual Pane Windows
Solar
No
Garage Type
Attached
Garage Spaces
2
APN
019 280 047
School District
Lodi
School Type 1
High School
School Name 1
Lodi
School Type 2
Junior High School
School Name 2
Lodi
School Type 3
Grade School
School Name 3
Lockeford
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 369550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 408450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 936 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1436 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` = 1696552)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640173' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-06' 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 Laura Oliver, Century 21 Jordan-Link & Company - [email protected] Last modified 1 month ago Fresno MLS last checked for updates 10 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.
