Refine Search
Sort by
$499,000
CC41143007 MLS
PRIME DUAL-PARCEL DEVELOPMENT OPPORTUNITY IN OAKLAND! Exceptional flexibility and investment potential on a high-visibility MacArthur Blvd transit corridor. Offered at $499,000 across two level, contiguous lots (~10,014 SF total; APNs 046-5490-003-00 & 046-5490-004-00), this site features two distinct, city-reviewed project paths for non-profit and private market-rate developers. OPTION 1: DENSE AFFORDABLE / SUPPORTIVE HOUSING (49 UNITS) Leverage approved 2023 design review plans under CA AB 2162 ministerial, by-right streamlining. Plans specify a 6-story, 37,361 GSF podium building featuring 49 total units (48 studios + 1 manager unit), 7,450 SF of ground-floor supportive/common service space, and 23 garage parking spaces. Unbeatable acquisition land basis of ~$10,183/door and $13.36/buildable GSF, making it highly competitive for LIHTC non-profit tax credit funding. OPTION 2: PRIVATE / MARKET-RATE INFILL (8 UNITS + COMMERCIAL) For traditional builders seeking simpler construction, the site previously received Development Permit approval (PLN19039) for a 3-story mixed-use project featuring 8 residential townhomes (19,125 SF total) and 1,200 SF of ground-floor retail.

9809 Macarthur Blvd, Oakland

Listed by Marcin Grobelny, (925) 408-0682 from Prominent Realty & Funding
(If provided) CoList: from

$1,549,000
4 Beds 3 Baths CC41142136 MLS
Spectacular 6 acre property in a gorgeous Palomares Valley setting, minutes to freeway, with private gate entrance, creekside with bridge accessing huge flat area, pool & spa, single story home beautiful hardwood floors with huge family room, updated kitchen, Granite Counters, Viking Refrigerator, New Gas Range, and more...Detached 4 Car Garage with separate ADU/Guest House, approximately 600 sqft full bathroom, kitchen, breakfast bar, balcony, workshop, beautifully custom paved entrance, Bridge can hold up to 8000 lbs for access to rear section of property, Additional Huge separate Bonus Room perfect for game room or separate office RV parking, Full BBQ set up possible horse set up, newly painted interior & exterior, updated lighting, refinished hardwood floors, new well pump, serviced septic tank and more, a must see!

26929 Palomares Rd, Castro Valley

Listed by Lucia Blanco, (925) 575-0162 from Compass
(If provided) CoList: from

$427,500
1 Beds 2 Baths EB41141786 MLS Not Listed BLDG.
Discover the ultimate fusion of modern living and entrepreneurial freedom in this oversized, end-unit live/work condo. Nestled in a beautifully maintained complex with exceptional curb appeal, this completely remodeled residence boasts an airy, open floor plan crowned by soaring ceilings and dramatic double-height windows. The main level is designed for maximum business utility, featuring an ADA-compliant bathroom and a flexible layout perfect for welcoming clients. Upstairs, a massive loft overlooks the vibrant main floor, offering an ideal retreat for private living. Finished with a full bathroom on each level, premium stainless steel appliances, and an energy-efficient tankless water heater, this turnkey property allows you to seamlessly run your business and elevate your lifestyle from home.

5410 Trask St, Oakland

Listed by Ullon Willis, (510) 562-3827 from Choice Realty
(If provided) CoList: from

$1,899,950
BE41135456 MLS
Rare investment opportunity on iconic College Avenue in Berkeley. This expansive single-family property features specialized use potential and flexible living configurations ideal for investors, owner-occupants, or income-focused buyers. The main residence offers four bedrooms, two bathrooms, oversized living spaces, basement access, and multiple generously sized bedrooms. Two rooms share access to a private patio deck, creating additional outdoor appeal. A separate section of the property includes seven additional bedrooms - six located on the upper level - along with two kitchens, two bathrooms, and attic access, offering versatile occupancy and layout possibilities. The property also features an attached art studio with a private entrance and dedicated bathroom. Currently operated in a manner similar to single-room occupancy (SRO) use, the property presents multiple potential income-producing opportunities, subject to buyer verification and local regulations. Possible uses may include owner-occupancy with supplemental rental income or maximizing rental potential across multiple sections. Conveniently located near shops, dining, transit, and neighborhood amenities, this property offers strong long-term investment potential. Property could benefit from and may require update

2610 College Ave, Berkeley

Listed by Ashley Monasmith, (831) 221-6051 from Monasmith Real Estate
(If provided) CoList: from

$1,899,950
BE41135230 MLS
Rare investment opportunity on iconic College Avenue in Berkeley. This expansive single-family property features specialized use potential and flexible living configurations ideal for investors, owner-occupants, or income-focused buyers. The main residence offers four bedrooms, two bathrooms, oversized living spaces, basement access, and multiple generously sized bedrooms. Two rooms share access to a private patio deck, creating additional outdoor appeal. A separate section of the property includes seven additional bedrooms - six located on the upper level - along with two kitchens, two bathrooms, and attic access, offering versatile occupancy and layout possibilities. The property also features an attached art studio with a private entrance and dedicated bathroom. Currently operated in a manner similar to single-room occupancy (SRO) use, the property presents multiple potential income-producing opportunities, subject to buyer verification and local regulations. Possible uses may include owner-occupancy with supplemental rental income or maximizing rental potential across multiple sections. Conveniently located near shops, dining, transit, and neighborhood amenities, this property offers strong long-term investment potential. Property could benefit from and may require update

2610 College Ave, Berkeley

Listed by Ashley Monasmith, (831) 221-6051 from Monasmith Real Estate
(If provided) CoList: from

$1,325,000
3 Beds 2 Baths BE41125291 MLS
APPROVED SHORT SALE!! Welcome to 4612 Drury Court in Fremont - a wonderful home that needs a little updating, 3-bedroom, 2-bath home offering 1,452 square feet of comfortable living space on a generous 6,279 square foot lot. Nestled on a quiet court, this charming residence blends classic character with thoughtful modern upgrades with updated HVAC. The inviting living area features Hunter Douglas Duette® PowerView® blinds, offering both style and smart functionality. Enjoy year-round comfort with a newly installed Lennox A/C and furnace (2024), enhanced by an air scrubber system for improved indoor air quality. A tankless water heater adds energy efficiency and everyday convenience. The low-maintenance front yard showcases attractive turf landscaping, providing great curb appeal without the upkeep. The spacious lot offers plenty of room to entertain, garden, or simply relax outdoors. Built in 1962, this home is ideally located near parks, schools, shopping, and commuter routes. A wonderful opportunity to own in one of Fremont's established neighborhoods.

4612 Drury Ct, Fremont

Listed by DeAnna Armario, (925) 260-2220 from Keller Williams Tri-Valley
(If provided) CoList: Brianna Armario from Keller Williams Tri-Valley

board logoThe data relating to real estate for sale on this display comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system. Real estate listings held by brokerage firms other than The Villages Realty - Rodda Realty Team are marked with the Internet Data Exchange and detailed information about them includes the names of the listing brokers and listing agents.
Based on information from MLSListings MLS as of . All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.


Copyright 2026 MLSListings Inc. All rights reserved