Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/tulare/244428/1517-S-Barberry-Pl/Hanford/https://www.londonproperties.com/images/props/tulare/full/244428.jpgLondon Properties Hanford Real Estate | 1517 S Barberry Pl
Welcome Home for the Holidays! Step into this beautiful, nearly-new farmhouse-style home in Hanford's desirable Hidden Oaks neighborhood! Built in 2024 and thoughtfully designed with 1,595 square feet, this charming 3-bedroom, 2-bath home offers the perfect blend of modern comfort, warmth, and easy living. The inviting open-concept floor plan creates a wonderful space for everyday living and entertaining. The spacious kitchen is the heart of the home, featuring quartz countertops, a large center island, and plenty of room to gather with family and friends. Beautiful wood-look tile flooring flows throughout the main living areas, adding warmth and style while offering easy maintenance. Step outside to enjoy the beautifully landscaped front and backyard, where a covered patio, additional concrete, and cozy outdoor fireplace create the perfect setting for relaxing evenings, holiday gatherings, or enjoying a cup of coffee on a crisp morning. Additional features include a two-car garage, PPA solar panels, and the peace of mind that comes with a home that feels clean, fresh, and like new. Whether you're looking for your first home, a place to grow, or simply a beautiful space to make new memories, this Hidden Oaks gem is ready to welcome you home for the holidays and beyond! Don't miss the opportunity to see it for yourself! Call your favorite Realtor® today and schedule your private showing. Tenant Occupied and will be vacant sometime in November. Ask agent for more details. Please send all offers to [email protected]
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2024
Year Built Source
Public Records
Days On London
7
Cumulative Days On London
7
County
Kings
New Construction
No
Stories
1
Current Use
Residential
Directions to Property
From Hwy 198 and 12th Ave, Go South on 12th Ave, East on Hume Ave, South on S Alpine Ave, West on Butterfield Lane and a Right on Barberry Place. Home is not in the corner like GPS will announce, you have arrived. Look for 1517
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, Garage Door Opener
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
2.0
# Uncovered Parking
2.0
APN
011 620 048 000
Lot Features
Back Yard
Lot Dimensions
No map on public records
Horse Property
No
Zoning Description
SFR
Additional Parcels Y/N
No
View
Neighborhood
Waterfront Y/N
No
Road Frontage Type
City Street
Road Surface Type
Asphalt
Subdivision
Hidden Oaks
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 422750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 467250 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) >= 1345 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1845 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` = 1748857 OR `props-main`.`id` = 1786528 OR `props-main`.`id` = 1721178 OR `props-main`.`id` = 1754548 OR `props-main`.`id` = 1748830 OR `props-main`.`id` = 1745998 OR `props-main`.`id` = 1745999 OR `props-main`.`id` = 1755438 OR `props-main`.`id` = 1721710 OR `props-main`.`id` = 1782333 OR `props-main`.`id` = 1785560 OR `props-main`.`id` = 1785590 OR `props-main`.`id` = 1785586 OR `props-main`.`id` = 1781675 OR `props-main`.`id` = 1748824 OR `props-main`.`id` = 1788036 OR `props-main`.`id` = 1719337 OR `props-main`.`id` = 1773145 OR `props-main`.`id` = 1774026 OR `props-main`.`id` = 1744794 OR `props-main`.`id` = 1784965 OR `props-main`.`id` = 1769228 OR `props-main`.`id` = 1769343 OR `props-main`.`id` = 1767299 OR `props-main`.`id` = 1786127 OR `props-main`.`id` = 1728424 OR `props-main`.`id` = 1771342 OR `props-main`.`id` = 1774250 OR `props-main`.`id` = 1772850 OR `props-main`.`id` = 1767714 OR `props-main`.`id` = 1769122 OR `props-main`.`id` = 1785414 OR `props-main`.`id` = 1783424 OR `props-main`.`id` = 1778965 OR `props-main`.`id` = 1757164 OR `props-main`.`id` = 1757152 OR `props-main`.`id` = 1712806 OR `props-main`.`id` = 1782718 OR `props-main`.`id` = 1760042 OR `props-main`.`id` = 1758332 OR `props-main`.`id` = 1758345 OR `props-main`.`id` = 1753948 OR `props-main`.`id` = 1753953 OR `props-main`.`id` = 1759366 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1767787 OR `props-main`.`id` = 1786102 OR `props-main`.`id` = 1786135 OR `props-main`.`id` = 1785408 OR `props-main`.`id` = 1783494 OR `props-main`.`id` = 1726614 OR `props-main`.`id` = 1756044 OR `props-main`.`id` = 1786448 OR `props-main`.`id` = 1731939 OR `props-main`.`id` = 1783070 OR `props-main`.`id` = 1748863 OR `props-main`.`id` = 1783674 OR `props-main`.`id` = 1783637 OR `props-main`.`id` = 1783638 OR `props-main`.`id` = 1738561 OR `props-main`.`id` = 1748881 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1765497 OR `props-main`.`id` = 1787306 OR `props-main`.`id` = 1739164 OR `props-main`.`id` = 1739165 OR `props-main`.`id` = 1739184 OR `props-main`.`id` = 1768947 OR `props-main`.`id` = 1768948 OR `props-main`.`id` = 1768960 OR `props-main`.`id` = 1780018 OR `props-main`.`id` = 1756471 OR `props-main`.`id` = 1740904 OR `props-main`.`id` = 1740922 OR `props-main`.`id` = 1740937 OR `props-main`.`id` = 1740941 OR `props-main`.`id` = 1741969 OR `props-main`.`id` = 1739074 OR `props-main`.`id` = 1768961 OR `props-main`.`id` = 1768976)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare244428' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-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();
1
Similar Properties
$423,000
3
2
1,521
0.16
2138 Freedom St
Hanford, CA 93230
Courtesy of Olga Robles, Avedian Properties 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.
