ffd_listing_title,547 Missouri Street, San Francisco, CA, 94107

ffd_mls_id,423907901

ffd_salesforce_id,a0E8W00000dSWvdUAG

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,547 Missouri Street, San Francisco, CA, 94107

pba__address_pb__c,547 Missouri Street, San Francisco, CA, 94107

agent_only_remarks__c,Gym equipment, piano, some furniture and art may also be negotiated. Matterport says 3494 square feet. Buyer to verify. Please call/text Alex at 415-254-5351 for all showings. Please do not use Showing Time...I beg of you. Disclosure package available. One of a kind home. Show your clients that might be looking in Noe Valley or Bernal. This home is truly amazing for indoor/outdoor living in the city.

appliances__c,Dishwasher;Insulated Water Heater;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Tankless Water Heater;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Wine Refrigerator;Ice Maker;Built-In Refrigerator

architectural_style__c,Contemporary;Modern/High Tech;Craftsman

bath_features__c,Tub w/Shower Over;Shower Stall(s);Dual Flush Toilet;Double Sinks

pba__fullbathrooms_pb__c,5

pba__bedrooms_pb__c,5

year_build_text__c,1900

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-15T20:46:46.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,Designed by Jonathan Pearlman, and located in one of SF's hippest locales, on a tree lined street, and walkable to so many amazing establishments, this home boasts 4 levels of sophisticated luxury indoor/outdoor living with: radiant heat; white oak hardwood floors; all bedrooms w/ensuite bath; 3 Bay facing view decks (one with custom awning); designer kitchen w/open plan, Wolf range w/ hood, built in espresso/coffee maker, Sub Zero fridge, Asko DW, bar seating for 4 w/ pendant lighting; 3 Bedrooms on same level; w/ Primary pent-room + private deck one level higher; + au pair room w/ separate ground floor entrance; family room w/ gas fireplace and den; modern landscaped garden; custom shelving; wet bar; keyless entry; Sonos; car charger; parking for 1 car (garage currently setup as gym); and oh so much more. If you've been looking for a San Francisco home that truly experiences city & summer, and you're better suited in bare feet, you'll definitely want to see this home.

district__c,SF District 9

driveway_sidewalks__c,Paved Sidewalk

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Gas Piped;Family Room

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Radiant

interior_features__c,Storage Area(s);Wet Bar

ffd_lastmodifieddate,2023-09-21T12:46:20.000+0000

pba__latitude_pb__c,37.759376

pba__latitude_property__c,37.759376

laundry_features__c,Inside Area;Ground Floor;Washer Included;Dryer Included

listed_date__c,2023-09-15

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Alexander

pba__listing_agent_lastname__c,Clark

listing_agent_mls_id__c,802982

ffd_listingagentname,Alexander T Clark

listing_agent_number__c,802982

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,TFST

listing_office_name__c,The Front Steps

listing_office_number__c,27633

pba__listingprice_pb__c,4895000

pba__listingtype__c,Sale

pba__listing_website__c,https://thefrontsteps.com/san-francisco-real-estate/featured-listings/547miss/

pba__longitude_pb__c,-122.3960172

lower_level__c,Family Room,Street Entrance

mls_id__c,423907901

main_level__c,Partial Bath(s);Kitchen;Garage;Living Room;Dining Room;Street Entrance

master_bathroom_features__c,Low-Flow Toilet(s);Double Sinks;Tile;Walk-In Closet;Soaking Tub;Window;Radiant Heat;Stone

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-15

open_house_end__c,2023-09-24T13:00:00.000+0000

open_house_start__c,2023-09-24T11:00:00.000+0000

original_price__c,4895000

overall_days_on_market__c,-81706

parking_access__c,Independent

parking_features__c,Enclosed,EV Charging

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Awning

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

room_type__c,Storage;Bonus Room;Laundry;Den;Kitchen;Living Room;Family Room;Great Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Carbon Mon Detector;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,4

pba__street_pb__c,Missouri

subdist__c,Potrero Hill

ffd_name,547 Missouri Street, San Francisco, CA, 94107

view__c,Bay

website_property_type__c,Single Family Home

window_features__c,Window Screens;Low E Glass Full

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/530677869-1.jpg

ffd_listing_title,766 Rhode Island Street, San Francisco, CA, 94107

ffd_mls_id,423905908

ffd_salesforce_id,a0E8W00000dSWWNUA4

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,2

address2__c,766 Rhode Island Street, San Francisco, CA, 94107

pba__address_pb__c,766 Rhode Island Street, San Francisco, CA, 94107

agent_only_remarks__c,No showings until first open house Sat 2-4 PM. Owners were able to fit two cars in the garage. Call/email Wendy for more information and/or questions. 415.367.5997 [email protected]

appliances__c,Dishwasher;Free Standing Refrigerator;Gas Cook Top

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1992

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-15T16:46:26.000+0000

days_on_market__c,5

dom__c,5

ffd_description_pb,Unique light filled top floor condo in a 2 unit building on the coveted North slope of Potrero Hill. The open plan living room/kitchen/dining has 9+ foot ceilings with a further elevated ceiling in the living room. Bay Bridge, East Bay and city views from living room and dining room, and light oak hardwood floors throughout. Master bedroom with en-suite bathroom, second bedroom and bathroom. Bonus is a generous study/den area. Private deeded roof deck has panoramic views. This unit includes one car parking plus lots of storage in the garage. A generously sized common landscaped backyard. Easy access to 101, 280, Caltrain, and Muni, Whole Foods, and is just steps to the bustling 18th street corridor with restaurants and shopping.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Insurance,Maintenance Grounds,Trash,Water,Other

pba__hoafees__c,475

pba__hoafrequency_pb__c,Monthly

hoa_name__c,764-766 Rhode Island

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Gas

ffd_lastmodifieddate,2023-09-20T10:46:55.000+0000

pba__latitude_pb__c,37.760085

pba__latitude_property__c,37.760085

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2023-08-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Wendy

pba__listing_agent_lastname__c,Watkins

listing_agent_mls_id__c,807243

ffd_listingagentname,Wendy A Watkins

listing_agent_number__c,1011757

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CIP05

listing_office_name__c,Corcoran Icon Properties

listing_office_number__c,28943

pba__listingprice_pb__c,1398000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.402433

mls_id__c,423905908

master_bathroom_features__c,Tub w/Shower Over

master_property__c,a0O8W00000KTKoLUAX

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-15

open_house_end__c,2023-09-23T16:00:00.000+0000

open_house_start__c,2023-09-23T14:00:00.000+0000

original_price__c,1398000

overall_days_on_market__c,-81706

parking_access__c,Side by Side

parking_features__c,Covered,Garage Door Opener,Interior Access,Side-by-Side

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000dSWWNUA4

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

size__c,1280

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Rhode Island

subdist__c,Potrero Hill

ffd_name,766 Rhode Island Street, San Francisco, CA, 94107

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1992

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,451 Kansas Street #282, San Francisco, CA, 94107

ffd_mls_id,423907312

ffd_salesforce_id,a0E8W00000dSWN6UAO

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,196

address2__c,451 Kansas Street #282, San Francisco, CA, 94107

pba__address_pb__c,451 Kansas Street #282, San Francisco, CA, 94107

agent_only_remarks__c,Square footage per condo map/tax records. Pre-sale escrow opened with Sylvia Wong @ Fidelity #FSFM-62300670.

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Refrigerator;Free Standing Electric Range

architectural_style__c,Contemporary;Modern/High Tech

bath_features__c,Tub w/Shower Over;Tile;Low-Flow Shower(s);Stone

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2007

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-15T15:46:33.000+0000

days_on_market__c,17

dom__c,11

ffd_description_pb,Welcome to The Potrero, a well-built, creatively designed 169 unit boutique luxury condominium community nestled on the sunny northern slope of popular Potrero Hill. Residence 282 is an exterior facing (green tree privacy) freshly painted and updated split floor-plan 2 bedroom, 2 full bath home with a sunny eastern exposure. The property features open floor-plan living and dining areas designed with engineered hardwood, large bright windows, tall ceilings and updated lighting. The modern open kitchen is fitted with granite counters, Studio Becker cabinetry, dual sink, GE Profile range and dishwasher, built-in microwave, recessed lighting and a large walk-in pantry. Adjacent petite foyer with coat closet. Private primary suite features new carpeting, tall windows, a large walk-in closet and a spacious en-suite bath with stone counters, dual sinks and a glass enclosed bathtub + shower. Guest bedroom with roomy closets and a shared full bathroom with tub + shower. Washer-dryer. 1 car parking. The Potrero is a warm and friendly community offering a fitness center, craft room, interior gardens, bike racks, roof deck, gated access control and video surveillance. Strong HOA prudent reserves. Whole Foods downstairs. Close to 101+280. WalkScore: 96. A fine home, location and lifestyle.

district__c,SF District 9

driveway_sidewalks__c,Gated,Maintenance Agreement,Paved Sidewalk

entry_level__c,0

exterior_features__c,Uncovered Courtyard;Entry Gate

external_listing__c,1

pba__floortype_pb__c,Carpet;Laminate;Tile

hoa_fee_includes__c,Common Areas,Elevator,Insurance,Maintenance Exterior,Maintenance Grounds,Management,Recreation Facility,Roof,Sewer,Trash,Water

pba__hoafees__c,689

pba__hoafrequency_pb__c,Monthly

hoa_name__c,The Potrero Homeowners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Electric

interior_features__c,Storage Area(s)

ffd_lastmodifieddate,2023-09-24T22:46:40.000+0000

pba__latitude_pb__c,37.7638238

pba__latitude_property__c,37.7638238

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2023-09-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Peter

pba__listing_agent_lastname__c,Fisler

listing_agent_mls_id__c,803752

ffd_listingagentname,Peter Fisler

listing_agent_number__c,803752

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP7

listing_office_name__c,Compass

listing_office_number__c,28751

pba__listingprice_pb__c,988000

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/861623724

pba__longitude_pb__c,-122.4031933

mls_id__c,423907312

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

master_bathroom_features__c,Tub w/Shower Over;Low-Flow Toilet(s);Double Sinks;Tile;Low-Flow Shower(s);Stone

master_property__c,a0O1I000001Vhj9UAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-07

open_house_end__c,2023-09-24T16:00:00.000+0000

open_house_start__c,2023-09-24T14:00:00.000+0000

original_price__c,988000

overall_days_on_market__c,-81698

parking_access__c,Side by Side

parking_features__c,Attached,Garage Door Opener,Interior Access,Restrictions,Side-by-Side

parking_type__c,On Site - Assigned (Condo Only)

patio_and_porch_features__c,Roof 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,1060.09

pba__propertytype__c,Condominium

ListingId,a0E8W00000dSWN6UAO

road_surface_type__c,Asphalt

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Security Gate;Fire Alarm;Security Fence;Fire Suppression System;Secured Access;Carbon Mon Detector;Video System

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

size__c,932

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Kansas

subdist__c,Potrero Hill

ffd_name,451 Kansas Street #282, San Francisco, CA, 94107

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2007

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,1164 De Haro Street, San Francisco, CA, 94107

ffd_mls_id,423904646

ffd_salesforce_id,a0E8W00000dSWHIUA4

num_of_fireplaces__c,0

num_of_rooms__c,10

of_units__c,0

address2__c,1164 De Haro Street, San Francisco, CA, 94107

pba__address_pb__c,1164 De Haro Street, San Francisco, CA, 94107

agent_only_remarks__c,You have never seen a home with so many boxes checked! Schedule a private showing by emailing [email protected]. Feel free to text Wendy 415-519-6091 with questions. Disclosures: https://app.disclosures.io/link/1164-De-Haro-Street-5cwkst33

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

architectural_style__c,Victorian;Modern/High Tech

bath_features__c,Tub w/Shower Over;Shower Stall(s);Tub;Double Sinks;Quartz;Window

pba__fullbathrooms_pb__c,5

pba__bedrooms_pb__c,5

year_build_text__c,1900

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,MultiUnits,MultiZone

ffd_createddate,2023-09-15T14:46:10.000+0000

days_on_market__c,9

dom__c,9

ffd_description_pb,A classic Victorian facade gives way to a beautifully articulated residence, poised for a robust family life, no detail has been overlooked in its thoughtful renovations. Set on a tree lined street, the light filled home offers multiple opportunities for indoor/outdoor living. A natural flow from living room to dining, open to an exquisite kitchen, embraced by views of Noe Valley & Twin Peaks. The aspiring chef's kitchen features a massive island, Thermador appl & breakfast area. Seamless indoor/ outdoor entertaining awaits, ipe deck featuring infrastructure to create a dream outdoor KIT. Completing this level is 1 bedroom/ office & 1 luxe bath. An impressive penthouse suite w/sparkling Twin Peaks views + luxe spa-like bath soaking tub & rain shower + private deck create a serene retreat. 3 beds & 2 baths on the level below incl. an ensuite. The garden level 'something for everyone' family area: wet bar open to landscaped garden & BBQ patio; fabulous equipped gym & mirrored barre; temp-controlled wine room; full bath; laundry room with drying rack complete.Skillfully woven throughout are useful, smart-home features: solar, split system AC,house Tesla battery + EV charger, security. Easy dual commute. Quintessential Potrero, gateway to a sophisticated city life!

district__c,SF District 9

electric__c,Photovoltaics Seller Owned

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Carpet;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Natural Gas

interior_features__c,Formal Entry;Skylight(s);Storage Area(s)

ffd_lastmodifieddate,2023-09-25T02:46:16.000+0000

pba__latitude_pb__c,37.755145

pba__latitude_property__c,37.755145

laundry_features__c,Inside Area;See Remarks;Washer Included;Dryer Included;Gas Hook-Up

listed_date__c,2023-09-15

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Wendy

pba__listing_agent_lastname__c,Storch

listing_agent_mls_id__c,803139

ffd_listingagentname,Wendy Storch

listing_agent_number__c,803139

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

pba__listingtype__c,Sale

pba__listing_website__c,https://www.dropbox.com/scl/fo/o7tdjc5xmjwexuyj0i9p3/h?dl=0&preview=1164+De+Haro+-+v5+-+LONG+FORM.mp4&rlkey=wt7m97pooshelb9id1k2lxe1j

pba__longitude_pb__c,-122.400988

lower_level__c,Family Room,Full Bath(s)

mls_id__c,423904646

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

master_bathroom_features__c,Quartz;Walk-In Closet;Soaking Tub;Dual Flush Toilet

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-15

open_house_end__c,2023-09-24T16:00:00.000+0000

open_house_start__c,2023-09-24T14:00:00.000+0000

original_price__c,3450000

overall_days_on_market__c,-81706

parking_access__c,Independent

parking_features__c,Attached,EV Charging,Garage Door Opener,Garage Facing Front,Interior Access,Private

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Roof Deck;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,1078.13

pba__propertytype__c,Single Family Residence

ListingId,a0E8W00000dSWHIUA4

room_type__c,Storage;Office;Kitchen;Living Room;Dining Room;Family Room;Media Room;Temp Controlled Room;Primary Bathroom;Primary Bedroom

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

size__c,3200

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,De Haro

subdist__c,Potrero Hill

ffd_name,1164 De Haro Street, San Francisco, CA, 94107

view__c,City;City Lights;Garden/Greenbelt;San Francisco;Twin Peaks;Sutro Tower;Valley;Forest

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Window Coverings

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/530677560-1.jpg