The Madison is a thoughtfully designed single-story, three-bedroom, two-bath home offering approximately 1,230 square feet of open-concept living. The welcoming living room flows seamlessly into the kitchen and dining areaideal for everyday living and entertaining. The modern kitchen features shaker-style cabinetry, quartz countertops, a center island with snack bar, walk-in pantry, and Whirlpool® stainless-steel appliances. The private primary suite includes an en-suite bathroom and a spacious walk-in closet. Two additional bedrooms, a full bathroom, and an indoor laundry room complete this functional and comfortable layout.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built Exception
Under Construction
Location
Rural
Property Condition
New Construction
Stories
1
Price Per Square Foot
$293
Price Per Acre
$2,903,707
Cumulative Days On London
9
County
Kings
Warranty Program
Builder Warranty
Directions
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
Leased
Garage Type
Garage Attached
Garage Capacity
2
Horse Property Y/N
No
APN Number
011 040 042
Association
Kings County Multiple Listing Service
Special Listing Conditions
HUD Owned
Currently Rented
No
Lease Type
Net
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 342332.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 378367.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` = 1748830 OR `props-main`.`id` = 1728731 OR `props-main`.`id` = 1728733 OR `props-main`.`id` = 1702192 OR `props-main`.`id` = 1745998 OR `props-main`.`id` = 1745999 OR `props-main`.`id` = 1717863 OR `props-main`.`id` = 1717862 OR `props-main`.`id` = 1717867 OR `props-main`.`id` = 1717879 OR `props-main`.`id` = 1717885 OR `props-main`.`id` = 1746505 OR `props-main`.`id` = 1726974 OR `props-main`.`id` = 1733210 OR `props-main`.`id` = 1736563 OR `props-main`.`id` = 1716929 OR `props-main`.`id` = 1716910 OR `props-main`.`id` = 1720568 OR `props-main`.`id` = 1720570 OR `props-main`.`id` = 1744794 OR `props-main`.`id` = 1749196 OR `props-main`.`id` = 1749800 OR `props-main`.`id` = 1728424 OR `props-main`.`id` = 1748827 OR `props-main`.`id` = 1747368 OR `props-main`.`id` = 1745036 OR `props-main`.`id` = 1751733 OR `props-main`.`id` = 1724354 OR `props-main`.`id` = 1745231 OR `props-main`.`id` = 1736801 OR `props-main`.`id` = 1732951 OR `props-main`.`id` = 1733039 OR `props-main`.`id` = 1732875 OR `props-main`.`id` = 1735830 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1724616 OR `props-main`.`id` = 1748866 OR `props-main`.`id` = 1748867 OR `props-main`.`id` = 1748868 OR `props-main`.`id` = 1751613 OR `props-main`.`id` = 1726614 OR `props-main`.`id` = 1727185 OR `props-main`.`id` = 1738561 OR `props-main`.`id` = 1712807 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1749115 OR `props-main`.`id` = 1749056 OR `props-main`.`id` = 1749243 OR `props-main`.`id` = 1724829 OR `props-main`.`id` = 1728425 OR `props-main`.`id` = 1728492 OR `props-main`.`id` = 1728493 OR `props-main`.`id` = 1728494 OR `props-main`.`id` = 1728509 OR `props-main`.`id` = 1728510 OR `props-main`.`id` = 1739164 OR `props-main`.`id` = 1739165 OR `props-main`.`id` = 1739184 OR `props-main`.`id` = 1739185 OR `props-main`.`id` = 1742175 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` = 1713710 OR `props-main`.`id` = 1727905 OR `props-main`.`id` = 1727906 OR `props-main`.`id` = 1739029 OR `props-main`.`id` = 1739030 OR `props-main`.`id` = 1739032 OR `props-main`.`id` = 1739047 OR `props-main`.`id` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1724968 OR `props-main`.`id` = 1731865)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings234057' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-21' 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();
8
Similar Properties
$372,990
3
3
1,380
0.08
2360 41 S Cullum St
Hanford, CA 93230
$371,240
3
3
1,380
0.08
2348 39 S Cullum St
Hanford, CA 93230
$370,000
3
2
1,271
0.11
1316 Greenbrier Dr
Hanford, CA 93230
$363,990
3
3
1,380
0.08
2336 37 S Cullum St
Hanford, CA 93230
Courtesy of Sherry Maurer, 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.
