Welcome to your dream home at 1738 Justice Ave. A beautifully built nearly new residence designed for comfort and every day living. With over 2,200 sq ft of thoughtfully laid-out space, this home features an open floor plan and is perfect for family gatherings and entertaining. Bright interiors, generous bedroom sizes, modern finishes create a move in ready atmosphere. Enjoy this homes big lot that has potential for any backyard dreams. Situated in a Tulare neighborhood, close to local schools and amenities, this home offers quality, value, and lifestyle all in one! Don't miss your chance- schedule your tour today!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2024
Year Built Source
Public Records
Days On London
21
Cumulative Days On London
21
County
Tulare
New Construction
No
Stories
2
Directions to Property
Go West on Bardsley, turn right/North on Potomace, turn left on Justice and the home will be on your right.
Construction Materials
Board & Batten Siding, Stucco, Vertical Siding
Foundation Details
Concrete Perimeter
Roof
Composition, Shingle
Heating
Electric
Cooling
Ceiling Fan(s), Central Air
Laundry Features
Inside, Laundry Room, Washer Hookup
Security Features
Smoke Detector(s)
Interior Features
Breakfast Bar, Ceiling Fan(s), Kitchen Island, Open Floorplan, Recessed Lighting, Stone Counters, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 417050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 460950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1972 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2472 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` = 1698936 OR `props-main`.`id` = 1694035 OR `props-main`.`id` = 1690412 OR `props-main`.`id` = 1706149 OR `props-main`.`id` = 1690415 OR `props-main`.`id` = 1696402 OR `props-main`.`id` = 1705819 OR `props-main`.`id` = 1704206 OR `props-main`.`id` = 1704487 OR `props-main`.`id` = 1704488 OR `props-main`.`id` = 1704499 OR `props-main`.`id` = 1673302 OR `props-main`.`id` = 1673303 OR `props-main`.`id` = 1661841 OR `props-main`.`id` = 1655866 OR `props-main`.`id` = 1655879 OR `props-main`.`id` = 1706853 OR `props-main`.`id` = 1657781 OR `props-main`.`id` = 1701658 OR `props-main`.`id` = 1709296 OR `props-main`.`id` = 1708003 OR `props-main`.`id` = 1701738 OR `props-main`.`id` = 1703069 OR `props-main`.`id` = 1703511 OR `props-main`.`id` = 1703513 OR `props-main`.`id` = 1698634 OR `props-main`.`id` = 1711122 OR `props-main`.`id` = 1709917 OR `props-main`.`id` = 1698616 OR `props-main`.`id` = 1704818 OR `props-main`.`id` = 1694065 OR `props-main`.`id` = 1686171 OR `props-main`.`id` = 1703151 OR `props-main`.`id` = 1701579 OR `props-main`.`id` = 1708167 OR `props-main`.`id` = 1708158 OR `props-main`.`id` = 1703243 OR `props-main`.`id` = 1681737 OR `props-main`.`id` = 1702082)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239599' 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();
2
Similar Properties
$432,000
5
3
2,222
0.12
920 Maricopa St
Tulare, CA 93274
$429,990
5
3
2,096
0.13
1824 Union Ave
Tulare, CA 93274
Courtesy of Kimberly Valov-Lorenzo, Craig Smith & Associates, 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.
