Courtesy of Jon Motsenbocker, Real Brokerage Technologies - [email protected]
Opportunity in Antioch! This single-family home offers a chance for buyers, investors, or contractors looking for a property with significant upside potential. The home is being sold in its current condition and may require substantial repairs and improvements. Bring your vision and explore the possibilities. This is a short sale and all terms are subject to lender approval. Property is being sold AS-IS. Seller will not make repairs or provide credits for property condition. Buyer to conduct all desired inspections and independently verify property condition, square footage, permits, and all other information. Please submit offers with proof of funds or financing documentation. Allow additional time for short-sale lender review and approval.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1947
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$60
Price Per Acre
$455,602
Days On London
0
Cumulative Days On London
0
County
Contra Costa
REO / Bank Owned
No
Cross Street Address
L Street & W 18th Street
Directions
From Hwy 4, take the L Street exit and head north. Continue on L Street, turn left onto W 18th St, then right onto D Street, and continue toward W Madill St. Property is located at 540 W Madill St, Antioch.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Metal
Foundation
Concrete
Primary Bedroom Level
Main
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Are there garage spaces?
No
APN
067 301 026 0
School District
Antioch Unified
School Type 1
High School
School Name 1
Antioch High
School Type 2
Junior High School
School Name 2
Antioch Middle
School Type 3
Grade School
School Name 3
Marsh
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 52155 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 57645 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 665 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1165 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` = 1792708)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654022' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-17' 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
Last modified 2 hours ago Fresno MLS last checked for updates 15 minutes ago
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.
