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/41151168/300-Pueblo-Ave/Modesto/https://www.londonproperties.com/images/props/crmls/full/41151168.jpgLondon Properties Modesto Real Estate | 300 Pueblo Ave
Listing Agent: Grant Alvernaz, HomePivot Listing Co-Agent: Charla Messina, HomePivot
Step into a fully renovated home that blends modern comfort with everyday practicality. This property features laminate flooring throughout, stainless appliances, designer tile and fixtures in the kitchen and bathrooms, and a bright eat in dining area perfect for family meals. Every detail has been updated, including new windows and central air and heat for year round comfort. The huge backyard lot offers endless possibilities with two large storage sheds, ideal for hobbies, tools, or outdoor projects. Located near Sutter Ave and Paradise Rd, this home delivers both convenience and space in one complete package. A move in ready opportunity with modern finishes, generous outdoor space, and a fresh contemporary feel.
Property Sub Type
Single Family Residence
Year Built
1945
Levels
One
Price Per Square Foot
$237
Days On London
0
Cumulative Days On London
0
County Or Parish
Stanislaus
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Sutter Ave.
Room Type
Bonus Room
Heating
Forced Air
Cooling
Central Air
Laundry Y/N
Yes
Roof
Shingle
Construction Materials
Stucco
Other Structures
Storage
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Room Kitchen Features
Remodeled Kitchen
Eating Area
In Kitchen
Appliances Y/N
Yes
Appliances
Gas Water Heater
Flooring
Laminate
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Parking Y/N
No
Parking Features
None
Attached Garage Y/N
No
Lot Features
Front Yard, Back Yard, Yard
Lot Size Area
7841.0000
Lot Size Units
Square Feet
Parcel Number
038031029000
Subdivision Name
Not Listed
Subdivision Name Other
Not Listed
Association Y/N
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 419895 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) >= 1438 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1938 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` = 1787507 OR `props-main`.`id` = 1764176 OR `props-main`.`id` = 1773005 OR `props-main`.`id` = 1779337 OR `props-main`.`id` = 1769016 OR `props-main`.`id` = 1717238 OR `props-main`.`id` = 1786019 OR `props-main`.`id` = 1728779 OR `props-main`.`id` = 1785448 OR `props-main`.`id` = 1777836 OR `props-main`.`id` = 1790259 OR `props-main`.`id` = 1751542 OR `props-main`.`id` = 1782537 OR `props-main`.`id` = 1790194 OR `props-main`.`id` = 1773094 OR `props-main`.`id` = 1784782 OR `props-main`.`id` = 1780856 OR `props-main`.`id` = 1789358 OR `props-main`.`id` = 1775342 OR `props-main`.`id` = 1734142 OR `props-main`.`id` = 1734141 OR `props-main`.`id` = 1789263 OR `props-main`.`id` = 1776026 OR `props-main`.`id` = 1788757 OR `props-main`.`id` = 1788755 OR `props-main`.`id` = 1786875 OR `props-main`.`id` = 1790915 OR `props-main`.`id` = 1747606 OR `props-main`.`id` = 1781934 OR `props-main`.`id` = 1774664 OR `props-main`.`id` = 1737121 OR `props-main`.`id` = 1786865 OR `props-main`.`id` = 1777024 OR `props-main`.`id` = 1773868 OR `props-main`.`id` = 1781923 OR `props-main`.`id` = 1789857 OR `props-main`.`id` = 1716375 OR `props-main`.`id` = 1733150 OR `props-main`.`id` = 1781426 OR `props-main`.`id` = 1786460 OR `props-main`.`id` = 1788722 OR `props-main`.`id` = 1768659 OR `props-main`.`id` = 1778552 OR `props-main`.`id` = 1723143 OR `props-main`.`id` = 1700083 OR `props-main`.`id` = 1779369 OR `props-main`.`id` = 1781766 OR `props-main`.`id` = 1775809 OR `props-main`.`id` = 1760650 OR `props-main`.`id` = 1704117 OR `props-main`.`id` = 1786648 OR `props-main`.`id` = 1761876 OR `props-main`.`id` = 1786899 OR `props-main`.`id` = 1790401 OR `props-main`.`id` = 1758492 OR `props-main`.`id` = 1790238 OR `props-main`.`id` = 1790233 OR `props-main`.`id` = 1790223 OR `props-main`.`id` = 1788661 OR `props-main`.`id` = 1781924 OR `props-main`.`id` = 1771840 OR `props-main`.`id` = 1771587 OR `props-main`.`id` = 1790887 OR `props-main`.`id` = 1781909 OR `props-main`.`id` = 1746711 OR `props-main`.`id` = 1773925 OR `props-main`.`id` = 1786690 OR `props-main`.`id` = 1782650 OR `props-main`.`id` = 1771618)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41151168' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-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();
4
Similar Properties
$415,000
3
2
1,460
0.11
2032 Boise Ave
Modesto, CA 95358
$399,000
3
3
1,483
0.06
1766 Norwood Heights Ln
Ceres, CA 95307
$389,000
3
2
1,594
0.14
1530 Glenn Ave
Modesto, CA 95358
$379,950
4
2
1,567
0.15
921 Atlantic Dr
Modesto, CA 95358
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.
