Courtesy of Carlos Quintero, American Discount Realty Services Inc - [email protected]
Hard to find, this three-bedroom, 1.75-bath single-family residence sits on a generous 15,390-square-foot lot in Orosi, The property includes a one-car garage and ample outdoor space rare advantage in today's market. With a separate office unit 1 bedroom 1 bath, this home provides flexibility for various needs, whether you're seeking room for a growing household, a home office, or guest quarters. A solid foundation for building equity and long-term ownership value.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1963
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$299
Price Per Acre
$1,024,286
Days On London
0
Cumulative Days On London
0
County
Tulare
REO / Bank Owned
No
Cross Street Address
David Rd
Directions
david rd to ave 414 to property
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Composition
Foundation
Wood Subfloor
Detached Structures
Shed
Primary Bedroom Level
Lower
Bath Features
Tub/Shower
Extra Rooms
Office, Family Room
Flooring
Carpet, Vinyl
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Uncovered
Yard
Other
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Existing RV Parking, Carport
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
1
Carport Spaces
2
APN
023 193 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
Seller Will Consider
Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 340575 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 376425 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 950 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1450 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` = 1761050 OR `props-main`.`id` = 1722461 OR `props-main`.`id` = 1722520 OR `props-main`.`id` = 1746485 OR `props-main`.`id` = 1755333)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653480' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-11' 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 1 hour ago Fresno MLS last checked for updates 2 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.
