Welcome home to this beautifully updated 3-bedroom, 2-bath mobile home located in the highly sought-after Country Club Estates community. Thoughtfully renovated with today's first-time homebuyer in mind, this move-in-ready gem offers the perfect blend of comfort, style, and functionality.Step inside to discover a bright, open-concept living space designed for both everyday living and effortless entertaining. The spacious layout flows seamlessly into a stunning kitchen featuring custom cabinetry, providing ample storage and a touch of elegance throughout.Outside, you'll find a durable 30-year deckperfect for morning coffee, summer barbecues, or gathering with family and friends. A convenient storage shed offers plenty of room for tools, hobbies, or additional storage needs.Whether you're starting your homeownership journey or simply looking for a beautifully updated home in a desirable neighborhood, this property checks all the boxes
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1984
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$115
Price Per Acre
$3,343,023
Days On London
2
Cumulative Days On London
2
County
Tulare
REO / Bank Owned
No
Cross Street Address
Road 112
Directions
Google
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Main
Exterior
Wood, Vinyl
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Parking Features
Carport
Are there garage spaces?
No
Carport Spaces
2
APN
900 003 389
Association / Park Amenities
Green Area, Security Guard, Landscape Maint
HOA Dues
800.00
School District
Tulare Schools
School Type 1
High School
School Name 1
Tulare Union
School Type 2
Junior High School
School Name 2
Palo Verde
School Type 3
Grade School
School Name 3
Palo Verde
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 109250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 120750 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) >= 750 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1250 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` = 1719881 OR `props-main`.`id` = 1722785 OR `props-main`.`id` = 1729186 OR `props-main`.`id` = 1722812 OR `props-main`.`id` = 1734081 OR `props-main`.`id` = 1732783 OR `props-main`.`id` = 1728361 OR `props-main`.`id` = 1697281)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650076' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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
Last modified 2 hours ago Fresno MLS last checked for updates 5 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.
