3970 San Bruno Avenue, San Francisco, CA, 94134 - Property Description

_yoast_indexnow_last_ping,1715079472

ffd_listing_title,514 Visitacion 520 Avenue, San Francisco, CA, 94134

ffd_mls_id,423919766

ffd_salesforce_id,a0EUd000000vkCbMAI

num_of_rooms__c,12

of_units__c,5

address2__c,514 Visitacion 520 Avenue, San Francisco, CA, 94134

pba__address_pb__c,514 Visitacion 520 Avenue, San Francisco, CA, 94134

agent_only_remarks__c,MLS expired by mistake. Bldg Still Available 5/5/24. Property Subject to Tenants Rights. Do Not Disturb Occupants. No sign or lockbox installed at property. PLEASE contact Agent with questions and/or more information. Cap 4.1% GRM 16.5%. Studio Apt pays $905 monthly rent. Showings will be conducted only with a submitted contingent offer or Buyer letter of intent attached with verification of POF. Tenant in unit 518 has Section 8 assistance. Approved ADU plans on SFDBI website. No permits yet. Seismic completed. New Roof 2019. Pre-escrow at Old Republic Title with Bonnie Hugh - 2566 Ocean Ave SF. Bring your Best Offer-Inspections OK! Seller Reserves the Right to accept, reject & counter any offers.

appliances__c,Free Standing Gas Range;Free Standing Refrigerator

architectural_style__c,Contemporary;Art Deco

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1927

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-01-25T11:50:02.000+0000

days_on_market__c,103

dom__c,102

ffd_description_pb,514-520 Visitacion Avenue is a classic 1927 detached Art Deco 5+ unit building consisting of (4) spacious one bedroom & one bath apartments + a studio apartment at street level. Currently each apartment is tenant occupied (three longer term and two newly leased). There are a pair of individual attached garages that may accommodate parking on each side at the front. Additionally, submitted architectural plans are awaiting full approval from the SF Department of Building Inspections to construct an ADU (1 bed + 1 bath) in one of the garages below. Earning over $100k gross rental income with minimal expenses (tenants pay PG&E + Recology) these 5 apartments yield a 4.1% cap rate. The Seismic retrofit compliance repairs have been completed and a new roof was installed in 2019. Each apartment provides natural light, wood and tiled floors, large living rooms which include a Murphy Bed in the closet + fireplace, and upgraded kitchens & baths, with the possibility to include an in-unit laundry set up. There is also a large shared concrete yard in the rear that could be reconfigured. Lots of upside potential to upgrade this classic SF investment to 6 or more units. Seller says bring offer!

district__c,SF District 10

exterior_features__c,Fenced Yard;Yard Space

external_listing__c,1

pba__floortype_pb__c,Laminate;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Wall Furnace

ffd_lastmodifieddate,2024-05-07T10:47:47.000+0000

pba__latitude_pb__c,37.710733

pba__latitude_property__c,37.710733

listed_date__c,2023-10-27

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Matthew

pba__listing_agent_lastname__c,Hilzendrager

listing_agent_mls_id__c,803362

ffd_listingagentname,Matthew T Hilzendrager

listing_agent_number__c,803362

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CIP

listing_office_name__c,Corcoran Icon Properties

listing_office_number__c,28936

pba__listingprice_pb__c,1595000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.40463

mls_id__c,423919766

parkingspaces__c,2

on_market_date__c,2024-01-25

original_price__c,1695000

overall_days_on_market__c,-81838

parking_features__c,Attached,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,453.13

pba__propertytype__c,5 or More Unit

ListingId,a0EUd000000vkCbMAI

roof__c,Tar/Gravel

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Unguarded Gate;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,3520

size__c,3520

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Visitacion

subdist__c,Visitacion Valley

ffd_name,514 Visitacion 520 Avenue, San Francisco, CA, 94134

website_property_type__c,5 or More Unit

window_features__c,Bay Window(s);Varies by Unit

pba__yearbuilt_pb__c,1927

pba__postalcode_pb__c,94134

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714820313

ffd_listing_title,427 Harkness Avenue, San Francisco, CA, 94134

ffd_mls_id,424027440

ffd_salesforce_id,a0EUd000001qJkOMAU

num_of_fireplaces__c,0

num_of_rooms__c,8

of_units__c,0

address2__c,427 Harkness Avenue, San Francisco, CA, 94134

pba__address_pb__c,427 Harkness Avenue, San Francisco, CA, 94134

agent_only_remarks__c,Reviewing offers Monday, May 6 @ 12pm

appliances__c,Dishwasher;Disposal;Free Standing Gas Range;Free Standing Refrigerator

bath_features__c,Tub w/Shower Over;Double Sinks

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1972

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-04-25T19:47:03.000+0000

days_on_market__c,9

dom__c,9

ffd_description_pb,Welcome to this delightful 4-bedroom, 2-bathroom home nestled in Visitacion Valley, offering stunning panoramic views of the south slope of San Bruno Mountain. The upper level is thoughtfully laid out with a spacious living room, dining area, and kitchen, all designed to take full advantage of the breathtaking scenery. This floor also hosts one bedroom with a walk-in closet, alongside two additional bedrooms and a full bathroom, ensuring ample space and privacy. On the ground level, the primary bedroom serves as a peaceful retreat, complete with an ensuite bathroom and a large walk-in closet. This level also features a versatile multi-purpose space that can seamlessly function as a family room, den, or home office, each providing direct access to the inviting rear deck and yard. Modern updates like central air conditioning, high-speed Ethernet in every room, and motorized blinds in key areas blend convenience with contemporary living. The home is equipped with an ADT security system and strategic security cameras, ensuring a safe and serene living environment. With its combination of comfort, connectivity, and serene outdoor spaces, this home at 427 Harkness Avenue is a wonderful sanctuary in San Francisco, perfect for both relaxation and entertainment.

district__c,SF District 10

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

ffd_lastmodifieddate,2024-05-04T10:47:07.000+0000

pba__latitude_pb__c,37.7179756

pba__latitude_property__c,37.7179756

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included;Stacked Only

listed_date__c,2024-04-25

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Dan

pba__listing_agent_lastname__c,McLean

listing_agent_mls_id__c,802350

ffd_listingagentname,Dan McLean

listing_agent_number__c,802350

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CBLUXURY

listing_office_name__c,Coldwell Banker Realty

listing_office_number__c,2128

pba__listingprice_pb__c,1095000

pba__listingtype__c,Sale

pba__listing_website__c,https://mls.kuu.la/share/collection/7cVJr?fs=1&vr=1&sd=1&initload=0&autorotate=0.32&autop=8&autopalt=1&thumbs=1

pba__longitude_pb__c,-122.4056902

mls_id__c,424027440

main_level__c,Family Room;Street Entrance;Primary Bedroom

master_bathroom_features__c,Tub w/Shower Over;Double Sinks

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-04-25

open_house_end__c,2024-05-04T16:00:00.000+0000

open_house_start__c,2024-05-04T14:00:00.000+0000

original_price__c,1095000

overall_days_on_market__c,-81929

parking_access__c,Side by Side

parking_features__c,Enclosed,Garage Door Opener,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,540.21

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001qJkOMAU

room_type__c,Family Room;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Carbon Mon Detector;Security System Leased

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

size__c,2027

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Harkness

subdist__c,Visitacion Valley

ffd_name,427 Harkness Avenue, San Francisco, CA, 94134

view__c,Bay;Mountains;Valley

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1972

pba__postalcode_pb__c,94134

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714561179

ffd_listing_title,146 Britton Street, San Francisco, CA, 94134

ffd_mls_id,424023831

ffd_salesforce_id,a0EUd000001qJkNMAU

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,146 Britton Street, San Francisco, CA, 94134

pba__address_pb__c,146 Britton Street, San Francisco, CA, 94134

agent_only_remarks__c,two unpermitted tenant occupied second units must be vacated and removed per NOV on file. Additional 4th unit is vacant and also needs to be removed. Call/Text/Leave Voicemail Gabe(Agent) for additional information or showing. 415-967-2099 ***DO NOT DISTURB OCCUPANTS FOR VIEWINGS. ONLY CALL LISTING AGENT (GABE QUEZADA) TO ESTABLISH A SHOWING TIME. 24-HOUR NOTICE REQUIRED, MINIMUM***

appliances__c,Insulated Water Heater;Hood Over Range;Free Standing Gas Range

architectural_style__c,Other

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,3

year_build_text__c,1912

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-04-25T19:47:03.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,Spacious home w/owner additions made without permits. Home shows well with updated kitchen and bath. Large 4,182 sqft. lot. Motivated owner wants to sell as-is condition. * Shown by appointment only. Do not Disturb occupants. Call/email/text agent for showing times

district__c,SF District 10

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fencing__c,Back Yard;Fenced

pba__floortype_pb__c,Laminate;Tile;Simulated Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,None

ffd_lastmodifieddate,2024-05-01T10:47:00.000+0000

pba__latitude_pb__c,37.7120942

pba__latitude_property__c,37.7120942

laundry_features__c,None

listed_date__c,2024-04-25

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Gabriel

pba__listing_agent_lastname__c,Quezada

listing_agent_mls_id__c,815180

ffd_listingagentname,Gabriel Quezada

listing_agent_number__c,1071355

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,BAYVW

listing_office_name__c,Bayview Real Estate & Mortgage

listing_office_number__c,166012925

pba__listingprice_pb__c,849000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4130299

mls_id__c,424023831

main_level__c,Partial Bath(s);Street Entrance

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,3

on_market_date__c,2024-04-25

original_price__c,849000

overall_days_on_market__c,-81929

parking_access__c,Side by Side

parking_features__c,Other

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

price_reduced__c,1

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001qJkNMAU

road_surface_type__c,Asphalt

roof__c,Composition

room_type__c,Bonus Room;Kitchen;Converted Garage;Living Room;Baths Other;Attic;Primary Bathroom

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

size__c,1350

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Britton

subdist__c,Visitacion Valley

ffd_name,146 Britton Street, San Francisco, CA, 94134

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1912

pba__postalcode_pb__c,94134

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714618651

ffd_listing_title,263 Raymond Avenue, San Francisco, CA, 94134

ffd_mls_id,424019822

ffd_salesforce_id,a0EUd000001l67qMAA

num_of_fireplaces__c,1

num_of_rooms__c,6

of_units__c,0

address2__c,263 Raymond Avenue, San Francisco, CA, 94134

pba__address_pb__c,263 Raymond Avenue, San Francisco, CA, 94134

agent_only_remarks__c,Offer due date 05-10 at 1:00 PM, Pls email for Disclosure package. Home and Pest Inspection will be ready next week. For questions, please email: [email protected]. Buyers to verify property configurations and square footage. Downstairs bedroom and full bathroom with permit. Pre-Escrow open with WFG title Company, Escrow officer- [email protected], (415) 753-3003, Escrow # 24-128374.

appliances__c,Dishwasher;Microwave;Disposal;Free Standing Gas Oven

architectural_style__c,Contemporary

bath_features__c,Tile;Low-Flow Toilet(s);Low-Flow Shower(s);Window;Stone

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1953

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Ceiling Fan(s)

ffd_createddate,2024-04-17T10:47:20.000+0000

days_on_market__c,14

dom__c,14

ffd_description_pb,Discover this recently renovated gem nestled in the convenient locale of Visitation Valley. Boasting two bedrooms and one bath upstairs, the home features a brand-new kitchen with elegant granite countertops, offering both functionality and style. Step into the inviting backyard, and fragrant lemon trees. Downstairs, find an additional bedroom (with Permit), complemented by a full bath (with Permit) and a convenient wet bar, perfect for entertaining guests. Don't let this opportunity slip away make this beautiful house your home today. New Roof and New Paint. Don't miss the chance to own a piece of tranquility in Visitation Valley. Please note that Kitchen, living room, bedrooms, back yard are Virtual Staging

district__c,SF District 10

driveway_sidewalks__c,Paved Driveway

electric__c,220 Volts in Kitchen,220 Volts in Laundry

entry_level__c,0

exterior_features__c,Entry Gate

external_listing__c,1

fencing__c,Back Yard;Fenced;Full

fireplace_features__c,Living Room

pba__floortype_pb__c,Laminate;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Wall Furnace;Gas;Fireplace(s)

interior_features__c,Formal Entry;Skylight(s);Wet Bar

ffd_lastmodifieddate,2024-05-02T02:46:49.000+0000

pba__latitude_pb__c,37.7134516

pba__latitude_property__c,37.7134516

laundry_features__c,Hookups Only;Sink

listed_date__c,2024-03-28

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Mary

pba__listing_agent_lastname__c,Wong

listing_agent_mls_id__c,378415

ffd_listingagentname,Mary J Wong

listing_agent_number__c,378415

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CIP12

listing_office_name__c,Corcoran Icon Properties

listing_office_number__c,28941

pba__listingprice_pb__c,1188000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.263raymondave.com

pba__longitude_pb__c,-122.408472

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

mls_id__c,424019822

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-17

open_house_end__c,2024-05-04T16:30:00.000+0000

open_house_start__c,2024-05-04T14:00:00.000+0000

original_price__c,1188000

overall_days_on_market__c,-81921

parking_access__c,Tandem

parking_features__c,Attached,Garage Door Opener

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001l67qMAA

road_surface_type__c,Asphalt,Paved

roof__c,Shake

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Security Gate;Carbon Mon Detector;Double Strapped Water Heater

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

size__c,1353

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Raymond

subdist__c,Visitacion Valley

ffd_name,263 Raymond Avenue, San Francisco, CA, 94134

view__c,City Lights

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Window Screens

pba__yearbuilt_pb__c,1953

pba__postalcode_pb__c,94134

ffd_media,Array

ffd_media_tags,Array

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