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/239212/3159-Manchester-St/Tulare/https://www.londonproperties.com/images/props/tulare/full/239212.jpgLondon Properties Tulare Real Estate | 3159 Manchester St
Step into this beautiful 3 bedroom, 2 bathroom single family home with the blend of comfort living and modern finishes. As you step into this open concept floor plan, you will notice the modern farmhouse charm, upgraded granite countertops, stainless steel appliances, upgraded floors, and new fresh paint. This home has a split floor plan with guest bedrooms on one side and a large master suit with an oversized large walk in closet. The back yard is beautifully landscaped with newly added cement. Call today for a private showing.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2019
Year Built Source
Public Records
Days On Market
0
Cumulative Days On Market
19
County
Tulare
New Construction
No
Stories
1
Directions to Property
from cartmill and mooney head west on cartmill, north on dellavina, east on manchester home is located on the west side of the road.
Roof
Tile
Heating
Central
Cooling
Central Air
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Fireplace Y/N
No
Spa
No
Utilities
Sewer Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
2.0
APN
149 450 081 000
Lot Dimensions
9147
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 384750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 425250 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) >= 1347 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1847 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` = 1685817 OR `props-main`.`id` = 1693940 OR `props-main`.`id` = 1696785 OR `props-main`.`id` = 1702611 OR `props-main`.`id` = 1685766 OR `props-main`.`id` = 1651113 OR `props-main`.`id` = 1701353 OR `props-main`.`id` = 1692257 OR `props-main`.`id` = 1700834 OR `props-main`.`id` = 1700835 OR `props-main`.`id` = 1702607 OR `props-main`.`id` = 1701245 OR `props-main`.`id` = 1694598 OR `props-main`.`id` = 1701338 OR `props-main`.`id` = 1694599 OR `props-main`.`id` = 1660481 OR `props-main`.`id` = 1657630 OR `props-main`.`id` = 1660958 OR `props-main`.`id` = 1648117 OR `props-main`.`id` = 1685715 OR `props-main`.`id` = 1643854 OR `props-main`.`id` = 1694740 OR `props-main`.`id` = 1677929 OR `props-main`.`id` = 1636938 OR `props-main`.`id` = 1657603 OR `props-main`.`id` = 1690627 OR `props-main`.`id` = 1698877 OR `props-main`.`id` = 1701502 OR `props-main`.`id` = 1701806 OR `props-main`.`id` = 1701808 OR `props-main`.`id` = 1701810 OR `props-main`.`id` = 1701505 OR `props-main`.`id` = 1701807 OR `props-main`.`id` = 1701811 OR `props-main`.`id` = 1701812 OR `props-main`.`id` = 1684795 OR `props-main`.`id` = 1648079 OR `props-main`.`id` = 1697046 OR `props-main`.`id` = 1695290 OR `props-main`.`id` = 1695293 OR `props-main`.`id` = 1695294 OR `props-main`.`id` = 1695266 OR `props-main`.`id` = 1702732 OR `props-main`.`id` = 1701804 OR `props-main`.`id` = 1688392 OR `props-main`.`id` = 1697295 OR `props-main`.`id` = 1648872 OR `props-main`.`id` = 1698543 OR `props-main`.`id` = 1700375 OR `props-main`.`id` = 1698872 OR `props-main`.`id` = 1701650 OR `props-main`.`id` = 1688342 OR `props-main`.`id` = 1680925 OR `props-main`.`id` = 1689107 OR `props-main`.`id` = 1688528)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239212' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-14' 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();
10
Similar Properties
$419,900
4
2
1,683
0.16
182 E Kennedy Ave
Tulare, CA 93274
$399,000
3
2
1,819
0.18
1209 N N Gem St
Tulare, CA 93274
$395,790
3
3
1,662
0.07
2785 Ruby Port St #Sor21
Tulare, CA 93274
$385,190
3
3
1,494
0.08
2137 Roussanne Ave #Sor31
Tulare, CA 93274
Courtesy of Tiffany Leon, Bloom Group, Inc.
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.
