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/tulare/240005/144-E-Parkview-Ave/Visalia/https://www.londonproperties.com/images/props/tulare/full/240005.jpgLondon Properties Visalia Real Estate | 144 E Parkview Ave
Opportunities like this in Blain Park don't come around often. This spacious 5-bedroom home is full of character and offers incredible potential for the right buyer to update and make it their own in one of Visalia's most desirable established neighborhoods. Inside, you'll find multiple living areas including a large family room and formal dining space, two fireplaces, built-ins, and abundant storage throughout - offering flexibility for everyday living and entertaining. The standout feature is the large backyard, complete with mature landscaping and an in-ground pool, perfect for enjoying Central Valley summers and hosting family and friends. A rare chance to create your vision in a prime Blain Park location with space, charm, and endless possibilities.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1986
Year Built Source
Public Records
Days On London
0
Cumulative Days On London
0
County
Tulare
New Construction
No
Stories
2
Directions to Property
Start on W Caldwell Ave & S Court St Head north on S Court St Turn right onto E Parkview Ave Home will be to the left
Roof
Wood
Heating
Central
Cooling
Central Air
# of Main Level Bathrooms
1
Bathrooms Total (Integer)
4
Full Baths
3.0
Full Baths
2
Half Baths
2
Fireplace Y/N
Yes
Fireplace Features
Gas
Private Pool
Yes
Pool Features
In Ground
Spa
No
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
2.0
APN
123 250 003 000
Lot Dimensions
Irregular
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 566199.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 625798.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2641 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3141 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` = 1648135 OR `props-main`.`id` = 1569638 OR `props-main`.`id` = 1651484 OR `props-main`.`id` = 1703204 OR `props-main`.`id` = 1703234 OR `props-main`.`id` = 1703240 OR `props-main`.`id` = 1683411 OR `props-main`.`id` = 1701500 OR `props-main`.`id` = 1703208 OR `props-main`.`id` = 1703217 OR `props-main`.`id` = 1703226 OR `props-main`.`id` = 1703252 OR `props-main`.`id` = 1709723 OR `props-main`.`id` = 1696538 OR `props-main`.`id` = 1700154 OR `props-main`.`id` = 1703194 OR `props-main`.`id` = 1671691 OR `props-main`.`id` = 1681202 OR `props-main`.`id` = 1648449 OR `props-main`.`id` = 1657266 OR `props-main`.`id` = 1684940 OR `props-main`.`id` = 1633263 OR `props-main`.`id` = 1709453 OR `props-main`.`id` = 1705659 OR `props-main`.`id` = 1705652 OR `props-main`.`id` = 1705665 OR `props-main`.`id` = 1705657 OR `props-main`.`id` = 1698166 OR `props-main`.`id` = 1708042 OR `props-main`.`id` = 1709685 OR `props-main`.`id` = 1689458 OR `props-main`.`id` = 1689662 OR `props-main`.`id` = 1706961 OR `props-main`.`id` = 1706965 OR `props-main`.`id` = 1706957 OR `props-main`.`id` = 1706974 OR `props-main`.`id` = 1706698 OR `props-main`.`id` = 1706690 OR `props-main`.`id` = 1702391 OR `props-main`.`id` = 1711374 OR `props-main`.`id` = 1706087 OR `props-main`.`id` = 1711421 OR `props-main`.`id` = 1711398 OR `props-main`.`id` = 1711400 OR `props-main`.`id` = 1711404 OR `props-main`.`id` = 1711524 OR `props-main`.`id` = 1698550 OR `props-main`.`id` = 1651784 OR `props-main`.`id` = 1702083 OR `props-main`.`id` = 1708418 OR `props-main`.`id` = 1708438 OR `props-main`.`id` = 1708419 OR `props-main`.`id` = 1681923 OR `props-main`.`id` = 1703289 OR `props-main`.`id` = 1694906 OR `props-main`.`id` = 1710092 OR `props-main`.`id` = 1704094 OR `props-main`.`id` = 1708062 OR `props-main`.`id` = 1648093 OR `props-main`.`id` = 1708319 OR `props-main`.`id` = 1694031 OR `props-main`.`id` = 1704076 OR `props-main`.`id` = 1708394 OR `props-main`.`id` = 1711409 OR `props-main`.`id` = 1702854 OR `props-main`.`id` = 1690044 OR `props-main`.`id` = 1704617 OR `props-main`.`id` = 1705847 OR `props-main`.`id` = 1709612 OR `props-main`.`id` = 1703192 OR `props-main`.`id` = 1709215 OR `props-main`.`id` = 1695569 OR `props-main`.`id` = 1710056 OR `props-main`.`id` = 1694460 OR `props-main`.`id` = 1698087 OR `props-main`.`id` = 1698128 OR `props-main`.`id` = 1694547 OR `props-main`.`id` = 1679909 OR `props-main`.`id` = 1641233 OR `props-main`.`id` = 1679937 OR `props-main`.`id` = 1701354 OR `props-main`.`id` = 1674209 OR `props-main`.`id` = 1705113 OR `props-main`.`id` = 1705141 OR `props-main`.`id` = 1704880 OR `props-main`.`id` = 1680183 OR `props-main`.`id` = 1690662 OR `props-main`.`id` = 1690664 OR `props-main`.`id` = 1708112 OR `props-main`.`id` = 1702973 OR `props-main`.`id` = 1706830 OR `props-main`.`id` = 1708013 OR `props-main`.`id` = 1688036 OR `props-main`.`id` = 1680674 OR `props-main`.`id` = 1709611 OR `props-main`.`id` = 1704628 OR `props-main`.`id` = 1704635 OR `props-main`.`id` = 1710216 OR `props-main`.`id` = 1709998 OR `props-main`.`id` = 1710182 OR `props-main`.`id` = 1693637 OR `props-main`.`id` = 1696175 OR `props-main`.`id` = 1691643 OR `props-main`.`id` = 1704197 OR `props-main`.`id` = 1690732 OR `props-main`.`id` = 1708037 OR `props-main`.`id` = 1708015 OR `props-main`.`id` = 1698498 OR `props-main`.`id` = 1702527 OR `props-main`.`id` = 1701524 OR `props-main`.`id` = 1701520 OR `props-main`.`id` = 1693990 OR `props-main`.`id` = 1694047 OR `props-main`.`id` = 1706660 OR `props-main`.`id` = 1708367 OR `props-main`.`id` = 1705732 OR `props-main`.`id` = 1704417 OR `props-main`.`id` = 1702264 OR `props-main`.`id` = 1698686 OR `props-main`.`id` = 1709446 OR `props-main`.`id` = 1704015 OR `props-main`.`id` = 1711518 OR `props-main`.`id` = 1689152 OR `props-main`.`id` = 1700934 OR `props-main`.`id` = 1698520 OR `props-main`.`id` = 1704453 OR `props-main`.`id` = 1694457 OR `props-main`.`id` = 1701825 OR `props-main`.`id` = 1701822 OR `props-main`.`id` = 1701824 OR `props-main`.`id` = 1703764 OR `props-main`.`id` = 1703728 OR `props-main`.`id` = 1704478 OR `props-main`.`id` = 1709678 OR `props-main`.`id` = 1709668 OR `props-main`.`id` = 1709694 OR `props-main`.`id` = 1709670 OR `props-main`.`id` = 1698590 OR `props-main`.`id` = 1698591 OR `props-main`.`id` = 1698580 OR `props-main`.`id` = 1698648)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240005' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-25' 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();
1
Similar Properties
$590,000
5
4
2,803
0.15
2241 E Monte Verde Ct
Visalia, CA 93292
Courtesy of Ignacio Villanueva, KW Ascend
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.
