GUIDE Real Estate
  • Home
  • Sellers
    1. Sellers
    2. Sold Listings
    3. Marketing
    4. Online Presence
    5. Home Valuation
  • Buyers
    1. Buyers
    2. Featured Listings
    3. Home Search
  • Neighborhoods
    1. Paso Robles
    2. Templeton
    3. Atascadero
    4. San Luis Obispo
    5. Cambria
    6. Arroyo Grande
    7. Morro Bay
    8. San Miguel
  • About
    1. About
    2. Testimonials
    3. Forbes Global Properties
  • Contact
Register
/
Sign In
Filters Reset
1 Filter
Price
  • Any
  • $ 100,000
  • $ 150,000
  • $ 200,000
  • $ 400,000
  • $ 800,000
  • Any
  • $ 200,000
  • $ 300,000
  • $ 400,000
  • $ 600,000
  • $ 1,000,000
Beds
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Baths
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Reset
1 Filter
1 Filter Applied

Price
  • Any
  • $ 100,000
  • $ 150,000
  • $ 200,000
  • $ 400,000
  • $ 800,000
  • Any
  • $ 200,000
  • $ 300,000
  • $ 400,000
  • $ 600,000
  • $ 1,000,000
Beds
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Baths
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Days On Site
Advanced
Less Than
Days
Unit Level
Unfin SqFt

SqFt
Switch to Acre
Sqft
Sqft
Lot Size
Switch to Acre
Sqft
Sqft
Price per Sqft
Monthly HOA Fee
Year Built
Stories
Acres
Full Bathrooms
Half Bathrooms
Frontage
Tax Amount
Land Lease Fee
Keyword
Assessed Value

Fireplace Number

Parking Space
Garage Space
Carport Spaces

Open House
Has Picture
New
Hot
Virtual Tour
3D Tour
Price Reduced
Save Search (2)
Save your search to get Alerts
12 Properties
Map

12 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
222 N St Andrews PL, Los Angeles, CA 90004
Open Tue 11AM-2PM

$2,295,000

222 N St Andrews PL, Los Angeles, CA 90004

4 Beds4 Baths2,905 SqFt

MLS# 26869869

Listed by Thomas Hilal of Nourmand & Associates-BH

CRMLS Full IDX Feed (MAIN Website Search)
316 N Rossmore AVE #605, Los Angeles, CA 90004
Open Tue 11AM-2PM

$2,750,000

316 N Rossmore AVE #605, Los Angeles, CA 90004

3 Beds3 Baths1,616 SqFt

MLS# 26869649

Listed by Kaitrin Simkin of Compass

CRMLS Full IDX Feed (MAIN Website Search)
4814 W 1st ST, Los Angeles, CA 90004
Open Tue 11AM-2PM

$1,800,000

4814 W 1st ST, Los Angeles, CA 90004

2 Beds2 Baths1,134 SqFt

MLS# 26869233

Listed by John Duerler of eXp Realty of Greater Los Angeles

CRMLS Full IDX Feed (MAIN Website Search)
564 N Arden BLVD, Los Angeles, CA 90004
Open Fri 11AM-2PM

$10,999

564 N Arden BLVD, Los Angeles, CA 90004

4 Beds4 Baths2,143 SqFt

MLS# 26868175

Listed by Marko Babineau of Compass

CRMLS Full IDX Feed (MAIN Website Search)
612 Wilcox AVE, Los Angeles, CA 90004
Open Sat 1PM-4PM

$1,099,000

612 Wilcox AVE, Los Angeles, CA 90004

2 Beds3 Baths1,363 SqFt

MLS# BB26101979

Listed by Steven Hill of Equity Union

CRMLS Full IDX Feed (MAIN Website Search)
585 N Rossmore AVE #209, Los Angeles, CA 90004
Open Tue 4PM-6PM

$835,000

585 N Rossmore AVE #209, Los Angeles, CA 90004

2 Beds2 Baths1,190 SqFt

MLS# 26862239

Listed by Arthur Yoon of Redpoint Realty

CRMLS Full IDX Feed (MAIN Website Search)
547 N Irving BLVD, Los Angeles, CA 90004
Open Tue 11AM-2PM

$1,285,000

547 N Irving BLVD, Los Angeles, CA 90004

2 Beds2 Baths1,147 SqFt

MLS# 26860371

Listed by Catherine Gellert of Compass

CRMLS Full IDX Feed (MAIN Website Search)
584 N Lucerne BLVD, Los Angeles, CA 90004
Open Sun 1PM-4PM

$2,395,000

584 N Lucerne BLVD, Los Angeles, CA 90004

4 Beds4 Baths2,033 SqFt

MLS# 26850543

Listed by Sue Carr of Coldwell Banker Realty

CRMLS Full IDX Feed (MAIN Website Search)
147 N Berendo ST #203, Los Angeles, CA 90004
Open Sat 1PM-4PM

$735,000

147 N Berendo ST #203, Los Angeles, CA 90004

3 Beds2 Baths1,530 SqFt

MLS# 26839469

Listed by Koeun Hwang of Urban Real Estate, Inc.

CRMLS Full IDX Feed (MAIN Website Search)
111 S Van Ness AVE, Los Angeles, CA 90004
3D
Open Tue 11AM-2PM

$4,900,000

111 S Van Ness AVE, Los Angeles, CA 90004

5 Beds6 Baths7,315 SqFt

MLS# 26674135

Listed by John Duerler of eXp Realty of Greater Los Angeles

CRMLS Full IDX Feed (MAIN Website Search)
3812 Middlebury, Los Angeles, CA 90004
Open Sun 12PM-3PM

$799,800

3812 Middlebury, Los Angeles, CA 90004

3 Beds3 Baths1,240 SqFt

MLS# CV26069686

Listed by Yescenia Osorio of VISMAR REAL ESTATE

CRMLS Full IDX Feed (MAIN Website Search)
310 N Lucerne BLVD, Los Angeles, CA 90004
Open Sun 2PM-5PM

$3,690,000

310 N Lucerne BLVD, Los Angeles, CA 90004

5 Beds5 Baths4,400 SqFt

MLS# 26661705

Listed by Aera So of Latitude 33 Real Estate

CRMLS Full IDX Feed (MAIN Website Search)
  • 1

explore listings in 90004

  • Open House
  • Price Reduced
  • Virtual Tour
  • 3D Tour
site logoGUIDExFORBES-Hor-White-v2-453w-430w-653ba011-640w
GUIDE Real Estate
Terri Winn
1213 Vine St, Paso Robles, CA 93446-2260, USA

+1(805) 610-0991

sold@terriwinn.com

Get My App

The cooperating broker offer of compensation summaries herein are intended solely as preliminary expressions of possible outcomes. No such offer of compensation shall become binding, or create any legal obligation of any kind, unless and until a written Cooperative Broker Compensation Agreement has been fully executed and delivered by both brokers.

Website Design by Bullsai

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.

Filters Reset
1 Filter
Price
  • Any
  • $ 100,000
  • $ 150,000
  • $ 200,000
  • $ 400,000
  • $ 800,000
  • Any
  • $ 200,000
  • $ 300,000
  • $ 400,000
  • $ 600,000
  • $ 1,000,000
Beds
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Baths
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Reset
1 Filter
1 Filter Applied

Price
  • Any
  • $ 100,000
  • $ 150,000
  • $ 200,000
  • $ 400,000
  • $ 800,000
  • Any
  • $ 200,000
  • $ 300,000
  • $ 400,000
  • $ 600,000
  • $ 1,000,000
Beds
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Baths
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Days On Site
Advanced
Less Than
Days
Unit Level
Unfin SqFt

SqFt
Switch to Acre
Sqft
Sqft
Lot Size
Switch to Acre
Sqft
Sqft
Price per Sqft
Monthly HOA Fee
Year Built
Stories
Acres
Full Bathrooms
Half Bathrooms
Frontage
Tax Amount
Land Lease Fee
Keyword
Assessed Value

Fireplace Number

Parking Space
Garage Space
Carport Spaces

Open House
Has Picture
New
Hot
Virtual Tour
3D Tour
Price Reduced
Save Search (2)
Save your search to get Alerts
12 Properties
Map

12 Properties Available

  • Default
  • Baths (Most)
  • Beds (Most)
  • Newest Listings
  • Square Feet (Biggest)
  • Price-High To Low
  • Price-Low To High
  • 222 N St Andrews PL, Los Angeles, CA 90004
    4 Beds4 Baths2,905 SqFt
    1/52 52
    Open Tue 11AM-2PM

    $2,295,000

    222 N St Andrews PL, Los Angeles, CA 90004

    MLS# 26869869

    Listed by Thomas Hilal of Nourmand & Associates-BH

    CRMLS Full IDX Feed (MAIN Website Search)
  • 316 N Rossmore AVE #605, Los Angeles, CA 90004
    3 Beds3 Baths1,616 SqFt
    1/16 16
    Open Tue 11AM-2PM

    $2,750,000

    316 N Rossmore AVE #605, Los Angeles, CA 90004

    MLS# 26869649

    Listed by Kaitrin Simkin of Compass

    CRMLS Full IDX Feed (MAIN Website Search)
  • 4814 W 1st ST, Los Angeles, CA 90004
    2 Beds2 Baths1,134 SqFt
    1/10 10
    Open Tue 11AM-2PM

    $1,800,000

    4814 W 1st ST, Los Angeles, CA 90004

    MLS# 26869233

    Listed by John Duerler of eXp Realty of Greater Los Angeles

    CRMLS Full IDX Feed (MAIN Website Search)
  • 564 N Arden BLVD, Los Angeles, CA 90004
    4 Beds4 Baths2,143 SqFt
    1/39 39
    Open Fri 11AM-2PM

    $10,999

    564 N Arden BLVD, Los Angeles, CA 90004

    MLS# 26868175

    Listed by Marko Babineau of Compass

    CRMLS Full IDX Feed (MAIN Website Search)
  • 612 Wilcox AVE, Los Angeles, CA 90004
    2 Beds3 Baths1,363 SqFt
    1/46 46
    Open Sat 1PM-4PM

    $1,099,000

    612 Wilcox AVE, Los Angeles, CA 90004

    MLS# BB26101979

    Listed by Steven Hill of Equity Union

    CRMLS Full IDX Feed (MAIN Website Search)
  • 585 N Rossmore AVE #209, Los Angeles, CA 90004
    2 Beds2 Baths1,190 SqFt
    1/29 29
    Open Tue 4PM-6PM

    $835,000

    585 N Rossmore AVE #209, Los Angeles, CA 90004

    MLS# 26862239

    Listed by Arthur Yoon of Redpoint Realty

    CRMLS Full IDX Feed (MAIN Website Search)
  • 547 N Irving BLVD, Los Angeles, CA 90004
    2 Beds2 Baths1,147 SqFt
    1/23 23
    Open Tue 11AM-2PM

    $1,285,000

    547 N Irving BLVD, Los Angeles, CA 90004

    MLS# 26860371

    Listed by Catherine Gellert of Compass

    CRMLS Full IDX Feed (MAIN Website Search)
  • 584 N Lucerne BLVD, Los Angeles, CA 90004
    4 Beds4 Baths2,033 SqFt
    1/30 30
    Open Sun 1PM-4PM

    $2,395,000

    584 N Lucerne BLVD, Los Angeles, CA 90004

    MLS# 26850543

    Listed by Sue Carr of Coldwell Banker Realty

    CRMLS Full IDX Feed (MAIN Website Search)
  • 147 N Berendo ST #203, Los Angeles, CA 90004
    3 Beds2 Baths1,530 SqFt
    1/19 19
    Open Sat 1PM-4PM

    $735,000

    147 N Berendo ST #203, Los Angeles, CA 90004

    MLS# 26839469

    Listed by Koeun Hwang of Urban Real Estate, Inc.

    CRMLS Full IDX Feed (MAIN Website Search)
  • 111 S Van Ness AVE, Los Angeles, CA 90004
    5 Beds6 Baths7,315 SqFt
    3D
    Open Tue 11AM-2PM

    $4,900,000

    111 S Van Ness AVE, Los Angeles, CA 90004

    MLS# 26674135

    Listed by John Duerler of eXp Realty of Greater Los Angeles

    CRMLS Full IDX Feed (MAIN Website Search)
  • 3812 Middlebury, Los Angeles, CA 90004
    3 Beds3 Baths1,240 SqFt
    1/35 35
    Open Sun 12PM-3PM

    $799,800

    3812 Middlebury, Los Angeles, CA 90004

    MLS# CV26069686

    Listed by Yescenia Osorio of VISMAR REAL ESTATE

    CRMLS Full IDX Feed (MAIN Website Search)
  • 310 N Lucerne BLVD, Los Angeles, CA 90004
    5 Beds5 Baths4,400 SqFt
    1/53 53
    Open Sun 2PM-5PM

    $3,690,000

    310 N Lucerne BLVD, Los Angeles, CA 90004

    MLS# 26661705

    Listed by Aera So of Latitude 33 Real Estate

    CRMLS Full IDX Feed (MAIN Website Search)
  • 1

explore listings

  • Open House
  • Price Reduced
  • Virtual Tour
  • 3D Tour
site logoGUIDExFORBES-Hor-White-v2-453w-430w-653ba011-640w
GUIDE Real Estate
Terri Winn
1213 Vine St, Paso Robles, CA 93446-2260, USA

+1(805) 610-0991

sold@terriwinn.com

Get My App

The cooperating broker offer of compensation summaries herein are intended solely as preliminary expressions of possible outcomes. No such offer of compensation shall become binding, or create any legal obligation of any kind, unless and until a written Cooperative Broker Compensation Agreement has been fully executed and delivered by both brokers.

Website Design by Bullsai

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.

site logoGUIDExFORBES-Hor-White-v2-453w-430w-653ba011-640w
GUIDE Real Estate
Terri Winn
1213 Vine St, Paso Robles, CA 93446-2260, USA

+1(805) 610-0991

sold@terriwinn.com

Get My App

The cooperating broker offer of compensation summaries herein are intended solely as preliminary expressions of possible outcomes. No such offer of compensation shall become binding, or create any legal obligation of any kind, unless and until a written Cooperative Broker Compensation Agreement has been fully executed and delivered by both brokers.

Website Design by Bullsai

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.