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/fresno/654456/402-Mary-St/Bakersfield/https://www.londonproperties.com/images/props/fresno/full/654456.jpgLondon Properties Bakersfield Real Estate | 402 Mary St
Courtesy of Roger Magana, Golden Valley Real Estate Group - [email protected]
Welcome to Maricopa, CA! This charming 3-bedroom, 2-bathroom home has been thoughtfully remodeled and is ready for its new owners. Featuring new flooring, fresh interior paint, granite countertops, beautiful white cabinetry, and modern lighting throughout, this home offers a fresh and inviting feel.The spacious backyard provides plenty of room to entertain, garden, or enjoy the outdoors, with abundant potential for future improvements. The large lot may also offer the possibility of adding an ADU, buyer to verify with the appropriate city/county agencies.Don't miss this fantastic opportunity to own a beautifully updated home with plenty of potential in Maricopa! Contact your favorite Realtor today to schedule a private showing.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1940
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$243
Price Per Acre
$1,588,462
Days On London
0
Cumulative Days On London
0
County
Kern
REO / Bank Owned
No
Cross Street Address
California St/ Union St
Directions
Off Hwy 33 S, turn right onto Union St, then left onto Mary St. Property is at 402 Mary St.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Flooring
Laminate
Exterior
Wood
Pool
No
Pool
No
Patio Features
Uncovered
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Parking Features
Existing RV Parking
Are there garage spaces?
No
APN
042 112 100 1
Zoning
R1
School District
Maricopa Unified
School Type 1
High School
School Name 1
Maricopa High
School Type 2
Junior High School
School Name 2
Maricopa Middle
School Type 3
Grade School
School Name 3
Maricopa Elementary
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 196175 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 216825 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) >= 599 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1099 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` = 1709936 OR `props-main`.`id` = 1749112 OR `props-main`.`id` = 1739052 OR `props-main`.`id` = 1768998 OR `props-main`.`id` = 1755476 OR `props-main`.`id` = 1753061)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654456' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-28' 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 3 hours ago Fresno MLS last checked for updates 23 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.
