609 San Bruno Avenue, San Francisco, CA, 94107 - Property Description

_yoast_indexnow_last_ping,1713236269

ffd_listing_title,249 Connecticut Street, San Francisco, CA, 94107

ffd_mls_id,424024109

ffd_salesforce_id,a0EUd000001jjN0MAI

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,3

address2__c,249 Connecticut Street, San Francisco, CA, 94107

pba__address_pb__c,249 Connecticut Street, San Francisco, CA, 94107

agent_only_remarks__c,Escrow opened with Michael Yip, Chicago Title.

architectural_style__c,Edwardian

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1908

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Jeny L Smith

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-15T15:46:54.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,This beautiful and elegant 2-bedroom, 1-bath Edwardian condo is located just a block from the charming amenities of 18th Street in Potrero Hill. It features gracious architectural details including curved ceilings, moldings, pocket doors, a fireplace, and large windows that offer a great view and fill the space with light. The home includes a flexible floor plan with two bedrooms and an additional office space. The open kitchen comes with an island and a cozy breakfast nook, leading into an expansive living area. Convenient in-unit washer and dryer, a private deck, and a shared garden complete this delightful home, making it both functional and inviting.

district__c,SF District 9

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

has_3d_tour__c,1

ffd_lastmodifieddate,2024-04-16T02:47:16.000+0000

pba__latitude_pb__c,37.76314

pba__latitude_property__c,37.76314

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2023-11-08

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jennifer

pba__listing_agent_lastname__c,Davis

listing_agent_mls_id__c,803209

ffd_listingagentname,Jenn Davis

listing_agent_number__c,803209

listing_co_agent_mls_id__c,803235

listing_co_agent_number__c,803235

listing_co_office_mls_id__c,SRNO05

listing_co_office_name__c,Christie's International Real Estate Sereno

listing_co_office_number__c,29071

listing_office_mls_id__c,SRNO04

listing_office_name__c,Christie's Int'l Real Estate

listing_office_number__c,29064

pba__listingprice_pb__c,995000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=5jCbNSbHkzP

pba__longitude_pb__c,-122.397242

mls_id__c,424024109

master_property__c,a0OUd0000061GP3MAM

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-04-15

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

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

original_price__c,995000

overall_days_on_market__c,-81919

patio_and_porch_features__c,Back Porch

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001jjN0MAI

room_type__c,Laundry;Den;Kitchen;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+

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

size__c,1157

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Connecticut

subdist__c,Potrero Hill

ffd_name,249 Connecticut Street, San Francisco, CA, 94107

view__c,City Lights

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1908

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713189496

ffd_listing_title,1061 Kansas 1063 Street, San Francisco, CA, 94107

ffd_mls_id,424017911

ffd_salesforce_id,a0EUd000001jZNdMAM

num_of_rooms__c,8

of_units__c,2

address2__c,1061 Kansas 1063 Street, San Francisco, CA, 94107

pba__address_pb__c,1061 Kansas 1063 Street, San Francisco, CA, 94107

agent_only_remarks__c,Cannot show until April 16. Seller respectfully requests that escrow remain with Janette Marcelo at Old Republic Title.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1910

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-15T10:49:19.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Exciting Opportunity Awaits! Discover the potential of this diamond-in-the-rough vacant duplex in the sun-drenched Potrero Hill neighborhood of San Francisco. This hidden gem boasts two spacious full-floor flats, each featuring expansive eat-in kitchens and formal living rooms with period details. Imagine the endless possibilities that come with a generous south-facing backyard, perfect for creating your own urban oasis or an entertainer's paradise. Plus, the convenience of a large garage adds to the appeal of this rare find. This is a once-in-a-lifetime chance for visionaries eager to imprint their style and live in one of the most sought-after climates San Francisco has to offer. Don't miss out on making this duplex your dream project and personal haven!

district__c,SF District 9

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-15T13:46:51.000+0000

pba__latitude_pb__c,37.756274

pba__latitude_property__c,37.756274

listed_date__c,2024-03-15

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Mary

pba__listing_agent_lastname__c,Macpherson

listing_agent_mls_id__c,806933

ffd_listingagentname,Mary Macpherson

listing_agent_number__c,166017897

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,VANTAGE

listing_office_name__c,Vantage Realty

listing_office_number__c,28995

pba__listingprice_pb__c,1200000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.402414

mls_id__c,424017911

parkingspaces__c,2

on_market_date__c,2024-04-15

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

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

original_price__c,1200000

overall_days_on_market__c,-81919

parking_features__c,Garage,Garage Door Opener

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,507.4

pba__propertytype__c,Duplex

ListingId,a0EUd000001jZNdMAM

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

size__c,2365

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Kansas

subdist__c,Potrero Hill

ffd_name,1061 Kansas 1063 Street, San Francisco, CA, 94107

website_property_type__c,Duplex

pba__yearbuilt_pb__c,1910

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713211335

ffd_listing_title,654 Pennsylvania Avenue, San Francisco, CA, 94107

ffd_mls_id,424023071

ffd_salesforce_id,a0EUd000001jHP9MAM

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,654 Pennsylvania Avenue, San Francisco, CA, 94107

pba__address_pb__c,654 Pennsylvania Avenue, San Francisco, CA, 94107

agent_only_remarks__c,Leased garage parking space is nearby at 800 Indiana Street.

appliances__c,Dishwasher;Gas Water Heater;Hood Over Range;Free Standing Gas Oven

architectural_style__c,Victorian

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1900

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-13T00:47:28.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,On a prized block of Potrero Hill, this beautiful Victorian home is flooded with light from its expansive windows. The home has been attractively updated for today's modern living while retaining its charming period details. The bright chef's kitchen is handsomely appointed with stainless steel appliances, tiled counters and ample cabinetry. The kitchen opens onto a spacious walk-out deck ideally configured for entertaining under Potrero's sunny skies. The spacious primary bedroom has wood floors, a soaring ceiling and a pristine tiled bath en suite. The sunny guest bedroom is generous enough to accommodate an office area. Lovingly landscaped, the lush garden offers a tranquil retreat for enjoying Potrero Hill's famously warm weather. An enormous, high-ceilinged basement offers a world of possibilities for conversion to additional living area, a media room, or work from home space. Architectural concepts for two expanded floor plans have been created by award-winning San Francisco architect John Lum. This lovely home is a rare opportunity for buyers ready to enjoy it as is and those who want to create their dream home on a sunny block of Potrero Hill. Very convenient to North Slope shops, restaurants, Caltrain and I-280!

district__c,SF District 9

electric__c,220 Volts in Laundry

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Central;Gas

ffd_lastmodifieddate,2024-04-15T19:47:42.000+0000

pba__latitude_pb__c,37.758242

pba__latitude_property__c,37.758242

laundry_features__c,Inside Area;Ground Floor;Washer Included;Dryer Included;Gas Hook-Up;Sink

listed_date__c,2024-04-12

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Tim

pba__listing_agent_lastname__c,Johnson

listing_agent_mls_id__c,805021

ffd_listingagentname,Tim Johnson

listing_agent_number__c,166014787

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP41

listing_office_name__c,Compass

listing_office_number__c,27887

pba__listingprice_pb__c,1395000

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/933813660

pba__longitude_pb__c,-122.393461

lower_level__c,Street Entrance

mls_id__c,424023071

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

master_bathroom_features__c,Tub w/Shower Over;Soaking Tub;Window

monthly_parking_fees__c,338

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-12

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

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

original_price__c,1395000

overall_days_on_market__c,-81916

parking_access__c,Independent

parking_features__c,Enclosed

parking_type__c,Other

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001jHP9MAM

roof__c,Composition;Other

room_type__c,Laundry;Kitchen;Primary Bedroom

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

size__c,915

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Pennsylvania

subdist__c,Potrero Hill

ffd_name,654 Pennsylvania Avenue, San Francisco, CA, 94107

website_property_type__c,Single Family Home

window_features__c,Window Coverings;Window Screens

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713232939

ffd_listing_title,540 De Haro Street #402, San Francisco, CA, 94107

ffd_mls_id,424022471

ffd_salesforce_id,a0EUd000001iXqyMAE

num_of_fireplaces__c,1

num_of_rooms__c,2

of_units__c,16

address2__c,540 De Haro Street #402, San Francisco, CA, 94107

pba__address_pb__c,540 De Haro Street #402, San Francisco, CA, 94107

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Electric Cook Top;Built-In Refrigerator

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,2020

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Edward R Deleski

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-04-12T00:47:11.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,Enjoy modern sophistication in the heart of Potrero Hill in this exquisite condominium at 540 De Haro Street, a boutique 16-unit residential building, newly constructed in 2020, and designed by Sternberg Benjamin Architects. Residence 402 features the finest of modern urban living, offering great natural light and views from floor-to-ceiling windows and a Great Room for dining and entertaining, with a terrace offering views to the East with peek-a-boo views to the Bay Bridge and Downtown. Luxury features include beautiful wood floors, central air conditioning, a gas fireplace, Lutron Caseta smart lighting, Bonelli windows, and European finishes including Miele kitchen appliances, Boffi cabinetry, Porcelanosa tile, and a Porro closet system. Other features include in-unit laundry and deeded 1-car parking, with a common roof terrace with sweeping city views and a welcoming elevator lobby. Set in the heart of Potrero Hill, enjoy all the City has to offer with easy access to restaurants, cafes and shopping along quaint 18th Street and nearby Dogpatch, Jackson Park & Playground, Chase Center and public transportation, plus conveniently close to 101 and 280.

district__c,SF District 9

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fireplace_features__c,Living Room;Gas Piped

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Common Areas,Elevator,Homeowners Insurance,Maintenance Grounds,Management,Trash

pba__hoafees__c,550

pba__hoafrequency_pb__c,Monthly

hoa_name__c,540 De Haro HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

ffd_lastmodifieddate,2024-04-16T01:47:39.000+0000

pba__latitude_pb__c,37.762907

pba__latitude_property__c,37.762907

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2024-04-03

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jean-Paul

pba__listing_agent_lastname__c,Samaha

listing_agent_mls_id__c,804997

ffd_listingagentname,Jean-Paul Samaha

listing_agent_number__c,166014752

listing_co_agent_mls_id__c,807512

listing_co_agent_number__c,1020319

listing_co_office_mls_id__c,VANG02

listing_co_office_name__c,Vanguard Properties

listing_co_office_number__c,166013449

listing_office_mls_id__c,VANG02

listing_office_name__c,Vanguard Properties

listing_office_number__c,166013449

pba__listingprice_pb__c,995000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.401732

mls_id__c,424022471

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

master_bathroom_features__c,Shower Stall(s);Radiant Heat

master_property__c,a0O1I00000A33VaUAJ

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-11

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

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

original_price__c,995000

overall_days_on_market__c,-81915

parking_access__c,Side by Side

parking_features__c,Garage Door Opener,Interior Access

parking_type__c,On Site - Mapped (Condo 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,0

pba__propertytype__c,Condominium

ListingId,a0EUd000001iXqyMAE

road_surface_type__c,Asphalt

room_type__c,Kitchen;Great Room;Primary Bathroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;Video System;Security System Prewired

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

pba__street_pb__c,De Haro

subdist__c,Potrero Hill

ffd_name,540 De Haro Street #402, San Francisco, CA, 94107

view__c,City;Panoramic;City Lights;Downtown;Bay Bridge;San Francisco

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2020

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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