2912 Steiner Street #6, San Francisco, CA, 94123 - Property Description

_yoast_indexnow_last_ping,1701490784

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

ffd_mls_id,423924683

ffd_salesforce_id,a0EUd000000KNlIMAW

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,41

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

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

agent_only_remarks__c,By appointment only. Please contact listing agents.

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,2023-12-01T11:48:13.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Welcome to grand Penthouse 4 at Union House - part of an ultra-luxury 41 unit condo complex hat was newly constructed in 2020. Located on the prestigious PH floor of the building, Union House is perfectly situated at the intersections of San Francisco's most coveted neighborhoods: Pacific Heights, Cow Hollow, The Marina as well as Russian Hill. Designed by renowned Handel Architects,PH4 offers an open island kitchen/family room floor plan, and includes 2 spacious bedrooms with 2 oversized bathrooms. The principal bedroom suite includes a generous walk-in closet. The master bath is beautifully accented by floor to ceiling Italian Carrera Marble, custom white lacquer vanities w/double sinks and Waterworks polished nickel fixtures, and a free standing Victoria+ Albert soaking tub. From the moment you arrive, you are greeted by a soaring, double-height lobby with exquisite finishes, complemented by an intimate, seated parlor w/a custom marble fireplace. Union House is a fully secure building, w/a 7-day a week doorman. The high speed elevator can only be access by each unit owner's customized key fob. Building amenities include a rooftop Sky Lounge providing direct views of the Golden Gate Bridge, Palace of Fine Arts & SF Bay. A storage locker and 1 car parking are included.

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

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,2023-12-02T03:47:23.000+0000

pba__latitude_pb__c,37.798278

pba__latitude_property__c,37.798278

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

listed_date__c,2023-11-30

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

pba__listingtype__c,Sale

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

pba__longitude_pb__c,-122.424266

mls_id__c,423924683

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,2023-12-01

open_house_end__c,2023-12-03T16:00:00.000+0000

open_house_start__c,2023-12-03T14:00:00.000+0000

original_price__c,3195000

overall_days_on_market__c,-81783

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

pba__propertytype__c,Condominium

ListingId,a0EUd000000KNlIMAW

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

size__c,2015

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

_yoast_indexnow_last_ping,1700597570

ffd_listing_title,3014 Pierce Street, San Francisco, CA, 94123

ffd_mls_id,423922003

ffd_salesforce_id,a0EUd0000003eaRMAQ

num_of_fireplaces__c,1

num_of_rooms__c,8

of_units__c,2

address2__c,3014 Pierce Street, San Francisco, CA, 94123

pba__address_pb__c,3014 Pierce Street, San Francisco, CA, 94123

agent_only_remarks__c,Victorian 3 story upper unit, candidate for two-unit fast track condo bypass. Entire building is available for purchase at $4,995,000 / refer to MLS #423917575.

appliances__c,Gas Water Heater;Gas Cook Top

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1906

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-11-09T18:47:35.000+0000

days_on_market__c,12

dom__c,12

ffd_description_pb,Bright and sunny 3 story Victorian upper unit, 12ft ceilings, fireplace, two decks, Bay Views, garage and much, much more!

district__c,SF District 7

driveway_sidewalks__c,Paved Driveway

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fireplace_features__c,Gas Log

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

interior_features__c,Open Beam Ceiling

ffd_lastmodifieddate,2023-11-21T19:47:04.000+0000

pba__latitude_pb__c,37.79795

pba__latitude_property__c,37.79795

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2023-11-09

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Ryan

pba__listing_agent_lastname__c,McCauley

listing_agent_mls_id__c,808838

ffd_listingagentname,Ryan A McCauley

listing_agent_number__c,1037841

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,MCCL

listing_office_name__c,McCauley, Ryan Allen

listing_office_number__c,28879

pba__listingprice_pb__c,3799000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.438751

mls_id__c,423922003

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-11-09

open_house_end__c,2023-11-21T12:00:00.000+0000

open_house_start__c,2023-11-21T10:00:00.000+0000

original_price__c,3799000

overall_days_on_market__c,-81761

parking_access__c,Independent

parking_features__c,Garage Door Opener

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

pba__propertytype__c,Tenancy In Common

ListingId,a0EUd0000003eaRMAQ

road_surface_type__c,Paved

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

size__c,2550

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Pierce

subdist__c,Cow Hollow

ffd_name,3014 Pierce Street, San Francisco, CA, 94123

website_property_type__c,Tenancy In Common

pba__yearbuilt_pb__c,1906

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

wpil_links_inbound_internal_count,0

wpil_links_inbound_internal_count_data,Array

wpil_links_outbound_internal_count,0

wpil_links_outbound_internal_count_data,Array

wpil_links_outbound_external_count,0

wpil_links_outbound_external_count_data,Array

wpil_sync_report2_time,2023-11-10T14:23:53+00:00

wpil_sync_report3,1

_wp_old_slug,3014-pierce-3014-square-san-francisco-ca-94123

_yoast_indexnow_last_ping,1701137715

ffd_listing_title,2821 Union 23 Street, San Francisco, CA, 94123

ffd_mls_id,423920095

ffd_salesforce_id,a0E8W00000dxTcnUAE

num_of_rooms__c,8

of_units__c,2

address2__c,2821 Union 23 Street, San Francisco, CA, 94123

pba__address_pb__c,2821 Union 23 Street, San Francisco, CA, 94123

agent_only_remarks__c,. No Showing Time Appointments please. Please call, email or text Nina Hatvany directly. Property Website: https://www.2821union.com/unbranded

appliances__c,Dishwasher;Gas Water Heater;Built-In Gas Range;Built-In Refrigerator;See Remarks;Varies By Unit

architectural_style__c,Victorian;Traditional

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,5

year_build_text__c,1904

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Paul Hatvany Kitchen

pba__contingentdate__c,1800-01-01

cooling__c,None,See Remarks

ffd_createddate,2023-11-02T18:50:06.000+0000

days_on_market__c,25

dom__c,25

ffd_description_pb,Vacant 2-unit building in an idyllic Cow Hollow location, just steps from the Presidio! Wonderful upper owner's unit with 3 generous bedrooms and 1 bathroom, and charming period detail throughout. At the back of the home is a sun-filled living/dining room and kitchen, with a fireplace and French doors that open onto balconies overlooking the garden below. The updated kitchen is equipped with deluxe appliances and built-ins. The lower unit offers 2 bedrooms and a tile bathroom with shower over tub. A bright living room has direct access to the lovely south-facing garden, surrounded by mature trees and landscaping. Adjacent to the living room is a kitchen with stainless appliances, an L-shaped countertop, and built-ins around a dining area in front of the windows. The lowest level houses shared laundry, a bonus office with full bathroom, and a 2-car tandem garage with additional storage areas. Some expansion potential and upside for an owner/occupant, investor, or family compound! Miles of trails and attractions a block away in the Presidio, with Union St shops & dining nearby.

district__c,SF District 7

electric__c,Photovoltaics Seller Owned

exterior_features__c,Fenced Yard;Yard Space

external_listing__c,1

pba__floortype_pb__c,Carpet;Tile;Wood;See Remarks;Varies by Unit

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas;Individual;See Remarks

ffd_lastmodifieddate,2023-11-28T01:48:58.000+0000

pba__latitude_pb__c,37.79558

pba__latitude_property__c,37.79558

laundry_features__c,In Common Area;Washer/Dryer Owned

listed_date__c,2023-10-31

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

listing_co_agent_number__c,1045825

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

pba__listingtype__c,Sale

pba__listing_website__c,https://teamhatvany.com/

pba__longitude_pb__c,-122.445825

mls_id__c,423920095

parkingspaces__c,2

on_market_date__c,2023-11-02

open_house_end__c,2023-11-28T12:00:00.000+0000

open_house_start__c,2023-11-28T10:00:00.000+0000

original_price__c,2750000

overall_days_on_market__c,-81754

parking_features__c,Garage,Tandem Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,1145.83

pba__propertytype__c,Duplex

ListingId,a0E8W00000dxTcnUAE

roof__c,Tar/Gravel

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Fire Alarm;Carbon Mon Detector;Double Strapped Water Heater;See Remarks

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

size__c,2400

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Union

subdist__c,Cow Hollow

ffd_name,2821 Union 23 Street, San Francisco, CA, 94123

view__c,Varies by Unit

website_property_type__c,Duplex

window_features__c,Varies by Unit

pba__yearbuilt_pb__c,1904

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1701432849

ffd_listing_title,2912 Steiner Street #1, San Francisco, CA, 94123

ffd_mls_id,423915830

ffd_salesforce_id,a0E8W00000dxHe3UAE

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,11

address2__c,2912 Steiner Street #1, San Francisco, CA, 94123

pba__address_pb__c,2912 Steiner Street #1, San Francisco, CA, 94123

agent_only_remarks__c,3% to Buyer's Agent! Property site here: www.2912Steiner.com - Address on tax records also listed as 2298 Green St #2298. Fractional TIC financing available. For more information or to schedule a private tour, please contact Kevin Delmore at [email protected] or 415.203.3357

appliances__c,Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Built-In Refrigerator

architectural_style__c,Victorian;Traditional

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1909

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-11-01T00:47:49.000+0000

days_on_market__c,31

dom__c,31

ffd_description_pb,Discover the allure of Cow Hollow living in this enchanting 2-bedroom residence, ideally situated just a block from the best of Union Street. Enter a piece of San Francisco history with this 1909 gem, offering a private entrance off the central courtyard and a host of charming features including a shared, panoramic rooftop deck. Adorned with exquisite inlaid hardwood floors, a cozy fireplace, and custom built-ins, this apartment exudes timeless elegance. Two generously sized bedrooms ensure comfortable living, and you'll find yourself at home in a well-established TIC community comprising 11 homes. An outstanding location: Cow Hollow's Union Street is your backyard, offering an array of boutiques, cafes, and cultural experiences, as is the Marina waterfront and myriad trails and activities in the Presidio. This is your chance to reside in an incredibly special home, where history and modern amenities blend seamlessly, in one of San Francisco's most coveted neighborhoods. Welcome home to Cow Hollow's finest!

district__c,SF District 7

driveway_sidewalks__c,Paved Sidewalk

entry_level__c,0

exterior_features__c,Uncovered Courtyard

external_listing__c,1

fireplace_features__c,Living Room

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Homeowners Insurance,Maintenance Exterior,Maintenance Grounds,Trash,Water

pba__hoafees__c,569

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Green Steiner TIC

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-12-01T11:48:00.000+0000

pba__latitude_pb__c,37.796215

pba__latitude_property__c,37.796215

listed_date__c,2023-09-05

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Gregg

pba__listing_agent_lastname__c,Lynn

listing_agent_mls_id__c,804728

ffd_listingagentname,Gregg Lynn

listing_agent_number__c,166014390

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

pba__listingtype__c,Sale

pba__listing_website__c,https://youtu.be/FpgQjRuW7PQ

pba__longitude_pb__c,-122.436827

mls_id__c,423915830

main_level__c,Bedroom(s);Kitchen;Living Room;Street Entrance;Primary Bedroom

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2023-10-31

open_house_end__c,2023-12-03T15:00:00.000+0000

open_house_start__c,2023-12-03T14:00:00.000+0000

original_price__c,895000

overall_days_on_market__c,-81752

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,Tenancy In Common

ListingId,a0E8W00000dxHe3UAE

room_type__c,Kitchen;Living Room;Possible Guest;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

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

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Steiner

subdist__c,Cow Hollow

ffd_name,2912 Steiner Street #1, San Francisco, CA, 94123

website_property_type__c,Tenancy In Common

pba__yearbuilt_pb__c,1909

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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