meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338654' 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] => 2023-06-23 07:14:44
[post_modified_gmt] => 2023-06-23 14:14:44
[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, 998 Union Street, San Francisco, CA, 94133
ffd_mls_id, 423744671
ffd_salesforce_id, a0E8W00000awmK7UAI
num_of_fireplaces__c, 1
num_of_rooms__c, 3
of_units__c, 6
address2__c, 998 Union Street, San Francisco, CA, 94133
pba__address_pb__c, 998 Union Street, San Francisco, CA, 94133
agent_only_remarks__c, Easy to show, please contact: Ilonka - 415.867.7373 or Heidi - 415.867.7948 Parking at WePark is $400.00 per month or $350 when paying 2 months at a time. Next-door neighbors' contact info for parking availability will be provided after ratified offer. Disclosures are available on request.
appliances__c, Dishwasher;Microwave;Free Standing Refrigerator;Built-In Electric Range;Other
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1907
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Heidi W Howell
pba__contingentdate__c, 2023-08-14
ffd_createddate, 2023-05-29T10:49:27.000+0000
days_on_market__c, 111
dom__c, 86
ffd_description_pb, HUGE PRICE REDUCTION!!!! Come home to this iconic Russian Hill low-rise charmer, relax, and enjoy the breathtaking high-rise view apartment 998 Union Street has to offer! Discover a seamless blend of vintage elements with wood burning fireplace and modern convenience like fiber optic WiFi, in this generous and light-filled two bedroom, and one bath condominium. Newer carpet in bedrooms and hallway with original hardwood underneath. Presenting an open kitchen, dining, and living area floor plan. Simply an entertainer's dream! This quintessential San Francisco neighborhood has an amazing 93 walk score and the condominium's location is just a three blocks walk to North Beach, two blocks to Mason St Cable Car, and a short distance to more Restaurants & Shopping. Parking can be leased one and a half blocks away on Powell/Mason at We Park or when available from the next-door neighbor. Public transportation runs on Union Street. Very low HOA dues and an ample, free, and clean common laundry room downstairs.
district__c, SF District 8
driveway_sidewalks__c, Paved Sidewalk
electric__c, 220 Volts
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
fireplace_features__c, Family Room
pba__floortype_pb__c, Carpet;Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Trash
pba__hoafees__c, 402
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Self Managed HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard;Other;Fireplace(s);Natural Gas;See Remarks
interior_features__c, Wet Bar
ffd_lastmodifieddate, 2023-09-17T10:46:35.000+0000
pba__latitude_pb__c, 37.799838
pba__latitude_property__c, 37.799838
laundry_features__c, In Basement
listed_date__c, 2023-05-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ilona
pba__listing_agent_lastname__c, Edwards-Marsovszk
listing_agent_mls_id__c, 804012
ffd_listingagentname, Ilonka H Edwards-Marsovszk
listing_agent_number__c, 166013409
listing_co_agent_mls_id__c, 805722
listing_co_agent_number__c, 166015747
listing_co_office_mls_id__c, NORTH-PT
listing_co_office_name__c, North Point Real Estate
listing_co_office_number__c, 27699
listing_office_mls_id__c, NORTH-PT
listing_office_name__c, North Point Real Estate
listing_office_number__c, 27699
pba__listingprice_pb__c, 1299000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.415615
mls_id__c, 423744671
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Low-Flow Shower(s);Window
master_property__c, a0O8W00000JaQdyUAF
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-05-29
original_price__c, 1650000
overall_days_on_market__c, -81597
pba__pendingdate__c, 2023-09-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-09-16T17:34:27.000+0000
price_per_square_foot__c, 1151.57
pba__propertytype__c, Condominium
ListingId, a0E8W00000awmK7UAI
road_surface_type__c, Asphalt,Paved
room_type__c, Storage;Kitchen;Great Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
sale_date__c, 2023-09-15
sale_price__c, 1360000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 817117
selling_agent_number__c, 1076016
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Avenue 8 Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 1181
size__c, 1181
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Union
subdist__c, Russian Hill
ffd_name, 998 Union Street, San Francisco, CA, 94133
view__c, Marina;City;Panoramic;Bay;Water;Hills;Mt Tamalpais
website_property_type__c, Condominium
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1907
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530624694-1.jpg