Come check out this beautiful model at Hidden Oaks II in Hanford! The Hawthorne floorplan offers a large open kitchen with spacious island, split floorplan, and covered patio all located near our large park with a basketball court and playground! You can still customize many of your interior selections. Convenient access to 198 freeway, shopping and restaurants, and the Lemoore Naval Station are just a few of the reasons buyers have chosen to call Hidden Oaks home. Call or come by today to tour the Hawthorne Model.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2025
Year Built Source
Builder
Days On Market
30
Cumulative Days On Market
30
County
Kings
Property Condition
New Construction
New Construction
Yes
Stories
2
Directions to Property
Visit Hidden Oaks II located in southwest Hanford at 1601 Barberry Pl, near 12th Ave. and Hume Ave., off of Alpine. From Hwy 198, take the 12th Ave. exit, then head south onto 12th Ave. From 12th Ave., head east on Hume Ave., then go south on S. Alpine Ave. follow the flags and signage to the Sales Office and model homes on Barberry Pl.
Construction Materials
Stucco
Foundation Details
Slab
Roof
Composition
Heating
Central, Electric, High Effciency
Cooling
Central Air, Electric, High Effciency
Laundry Features
Inside
Security Features
Carbon Monoxide Detector(s), Fire Alarm
Interior Features
Ceiling Fan(s), Granite Counters, Kitchen Open to Family Room, Pantry
# of Main Level Bathrooms
1
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Appliances
Built-In Range, Dishwasher, Electric Range
Fireplace Y/N
No
Flooring
Carpet, Ceramic Tile
Common Walls
No One Above
Spa
No
Patio and Porch Features
Covered
Utilities
Electricity Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
2.0
APN
123 456 789 000
Lot Features
Back Yard, Fencing, Front Yard, Landscaped
Lot Dimensions
irregular
Additional Parcels Y/N
No
View
Neighborhood
Road Surface Type
Asphalt, Paved
HOA
No
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 400838.25 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 443031.75 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1826 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2326 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` = 1669702 OR `props-main`.`id` = 1626111 OR `props-main`.`id` = 1648248 OR `props-main`.`id` = 1643093 OR `props-main`.`id` = 1682335 OR `props-main`.`id` = 1665900 OR `props-main`.`id` = 1679817 OR `props-main`.`id` = 1674594 OR `props-main`.`id` = 1636285 OR `props-main`.`id` = 1614339 OR `props-main`.`id` = 1613599 OR `props-main`.`id` = 1615157 OR `props-main`.`id` = 1681309 OR `props-main`.`id` = 1681282 OR `props-main`.`id` = 1681541 OR `props-main`.`id` = 1679384 OR `props-main`.`id` = 1676378 OR `props-main`.`id` = 1653176 OR `props-main`.`id` = 1648085 OR `props-main`.`id` = 1659576 OR `props-main`.`id` = 1660339 OR `props-main`.`id` = 1680932 OR `props-main`.`id` = 1667648 OR `props-main`.`id` = 1681149 OR `props-main`.`id` = 1682178 OR `props-main`.`id` = 1668875 OR `props-main`.`id` = 1676228 OR `props-main`.`id` = 1676227 OR `props-main`.`id` = 1676226 OR `props-main`.`id` = 1676217 OR `props-main`.`id` = 1682179 OR `props-main`.`id` = 1678155 OR `props-main`.`id` = 1681402 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1683401 OR `props-main`.`id` = 1668724 OR `props-main`.`id` = 1681542 OR `props-main`.`id` = 1673823 OR `props-main`.`id` = 1652718 OR `props-main`.`id` = 1684096 OR `props-main`.`id` = 1684127 OR `props-main`.`id` = 1684151 OR `props-main`.`id` = 1684099 OR `props-main`.`id` = 1684134 OR `props-main`.`id` = 1667593 OR `props-main`.`id` = 1681390 OR `props-main`.`id` = 1627862 OR `props-main`.`id` = 1632242 OR `props-main`.`id` = 1681546 OR `props-main`.`id` = 1571373 OR `props-main`.`id` = 1571371 OR `props-main`.`id` = 1681814 OR `props-main`.`id` = 1671536 OR `props-main`.`id` = 1671732 OR `props-main`.`id` = 1671537 OR `props-main`.`id` = 1681495 OR `props-main`.`id` = 1666685 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1666686 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1683328)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare236733' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-07' 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 Lana Fahoum, San Joaquin Valley Homes
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.
