Check out this gorgeous custom home! Built in 2001, this impressive home offers over 5,000 square feet of living space and sits on a spacious 1.93-acre lot. From the long driveway, mature landscaping and grand entrance, there are custom features to appreciate throughout. Inside, the home offers plenty of room with a formal dining area, multiple living spaces, high ceilings, arched windows and an open layout that flows from one end of the home to the other. The large kitchen features beautiful wood cabinetry, granite countertops, multiple islands, plenty of counter and storage space, and a large breakfast bar overlooking the main living area. The living room is highlighted by soaring ceilings, abundant natural light, built-in cabinetry and a fireplace. The main level features 2 bedrooms, 2 bathrooms, a bonus room, indoor laundry and a large office with its own private entrance. Upstairs you'll find the spacious primary suite overlooking the living area, along with a private balcony and spiral staircase leading to the backyard. Outside, the nearly 2-acre property offers mature landscaping, expansive grounds, a long driveway, covered outdoor areas and a large custom gazebo, creating a wonderful setting for entertaining family and friends. This one-of-a-kind property has so much to offer. Call today to schedule your private showing!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2001
Region
Rural
# of Stories
Two
Price Per Square Foot
$309
Price Per Acre
$870,466
Days On London
0
Cumulative Days On London
0
County
Tulare
REO / Bank Owned
No
Cross Street Address
Ave 416
Directions
North on Hwy 63 to Ave 416, West on Ave 416 to Road 120, South on Road 120 to property.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Primary Bedroom Level
Upper
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank, Private Well
Solar
Yes
Solar Type
Lease
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
4
APN
021 230 043
School District
Cutler-Orosi Schools
School Type 1
High School
School Name 1
Orosi
School Type 2
Junior High School
School Name 2
El Monte
School Type 3
Grade School
School Name 3
Palm
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1596000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1764000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 5181 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 5681 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` = 1716969 OR `props-main`.`id` = 1732307 OR `props-main`.`id` = 1734249 OR `props-main`.`id` = 1722461 OR `props-main`.`id` = 1722520 OR `props-main`.`id` = 1763630 OR `props-main`.`id` = 1746485 OR `props-main`.`id` = 1755333 OR `props-main`.`id` = 1714923)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653862' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-18' 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
Last modified 3 hours ago Fresno MLS last checked for updates 52 minutes ago
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.
