Welcome home to this beautiful 4 bedroom 2 bath home!! It boasts tile floor throughout the home, a fully serviced central heating and cooling system, and a beautiful backyard to host. The property has been fully landscaped through the front and back with added glow voltage waterproof landscape light transformer lighting kit. It also has a fenced front yard for added security. Contact your preferred agent and come on by and view this beautiful home.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1999
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$288
Price Per Acre
$2,586,751
Days On Market
1
Cumulative Days On Market
1
County
Tulare
REO / Bank Owned
No
Cross Street Address
Kamm
Directions
from freeway 99 get off on Mountain View Ave Exit and stay for approximately 11 miles and then right on S Alta Ave until the roundabout, Then take 3rd exit onto E Kamm Ave heading East, Then turn right to south S Greene ave right to Exie Lane.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Lower
Flooring
Tile
Exterior
Stucco
Pool
No
Pool
No
Yard
Sprinklers Front, Sprinklers Back, Fenced
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Garage Type
Attached
Garage Spaces
2
APN
030 270 071
School District
Dinuba
School Type 1
High School
School Name 1
Dinuba
School Type 2
Junior High School
School Name 2
Washington
School Type 3
Grade School
School Name 3
Wilson - Dinuba
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 389500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 430500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1174 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1674 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` = 1700873 OR `props-main`.`id` = 1648426 OR `props-main`.`id` = 1666076 OR `props-main`.`id` = 1690493 OR `props-main`.`id` = 1685735 OR `props-main`.`id` = 1685737 OR `props-main`.`id` = 1697271 OR `props-main`.`id` = 1697251 OR `props-main`.`id` = 1698646 OR `props-main`.`id` = 1696619 OR `props-main`.`id` = 1697211 OR `props-main`.`id` = 1645564 OR `props-main`.`id` = 1700361 OR `props-main`.`id` = 1698540 OR `props-main`.`id` = 1698615 OR `props-main`.`id` = 1681363 OR `props-main`.`id` = 1698079 OR `props-main`.`id` = 1689869 OR `props-main`.`id` = 1698664 OR `props-main`.`id` = 1697323 OR `props-main`.`id` = 1698672 OR `props-main`.`id` = 1668131 OR `props-main`.`id` = 1693923 OR `props-main`.`id` = 1680656 OR `props-main`.`id` = 1694492 OR `props-main`.`id` = 1698096 OR `props-main`.`id` = 1666395 OR `props-main`.`id` = 1662429 OR `props-main`.`id` = 1700140 OR `props-main`.`id` = 246307 OR `props-main`.`id` = 1698749 OR `props-main`.`id` = 1683751 OR `props-main`.`id` = 1651549 OR `props-main`.`id` = 1698066 OR `props-main`.`id` = 1700136 OR `props-main`.`id` = 1681675 OR `props-main`.`id` = 1698469 OR `props-main`.`id` = 1691339 OR `props-main`.`id` = 1691366 OR `props-main`.`id` = 1691199 OR `props-main`.`id` = 1697827)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641452' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-31' 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 Maria Alcaraz Villegas, Realty Concepts - Reedley - [email protected] Last modified 3 hours ago Fresno MLS last checked for updates 16 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.
