Welcome to this lovely home featuring 3 bedrooms and 2 bathrooms with an open-concept floor plan, designed for comfortable living and entertaining. Cozy fireplace and wood-look tile flooring in kitchen, dining. and hallway. Granite counter tops and tile backsplash in kitchen, plus large pantry. Great room with lighting above and crown molding. Large primary bedroom with walk-in closet. Situated in a great neighborhood, this home boasts a large backyard with no neighbors behind, offering added privacy. The covered patio is perfect for relaxing, along with a an equipped outdoor kitchen, ideal for entertaining year-round. There is also a storage shed for extra convenience. Lots more to mention! Make your appointment to see this home today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2006
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$280
Price Per Acre
$2,359,292
Days On Market
39
Cumulative Days On Market
39
County
Tulare
REO / Bank Owned
No
Cross Street Address
Mammoth
Directions
From S Mooney, East on Bardlsey, South o n Nelder Gove, East on Swanson Meadows, South on Mammoth to Badger Flat
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven
Primary Bedroom Level
Lower
Bath Features
Tub/Shower
Flooring
Carpet, Tile
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Garage Type
Attached
Garage Spaces
2
APN
172 170 023
School District
Tulare Schools
School Type 1
High School
School Name 1
Tulare Union
School Type 2
Junior High School
School Name 2
Los Tules
School Type 3
Grade School
School Name 3
Lincoln - Tulare Cit
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 419895 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) >= 1180 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1680 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` = 1697281 OR `props-main`.`id` = 1697836 OR `props-main`.`id` = 1700836 OR `props-main`.`id` = 1615096 OR `props-main`.`id` = 1648491 OR `props-main`.`id` = 1671752 OR `props-main`.`id` = 1693558 OR `props-main`.`id` = 1693586 OR `props-main`.`id` = 1701679 OR `props-main`.`id` = 1701681 OR `props-main`.`id` = 1697784 OR `props-main`.`id` = 1685701 OR `props-main`.`id` = 1693584 OR `props-main`.`id` = 1685045 OR `props-main`.`id` = 1698548 OR `props-main`.`id` = 1698507 OR `props-main`.`id` = 1701927 OR `props-main`.`id` = 1701992 OR `props-main`.`id` = 1696910 OR `props-main`.`id` = 1697194 OR `props-main`.`id` = 1690896 OR `props-main`.`id` = 1693561 OR `props-main`.`id` = 1701978 OR `props-main`.`id` = 1696554 OR `props-main`.`id` = 1684212 OR `props-main`.`id` = 1656199 OR `props-main`.`id` = 1701785 OR `props-main`.`id` = 1696043 OR `props-main`.`id` = 1681869 OR `props-main`.`id` = 1691823 OR `props-main`.`id` = 1694260 OR `props-main`.`id` = 1691888 OR `props-main`.`id` = 1691889 OR `props-main`.`id` = 1694258 OR `props-main`.`id` = 1696591 OR `props-main`.`id` = 1696346 OR `props-main`.`id` = 1686448 OR `props-main`.`id` = 1691870 OR `props-main`.`id` = 1685563 OR `props-main`.`id` = 1685702 OR `props-main`.`id` = 1702075 OR `props-main`.`id` = 1702079 OR `props-main`.`id` = 1690932 OR `props-main`.`id` = 1702076 OR `props-main`.`id` = 1691893 OR `props-main`.`id` = 1666539 OR `props-main`.`id` = 1687298 OR `props-main`.`id` = 1689432 OR `props-main`.`id` = 1698078 OR `props-main`.`id` = 1691833 OR `props-main`.`id` = 1691958 OR `props-main`.`id` = 1698849 OR `props-main`.`id` = 1693438 OR `props-main`.`id` = 1693439 OR `props-main`.`id` = 1693440 OR `props-main`.`id` = 1697940 OR `props-main`.`id` = 1686669 OR `props-main`.`id` = 1698959 OR `props-main`.`id` = 1648159 OR `props-main`.`id` = 1700912 OR `props-main`.`id` = 1694348 OR `props-main`.`id` = 1667549 OR `props-main`.`id` = 1697313 OR `props-main`.`id` = 1697879 OR `props-main`.`id` = 1701698 OR `props-main`.`id` = 1693940 OR `props-main`.`id` = 1685766)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640610' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-09' 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();
4
Similar Properties
$401,050
3
2
1,615
0.12
230 Ontario Cir
Tulare, CA 93274
$392,500
3
2
1,483
0.12
3177 E Sierra Ave
Tulare, CA 93274
$390,000
3
2
1,613
0.16
1363 Windsong Dr
Tulare, CA 93274
$389,900
3
2
1,567
0.16
1599 Softwind Dr. Dr
Tulare, CA 93274
Courtesy of Angela Barajas, Newton & Sons Real Estate - [email protected] Last modified 1 day ago Fresno MLS last checked for updates 55 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.
