Great opportunity to own a property where the possibilities are endless and location is prime, situated on the main thoroughfare running through Ivanhoe. Currently utilized as a dentist office in the front section of the main building (not pictured) and primary residence in the back and upstairs . The secondary buildings on this half acre plot of land were previously an auto repair shop and storage. C-2 zoning provides the freedom to embark on a variety of ventures. The residence is set up as an entertainer's dream with large rooms, a bar, indoor/outdoor pool and spa and second story balconies. The inviting courtyard is perfect for intimate parties and events and is replete with a variety of fruit trees: pear, plum, peach, nectarine, apricot, apple and avocado. With a little updating, this entire property would make a fantastic short-term rental, apartments or event venue.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1979
Year Built Source
Public Records
Days On Market
227
Cumulative Days On Market
227
County
Tulare
New Construction
No
Stories
2
Current Use
Warehouse, Medical/Dental, Residential
Directions to Property
From Road 160 (Ivanhoe Road 216) north, west on Ave 328. Property located on south side of street.
Roof
Spanish Tile
Heating
Central
Cooling
Central Air
Laundry Features
Laundry Room
Direction Faces
North
Other Structures
Outbuilding, Storage
Interior Features
Built-in Features, Balcony, Bar, Living Room Balcony, Pantry
# of Main Level Bathrooms
2
Bathrooms Total (Integer)
4
Full Baths
2.5
Three Quarter Baths
2
Half Baths
2
Fireplace Y/N
Yes
Fireplace Features
Gas, Recreation Room
Flooring
Combination
Exterior Features
Courtyard
Private Pool
Yes
Pool Features
Private, Gunite
Spa
Yes
Spa Features
Gunite
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, Garage Door Opener, Garage Faces Side
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
4.0
APN
107 131 001 000
Lot Features
Corner Lot, Fencing, Landscaped, Sprinklers In Front, Sprinklers In Rear
Lot Dimensions
120 x 22.38
Zoning Description
C-2
Retail, restaurants, personal services, offices, repair shops, parking, some residential.
Additional Parcels Y/N
No
Road Surface Type
Asphalt
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 635550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 702450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2436 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2936 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` = 1695063 OR `props-main`.`id` = 1697335 OR `props-main`.`id` = 1697331 OR `props-main`.`id` = 1697341 OR `props-main`.`id` = 1697337 OR `props-main`.`id` = 1671710 OR `props-main`.`id` = 1658443 OR `props-main`.`id` = 1661962 OR `props-main`.`id` = 1689083 OR `props-main`.`id` = 1689101 OR `props-main`.`id` = 1689089 OR `props-main`.`id` = 1689086 OR `props-main`.`id` = 1696232 OR `props-main`.`id` = 1656850 OR `props-main`.`id` = 1656554 OR `props-main`.`id` = 1685116 OR `props-main`.`id` = 1685357 OR `props-main`.`id` = 1692613 OR `props-main`.`id` = 1656163 OR `props-main`.`id` = 1697092)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare235035' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-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 Brian Gilbert, The Equity Group
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.
