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/243621/587-E-Camelia-Ave/Tulare/https://www.londonproperties.com/images/props/tulare/full/243621.jpgLondon Properties Tulare Real Estate | 587 E Camelia Ave
This is the Full Package!! Welcome to 587 E Camelia Avenue! Pride of ownership shines throughout this entire home! Turn Key doesn't describe the quality of upgrades the owners have done and have maintained in the utmost Care! The kitchen has been remodeled with Quartzsite countertops, beautiful cabinetry, wood floors throughout! Top of line appliances! 4 bedroom, 3 baths! Primary bedroom and bath is set up with high end toiletries including a Toto Bidet! This single story home has a fantastic layout! The backyard is a families dream! Huge backyard, pool, spa and Outdoor Kitchen tops it off for those long summer nights! 39 Paid Solar Panels are also included! The front of the home is beautiful with the professional landscape and new stone added to the outdoor entry! The neighborhood is one of Tulare's finest, surrounded by beautiful homes and great neighbors! Make this your next and final home!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1978
Year Built Source
Assessor
Days On London
1
Cumulative Days On London
1
County
Tulare
Property Condition
Updated/Remodeled
New Construction
No
Stories
1
Directions to Property
From Prosperity go North on Gem St. Home is on the corner of Gem and Camelia
Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
2.0
APN
166 040 000 000
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 807500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 892500 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) >= 2102 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2602 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` = 1729292 OR `props-main`.`id` = 1731907 OR `props-main`.`id` = 1731070 OR `props-main`.`id` = 1725695 OR `props-main`.`id` = 1763948 OR `props-main`.`id` = 1762035 OR `props-main`.`id` = 1755447 OR `props-main`.`id` = 1766675 OR `props-main`.`id` = 1755089 OR `props-main`.`id` = 1756258 OR `props-main`.`id` = 1755422 OR `props-main`.`id` = 1755449 OR `props-main`.`id` = 1767395 OR `props-main`.`id` = 1717106 OR `props-main`.`id` = 1720520 OR `props-main`.`id` = 1755406 OR `props-main`.`id` = 1755404 OR `props-main`.`id` = 1762056 OR `props-main`.`id` = 1728113 OR `props-main`.`id` = 1755401 OR `props-main`.`id` = 1767617 OR `props-main`.`id` = 1722155 OR `props-main`.`id` = 1716994 OR `props-main`.`id` = 1753744 OR `props-main`.`id` = 1725486 OR `props-main`.`id` = 1725920 OR `props-main`.`id` = 1728588 OR `props-main`.`id` = 1762790 OR `props-main`.`id` = 1762797 OR `props-main`.`id` = 1763402 OR `props-main`.`id` = 1740835 OR `props-main`.`id` = 1760884 OR `props-main`.`id` = 1761707 OR `props-main`.`id` = 1733382 OR `props-main`.`id` = 1733342 OR `props-main`.`id` = 1733388 OR `props-main`.`id` = 1735820 OR `props-main`.`id` = 1747640 OR `props-main`.`id` = 1753034 OR `props-main`.`id` = 1752947 OR `props-main`.`id` = 1753427 OR `props-main`.`id` = 1724772 OR `props-main`.`id` = 1724773 OR `props-main`.`id` = 1709147 OR `props-main`.`id` = 1717233 OR `props-main`.`id` = 1720588 OR `props-main`.`id` = 1725304 OR `props-main`.`id` = 1756002 OR `props-main`.`id` = 1756006 OR `props-main`.`id` = 1756005 OR `props-main`.`id` = 1756007 OR `props-main`.`id` = 1755484 OR `props-main`.`id` = 1756004 OR `props-main`.`id` = 1736796 OR `props-main`.`id` = 1752344 OR `props-main`.`id` = 1737704 OR `props-main`.`id` = 1725240 OR `props-main`.`id` = 1757165 OR `props-main`.`id` = 1736244 OR `props-main`.`id` = 1746235 OR `props-main`.`id` = 1748996 OR `props-main`.`id` = 1762363 OR `props-main`.`id` = 1767588 OR `props-main`.`id` = 1748963 OR `props-main`.`id` = 1732860 OR `props-main`.`id` = 1736324 OR `props-main`.`id` = 1705626 OR `props-main`.`id` = 1753184 OR `props-main`.`id` = 1762758 OR `props-main`.`id` = 1747604 OR `props-main`.`id` = 1746778 OR `props-main`.`id` = 1747605 OR `props-main`.`id` = 1762759 OR `props-main`.`id` = 1660481 OR `props-main`.`id` = 1760558 OR `props-main`.`id` = 1727120 OR `props-main`.`id` = 1722536 OR `props-main`.`id` = 1727693 OR `props-main`.`id` = 1753054 OR `props-main`.`id` = 1643854 OR `props-main`.`id` = 1726412 OR `props-main`.`id` = 1763554 OR `props-main`.`id` = 1677929 OR `props-main`.`id` = 1726625 OR `props-main`.`id` = 1752619 OR `props-main`.`id` = 1763427 OR `props-main`.`id` = 1701505 OR `props-main`.`id` = 1762614 OR `props-main`.`id` = 1719473 OR `props-main`.`id` = 1757437 OR `props-main`.`id` = 1757436 OR `props-main`.`id` = 1757438 OR `props-main`.`id` = 1757439 OR `props-main`.`id` = 1757440 OR `props-main`.`id` = 1757441 OR `props-main`.`id` = 1719866 OR `props-main`.`id` = 1719864 OR `props-main`.`id` = 1763030 OR `props-main`.`id` = 1760506 OR `props-main`.`id` = 1755402 OR `props-main`.`id` = 1716986 OR `props-main`.`id` = 1719975)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare243621' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-26' 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
Courtesy of Victoria Fernandes, Town Land and Coast Realty
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.
