1515 Union Street #3A, San Francisco, CA, 94123 - Property Description

_yoast_indexnow_last_ping,1742001866

ffd_listing_title,2635 Lyon Street, San Francisco, CA, 94123

ffd_mls_id,425017553

ffd_salesforce_id,a0EUd000004W6rBMAS

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

pba__address_pb__c,2635 Lyon Street, San Francisco, CA, 94123

address2__c,2635 Lyon Street, San Francisco, CA, 94123

agent_only_remarks__c,No Showing Time Appointments please. Please call, email or text Nina directly.Property Website: https://www.2635lyon.com/mls/176268121. This property is a legal two-unit building with 5 beds 3.5 baths in the larger upper unit and 2 beds 1 bath in the smaller lower unit.

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

architectural_style__c,Contemporary;Edwardian

bath_features__c,Tub w/Shower Over;Shower Stall(s);Marble;Radiant Heat

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,7

year_build_text__c,1922

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Natalie Kitchen

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2025-03-14T18:47:43.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Unique renovated Mediterranean home right on the Presidio border, fully detached on all sides with sweeping Bay views. With 5 bedrooms, 3.5 bathrooms, a family room, office, pentroom, multiple decks, and a separate guest apartment, this house is truly a special find. The main level presents formal living and dining rooms, an office or den, powder room, laundry room, and a gourmet chef's kitchen with custom maple cabinetry and deluxe appliances. Downstairs are 4 light-filled bedrooms, 2 lovely marble bathrooms, and a media room with a beautiful view deck. On the top level is a fabulous pentroom with a nanowall to a wraparound deck, boasting outlooks across the city, the Bay, Alcatraz, and the lush greenery of the Presidio. A ladder leads to a roof deck with more amazing views. The expansive, sun-drenched primary suite includes a gorgeous, spa-like bathroom and a walk-in closet. On the lowest level is a well-appointed legal 2-bed, 1-bath guest apartment, perfect for guests or rental income. Elevator to all levels, 1-car garage w/EV charger, wine cellar, radiant-heated floors, smart home features, foundation/structural upgrades, and more. All this in a coveted, peaceful location in Cow Hollow at the Presidio, offering miles of trails, great restaurants and Tunnel Tops playgroun

district__c,SF District 7

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Radiant Floor;Central

interior_features__c,Skylight(s);Wet Bar;Elevator

ffd_lastmodifieddate,2025-03-15T00:47:21.000+0000

pba__latitude_pb__c,37.7949657

pba__latitude_property__c,37.7949657

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2025-03-13

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Nina

pba__listing_agent_lastname__c,Hatvany

listing_agent_mls_id__c,372883

ffd_listingagentname,Nina Hatvany

listing_agent_number__c,372883

listing_co_agent_mls_id__c,400638

listing_co_agent_number__c,1021887

listing_co_office_mls_id__c,COMP12

listing_co_office_name__c,Compass

listing_co_office_number__c,28739

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,9995000

pba__listingtype__c,Sale

pba__listing_website__c,https://teamhatvany.com/

pba__longitude_pb__c,-122.4470113

lower_level__c,Bedroom(s),Family Room,Full Bath(s),Street Entrance

mls_id__c,425017553

main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room

master_bathroom_features__c,Shower Stall(s);Tub;Double Sinks;Walk-In Closet;Radiant Heat

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-03-14

open_house_end__c,2025-03-14T17:00:00.000+0000

open_house_start__c,2025-03-14T16:00:00.000+0000

original_price__c,9995000

overall_days_on_market__c,-82252

parking_access__c,Independent

parking_features__c,Garage Door Opener,Garage Facing Front,Interior Access

parking_type__c,On Site (Single Family 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,1902

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000004W6rBMAS

room_type__c,Laundry;Kitchen;Wine Cellar;In Law Apartment;Living Room;Dining Room;Family Room;Media 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,5255

size__c,5255

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,Lyon

subdist__c,Cow Hollow

ffd_name,2635 Lyon Street, San Francisco, CA, 94123

view__c,Garden/Greenbelt;Bay;Water;San Francisco;Hills

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1922

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1742267940

ffd_listing_title,3131 Pierce Street #101, San Francisco, CA, 94123

ffd_mls_id,425020235

ffd_salesforce_id,a0EUd000004VyH2MAK

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,22

pba__address_pb__c,3131 Pierce Street #101, San Francisco, CA, 94123

address2__c,3131 Pierce Street #101, San Francisco, CA, 94123

agent_only_remarks__c,Parking is disallowed to be attached to the unit or included with the sale per SF-Planning rules; must be sold independent - $50,000. Call for details. Contact Ed at 415.350.9083.

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;ENERGY STAR Qualified Appliances;Wine Refrigerator;Gas Cook Top;Built-In Electric Oven

architectural_style__c,Modern/High Tech

bath_features__c,Shower Stall(s);Tub;Low-Flow Toilet(s);Quartz

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2021

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Mary Cassidy

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2025-03-14T17:47:35.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,Cow Hollow/Marina's best townhouse!! Fabulous floor plan features a dramatic two-story great room, 2 bedrooms, loft, 2.5 bathrooms, and apx. 1,731 sq.ft. Kitchen features a massive center island, Studio Becker cabinetry, marble countertops and backsplash, Miele appliances, and wine refrigeration. The spa-like bathrooms are replete with designer tile floors and walls, Studio Becker vanities, Hansgrohe fixtures, and a curb-less walk-in shower. Building features include Google Web Pass, designer lobby, deeded storage, roof terrace with Golden Gate Bridge views, BBQs, fire-pits and outdoor lounge/dining room. Deeded parking available.

district__c,SF District 7

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Common Areas,Door Person,Insurance on Structure,Maintenance Exterior,Management,Trash

pba__hoafees__c,1246

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,2025-03-18T02:47:16.000+0000

pba__latitude_pb__c,37.799096

pba__latitude_property__c,37.799096

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2025-03-14

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Edward

pba__listing_agent_lastname__c,Deleski

listing_agent_mls_id__c,807512

ffd_listingagentname,Edward R Deleski

listing_agent_number__c,1020319

listing_co_agent_mls_id__c,805731

listing_co_agent_number__c,166015765

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

pba__listingtype__c,Sale

pba__listing_website__c,http://www.MuranoSanFrancisco.com

pba__longitude_pb__c,-122.439611

lower_level__c,Dining Room,Kitchen,Living Room,Partial Bath(s),Street Entrance

mls_id__c,425020235

main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room;Street Entrance

master_bathroom_features__c,Low-Flow Toilet(s);Quartz;Double Sinks;Multiple Shower Heads

master_property__c,a0O8W00000DagvIUAR

monthly_parking_fees__c,82

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-03-14

open_house_end__c,2025-03-18T12:00:00.000+0000

open_house_start__c,2025-03-18T10:00:00.000+0000

original_price__c,1795000

overall_days_on_market__c,-82252

parking_access__c,Independent

parking_features__c,Mechanical Lift,Side-by-Side

parking_type__c,On Site - Mapped (Condo Only)

patio_and_porch_features__c,Enclosed Patio;Front Porch

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

pba__propertytype__c,Condominium

ListingId,a0EUd000004VyH2MAK

room_type__c,Storage

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security 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,1731

size__c,1731

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Pierce

subdist__c,Cow Hollow

ffd_name,3131 Pierce Street #101, San Francisco, CA, 94123

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2021

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1742260850

ffd_listing_title,2525 Van Ness Avenue #502, San Francisco, CA, 94109

ffd_mls_id,424073787

ffd_salesforce_id,a0EUd000003MYhFMAW

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,28

pba__address_pb__c,2525 Van Ness Avenue #502, San Francisco, CA, 94109

address2__c,2525 Van Ness Avenue #502, San Francisco, CA, 94109

agent_only_remarks__c,Contact Frank Nolan for showings and DRE purchase agreement, 415.377.3726, [email protected]. www.belvederesf.com

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

architectural_style__c,Modern/High Tech

bath_features__c,Shower Stall(s);Tile;Quartz

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,2024

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-10-16T00:47:39.000+0000

days_on_market__c,153

dom__c,146

ffd_description_pb,Now 60% SOLD & offering seller rate buy-downs! The Belvedere, designed by world-renowned Handel Architects, is a culmination of elevated architectural design, tailor-made shared spaces, and 28 brand-new refined homes gracing San Francisco's prestigious Cow Hollow neighborhood. A concrete and steel structure built in 2024, The Belvedere features an exquisite, attended lobby, and incredible views captured from the two and three-bedroom homes. Crowning The Belvedere is an expansive, 6,200 sqft resort-style roof terrace with picture perfect views of the Golden Gate Bridge and San Francisco's most notable hills. The elegant kitchens include Miele appliances and gorgeous Gabana Quartzite stone, while the spa-like bathrooms are equipped with Waterworks fixtures and adorned in imported Calacatta stone. Additional features include: air conditioning, add'l storage, and bicycle parking. Residence 502 is a Golden Gate Bridge VIEW home boasting 3 beds/3.5 baths and 1,951 sqft with a spacious great room that leads to a covered terrace. The Belvedere is in a fantastic walking area, with the bustling shops, restaurants, and cafes of Union St in Cow Hollow right outside your door. Russian Hill, Pacific Heights, and The Marina are all just minutes away. Optional parking.

district__c,SF District 7

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Door Person,Elevator,Management,Trash

pba__hoafees__c,981

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,2025-03-18T00:46:59.000+0000

pba__latitude_pb__c,37.7990113

pba__latitude_property__c,37.7990113

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2024-10-15

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

listing_co_office_number__c,0

listing_office_mls_id__c,VANG02

listing_office_name__c,Vanguard Properties

listing_office_number__c,166013449

pba__listingprice_pb__c,3500000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.belvederesf.com/

pba__longitude_pb__c,-122.424363

mls_id__c,424073787

master_bathroom_features__c,Tub w/Shower Over;Shower Stall(s);Quartz;Double Sinks;Tile;Soaking Tub

master_property__c,a0OUd000002Ci7NMAS

monthly_parking_fees__c,85

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-10-15

open_house_end__c,2025-03-18T12:00:00.000+0000

open_house_start__c,2025-03-18T10:00:00.000+0000

original_price__c,3500000

overall_days_on_market__c,-82102

parking_access__c,Side by Side

parking_features__c,Garage Facing Front,Interior Access

parking_type__c,On Site - Assigned (Condo Only)

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

pba__propertytype__c,Condominium

ListingId,a0EUd000003MYhFMAW

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Suppression System;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,1951

size__c,1951

pba__state_pb__c,CA

stories__c,7

pba__street_pb__c,Van Ness

subdist__c,Cow Hollow

ffd_name,2525 Van Ness Avenue #502, San Francisco, CA, 94109

view__c,City;Bay;Water;San Francisco;Golden Gate Bridge;Hills

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2024

pba__postalcode_pb__c,94109

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1742174449

ffd_listing_title,1515 Union Street #PH4, San Francisco, CA, 94123

ffd_mls_id,425015294

ffd_salesforce_id,a0EUd000004S0apMAC

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,41

pba__address_pb__c,1515 Union Street #PH4, San Francisco, CA, 94123

address2__c,1515 Union Street #PH4, San Francisco, CA, 94123

agent_only_remarks__c,Showings are by appointment only. Please contact listing agent: David Costello at 415-828-8122 or Andy Ardila at 415-608-1003. If you prefer, email: [email protected] www.unionhousesf.com

appliances__c,Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Wine Refrigerator;Ice Maker;Built-In Refrigerator;Gas Cook Top;Built-In Freezer

architectural_style__c,Contemporary;Modern/High Tech

bath_features__c,Tub;Marble;Double Sinks

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,David S Costello

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2025-03-06T11:49:25.000+0000

days_on_market__c,10

dom__c,10

ffd_description_pb,Perched atop Union House in prestigious Pacific Heights, Penthouse Five is a breathtaking retreat that defines sophisticated city living. This northwest-facing, seventh-floor residence is one of the largest available, offering 1,943 square feet of refined elegance with three bedrooms and two-and-a-half baths. The showpiece of this home is the expansive private rooftop terrace, among the largest in the building, where panoramic views of the Golden Gate Bridge, Palace of Fine Arts, and the shimmering San Francisco Bay create a stunning backdrop for entertaining or quiet relaxation. Inside, the open-concept living area is designed for both comfort and style, featuring a chef's kitchen with top-tier appliances, a spacious island with a built-in wine fridge, and a seamless flow into the dining and family room. Residents enjoy world-class amenities, including a seven-day-a-week doorman, a shared rooftop lounge, private parking, and additional storage. Experience the pinnacle of luxury in one of San Francisco's most sought-after addresses.

district__c,SF District 7

electric__c,220 Volts in Laundry

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Marble;Wood

hoa_fee_includes__c,Common Areas,Elevator,Insurance on Structure,Security,Sewer,Trash

pba__hoafees__c,2200

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Union House HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

ffd_lastmodifieddate,2025-03-17T00:47:31.000+0000

pba__latitude_pb__c,37.7982705

pba__latitude_property__c,37.7982705

laundry_features__c,Inside Room;Stacked Only;Gas Hook-Up

listed_date__c,2025-03-05

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Andres

pba__listing_agent_lastname__c,Ardila

listing_agent_mls_id__c,815676

ffd_listingagentname,Andy Ardila

listing_agent_number__c,1073945

listing_co_agent_mls_id__c,810541

listing_co_agent_number__c,1046798

listing_co_office_mls_id__c,COMP

listing_co_office_name__c,Compass

listing_co_office_number__c,26293

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,2700000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.424284

mls_id__c,425015294

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

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

master_property__c,a0O1I000009s6IUUAY

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-03-06

open_house_end__c,2025-03-16T16:00:00.000+0000

open_house_start__c,2025-03-16T14:00:00.000+0000

original_price__c,4625000

overall_days_on_market__c,-82244

parking_access__c,Side by Side

parking_features__c,Attached,EV Charging,Garage Door Opener,Mechanical Lift,Underground Parking

parking_type__c,On Site - Assigned (Condo Only)

patio_and_porch_features__c,Roof 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,1668.73

pba__propertytype__c,Condominium

ListingId,a0EUd000004S0apMAC

roof__c,Composition

room_type__c,Laundry;Kitchen;Dining Room;Family 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 Suppression System;Fire Extinguisher;Secured Access;Carbon Mon Detector;Video System

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

size__c,1618

pba__state_pb__c,CA

stories__c,7

pba__street_pb__c,Union

subdist__c,Cow Hollow

ffd_name,1515 Union Street #PH4, San Francisco, CA, 94123

view__c,City;Panoramic;City Lights;San Francisco;Hills

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2020

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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