6 Pueblo Street, San Francisco, CA, 94134 - Property Description

_yoast_indexnow_last_ping,1713362261

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

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,Property still is working on touch up, not ready to show yet.

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

pba__bedrooms_pb__c,2

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

dom__c,0

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 bathroom, complemented by a full bath and a convenient wet bar, perfect for entertaining guests. Don't let this opportunity slip away make this beautiful house your home today. 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,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

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

ffd_lastmodifieddate,2024-04-17T13:46:35.000+0000

pba__latitude_pb__c,37.7134516

pba__latitude_property__c,37.7134516

laundry_features__c,Hookups Only

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__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

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

_yoast_indexnow_last_ping,1712969747

ffd_listing_title,975 Girard Street, San Francisco, CA, 94134

ffd_mls_id,424016702

ffd_salesforce_id,a0EUd000001UMx0MAG

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,975 Girard Street, San Francisco, CA, 94134

pba__address_pb__c,975 Girard Street, San Francisco, CA, 94134

agent_only_remarks__c,Easy to show. Please text Bill at 415-309-7279.

appliances__c,Dishwasher;Hood Over Range;Free Standing Refrigerator

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,1946

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-03-19T17:46:55.000+0000

days_on_market__c,24

dom__c,24

ffd_description_pb,975 Girard Street is a 3 bedroom, 3 bath home with modern comforts and stunning views to the Bay and beyond. Beautiful hardwood floors and recessed lighting accentuate the contemporary appeal of this amazing home. Enter the main level with a spacious living room, two bedrooms and two full baths, with one bath ensuite to the primary bedroom. The modern, eat-in kitchen is also on this level and offers views, plentiful cabinets, stainless steel appliances and direct access to a large deck that showcases the wonderful views. On the lower level is a large family room, finished with hardwood floors, high ceilings, recessed lighting and a slider to a lower deck, all with the same fantastic views, and access to the large backyard with slate patio and a large garden area. There is another spacious bedroom and a full bath on this level. As a bonus, this home features a large laundry room with a utility sink. Take advantage of the vibrant San Francisco lifestyle with easy access to the city's amenities. Perched at the top of the hill, 975 Girard is ideally located on the cusps of the popular Portola district, with easy access to the shops and restaurants of San Bruno Avenue, beautiful McLaren Park, and freeways.

district__c,SF District 10

driveway_sidewalks__c,Paved Sidewalk,Sidewalk/Curb/Gutter

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Bamboo;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-04-13T00:46:51.000+0000

pba__latitude_pb__c,37.7205377

pba__latitude_property__c,37.7205377

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2024-02-14

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,William

pba__listing_agent_lastname__c,Kitchen

listing_agent_mls_id__c,803707

ffd_listingagentname,William J Kitchen Jr.

listing_agent_number__c,803707

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,999000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4015593

lower_level__c,Bedroom(s),Family Room

mls_id__c,424016702

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-03-19

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

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

original_price__c,999000

overall_days_on_market__c,-81892

patio_and_porch_features__c,Uncovered Deck

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001UMx0MAG

road_surface_type__c,Paved

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

size__c,1605

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Girard

subdist__c,Visitacion Valley

ffd_name,975 Girard Street, San Francisco, CA, 94134

view__c,Bay

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1946

pba__postalcode_pb__c,94134

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1709812521

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,*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,42

dom__c,42

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-03-07T11:48:29.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

price_reduced__c,1

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

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

ffd_mls_id,422713413

ffd_salesforce_id,a0E8W00000a6KEfUAM

num_of_fireplaces__c,1

num_of_rooms__c,8

of_units__c,0

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

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

agent_only_remarks__c,Occupied property - do not disturb the occupants - exterior drive by inspections only - no inspections or viewings. Buyer responsible for removing occupants after closing at their expense. Cash offers only no financing allowed. All offers must be submitted at www.Hubzu.com. email/ fax offers NOT considered. Buyers' premium paid at closing by buyer. See www.HUBZU.COM to place an offer, for fee details, and availability. All potential buyers are asked to check with City, County, Zoning, Tax, and other records to determine all details on this property listed above to their satisfaction. This is an AS-IS REO property.

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1937

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2022-12-29T23:45:33.000+0000

days_on_market__c,476

dom__c,460

ffd_description_pb,Left my heart in San Francisco with this amazing opportunity. This single-family residence in this area will sell quick. If you blink it will be sold. This is a great opportunity to put your finishing touches on this gem. Don't miss this unique chance to say ''hello'' to your new dream getaway! All potential buyers are asked to check with City, County, Zoning, Tax, and other records to determine all details on this property listed above to their satisfaction. This is an AS-IS REO property.

district__c,SF District 10

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Natural Gas

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

pba__latitude_pb__c,37.7182194

pba__latitude_property__c,37.7182194

listed_date__c,2022-12-29

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Neven

pba__listing_agent_lastname__c,Spralja

listing_agent_mls_id__c,817116

ffd_listingagentname,Neven Spralja

listing_agent_number__c,1076015

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,REALH

listing_office_name__c,RealHome Services and Solutions, Inc.

listing_office_number__c,26036

pba__listingprice_pb__c,908900

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4054893

mls_id__c,422713413

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2022-12-29

original_price__c,1060000

overall_days_on_market__c,-81446

parking_access__c,Independent

parking_features__c,Attached

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

pba__propertytype__c,Single Family Residence

ListingId,a0E8W00000a6KEfUAM

roof__c,Composition

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

size__c,1412

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Harkness

subdist__c,Visitacion Valley

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

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1937

pba__postalcode_pb__c,94134

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713437851