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/tulare/240566/694-W-Clay-Ave/Earlimart/https://www.londonproperties.com/images/props/tulare/full/240566.jpgLondon Properties Earlimart Real Estate | 694 W Clay Ave
Charming entry level home located in the quiet small town of Earlimart. This cozy 2 bedroom, 1 bathroom home features thoughtful updates throughout, including new light fixtures, durable laminate flooring in high traffic areas, and comfortable carpet in both bedrooms. The kitchen comes equipped with a brand-new stainless steel stove, perfect for everyday cooking. Situated on a spacious fenced corner lot, the property offers plenty of outdoor space with extensive concrete in both the front and backyard ideal for low maintenance and entertaining. Enjoy relaxing or hosting under the large covered patio, with the convenience of a single car garage. This is a wonderful opportunity for first-time buyers or anyone looking for a well-maintained home with great potential don't miss out!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1991
Year Built Source
Public Records
Days On London
0
Cumulative Days On London
0
County
Tulare
New Construction
No
Stories
1
Directions to Property
From Front Rd. and Washington Ave., west on Washington Ave., south on Ash St. home is on the corner on W. Clay and Ash St.
Roof
Composition
Heating
Central
Cooling
Central Air
Bathrooms Total (Integer)
1
Full Baths
1.0
Full Baths
1
Fireplace Y/N
No
Spa
No
Utilities
Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
1.0
APN
315 200 014 000
Lot Dimensions
7485
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 255550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 282450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 614 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1114 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` = 1715318 OR `props-main`.`id` = 1714613 OR `props-main`.`id` = 1713895 OR `props-main`.`id` = 1715320 OR `props-main`.`id` = 1700129 OR `props-main`.`id` = 1714614 OR `props-main`.`id` = 1718016 OR `props-main`.`id` = 1715321 OR `props-main`.`id` = 1714615 OR `props-main`.`id` = 1714531 OR `props-main`.`id` = 1715284 OR `props-main`.`id` = 1715285 OR `props-main`.`id` = 1714526 OR `props-main`.`id` = 1715273 OR `props-main`.`id` = 1709602 OR `props-main`.`id` = 1696868)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240566' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-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 Rito Valero, Century 21 Jordan-Link & Company
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.
