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/240260/1431-Hillcrest-Dr/Lindsay/https://www.londonproperties.com/images/props/tulare/full/240260.jpgLondon Properties Lindsay Real Estate | 1431 Hillcrest Dr
Excellent location on Todds Hill. Property in need of TLC great potential on this large home on over an acre of land with beautiful views of the Valley and Hills. Inground pool, a porch that is the length of the home, large rooms and lots of built in cabinets, kitchen with Corian kitchen countertops, hard wood floors in kitchen, laundry room and pantry. Two car attached finished garage with garage door opener. Tile roof, two ac units and lots more, this is one you have to see for yourself to see the potential. All measurements are approximate, buyers to verify all information.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1969
Year Built Source
Public Records
Days On London
0
Cumulative Days On London
0
County
Tulare
Property Condition
Fixer
New Construction
No
Stories
2
Directions to Property
From intersection of Tulare Rd and Elmwood Ave, north on Elmwood to Hickory St, east on Hickory to Bellah, north on Bellah to E Fir St, east on fir to Hillcrest, north on Hillcrest to Property.
Construction Materials
Frame, Stucco
Foundation Details
Combination, Raised
Roof
Concrete, Tile
Heating
Central
Cooling
Ceiling Fan(s), Central Air, Multi Units
Laundry Features
Inside
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s)
Interior Features
Bookcases, Breakfast Bar, Ceiling Fan(s)
# of Main Level Bathrooms
2
Bathrooms Total (Integer)
3
Full Baths
2.25
Full Baths
1
Three Quarter Baths
1
Half Baths
1
Appliances
Disposal, Double Oven, Electric Range
Fireplace Y/N
Yes
Fireplace Features
Double Sided, Living Room
Flooring
Carpet, Vinyl, Wood
Private Pool
Yes
Pool Features
Gunite
Spa
No
Patio and Porch Features
Covered
Utilities
Electricity Connected, Water Connected
Water Source
Public
Sewer
Septic Tank
Parking Features
Attached, Asphalt, Concrete, Garage Door Opener
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
2.0
APN
202 060 005
Lot Dimensions
Irregular
Additional Parcels Y/N
No
View
Hills, Mountain(s), Valley
Road Surface Type
Asphalt
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2716 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3216 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` = 1698850 OR `props-main`.`id` = 1713927 OR `props-main`.`id` = 1715197 OR `props-main`.`id` = 1702921 OR `props-main`.`id` = 1704348 OR `props-main`.`id` = 1702918 OR `props-main`.`id` = 1702942 OR `props-main`.`id` = 1715337 OR `props-main`.`id` = 1704079 OR `props-main`.`id` = 1703228 OR `props-main`.`id` = 1705213 OR `props-main`.`id` = 1709767 OR `props-main`.`id` = 1698847 OR `props-main`.`id` = 1673178 OR `props-main`.`id` = 1713912 OR `props-main`.`id` = 1716146 OR `props-main`.`id` = 1713544 OR `props-main`.`id` = 1713883 OR `props-main`.`id` = 1715134 OR `props-main`.`id` = 1703020 OR `props-main`.`id` = 1705109 OR `props-main`.`id` = 1709717 OR `props-main`.`id` = 1709422 OR `props-main`.`id` = 1615630 OR `props-main`.`id` = 1716431 OR `props-main`.`id` = 1708038)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240260' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-16' 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 Raul Jara, Tienken Realty
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.
