148 Idora Avenue, San Francisco, CA 94127, San Francisco, 94127 - 3 bed, 3 bath
148 Idora Avenue
San Francisco, CA 94127
Property Price
SUMMARY
Analysis of 148 Idora Avenue, San Francisco, CA 94127 reveals a Prime Investment Opportunity with a current list price of $1,995,000—significantly undercutting the $2,208,480 Fair Market Value by 9%. This valuation gap indicates a +$213,480 Instant Equity potential for buyers. The property maintains a Excellent Condition Rating (95/100), indicating excellent structural integrity and modern finishes throughout. This turnkey property requires minimal updates and is ready for immediate occupancy. Located in a high-demand neighborhood within the San Francisco Unified School District, this asset is categorized as a low-risk, high-reward acquisition suitable for both Buy-and-Hold Investors and Owner-Occupants willing to undertake light renovation work.
Estimated Market Value
Comparable Sales Map
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 148 Idora Avenue Subject | $1,995,000* List Price | 3 | 3 | 1,925 | $1,147 | - |
A 150 El Verano Way Sold | $2,409,000 | 4 | 3 | 1,868 | $1,290 | 1.0 mi |
B 315 Colon Avenue Sold | $2,407,500 | 3 | 2 | 1,940 | $1,241 | 0.9 mi |
C 60 Hernandez Avenue Sold | $1,925,000 | 2 | 2 | 1,824 | $1,055 | 0.1 mi |
D 71 Ulloa Street Sold | $2,310,000 | 3 | 2 | 1,850 | $1,249 | 0.2 mi |
E 327 Ulloa Street Sold | $1,795,000 | 4 | 3 | 2,091 | $858 | 0.2 mi |
F 591 Los Palmos Drive Pending | $1,875,000 List Price | 4 | 2 | 2,004 | $936 | 0.7 mi |
* Subject property listed price vs sold prices of comps.
Condition Analysis
OVERALL CONDITION SCORE
Property is new construction or fully renovated.
This 1931 Art Deco home has undergone extensive high-end renovations that meet modern luxury standards. The property features a fully remodeled gourmet kitchen equipped with premium appliances (Sub-Zero, GE Cafe, Asko), updated marble-tiled bathrooms including a luxurious master suite, and pristine hardwood flooring throughout. The integration of classic architectural details with contemporary systems and finishes indicates a complete renovation within the last 5 years with no deferred maintenance.
PROSSTRENGTHS & OPPORTUNITIES
- Great Schools
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
- Architectural Significance
This 1931 Art Deco masterpiece features a masterfully designed facade, elaborate ornamentation, and high-end interior finishes like marble fireplaces and gleaming hardwood floors.
- Panoramic Views
The expansive master suite offers breathtaking views of Mt. Tamalpais, the Marin Headlands, and Sutro Tower, providing a rare and serene visual experience in the city.
CONSRISKS & DEFICIENCIES
- Multi-Level Layout
The home’s vertical design across three levels, including a significant basement and upper-level quarters, may pose accessibility challenges for some buyers.
- Historic Infrastructure
Being built in 1931, the property may require ongoing maintenance or seismic upgrades typical of historic San Francisco residences despite its modern cosmetic updates.
About 148 Idora Avenue
This spectacular, architecturally significant Art Deco home w/masterfully designed facade & elaborate ornamentation is tucked away on a wonderful, divided block with parkway in the heart of the neighborhood, close to Forest Hill Station! An enchanting garden entrance w/inviting walkway leads to a charming portico w/attractive awning & notable front door & into a lovely foyer w/huge coat closet. The impressive formal living rm w/high ceiling boasts a fireplace w/stunning marble mantel, hearth and surround, exquisite wall sconces, classic crown moldings, gleaming hardwood floors & large picture windows w/serene outlooks. The handsome, light-filled formal dining rm w/striking chandelier is perfect for entertaining! The beautifully remodeled gourmet kitchen w/comfortable breakfast area showcases all stainless-steel appliances incl a Sub-Zero refrigerator, Asko dishwasher, GE Cafe' five-burner gas stovetop w/griddle, hood & a separate GE Cafe' oven, built-in Sharp microwave, granite counters, double stainless-steel sink & custom wood cabinets w/slow-close drawers. A snazzy rear hallway leads to a terrific full bath w/shower over cast-iron tub & a good-sized bedroom w/an expansive closet & delightful garden views. The dramatic wrought-iron, open-banister staircase w/stylish carpet runner ascends to the upper-level landing w/adjacent walk-out terrace & the home's private living quarters. The magnificent master suite w/grand double-door entry features an enormous bay window w/a sweeping panoramic view of hills, trees, Mt. Tamalpais, the Marin Headlands and Sutro Tower, a wall-to-wall closet & a luxurious marble tiled en-suite bath w/pedestal sink, soaking tub & large, separate walk-in shower. A 3rd bedroom w/big closet & en-suite full bath ends this floor. The amazing staircase w/remarkable glass-block window continues down to the gigantic basement level, which includes a laundry area w/stacked Kenmore washer/dryer, utility sink, 'wine cellar', ample storage & a giant parking garage. The fabulous, landscaped backyard w/spacious patio, birdbath and mature, colorful plants & trees completes this truly special home!
Property Details
Public Facts
- Property Type
- Single Family Residence
- Year Built
- 1931
- Lot Size
- 3,998.81 Sq. Ft.
Interior
- Total Bedrooms
- 3
- Total Bathrooms
- 3 (3 Full, 0 Half)
Exterior & Parking
No exterior & parking available.
Utilities & Misc
- HOA Fee
- $0 / Month
Neighborhood Insights
San Francisco Unified Schools
West Portal Elementary School
Grades K-5 • 0.4 mi
Miraloma Elementary School
Grades K-5 • 0.5 mi
Clarendon Alternative Elementary School
Grades K-5 • 0.6 mi
Sensitive Facilities
No sensitive facilities data found.
Neighborhood Comparison
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | 3.0 | 4.0 | 47% |
| Baths | 3.0 | 3.0 | 50% |
| Square foot | 1,925 | 2,202 | 43% |
| Lot Size | 3,998.81 | 3,804.785 | 56% |
| Price | $2.00M | $2.31M | 38% |
| Price per sq ft | $1.0K | $1.1K | 41% |
| Built year | 1931 | 1930 | 51% |
| HOA | $0 | $0 | 50% |
| Days on market | 10 | 175 | 1% |
Pricing History
Listed for Sale
Feb 25, 2026
$1,995,000
Initial Listing