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

ffd_mls_id,423910885

ffd_salesforce_id,a0E8W00000dTmXQUA0

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,2

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

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

agent_only_remarks__c,Easy to show by appointment. Please email [email protected] to show.

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,2019

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Ron Abta

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-25T17:47:27.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,This 2019 new construction condo in a boutique 2-unit building enjoys the highest quality finishes and an incredible 97 WalkScore. Just 2 blocks from Whole Foods and steps to great retail & restaurants, with close proximity to the Warriors Chase Center. This 3 bed/2.5 bath home features multi-zone radiant floor heating, wide-plank Italian white oak hardwood floors and 2 car garage. 10' ceiling on the main level impresses, as does the chef's kitchen with custom cabinetry, Quartz countertops, Wolf range, Sub-Zero fridge & Bosch dishwasher. The open floor plan dining & living room leads perfectly through the huge sliding glass doors to a flat backyard, creating the perfect indoor-outdoor living area. The landscaped garden benefits from a large patio, raised gas fire pit, and elevated seating area with a view of Downtown. 2 large bedrooms on the lower area each enjoy generous closets and share a luxury bath. The primary suite features peek-a-boo downtown views, large custom closet, and spa-like bathroom with double sinks, luxurious soaking tub, and grand walk-in shower. Don't miss!

district__c,SF District 9

entry_level__c,0

external_listing__c,1

fireplace_features__c,Other

pba__floortype_pb__c,Wood

pba__hoafees__c,500

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2023-09-26T01:47:30.000+0000

pba__latitude_pb__c,37.762667

pba__latitude_property__c,37.762667

listed_date__c,2023-09-19

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,David

pba__listing_agent_lastname__c,Cohen

listing_agent_mls_id__c,804695

ffd_listingagentname,David G Cohen

listing_agent_number__c,166014347

listing_co_agent_mls_id__c,803878

listing_co_agent_number__c,166013231

listing_co_office_mls_id__c,CITYRE

listing_co_office_name__c,City Real Estate

listing_co_office_number__c,27425

listing_office_mls_id__c,CITYRE

listing_office_name__c,City Real Estate

listing_office_number__c,27425

pba__listingprice_pb__c,2295000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4017089

mls_id__c,423910885

master_property__c,a0O8W00000KTndtUAD

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2023-09-25

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

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

original_price__c,2295000

overall_days_on_market__c,-81716

parking_access__c,Side by Side

parking_features__c,Garage Door Opener

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000dTmXQUA0

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

size__c,1911

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,De Haro

subdist__c,Potrero Hill

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

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2019

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

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

dom__c,13

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 (blinds up privacy), freshly painted and updated split floor plan 2 bedroom, 2 full bathroom 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-26T18:47:08.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

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