ffd_listing_title,280 Spear Street #29C, San Francisco, CA, 94105

ffd_mls_id,423744753

ffd_salesforce_id,a0E8W00000awiCWUAY

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,391

address2__c,280 Spear Street #29C, San Francisco, CA, 94105

pba__address_pb__c,280 Spear Street #29C, San Francisco, CA, 94105

agent_only_remarks__c,Text or email Paul at (415.216.8746 / [email protected]) to schedule showing.

appliances__c,Dishwasher;Microwave;Built-In Gas Range;Built-In Refrigerator;Gas Cook Top;Built-In Freezer;Built-In Electric Oven

architectural_style__c,Contemporary

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

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2020

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2023-05-26T21:48:32.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Coveted, corner Bay Bridge, water & city view 2BR home at Mira. The beautiful home features an open floor plan with premium wide-plank hardwood flooring throughout, custom window treatments, custom lighting, and a chef's kitchen with SOZO Studio cabinetry, Caesarstone countertops, and high-end Miele appliances. Luxurious bathrooms are finished with Volakas marble countertops, floating vanities, Kohler fixtures, and Italian-made porcelain tile. Ample storage, a private balcony, in-unit washer/dryer, and 1 secure garage valet parking space complete the home. Located on the corner of Spear & Folsom, Mira features iconic architecture, innovative layouts, striking views and a bold attitude. With forward thinking floor plans, Mira invites you to shift your perspective on San Francisco living. Mira Is home to a full suite of amenities including private dining rooms, a Jay Wright designed Fitness Center, a rooftop deck with BBQs, 24hr doorman and concierge, and more. Pleasant walk to the Embarcadero waterfront & Ferry Building, Downtown, Financial District, Union Square, SF MoMA, world class restaurants, Oracle Park, and more. Easy access to public transportation, 80, 280 and the Bay Bridge.

district__c,SF District 9

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Common Areas,Door Person,Gas,Maintenance Exterior,Maintenance Grounds,Management,Organized Activities,Security,Sewer,Trash,Water

pba__hoafees__c,1250

pba__hoafrequency_pb__c,Monthly

hoa_name__c,MIRA HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-05-27T10:48:09.000+0000

pba__latitude_pb__c,37.78989

pba__latitude_property__c,37.78989

laundry_features__c,Washer Included;Dryer Included;Stacked Only

listed_date__c,2023-05-26

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Paul

pba__listing_agent_lastname__c,Hwang

listing_agent_mls_id__c,981227

ffd_listingagentname,Paul Hwang

listing_agent_number__c,981227

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,SKYBOX

listing_office_name__c,Skybox Realty

listing_office_number__c,191002105

pba__listingprice_pb__c,2075000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.391532

mls_id__c,423744753

master_bathroom_features__c,Double Sinks

master_property__c,a0O8W00000DagtvUAB

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-05-26

open_house_end__c,2023-05-28T16:00:00.000+0000

open_house_start__c,2023-05-28T13:00:00.000+0000

original_price__c,2075000

overall_days_on_market__c,-81594

parking_access__c,Side by Side

parking_features__c,Attached,Valet

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000awiCWUAY

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;Secured Access;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,1312

size__c,1312

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Spear

subdist__c,South Beach

ffd_name,280 Spear Street #29C, San Francisco, CA, 94105

view__c,City;City Lights;Bay;Water;Bay Bridge;San Francisco

website_property_type__c,Condominium

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

ffd_listing_title,229 Brannan Street #12J, San Francisco, CA, 94107

ffd_mls_id,423744014

ffd_salesforce_id,a0E8W00000awflAUAQ

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,130

address2__c,229 Brannan Street #12J, San Francisco, CA, 94107

pba__address_pb__c,229 Brannan Street #12J, San Francisco, CA, 94107

agent_only_remarks__c,View at 229Brannan12J.com | Easy to show, call/txt 415.425.1516

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

architectural_style__c,Contemporary;Modern/High Tech

bath_features__c,Tub w/Shower Over;Shower Stall(s);Tile

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2001

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2023-05-26T01:48:56.000+0000

days_on_market__c,2

dom__c,1

ffd_description_pb,Located 1 block from the Embarcadero Waterfront, this beautiful corner unit offers an exquisite feeling filled with sunlight throughout the day, two bedrooms, two full baths and spectacular Twin Peaks and SF skyline views. Unit 12J has dark wide plank hardwood floors highlighted by the expansive and elegant L shaped living and dining rooms complemented by a spacious lounge and reading area. A large primary bedroom with en suite bathroom includes a private balcony with amazing Twin Peaks views, while the expansive windows in the second bedroom provide far-reaching and dramatic city views. Situated on opposite sides of the unit, the two bedrooms provide an unparalleled level of privacy. The Brannan is a full-service building offering 24-hr security, concierge services, professionally managed, amazing pool, jacuzzi and fitness center.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Common Areas,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Roof,Security,Sewer,Trash

pba__hoafees__c,1400

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-05-27T00:48:19.000+0000

pba__latitude_pb__c,37.783043

pba__latitude_property__c,37.783043

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included;Washer Included;Dryer Included;Stacked Only

listed_date__c,2023-05-22

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

pba__listingtype__c,Sale

pba__listing_website__c,http://229brannan12J.com

pba__longitude_pb__c,-122.390301

mls_id__c,423744014

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

master_bathroom_features__c,Tub w/Shower Over;Tile

master_property__c,a0O1I000001VhhnUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-05-25

open_house_end__c,2023-05-28T16:00:00.000+0000

open_house_start__c,2023-05-28T14:00:00.000+0000

original_price__c,1595000

overall_days_on_market__c,-81593

parking_access__c,Side by Side

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

parking_type__c,On Site - Mapped (Condo Only)

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000awflAUAQ

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

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

size__c,1412

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Brannan

subdist__c,South Beach

ffd_name,229 Brannan Street #12J, San Francisco, CA, 94107

view__c,City Lights;Downtown;Twin Peaks

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2001

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

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

ffd_mls_id,423743805

ffd_salesforce_id,a0E8W00000awflEUAQ

num_of_fireplaces__c,0

num_of_rooms__c,3

of_units__c,120

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

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

agent_only_remarks__c,Showings by appointment only. Please call 415.215.2384 to schedule an appointment.

appliances__c,Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Ice Maker;Built-In Refrigerator;Built-In Freezer

architectural_style__c,Modern/High Tech

bath_features__c,Tub w/Shower Over;Marble;Dual Flush Toilet;Double Sinks

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,2021

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Garrett R Frakes

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2023-05-26T01:48:56.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,Remarkably rare collection of homes along the famed Bay. This stunning and spacious 1 Bedroom 1.5 Bathroom home features an open great room with a chef's entertaining kitchen featuring appliances by Gaggenau. The primary suite showcases the signature One Steuart Lane primary bathroom designed to rival any 5-star hotel. This once-in-a-generation opportunity affords a waterfront lifestyle rarely available. Designed by world-renowned architects Skidmore, Ownings & Merrill, designed as a timeless connection between the city & the water. Amenities include valet parking, attended lobby, lounge w/full kitchen & waterfront terrace, Wellness Center w/complete fitness with Pilates studio, outdoor terrace & spa facilities including steam, sauna & outdoor hot spa. HOA dues include parking fee.

district__c,SF District 9

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Marble;Wood

hoa_fee_includes__c,Common Areas,Door Person,Elevator,Insurance on Structure,Maintenance Grounds,Management,Security,Trash,Water

pba__hoafees__c,2957

pba__hoafrequency_pb__c,Monthly

hoa_name__c,One Steuart Lane Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-05-26T10:49:21.000+0000

pba__latitude_pb__c,37.79444497

pba__latitude_property__c,37.79444497

laundry_features__c,Laundry Closet;Hookups Only

listed_date__c,2023-05-24

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_mls_id__c,805198

listing_co_agent_number__c,802436

listing_co_office_mls_id__c,POGR

listing_co_office_name__c,Polaris Pacific

listing_co_office_number__c,166013106

listing_office_mls_id__c,POGR

listing_office_name__c,Polaris Pacific

listing_office_number__c,166013106

pba__listingprice_pb__c,1390000

pba__listingtype__c,Sale

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

pba__longitude_pb__c,-122.39464807

mls_id__c,423743805

master_property__c,a0O8W00000FqH2dUAF

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-05-24

open_house_end__c,2023-05-27T13:00:00.000+0000

open_house_start__c,2023-05-27T11:00:00.000+0000

original_price__c,1390000

overall_days_on_market__c,-81592

parking_access__c,Side by Side

parking_features__c,Covered,Enclosed,EV Charging,Garage Door Opener,Garage Facing Side,Interior Access,Unassigned,Underground Parking

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000awflEUAQ

room_type__c,Living Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security Gate;Carbon Mon Detector;Guarded Gate

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

size__c,1101

spa__c,1

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Steuart

subdist__c,South Beach

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

view__c,City

website_property_type__c,Condominium

window_features__c,Triple Pane Full

pba__yearbuilt_pb__c,2021

pba__postalcode_pb__c,94105

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,280 Spear Street #25G, San Francisco, CA, 94105

ffd_mls_id,423744584

ffd_salesforce_id,a0E8W00000aweNCUAY

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,392

address2__c,280 Spear Street #25G, San Francisco, CA, 94105

pba__address_pb__c,280 Spear Street #25G, San Francisco, CA, 94105

agent_only_remarks__c,Please call 415.839.8383 to speak with a sales associate to schedule an appointment. Appointments are required. Please visit www.MIRASF.com for more information.

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;ENERGY STAR Qualified Appliances;Wine Refrigerator;Ice Maker;Self/Cont Clean Oven;Built-In Refrigerator;Built-In Freezer;Built-In Electric Oven

architectural_style__c,Modern/High Tech

bath_features__c,Tub w/Shower Over;Shower Stall(s);Tub;Low-Flow Toilet(s)

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2022

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central,Heat Pump

ffd_createddate,2023-05-25T16:49:18.000+0000

days_on_market__c,1

dom__c,0

ffd_description_pb,MODEL HOME - With Upgrades - Explore a new angle on life at MIRA, luxury condominium homes developed by the team at Tishman Speyer and designed by award-winning architecture Studio Gang. Located at the corner of Spear and Folsom Streets in San Francisco, CA, MIRA features iconic architecture, innovative layouts, striking views and a bold attitude. Fresh and forward-thinking, MIRA invites you to shift your perspective on living in San Francisco. All images are representative of the development.

district__c,SF District 9

driveway_sidewalks__c,Gated

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Door Person,Elevator,Gas,Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Recreation Facility,Roof,Security,Sewer,Trash,Water

pba__hoafees__c,1495

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Heat Pump

ffd_lastmodifieddate,2023-05-26T01:48:45.000+0000

pba__latitude_pb__c,37.78989

pba__latitude_property__c,37.78989

laundry_features__c,Laundry Closet;Washer Included;Dryer Included

listed_date__c,2023-05-25

pba__listing_agent_email__c,[email protected]m

pba__listing_agent_firstname__c,Garrett

pba__listing_agent_lastname__c,Frakes

listing_agent_mls_id__c,805198

ffd_listingagentname,Garrett R Frakes

listing_agent_number__c,802436

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

pba__listingtype__c,Sale

pba__listing_website__c,https://mirasf.com/marketing

pba__longitude_pb__c,-122.391532

mls_id__c,423744584

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

master_bathroom_features__c,Tub w/Shower Over;Low-Flow Toilet(s);Marble

master_property__c,a0O8W00000DagtvUAB

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-05-25

open_house_end__c,2023-05-27T15:00:00.000+0000

open_house_start__c,2023-05-27T13:00:00.000+0000

original_price__c,2085000

overall_days_on_market__c,-81593

parking_access__c,Independent

parking_features__c,Valet

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000aweNCUAY

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

size__c,1548

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Spear

subdist__c,South Beach

ffd_name,280 Spear Street #25G, San Francisco, CA, 94105

view__c,Bay;Downtown;Bay Bridge

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2022

pba__postalcode_pb__c,94105

ffd_media,Array

ffd_media_tags,Array

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