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/239161/1336-Red-Teal-Dr/Newman/https://www.londonproperties.com/images/props/tulare/full/239161.jpgLondon Properties Newman Real Estate | 1336 Red Teal Dr
This 5-bedroom, 3-bath, well-designed living space home has it all! On the first floor features the kitchen opens to the breakfast nook and family room creating the perfect open concept layout. High ceiling in the living room and dinning room. One bedroom downstairs that can be used as an office. Upstairs features the Primary bedroom with a big retreat room and three additional bedrooms. This property has been totally remodeled from the past few years with new kitchen, flooring, AC, Heating and painting inside and outside of the house. This property won't last long!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1990
Year Built Source
Public Records
Days On Market
0
Cumulative Days On Market
0
County
Other
New Construction
No
Stories
2
Current Use
Residential
Directions to Property
Take Hwy 33, turn East on Driskell, make a right on Decoy and a Left on Red Teal . The house is on the corner.
Construction Materials
Frame, Stucco
Foundation Details
Slab
Roof
Tile
Heating
Central, Natural Gas
Cooling
Ceiling Fan(s), Central Air, Electric
Laundry Features
Inside, Laundry Room
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s)
Direction Faces
North
Interior Features
Pantry
# of Main Level Bathrooms
1
Bathrooms Total (Integer)
3
Full Baths
3.0
Full Baths
3
Appliances
Dishwasher, Disposal, Gas Oven, Gas Range, Gas Water Heater, Range Hood
Fireplace Y/N
Yes
Fireplace Features
Family Room, Gas, Masonry
Flooring
Carpet, Laminate
Spa
No
Utilities
Cable Connected, Electricity Connected, Natural Gas Connected, Phone Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
3.0
APN
049 051 004 000
Lot Features
Back Yard, Corner Lot, Front Yard, Irregular Lot
Lot Dimensions
Irregular
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 541405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 598395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2142 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2642 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` = 1701051 OR `props-main`.`id` = 1701948 OR `props-main`.`id` = 1701659 OR `props-main`.`id` = 1685945 OR `props-main`.`id` = 1698726 OR `props-main`.`id` = 1695960 OR `props-main`.`id` = 1700993 OR `props-main`.`id` = 1691915 OR `props-main`.`id` = 1700700 OR `props-main`.`id` = 1701980 OR `props-main`.`id` = 1637376 OR `props-main`.`id` = 1700944 OR `props-main`.`id` = 1676769 OR `props-main`.`id` = 1701032 OR `props-main`.`id` = 1701463 OR `props-main`.`id` = 1702169 OR `props-main`.`id` = 1689819 OR `props-main`.`id` = 1677324 OR `props-main`.`id` = 1677331 OR `props-main`.`id` = 1690708 OR `props-main`.`id` = 1700895 OR `props-main`.`id` = 1699120 OR `props-main`.`id` = 1673332 OR `props-main`.`id` = 1694772 OR `props-main`.`id` = 1700149 OR `props-main`.`id` = 1695411 OR `props-main`.`id` = 1700341)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239161' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-10' 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 Gilberto Padron, Central Valley 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.
