ffd_listing_title,1515 Union Street #6B, San Francisco, CA, 94123
ffd_mls_id,423740954
ffd_salesforce_id,a0E8W00000cJ0m9UAC
num_of_fireplaces__c,0
num_of_rooms__c,5
of_units__c,41
address2__c,1515 Union Street #6B, San Francisco, CA, 94123
pba__address_pb__c,1515 Union Street #6B, San Francisco, CA, 94123
agent_only_remarks__c,Showings are by appointment only. Please contact listing agent: Andy Ardila at 415-608-1003 or David Costello at 415-828-8122. If you prefer, email: [email protected] or visit www.unionhousesf.com
appliances__c,Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Wine Refrigerator;Ice Maker;Self/Cont Clean Oven;Built-In Refrigerator
architectural_style__c,Contemporary;Modern/High Tech;Traditional
bath_features__c,Shower Stall(s);Tub;Marble;Low-Flow Toilet(s);Dual Flush Toilet
pba__fullbathrooms_pb__c,2
pba__bedrooms_pb__c,3
year_build_text__c,2020
pba__city_pb__c,San Francisco
listing_co_agent_name__c,Andy Ardila
pba__contingentdate__c,1800-01-01
cooling__c,Central
ffd_createddate,2023-06-02T00:49:55.000+0000
days_on_market__c,1
dom__c,1
ffd_description_pb,Newly constructed in 2020, Union House is located in one of San Francisco's most coveted neighbors: Pacific Heights. This upscale 7-story building combines contemporary styling, generously proportioned floor plans with high ceilings, and extraordinary finishes of the highest quality. Drawing inspiration from an earlier era, Handel Architects combines grand architecture with sophisticated interiors. Each expansive residence at Union House marries classic details, modern styling, and finishes of the finest quality, resulting in a collection of rare and generously proportioned residences. The 41 distinctive and extraordinary homes are offered in 1-bedroom, 2-bedroom, and 3-bedroom floor plans, multi-level Townhouses, and Penthouses with private roof terraces. Every home features oversized picture frame windows, high ceilings, and European wide-plank oak flooring throughout, creating environments that are meticulously refined and equally timeless.
district__c,SF District 7
driveway_sidewalks__c,Paved Driveway,Paved Sidewalk
entry_level__c,0
external_listing__c,1
pba__floortype_pb__c,Marble;Wood
hoa_fee_includes__c,Door Person,Gas,Maintenance Grounds,Management,Trash,Water
pba__hoafees__c,1701
pba__hoafrequency_pb__c,Monthly
hoa_name__c,Union House Owners Association
hoa__c,Yes
pba__halfbathrooms_pb__c,1
pba__heatingtype_pb__c,Central
ffd_lastmodifieddate,2023-06-02T10:50:03.000+0000
pba__latitude_pb__c,37.798185
pba__latitude_property__c,37.798185
laundry_features__c,Inside Room;Hookups Only
listed_date__c,2023-06-01
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,David
pba__listing_agent_lastname__c,Costello
listing_agent_mls_id__c,810541
ffd_listingagentname,David S Costello
listing_agent_number__c,1046798
listing_co_agent_mls_id__c,815676
listing_co_agent_number__c,1073945
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,4995000
pba__listingtype__c,Sale
pba__longitude_pb__c,-122.424301
mls_id__c,423740954
master_bathroom_features__c,Walk-In Closet
master_property__c,a0O1I000009s6IUUAY
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,1
on_market_date__c,2023-06-01
open_house_end__c,2023-06-04T16:00:00.000+0000
open_house_start__c,2023-06-04T13:00:00.000+0000
original_price__c,4995000
overall_days_on_market__c,-81600
parking_access__c,Side by Side
parking_features__c,Assigned,Enclosed,Garage Door Opener,Interior Access,Mechanical Lift,Side-by-Side,Size Limited
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,2574.74
pba__propertytype__c,Condominium
ListingId,a0E8W00000cJ0m9UAC
room_type__c,Storage;Office;Laundry;Kitchen;Living Room;Baths Other;Dining Room;Possible Guest;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,1940
size__c,1940
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Union
subdist__c,Cow Hollow
ffd_name,1515 Union Street #6B, San Francisco, CA, 94123
view__c,City Lights;Bay;Water;San Francisco;Golden Gate Bridge
website_property_type__c,Condominium
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/530627189-1.jpg