Welcome to your dream home at 1738 Justice Ave. A beautifully built nearly new residence designed for comfort and everyday 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
62
Cumulative Days On London
62
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` = 1719452 OR `props-main`.`id` = 1719814 OR `props-main`.`id` = 1720001 OR `props-main`.`id` = 1706149 OR `props-main`.`id` = 1705819 OR `props-main`.`id` = 1704487 OR `props-main`.`id` = 1704488 OR `props-main`.`id` = 1720471 OR `props-main`.`id` = 1715540 OR `props-main`.`id` = 1715542 OR `props-main`.`id` = 1715539 OR `props-main`.`id` = 1706853 OR `props-main`.`id` = 1657781 OR `props-main`.`id` = 1719587 OR `props-main`.`id` = 1717864 OR `props-main`.`id` = 1718588 OR `props-main`.`id` = 1713953 OR `props-main`.`id` = 1701738 OR `props-main`.`id` = 1713948 OR `props-main`.`id` = 1717106 OR `props-main`.`id` = 1713922 OR `props-main`.`id` = 1719807 OR `props-main`.`id` = 1717338 OR `props-main`.`id` = 1713916 OR `props-main`.`id` = 1717815 OR `props-main`.`id` = 1719799 OR `props-main`.`id` = 1719803 OR `props-main`.`id` = 1719805 OR `props-main`.`id` = 1686171 OR `props-main`.`id` = 1717825 OR `props-main`.`id` = 1703243 OR `props-main`.`id` = 1702082 OR `props-main`.`id` = 1718859)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239599' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-06' 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
$444,465
5
3
2,096
0.14
1522 Glory Ave
Tulare, CA 93274
$420,000
5
3
2,222
0.12
920 Maricopa St
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.
