1738 The Cedar: This fresh and functional 1,738 sq. ft. haven features four bedrooms and two full bathrooms, offering separate spaces for the whole family. Entering the front door, you are welcomed into a grand living room with vaulted ceilings seamlessly joining the contemporary kitchen for an open interior. A generous island provides a dining area with storage and still allows room for more seating. Enjoy the sizable, covered patio, which is accessible from the nook and perfect for expanding the party outdoors. A roomy laundry room and pantry hallway provide easy access from the garage. One corner of this home is exclusively devoted to the private primary suite with a lofty walk-in closet. The sparkling primary bathroom can be configured with extra linen storage or a tub for relaxing, all behind an optional barn door. An additional hallway joins the entry way and leads to three more spacious bedrooms and a bathroom to make up a separate wing of the home. Contact our new home specialists to see how we can help you find your dream home. Individual Finishes vary. Call SHI Sales Agent for more details.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2026
Year Built Source
Builder
Days On London
18
Cumulative Days On London
18
County
Tulare
New Construction
Yes
Stories
1
Directions to Property
From 198 East to 65 South to Sequoia then West to Filbert. then North to Windsor, west to property on north side of the street.
Roof
Composition
Heating
Active Solar, Central
Cooling
Central Air
Bathrooms Total (Integer)
2
Full Baths
1.75
Full Baths
1
Three Quarter Baths
1
Fireplace Y/N
No
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
Lot Dimensions
60x135.68
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 450309.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 497710.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1488 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1988 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` = 1716869 OR `props-main`.`id` = 1715527 OR `props-main`.`id` = 1716370 OR `props-main`.`id` = 1711229 OR `props-main`.`id` = 1721617 OR `props-main`.`id` = 1720144 OR `props-main`.`id` = 1694014 OR `props-main`.`id` = 1694023 OR `props-main`.`id` = 1694041 OR `props-main`.`id` = 1694016 OR `props-main`.`id` = 1721732 OR `props-main`.`id` = 1691916 OR `props-main`.`id` = 1719990 OR `props-main`.`id` = 1691895 OR `props-main`.`id` = 1719354 OR `props-main`.`id` = 1721570 OR `props-main`.`id` = 1714925 OR `props-main`.`id` = 1717686 OR `props-main`.`id` = 1716776 OR `props-main`.`id` = 1691891 OR `props-main`.`id` = 1713294 OR `props-main`.`id` = 1717890 OR `props-main`.`id` = 1709912 OR `props-main`.`id` = 1720294 OR `props-main`.`id` = 1709595 OR `props-main`.`id` = 1719999 OR `props-main`.`id` = 1720575 OR `props-main`.`id` = 1717831 OR `props-main`.`id` = 1722323 OR `props-main`.`id` = 1630494 OR `props-main`.`id` = 1721261 OR `props-main`.`id` = 1721585)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare238441' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-17' 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 Irma Carter, Melson Realty, 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.
