ffd_listing_title,1 Steuart Lane #401, San Francisco, CA, 94105

ffd_mls_id,423911100

ffd_salesforce_id,a0E8W00000dTT9VUAW

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,120

address2__c,1 Steuart Lane #401, San Francisco, CA, 94105

pba__address_pb__c,1 Steuart Lane #401, San Francisco, CA, 94105

appliances__c,Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Wine Refrigerator;Built-In Refrigerator

architectural_style__c,Contemporary;Modern/High Tech

bath_features__c,Marble;Double Sinks

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,0

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2023-09-22T10:48:09.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,One Steuart Lane offers a remarkable rare collection of homes along the famed Bay. With floor to ceiling windows and unparalleled waterfront views, Residence 401 features 2 Bedrooms, a Den (flex room), 3 Bathrooms, balcony, and a large laundry room. The living spaces and kitchen boast high quality materials from a collection of Gaggenau and Meile appliances, Dada cabinetry by Molteni group, Glorious marble islands, and immaculate white oak flooring. The master bath emanates warm coastal splendor with Glorious White marble, Dornbracht fixtures, Vali & Vali door handles, and Dada millwork by Molteni Group. Amenities include a grand lobby attended by lobby ambassadors, 24 hour valet parking, resident lounge w/full kitchen & waterfront terrace, Wellness Center with a fitness and Pilates studio, outdoor terrace & spa facilities including steam, sauna & outdoor hot spa. Discover where lush meets California character!

district__c,SF District 9

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

pba__floortype_pb__c,Marble;Wood

hoa_fee_includes__c,Door Person,Maintenance Exterior,Maintenance Grounds,Management,Water

pba__hoafees__c,2844

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-09-22T11:46:33.000+0000

pba__latitude_pb__c,37.79444497

pba__latitude_property__c,37.79444497

laundry_features__c,Inside Room;Laundry Closet;Hookups Only

listed_date__c,2023-09-21

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Edie

pba__listing_agent_lastname__c,Narrido

listing_agent_mls_id__c,803433

ffd_listingagentname,Edie A Narrido

listing_agent_number__c,803433

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,POGR

listing_office_name__c,Polaris Pacific

listing_office_number__c,166013106

pba__listingprice_pb__c,6395000

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/polarispacific/review/851001183/0886050681

pba__longitude_pb__c,-122.39464807

mls_id__c,423911100

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

master_bathroom_features__c,Shower Stall(s);Double Sinks;Soaking Tub;Marble;Closet;Dual Flush Toilet

master_property__c,a0O8W00000FqH2dUAF

monthly_parking_fees__c,610

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-21

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

overall_days_on_market__c,-81712

parking_access__c,Side by Side

parking_features__c,Enclosed,EV Charging,Garage Door Opener,Guest Parking Available,Interior Access,Unassigned,Underground Parking,Valet

parking_type__c,On Site - Unassigned (Condo Only)

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000dTT9VUAW

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

pba__street_pb__c,Steuart

subdist__c,South Beach

ffd_name,1 Steuart Lane #401, San Francisco, CA, 94105

view__c,Garden/Greenbelt;Bay;Bay Bridge;San Francisco

website_property_type__c,Condominium

window_features__c,Triple Pane Full

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94105

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,219 Brannan Street #3E, San Francisco, CA, 94107

ffd_mls_id,423909458

ffd_salesforce_id,a0E8W00000dTLISUA4

num_of_fireplaces__c,0

num_of_rooms__c,2

of_units__c,113

address2__c,219 Brannan Street #3E, San Francisco, CA, 94107

pba__address_pb__c,219 Brannan Street #3E, San Francisco, CA, 94107

agent_only_remarks__c,Contact Eric 415.425.1516 for private showings. Owner is a licensed real estate agent & appraiser.

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

architectural_style__c,Contemporary;Modern/High Tech

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,2000

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-20T21:46:56.000+0000

days_on_market__c,7

dom__c,7

ffd_description_pb,Rare Offering for the Brannan-Delancey area and especially for The Brannan Towers. Welcome to this super charming Jr One Bedroom light filled unit. This is the first time in The Brannan's 23 year history a Jr One Bedroom has become available on the 3rd Floor! Possibly your SF pied-a-tier for Giants & Warriors games? Perhaps at home workspace? Maybe your year round SF getaway or live here full time! Unit 3E is part of the Brannan's full-service offerings which include 24 hour door person, 75-foot heated lap pool, spa, cabana, BBQ area, 3,000 square foot fitness center and concierge services. The Brannan is also located 1 block from the Embarcadero waterfront, close to the Ferry Building Plaza, Farmers Market, Oracle Park (Giants), Chase Center (Warriors), Caltrain, shops & world-class restaurants. 1 car parking is also included!

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Carpet;Tile

hoa_fee_includes__c,Common Areas,Elevator,Insurance on Structure,Maintenance Grounds,Security,Sewer,Trash,Water

pba__hoafees__c,1308

pba__hoafrequency_pb__c,Monthly

hoa_name__c,The Brannan HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-09-21T13:46:01.000+0000

pba__latitude_pb__c,37.783047

pba__latitude_property__c,37.783047

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2023-09-13

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Eric

pba__listing_agent_lastname__c,Turner

listing_agent_mls_id__c,804276

ffd_listingagentname,Eric Turner

listing_agent_number__c,166013782

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,575000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.390159

mls_id__c,423909458

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

master_property__c,a0O1I000001VhhfUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-14

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

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

original_price__c,575000

overall_days_on_market__c,-81705

parking_access__c,Side by Side

parking_features__c,Attached,Enclosed,Garage Door Opener,Interior Access

parking_type__c,On Site - Mapped (Condo Only)

pba__pendingdate__c,1800-01-01

pba__pool_pb__c,1

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,1207.98

pba__propertytype__c,Condominium

ListingId,a0E8W00000dTLISUA4

room_type__c,Library;Living Room

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

size__c,476

spa__c,1

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Brannan

subdist__c,South Beach

ffd_name,219 Brannan Street #3E, San Francisco, CA, 94107

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2000

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,15 Guy Place, San Francisco, CA, 94105

ffd_mls_id,423910570

ffd_salesforce_id,a0E8W00000dSpkCUAS

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,2

address2__c,15 Guy Place, San Francisco, CA, 94105

pba__address_pb__c,15 Guy Place, San Francisco, CA, 94105

agent_only_remarks__c,Escrow with Rita Lin at ORTC. Shown by appointment, please call for more information.

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

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2020

pba__city_pb__c,San Francisco

listing_co_agent_name__c,James Nunemacher

pba__contingentdate__c,1800-01-01

cooling__c,Other,See Remarks

ffd_createddate,2023-09-18T22:46:37.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,15 Guy Place is a 2 bedroom, 2.5 bath 1,870 sqft custom new construction condominium residence in a boutique two residence townhouse located amongst San Francisco's most prestigious luxury towers and residences. The home is set in SF's 150 year old Rincon Hill neighborhood, one of The City's Original Seven hills along with its famous neighbors, Nob Hill and Russian Hill. The two level residence is set on the 2nd and 3rd floors of the new construction building just steps form some of the City's most well known attractions. The second floor primary suite has a private terrace and large primary suite with soaking tub and double shower. The custom kitchen is wrapped in Calacatta Italian marble and is a perfect pairing with the homes white oak floors.

district__c,SF District 9

driveway_sidewalks__c,Paved Sidewalk

entry_level__c,0

exterior_features__c,Balcony;Fire Pit

external_listing__c,1

fireplace_features__c,Other;See Remarks

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,Yes

pba__halfbathrooms_pb__c,1

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Radiant

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

ffd_lastmodifieddate,2023-09-22T19:46:59.000+0000

pba__latitude_pb__c,37.7863899

pba__latitude_property__c,37.7863899

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2023-09-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Frank

pba__listing_agent_lastname__c,Nolan

listing_agent_mls_id__c,803037

ffd_listingagentname,Frank A Nolan

listing_agent_number__c,803037

listing_co_agent_mls_id__c,223773

listing_co_agent_number__c,223773

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

pba__listingtype__c,Sale

pba__listing_website__c,http://GuyPlaceSF.com

pba__longitude_pb__c,-122.3943964

lower_level__c,Retreat,Street Entrance

mls_id__c,423910570

main_level__c,Kitchen;Living Room;Dining Room;Family Room;Primary Bedroom

master_bathroom_features__c,Double Sinks;Soaking Tub;Marble

master_property__c,a0O8W00000HvFaOUAV

monthly_parking_fees__c,350

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-18

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

overall_days_on_market__c,-81709

parking_access__c,Independent

parking_features__c,Garage Door Opener,Interior Access,Mechanical Lift

parking_type__c,Other;On Site (Single Family Only);On Site - Lease Available (Condo Only)

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000dSpkCUAS

road_surface_type__c,Asphalt

roof__c,Composition

room_type__c,Wine Storage Area;Temp Controlled Room

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Fire Alarm;Fire Suppression System;Secured Access;Carbon Mon Detector;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,1870

size__c,1870

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Guy

subdist__c,South Beach

ffd_name,15 Guy Place, San Francisco, CA, 94105

view__c,City;City Lights;Downtown;San Francisco

website_property_type__c,Condominium

window_features__c,Dual Pane Full;Window Coverings;Bay Window(s)

pba__yearbuilt_pb__c,2020

pba__postalcode_pb__c,94105

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,14 Guy Place #A, San Francisco, CA, 94105

ffd_mls_id,423910424

ffd_salesforce_id,a0E8W00000dSoRzUAK

num_of_fireplaces__c,1

num_of_rooms__c,9

of_units__c,2

address2__c,14 Guy Place #A, San Francisco, CA, 94105

pba__address_pb__c,14 Guy Place #A, San Francisco, CA, 94105

appliances__c,Dishwasher;Disposal;Electric Cook Top;Built-In Refrigerator;Warming Drawer

architectural_style__c,Contemporary

bath_features__c,Shower Stall(s);Tub;Tile;Window

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,2

year_build_text__c,2000

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-18T18:46:50.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Perched atop an intimate tree-lined street on South Beach's Rincon Hill, one of the City's original 7 Hills, this designer tri-level condo features 2-bedrooms (+office), 3.5-bathrooms, soaring ceilings, a tranquil garden patio and luxury finishes throughout. The lower unit of a 2-unit building, this was built in 2000 by John Strickland and architect Daryl Yamamoto, and has since been meticulous updated throughout. The entry level features a primary bedroom with spa-like bathroom and adjacent bedroom, office, and full bathroom. Upstairs features a light-filled open living/dining room with gas fireplace and adjacent kitchen with top-of-the-line miele appliances. The lowermost level is a tranquil retreat complete with a full bathroom, dry bar, media area and peaceful garden with tea hut and fountain. Living at Guy Place means having convenient access to Essex Street stairway, Guy Place Mini Park, delicious eateries, the Embarcadero, freeways & Bay Bridge, shopping, Salesforce Transit Center, Yerba Buena Gardens and so much more.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard;Electric

fireplace_features__c,Living Room

pba__floortype_pb__c,Wood

pba__hoafees__c,0

pba__hoafrequency_pb__c,See Remarks

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Radiant;Radiant Floor

ffd_lastmodifieddate,2023-09-19T00:47:40.000+0000

pba__latitude_pb__c,37.786561

pba__latitude_property__c,37.786561

laundry_features__c,Inside Area

listed_date__c,2023-09-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Mary Lou

pba__listing_agent_lastname__c,Castellanos

listing_agent_mls_id__c,301994

ffd_listingagentname,Mary Castellanos

listing_agent_number__c,301994

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.394547

lower_level__c,Family Room,Garage,Street Entrance

mls_id__c,423910424

main_level__c,Full Bath(s);Bedroom(s);Primary Bedroom

master_bathroom_features__c,Shower Stall(s);Tile;Soaking Tub;Stone

master_property__c,a0O8W00000KTS5kUAH

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-18

open_house_end__c,2023-09-19T11:00:00.000+0000

open_house_start__c,2023-09-19T09:00:00.000+0000

original_price__c,2699000

overall_days_on_market__c,-81709

parking_access__c,Independent

parking_features__c,Attached,Enclosed,Garage Door Opener,Interior Access

parking_type__c,On Site - Assigned (Condo Only)

patio_and_porch_features__c,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,1127.87

pba__propertytype__c,Condominium

ListingId,a0E8W00000dSoRzUAK

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

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security Fence;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,2393

size__c,2393

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Guy

subdist__c,South Beach

ffd_name,14 Guy Place #A, San Francisco, CA, 94105

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2000

pba__postalcode_pb__c,94105

ffd_media,Array

ffd_media_tags,Array

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