The Wren is a generously sized two-story, five-bedroom, three-bath home offering approximately 2,814 square feet of living space and enhanced with 9-foot ceilings. A first-floor bedroom and full bathroom near the entry provide flexibility for guests or multi-generational living. The open-concept main living area connects to a large kitchen featuring shaker-style cabinetry, quartz countertops with backsplash, pendant lighting over the center island with snack bar, walk-in pantry, and Whirlpool® stainless-steel appliances. Black finishes are featured throughout for a modern, cohesive design. A formal dining area sits adjacent to the kitchen. Upstairs includes an open loft, the primary suite with dual vanity sinks and a spacious walk-in closet, three additional bedrooms, and an indoor laundry room.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2026
Year Built Source
Builder
Days On London
0
Cumulative Days On London
0
County
Tulare
New Construction
Yes
Stories
2
Directions to Property
From Hwy 99, take exit 87 to Tulare Ave. and head east on Tulare Ave. Go north on Morrison St., then follow the flags and signage to the model home located at the corner of Monarch Dunes Ave. and Ocean St.
Foundation Details
Slab
Roof
Composition
Heating
Central
Cooling
Central Air
# of Main Level Bathrooms
1
Bathrooms Total (Integer)
3
Full Baths
3.0
Full Baths
3
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
2.0
APN
172 450 022
Lot Dimensions
Irregular
Horse Property
No
Additional Parcels Y/N
No
Subdivision
Santa Fe Trail
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 501590.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 554389.5 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) >= 2564 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3064 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` = 1684212 OR `props-main`.`id` = 1713054 OR `props-main`.`id` = 1718328 OR `props-main`.`id` = 1702949 OR `props-main`.`id` = 1712799 OR `props-main`.`id` = 1709919 OR `props-main`.`id` = 1713023 OR `props-main`.`id` = 1717788 OR `props-main`.`id` = 1709751 OR `props-main`.`id` = 1709174 OR `props-main`.`id` = 1715198 OR `props-main`.`id` = 1706839 OR `props-main`.`id` = 1705988 OR `props-main`.`id` = 1702075 OR `props-main`.`id` = 1702079 OR `props-main`.`id` = 1715325 OR `props-main`.`id` = 1713390 OR `props-main`.`id` = 1711425 OR `props-main`.`id` = 1716772 OR `props-main`.`id` = 1693438 OR `props-main`.`id` = 1693439 OR `props-main`.`id` = 1693440 OR `props-main`.`id` = 1703242 OR `props-main`.`id` = 1716487 OR `props-main`.`id` = 1716994 OR `props-main`.`id` = 1694348 OR `props-main`.`id` = 1697313 OR `props-main`.`id` = 1697879 OR `props-main`.`id` = 1716826 OR `props-main`.`id` = 1709738 OR `props-main`.`id` = 1712944 OR `props-main`.`id` = 1718087 OR `props-main`.`id` = 1717042 OR `props-main`.`id` = 1693940 OR `props-main`.`id` = 1717242 OR `props-main`.`id` = 1709147 OR `props-main`.`id` = 1717233 OR `props-main`.`id` = 1718509 OR `props-main`.`id` = 1718519 OR `props-main`.`id` = 1718522 OR `props-main`.`id` = 1700834 OR `props-main`.`id` = 1715496 OR `props-main`.`id` = 1705941 OR `props-main`.`id` = 1714908 OR `props-main`.`id` = 1713079 OR `props-main`.`id` = 1705626 OR `props-main`.`id` = 1714028 OR `props-main`.`id` = 1705627 OR `props-main`.`id` = 1660481 OR `props-main`.`id` = 1657630 OR `props-main`.`id` = 1660958 OR `props-main`.`id` = 1685715 OR `props-main`.`id` = 1717689 OR `props-main`.`id` = 1717849 OR `props-main`.`id` = 1701505 OR `props-main`.`id` = 1701811 OR `props-main`.`id` = 1718126 OR `props-main`.`id` = 1718127 OR `props-main`.`id` = 1717729 OR `props-main`.`id` = 1695293 OR `props-main`.`id` = 1707927 OR `props-main`.`id` = 1715065 OR `props-main`.`id` = 1717448 OR `props-main`.`id` = 1717438 OR `props-main`.`id` = 1697295 OR `props-main`.`id` = 1716986 OR `props-main`.`id` = 1717382)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240636' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-27' 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 Cara Dierkes-Ray, D.R. Horton CA, 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.
