Nice 3 bdrm, 2 ba home, located on 3.18 acres of land! This home was built in 2005 and features tile floors throughout. Nice dining and kitchen with breakfast bar. New exterior paint and large 60 x 14 patio. This home is surrounded by a variety of trees. There is olive trees, 4 different types of palm trees, bamboo, pine trees, and lots of fruit trees including pomegranate, avocado, lemon, orange, mandarin, and guava trees. This property is also perfect for animals such as horses, sheep, goat, etc. Also it's located within the city limits of Orosi and close to school and shopping centers. Call to set up your private showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2005
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$458
Price Per Acre
$187,107
Days On Market
83
Cumulative Days On Market
449
County
Tulare
REO / Bank Owned
No
Cross Street Address
Rd. 130
Directions
East Ave. 416, North Rd. 130, East Ave. 414
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Concrete
Kitchen
Gas Appliances, Breakfast Bar
Primary Bedroom Level
Main
Flooring
Tile
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Covered
Gas & Electric
Propane
Sewer / Water
Septic Tank
Well Depth
120.00
Solar
No
Garage Type
Attached
Garage Spaces
2
APN
025 220 014
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) >= 565250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 624750 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) >= 1050 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1550 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` = 1690064 OR `props-main`.`id` = 1693934 OR `props-main`.`id` = 1698788 OR `props-main`.`id` = 1691936 OR `props-main`.`id` = 1665898 OR `props-main`.`id` = 1698626 OR `props-main`.`id` = 1688964 OR `props-main`.`id` = 1657715)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno638567' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-06' 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 Angela Barajas, Newton & Sons Real Estate - [email protected] Last modified 2 months ago Fresno MLS last checked for updates 9 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.
