Welcome to 1823 Rothschild Ave in Tulare, an exceptional 6-bedroom, 3-bath home offering nearly 3,800 sq ft of well-designed living space, ideal for a large family and entertaining. Situated on a desirable corner lot, this property features a 3-car garage, RV parking, and is in great condition throughout. The backyard is an entertainer's dream with a sparkling pool, covered patio, and outdoor fire pit, perfect for gatherings or relaxing evenings. The spacious interior offers multiple living areas with a functional layout that provides room for everyone. Conveniently located within walking distance to parks, schools, and shopping, this home delivers both comfort and lifestyle. A rare opportunity to own a home of this size and quality-don't miss it.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2007
Year Built Source
Public Records
Days On Market
0
Cumulative Days On Market
0
County
Tulare
New Construction
No
Stories
2
Directions to Property
S. Mooney Blvd, go south. west on E. Cartmill, south on De La Vina St., east on Bella Oaks, south on N. Laspina, east on Gruner, north on Rothschild
Foundation Details
Slab
Roof
Spanish Tile, Tile
Heating
Central
Cooling
Ceiling Fan(s), Central Air
Laundry Features
Gas Dryer Hookup, Inside
# of Main Level Bathrooms
1
Bathrooms Total (Integer)
3
Full Baths
2.75
Full Baths
2
Three Quarter Baths
1
Appliances
Dishwasher, Gas Range, Microwave
Fireplace Y/N
No
Private Pool
Yes
Pool Features
In Ground
Spa
No
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
3.0
APN
149 330 013 000
Lot Dimensions
Irregular
Horse Property
No
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) >= 679250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 750750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3476 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3976 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` = 1703164 OR `props-main`.`id` = 1691823 OR `props-main`.`id` = 1696346 OR `props-main`.`id` = 1686448 OR `props-main`.`id` = 1685563 OR `props-main`.`id` = 1685702 OR `props-main`.`id` = 1702075 OR `props-main`.`id` = 1702079 OR `props-main`.`id` = 1702076 OR `props-main`.`id` = 1691893 OR `props-main`.`id` = 1666539 OR `props-main`.`id` = 1687298 OR `props-main`.`id` = 1691958 OR `props-main`.`id` = 1698849 OR `props-main`.`id` = 1693438 OR `props-main`.`id` = 1693439 OR `props-main`.`id` = 1693440 OR `props-main`.`id` = 1703242 OR `props-main`.`id` = 1686669 OR `props-main`.`id` = 1703190 OR `props-main`.`id` = 1703256 OR `props-main`.`id` = 1703264 OR `props-main`.`id` = 1702371 OR `props-main`.`id` = 1703286 OR `props-main`.`id` = 1703187 OR `props-main`.`id` = 1648159 OR `props-main`.`id` = 1700912 OR `props-main`.`id` = 1694348 OR `props-main`.`id` = 1667549 OR `props-main`.`id` = 1697313 OR `props-main`.`id` = 1697879 OR `props-main`.`id` = 1701698 OR `props-main`.`id` = 1700135 OR `props-main`.`id` = 1685817 OR `props-main`.`id` = 1693940 OR `props-main`.`id` = 1696785 OR `props-main`.`id` = 1702611 OR `props-main`.`id` = 1685766 OR `props-main`.`id` = 1651113 OR `props-main`.`id` = 1701353 OR `props-main`.`id` = 1692257 OR `props-main`.`id` = 1700834 OR `props-main`.`id` = 1700835 OR `props-main`.`id` = 1702607 OR `props-main`.`id` = 1701245 OR `props-main`.`id` = 1703353 OR `props-main`.`id` = 1694598 OR `props-main`.`id` = 1701338 OR `props-main`.`id` = 1694599 OR `props-main`.`id` = 1660481 OR `props-main`.`id` = 1657630 OR `props-main`.`id` = 1660958 OR `props-main`.`id` = 1703366 OR `props-main`.`id` = 1648117 OR `props-main`.`id` = 1685715 OR `props-main`.`id` = 1643854 OR `props-main`.`id` = 1694740 OR `props-main`.`id` = 1677929 OR `props-main`.`id` = 1636938 OR `props-main`.`id` = 1657603 OR `props-main`.`id` = 1703219 OR `props-main`.`id` = 1703244 OR `props-main`.`id` = 1701502 OR `props-main`.`id` = 1701806 OR `props-main`.`id` = 1701808 OR `props-main`.`id` = 1701810 OR `props-main`.`id` = 1701505 OR `props-main`.`id` = 1701807 OR `props-main`.`id` = 1701811 OR `props-main`.`id` = 1701812 OR `props-main`.`id` = 1703207 OR `props-main`.`id` = 1648079 OR `props-main`.`id` = 1697046 OR `props-main`.`id` = 1695290 OR `props-main`.`id` = 1695293 OR `props-main`.`id` = 1695294 OR `props-main`.`id` = 1703131 OR `props-main`.`id` = 1695266 OR `props-main`.`id` = 1702732 OR `props-main`.`id` = 1701804 OR `props-main`.`id` = 1688392 OR `props-main`.`id` = 1697295 OR `props-main`.`id` = 1648872 OR `props-main`.`id` = 1698543 OR `props-main`.`id` = 1700375 OR `props-main`.`id` = 1698872 OR `props-main`.`id` = 1701650 OR `props-main`.`id` = 1688342 OR `props-main`.`id` = 1680925)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239292' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-19' 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 Zaid German, Bloom Group, 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.
