Madison: This single-story, three bedroom, two bathroom offers approximately 1,230 square feet of living space with an open-style living room and adjoining kitchen and dining area that are perfect for entertaining. The kitchen features shaker-style cabinetry, quartz countertops with backsplash, a walk-in pantry, a center island with pendant lighting and snack bar, and Whirlpool® stainless-steel appliances including a range, microwave and dishwasher. Black finishes are standard throughout the home. The main suite has an adjoining bathroom and a large walk-in closet.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built Exception
Under Construction
Location
Rural
Stories
1
Price Per Square Foot
$296
Price Per Acre
$2,855,381
Cumulative Days On Market
10
County
Kings
New Construction
Yes
Warranty Program
Builder Warranty
HUD
Yes
Foreclosure
No
Short Sale
No
Directions
Currently selling from Fox Run Community: From Hwy 198, take exit 84 to Hanford-Armona Road. Head south on Hanford-Armona Road. At the roundabout, take the third exit to continue onto Hanford-Armona Road then go west. Go south on Aquifer Drive and west on Annie Street. The sales office and model home will be on the corner of Annie Street and S. Magna Carta Avenue.
Heating Systems
Central
Cooling
Ceiling Fan(s), Central
Roof
Composition
Security Features
Smoke Detectors
Permanent Foundation
Slab
Full Bathrooms
2
Exterior
Stucco
Pool Private Y/N
No
Spa Y/N
No
Solar Y/N
Yes
Solar Options
Solar Panels
Solar Ownership
Owned
Garage Type
Garage Attached
Garage Capacity
2
Horse Property Y/N
No
APN Number
011 040 029
Association
Kings County Multiple Listing Service
Currently Rented
No
Lease Type
Net
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 345315.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 381664.5 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) >= 980 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1480 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` = 1679817 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` = 1669714 OR `props-main`.`id` = 1679384 OR `props-main`.`id` = 1676378 OR `props-main`.`id` = 1680932 OR `props-main`.`id` = 1667648 OR `props-main`.`id` = 1681149 OR `props-main`.`id` = 1682178 OR `props-main`.`id` = 1658724 OR `props-main`.`id` = 1682179 OR `props-main`.`id` = 1678155 OR `props-main`.`id` = 1681402 OR `props-main`.`id` = 1680311 OR `props-main`.`id` = 1683401 OR `props-main`.`id` = 1681542 OR `props-main`.`id` = 1678341 OR `props-main`.`id` = 1673823 OR `props-main`.`id` = 1667593 OR `props-main`.`id` = 1681390 OR `props-main`.`id` = 1655519 OR `props-main`.`id` = 1571373 OR `props-main`.`id` = 1571371 OR `props-main`.`id` = 1681814 OR `props-main`.`id` = 1683328 OR `props-main`.`id` = 1679088)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings232679' 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();
3
Similar Properties
$362,990
3
2
1,291
0.11
1842 W Twilight St
Hanford, CA 93230
$354,990
3
2
1,230
0.11
1186 31 BR Billingsley St
Hanford, CA 93230
$354,990
3
2
1,230
0.15
1146 27 BR Billingsley St
Hanford, CA 93230
Courtesy of Christian Perez, D.R. Horton CA3, 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.
