791 San Jose 791A Avenue, San Francisco, CA, 94110 - Property Description

_yoast_indexnow_last_ping,1726513016

ffd_listing_title,461 27th Street, San Francisco, CA, 94114

ffd_mls_id,424065848

ffd_salesforce_id,a0EUd0000037Y4tMAE

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,461 27th Street, San Francisco, CA, 94114

pba__address_pb__c,461 27th Street, San Francisco, CA, 94114

agent_only_remarks__c,For showings, disclosures, or questions please contact Greg Fulford ([email protected] or 415.305.3251). 24-hour notice requested for all showings. *We have multiple square footage measurements. Buyer is advised to investigate to their own satisfaction. Graphic Artist: 4,075 sqft (house) + 90 sqft (detached office) and Tax Records: 3,836 sqft.

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,1900

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Greg Fulford

pba__contingentdate__c,1800-01-01

cooling__c,Heat Pump

ffd_createddate,2024-09-16T18:47:16.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Halfway up one of Noe Valley's famed hillsides, this enchanting home has been painstakingly remodeled for consummate modern living. The charming classicism of the Edwardian faade belies the sleek contemporary aesthetics of the interiors. It has an ideal floor plan with wide-plank white oak floors, multiple skylights, southern natural light, lovely views, AC, and several outdoor spaces. Beyond the living room and formal dining room is an open kitchen and bright family room boasting streamlined appliances and cabinetry, a gas fireplace surrounded by useful built-ins, and a wall of windows offering an idyllic view and opening to a deck. A powder room is nearby. The principal bedroom gazes out over the neighborhood through a wall of sliding glass that opens to a private deck; adjoining are a walk-in closet and an en-suite bath with a soaking tub and a glass-walled shower. The two guest bedrooms on this floor share a skylit hall bath. Relaxation and casual entertaining are effortless in the garden level family room, with its expertly appointed wet bar and direct access to the serene south-facing garden and freestanding glass-walled office. Completing the home is an additional bedroom and bath, mudroom, gym, and 1 car garage. Ideally located near the restaurants and shops of 24th St.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fireplace_features__c,Family Room;Gas Log

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Radiant Floor

ffd_lastmodifieddate,2024-09-16T18:47:16.000+0000

pba__latitude_pb__c,37.7465281

pba__latitude_property__c,37.7465281

laundry_features__c,Washer/Dryer Stacked Included;Upper Floor

listed_date__c,2024-09-16

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Neill

pba__listing_agent_lastname__c,Bassi

listing_agent_mls_id__c,807780

ffd_listingagentname,Neill Bassi

listing_agent_number__c,1027326

listing_co_agent_mls_id__c,804156

listing_co_agent_number__c,166013627

listing_co_office_mls_id__c,STHB

listing_co_office_name__c,Sotheby's International Realty

listing_co_office_number__c,2050

listing_office_mls_id__c,STHB

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,2050

pba__listingprice_pb__c,5900000

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/1009734582/232788845d?share=copy

pba__longitude_pb__c,-122.4304969

mls_id__c,424065848

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-09-16

open_house_end__c,2024-09-17T14:00:00.000+0000

open_house_start__c,2024-09-17T12:00:00.000+0000

original_price__c,5900000

overall_days_on_market__c,-82073

parking_access__c,Independent

parking_features__c,Attached,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,1447.85

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000037Y4tMAE

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security System Owned

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

size__c,4075

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,27th

subdist__c,Noe Valley

ffd_name,461 27th Street, San Francisco, CA, 94114

view__c,City Lights;Hills

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726512984

ffd_listing_title,375 Day Street, San Francisco, CA, 94131

ffd_mls_id,424065843

ffd_salesforce_id,a0EUd0000037DOdMAM

num_of_rooms__c,10

of_units__c,2

address2__c,375 Day Street, San Francisco, CA, 94131

pba__address_pb__c,375 Day Street, San Francisco, CA, 94131

agent_only_remarks__c,Disclosure package available upon request. No written leases. Some of the tenants have protected status. Unwarranted ADU in garage. Total rent collections are $5,829 month. Shown by appointment only with a 48-hour notice. Contact John Downing to schedule a date and time. Do not use ShowingTime. Pre-escrow opened with Gerrie Brindley at Chicago Title.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1908

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-16T10:49:39.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Investors and contractors opportunity knocks to acquire a duplex in coveted Noe Valley. This asset sits on a deep 2,850 square foot lot that measures 25' x 114'. First time on the market in 35 years. Property needs TLC and is TENANT OCCUPIED. Excellent location with close proximity to the J Church train, tech shuttles, and Highway 280. Furthermore, it's just a short walk on pedestrian friendly slow Sanchez Street to the Noe Valley Town Square, Whole Foods grocery store, restaurants, and shops on 24th Street.

district__c,SF District 5

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-09-16T18:48:31.000+0000

pba__latitude_pb__c,37.7425105

pba__latitude_property__c,37.7425105

listed_date__c,2024-08-22

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,John

pba__listing_agent_lastname__c,Downing

listing_agent_mls_id__c,807596

ffd_listingagentname,John Downing

listing_agent_number__c,1023008

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,DCRE

listing_office_name__c,Downing & Company Real Estate

listing_office_number__c,22398

pba__listingprice_pb__c,1295000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4303103

mls_id__c,424065843

parkingspaces__c,1

on_market_date__c,2024-09-16

original_price__c,1295000

overall_days_on_market__c,-82073

parking_features__c,Attached

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,417.74

pba__propertytype__c,Duplex

ListingId,a0EUd0000037DOdMAM

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

size__c,3100

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Day

subdist__c,Noe Valley

ffd_name,375 Day Street, San Francisco, CA, 94131

website_property_type__c,Duplex

pba__yearbuilt_pb__c,1908

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726484034

ffd_listing_title,1210 Dolores Street, San Francisco, CA, 94110

ffd_mls_id,424062645

ffd_salesforce_id,a0EUd0000037Bt3MAE

num_of_rooms__c,14

of_units__c,3

address2__c,1210 Dolores Street, San Francisco, CA, 94110

pba__address_pb__c,1210 Dolores Street, San Francisco, CA, 94110

agent_only_remarks__c,Preview showing for agents 9/17 5:30-7 PM. Active on MLS 9/16. This one will blow your mind. Put on your skinny tie and come check out this 50's gem. All vacant. No evictions or OMI's. Seller concessions to buyer available.

appliances__c,Dishwasher;Gas Water Heater;Disposal;Built-In Gas Range;Free Standing Gas Oven;Built-In Refrigerator

architectural_style__c,Mid-Century

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,6

year_build_text__c,0

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-16T01:47:11.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,One-of-a-kind gem built circa 1959. Mad Men's Don Draper would have loved living here. Vacant 3-unit building with super cool 2-level 3br/2ba owner's unit with an elevator from the garage to both levels! Awesome crows nest on the upper floor with access to temporary deck area (not warranted). Amazing 50's detail, wood paneling and stunningly gorgeous ornate wood flooring with intricate inlay. 2 additional flats, one a large 1 bedroom, the other a 2 bedroom. Huge space down for expansion? 4 car parking, 2 in one garage and one in each of the other two garages. Nice west facing yard. Quick stroll to 24th Street, or a couple blocks to the best that Valencia street can offer with amazing local dining and shops. Once in a life time opportunity!

district__c,SF District 5

electric__c,Passive Solar

external_listing__c,1

pba__floortype_pb__c,Carpet;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Central;Gas

interior_features__c,Storage Area(s);Elevator

ffd_lastmodifieddate,2024-09-16T10:49:37.000+0000

pba__latitude_pb__c,37.749749

pba__latitude_property__c,37.749749

laundry_features__c,Washer/Dryer Hookups;In Common Area

listed_date__c,2024-07-04

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Ken

pba__listing_agent_lastname__c,Eggers

listing_agent_mls_id__c,526543

ffd_listingagentname,Ken A Eggers

listing_agent_number__c,526543

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CIP01

listing_office_name__c,Corcoran Icon Properties

listing_office_number__c,28939

pba__listingprice_pb__c,2995000

pba__listingtype__c,Sale

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

pba__longitude_pb__c,-122.4253349

mls_id__c,424062645

parkingspaces__c,4

on_market_date__c,2024-09-15

open_house_end__c,2024-09-19T18:30:00.000+0000

open_house_start__c,2024-09-19T17:30:00.000+0000

original_price__c,2995000

overall_days_on_market__c,-82072

parking_features__c,Attached,Garage,Garage Door Opener,Side-by-Side,Tandem Garage

patio_and_porch_features__c,Uncovered Deck

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,755.36

pba__propertytype__c,Triplex

ListingId,a0EUd0000037Bt3MAE

roof__c,Tar/Gravel;Flat

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

size__c,3965

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Dolores

subdist__c,Noe Valley

ffd_name,1210 Dolores Street, San Francisco, CA, 94110

view__c,City;City Lights;Bay;Water;San Francisco;Twin Peaks;Hills

website_property_type__c,Triplex

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726512966

ffd_listing_title,464 Hoffman Avenue, San Francisco, CA, 94114

ffd_mls_id,424065583

ffd_salesforce_id,a0EUd0000036unNMAQ

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,464 Hoffman Avenue, San Francisco, CA, 94114

pba__address_pb__c,464 Hoffman Avenue, San Francisco, CA, 94114

agent_only_remarks__c,Put your best foot forward - seller will consider ALL offers. Seller is licensed real estate agent in state of CA. Escrow opened with Michelle Patterson at WFG Title. Call or text Luba at 415-307-1392 for showings. Available disclosures at https://app.disclosures.io/link/464-Hoffman-Ave-id3kz285 - will be updated as they come in.

appliances__c,Dishwasher;Hood Over Range;Built-In Gas Range;Gas Plumbed

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1946

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Jesse E Fowler

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-14T02:46:57.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,Welcome to this meticulously remodeled 3-bedroom, 2.5-bath modern retreat w/ 1-car parking, nestled in the heart of Noe Valley on an idyllic tree-lined street. Thoughtfully designed for seamless indoor-outdoor living, the open great room features a 4-panel panoramic accordion door that opens fully to a concrete patio w/ a pre-installed gas line, perfect for your dream grill or firepit. The spacious terraced yard offers multiple levels for gatherings, anchored by a magnificent mature oak tree, w/ a bonus 100 sq ft office/art studio at the top. Upstairs, all bedrooms provide privacy & comfort, including the primary bedroom w/ its own private deck. The conveniently located laundry room near the bedrooms adds ease to daily tasks. The chef's kitchen is outfitted w/ custom solid wood cabinetry, Caesarstone countertops, Thermador stove & Fischer & Paykel fridge, illuminated by high-efficiency LED & under-cabinet lighting. Tech enthusiasts will appreciate the Ubiquity/Unify camera system, Cat 6 & coax wiring, plus Nest thermostat & MyQ garage opener. Structural upgrades include a reinforced foundation w/ 3 steel beams, new front stucco, & Hardy Backer siding on the rear.

district__c,SF District 5

entry_level__c,0

exterior_features__c,Entry Gate

external_listing__c,1

fencing__c,Wood;Full

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2024-09-16T18:47:11.000+0000

pba__latitude_pb__c,37.7498562

pba__latitude_property__c,37.7498562

laundry_features__c,Laundry Closet;Upper Floor;Washer Included;Dryer Included;Gas Hook-Up

listed_date__c,2024-09-13

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Luba

pba__listing_agent_lastname__c,Muzichenko

listing_agent_mls_id__c,806066

ffd_listingagentname,Luba Muzichenko

listing_agent_number__c,166016229

listing_co_agent_mls_id__c,802084

listing_co_agent_number__c,802084

listing_co_office_mls_id__c,JEFRE

listing_co_office_name__c,Jesse E. Fowler

listing_co_office_number__c,28859

listing_office_mls_id__c,VANG03

listing_office_name__c,Vanguard Properties

listing_office_number__c,1228

pba__listingprice_pb__c,2795000

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/1009235303

pba__longitude_pb__c,-122.4407484

mls_id__c,424065583

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-09-13

open_house_end__c,2024-09-17T14:00:00.000+0000

open_house_start__c,2024-09-17T12:00:00.000+0000

original_price__c,2795000

overall_days_on_market__c,-82070

parking_access__c,Independent

parking_features__c,Enclosed,Garage Door Opener

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Uncovered Deck;Uncovered Patio

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000036unNMAQ

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

size__c,0

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Hoffman

subdist__c,Noe Valley

ffd_name,464 Hoffman Avenue, San Francisco, CA, 94114

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1946

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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