604 Funston Avenue, San Francisco, CA, 94118 - Property Description

_yoast_indexnow_last_ping,1728528963

ffd_listing_title,415 Cornwall Street, San Francisco, CA, 94118

ffd_mls_id,424070777

ffd_salesforce_id,a0EUd000003GvwfMAC

num_of_fireplaces__c,0

num_of_rooms__c,9

of_units__c,0

address2__c,415 Cornwall Street, San Francisco, CA, 94118

pba__address_pb__c,415 Cornwall Street, San Francisco, CA, 94118

agent_only_remarks__c,Offers, if any, due Wednesday 10/16 @ 10AM. Please have clients make one of posted open house by appt times. Leased enclosed parking $250/mo at 190 Cornwall. Owner occ so open by app. Shoiwn with 24 hours notice. Please sign up here: https://calendly.com/subhi-barakat-vanguardproperties/415cornwall Escrow opened with Janette Marcelo at ORTC. Text Subhi 415-533-4600 w/ questions

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Built-In Refrigerator;Free Standing Electric Oven

architectural_style__c,Edwardian

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,1902

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-10-03T18:48:04.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,This newly renovated Edwardian home has been thoughtfully re-imagined, featuring an open floor plan, high-end finishes, hardwood floors, and soaring ceilings. With a serene lush garden accessible from multiple levels and a garden studio/office, 415 Cornwall St offers seamless indoor-outdoor living and smart lights and Sonos surround sound inside and out! The gated entry opens to a modern open-plan living, dining, and kitchen area with direct access to the patio and lush private garden. The Chef's kitchen boasts top-tier stainless steel appliances and an oversized island. Upstairs are two bedrooms and two bathrooms, including a spacious primary suite with a walk-in closet, a sitting room, a private deck, and a spa-like en-suite bathroom with a glass-walled shower, soaking tub, and dual vanities. The lower level features a family room configured for Dolby Atmos, currently used as a multimedia room/office, with a separate entrance and direct garden access. This level also includes a bedroom with an en-suite bathroom. Additional features are a Tesla Power Wall, solar panels, and leased parking nearby. Exceptionally well-located, just blocks from Presidio Park and the shops and restaurants of Clement Street.

district__c,SF District 1

electric__c,220 Volts,Battery Backup

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-10-10T02:47:59.000+0000

pba__latitude_pb__c,37.7846776

pba__latitude_property__c,37.7846776

laundry_features__c,Washer/Dryer Stacked Included

listed_date__c,2024-10-02

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Subhi

pba__listing_agent_lastname__c,Barakat

listing_agent_mls_id__c,812024

ffd_listingagentname,Subhi Barakat

listing_agent_number__c,1054445

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,VANG03

listing_office_name__c,Vanguard Properties

listing_office_number__c,1228

pba__listingprice_pb__c,2598000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.zillow.com/view-imx/f1196229-e5eb-4f5f-90dc-2c2e14d63578?wl=true&setAttribution=mls&initialViewType=pano

pba__longitude_pb__c,-122.4638675

mls_id__c,424070777

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-10-03

open_house_end__c,2024-10-10T20:00:00.000+0000

open_house_start__c,2024-10-10T17:00:00.000+0000

original_price__c,2598000

overall_days_on_market__c,-82090

parking_access__c,Independent

parking_features__c,Private

parking_type__c,Other

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,958.67

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000003GvwfMAC

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,2710

size__c,2710

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Cornwall

subdist__c,Inner Richmond

ffd_name,415 Cornwall Street, San Francisco, CA, 94118

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1902

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1727920341

ffd_listing_title,431 3rd Avenue, San Francisco, CA, 94118

ffd_mls_id,424027850

ffd_salesforce_id,a0EUd000001r0cPMAQ

num_of_rooms__c,12

of_units__c,4

address2__c,431 3rd Avenue, San Francisco, CA, 94118

pba__address_pb__c,431 3rd Avenue, San Francisco, CA, 94118

agent_only_remarks__c,One top floor unit is vacant along with one parking. One tenant claims protected status. https://app.disclosures.io/link/431-3rd-Avenue-9vj428q5. Please email for showings. Seller has limited knowledge of the property and buyer will be responsible for any inspections. https://4313rd.com/

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1922

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-26T18:49:22.000+0000

days_on_market__c,159

dom__c,157

ffd_description_pb,Fantastic four unit opportunity in the Richmond District. All are large one bedroom apartments boasting hardwood floors and great natural light. Parking for three cars. Shared yard. Terrific location. Just blocks to Golden Gate Park and The Presidio. Steps to the popular Clement St. commercial corridor with some of San Francisco's best restaurants, shops, and bars. Nearby access to public transit. An easy to manage investment in a great neighborhood.

district__c,SF District 1

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-10-03T01:49:45.000+0000

pba__latitude_pb__c,37.7804662

pba__latitude_property__c,37.7804662

listed_date__c,2024-04-26

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jonathan

pba__listing_agent_lastname__c,Britton

listing_agent_mls_id__c,807225

ffd_listingagentname,Jonathan Britton

listing_agent_number__c,1011257

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,BCWJ

listing_office_name__c,Britton & Company, W.J.

listing_office_number__c,689

pba__listingprice_pb__c,1575000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4612789

mls_id__c,424027850

parkingspaces__c,3

on_market_date__c,2024-04-26

original_price__c,1675000

overall_days_on_market__c,-81930

parking_features__c,Covered

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,420

pba__propertytype__c,Quadruplex

ListingId,a0EUd000001r0cPMAQ

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,3750

size__c,3750

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,3rd

subdist__c,Inner Richmond

ffd_name,431 3rd Avenue, San Francisco, CA, 94118

website_property_type__c,Quadruplex

pba__yearbuilt_pb__c,1922

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1727837810

ffd_listing_title,583 Arguello Boulevard, San Francisco, CA, 94118

ffd_mls_id,424069962

ffd_salesforce_id,a0EUd000003FCjtMAG

num_of_rooms__c,22

of_units__c,6

address2__c,583 Arguello Boulevard, San Francisco, CA, 94118

pba__address_pb__c,583 Arguello Boulevard, San Francisco, CA, 94118

agent_only_remarks__c,E-mail Natalie for showings - [email protected]. Two units vacant. Marketing package: https://www.allisonchapleau.com/listing/583-arguello-boulevard Disclosures: https://app.disclosures.io/link/583-Arguello-Boulevard-g6zfutab

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,0

year_build_text__c,1966

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-10-01T00:49:58.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,This well-maintained 6-unit building is located in the highly desirable Lone Mountain neighborhood, presenting an excellent investment opportunity. The property features a versatile unit mix of four two-bedroom units and two one-bedroom units, offering flexibility for prospective tenants. Two of the units will be delivered vacant, providing immediate leasing opportunities at market rates, while the remaining units are tenant-occupied, generating steady rental income. One of the building's standout features is its large garage, which offers six parking spaces. Currently, only one space is rented, leaving significant potential for additional rental income. Situated near the University of San Francisco (USF), this property is in an ideal location for attracting renters. Just a 2-3 minute walk from the building, tenants can take advantage of Rossi Park, which features a recently remodeled swimming facility, making it a great spot for recreation and relaxation. Additionally, residents can enjoy a variety of nearby dining and nightlife options, including popular spots like Altamirano, Eats, Price Hot, Magic Flute, Spruce, Social, and more, further enhancing the appeal of this prime location.

district__c,SF District 1

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-10-02T02:47:30.000+0000

pba__latitude_pb__c,37.7797498

pba__latitude_property__c,37.7797498

listed_date__c,2024-09-30

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Allison

pba__listing_agent_lastname__c,Chapleau

listing_agent_mls_id__c,981036

ffd_listingagentname,Allison Chapleau

listing_agent_number__c,981036

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,2080000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4590863

mls_id__c,424069962

parkingspaces__c,6

on_market_date__c,2024-09-30

open_house_end__c,2024-10-08T12:00:00.000+0000

open_house_start__c,2024-10-08T11:00:00.000+0000

original_price__c,2080000

overall_days_on_market__c,-82087

parking_features__c,Attached,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,438.45

pba__propertytype__c,5 or More Unit

ListingId,a0EUd000003FCjtMAG

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,4744

size__c,4744

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Arguello

subdist__c,Inner Richmond

ffd_name,583 Arguello Boulevard, San Francisco, CA, 94118

website_property_type__c,5 or More Unit

pba__yearbuilt_pb__c,1966

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1728352500

ffd_listing_title,833 Balboa 835 Street, San Francisco, CA, 94118

ffd_mls_id,424068609

ffd_salesforce_id,a0EUd000003Ep0vMAC

num_of_rooms__c,10

of_units__c,3

address2__c,833 Balboa 835 Street, San Francisco, CA, 94118

pba__address_pb__c,833 Balboa 835 Street, San Francisco, CA, 94118

agent_only_remarks__c,Please try to attend scheduled showings. Email [email protected] for more information. Escrow opened with Mark Adams of WFG. Buyer to satisfy themselves with square footage measurement. Sale subject to tenants rights.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,7

year_build_text__c,1922

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-30T18:50:37.000+0000

days_on_market__c,7

dom__c,7

ffd_description_pb,This renovated trophy duplex plus in-law unit is perfectly situated on a desirable tree-lined block in the Inner Richmond. With a robust monthly income and significant upside potential, this property boasts an excellent unit mix: two spacious full-floor flats with 3+ bedrooms and 1-1.5 bathrooms each, along with a 2 bedroom, 1-bathroom in-law unit. Additional amenities include a large backyard, and two car garage. The flats are currently tenant-occupied, generating strong rental income, and the in-law unit will be delivered vacant. Located at 833-835 Balboa St., you'll enjoy easy access to the best of the Inner Richmond, including Golden Gate Park, USF, and the vibrant Clement corridor, home to a variety of local restaurants, cafes, and boutiques. This is a fantastic investment opportunity.

district__c,SF District 1

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-10-08T01:48:40.000+0000

pba__latitude_pb__c,37.7988162

pba__latitude_property__c,37.7988162

listed_date__c,2024-09-25

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Greg

pba__listing_agent_lastname__c,Fulford

listing_agent_mls_id__c,804156

ffd_listingagentname,Greg Fulford

listing_agent_number__c,166013627

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,STHB

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,2050

pba__listingprice_pb__c,2295000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4361023

mls_id__c,424068609

parkingspaces__c,2

on_market_date__c,2024-09-30

open_house_end__c,2024-10-08T13:00:00.000+0000

open_house_start__c,2024-10-08T11:00:00.000+0000

original_price__c,2295000

overall_days_on_market__c,-82087

parking_features__c,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,710.09

pba__propertytype__c,Duplex

ListingId,a0EUd000003Ep0vMAC

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,3232

size__c,3232

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Balboa

subdist__c,Inner Richmond

ffd_name,833 Balboa 835 Street, San Francisco, CA, 94118

website_property_type__c,Duplex

pba__yearbuilt_pb__c,1922

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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