249 Shipley Street #12, San Francisco, CA, 94107 - Property Description

_yoast_indexnow_last_ping,1713956275

ffd_listing_title,1160 Mission Street #1008, San Francisco, CA, 94103

ffd_mls_id,424026804

ffd_salesforce_id,a0EUd000001p9n3MAA

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,246

address2__c,1160 Mission Street #1008, San Francisco, CA, 94103

pba__address_pb__c,1160 Mission Street #1008, San Francisco, CA, 94103

agent_only_remarks__c,Truly the best valued condo in Soma Grand with jetliner San Francisco skyline views. One parking spot available(via month to month lease). Please contact Payam to schedule an appointment (preferably at least 24-48 hours notice). Disclosure package with reports available soon. Property is vacant and virtually staged.

appliances__c,Dishwasher;Microwave;Disposal;Free Standing Refrigerator;Built-In Electric Range

architectural_style__c,Modern/High Tech

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2008

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-23T22:46:43.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Experience breathtaking jetliner views of the San Francisco skyline from this stunning, modern, and technologically advanced high-rise condominium. Boasting 2 bedrooms and 2 full baths (including 1 en-suite), this luxurious unit offers a spacious open floor plan accentuated by expansive windows, flooding the space with natural light. The chef's kitchen, adorned with Bosch appliances, Studio Becker cabinetry, and Cambria quartz countertops, exudes elegance and functionality. Light wood floors add a touch of chic sophistication throughout. Relish in the comfort of the primary bedroom with its panoramic views of the San Francisco skyline and ample walk-in closet. The en-suite primary bathroom features a custom Studio Becker double vanity with quartz countertops and a luxurious walk-in shower. Indulge in resort-style living with an array of amenities including twice-monthly in-unit housekeeping, a fitness center, outdoor spa, lounge area with fire pit, dining area with built-in BBQ, community club room, 24-hour attended lobby, coffee bar, and additional guest parkingall included in the HOA dues. Experience the epitome of modern urban living in this exceptional condominium.

district__c,SF District 9

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

exterior_features__c,Balcony;Uncovered Courtyard;Entry Gate;BBQ Built-In;Fire Pit;Kitchen

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

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

pba__hoafees__c,1134

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Soma Grand HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Central;MultiZone

ffd_lastmodifieddate,2024-04-24T10:47:49.000+0000

pba__latitude_pb__c,37.778705

pba__latitude_property__c,37.778705

laundry_features__c,Laundry Closet;Stacked Only

listed_date__c,2024-04-20

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Payam

pba__listing_agent_lastname__c,Ghafoori

listing_agent_mls_id__c,815784

ffd_listingagentname,Payam Ghafoori

listing_agent_number__c,1074755

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.412635

mls_id__c,424026804

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

master_bathroom_features__c,Quartz;Double Sinks;Tile

master_property__c,a0O1I000001Vhi3UAC

monthly_parking_fees__c,75

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-23

original_price__c,939000

overall_days_on_market__c,-81927

parking_access__c,Side by Side

parking_features__c,Covered,Enclosed,EV Charging,Side-by-Side

parking_type__c,On Site ' Monthly Fee (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,793.07

pba__propertytype__c,Condominium

ListingId,a0EUd000001p9n3MAA

road_surface_type__c,Paved

room_type__c,Storage;Laundry;Kitchen;Living Room;Dining Room;Great Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;Fire Extinguisher;Carbon Mon Detector;Video System;Security Patrol;Other;Panic Alarm

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

size__c,1184

spa__c,1

pba__state_pb__c,CA

stories__c,23

pba__street_pb__c,Mission

subdist__c,South of Market

ffd_name,1160 Mission Street #1008, San Francisco, CA, 94103

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

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2008

pba__postalcode_pb__c,94103

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713610867

ffd_listing_title,1288 Howard Street #304, San Francisco, CA, 94103

ffd_mls_id,424026006

ffd_salesforce_id,a0EUd000001nKZmMAM

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,129

address2__c,1288 Howard Street #304, San Francisco, CA, 94103

pba__address_pb__c,1288 Howard Street #304, San Francisco, CA, 94103

agent_only_remarks__c,Listed by: Michael Brizzolara 415-800-3886 [email protected] Parking available for purchase.

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

architectural_style__c,Modern/High Tech

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

ffd_createddate,2024-04-20T00:49:11.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Elegant & opulent design in this corner 2-bedroom, 2-bathroom with den home with walls-of-glass and soaring with sunlight and city skyline views. A lush outdoor courtyard is situated just outside the door. The primary bedroom and ensuite is beautifully designed with dual vanity, 20-inch wall surround tile, and an all-glass over-sized shower enclosure. 1288 Howard is a thoughtfully conceived & luxuriously appointed new condominium complex that brings you the best of SoMa, Hayes Valley, & The Theater District. Residences are designed for how people live, work, entertain and relax. Choose what fits your lifestyle from studios/junior, one-, and two-bedroom flats, artist-style lofts, & townhomes. Luxurious interiors, designer finishes, and open floor plan set these residences in a category of their own. 1288 Howard offers superior amenities: In-unit AC, state-of-the-art fitness, doorman, business center, rooftop terrace with BBQ, firepit & TV, Garden Courtyard, while keeping HOA dues low. With its distinctive Lane, a contemporary interpretation of a European Cobblestone alley, 1288 Howard is an urban sanctuary. After enjoying the city's top restaurants, theater & entertainment. Parking available for purchase.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Laminate

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

pba__hoafees__c,438

pba__hoafrequency_pb__c,Monthly

hoa_name__c,First Service Residential

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2024-04-20T10:46:59.000+0000

pba__latitude_pb__c,37.7754633

pba__latitude_property__c,37.7754633

laundry_features__c,Hookups Only

listed_date__c,2024-04-19

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Michael

pba__listing_agent_lastname__c,Brizzolara

listing_agent_mls_id__c,812376

ffd_listingagentname,Michael R Brizzolara

listing_agent_number__c,1056294

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,MARCH

listing_office_name__c,March Properties

listing_office_number__c,28735

pba__listingprice_pb__c,865000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.413175

mls_id__c,424026006

master_bathroom_features__c,Tub w/Shower Over;Stone;Sunken Tub

master_property__c,a0O8W00000DaIsMUAV

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-19

open_house_end__c,2024-04-20T16:00:00.000+0000

open_house_start__c,2024-04-20T12:00:00.000+0000

original_price__c,865000

overall_days_on_market__c,-81923

parking_access__c,Side by Side

parking_features__c,Alley Access,Assigned,Covered,Drive Thru Garage,Enclosed,Garage Door Opener,Garage Facing Side,Interior Access

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001nKZmMAM

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

pba__street_pb__c,Howard

subdist__c,South of Market

ffd_name,1288 Howard Street #304, San Francisco, CA, 94103

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2022

pba__postalcode_pb__c,94103

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714013936

ffd_listing_title,7 Hallam Street #1A, San Francisco, CA, 94103

ffd_mls_id,424023669

ffd_salesforce_id,a0EUd000001mrpWMAQ

num_of_fireplaces__c,0

num_of_rooms__c,2

of_units__c,9

address2__c,7 Hallam Street #1A, San Francisco, CA, 94103

pba__address_pb__c,7 Hallam Street #1A, San Francisco, CA, 94103

agent_only_remarks__c,Please use open escrow with Christine Lin at Old Republic Title Company, Ocean Avenue, SF.

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

architectural_style__c,Modern/High Tech

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,1992

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Carren S Shagley

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-19T17:47:36.000+0000

days_on_market__c,5

dom__c,5

ffd_description_pb,Welcome to 7 Hallam Street an award-winning building designed by Siegel & Strain Architects. Unit 1A is a chic split-level, 1-bed, 1-bath condo with a loft that exceeds expectations. Soaring 2-story floor-to-ceiling windows in living room. Patio door extends indoor-outdoor living to a private patio/entertainment space. The versatile loft offers ideal space for home office or guest retreat. Spacious bedroom, featuring 1.5-story high ceilings and large bay window. Thoughtfully laid out with hardwood floors, newer stainless steel appliances (refrigerator, electric oven, & dishwasher), stone countertops, wood cabinets, and dining area. Tiled bath has double sinks, with a shower over tub. In-unit laundry, one full-size car parking, & additional storage. Located in the heart of SOMA, within walking distance of several coffee shops, eateries, bars, parks, conveniences, public transportation, and freeways. See this inner San Francisco sanctuary!

district__c,SF District 9

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

electric__c,220 Volts in Laundry

entry_level__c,0

external_listing__c,1

fencing__c,Fenced;Metal;Masonry

pba__floortype_pb__c,Carpet;Wood

hoa_fee_includes__c,Common Areas,Heat,Homeowners Insurance,Trash,Water

pba__hoafees__c,625

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Electric

ffd_lastmodifieddate,2024-04-25T02:47:43.000+0000

pba__latitude_pb__c,37.775735

pba__latitude_property__c,37.775735

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included;Inside Area;Washer Included;Dryer Included

listed_date__c,2024-03-21

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jennifer

pba__listing_agent_lastname__c,Burden

listing_agent_mls_id__c,804035

ffd_listingagentname,Jennifer C Burden

listing_agent_number__c,166013451

listing_co_agent_mls_id__c,113506

listing_co_agent_number__c,113506

listing_co_office_mls_id__c,LEGACY

listing_co_office_name__c,Legacy Real Estate

listing_co_office_number__c,27760

listing_office_mls_id__c,LEGACY

listing_office_name__c,Legacy Real Estate

listing_office_number__c,27760

pba__listingprice_pb__c,749000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.7hallam.com

pba__longitude_pb__c,-122.408298

lower_level__c,Living Room

mls_id__c,424023669

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

master_bathroom_features__c,Tub w/Shower Over;Double Sinks;Tile

master_property__c,a0O8W00000KSrcmUAD

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-19

open_house_end__c,2024-04-28T16:00:00.000+0000

open_house_start__c,2024-04-28T14:00:00.000+0000

original_price__c,749000

overall_days_on_market__c,-81923

parking_access__c,Independent

parking_features__c,Assigned,Attached,Covered,Garage Door Opener,Garage Facing Front,Interior Access

parking_type__c,On Site - Assigned (Condo Only)

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001mrpWMAQ

road_surface_type__c,Paved

room_type__c,Laundry;Kitchen;Loft;Living Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;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,1056

size__c,1056

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Hallam

subdist__c,South of Market

ffd_name,7 Hallam Street #1A, San Francisco, CA, 94103

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1992

pba__postalcode_pb__c,94103

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713567710

ffd_listing_title,765 Market Street #36E, San Francisco, CA, 94103

ffd_mls_id,424025406

ffd_salesforce_id,a0EUd000001mqYQMAY

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,142

address2__c,765 Market Street #36E, San Francisco, CA, 94103

pba__address_pb__c,765 Market Street #36E, San Francisco, CA, 94103

appliances__c,Dishwasher;Microwave;Disposal;Free Standing Gas Oven;Built-In Gas Oven;Wine Refrigerator;Built-In Refrigerator

architectural_style__c,Modern/High Tech

bath_features__c,Tub w/Shower Over;Marble

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

ffd_createddate,2024-04-19T16:47:44.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Welcome to the epitome of ultra-luxury living at The Four Seasons Residences, No. 36E This breathtaking property floating high above the City's Union Square enjoys unparalleled views sweeping from the Golden Gate Bridge to the gleaming towers of the Financial District with other iconic landmarks such as Union Square, Alcatraz, and the spires of the City's iconic St. Ignatius, Grace Cathedral and St. Peter Paul churches framed by the shimmering waters of the Bay as a scenic backdrop during the day and adding to the glittering lights of the night-time view. Beautifully light-filled, this 2 bedroom, 2.5 bath condominium home features an exceptional open floorplan design with walls of glass showcasing the stunning views and showering the residence with wonderful natural light, while high-end designer finishes create warm and elegant spaces perfect for both entertaining as well as comfortable everyday living and lounging. This super-sophisticated residence is truly a gem that offers the best of everything- sky-high views, opulent living spaces, unparalleled amenities, and the ultimate urban location in the heart of San Francisco's world-class shopping, dining, theater, cultural, entertainment, sporting and business attractions of the Union Square, Theater District, FiDi and SoMa

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Door Person,Earthquake Insurance,Heat,Insurance on Structure,Maintenance Grounds,Management,Security,Trash,Water

pba__hoafees__c,3295

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Wall Furnace

ffd_lastmodifieddate,2024-04-19T22:47:25.000+0000

pba__latitude_pb__c,37.786258

pba__latitude_property__c,37.786258

laundry_features__c,Laundry Closet

listed_date__c,2024-04-15

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Joel

pba__listing_agent_lastname__c,Goodrich

listing_agent_mls_id__c,364929

ffd_listingagentname,Joel Goodrich

listing_agent_number__c,364929

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

pba__listingtype__c,Sale

pba__listing_website__c,https://view.publitas.com/coldwell-banker-global-luxury-bye4oqyk9jkk/765m36e-brochure/page/1

pba__longitude_pb__c,-122.404447

mls_id__c,424025406

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

master_bathroom_features__c,Shower Stall(s);Double Sinks;Soaking Tub;Marble

master_property__c,a0O1I000001VhisUAC

monthly_parking_fees__c,260

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-18

original_price__c,2850000

overall_days_on_market__c,-81922

parking_access__c,Independent

parking_features__c,Side-by-Side

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001mqYQMAY

room_type__c,Kitchen;Living 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,0

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Market

subdist__c,South of Market

ffd_name,765 Market Street #36E, San Francisco, CA, 94103

view__c,Bay;Downtown;San Francisco;Golden Gate Bridge;Sutro Tower;Mt Tamalpais

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2001

pba__postalcode_pb__c,94103

ffd_media,Array

ffd_media_tags,Array

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