354 Niagara Avenue, San Francisco, CA, 94112 - Property Description

_yoast_indexnow_last_ping,1742267975

ffd_listing_title,778 34th Avenue, San Francisco, CA, 94121

ffd_mls_id,425007957

ffd_salesforce_id,a0EUd000004XGy9MAG

num_of_fireplaces__c,0

num_of_rooms__c,9

of_units__c,0

pba__address_pb__c,778 34th Avenue, San Francisco, CA, 94121

address2__c,778 34th Avenue, San Francisco, CA, 94121

agent_only_remarks__c,Owner occupied, please allow 24 hours notice for showing. 3-D Matterport under virtual media.

appliances__c,Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;Built-In Refrigerator

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,5

pba__bedrooms_pb__c,5

year_build_text__c,1926

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-03-18T01:47:11.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,This gorgeous spacious home was remodeled in 2018 from studs to refine finishes. A captivating high ceiling offers an abundance of natural light throughout. Lovely gourmet kitchen included custom cabinetries, Thermador gas stove, SS appliances and marble island counter. 2 rear ensuite with sophisticated designed baths, a bonus room, laundry room and guest bath completes the upper level. On the first floor a generous size family room, ensuite, bath and additional bedroom with access to the private backyard. Other features are surround sound, skylights, French white oak flooring, radiant heat and much more. Located within distance to Spreckels Lake in Golden Gate Park. A variety of desirable restaurants, shops and public transportation nearby.

district__c,SF District 1

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard;Fenced

pba__floortype_pb__c,Other;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Radiant Floor

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2025-03-18T02:47:16.000+0000

pba__latitude_pb__c,37.7744377

pba__latitude_property__c,37.7744377

laundry_features__c,Upper Floor;Inside Area

listed_date__c,2025-01-22

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Anna

pba__listing_agent_lastname__c,Lew

listing_agent_mls_id__c,331742

ffd_listingagentname,Anna K Lew

listing_agent_number__c,331742

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP3

listing_office_name__c,Compass

listing_office_number__c,27342

pba__listingprice_pb__c,3295000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=kibTNchXSC7&mls=1

pba__longitude_pb__c,-122.4937412

lower_level__c,Bedroom(s),Family Room,Full Bath(s),Garage

mls_id__c,425007957

main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Primary Bedroom

master_bathroom_features__c,Shower Stall(s);Tub;Walk-In Closet;Closet

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-03-17

original_price__c,3295000

overall_days_on_market__c,-82255

parking_access__c,Tandem

parking_features__c,Attached,Covered,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access

parking_type__c,On Site (Single Family Only)

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,1072.94

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000004XGy9MAG

road_surface_type__c,Paved

room_type__c,Bonus Room;Laundry;Kitchen;Living Room;Family Room;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Security Gate

selling_agent_number__c,0

selling_co_agent_number__c,0

selling_co_office_number__c,0

pba__status__c,Active

pba__totalarea_pb__c,3071

size__c,3071

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,34th

subdist__c,Outer Richmond

ffd_name,778 34th Avenue, San Francisco, CA, 94121

website_property_type__c,Single Family Home

window_features__c,Bay Window(s)

pba__yearbuilt_pb__c,1926

pba__postalcode_pb__c,94121

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530962824-1.jpg

_yoast_indexnow_last_ping,1742267973

ffd_listing_title,1647 Cabrillo Street, San Francisco, CA, 94121

ffd_mls_id,425020737

ffd_salesforce_id,a0EUd000004XGgPMAW

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,1

pba__address_pb__c,1647 Cabrillo Street, San Francisco, CA, 94121

address2__c,1647 Cabrillo Street, San Francisco, CA, 94121

agent_only_remarks__c,Presale escrow opened with Janet Lee at Fidelity National Title at 2661 Ocean Avenue. SF. Ca 94132 TEL. NO. 415-661-1960 Escrow no. FSFM-1072500260 Seller is broker at Focus Realty and the listing agent is related to the seller

appliances__c,Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator

architectural_style__c,Modern/High Tech;Flat

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1922

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-03-18T00:47:39.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Modern Elegance Meets Unmatched Convenience in the Richmond District Step into this beautifully renovated 2-bedroom, 2-bathroom TIC flat, where modern sophistication meets everyday comfort. Nestled in one of the Richmond District's most desirable neighborhoods, this bright and airy corner unit sits directly across from the prestigious Argonne Elementary School and is just a block from Golden Gate Park offering the perfect blend of urban convenience and natural beauty. Every inch of this home has been meticulously upgraded, featuring: ✅ Brand-new windows, electrical, plumbing, and drywall ✅ Recessed lighting for a bright, contemporary ambiance ✅ High-end appliances throughout, plus a new high-grade tankless water heater & furnace for optimal efficiency ✅ Extra-large independent garage & additional storage rooma rare find! Designed to impress, this fully detached corner unit at Cabrillo & 18th Avenue is bathed in natural light, creating a warm and inviting atmosphere. The spacious dual master suites offer flexibility, with one featuring ensuite access for guests. Walking to local shops, restaurants, and park. This stunning flat is the perfect place to call home!

district__c,SF District 1

entry_level__c,0

external_listing__c,1

hoa_fee_includes__c,Insurance,Insurance on Structure,Maintenance Exterior,Management,Water

pba__hoafees__c,250

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Natural Gas

ffd_lastmodifieddate,2025-03-18T02:47:16.000+0000

pba__latitude_pb__c,37.7746613

pba__latitude_property__c,37.7746613

laundry_features__c,Washer/Dryer Stacked Included

listed_date__c,2025-03-16

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Paul

pba__listing_agent_lastname__c,Koncar

listing_agent_mls_id__c,811873

ffd_listingagentname,Paul Koncar

listing_agent_number__c,1053702

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,FCSR

listing_office_name__c,Focus Realty

listing_office_number__c,1058

pba__listingprice_pb__c,938000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4765853

mls_id__c,425020737

master_bathroom_features__c,Low-Flow Toilet(s);Tile;Low-Flow Shower(s)

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-03-17

open_house_end__c,2025-03-18T13:00:00.000+0000

open_house_start__c,2025-03-18T11:00:00.000+0000

original_price__c,938000

overall_days_on_market__c,-82255

parking_access__c,Independent

parking_features__c,Attached,Covered,Enclosed

parking_type__c,On Site (Single Family Only)

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,987.37

pba__propertytype__c,Tenancy In Common

ListingId,a0EUd000004XGgPMAW

roof__c,Bitumen

room_type__c,Kitchen;Great Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Carbon Mon Detector

selling_agent_number__c,0

selling_co_agent_number__c,0

selling_co_office_number__c,0

pba__status__c,Active

pba__totalarea_pb__c,950

size__c,950

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Cabrillo

subdist__c,Central Richmond

ffd_name,1647 Cabrillo Street, San Francisco, CA, 94121

website_property_type__c,Tenancy In Common

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1922

pba__postalcode_pb__c,94121

_yoast_indexnow_last_ping,1742267834

ffd_listing_title,495 32nd Avenue, San Francisco, CA, 94121

ffd_mls_id,424066875

ffd_salesforce_id,a0EUd0000039YvBMAU

num_of_rooms__c,52

of_units__c,12

pba__address_pb__c,495 32nd Avenue, San Francisco, CA, 94121

address2__c,495 32nd Avenue, San Francisco, CA, 94121

agent_only_remarks__c,Please email or call Rachel Abraham-Pollard at [email protected] or 415.828.3964 for more information or to schedule a showing.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,0

year_build_text__c,1927

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-19T19:49:10.000+0000

days_on_market__c,179

dom__c,179

ffd_description_pb,The Del Rey Apartments offer a unique chance to own a prime property in the highly desirable Richmond District. This stately corner building features 12 exceptionally spacious, house-like units, ideal for rentals or TIC conversions. The property includes 8 2bd/2ba, 3 1bd units, and 1 Penthouse. Seven units will be delivered vacant, providing immediate flexibility for new owners. The size and scale of these units are rare for San Francisco, with each featuring large separate living and dining rooms offering opportunities to expand bedroom counts or remodel with modern finishes and amenities. Many units enjoy panoramic views of the Richmond District, Golden Gate Bridge. The building showcases classic period details including hardwood floors, built-in cabinetry, and timeless architectural elements. Additionally, the building is serviced by an elevator, enhancing convenience for tenants. The garage provides parking for 5 cars, and a large basement offers ideal storage space for tenants or owners. Currently, the electrical system is being upgraded to 400 amps with new panels and breakers, ensuring the property is equipped for modern living. Tremendous opportunity for contractors or developers with an appreciation and understanding of this asset's tremendous potential.

district__c,SF District 1

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Steam

ffd_lastmodifieddate,2025-03-18T02:47:55.000+0000

pba__latitude_pb__c,37.7800391

pba__latitude_property__c,37.7800391

listed_date__c,2024-09-19

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Adam

pba__listing_agent_lastname__c,Filly

listing_agent_mls_id__c,803097

ffd_listingagentname,Adam D Filly

listing_agent_number__c,803097

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP13

listing_office_name__c,Compass Commercial

listing_office_number__c,27689

pba__listingprice_pb__c,5800000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4924709

mls_id__c,424066875

parkingspaces__c,5

on_market_date__c,2024-09-19

original_price__c,5800000

overall_days_on_market__c,-82076

parking_features__c,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,284.31

pba__propertytype__c,5 or More Unit

ListingId,a0EUd0000039YvBMAU

sale_date__c,1800-01-01

sale_price__c,0

selling_agent_number__c,0

selling_co_agent_number__c,0

selling_co_office_number__c,0

pba__status__c,Active

pba__totalarea_pb__c,20400

size__c,20400

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,32nd

subdist__c,Central Richmond

ffd_name,495 32nd Avenue, San Francisco, CA, 94121

website_property_type__c,5 or More Unit

pba__yearbuilt_pb__c,1927

pba__postalcode_pb__c,94121

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530844490-1.jpg

_yoast_indexnow_last_ping,1742267971

ffd_listing_title,900 Bush Street #314, San Francisco, CA, 94109

ffd_mls_id,425020854

ffd_salesforce_id,a0EUd000004XBSDMA4

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,187

pba__address_pb__c,900 Bush Street #314, San Francisco, CA, 94109

address2__c,900 Bush Street #314, San Francisco, CA, 94109

agent_only_remarks__c,Buyer credits considered. Please call or text me at 415-307-7991 to schedule a showingdo not use ShowingTime. Parking: if you park in the white or yellow loading zones out front of the building, please inform the front desk security so they are aware. Important Notes: This is a fixer unit and is not stagedplease inform your clients before scheduling a showing. The assigned parking space that comes with the unit will be reassigned at COE (the seller's parking space will not directly transfer to the buyer). Additional parking and storage may be available through the HOA for an extra cost, subject to availability. If your clients are using financing, please call to discuss, as traditional financing will not be approved in the building at this time. The HOA is set to begin a large waterproofing project in 2025, which will include a special assessment for each unit. The pet policy is ONE domestic cat or dog per unit UNDER 20LBS. There is no opportunity for an in-unit washer/dryer at this time. The common area laundry room is very well cared for on a daily basis. Buyers are advised to independently verify the accuracy of square footage and review all disclosures before submitting an offer. The seller reserves the right to accept, reject, or counter any offer.

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Refrigerator;Free Standing Electric Range;See Remarks

architectural_style__c,Contemporary

bath_features__c,See Remarks

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1982

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-03-17T21:47:42.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,First Time on the Market in Over 30 Years! Unit #314 presents an unbelievable opportunity to enter the San Francisco condo market at an unbeatable price. This two-bedroom, two-bathroom unit with one-car parking is priced to sell and won't last long! With recent plumbing upgrades throughout and a suite of brand-new appliances in the kitchen, you can bring your design vision to life and customize the rest of the space to your exact style and needs. The building's HOA covers an extensive list of amenities, including water, trash, heat, basic cable, high-speed Internet (including WiFi), one-car parking in the building's secured garage, 24/7 security in the lobby, a gym, a pool, and a plaza. Located at 900 Bush Street in Lower Nob Hill, La Galleria offers prime city living just steps from some of San Francisco's top-rated Michelin-starred restaurants, cozy cafes, and exciting landmarks. Impress your friends and family by taking them to one of the many nearby world-renowned hotels with jaw-dropping city views. Whether you're looking for a vibrant urban lifestyle or a long-term investment, this is a rare chance to own a piece of San Francisco in a full-service building at an incredible value. Please reach out for details on the building's upcoming improvement project. Talk with you soon

district__c,SF District 8

driveway_sidewalks__c,Gated,Paved Sidewalk,Shared Driveway,Sidewalk/Curb/Gutter

entry_level__c,0

exterior_features__c,Balcony;Uncovered Courtyard

external_listing__c,1

pba__floortype_pb__c,Carpet;Tile;Wood;See Remarks

hoa_fee_includes__c,Cable TV,Common Areas,Door Person,Elevator,Heat,Insurance on Structure,Internet,Maintenance Grounds,Management,Pool,Security,Sewer,Trash,Water

pba__hoafees__c,1332

pba__hoafrequency_pb__c,Monthly

hoa_name__c,La Galleria Condo Owners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Baseboard

ffd_lastmodifieddate,2025-03-18T02:47:16.000+0000

pba__latitude_pb__c,37.7899451

pba__latitude_property__c,37.7899451

laundry_features__c,See Remarks

listed_date__c,2025-03-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Samantha

pba__listing_agent_lastname__c,Hailer

listing_agent_mls_id__c,813131

ffd_listingagentname,Samantha Hailer

listing_agent_number__c,1059614

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,STHB4

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,28397

pba__listingprice_pb__c,398000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4127266

mls_id__c,425020854

main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom

master_bathroom_features__c,Tub w/Shower Over;Low-Flow Toilet(s);Tile;Closet

master_property__c,a0O1I000001VhzaUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-03-17

open_house_end__c,2025-03-18T14:00:00.000+0000

open_house_start__c,2025-03-18T13:00:00.000+0000

original_price__c,398000

overall_days_on_market__c,-82255

parking_access__c,Side by Side

parking_features__c,Assigned,Attached,EV Charging,Garage Door Opener,Interior Access,Side-by-Side,Underground Parking,See Remarks

parking_type__c,On Site - Assigned (Condo Only)

patio_and_porch_features__c,Uncovered Patio

pba__pendingdate__c,1800-01-01

pba__pool_pb__c,1

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,496.26

pba__propertytype__c,Condominium

ListingId,a0EUd000004XBSDMA4

sale_date__c,1800-01-01

sale_price__c,0

selling_agent_number__c,0

selling_co_agent_number__c,0

selling_co_office_number__c,0

pba__status__c,Active

pba__totalarea_pb__c,802

size__c,802

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Bush

subdist__c,Downtown

ffd_name,900 Bush Street #314, San Francisco, CA, 94109

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1982

pba__postalcode_pb__c,94109

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530962676-1.jpg