1255 Rhode Island 1257 Street, San Francisco, CA, 94107 - Property Description

_yoast_indexnow_last_ping,1726783028

ffd_listing_title,877 Carolina Street, San Francisco, CA, 94107

ffd_mls_id,424063953

ffd_salesforce_id,a0EUd0000039AjCMAU

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,877 Carolina Street, San Francisco, CA, 94107

pba__address_pb__c,877 Carolina Street, San Francisco, CA, 94107

agent_only_remarks__c,Exceptional new construction completed in summer 2024. No expense spared.

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Built-In Gas Oven

architectural_style__c,Modern/High Tech

bath_features__c,Dual Flush Toilet;Skylight/Solar Tube;Low-Flow Shower(s);Stone

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,4

year_build_text__c,2024

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central,MultiZone

ffd_createddate,2024-09-19T10:48:36.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Pristine newly blt 4+BR/4.5BA view home at the crest of Potrero Hill, designed by John Lum Architecture w/meticulous curation of the home's orientation, natural light, sightlines, volume, indoor/outdoor flow & expansive views - north & east across SF bay to Mt Diablo, downtown, Sutro Tower from the west, magical sunrises & sunsets. Thoughtful reverse flr pln provides a dramatic open entertaining top flr w/intimate living spaces on the middle & lower lvls, all accessed by elevator. Kitchen w/Carrera marble center island & scalloped backspash & Miele appliances flows seamlessly to the LR w/fplc & stunning view deck, & DR w/sunny front entertaining deck. A bright home office is tucked away at the front of this lvl, & a powder rm w/skylight, custom mural & fireclay tile. Incredible 360 roof deck directly accessed from the living space via an automatic retractable Rollamatic roof. BR floor w/stunning primary BR suite at quiet rear w/bay & downtown views, large walk-in closet, BA w/double vanity, marble mosaic shower, Badeloft freestanding tub. Lounge, 2 front view BRs, 2 more BA's & a laundry rm complete this lvl. Downstairs, the 4th BR & lux BA overlook the serene garden. Addl 682 sq ft of storage space, perfect for many uses. Secure spacious garage. Fab Potrero Hill loc

district__c,SF District 9

electric__c,220 Volts in Laundry

entry_level__c,0

exterior_features__c,Balcony;Fire Pit

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room;Gas Piped;Gas Starter

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

has_3d_tour__c,1

pba__heatingtype_pb__c,Central;Gas;Fireplace(s);Natural Gas;MultiZone

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

ffd_lastmodifieddate,2024-09-19T21:47:48.000+0000

pba__latitude_pb__c,37.7575941

pba__latitude_property__c,37.7575941

laundry_features__c,Inside Room;Hookups Only;Inside Area;Gas Hook-Up

listed_date__c,2024-09-09

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Naomi

pba__listing_agent_lastname__c,Lempert Lopez

listing_agent_mls_id__c,800407

ffd_listingagentname,Naomi Lempert Lopez

listing_agent_number__c,800407

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CBLUXURY

listing_office_name__c,Coldwell Banker Realty

listing_office_number__c,2128

pba__listingprice_pb__c,4995000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=K6PDywCFdDt&brand=0

pba__longitude_pb__c,-122.3996918

lower_level__c,Bedroom(s),Full Bath(s),Garage,Retreat,Street Entrance

mls_id__c,424063953

main_level__c,Full Bath(s);Bedroom(s);Family Room;Retreat;Primary Bedroom

master_bathroom_features__c,Low-Flow Toilet(s);Double Sinks;Soaking Tub;Marble;Window;Stone;Skylight/Solar Tube;Dual Flush Toilet

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-09-19

open_house_end__c,2024-09-22T16:00:00.000+0000

open_house_start__c,2024-09-22T14:00:00.000+0000

original_price__c,4995000

overall_days_on_market__c,-82076

parking_access__c,Independent

parking_features__c,Attached,Covered,Enclosed,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;Enclosed 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,1449.93

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000039AjCMAU

room_type__c,Storage;Office;Laundry;Den;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Fire Alarm;Fire Extinguisher;Carbon Mon Detector;Video System;Security System Prewired;Security System Owned;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,3445

size__c,3445

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Carolina

subdist__c,Potrero Hill

ffd_name,877 Carolina Street, San Francisco, CA, 94107

view__c,Panoramic;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Hills;Sutro Tower;Mt Diablo;Bridges

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Window Coverings

pba__yearbuilt_pb__c,2024

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726541711

ffd_listing_title,512 Mississippi Street, San Francisco, CA, 94107

ffd_mls_id,424056721

ffd_salesforce_id,a0EUd0000036pJ7MAI

num_of_fireplaces__c,0

num_of_rooms__c,7

of_units__c,0

address2__c,512 Mississippi Street, San Francisco, CA, 94107

pba__address_pb__c,512 Mississippi Street, San Francisco, CA, 94107

agent_only_remarks__c,Easy to show just contact Josh Burns at 415-307-2463 via phone or text to arrange. Open this weekend both Saturday from 11:00 am to 1:00 pm and Sunday from 1:00 pm to 4:00 pm.

appliances__c,Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;Free Standing Refrigerator;Gas Cook Top

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1909

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-09-13T21:47:34.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,Located in the highly desirable Potrero Hill neighborhood, this updated light-filled four bedroom and two bathroom single family home has a flexible floorplan and is highlighted by the mature peaceful garden which is ideal for outdoor living at its finest. With high ceilings and ample natural light, the main living level of the home has an open layout with one bedroom, living room, dining area and kitchen with direct access to the large sunny private deck and the park-like backyard. The spacious chef's kitchen has newly installed quartz countertops, eat-in breakfast peninsula, stainless steel appliances including newer refrigerator, dishwasher, gas cooktop and generous cabinet space. Measuring approximately 1,765 square feet, there are two spacious bedrooms on the upper level with city and water views. On the lower level is a comfortable primary suite bedroom with sliding glass doors leading to the deck and tranquil gardens with a water fountain. Other features include wood floors, skylights, dual pane windows, newer water heater and additional storage located on the ground level along with washer and dryer. Close proximity to dining, parks, shopping, schools and easy freeway access for commuting. A great home for those seeking the perfect blend of comfort, style and convenience.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Carpet;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2024-09-17T02:46:35.000+0000

pba__latitude_pb__c,37.7598764

pba__latitude_property__c,37.7598764

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2024-09-13

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Josh

pba__listing_agent_lastname__c,Burns

listing_agent_mls_id__c,805857

ffd_listingagentname,Josh K Burns

listing_agent_number__c,177518611

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

pba__listingtype__c,Sale

pba__listing_website__c,https://512mississippi.com/mls

pba__longitude_pb__c,-122.3945667

lower_level__c,Primary Bedroom

mls_id__c,424056721

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-09-13

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

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

original_price__c,1875000

overall_days_on_market__c,-82070

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000036pJ7MAI

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

size__c,1765

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Mississippi

subdist__c,Potrero Hill

ffd_name,512 Mississippi Street, San Francisco, CA, 94107

view__c,City;City Lights;Garden/Greenbelt;Bay;Hills

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1909

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726743304

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

ffd_mls_id,424065361

ffd_salesforce_id,a0EUd0000036kuTMAQ

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,165

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

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

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

architectural_style__c,Modern/High Tech

bath_features__c,Tub w/Shower Over;Tile;Quartz

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,2024-09-13T20:47:22.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,Welcome to The Potrero No. 392. This bright and inviting corner condo offers 2 bedrooms and 2 bathrooms, with abundant natural light from its south and east-facing windows. This smart floor plan features an open-concept living and dining area, hardwood floors, an ensuite primary bedroom with large walk-in closet, a second bedroom with an adjacent bath, and a spacious private patio with abundant southern light. Additional amenities include deeded parking in a secure garage (with EV charging capability), beautifully landscaped walkways and courtyards, fitness facilities, and a rooftop deck offering stunning views. Built in 2007, The Potrero is a secure 165-unit courtyard complex in one of San Francisco's most desirable neighborhoods, celebrated for its exceptional livability. With a Whole Foods conveniently located just downstairs, residents can shop or dine without ever leaving the property. The area also enjoys great weather and provides easy commute access to Mission Bay/ downtown, freeways and waterfront attractions.

district__c,SF District 9

entry_level__c,0

exterior_features__c,Balcony;Uncovered Courtyard;Entry Gate

external_listing__c,1

fencing__c,Wood

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Common Areas,Elevator,Homeowners Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Roof,Security,Trash,Water

pba__hoafees__c,732

pba__hoafrequency_pb__c,Monthly

hoa_name__c,The Potrero Owners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Electric

interior_features__c,Elevator

ffd_lastmodifieddate,2024-09-19T10:48:28.000+0000

pba__latitude_pb__c,37.7640609

pba__latitude_property__c,37.7640609

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2024-07-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Victoria

pba__listing_agent_lastname__c,Stewart Davis

listing_agent_mls_id__c,806048

ffd_listingagentname,Victoria Stewart Davis

listing_agent_number__c,166016199

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP50

listing_office_name__c,Compass

listing_office_number__c,28741

pba__listingprice_pb__c,1095000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.403009

mls_id__c,424065361

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

master_bathroom_features__c,Shower Stall(s);Quartz;Double Sinks;Tile

master_property__c,a0O1I000001Vhj9UAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-09-13

open_house_end__c,2024-09-22T16:00:00.000+0000

open_house_start__c,2024-09-22T14:00:00.000+0000

original_price__c,1095000

overall_days_on_market__c,-82070

parking_access__c,Side by Side

parking_features__c,Enclosed,EV Charging,Interior Access,Side-by-Side

parking_type__c,On Site - Mapped (Condo Only)

patio_and_porch_features__c,Enclosed Patio;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,1115.07

pba__propertytype__c,Condominium

ListingId,a0EUd0000036kuTMAQ

room_type__c,Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Security Gate;Secured Access

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

size__c,982

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Kansas

subdist__c,Potrero Hill

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

view__c,City;Garden/Greenbelt;San Francisco

website_property_type__c,Condominium

window_features__c,Window Coverings

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

_yoast_indexnow_last_ping,1726782968

ffd_listing_title,784 Wisconsin Street, San Francisco, CA, 94107

ffd_mls_id,424049821

ffd_salesforce_id,a0EUd0000036MDpMAM

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,2

address2__c,784 Wisconsin Street, San Francisco, CA, 94107

pba__address_pb__c,784 Wisconsin Street, San Francisco, CA, 94107

agent_only_remarks__c,Contact Jessica with any questions 415-341-7177

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1991

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-13T14:46:07.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,Jaw-dropping Bay, downtown, Bay Bridge & Mt Diablo views abound from this gorgeous, renovated, standalone, 3 lvl, 3BDR/2BA house-like condo on Potrero's coveted North Slope. Built in 1991 by renowned Kotas Pantaleoni Architects, the home was featured in Sunset Magazine. On the main lvl, an open living, kitchen and dining space w soaring ceilings and double height windows framing the Bay + city skyline. There is a w/b fireplace and a fantastic walk out deck w views! Remodeled pro kitchen w Thermador refrigerator and range, Bosch dishwasher, and a beautiful breakfast bar for working and eating. Spacious dining area w floor to ceiling custom reclaimed wood paneling - the perfect entertaining space! Upstairs, a sumptuous primary suite w walk-in closet/nursery, a designer renovated ensuite BA w heated Japanese toilet, and a private deck w built in seating and Golden Gate bridge views. On the lower lvl, 2 spacious BDRs, laundry, and a 2nd designer renovated full BA. Refinished warm wd flrs. 2021 roof, 2016 bldg retrofit, tankless water heater. 2 unit HOA. No unit above or below. Deeded 2 car pkg/storage. Best SF weather + walk to Plow, Farley's, Good Life, Whole Foods, Papito, and McKinley Sq Park. Dogpatch/Mission shops + restaurants. Mins to downtown + 280/101. Wow!

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__hoafees__c,237

hoa__c,Yes

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-09-19T21:47:48.000+0000

pba__latitude_pb__c,37.7575571

pba__latitude_property__c,37.7575571

listed_date__c,2024-01-16

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jessica

pba__listing_agent_lastname__c,Branson

listing_agent_mls_id__c,805610

ffd_listingagentname,Jessica Branson

listing_agent_number__c,166015601

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

pba__listingtype__c,Sale

pba__listing_website__c,http://www.ViewsInPotrero.com

pba__longitude_pb__c,-122.3993243

mls_id__c,424049821

master_property__c,a0OUd00000C0YduMAF

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-13

open_house_end__c,2024-09-19T13:00:00.000+0000

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

original_price__c,1795000

overall_days_on_market__c,-82070

parking_access__c,Side by Side

parking_features__c,Garage Door Opener

parking_type__c,On Site - Assigned (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,930.53

pba__propertytype__c,Condominium

ListingId,a0EUd0000036MDpMAM

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

size__c,1929

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Wisconsin

subdist__c,Potrero Hill

ffd_name,784 Wisconsin Street, San Francisco, CA, 94107

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1991

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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