Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/652819/4833-W-Ashland-Ave/Visalia/https://www.londonproperties.com/images/props/fresno/full/652819.jpgLondon Properties Visalia Real Estate | 4833 W Ashland Ave
Courtesy of Debra White, Real Brokerage Technologies - [email protected]
Cool Off this summer with your own Swimming Pool ! This inviting 3-bedroom, 2-bath home offering 1,475 square feet of comfortable living space on a desirable corner lot in Northwest Visalia and walking distance to El Diamante High School. Inside, you'll find laminate flooring throughout and an updated kitchen featuring granite countertops, a double oven, decorative backsplash, and ample workspace for everyday cooking and entertaining. The spacious primary suite includes a French door to the patio, beautifully updated bathroom with a walk-in shower, dual sinks, and a walk-in closet. A separate laundry room provides added convenience. Step outside to your own private backyard retreat, complete with a swimming pool, spa, Alumawood-covered patio, mature landscaping, and outdoor storage sheds. The landscaped front and back yards offer plenty of space to relax, entertain, and enjoy Central Valley living. Conveniently located near schools, shopping, dining, parks, and major roadways, this well-maintained Visalia home is ready for its next owner. Make an appointment today before it's gone !
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2001
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$271
Price Per Acre
$2,475,186
Days On London
0
Cumulative Days On London
0
County
Tulare
REO / Bank Owned
No
Cross Street Address
Crenshaw
Directions
From 198 and Akers, go S on Akers, E on Whitendale, N on Crenshaw to Ashland
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Tile
Foundation
Concrete
Detached Structures
Shed
Kitchen
Gas Appliances, Dishwasher, Microwave, Refrigerator
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
Yes
Spa Type
In Ground
Patio Features
Covered
Yard
Sprinklers Front, Mature Landscape
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Parking Features
Potential RV Parking
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
Site Amenities
Corner
APN
119 590 040
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
Linwood
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 418950 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) >= 1225 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1725 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` = 1746321 OR `props-main`.`id` = 1752430 OR `props-main`.`id` = 1751925 OR `props-main`.`id` = 1715653 OR `props-main`.`id` = 1734717 OR `props-main`.`id` = 1722131 OR `props-main`.`id` = 1724756 OR `props-main`.`id` = 1719439 OR `props-main`.`id` = 1752322 OR `props-main`.`id` = 1752294 OR `props-main`.`id` = 1733444 OR `props-main`.`id` = 1719144 OR `props-main`.`id` = 1709722 OR `props-main`.`id` = 1709229 OR `props-main`.`id` = 1751667 OR `props-main`.`id` = 1728469 OR `props-main`.`id` = 1719891 OR `props-main`.`id` = 1742713 OR `props-main`.`id` = 1742636 OR `props-main`.`id` = 1742682 OR `props-main`.`id` = 1739986 OR `props-main`.`id` = 1742781 OR `props-main`.`id` = 1737432 OR `props-main`.`id` = 1739985 OR `props-main`.`id` = 1742745 OR `props-main`.`id` = 1616928 OR `props-main`.`id` = 1744679 OR `props-main`.`id` = 1742661 OR `props-main`.`id` = 1707104 OR `props-main`.`id` = 1749762 OR `props-main`.`id` = 1749806 OR `props-main`.`id` = 1746506 OR `props-main`.`id` = 1747809 OR `props-main`.`id` = 1744777 OR `props-main`.`id` = 1744776 OR `props-main`.`id` = 1744800 OR `props-main`.`id` = 1747158 OR `props-main`.`id` = 1753503 OR `props-main`.`id` = 1733898 OR `props-main`.`id` = 1746493 OR `props-main`.`id` = 1745597 OR `props-main`.`id` = 1745743 OR `props-main`.`id` = 1739207 OR `props-main`.`id` = 1739210 OR `props-main`.`id` = 1727448 OR `props-main`.`id` = 1721330 OR `props-main`.`id` = 1747752 OR `props-main`.`id` = 1753738 OR `props-main`.`id` = 1737676 OR `props-main`.`id` = 1737654 OR `props-main`.`id` = 1747571 OR `props-main`.`id` = 1745594 OR `props-main`.`id` = 1681923 OR `props-main`.`id` = 1749868 OR `props-main`.`id` = 1746864 OR `props-main`.`id` = 1749375 OR `props-main`.`id` = 1722713 OR `props-main`.`id` = 1710092 OR `props-main`.`id` = 1720113 OR `props-main`.`id` = 1752346 OR `props-main`.`id` = 1752095 OR `props-main`.`id` = 1752350 OR `props-main`.`id` = 1712729 OR `props-main`.`id` = 1717921 OR `props-main`.`id` = 1748467 OR `props-main`.`id` = 1702854 OR `props-main`.`id` = 1754686 OR `props-main`.`id` = 1754691 OR `props-main`.`id` = 1754695 OR `props-main`.`id` = 1720925 OR `props-main`.`id` = 1721635 OR `props-main`.`id` = 1720924 OR `props-main`.`id` = 1721631 OR `props-main`.`id` = 1729947 OR `props-main`.`id` = 1729968 OR `props-main`.`id` = 1729983 OR `props-main`.`id` = 1729940 OR `props-main`.`id` = 1744300 OR `props-main`.`id` = 1725248 OR `props-main`.`id` = 1716112 OR `props-main`.`id` = 1754497 OR `props-main`.`id` = 1731039 OR `props-main`.`id` = 1731038 OR `props-main`.`id` = 1731044 OR `props-main`.`id` = 1721149 OR `props-main`.`id` = 1752348 OR `props-main`.`id` = 1740022 OR `props-main`.`id` = 1748579 OR `props-main`.`id` = 1728452 OR `props-main`.`id` = 1752733 OR `props-main`.`id` = 1754152 OR `props-main`.`id` = 1719621 OR `props-main`.`id` = 1745878 OR `props-main`.`id` = 1719622 OR `props-main`.`id` = 1746655 OR `props-main`.`id` = 1735832 OR `props-main`.`id` = 1745876 OR `props-main`.`id` = 1702399 OR `props-main`.`id` = 1702407 OR `props-main`.`id` = 1692035 OR `props-main`.`id` = 1752308 OR `props-main`.`id` = 1700934 OR `props-main`.`id` = 1737629 OR `props-main`.`id` = 1753089 OR `props-main`.`id` = 1706994 OR `props-main`.`id` = 1706995 OR `props-main`.`id` = 1752299 OR `props-main`.`id` = 1737437 OR `props-main`.`id` = 1741450 OR `props-main`.`id` = 1724438 OR `props-main`.`id` = 1750084 OR `props-main`.`id` = 1750098 OR `props-main`.`id` = 1752107 OR `props-main`.`id` = 1752146 OR `props-main`.`id` = 1752151 OR `props-main`.`id` = 1752098 OR `props-main`.`id` = 1752297 OR `props-main`.`id` = 1752296 OR `props-main`.`id` = 1752298 OR `props-main`.`id` = 1745749 OR `props-main`.`id` = 1739307 OR `props-main`.`id` = 1741076 OR `props-main`.`id` = 1747189 OR `props-main`.`id` = 1751442 OR `props-main`.`id` = 1754514 OR `props-main`.`id` = 1741087 OR `props-main`.`id` = 1731846 OR `props-main`.`id` = 1738869 OR `props-main`.`id` = 1744749 OR `props-main`.`id` = 1752316 OR `props-main`.`id` = 1744767 OR `props-main`.`id` = 1722976 OR `props-main`.`id` = 1728430 OR `props-main`.`id` = 1728416 OR `props-main`.`id` = 1728422 OR `props-main`.`id` = 1728426 OR `props-main`.`id` = 1752323 OR `props-main`.`id` = 1752326 OR `props-main`.`id` = 1744748 OR `props-main`.`id` = 1746826 OR `props-main`.`id` = 1754474 OR `props-main`.`id` = 1753581 OR `props-main`.`id` = 1726163 OR `props-main`.`id` = 1726156 OR `props-main`.`id` = 1726138 OR `props-main`.`id` = 1739495)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652819' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-29' 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();
7
Similar Properties
$400,000
3
2
1,656
0.15
900 N Oakwood Ct
Visalia, CA 93291
$398,000
3
2
1,406
0.21
3731 S Mountain
Visalia, CA 93277
$389,900
3
2
1,555
0.19
3533 W Whitendale Ave
Visalia, CA 93277
$384,900
3
2
1,492
0.17
851 N Crenshaw St
Visalia, CA 93291
Last modified 2 hours ago Fresno MLS last checked for updates 15 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.
