3014 Pierce Street, San Francisco, CA, 94123 - Property Description

_yoast_indexnow_last_ping,1701519223

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

dom__c,1

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-02T11:48:40.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,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

_yoast_indexnow_last_ping,1700568782

ffd_listing_title,1964 Union 1966 Street, San Francisco, CA, 94123

ffd_mls_id,423918754

ffd_salesforce_id,a0E8W00000dwtRfUAI

num_of_rooms__c,9

of_units__c,3

address2__c,1964 Union 1966 Street, San Francisco, CA, 94123

pba__address_pb__c,1964 Union 1966 Street, San Francisco, CA, 94123

agent_only_remarks__c,Please contact Morgan Thomas for all showings and questions 415-505-0226.

appliances__c,Dishwasher;Microwave;Free Standing Gas Oven;Free Standing Refrigerator

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,2

year_build_text__c,1924

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-10-27T20:51:39.000+0000

days_on_market__c,25

dom__c,25

ffd_description_pb,1964 Union St is located in the desirable Cow Hollow neighborhood. This mixed-used space is situated in a highly visible prime location, surrounded by prime real estate. The area is popular among locals and tourists and experiences heavy foot traffic. The area consists of popular retail stores, and amenities such as Equinox, Soul Cycle, retail stores such as Sephora, Lululemon, Vuori, and popular local restaurants such as Perrys on Union, Flores, and Wildseed. This space is the perfect opportunity to be in the heart of the action. Enjoy the convenience of being close to all the amenities the area has to offer.

district__c,SF District 7

external_listing__c,1

pba__floortype_pb__c,Simulated Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-11-21T11:48:25.000+0000

pba__latitude_pb__c,37.79786

pba__latitude_property__c,37.79786

laundry_features__c,In Each Unit

listed_date__c,2023-10-27

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Morgan

pba__listing_agent_lastname__c,Thomas

listing_agent_mls_id__c,981213

ffd_listingagentname,Morgan Thomas

listing_agent_number__c,166015004

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.431678

mls_id__c,423918754

parkingspaces__c,0

on_market_date__c,2023-10-27

original_price__c,3800000

overall_days_on_market__c,-81748

patio_and_porch_features__c,Uncovered Patio

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,1022.6

pba__propertytype__c,Triplex

ListingId,a0E8W00000dwtRfUAI

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

size__c,3716

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Union

subdist__c,Cow Hollow

ffd_name,1964 Union 1966 Street, San Francisco, CA, 94123

website_property_type__c,Triplex

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1924

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1700597550

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

ffd_mls_id,423917575

ffd_salesforce_id,a0E8W00000dvv6BUAQ

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

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

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

agent_only_remarks__c,4 story Victorian currently used as 3 story home for the upper unit. Feels like a single-family home. with luxury 850 sqft, garden unit fully remodeled currently rented at 4,230 a month for lower unit. 1 car parking. Not to be missed.

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,5

year_build_text__c,1906

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-10-20T10:48:35.000+0000

days_on_market__c,33

dom__c,33

ffd_description_pb,Remodeled 4 story Victorian, 12 feet ceilings, gourmet, garden, plus two decks, views of Alcatraz and Bay. Hardwood floors, fireplace, 1 car garage and much much more.

district__c,SF District 7

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Family Room

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

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

pba__latitude_pb__c,37.797949

pba__latitude_property__c,37.797949

listed_date__c,2023-10-19

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.438749

mls_id__c,423917575

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-10-19

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

overall_days_on_market__c,-81740

parking_access__c,Independent

parking_features__c,Attached,Covered,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,1445.31

pba__propertytype__c,Single Family Residence

ListingId,a0E8W00000dvv6BUAQ

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

size__c,3456

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,Pierce

subdist__c,Cow Hollow

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

website_property_type__c,Single Family Home

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