meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329332' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15719
[post_author] => 4
[post_date] => 2018-11-02 19:54:35
[post_date_gmt] => 2018-11-02 19:54:35
[post_content] => Russian sailors were once buried upon this hill. That's why. Ground zero for the San Francisco high-rise revolt that began in the 1960s. Not coincidentally, also home to The Summit, The Royal Towers, Green Hill Tower, the so-called crookedest street in SF (the real crookedest street is in Potrero Hill), and the authentic inspiration for Armistead Maupin's magical Barbary Lane.
[post_title] => Russian Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => russian-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-14 03:40:15
[post_modified_gmt] => 2022-12-14 11:40:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15719
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 1020 Union Street #5, San Francisco, CA, 94133
ffd_mls_id, 423731491
ffd_salesforce_id, a0E8W00000balmBUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 1020 Union Street #5, San Francisco, CA, 94133
pba__address_pb__c, 1020 Union Street #5, San Francisco, CA, 94133
agent_only_remarks__c, Escrow opened with Kevin Thompson First American Title. HOA dues listed by association as $2005.41 + $145.45 monthly HOA dues cover on site caretaker, heat, water, trash, operating and reserve expenses for the building including building insurance, common area maintenance, cleaning and utilities and property management.
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range;Gas Plumbed
bath_features__c, Shower Stall(s);Jack & Jill
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1921
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-04-06T10:49:04.000+0000
days_on_market__c, 52
dom__c, 52
ffd_description_pb, Residence 5 at Union Terrace offers a unique alternative to the traditional single-family home. Imagine living in a luxurious four-level townhome with no neighbors above or below you and your own private garage. Designed by renown T. Patterson Ross in 1921, Ross and his wife moved into the 29 resident complex upon its completion, which speaks to the quality of the building and the attention to detail that went into the original design. As the largest and only continuous 4 bedroom home in the complex, Residence 5 stands out not just for its size but also the breathtaking views. The top floor entertainment sunroom is a truly special space with a walkout deck that overlooks the world-famous garden and San Francisco Bay. Remodeled thoughtfully over a period of years, the finished home is a prime example of the harmony between classic and contemporary, incorporating both period detail of the original design with modern-day amenities. Easy access to North Beach and San Francisco's many attractions, this home is the perfect place to make memories that will last a lifetime. Come and experience the best of both worlds the classic and the contemporary at 1020 Union Residence 5.
district__c, SF District 8
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Heat,Insurance on Structure,Maintenance Grounds,Management,Trash
pba__hoafees__c, 2151
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Union Terrace Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant;Steam
interior_features__c, Wet Bar
ffd_lastmodifieddate, 2023-05-27T10:48:09.000+0000
pba__latitude_pb__c, 37.800034
pba__latitude_property__c, 37.800034
laundry_features__c, In Garage;Washer/Dryer Stacked Included;Cabinets
listed_date__c, 2023-04-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Meredith
pba__listing_agent_lastname__c, Martin
listing_agent_mls_id__c, 800346
ffd_listingagentname, Meredith Martin
listing_agent_number__c, 800346
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 2800000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=QCYd9k3T2J8&mls=1
pba__longitude_pb__c, -122.416276
lower_level__c, Full Bath(s),Garage
mls_id__c, 423731491
main_level__c, Living Room
master_bathroom_features__c, Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-04-05
open_house_end__c, 2023-05-28T16:00:00.000+0000
open_house_start__c, 2023-05-28T14:00:00.000+0000
original_price__c, 2800000
overall_days_on_market__c, -81543
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Size Limited
parking_type__c, On Site - Mapped (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, 1120
pba__propertytype__c, Stock Cooperative
ListingId, a0E8W00000balmBUAQ
room_type__c, Bonus Room;Sun Room;Family Room;Primary Bathroom;Primary Bedroom
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, 2500
size__c, 2500
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Union
subdist__c, Russian Hill
ffd_name, 1020 Union Street #5, San Francisco, CA, 94133
view__c, Bay
website_property_type__c, Stock Cooperative
pba__yearbuilt_pb__c, 1921
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530599822-1.jpg
