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/239405/762-W-Front-St/Farmersville/https://www.londonproperties.com/images/props/tulare/full/239405.jpgLondon Properties Farmersville Real Estate | 762 W Front St
Great first-time buyer home walking distance to the Jr High School large lot 4-bedroom 1-bathroom
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1980
Year Built Source
Assessor
Days On London
32
Cumulative Days On London
32
County
Tulare
New Construction
No
Stories
1
Directions to Property
head east on main street to east on mineral king to head south on lovers lane to head east on caldwell avenue to farmersville city head north on farmersville Blvd. to head west on front street to property.
Roof
Composition
Heating
Central
Cooling
Central Air, Evaporative Cooling
Bathrooms Total (Integer)
1
Full Baths
1.0
Full Baths
1
Fireplace Y/N
No
Spa
No
Utilities
Electricity Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
1.0
APN
128 130 040 000
Lot Dimensions
Irregular
Additional Parcels Y/N
No
Waterfront Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 274550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 303450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 790 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1290 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` = 1710020 OR `props-main`.`id` = 1710019 OR `props-main`.`id` = 1710024 OR `props-main`.`id` = 1698529 OR `props-main`.`id` = 1696070 OR `props-main`.`id` = 1695457 OR `props-main`.`id` = 1687891 OR `props-main`.`id` = 1703893 OR `props-main`.`id` = 1694645 OR `props-main`.`id` = 1698614 OR `props-main`.`id` = 1705896 OR `props-main`.`id` = 1701846 OR `props-main`.`id` = 1711147 OR `props-main`.`id` = 1711238 OR `props-main`.`id` = 1685761 OR `props-main`.`id` = 1685745 OR `props-main`.`id` = 1658088 OR `props-main`.`id` = 1704215 OR `props-main`.`id` = 1648099 OR `props-main`.`id` = 1706898 OR `props-main`.`id` = 1648453)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239405' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 Richard Bueno, KW Ascend
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.
