From Ca-216 E/Ivanhoe DR. Turn left Ave. 328, Turn right onto Rd 157, Turn right onto Fuchsia Ave.
Construction Materials
Stucco
Foundation Details
Raised
Roof
Shingle
Heating
Other
Cooling
Ceiling Fan(s)
Direction Faces
North
Bathrooms Total (Integer)
1
Full Baths
1.0
Full Baths
1
Appliances
None
Fireplace Y/N
No
Common Walls
No Common Walls
Spa
No
Utilities
Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Features
Concrete, RV Access/Parking
Garage
No
Attached Garage
No
APN
107 012 018 000
Lot Dimensions
rectangular
Horse Property
No
Additional Parcels Y/N
No
Road Surface Type
Paved
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 189050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 208950 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) >= 440 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 940 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` = 1696232 OR `props-main`.`id` = 1718350 OR `props-main`.`id` = 1656850 OR `props-main`.`id` = 1656554 OR `props-main`.`id` = 1719059 OR `props-main`.`id` = 1714046 OR `props-main`.`id` = 1714052 OR `props-main`.`id` = 1714060 OR `props-main`.`id` = 1715411 OR `props-main`.`id` = 1656163)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240733' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-31' 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 Felipe Blanco Araujo, Legacy Real Estate Inc
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.
