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/metrolist/225122853/9015-Tee-Box-Ct/Patterson/https://www.londonproperties.com/images/props/metrolist/full/225122853.jpgLondon Properties Patterson Real Estate | 9015 Tee Box Ct
Welcome to 9015 Tee Box Ct - this property is offering nearly 3,000 square feet of elegant living space. Located on a peaceful court with scenic views, this 4-bedroom, 3.5-bathroom residence provides comfort and privacy. The thoughtfully designed floor plan features a downstairs bedroom with a full bath, perfect for guests or multi-generational living. Upstairs, you'll find a spacious loftideal for a media room, home office, or play areaalong with a convenient upstairs laundry room. Entertain with ease in the open-concept kitchen, which flows into a large living area with bar seating. Step outside to a private backyard where mature oak trees and hillside views create a serene, natural setting. This home is nestled within the secure, gated community of Diablo Grande, which offers 24-hour guarded entry. Enjoy the perfect blend of tranquility and convenience, with shopping just 15 minutes away and I-5 just 10 minutes away. Come, see and fall in LOVE with 9015 Tee Box Court!
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 524998.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2717 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3217 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` = 1697662 OR `props-main`.`id` = 1693982 OR `props-main`.`id` = 1677329 OR `props-main`.`id` = 1688897 OR `props-main`.`id` = 1690718 OR `props-main`.`id` = 1694754 OR `props-main`.`id` = 1689654 OR `props-main`.`id` = 1676142 OR `props-main`.`id` = 1695242 OR `props-main`.`id` = 1689342 OR `props-main`.`id` = 1642987 OR `props-main`.`id` = 1679865 OR `props-main`.`id` = 1668687 OR `props-main`.`id` = 1694888 OR `props-main`.`id` = 1691441 OR `props-main`.`id` = 1687390 OR `props-main`.`id` = 1693914 OR `props-main`.`id` = 1678618 OR `props-main`.`id` = 1688261 OR `props-main`.`id` = 1693915 OR `props-main`.`id` = 1685220 OR `props-main`.`id` = 1685223 OR `props-main`.`id` = 1685227 OR `props-main`.`id` = 1685225 OR `props-main`.`id` = 1693226 OR `props-main`.`id` = 1656966 OR `props-main`.`id` = 1685229 OR `props-main`.`id` = 1685224 OR `props-main`.`id` = 1679258 OR `props-main`.`id` = 1685222 OR `props-main`.`id` = 1685221 OR `props-main`.`id` = 1685226 OR `props-main`.`id` = 1685228 OR `props-main`.`id` = 1697671 OR `props-main`.`id` = 1641208 OR `props-main`.`id` = 1659476 OR `props-main`.`id` = 1686162 OR `props-main`.`id` = 1693309)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225122853' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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 Michael Meneses, PMZ Real Estate IDX provided by Reliance Marketing
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.
