25 Lucerne Street #1, San Francisco, CA, 94103 - Property Description

_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,1713574785

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

dom__c,0

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-20T00:48:21.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-21T16:00:00.000+0000

open_house_start__c,2024-04-21T14: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

_yoast_indexnow_last_ping,1713610808

ffd_listing_title,357 Tehama Street #1, San Francisco, CA, 94103

ffd_mls_id,424025288

ffd_salesforce_id,a0EUd000001mYDUMA2

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,4

address2__c,357 Tehama Street #1, San Francisco, CA, 94103

pba__address_pb__c,357 Tehama Street #1, San Francisco, CA, 94103

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1910

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-19T10:49:46.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,Experience the epitome of urban living in this hip and versatile brick and timber loft located in one of San Francisco's most convenient neighborhoods, SOMA. 357 Tehama Street #1 is one of only four lofts in the building and has the rare designation of live/work, allowing for partial office use. Residence #1 boasts 13-foot ceilings that create an incredible sense of volume and features two-bedrooms, one-bathroom, and a large storage/sleeping loft. There are multiple closets throughout and a large washer and dryer. The living/dining/kitchen area seamlessly flows amongst each other and even has a movie screen recessing from the ceiling adding a touch of modern functionality. Designed lighting throughout enhances the ambiance, while the custom-built kitchen features high-end Miele appliances for the ultimate culinary experience. Additionally, this home comes with dedicated parking directly attached to the home. Located just around the corner from the InterContinental Hotel, this loft offers more than just a stylish living space, it's a gateway to the best of city living. Enjoy easy access to a plethora of amenities including restaurants, cafes, Trader Joe's, Costco, freeways, and public transportation, all within reach of your doorstep.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__hoafees__c,460

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

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

pba__latitude_pb__c,37.781666

pba__latitude_property__c,37.781666

listed_date__c,2024-04-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Justin

pba__listing_agent_lastname__c,Goldberg

listing_agent_mls_id__c,981678

ffd_listingagentname,Justin Goldberg

listing_agent_number__c,1017282

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.403364

mls_id__c,424025288

master_property__c,a0OUd000006CbTPMA0

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-18

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

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

original_price__c,850000

overall_days_on_market__c,-81922

parking_access__c,Side by Side

parking_features__c,Garage Facing Front

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001mYDUMA2

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

size__c,1403

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Tehama

subdist__c,South of Market

ffd_name,357 Tehama Street #1, San Francisco, CA, 94103

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1910

pba__postalcode_pb__c,94103

ffd_media,Array

ffd_media_tags,Array

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