247 E Main St, Alhambra, CA 91801
OFF MARKET

247 E Main St
Alhambra, CA 91801

  • Studio
  • 1 Bath
  • 1,500 sqft (on 0.39 acres)

$4,853,800

Trulia Estimate
as of May 12, 2026
Est. Refi. Payment $28,404/mo*
Refinance Your Home

$4,853,800

Trulia Estimate
as of May 12, 2026
Est. Refi. Payment $28,404/mo*
Refinance Your Home
Studio
1 Bath
1,500 sqft
(on 0.39 acres)

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

Description

Alhambra Office / Studio Space - Property Id: 89881

Office / studio space for lease
Apply at TurboTenant: http
rental.turbotenant.com/properties/89881
Property Id 89881

No Pets Allowed

(RLNE4564803)
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources.

Home Highlights

Parking
No Info
Outdoor
No Info
HOA
None
Price/Sqft
No Info
Listed
No Info

Home Details for 247 E Main St

Interior Features

Levels, Entrance, & Accessibility
Stories: 1

Property Information

Year Built
Year Built: 1947
Property Type / Style
Property Type: Multi Family

Community

Units in Building: 1

Lot Information

Lot Area: 0.39 acres

Price History for 247 E Main St

DatePriceEventSource
01/12/2019$2,000ListingRemovedAgent Provided
12/07/2018$2,000Listed For RentAgent Provided
03/25/2016$4,000,000Sold
N/A
05/13/2004$3,880,000Sold
N/A
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$86,107
Assessment$6,720,412
Home facts updated by county records

Comparable Sales for 247 E Main St

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
113 S 5th St, Alhambra, CA
0.58
Multi-Family Home
$1,095,000
01/22/26
4
2
1,873
601 N Stoneman Ave, Alhambra, CA
0.45
Multi-Family Home
$4,780,000
09/10/25
35
29
13,436
140 N 4th St #A, Alhambra, CA
0.48
Multi-Family Home
$1,554,000
09/03/25
6
4
3,802
120 W Grand Ave, Alhambra, CA
0.41
Multi-Family Home
$5,600,000
08/12/25
38
34
23,237
428 N Garfield Ave, Alhambra, CA
0.40
Multi-Family Home
$1,508,000
09/12/25
8
6
4,226
101 E Alhambra Rd #E, Alhambra, CA
0.45
Multi-Family Home
$2,650,000
09/12/25
13
11
8,015
400 401grand N, Alhambra, CA
0.59
Multi-Family Home
$2,250,000
09/15/25
10
8
5,829
505 N Stoneman Ave, Alhambra, CA
0.42
Multi-Family Home
$1,938,000
05/01/26
11
6
5,768
15 E Beacon St, Alhambra, CA
0.36
Multi-Family Home
$1,630,000
02/25/26
10
11
5,951
233 N Olive Ave, Alhambra, CA
0.69
Multi-Family Home
$1,080,000
12/17/25
5
3
2,144

Assigned Schools

These are the assigned schools for 247 E Main St.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Alhambra

At least 727 Trulia users voted on each feature.

  • 90 % Say there are sidewalks

  • 83 % Say it's dog friendly

  • 76 % Say it's walkable to restaurants

  • 74 % Say car is needed

  • 68 % Say it's walkable to grocery stores

  • 67 % Say people would walk alone at night

  • 67 % Say streets are well-lit

  • 64 % Say parking is easy

  • 59 % Say they plan to stay for at least 5 years

  • 59 % Say yards are well-kept

  • 58 % Say there's holiday spirit

  • 56 % Say it's quiet

  • 48 % Say kids play outside

  • 47 % Say neighbors are friendly

  • 47 % Say there's wildlife

  • 26 % Say there are community events

Learn more about our methodology.
  • Cesar Martinez
    "There’s a big sense of a community in Alhambra, it’s busy during the day, quiet at night in residential neighborhoods but it seems very safe "
    0
    Flag
  • Skye Ledoux
    "It’s a very safe neighborhood with several young families and lots of community activities. Close to many great restaurants and grocery stores, as well as well maintained parks. Alhambra is a very family friendly area."
    0
    Flag
  • H89hx9sdw6
    "Lived here all my life never had any issues with the city although sometimes it can be a bit difficult with the parking here unless you are a resident you need to get permit so it makes it difficult for people with multiple vehicles "
    0
    Flag
  • Rener4001
    "Some streets can feel large to different gas but overall great streets to walk very safe lots of other dog walkers "
    0
    Flag
  • Low
    "I’ve lived in this neighborhood for 6 years. It’s pretty quiet and it seems most people like to keep to themselves and not cause a ruckus. I run around 8-9pm in the dark and generally feel pretty safe. The thing you most likely have to lookout for are the coyotes. Other than that, I enjoy living in the neighborhood and it seems like it’s safe enough that parents don’t mind letting their kids out to play."
    0
    Flag
  • Brenda Estrada
    "It’s a prime location near DTLA, Pasadena and other surrounding neighborhoods. It’s also filled with trees that make it beautiful "
    0
    Flag
  • Alfred Cherrington Jr
    "Lots of nice parks for kids, super friendly, fun on Halloween. Summer time offers free meals at all the parks as well "
    0
    Flag
  • Lynn
    "I work from home. But driving during commute hours is a drag, like it is everywhere in L.A. Just to get to the freeway takes 15 minutes. "
    0
    Flag
  • Charlie Rodarte
    "Dog owners would like the walkable sidewalks. I personally don't walk my dog. I usually just walk everywherem"
    0
    Flag
  • Trulia User
    "Schools are great for our children. Neighborhood is always quiet. Pricing for homes are higher than average but i would love to live here long term. 5 years in currently."
    0
    Flag
  • Pgt47wj8x8
    "Close to downtown la 15 min drive on a good day 30 minutes on a high traffic day over all easy to get around "
    0
    Flag
  • Trulia User
    "Schools and education are very important in alhambra. Mandarin is taught in loca Montessori schools."
    0
    Flag
  • Lynnstoner.mansir
    "There are a lot of dog owners here. There are two groups of dog owners and their dogs who meet at the park every afternoon - - one group for big dogs and one for small and mid-size dogs. Everyone is friendly. "
    5
    Flag
  • Mariela Cortés
    "I’ve lived in Alhambra for 6 years and have not found a problem. The school districts are okay, not as great as others."
    0
    Flag
  • Trulia User
    "I don’t actually know? Why is there a minimum requirement here! I don’t have enough to write. There’s trees and stuff. Dogs like trees"
    0
    Flag
  • Trulia User
    "El sereno is not really safe. Do not move here lol. Unless you want trouble I would not suggest it. "
    6
    Flag
  • Veganltlbear
    "Great for raising a family, parks close by, good schools, great downtown for many activities. Try to find one of the SFR zine areas and you’ll be happy "
    1
    Flag
  • Jmartinezucla
    "Everyone has dogs on a leash and it’s a nice area to walk in. The park is a few blocks away and is set up with doggy bags stands."
    12
    Flag
  • Christina M.
    "Feels like a community, very welcoming would recommend to a friend or potential neighbor. Very safe, quiet, everyone to themselves, close to freeways, away from city"
    0
    Flag
  • Kenneth J.
    "This is a Great area and is really neighborhood friendly ... I love in the area and never had a problem !!"
    4
    Flag
  • Susana R.
    "The water supply is more cleaner and the neighborhood is safe. Downtown Main Street is very nice and popular."
    0
    Flag
  • Tommy L.
    "It’s alright, no traffic to DTLA is 15 mins but with traffic it could be up to 45 mins. Easy drive to Pasadena. "
    0
    Flag
  • Abraham B.
    "Pandemic times - no commute - work from home - traffic has been minimal otherwise compared to the city."
    0
    Flag
  • Darrell T.
    "Weekly farmers market on Main Street. Easter egg, 4th of July celebration, and many other seasonal events. Many community events."
    1
    Flag
  • Steven H.
    "Lots of beautiful neighborhood areas to walk. Not everyone in the area is very dog friendly, some people seem stand-off-ish if they pass you while walking "
    0
    Flag
  • Ashley C.
    "I love it here. Lots of restaurants and not too far from LA. I don’t know if this is a good area for kids but I think it’s good for younger adults or older adults without kids definitely."
    3
    Flag
  • Miles T.
    "I live here for a year and street parking is a big issue but only in certain areas, always be careful where u park."
    1
    Flag
  • Breanna F.
    "It’s a great place. I’ve lived in Alhambra for 2 years and borderline Alhambra/ El Sereno for 5 and there’s a little bit of everything here. Everything is close by and welcoming "
    4
    Flag
  • Juan M.
    "I’ve lived in this neighborhood for 2 years. Never had to complain, everyone is friendly. Clean sidewalks as well "
    0
    Flag
  • Amanda G.
    "ACT Green line helps me bring my daughter to school for only a quarter. Super clean and the drivers are so nice. Timing is off sometimes but other than that, its great."
    0
    Flag
  • Virginia G.
    "They would like that the streets are not terribly busy with passing cars. People are respectful and it is very peaceful to go for walks around here. "
    3
    Flag
  • Rehabcounselor2001
    "you can walk your dog at any time., as long as you pick up after them. I believe it's a dog friendly city."
    0
    Flag
  • Allysgirls
    "There are community events hosted by the local firefighters at the fire department throughout the year. "
    0
    Flag
  • Julia
    "Their is a annual event with the cops dinner night. All their reading program event that happen during the summer. The music Friday nights at Ricky’s. The pumpkin patch run. "
    0
    Flag
  • Miguelavila54
    "Our area has great schools, parks and restaurants. It’s a friendly town and great to live and be part of this wonderful community."
    0
    Flag
  • Jenny M.
    "Loving this city everyone here are very respectful and nice. I just recently moved to Alhambra and I’m glad I did "
    0
    Flag
  • Dmartinez3128
    "You’re lucky if you can find a parking in this area because so many people are living under the same roof and the apartments only allow one or two parking so everybody is cramping the street with all these extra cars that the city should not be allowing them to park or rent if they don’t have apartments but for them"
    3
    Flag
  • Gabby052785
    "there is a lot of activity for families in the park , the schools are very good. Alhambra is a very good neighborhood to live with family. "
    0
    Flag
  • Marcella G.
    "Neighbor hood watch meetings staying connected to our city’s web page and all the events that happen in our city"
    0
    Flag
  • Tommy H.
    "The neighborhood is very diverse in age and also cultures. Everyone is friendly and I haven't experienced any "bad" neighbors in the past three years. "
    0
    Flag

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Homes for sale near 247 E Main St

Skip to last item
Skip to first item

Homes for rent near 247 E Main St

Skip to last item
Skip to first item

Off Market Homes Near 247 E Main St

Skip to last item
Skip to first item

Explore by feature

247 E Main St, Alhambra, CA 91801 is a studio, 1 bathroom, 1,500 sqft multi-family built in 1947. This property is not currently available for sale. 247 E Main St was last sold on Mar 25, 2016 for $4,000,000. The current Trulia Estimate for 247 E Main St is $4,853,800.