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/crmls/ML82029781/4009-Bella-Tuscany-Dr/Modesto/https://www.londonproperties.com/images/props/crmls/full/ML82029781.jpgLondon Properties Modesto Real Estate | 4009 Bella Tuscany Dr
Welcome to 4009 Bella Tuscany Drive, a beautifully maintained 5-bedroom, 3-bath home offering both space and comfort. The home features separate living and dining rooms, wide hallways and staircases, and abundant natural light throughout. The private backyard boasts a large patio and a sparkling poolideal for entertaining or relaxing. Located in the heart of the desirable Tuscany Subdivision, the property is conveniently situated near Vintage Faire Mall with easy freeway access. A true must-see.
Property Sub Type
Single Family Residence
Year Built
2000
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Price Per Square Foot
$251
Days On Market
21
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Head west on Snyder Ave, turn right on Bella Tuscany Ave, home on the left. Cross Street: Snyder Ave
Roof
Tile
Foundation Details
Slab
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Eating Area
In Living Room
Appliances Y/N
No
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Spa Y/N
Yes
Utilities
Natural Gas Available
Water Source
Public
Sewer
Public Sewer
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Size Area
8808.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
078056003000
Zoning
R-1
Association Y/N
No
High School District
Other
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 644100 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 711900 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) >= 2456 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2956 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` = 1695330 OR `props-main`.`id` = 1703498 OR `props-main`.`id` = 1625562 OR `props-main`.`id` = 1699737 OR `props-main`.`id` = 1703119 OR `props-main`.`id` = 1700458 OR `props-main`.`id` = 1698185 OR `props-main`.`id` = 1703035 OR `props-main`.`id` = 1694191 OR `props-main`.`id` = 1693981 OR `props-main`.`id` = 1702668 OR `props-main`.`id` = 1702731 OR `props-main`.`id` = 1703076 OR `props-main`.`id` = 1686715 OR `props-main`.`id` = 1694263 OR `props-main`.`id` = 1702332 OR `props-main`.`id` = 1694971 OR `props-main`.`id` = 1702995 OR `props-main`.`id` = 1702632 OR `props-main`.`id` = 1703391 OR `props-main`.`id` = 1690026 OR `props-main`.`id` = 1702834 OR `props-main`.`id` = 1691431 OR `props-main`.`id` = 1695291 OR `props-main`.`id` = 1698431 OR `props-main`.`id` = 1702636 OR `props-main`.`id` = 1702554 OR `props-main`.`id` = 1676779 OR `props-main`.`id` = 1701764 OR `props-main`.`id` = 1684831 OR `props-main`.`id` = 1701117 OR `props-main`.`id` = 1700858 OR `props-main`.`id` = 1703330 OR `props-main`.`id` = 1702818 OR `props-main`.`id` = 1702823 OR `props-main`.`id` = 1694633 OR `props-main`.`id` = 1688375 OR `props-main`.`id` = 1686953 OR `props-main`.`id` = 1679295 OR `props-main`.`id` = 1700828 OR `props-main`.`id` = 1699969 OR `props-main`.`id` = 1697504 OR `props-main`.`id` = 1684985 OR `props-main`.`id` = 1703470 OR `props-main`.`id` = 1698851 OR `props-main`.`id` = 1702385 OR `props-main`.`id` = 1694579 OR `props-main`.`id` = 1694304 OR `props-main`.`id` = 1691724 OR `props-main`.`id` = 1703627)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82029781' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-21' 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
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.
