Please provide the following information and Amy Medeiros will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.platinumhomelistings.com/agent/10685/amy-medeiros/property/link/fresno/642286/4142-W-Cambridge-Ave/Visalia/https://www.platinumhomelistings.com/images/props/fresno/full/642286.jpgLondon Properties Visalia Real Estate | 4142 W Cambridge Ave
This cute and cozy home has been updated from top to bottom and front to back! Too many to list them all, but the major improvements include newer roof, new flooring throughout, new kitchen appliances and butcher block counters, updated bathrooms, new lighting, and new interior and exterior paint. The wood steps provide a warm welcome to the front porch while fresh landscaping invite you to linger outdoors. A shed in the back yard provides extra space for storage or hobbies. The fourth bedroom has been converted to a spacious closet but could still serve as office or workout space if desired. Whether you're looking for a starter home, investment property, or wanting to downsize; this conveniently located darling could be just the right fit!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1985
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$289
Price Per Acre
$2,415,813
Days On Market
1
Cumulative Days On Market
1
County
Tulare
REO / Bank Owned
No
Cross Street Address
Chinowth
Directions
From Walnut and Chinowth, head North onto Chinowth, Left onto Cambridge. Home is on the North side of the road.
Special Disclosure
Flood Zone, See Remrks/Attchmnts
Heating & Cooling
Central Heat & Cool, Whole House Fan
Laundry
In Garage
Roofing
Composition
Foundation
Wood Subfloor
Detached Structures
Shed
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Refrigerator
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Disabled Features
Hand Rails
Flooring
Carpet, Laminate, Tile
Exterior
Wood
Pool
No
Pool
No
Patio Features
Uncovered
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto, Mature Landscape, Drip System
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
No
Garage Type
Attached
Garage Spaces
2
APN
087 170 070
School District
Visalia Schools
School Type 1
High School
School Name 1
El Diamonte
School Type 2
Junior High School
School Name 2
La Joya
School Type 3
Grade School
School Name 3
Veva Blunt
Seller Will Consider
Government, Conventional, Cash
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 313500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 346500 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) >= 890 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1390 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` = 1690834 OR `props-main`.`id` = 1696538 OR `props-main`.`id` = 1700154 OR `props-main`.`id` = 1688752 OR `props-main`.`id` = 1685040 OR `props-main`.`id` = 1696672 OR `props-main`.`id` = 1696990 OR `props-main`.`id` = 1696539 OR `props-main`.`id` = 1696545 OR `props-main`.`id` = 1696537 OR `props-main`.`id` = 1549450 OR `props-main`.`id` = 1648185 OR `props-main`.`id` = 1616928 OR `props-main`.`id` = 1690720 OR `props-main`.`id` = 1549555 OR `props-main`.`id` = 1684180 OR `props-main`.`id` = 1687799 OR `props-main`.`id` = 1698846 OR `props-main`.`id` = 1691065 OR `props-main`.`id` = 1691073 OR `props-main`.`id` = 1691075 OR `props-main`.`id` = 1691082 OR `props-main`.`id` = 1702391 OR `props-main`.`id` = 1698493 OR `props-main`.`id` = 1698550 OR `props-main`.`id` = 1651784 OR `props-main`.`id` = 1702083 OR `props-main`.`id` = 1681923 OR `props-main`.`id` = 1689875 OR `props-main`.`id` = 1694031 OR `props-main`.`id` = 1689876 OR `props-main`.`id` = 1702963 OR `props-main`.`id` = 1702854 OR `props-main`.`id` = 1702042 OR `props-main`.`id` = 1694024 OR `props-main`.`id` = 1696748 OR `props-main`.`id` = 1680183 OR `props-main`.`id` = 1695949 OR `props-main`.`id` = 1695715 OR `props-main`.`id` = 1692036 OR `props-main`.`id` = 1692035 OR `props-main`.`id` = 1702829 OR `props-main`.`id` = 1693637 OR `props-main`.`id` = 1696175 OR `props-main`.`id` = 1684110 OR `props-main`.`id` = 1696779 OR `props-main`.`id` = 1694782 OR `props-main`.`id` = 1695064 OR `props-main`.`id` = 1702846 OR `props-main`.`id` = 1698043 OR `props-main`.`id` = 1689985 OR `props-main`.`id` = 1702896 OR `props-main`.`id` = 1702953 OR `props-main`.`id` = 1696665 OR `props-main`.`id` = 1696658 OR `props-main`.`id` = 1691546 OR `props-main`.`id` = 1695906 OR `props-main`.`id` = 1698231 OR `props-main`.`id` = 1702399 OR `props-main`.`id` = 1702407 OR `props-main`.`id` = 1698232 OR `props-main`.`id` = 1700934 OR `props-main`.`id` = 1698520 OR `props-main`.`id` = 1676419 OR `props-main`.`id` = 1701222 OR `props-main`.`id` = 1701929 OR `props-main`.`id` = 1698676 OR `props-main`.`id` = 1697316 OR `props-main`.`id` = 1698233 OR `props-main`.`id` = 1686434 OR `props-main`.`id` = 1691899 OR `props-main`.`id` = 1691904 OR `props-main`.`id` = 1694231 OR `props-main`.`id` = 1694457 OR `props-main`.`id` = 1681566 OR `props-main`.`id` = 1701825 OR `props-main`.`id` = 1701822 OR `props-main`.`id` = 1701824 OR `props-main`.`id` = 1701688 OR `props-main`.`id` = 1701267 OR `props-main`.`id` = 1702583 OR `props-main`.`id` = 1702629 OR `props-main`.`id` = 1701270 OR `props-main`.`id` = 1688527 OR `props-main`.`id` = 1687309 OR `props-main`.`id` = 1686038 OR `props-main`.`id` = 1702729 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1686066 OR `props-main`.`id` = 1668427 OR `props-main`.`id` = 1692210 OR `props-main`.`id` = 1698144 OR `props-main`.`id` = 1702526 OR `props-main`.`id` = 1700105 OR `props-main`.`id` = 1694314 OR `props-main`.`id` = 1697017 OR `props-main`.`id` = 1697761 OR `props-main`.`id` = 1702719 OR `props-main`.`id` = 1697273)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642286' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-16' 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();
3
Similar Properties
$340,000
4
2
1,376
0.17
3124 W SW Tulare Ave
Visalia, CA 93277
$330,000
3
2
1,237
0.19
2634 W Iris Ave
Visalia, CA 93277
$330,000
3
2
1,140
0.14
4142 W Cambridge Ave
Visalia, CA 93277
Courtesy of Amy Medeiros, London Properties - amedeiros@londonproperties.com Last modified 15 hours ago Fresno MLS last checked for updates 29 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.
