Villas at Sierra Ranch. Tulare's Newest Premier Luxury Gaterd Community. The Shelby entry reveals the welcoming two-story foyer and views of the expansive great room, dining room, and desirable luxury outdoor living space beyond. The well-designed kitchen is equipped with a large center island with breakfast bar, plenty of counter and cabinet space. The gorgeous primary bedroom suite is enhanced by a gigantic walk-in closet and deluxe primary bath with dual-sink vanity, large soaking tub option, luxe glass-enclosed shower with seat, and private water closet. BUILD TO SUIT TO THE BUYER.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2025
Location
City
Property Condition
New Construction
Stories
2
Price Per Square Foot
$234
Price Per Acre
$5,213,542
Cumulative Days On Market
241
County
Tulare
Directions
From 99 FWY exit east on Cartmill, south on Hillman, west on Corvina, model homes are on Lisbon
Heating Systems
Heat Pump
Cooling
Ceiling Fan(s), Other
Water Heater Types
Tankless
Laundry
Room
Roof
Composition
Security Features
Gated Community, Smoke Detectors
Window Treatments
None
Windows
Screens
Permanent Foundation
Slab
Full Bathrooms
2
Half Bathrooms
1
Appliances Included
Convection Oven, Dishwasher, Garbage Disposal, Gas Range/Oven
Interior Features
Walk In Closet(s), Walk In Shower(s)
Floors
Carpet, Hardwood Floors, Tile Floors
Pool Private Y/N
No
Spa Y/N
No
Utilities
Natural Gas Connected
Water Supply
Public
Sewer
Public Sewer
Solar Y/N
Yes
Solar Options
Solar Panels
Solar Ownership
PPA: Pwr Purch Agmnt
Garage Type
Garage Attached
Garage Capacity
2
Road Surface
Paved
Sprinklers
Front
Horse Property Y/N
No
APN Number
123 456 789 000
HOA Dues
88.00
HOA Frequency
Monthly
Association
Kings County Multiple Listing Service
Association Amenities
Gated Community
Currently Rented
No
Lease Type
Net
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 523022.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 578077.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2107 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2607 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` = 1686106 OR `props-main`.`id` = 1698537 OR `props-main`.`id` = 1698144 OR `props-main`.`id` = 1698563 OR `props-main`.`id` = 1685845 OR `props-main`.`id` = 1687117 OR `props-main`.`id` = 1689104 OR `props-main`.`id` = 1698636 OR `props-main`.`id` = 1690281 OR `props-main`.`id` = 1698637 OR `props-main`.`id` = 1698638 OR `props-main`.`id` = 1698521 OR `props-main`.`id` = 1697166 OR `props-main`.`id` = 1692256 OR `props-main`.`id` = 1693878 OR `props-main`.`id` = 1697926 OR `props-main`.`id` = 1698629 OR `props-main`.`id` = 1695624 OR `props-main`.`id` = 1697176 OR `props-main`.`id` = 1699992 OR `props-main`.`id` = 1696709 OR `props-main`.`id` = 1698683 OR `props-main`.`id` = 1663396 OR `props-main`.`id` = 1650946 OR `props-main`.`id` = 1677237 OR `props-main`.`id` = 1697938 OR `props-main`.`id` = 1690227 OR `props-main`.`id` = 1691067 OR `props-main`.`id` = 1678402 OR `props-main`.`id` = 1692065 OR `props-main`.`id` = 1688666 OR `props-main`.`id` = 1697231 OR `props-main`.`id` = 1694448 OR `props-main`.`id` = 1694575 OR `props-main`.`id` = 1698074 OR `props-main`.`id` = 1698201 OR `props-main`.`id` = 1698853 OR `props-main`.`id` = 1698143 OR `props-main`.`id` = 1674706 OR `props-main`.`id` = 1698622 OR `props-main`.`id` = 1698173 OR `props-main`.`id` = 1671956 OR `props-main`.`id` = 1695984 OR `props-main`.`id` = 1685192 OR `props-main`.`id` = 1688689 OR `props-main`.`id` = 1648087 OR `props-main`.`id` = 1689698 OR `props-main`.`id` = 1700872 OR `props-main`.`id` = 1700870 OR `props-main`.`id` = 1677924 OR `props-main`.`id` = 1677928 OR `props-main`.`id` = 1694475 OR `props-main`.`id` = 1692569 OR `props-main`.`id` = 1698099 OR `props-main`.`id` = 1698100 OR `props-main`.`id` = 1701164 OR `props-main`.`id` = 1701384 OR `props-main`.`id` = 1698102 OR `props-main`.`id` = 1691755 OR `props-main`.`id` = 1695697 OR `props-main`.`id` = 1695799 OR `props-main`.`id` = 1694425 OR `props-main`.`id` = 1696632 OR `props-main`.`id` = 1681742 OR `props-main`.`id` = 1681741 OR `props-main`.`id` = 1685446 OR `props-main`.`id` = 1695463 OR `props-main`.`id` = 1689648 OR `props-main`.`id` = 1690520 OR `props-main`.`id` = 1657899 OR `props-main`.`id` = 1680739 OR `props-main`.`id` = 1701314 OR `props-main`.`id` = 1701377 OR `props-main`.`id` = 1701382 OR `props-main`.`id` = 1701381 OR `props-main`.`id` = 1695693 OR `props-main`.`id` = 1680859 OR `props-main`.`id` = 1686889 OR `props-main`.`id` = 1686883 OR `props-main`.`id` = 1687411 OR `props-main`.`id` = 1701240 OR `props-main`.`id` = 1697177 OR `props-main`.`id` = 1697126 OR `props-main`.`id` = 1648083 OR `props-main`.`id` = 1345585 OR `props-main`.`id` = 1693526)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings232077' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-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();
5
Similar Properties
$539,900
4
3
2,232
0.17
1342 W Glendale Ave
Visalia, CA 93291
$529,000
5
3
2,229
0.16
2446 W Sedona Ave
Visalia, CA 93291
$525,000
5
4
2,554
0.15
3310 N Church St
Visalia, CA 93291
$525,000
4
3
2,570
0.16
336 E Tyler Ct
Visalia, CA 93291
Courtesy of Jennifer Padilla, Century 21 Jordan-Link & Company
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.
