Mello Realty
  • Home
  • Buy
    1. All Listings
    2. Featured Listings
    3. Sold Listings
  • Sell
    1. Sell My Home
    2. Home Valuation
  • Neighborhoods
    1. Keyes
    2. Modesto
    3. Stockton
    4. Riverbank
    5. Newman
    6. Tracy
    7. Manteca
    8. Patterson
    9. Ripon
  • Blogs
  • About
    1. About Us
    2. Contact Us
    3. Reviews
  • Market Snapshot
  • Register
  • /
  • Sign In
90004
Price
    • Any
    • $ 50,000
    • $ 100,000
    • $ 150,000
    • $ 200,000
    • $ 400,000
    • Any
    • $ 200,000
    • $ 300,000
    • $ 400,000
    • $ 600,000
    • $ 800,000
Beds
    • Any
    • 1
    • 2
    • 3
    • 4
    • 5
    • Any
    • 1
    • 2
    • 3
    • 4
    • 5
Baths
    • Any
    • 1
    • 1.5
    • 2
    • 3
    • 4
    • 5
    • Any
    • 1
    • 1.5
    • 2
    • 3
    • 4
    • 5
  • List
  • Mixed
  • Map
Map
227 Properties Available In 90004

227 Properties Available In 90004

  • Default
  • Price-High To Low
  • Price-Low To High
  • Newest Listings
  • Beds (Most)
  • Baths (Most)
  • Year Built (Newest)
  • Square Feet (Biggest)
CA >90004 >
Market Insights
443 N Harvard BLVD #1/2, Los Angeles, CA 90004
1/24
Active

$4,350

3 Beds4 Baths1,350 SqFt

443 N Harvard BLVD #1/2, Los Angeles, CA 90004

MLS# OC26093929

Listed by Drew Dunn of Four Brothers Real Estate, Inc.

CRMLS Full IDX Feed (MAIN Website Search)
542 N Serrano AVE, Los Angeles, CA 90004
1/22
Active

$1,395,000

5 Beds4 Baths2,388 SqFt

542 N Serrano AVE, Los Angeles, CA 90004

MLS# SR26082785

Listed by Oren Mordkowitz of Pinnacle Estate Properties, Inc.

CRMLS Full IDX Feed (MAIN Website Search)
571 Mariposa ST, Los Angeles, CA 90004
1/26
Active

$5,995

4 Beds3 Baths1,950 SqFt

571 Mariposa ST, Los Angeles, CA 90004

MLS# 25528565

Listed by Serena Shlomof of Onward Capital, Inc.

CRMLS Full IDX Feed (MAIN Website Search)
618 N Mariposa AVE #1/2, Los Angeles, CA 90004
1/18
Active

$5,250

3 Beds4 Baths1,550 SqFt

618 N Mariposa AVE #1/2, Los Angeles, CA 90004

MLS# OC26085850

Listed by Drew Dunn of Four Brothers Real Estate, Inc.

CRMLS Full IDX Feed (MAIN Website Search)
1/2 N Serrano AVE, Los Angeles, CA 90004
1/19
Active

$2,250

1 Bed1 Bath491 SqFt

1/2 N Serrano AVE, Los Angeles, CA 90004

MLS# SR26034130

Listed by Heather Schmitt of Equity Union

CRMLS Full IDX Feed (MAIN Website Search)
171 S Hoover ST, Los Angeles, CA 90004
1/47
Active

$3,699

3 Beds3 Baths1,347 SqFt

171 S Hoover ST, Los Angeles, CA 90004

MLS# 24368347

Listed by Yohann Bensimon of Keller Williams Hollywood Hills

CRMLS Full IDX Feed (MAIN Website Search)
171 S Hoover ST, Los Angeles, CA 90004
1/41
New

$3,750

3 Beds3 Baths1,347 SqFt

171 S Hoover ST, Los Angeles, CA 90004

MLS# BB26103633

Listed by Sekura Kruse of Myunits.com Inc.

CRMLS Full IDX Feed (MAIN Website Search)
222 N Manhattan PL, Los Angeles, CA 90004
1/20
Active

$6,250,000

6,895 Sqft Lot

222 N Manhattan PL, Los Angeles, CA 90004

MLS# SR25188533

Listed by Gal Moshe of Equity Union

CRMLS Full IDX Feed (MAIN Website Search)
5016 CLINTON ST #5016 - D, Los Angeles, CA 90004
1/20
Active

$2,795

2 Beds1 Bath1,200 SqFt

5016 CLINTON ST #5016 - D, Los Angeles, CA 90004

MLS# 26773409

Listed by Arrian Torkian of Arrian Torkian

CRMLS Full IDX Feed (MAIN Website Search)
408 N Kenmore AVE, Los Angeles, CA 90004
1/14
Active

$3,995

3 Beds4 Baths1,425 SqFt

408 N Kenmore AVE, Los Angeles, CA 90004

MLS# 26672229

Listed by Aida Khashaki of Coldwell Banker Realty

CRMLS Full IDX Feed (MAIN Website Search)
413 N Harvard BLVD #413, Los Angeles, CA 90004
1/17
Pending

$3,400

3 Beds2 Baths1,200 SqFt

413 N Harvard BLVD #413, Los Angeles, CA 90004

MLS# 25606655

Listed by Bruce Lee of TRRG Management

CRMLS Full IDX Feed (MAIN Website Search)
495 N St Andrews PL, Los Angeles, CA 90004
1/24
Active

$1,000,000

3 Beds4 Baths1,955 SqFt

495 N St Andrews PL, Los Angeles, CA 90004

MLS# 26828533

Listed by Naomi Kalkanoff of Compass

CRMLS Full IDX Feed (MAIN Website Search)
497 N St Andrews PL, Los Angeles, CA 90004
1/22
Active

$5,490

3 Beds4 Baths1,977 SqFt

497 N St Andrews PL, Los Angeles, CA 90004

MLS# 25560359

Listed by Eun Kim of Urban Real Estate, Inc.

CRMLS Full IDX Feed (MAIN Website Search)
552 N Hobart BLVD #207, Los Angeles, CA 90004
1/5
Active

$2,525

1 Bed2 Baths950 SqFt

552 N Hobart BLVD #207, Los Angeles, CA 90004

MLS# 26756663

Listed by H. Jason Yang of GAIA

CRMLS Full IDX Feed (MAIN Website Search)
552 N Hobart BLVD #208, Los Angeles, CA 90004
1/8
Active

$2,492

1 Bed1 Bath850 SqFt

552 N Hobart BLVD #208, Los Angeles, CA 90004

MLS# 25558533

Listed by A. Jessica Shin of GAIA

CRMLS Full IDX Feed (MAIN Website Search)
552 N Hobart BLVD #311, Los Angeles, CA 90004
1/9
Active

$2,362

1 Bed2 Baths1,000 SqFt

552 N Hobart BLVD #311, Los Angeles, CA 90004

MLS# 26634167

Listed by H. Jason Yang of GAIA

CRMLS Full IDX Feed (MAIN Website Search)
552 N Hobart BLVD #313, Los Angeles, CA 90004
1/5
Active

$2,712

1 Bed2 Baths1,100 SqFt

552 N Hobart BLVD #313, Los Angeles, CA 90004

MLS# 26756877

Listed by H. Jason Yang of GAIA

CRMLS Full IDX Feed (MAIN Website Search)
552 N Hobart BLVD #316, Los Angeles, CA 90004
1/10
Active

$2,769

1 Bed2 Baths950 SqFt

552 N Hobart BLVD #316, Los Angeles, CA 90004

MLS# 25558467

Listed by A. Jessica Shin of GAIA

CRMLS Full IDX Feed (MAIN Website Search)
552 N Hobart BLVD #316, Los Angeles, CA 90004
1/7
Active

$2,625

1 Bed2 Baths1,000 SqFt

552 N Hobart BLVD #316, Los Angeles, CA 90004

MLS# 26756439

Listed by H. Jason Yang of GAIA

CRMLS Full IDX Feed (MAIN Website Search)
667 N Wilton PL #306, Los Angeles, CA 90004
1/19
New

$2,395

1 Bed1 Bath611 SqFt

667 N Wilton PL #306, Los Angeles, CA 90004

MLS# 26833779

Listed by Kevin Krakower of Douglas Elliman of California, Inc.

CRMLS Full IDX Feed (MAIN Website Search)
178 Alexandria AVE, Los Angeles, CA 90004
1/75
Active

$7,250,000

8,041 Sqft Lot

178 Alexandria AVE, Los Angeles, CA 90004

MLS# GD26003773

Listed by Raffi Soualian of JohnHart Real Estate

CRMLS Full IDX Feed (MAIN Website Search)
412 N Ardmore AVE, Los Angeles, CA 90004
1/9
Active

$2,700,000

12 Beds13 Baths5,384 SqFt

412 N Ardmore AVE, Los Angeles, CA 90004

MLS# 26661439

Listed by David Leibowitz of Investment Real Estate Associates

CRMLS Full IDX Feed (MAIN Website Search)
5019 Maplewood AVE #105, Los Angeles, CA 90004
1/29
Active

$5,400

3 Beds3 Baths2,218 SqFt

5019 Maplewood AVE #105, Los Angeles, CA 90004

MLS# 26658119

Listed by Heather Yan of Willowmar Real Estate

CRMLS Full IDX Feed (MAIN Website Search)
5019 Maplewood AVE #105, Los Angeles, CA 90004
1/29
Active

$5,400

3 Beds3 Baths2,218 SqFt

5019 Maplewood AVE #105, Los Angeles, CA 90004

MLS# 26736551

Listed by Heather Yan of Atlas Elm Realty

CRMLS Full IDX Feed (MAIN Website Search)
  • 1
  • 2
  • 3
  • 4
  • 5
  • ...
  • 10

explore listings in 90004

  • Open House
  • Price Reduced
  • Virtual Tour
  • 3D Tour
Simple Minimalist Aesthetic Business Real Estate Logo (5)
Mello Realty
Cindy Mello | CA DRE# 01309212
625 LAN WAY, Ripon, CA, 95366, United States

+1(209) 346-4580

cindymello@gmail.com

Get My App

IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Listing information updated daily.

Terms of Service & Privacy Policy | Cookie Policy | Cookie Preferences | Property Listings | Sitemap | Accessibility

Powered by Lofty Inc. Copyright 2026. All Rights Reserved.

QUICK SEARCH
  • Homes For Sale in Newman, CA
  • Homes For Sale in Manteca, CA
  • Homes For Sale in Riverbank, CA
  • Homes For Sale in Ripon, CA
  • Homes For Sale in Keyes, CA
  • Homes For Sale in Stockton, CA
  • Homes For Sale in Modesto, CA
  • Homes For Sale in Patterson, CA
  • Homes For Sale in Tracy, CA
Simple Minimalist Aesthetic Business Real Estate Logo (5)
Mello Realty
Cindy Mello | CA DRE# 01309212
625 LAN WAY, Ripon, CA, 95366, United States

+1(209) 346-4580

cindymello@gmail.com

Get My App

IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Listing information updated daily.

Terms of Service & Privacy Policy | Cookie Policy | Cookie Preferences | Property Listings | Sitemap | Accessibility

Powered by Lofty Inc. Copyright 2026. All Rights Reserved.