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/644839/2425-N-Divisadero-St/Visalia/https://www.londonproperties.com/images/props/fresno/full/644839.jpgLondon Properties Visalia Real Estate | 2425 N Divisadero St
Beautiful two-story Lennar home offering 4 bedrooms and 3 full bathrooms, including a desirable downstairs mother-in-law suite perfect for guests or multi-generational living. The spacious open-concept floor plan creates a seamless flow between the living room, dining area, and kitchen, making it ideal for both everyday living and entertaining. The kitchen features ample cabinetry, generous counter space, and a large island overlooking the main living area. Natural light fills the home, highlighting the warm finishes and inviting atmosphere throughout. Step outside to enjoy great curb appeal and a spacious backyard with plenty of room to relax, garden, or host gatherings. Conveniently located near parks, schools, and shopping, this home offers comfort, flexibility, and space to grow.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2018
Region
Urban
# of Stories
Two
Price Per Square Foot
$179
Price Per Acre
$3,631,082
Days On London
2
Cumulative Days On London
2
County
Tulare
Leased Equipment
Security System, Solar Panels
Special Features
Security System
REO / Bank Owned
No
Cross Street Address
Ferguson Ave & N Mooney ave
Directions
Eastbound on Riggin Ave, turn right onto N Mooney Blvd then left on Sunnyview and left onto N Elm. Elm becomes Modoc Ave. Turn right on Divisadero
Unit Description
Rear
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, On Upper Level
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Dishwasher, Microwave, Breakfast Bar, Pantry
Dining Room Features
Living Room/Area
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower, Tub
Flooring
Tile, Vinyl
Exterior
Stucco
Pool
No
Pool
No
Yard
Sprinklers Front
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Lease
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
3
APN
090 010 045
School District
Visalia Schools
School Type 1
High School
School Name 1
Golden West
School Type 2
Junior High School
School Name 2
Valley Oak
School Type 3
Grade School
School Name 3
Riverway Elementary
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 475000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 525000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2547 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3047 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` = 1704478 OR `props-main`.`id` = 1687309 OR `props-main`.`id` = 1704261 OR `props-main`.`id` = 1713908 OR `props-main`.`id` = 1713909 OR `props-main`.`id` = 1713907 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1704533 OR `props-main`.`id` = 1713898 OR `props-main`.`id` = 1698144 OR `props-main`.`id` = 1712365 OR `props-main`.`id` = 1713929 OR `props-main`.`id` = 1703702 OR `props-main`.`id` = 1694314 OR `props-main`.`id` = 1685845 OR `props-main`.`id` = 1712652 OR `props-main`.`id` = 1689104 OR `props-main`.`id` = 1713712 OR `props-main`.`id` = 1713658 OR `props-main`.`id` = 1705455 OR `props-main`.`id` = 1702780 OR `props-main`.`id` = 1711580 OR `props-main`.`id` = 1711534 OR `props-main`.`id` = 1690281 OR `props-main`.`id` = 1712646 OR `props-main`.`id` = 1711298 OR `props-main`.`id` = 1711291 OR `props-main`.`id` = 1711300 OR `props-main`.`id` = 1711292 OR `props-main`.`id` = 1703268 OR `props-main`.`id` = 1698521 OR `props-main`.`id` = 1692256 OR `props-main`.`id` = 1697926 OR `props-main`.`id` = 1705331 OR `props-main`.`id` = 1705134 OR `props-main`.`id` = 1706794 OR `props-main`.`id` = 1712593 OR `props-main`.`id` = 1663396 OR `props-main`.`id` = 1650946 OR `props-main`.`id` = 1707093 OR `props-main`.`id` = 1704155 OR `props-main`.`id` = 1678402 OR `props-main`.`id` = 1707025 OR `props-main`.`id` = 1704319 OR `props-main`.`id` = 1688666 OR `props-main`.`id` = 1704216 OR `props-main`.`id` = 1702293 OR `props-main`.`id` = 1712887 OR `props-main`.`id` = 1703875 OR `props-main`.`id` = 1713674 OR `props-main`.`id` = 1713918 OR `props-main`.`id` = 1698173 OR `props-main`.`id` = 1708188 OR `props-main`.`id` = 1686098 OR `props-main`.`id` = 1713097 OR `props-main`.`id` = 1712530 OR `props-main`.`id` = 1712498 OR `props-main`.`id` = 1695984 OR `props-main`.`id` = 1706115 OR `props-main`.`id` = 1712569 OR `props-main`.`id` = 1704019 OR `props-main`.`id` = 1703173 OR `props-main`.`id` = 1648087 OR `props-main`.`id` = 1701591 OR `props-main`.`id` = 1712570 OR `props-main`.`id` = 1701592 OR `props-main`.`id` = 1703329 OR `props-main`.`id` = 1713626 OR `props-main`.`id` = 1711334 OR `props-main`.`id` = 1712573 OR `props-main`.`id` = 1712587 OR `props-main`.`id` = 1713653 OR `props-main`.`id` = 1704510 OR `props-main`.`id` = 1712354 OR `props-main`.`id` = 1712338 OR `props-main`.`id` = 1713824 OR `props-main`.`id` = 1703384 OR `props-main`.`id` = 1695697 OR `props-main`.`id` = 1704109 OR `props-main`.`id` = 1711367 OR `props-main`.`id` = 1704073 OR `props-main`.`id` = 1704406 OR `props-main`.`id` = 1709491 OR `props-main`.`id` = 1671529 OR `props-main`.`id` = 1671562 OR `props-main`.`id` = 1703785 OR `props-main`.`id` = 1697705 OR `props-main`.`id` = 1697719 OR `props-main`.`id` = 1697708 OR `props-main`.`id` = 1697728 OR `props-main`.`id` = 1709669 OR `props-main`.`id` = 1689648 OR `props-main`.`id` = 1690520 OR `props-main`.`id` = 1657899 OR `props-main`.`id` = 1710287 OR `props-main`.`id` = 1701377 OR `props-main`.`id` = 1701382 OR `props-main`.`id` = 1705166 OR `props-main`.`id` = 1701742 OR `props-main`.`id` = 1701381 OR `props-main`.`id` = 1706122 OR `props-main`.`id` = 1706867 OR `props-main`.`id` = 1708366 OR `props-main`.`id` = 1702211 OR `props-main`.`id` = 1687411 OR `props-main`.`id` = 1701240 OR `props-main`.`id` = 1697177 OR `props-main`.`id` = 1709495 OR `props-main`.`id` = 1709503 OR `props-main`.`id` = 1704928 OR `props-main`.`id` = 1712366 OR `props-main`.`id` = 1708271 OR `props-main`.`id` = 1713776 OR `props-main`.`id` = 1648083 OR `props-main`.`id` = 1345585 OR `props-main`.`id` = 1693526)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644839' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-07' 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();
2
Similar Properties
$515,000
5
4
2,554
0.15
3310 N Church St
Visalia, CA 93291
$475,000
5
3
2,819
0.14
2145 N Rinaldi Ct
Visalia, CA 93291
Courtesy of Zeke Chavez, Real Broker - [email protected] Last modified 12 hours ago Fresno MLS last checked for updates 35 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.
